• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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


 
Bartender
Posts: 1682
7
Android Mac OS X IntelliJ IDE Spring Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic