Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hibernate configuration issue while getting the Oracle Database 11G database connection

 
Sridhar Goranti
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


Hi,

When I am trying to deploying an j2ee application in IBM Web Sphere 7 Application Server, where it uses Adobe Flex, Spring 2.0, Hibernate 3.0 and the database as Oracle 11G. I am getting below issue:-


[8/17/12 16:14:48:979 CDT] 00000008 DMAdapter I com.ibm.ws.ffdc.impl.DMAdapter getAnalysisEngine FFDC1009I: Analysis Engine using data base: C:\Program Files (x86)\IBM\SDP\runtimes\base_v7\profiles\AppSrv01\properties\logbr\ffdc\adv\ffdcdb.xml
[8/17/12 16:14:48:985 CDT] 00000008 FfdcProvider I com.ibm.ws.ffdc.impl.FfdcProvider logIncident FFDC1003I: FFDC Incident emitted on C:\Program Files (x86)\IBM\SDP\runtimes\base_v7\profiles\AppSrv01\logs\ffdc\server1_78ce78ce_12.08.17_16.14.48.96029300.txt com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledCon 1298
[8/17/12 16:14:49:039 CDT] 00000008 FfdcProvider I com.ibm.ws.ffdc.impl.FfdcProvider logIncident FFDC1003I: FFDC Incident emitted on C:\Program Files (x86)\IBM\SDP\runtimes\base_v7\profiles\AppSrv01\logs\ffdc\server1_78ce78ce_12.08.17_16.14.49.00329301.txt com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper 199
[8/17/12 16:14:49:387 CDT] 00000008 FfdcProvider I com.ibm.ws.ffdc.impl.FfdcProvider logIncident FFDC1003I: FFDC Incident emitted on C:\Program Files (x86)\IBM\SDP\runtimes\base_v7\profiles\AppSrv01\logs\ffdc\server1_78ce78ce_12.08.17_16.14.49.04529302.txt com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection 299
[8/17/12 16:14:49:396 CDT] 00000008 JDBCException W org.hibernate.util.JDBCExceptionReporter logExceptions SQL Error: 17067, SQLState: 99999
[8/17/12 16:14:49:399 CDT] 00000008 JDBCException E org.hibernate.util.JDBCExceptionReporter logExceptions Invalid Oracle URL specifiedDSRA0010E: SQL State = 99999, Error Code = 17,067
[8/17/12 16:14:49:401 CDT] 00000008 SettingsFacto W org.hibernate.cfg.SettingsFactory buildSettings Could not obtain connection metadata
java.sql.SQLException: Invalid Oracle URL specifiedDSRA0010E: SQL State = 99999, Error Code = 17,067
at oracle.jdbc.xa.client.OracleXADataSource.getPooledConnection(OracleXADataSource.java:219)
at oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:154)
at oracle.jdbc.xa.client.OracleXADataSource.getXAConnection(OracleXADataSource.java:99)
at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper$1.run(InternalGenericDataStoreHelper.java:1175)
at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)




But when I tested from stand-alone application, from TOAD and IBM Web Sphere 7 Server - admin console window - the connection was successful.



Kindly help me here.


Thanks & Regards,
Sridhar Goranti
USA


 
Bill Gorder
Bartender
Posts: 1682
7
Android IntelliJ IDE Linux Mac OS X Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't see anything here to lead me to believe this a Hibernate issue. It sounds like your datasource is configured in Websphere, I would double check those configurations, and triple check the URL. Do you have Authentication=Container? Did you try restarting dmgr? How is your application getting a handle to the datasource is this exposed through JNDI and configured in Spring? You can post more of your hibernate configuration after verifying the other stuff I just suggested, but this question may be better suited as a configuration question in the websphere forum.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic