API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 22nd, 2017
103
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.70 KB | None | 0 0
raw download clone embed print report
  1. <!--
  2. ~ Hibernate, Relational Persistence for Idiomatic Java
  3. ~
  4. ~ License: GNU Lesser General Public License (LGPL), version 2.1 or later.
  5. ~ See the lgpl.txt file in the root directory or <http://www.gnu.org/licenses/lgpl-2.1.html>.
  6. -->
  7. <!DOCTYPE hibernate-configuration PUBLIC
  8. "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
  9. "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
  10.  
  11. <hibernate-configuration>
  12. <session-factory>
  13. <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
  14. <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
  15. <property name="hibernate.connection.username">manoj</property>
  16. <property name="hibernate.connection.password">manoj$123</property>
  17. <property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521/XE</property>
  18. <property name="hibernate.hbm2ddl.auto">create</property>
  19. <property name="connection.pool_size">1</property>
  20. <property name="show_sql">true</property>
  21. <mapping class="com.manoj.java.hibernate.UserDetails"/>
  22. </session-factory>
  23. </hibernate-configuration>
  24.  
  25. XE =
  26. (DESCRIPTION =
  27. (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  28. (CONNECT_DATA =
  29. (SERVER = DEDICATED)
  30. (SERVICE_NAME = XE)
  31. )
  32. )
  33.  
  34. EXTPROC_CONNECTION_DATA =
  35. (DESCRIPTION =
  36. (ADDRESS_LIST =
  37. (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
  38. )
  39. (CONNECT_DATA =
  40. (SID = PLSExtProc)
  41. (PRESENTATION = RO)
  42. )
  43. )
  44.  
  45. ORACLR_CONNECTION_DATA =
  46. (DESCRIPTION =
  47. (ADDRESS_LIST =
  48. (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
  49. )
  50. (CONNECT_DATA =
  51. (SID = CLRExtProc)
  52. (PRESENTATION = RO)
  53. )
  54. )
  55.  
  56. SID_LIST_LISTENER =
  57. (SID_LIST =
  58. (SID_DESC =
  59. (SID_NAME = XE)
  60. (ORACLE_HOME = C:oraclexeapporacleproduct11.2.0server)
  61. )
  62. (SID_DESC =
  63. (SID_NAME = PLSExtProc)
  64. (ORACLE_HOME = C:oraclexeapporacleproduct11.2.0server)
  65. (PROGRAM = extproc)
  66. )
  67. (SID_DESC =
  68. (SID_NAME = CLRExtProc)
  69. (ORACLE_HOME = C:oraclexeapporacleproduct11.2.0server)
  70. (PROGRAM = extproc)
  71. )
  72. )
  73.  
  74. LISTENER =
  75. (DESCRIPTION_LIST =
  76. (DESCRIPTION =
  77. (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
  78. (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  79. )
  80. )
  81.  
  82. DEFAULT_SERVICE_LISTENER = (XE)
  83.  
  84. Apr 22, 2017 11:40:01 AM org.hibernate.Version logVersion
  85. INFO: HHH000412: Hibernate Core {5.2.9.Final}
  86. Apr 22, 2017 11:40:01 AM org.hibernate.cfg.Environment <clinit>
  87. INFO: HHH000206: hibernate.properties not found
  88. Apr 22, 2017 11:40:02 AM org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
  89. INFO: HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
  90. Apr 22, 2017 11:40:02 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
  91. WARN: HHH10001002: Using Hibernate built-in connection pool (not for production use!)
  92. Apr 22, 2017 11:40:02 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
  93. INFO: HHH10001005: using driver [oracle.jdbc.driver.OracleDriver] at URL [jdbc:oracle:thin:localhost:1521:orcl]
  94. Apr 22, 2017 11:40:02 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
  95. INFO: HHH10001001: Connection properties: {user=manoj, password=****}
  96. Apr 22, 2017 11:40:02 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
  97. INFO: HHH10001003: Autocommit mode: false
  98. Apr 22, 2017 11:40:02 AM org.hibernate.engine.jdbc.connections.internal.PooledConnections <init>
  99. INFO: HHH000115: Hibernate connection pool size: 1 (min=1)
  100. Exception in thread "main" org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  101. at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:271)
  102. at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:233)
  103. at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:210)
  104. at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:51)
  105. at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:94)
  106. at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:242)
  107. at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:210)
  108. at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.handleTypes(MetadataBuildingProcess.java:352)
  109. at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:111)
  110. at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:83)
  111. at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:418)
  112. at org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:87)
  113. at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:691)
  114. at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:726)
  115. at com.manoj.java.session.HibernateSession.main(HibernateSession.java:15)
  116. Caused by: org.hibernate.exception.JDBCConnectionException: Error calling Driver#connect
  117. at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator$1$1.convert(BasicConnectionCreator.java:105)
  118. at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.convertSqlException(BasicConnectionCreator.java:123)
  119. at org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:41)
  120. at org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.createConnection(BasicConnectionCreator.java:58)
  121. at org.hibernate.engine.jdbc.connections.internal.PooledConnections.addConnections(PooledConnections.java:123)
  122. at org.hibernate.engine.jdbc.connections.internal.PooledConnections.<init>(PooledConnections.java:42)
  123. at org.hibernate.engine.jdbc.connections.internal.PooledConnections.<init>(PooledConnections.java:20)
  124. at org.hibernate.engine.jdbc.connections.internal.PooledConnections$Builder.build(PooledConnections.java:161)
  125. at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.buildPool(DriverManagerConnectionProviderImpl.java:109)
  126. at org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.configure(DriverManagerConnectionProviderImpl.java:72)
  127. at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:94)
  128. at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:242)
  129. at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:210)
  130. at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.buildJdbcConnectionAccess(JdbcEnvironmentInitiator.java:145)
  131. at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:66)
  132. at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35)
  133. at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:88)
  134. at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:259)
  135. ... 14 more
  136. Caused by: java.sql.SQLException: Listener refused the connection with the following error:
  137. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  138.  
  139. at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
  140. at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553)
  141. at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254)
  142. at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
  143. at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
  144. at org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:38)
  145. ... 29 more
  146. Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
  147. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  148.  
  149. at oracle.net.ns.NSProtocol.connect(NSProtocol.java:399)
  150. at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140)
  151. at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)
  152. ... 34 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!