These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 4 posts ] 
Author Message
 Post subject: Error Connecting to Oracle 10g Express Edition error
PostPosted: Wed Jul 28, 2010 10:12 pm 
Newbie

Joined: Wed Jul 28, 2010 9:43 pm
Posts: 3
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.


Top
 Profile  
 
 Post subject: Re: Error Connecting to Oracle 10g Express Edition error
PostPosted: Thu Jul 29, 2010 8:01 am 
Newbie

Joined: Mon Jul 26, 2010 6:50 am
Posts: 6
Hi,

the default port for a oracle db is usualy 1521, except you have changed that...

br


Top
 Profile  
 
 Post subject: Re: Error Connecting to Oracle 10g Express Edition error
PostPosted: Thu Jul 29, 2010 9:06 am 
Newbie

Joined: Wed Jul 28, 2010 9:43 pm
Posts: 3
Thank you! That helped.
I had used 1521 before but must have had the wrong username/password.

Great Job!!!


Top
 Profile  
 
 Post subject: Re: Error Connecting to Oracle 10g Express Edition error
PostPosted: Thu Jul 29, 2010 9:20 am 
Newbie

Joined: Mon Jul 26, 2010 6:50 am
Posts: 6
[edit] obsolete


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 4 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.