Could not obtain connection metadata

jfreebsd · **Joined:** Fri Apr 15, 2005 9:22 am **Posts:** 11

I'm having the following problem when building a session factory for oracle from cgf.xml

The xml file is

Code:

     <property name="hibernate.dialect">org.hibernate.dialect.OracleDialect</property>      
      <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
      <property name="connection.url">jdbc:oracle:thin:@10.30.10.55:1521:XYZ_SCHEMA</property>
      <property name="connection.username">XYZ</property>
      <property name="connection.password">XYZ</property>
      <property name="show_sql">false</property>

and the error is...

Code:

WARN  22-Aug-2006 18:27:11 [main] org.hibernate.cfg.SettingsFactory  - Could not obtain connection metadata
java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
   at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3678)
   at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:352)

org.hibernate.exception.GenericJDBCException: Cannot open connection
   at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
   at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:307)
   at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:109)
   at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:134)

Caused by: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

I don't know the reason of this error.

Regards.

ChristianS · **Posted:** Tue Aug 22, 2006 6:58 pm

Got a similar exception a week ago.
Google told me that Oracle Error 12505 is

Quote:

ORA-12505: TNS: listener could not resolve SID given in connection description TNS: listener could not resolve SID given in connection description

which indicates a problem in the Oracle configuration (client).
Maybe one of your database guys can help you with the TNS and SID settings.