Guest User

Untitled

a guest
Jan 20th, 2019
212
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.13 KB | None | 0 0
  1. package sally;
  2.  
  3. import org.hibernate.Session;
  4. import org.hibernate.Transaction;
  5.  
  6. public class MainClass {
  7.  
  8. public static void main(String args[]){
  9.  
  10. try{
  11. Session session=HibernateUtil.getSession();
  12. Transaction tx=session.beginTransaction();
  13. Employee ee=new Employee("abx","asd",2000);
  14. session.save(ee);
  15. tx.commit();
  16.  
  17.  
  18. }catch(Exception e){
  19. e.printStackTrace();
  20. }
  21. }
  22. }
  23.  
  24. package sally;
  25.  
  26. public class Employee {
  27. private int id;
  28. private String firstName;
  29. private String lastName;
  30. private int salary;
  31.  
  32. public Employee() {}
  33. public Employee(String fname, String lname, int salary) {
  34. this.firstName = fname;
  35. this.lastName = lname;
  36. this.salary = salary;
  37. }
  38. public int getId() {
  39. return id;
  40. }
  41. public void setId( int id ) {
  42. this.id = id;
  43. }
  44. public String getFirstName() {
  45. return firstName;
  46. }
  47. public void setFirstName( String first_name ) {
  48. this.firstName = first_name;
  49. }
  50. public String getLastName() {
  51. return lastName;
  52. }
  53. public void setLastName( String last_name ) {
  54. this.lastName = last_name;
  55. }
  56. public int getSalary() {
  57. return salary;
  58. }
  59. public void setSalary( int salary ) {
  60. this.salary = salary;
  61. }
  62. }
  63.  
  64.  
  65. <?xml version="1.0" encoding="utf-8"?>
  66. <!DOCTYPE hibernate-mapping PUBLIC
  67. "-//Hibernate/Hibernate Mapping DTD//EN"
  68. "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
  69.  
  70. <hibernate-mapping>
  71. <class name="sally.Employee" table="EMPLOYEE">
  72. <meta attribute="class-description">
  73. This class contains the employee detail.
  74. </meta>
  75. <id name="id" type="int" column="id">
  76. <generator class="native"/>
  77. </id>
  78. <property name="firstName" column="first_name" type="string"/>
  79. <property name="lastName" column="last_name" type="string"/>
  80. <property name="salary" column="salary" type="int"/>
  81. </class>
  82. </hibernate-mapping>
  83.  
  84. <?xml version="1.0" encoding="utf-8"?>
  85. <!DOCTYPE hibernate-configuration PUBLIC
  86. "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
  87. "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
  88. <hibernate-configuration>
  89. <session-factory>
  90. <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
  91. <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/test</property>
  92. <property name="hibernate.connection.password"></property>
  93. <property name="hibernate.connection.username">root</property>
  94. <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
  95. <property name="show_sql">true</property>
  96.  
  97.  
  98. <mapping class="sally.Employee"></mapping>
  99. </session-factory>
  100.  
  101. log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
  102. log4j:WARN Please initialize the log4j system properly.
  103. log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
  104. org.hibernate.exception.JDBCConnectionException: Cannot open connection
  105. at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
  106. at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
  107. at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
  108. at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)
  109. at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
  110. at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
  111. at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
  112. at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
  113. at sally.MainClass.main(MainClass.java:12)
  114. Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/test
  115. at java.sql.DriverManager.getConnection(DriverManager.java:596)
  116. at java.sql.DriverManager.getConnection(DriverManager.java:187)
  117. at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
  118. at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
  119. ... 5 more
Add Comment
Please, Sign In to add comment