I am trying to connect my Java standalone application to an Oracle database that is on my computer. I am using Windows XP. Here is my properties of my config file:
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property> <property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:8080:XE</property> <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property> <property name="hibernate.connection.username">sys</property> <property name="hibernate.connection.password">pass</property> <property name="connection.pool_size">1</property> <property name="hibernate.show_sql">true</property> <property name="hibernate.hbm2ddl.auto">update</property> <property name="hibernate.statement.cache.size">0</property> <property name="hibernate.jdbc.batch.size">0</property> <property name="hibernate.dbcp.ps.maxIdle">0</property> <property name="hibernate.jdbc.wrap_result_sets">true</property>
Here is my stack trace:
22:00:31,015 WARN SettingsFactory:117 - Could not obtain connection metadata java.sql.SQLException: Io exception: Got minus one from a read call at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:161) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:273) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:318) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:343) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:147) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545) 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.SettingsFactory.buildSettings(SettingsFactory.java:84) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292) at shared.dataAbstraction.AbstractDac.<clinit>(AbstractDac.java:42) at psp.businessLogic.PspApplicationManagement.<init>(PspApplicationManagement.java:19) at psp.controller.PspApplicationController.<init>(PspApplicationController.java:19) at psp.ui.PspClientApplication.afterPSP_TSP_MDIcreation(PspClientApplication.java:118) at psp.ui.PSP_TSP_MDIFrame$2.run(PSP_TSP_MDIFrame.java:300) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at org.openswing.swing.util.client.ApplicationEventQueue$InternalEventQueue.dispatchEvent(ApplicationEventQueue.java:130) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) 22:00:31,078 INFO Dialect:152 - Using dialect: org.hibernate.dialect.Oracle10gDialect 22:00:31,093 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions) 22:00:31,218 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended) 22:00:31,218 INFO SettingsFactory:143 - Automatic flush during beforeCompletion(): disabled 22:00:31,218 INFO SettingsFactory:147 - Automatic session close at end of transaction: disabled 22:00:31,218 INFO SettingsFactory:162 - Scrollable result sets: disabled 22:00:31,218 INFO SettingsFactory:170 - JDBC3 getGeneratedKeys(): disabled 22:00:31,218 INFO SettingsFactory:178 - Connection release mode: auto 22:00:31,218 INFO SettingsFactory:205 - Default batch fetch size: 1 22:00:31,218 INFO SettingsFactory:209 - Generate SQL with comments: disabled 22:00:31,218 INFO SettingsFactory:213 - Order SQL updates by primary key: disabled 22:00:31,218 INFO SettingsFactory:217 - Order SQL inserts for batching: disabled 22:00:31,218 INFO SettingsFactory:386 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory 22:00:31,218 INFO ASTQueryTranslatorFactory:24 - Using ASTQueryTranslatorFactory 22:00:31,218 INFO SettingsFactory:225 - Query language substitutions: {} 22:00:31,218 INFO SettingsFactory:230 - JPA-QL strict compliance: disabled 22:00:31,218 INFO SettingsFactory:235 - Second-level cache: enabled 22:00:31,218 INFO SettingsFactory:239 - Query cache: disabled 22:00:31,218 INFO SettingsFactory:373 - Cache provider: org.hibernate.cache.NoCacheProvider 22:00:31,218 INFO SettingsFactory:254 - Optimize cache for minimal puts: disabled 22:00:31,218 INFO SettingsFactory:263 - Structured second-level cache entries: disabled 22:00:31,234 INFO SettingsFactory:283 - Echoing all SQL to stdout 22:00:31,234 INFO SettingsFactory:290 - Statistics: disabled 22:00:31,250 INFO SettingsFactory:294 - Deleted entity synthetic identifier rollback: disabled 22:00:31,250 INFO SettingsFactory:309 - Default entity-mode: pojo 22:00:31,250 INFO SettingsFactory:313 - Named query checking : enabled 22:00:31,296 INFO SessionFactoryImpl:161 - building session factory 22:00:32,828 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured 22:00:32,859 INFO SchemaUpdate:115 - Running hbm2ddl schema update 22:00:32,859 INFO SchemaUpdate:126 - fetching database metadata 22:00:38,875 ERROR SchemaUpdate:134 - could not get database metadata java.sql.SQLException: Io exception: Got minus one from a read call at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:161) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:273) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:318) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:343) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:147) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545) 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.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:27) at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:127) at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:314) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294) at shared.dataAbstraction.AbstractDac.<clinit>(AbstractDac.java:42) at psp.businessLogic.PspApplicationManagement.<init>(PspApplicationManagement.java:19) at psp.controller.PspApplicationController.<init>(PspApplicationController.java:19) at psp.ui.PspClientApplication.afterPSP_TSP_MDIcreation(PspClientApplication.java:118) at psp.ui.PSP_TSP_MDIFrame$2.run(PSP_TSP_MDIFrame.java:300) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at org.openswing.swing.util.client.ApplicationEventQueue$InternalEventQueue.dispatchEvent(ApplicationEventQueue.java:130) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) 22:00:38,875 ERROR SchemaUpdate:165 - could not complete schema update java.sql.SQLException: Io exception: Got minus one from a read call at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:161) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:273) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:318) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:343) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:147) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545) 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.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:27) at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:127) at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:314) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294) at shared.dataAbstraction.AbstractDac.<clinit>(AbstractDac.java:42) at psp.businessLogic.PspApplicationManagement.<init>(PspApplicationManagement.java:19) at psp.controller.PspApplicationController.<init>(PspApplicationController.java:19) at psp.ui.PspClientApplication.afterPSP_TSP_MDIcreation(PspClientApplication.java:118) at psp.ui.PSP_TSP_MDIFrame$2.run(PSP_TSP_MDIFrame.java:300) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at org.openswing.swing.util.client.ApplicationEventQueue$InternalEventQueue.dispatchEvent(ApplicationEventQueue.java:130) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) 22:00:45,000 WARN JDBCExceptionReporter:77 - SQL Error: 17002, SQLState: null Jul 28, 2010 10:00:45 PM shared.dataAbstraction.AbstractDac rollback WARNING: Cannot rollback org.hibernate.TransactionException: Transaction not successfully started at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:149) at shared.dataAbstraction.AbstractDac.rollback(AbstractDac.java:92) at shared.dataAbstraction.AbstractDac.loadTestData(AbstractDac.java:1191) at psp.dataAccess.PspApplicationDac.<init>(PspApplicationDac.java:32) at psp.businessLogic.PspApplicationManagement.<init>(PspApplicationManagement.java:19) at psp.controller.PspApplicationController.<init>(PspApplicationController.java:19) at psp.ui.PspClientApplication.afterPSP_TSP_MDIcreation(PspClientApplication.java:118) at psp.ui.PSP_TSP_MDIFrame$2.run(PSP_TSP_MDIFrame.java:300) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at org.openswing.swing.util.client.ApplicationEventQueue$InternalEventQueue.dispatchEvent(ApplicationEventQueue.java:130) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) 22:00:45,000 ERROR JDBCExceptionReporter:78 - Io exception: Got minus one from a read call org.hibernate.exception.GenericJDBCException: Cannot open connection at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) 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:426) at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144) at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57) at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326) at shared.dataAbstraction.AbstractDac.begin(AbstractDac.java:77) at shared.dataAbstraction.AbstractDac.loadTestData(AbstractDac.java:132) at psp.dataAccess.PspApplicationDac.<init>(PspApplicationDac.java:32) at psp.businessLogic.PspApplicationManagement.<init>(PspApplicationManagement.java:19) at psp.controller.PspApplicationController.<init>(PspApplicationController.java:19) at psp.ui.PspClientApplication.afterPSP_TSP_MDIcreation(PspClientApplication.java:118) at psp.ui.PSP_TSP_MDIFrame$2.run(PSP_TSP_MDIFrame.java:300) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at org.openswing.swing.util.client.ApplicationEventQueue$InternalEventQueue.dispatchEvent(ApplicationEventQueue.java:130) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) Caused by: java.sql.SQLException: Io exception: Got minus one from a read call at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:161) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:273) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:318) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:343) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:147) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545) 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.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423) ... 20 more The resource 'Error starting application. Please make sure that no other copy of the application is running' is not defined. The resource 'Error starting application' is not defined.
I believe I am not making the connection to the database. I don't know what additional properties I need to describe my schema.
Any suggestions or help would be appreciated.
|