8000 hibernate JPA communicating with mysql successfully, implemented INSE… · anirtek/java-persistence-api@ef2e0a3 · GitHub
[go: up one dir, main page]
Skip to content

Commit ef2e0a3

Browse files
author
anirtek
committed
hibernate JPA communicating with mysql successfully, implemented INSERT INTO query as well
1 parent c6ed529 commit ef2e0a3

File tree

12 files changed

+96
-76
lines changed

12 files changed

+96
-76
lines changed

‎.gitignore

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
/target/

‎.project

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -16,12 +16,12 @@
1616
</arguments>
1717
</buildCommand>
1818
<buildCommand>
19-
<name>org.eclipse.m2e.core.maven2Builder</name>
19+
<name>org.eclipse.wst.validation.validationbuilder</name>
2020
<arguments>
2121
</arguments>
2222
</buildCommand>
2323
<buildCommand>
24-
<name>org.eclipse.wst.validation.validationbuilder</name>
24+
<name>org.eclipse.m2e.core.maven2Builder</name>
2525
<arguments>
2626
</arguments>
2727
</buildCommand>

‎pom.xml

Lines changed: 21 additions & 15 deletions
Original file line numberDiff line numberDiff line change
@@ -16,20 +16,17 @@
1616
</properties>
1717

1818
<build>
19-
<pluginManagement>
20-
<plugins>
21-
<plugin>
22-
<groupId>org.apache.maven.plugins</groupId>
23-
<artifactId>maven-compiler-plugin</artifactId>
24-
<version>3.7.0</version>
25-
<configuration>
26-
<!-- put your configurations here -->
27-
<source>1.8</source>
28-
<target>1.8</target>
29-
</configuration>
30-
</plugin>
31-
</plugins>
32-
</pluginManagement>
19+
<plugins>
20+
<plugin>
21+
<groupId>org.apache.maven.plugins</groupId>
22+
<artifactId>maven-compiler-plugin</artifactId>
23+
<version>3.7.0</version>
24+
<configuration>
25+
<source>1.8</source>
26+
<target>1.8</target>
27+
</configuration>
28+
</plugin>
29+
</plugins>
3330
</build>
3431

3532
<dependencies>
@@ -43,6 +40,15 @@
4340
<artifactId>hibernate-core</artifactId>
4441
<version>5.3.3.Final</version>
4542
</dependency>
46-
43+
<dependency>
44+
<groupId>org.hibernate</groupId>
45+
<artifactId>hibernate-entitymanager</artifactId>
46+
<version>5.3.3.Final</version>
47+
</dependency>
48+
<dependency>
49+
<groupId>mysql</groupId>
50+
<artifactId>mysql-connector-java</artifactId>
51+
<version>8.0.11</version>
52+
</dependency>
4753
</dependencies>
4854
</project>

‎src/main/java/io/anirtek/persistence/PersistenceTester.java

Lines changed: 7 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -13,25 +13,20 @@ public static void main(String[] args) {
1313

1414
EntityManager em = emf.createEntityManager();
1515

16-
/**
17-
* Create one object
18-
*/
16+
//INSERT INTO action
1917
Employee emp = new Employee();
20-
emp.setFirstName("aniruddha");
21-
emp.setLastName("tekade");
22-
emp.setEmail("atekade1@binghamton.edu");
23-
emp.setCity("New York");
18+
emp.setFirstName("Mayank");
19+
emp.setLastName("Jain");
20+
emp.setEmail("mjain8@binghamton.edu");
21+
emp.setCity("San Francisco");
2422

25-
/**
26-
* Now let's write this object into the database of MySQL
27-
*/
2823
em.getTransaction().begin();
2924
em.persist(emp);
3025
em.getTransaction().commit();
26+
3127

3228
em.close();
3329

34-
emf.close();
30+
// emf.close();
3531
}
36-
3732
}

‎src/main/java/io/anirtek/persistence/entity/Employee.java

Lines changed: 12 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -8,18 +8,22 @@
88

99
@Entity
1010
public class Employee {
11+
1112
@Id
1213
private String id;
14+
1315
private String firstName;
1416
private String lastName;
15-
16-
@Column(columnDefinition="VARCHAR(100)", unique=true)
17+
18+
@Column(columnDefinition = "VARCHAR(100)", unique = true)
1719
private String email;
20+
1821
private String city;
1922

2023
public Employee() {
2124
this.id = UUID.randomUUID().toString();
2225
}
26+
2327
public String getId() {
2428
return id;
2529
}
@@ -56,4 +60,10 @@ public void setCity(String city) {
5660
this.city = city;
5761
}
5862

63+
@Override
64+
public String toString() {
65+
return "Employee [id=" + id + ", firstName=" + firstName + ", lastName=" + lastName + ", email=" + email
66+
+ ", city=" + city + "]";
67+
}
68+
5969
}

‎src/main/resources/META-INF/persistence.xml

