Advertisement
Guest User

Untitled

a guest
May 8th, 2016
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.86 KB | None | 0 0
  1. Caused by: org.hibernate.exception.JDBCConnectionException: Cannot open connection
  2.  
  3. Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/shopping
  4. at java.sql.DriverManager.getConnection(DriverManager.java:689)
  5.  
  6. <persistence xmlns="http://java.sun.com/xml/ns/persistence"
  7. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  8. xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
  9. version="2.0">
  10. <persistence-unit name="ShoppingDB" transaction-type="RESOURCE_LOCAL">
  11. <provider>org.hibernate.ejb.HibernatePersistence</provider>
  12. <class>com.speed.model.Category</class>
  13. <properties>
  14. <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLInnoDBDialect"/>
  15. <property name="javax.persistence.jdbc.url"
  16. value="jdbc:mysql://localhost:3306/shopping"/>
  17. <property name="javax.persistence.jdbc.user" value="xxx"/>
  18. <property name="javax.persistence.jdbc.password" value="xxx"/>
  19. <property name="hibernate.hbm2ddl.auto" value="create"/>
  20. <property name="hibernate.show_sql" value="true"/>
  21. <property name="hibernate.format_sql" value="true"/>
  22. </properties>
  23. </persistence-unit>
  24.  
  25. public class Test {
  26.  
  27.  
  28. public static void main(String[] args) {
  29.  
  30. EntityManagerFactory emf = Persistence.createEntityManagerFactory("ShoppingDB");
  31. EntityManager em = emf.createEntityManager();
  32.  
  33. Category category = new Category();
  34. category.setCatId(1);
  35. category.setCatName("Test");
  36. category.setCatParent(11);
  37. category.setCatPosition(111);
  38.  
  39. em.getTransaction().begin();
  40. em.persist(category);
  41. em.getTransaction().commit();
  42.  
  43. category = em.find(Category.class, 1);
  44. System.out.println(category);
  45.  
  46.  
  47. }
  48. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement