aspose file tools*
The moose likes Object Relational Mapping and the fly likes Hibernate configuration issue while getting the Oracle Database 11G database connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate configuration issue while getting the Oracle Database 11G database connection" Watch "Hibernate configuration issue while getting the Oracle Database 11G database connection" New topic
Author

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

Sridhar Goranti
Greenhorn

Joined: Jul 11, 2012
Posts: 4


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

Joined: Mar 07, 2010
Posts: 1680
    
    7

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.


[How To Ask Questions][Read before you PM me]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Hibernate configuration issue while getting the Oracle Database 11G database connection