Lines changed: 12 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -1,20 +1,21 @@
1-
1+
<?xml version="1.0" encoding="UTF-8"?>
22
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
33
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
44
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
55
version="2.0">
6-
<persistence-unit name="anirtek-jpa"
7-
transaction-type="JTA">
6+
<persistence-unit name="anirtek-jpa">
87
<provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
98
<properties>
10-
<property name="javax.persistence.jdbc.driver" value="org.hsqld.jdbcDriver"/>
11-
<property name="javax.persistence.jdbc.url" value="root"/>
12-
<property name="javax.persistence.jdbc.user" value="root"/>
13-
<property name="javax.persistence.jdbc.password" value="root"/>
14-
15-
<property name="hibernate.dialect" value="org.hibernate.dialect.HSQLDialect" />
16-
<property name="hibernate.hbm2ddl.auto" value="create-drop" />
17-
<property name = "hibernate.show_sql" value = "true" />
9+
<property name="javax.persistence.jdbc.driver" value="com.mysql.cj.jdbc.Driver" />
10+
<property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/shiva-db?serverTimezone=UTC" />
11+
<property name="javax.persistence.jdbc.user" value="root" />
12+
<property name="javax.persistence.jdbc.password" value=":P" />
13+
14+
15+
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect" />
16+
<property name="hibernate.hbm2ddl.auto" value="validate" />
17+
<property name="hibernate.show_sql" value="true"/>
18+
<property name="hibernate.format_sql" value="true"/>
1819
</properties>
1920
</persistence-unit>
2021
</persistence>

‎target/classes/META-INF/MANIFEST.MF

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
1-
Manifest-Version: 1.0
2-
Built-By: atekade1
3-
Build-Jdk: 1.8.0_172
4-
Created-By: Maven Integration for Eclipse
5-
1+
Manifest-Version: 1.0
2+
Built-By: anirtek
3+
Build-Jdk: 1.8.0_171
4+
Created-By: Maven Integration for Eclipse
5+

‎target/classes/META-INF/maven/io.anirtek/persistence/pom.properties

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
#Generated by Maven Integration for Eclipse
2-
#Sat Jul 21 16:04:05 EDT 2018
2+
#Tue Jul 24 14:58:21 EDT 2018
33
version=0.0.1
44
groupId=io.anirtek
5-
m2e.projectName=persistence
6-
m2e.projectLocation=C\:\\Users\\atekade1\\eclipse-workspace\\persistence
5+
m2e.projectName=java-persistence-api
6+
m2e.projectLocation=/home/anirtek/eclipse-workspace/java-persistence-api
77
artifactId=persistence

‎target/classes/META-INF/maven/io.anirtek/persistence/pom.xml

Lines changed: 21 additions & 15 deletions
Original file line numberDiff line numberDiff line change
@@ -16,20 +16,17 @@
1616
</properties>
1717

1818
<build>
19-
<pluginManagement>
20-
<plugins>
21-
<plugin>
22-
<groupId>org.apache.maven.plugins</groupId>
23-
<artifactId>maven-compiler-plugin</artifactId>
24-
<version>3.7.0</version>
25-
<configuration>
26-
<!-- put your configurations here -->
27-
<source>1.8</source>
28-
<target>1.8</target>
29-
</configuration>
30-
</plugin>
31-
</plugins>
32-
</pluginManagement>
19+
<plugins>
20+
<plugin>
21+
<groupId>org.apache.maven.plugins</groupId>
22+
<artifactId>maven-compiler-plugin</artifactId>
23+
<version>3.7.0</version>
24+
<configuration>
25+
<source>1.8</source>
26+
<target>1.8</target>
27+
</configuration>
28+
</plugin>
29+
</plugins>
3330
</build>
3431

3532
<dependencies>
@@ -43,6 +40,15 @@
4340
<artifactId>hibernate-core</artifactId>
4441
<version>5.3.3.Final</version>
4542
</dependency>
46-
43+
<dependency>
44+
<groupId>org.hibernate</groupId>
45+
<artifactId>hibernate-entitymanager</artifactId>
46+
<version>5.3.3.Final</version>
47+
</dependency>
48+
<dependency>
49+
<groupId>mysql</groupId>
50+
<artifactId>mysql-connector-java</artifactId>
51+
<version>8.0.11</version>
52+
</dependency>
4753
</dependencies>
4854
</project>

‎target/classes/META-INF/persistence.xml

Lines changed: 12 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -1,20 +1,21 @@
1-
1+
<?xml version="1.0" encoding="UTF-8"?>
22
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
33
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
44
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
55
version="2.0">
6-
<persistence-unit name="anirtek-jpa"
7-
transaction-type="JTA">
6+
<persistence-unit name="anirtek-jpa">
87
<provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
98
<properties>
10-
<property name="javax.persistence.jdbc.driver" value="org.hsqld.jdbcDriver"/>
11-
<property name="javax.persistence.jdbc.url" value="root"/>
12-
<property name="javax.persistence.jdbc.user" value="root"/>
13-
<property name="javax.persistence.jdbc.password" value="root"/>
14-
15-
<property name="hibernate.dialect" value="org.hibernate.dialect.HSQLDialect" />
16-
<property name="hibernate.hbm2ddl.auto" value="create-drop" />
17-
<property name = "hibernate.show_sql" value = "true" />
9+
<property name="javax.persistence.jdbc.driver" value="com.mysql.cj.jdbc.Driver" />
10+
<property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/shiva-db?serverTimezone=UTC" />
11+
<property name="javax.persistence.jdbc.user" value="root" />
12+
<property name="javax.persistence.jdbc.password" value=":P" />
13+
14+
15+
<property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect" />
16+
<property name="hibernate.hbm2ddl.auto" value="validate" />
17+
<property name="hibernate.show_sql" value="true"/>
18+
<property name="hibernate.format_sql" value="true"/>
1819
</properties>
1920
</persistence-unit>
2021
</persistence>

0 commit comments

Comments
 (0)
0