Advertisement
Guest User

Untitled

a guest
Jan 8th, 2017
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.89 KB | None | 0 0
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE hibernate-configuration PUBLIC
  3. "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
  4. "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
  5. <hibernate-configuration>
  6. <session-factory>
  7. <property name="connection.username">root</property>
  8. <property name="connection.password">root</property>
  9. <property name="connecton.driver_class">com.mysql.jdbc.Driver</property>
  10. <property name="connection.url">jdbc:mysql://localhost:3306/hibernate_db</property>
  11. <property name="show_sql">true</property>
  12. </session-factory>
  13. </hibernate-configuration>
  14.  
  15.  
  16. This is my DTO class
  17.  
  18. package com.app.hibernate;
  19.  
  20. import java.io.Serializable;
  21.  
  22. import javax.persistence.Column;
  23. import javax.persistence.Entity;
  24. import javax.persistence.Id;
  25. import javax.persistence.Table;
  26.  
  27. @Entity
  28. @Table(name = "paytm_table")
  29.  
  30. public class PaytmDTO implements Serializable
  31. {
  32. @Id
  33. @Column(name="mob_num")
  34. private int mobileNumber;
  35.  
  36. @Column(name="amount")
  37. private int amount;
  38.  
  39. @Column(name="email_id")
  40. private String emailId;
  41.  
  42. @Column(name="OTP")
  43. private int OTP;
  44.  
  45. public PaytmDTO() {
  46.  
  47. }
  48.  
  49. public int getMobileNumber() {
  50. return mobileNumber;
  51. }
  52.  
  53. public void setMobileNumber(int mobileNumber) {
  54. this.mobileNumber = mobileNumber;
  55. }
  56.  
  57. public int getAmount() {
  58. return amount;
  59. }
  60.  
  61. public void setAmount(int amount) {
  62. this.amount = amount;
  63. }
  64.  
  65. public String getEmailId() {
  66. return emailId;
  67. }
  68.  
  69. public void setEmailId(String emailId) {
  70. this.emailId = emailId;
  71. }
  72.  
  73. public int getOTP() {
  74. return OTP;
  75. }
  76.  
  77. public void setOTP(int oTP) {
  78. OTP = oTP;
  79. }
  80.  
  81. }
  82.  
  83. package com.app.hibernate;
  84.  
  85. import org.hibernate.Session;
  86. import org.hibernate.SessionFactory;
  87. import org.hibernate.Transaction;
  88. import org.hibernate.cfg.Configuration;
  89.  
  90. public class PaytmDAO
  91. {
  92. public static void main(String[] args)
  93. {
  94. //Create Object of DTO
  95. PaytmDTO dto=new PaytmDTO();
  96.  
  97. //Set the DTO values using Setter method
  98. dto.setAmount(239);
  99. dto.setEmailId("impriyank95@gmail.com");
  100. dto.setMobileNumber(941478859);
  101. dto.setOTP(8965);
  102.  
  103. //Create Object of Configuration
  104. Configuration config=new Configuration();
  105. config.configure();
  106. config.addAnnotatedClass(PaytmDTO.class);
  107.  
  108. //Create object of 2nd Component SessionFactory
  109. SessionFactory sf=config.buildSessionFactory();
  110.  
  111. //Get a Session (3rd Component)
  112. Session sess=sf.openSession();
  113. sess.save(dto);
  114.  
  115. Transaction tx=sess.beginTransaction();
  116. tx.commit();
  117.  
  118. }
  119.  
  120. }
  121.  
  122. Jan 08, 2017 11:37:33 PM org.hibernate.engine.jdbc.connections.internal.PooledConnections <init>
  123. INFO: HHH000115: Hibernate connection pool size: 20 (min=1)
  124. Exception in thread "main" org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  125. at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:244)
  126. at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:208)
  127. at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:189)
  128. at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:51)
  129. at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:94)
  130. at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:217)
  131. at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:189)
  132. at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.handleTypes(MetadataBuildingProcess.java:352)
  133. at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:111)
  134. at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:83)
  135. at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:418)
  136. at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:87)
  137. at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:692)
  138. at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:724)
  139. at com.app.hibernate.PaytmDAO.main(PaytmDAO.java:27)
  140. Caused by: org.hibernate.exception.JDBCConnectionException: Error calling DriverManager#getConnection
  141. at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:115)
  142. at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator$1$1.convert(BasicConnectionCreator.java:101)
  143. at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.convertSqlException(BasicConnectionCreator.java:123)
  144. at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionCreator.makeConnection(DriverManagerConnectionCreator.java:37)
  145. at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.createConnection(BasicConnectionCreator.java:58)
  146. at org.hibernate.engine.jdbc.connections.internal.PooledConnections.addConnections(PooledConnections.java:106)
  147. at org.hibernate.engine.jdbc.connections.internal.PooledConnections.<init>(PooledConnections.java:40)
  148. at org.hibernate.engine.jdbc.connections.internal.PooledConnections.<init>(PooledConnections.java:19)
  149. at org.hibernate.engine.jdbc.connections.internal.PooledConnections$Builder.build(PooledConnections.java:138)
  150. at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.buildPool(DriverManagerConnectionProviderImpl.java:110)
  151. at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.configure(DriverManagerConnectionProviderImpl.java:74)
  152. at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:94)
  153. at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:217)
  154. at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:189)
  155. at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.buildJdbcConnectionAccess(JdbcEnvironmentInitiator.java:145)
  156. at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:66)
  157. at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35)
  158. at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:88)
  159. at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:234)
  160. ... 14 more
  161. Caused by: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/hibernate_db
  162. at java.sql.DriverManager.getConnection(Unknown Source)
  163. at java.sql.DriverManager.getConnection(Unknown Source)
  164. at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionCreator.makeConnection(DriverManagerConnectionCreator.java:34)
  165. ... 29 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement