[jboss-user] [JBoss Tools (users)] - Re: Reverse engineering - Could not obtain connection metada

[dfwsteele]

Has anyone been able to solve this issue? I am running into the same problem. I am working with Oracle 10g, eclipse 3.2, and IDE 1.6

When I try connecting to an Oracle database to do reverse engineeering I get the following error:

org.hibernate.exception.GenericJDBCException: Getting database metadata
  | 	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
  | 	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
  | 	at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect.getMetaData(JDBCMetaDataDialect.java:61)
  | 	at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect.getTables(JDBCMetaDataDialect.java:70)
  | 	at org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:404)
  | 	at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:68)
  | 	at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter$1.execute(LazyDatabaseSchemaWorkbenchAdapter.java:76)
  | 	at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35)
  | 	at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.readDatabaseSchema(LazyDatabaseSchemaWorkbenchAdapter.java:67)
  | 	at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.getChildren(LazyDatabaseSchemaWorkbenchAdapter.java:36)
  | 	at org.hibernate.eclipse.console.workbench.LazyDatabaseSchemaWorkbenchAdapter.getChildren(LazyDatabaseSchemaWorkbenchAdapter.java:28)
  | 	at org.hibernate.eclipse.console.workbench.BasicWorkbenchAdapter.fetchDeferredChildren(BasicWorkbenchAdapter.java:69)
  | 	at org.eclipse.ui.progress.DeferredTreeContentManager$1.run(DeferredTreeContentManager.java:207)
  | 	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:58)
  | Caused by: java.sql.SQLException: invalid arguments in call
  | 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
  | 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
  | 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
  | 	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:236)
  | 	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:494)
  | 	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
  | 	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
  | 	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:816)
  | 	at org.hibernate.console.FakeDelegatingDriver.connect(FakeDelegatingDriver.java:23)
  | 	at java.sql.DriverManager.getConnection(Unknown Source)
  | 	at java.sql.DriverManager.getConnection(Unknown Source)
  | 	at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
  | 	at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect.getConnection(JDBCMetaDataDialect.java:294)
  | 	at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect.getMetaData(JDBCMetaDataDialect.java:58)
  | 	... 11 more


Here is my hibernate.cfg.xml:

<?xml version="1.0" encoding="UTF-8"?>
  | <!DOCTYPE hibernate-configuration PUBLIC
  | 		"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
  | 		"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
  | <hibernate-configuration>
  |     <session-factory>
  |         <property name="hibernate.connection.driver_class">oracle.jdbc.OracleDriver</property>
  |         <property name="hibernate.connection.password">xxxxx</property>
  |         <property name="hibernate.connection.url">jdbc:oracle:thin:@nwusa-ars1048.nwusa.local:1521:veria</property>
  |         <property name="hibernate.connection.username">veria</property>
  |         <property name="hibernate.dialect">org.hibernate.dialect.OracleDialect</property>
  |         <property name="hibernate.default_schema">veria</property>
  |         <property name="show_sql">true</property>
  |     </session-factory>
  | </hibernate-configuration>
Any help would be greatly appreciated.

- Aaron

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4055263#4055263

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4055263