Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connection
- Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/shopping
- at java.sql.DriverManager.getConnection(DriverManager.java:689)
- <persistence xmlns="http://java.sun.com/xml/ns/persistence"
- xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
- xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
- version="2.0">
- <persistence-unit name="ShoppingDB" transaction-type="RESOURCE_LOCAL">
- <provider>org.hibernate.ejb.HibernatePersistence</provider>
- <class>com.speed.model.Category</class>
- <properties>
- <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLInnoDBDialect"/>
- <property name="javax.persistence.jdbc.url"
- value="jdbc:mysql://localhost:3306/shopping"/>
- <property name="javax.persistence.jdbc.user" value="xxx"/>
- <property name="javax.persistence.jdbc.password" value="xxx"/>
- <property name="hibernate.hbm2ddl.auto" value="create"/>
- <property name="hibernate.show_sql" value="true"/>
- <property name="hibernate.format_sql" value="true"/>
- </properties>
- </persistence-unit>
- public class Test {
- public static void main(String[] args) {
- EntityManagerFactory emf = Persistence.createEntityManagerFactory("ShoppingDB");
- EntityManager em = emf.createEntityManager();
- Category category = new Category();
- category.setCatId(1);
- category.setCatName("Test");
- category.setCatParent(11);
- category.setCatPosition(111);
- em.getTransaction().begin();
- em.persist(category);
- em.getTransaction().commit();
- category = em.find(Category.class, 1);
- System.out.println(category);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement