Switching from HypersonicSQL to Oracle

djtangman

Hello:

Trying to reconfigure OD to Oracle rather than HypersonicSQL, and I'm getting the following error when starting up OpenDeploy:

SVR: 2007-06-04 12:39:21 MDT GMT-06:00 Start logging to OpenDeploy server log.
OpenJMS 0.7.6.1
The OpenJMS Group. (C) 1999-2004. All rights reserved.
http://openjms.sourceforge.net
org.exolab.jms.server.ServerException: org.exolab.jms.persistence.PersistenceException: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory, cause:
java.sql.SQLException: Io exception: Invalid number format for port number
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:333)
at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:404)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:82)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:838)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:821)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
at org.exolab.jms.persistence.DBCPConnectionManager.getConnection(DBCPConnectionManager.java:119)
at org.exolab.jms.persistence.RDBMSAdapter.getConnection(RDBMSAdapter.java:709)
at org.exolab.jms.persistence.RDBMSAdapter.(RDBMSAdapter.java:180)
at org.exolab.jms.persistence.DatabaseService.createRdbmsAdapter(DatabaseService.java:236)
at org.exolab.jms.persistence.DatabaseService.(DatabaseService.java:163)
at org.exolab.jms.persistence.DatabaseService.instance(DatabaseService.java:115)
at org.exolab.jms.server.JmsServer.registerServices(JmsServer.java:274)
at org.exolab.jms.server.JmsServer.init(JmsServer.java:185)
at org.exolab.jms.server.JmsServer.main(JmsServer.java:229)
OpenDeploy server and its RMI registry started.


Anyone got any ideas on what to do about this? The rmi port configurations in the deploy.cfg file are as follows:


#-- server administration RMI connection ports:
Deploy.rmiConnectionPort1: 24071
Deploy.rmiConnectionPort2: 24071
Deploy.rmiConnectionPort3: 24071
Deploy.rmiConnectionPort4: 24071
Deploy.rmiConnectionPort5: 24071
Deploy.rmiConnectionPort6: 24071
Deploy.rmiConnectionPort7: 24071
#
#-- event reporting RMI connection ports:
Deploy.rmiConnectionPort8: 24078
Deploy.rmiConnectionPort9: 24078
Deploy.rmiConnectionPort10: 24078
Deploy.rmiConnectionPort11: 24078
Deploy.rmiConnectionPort12: 24078
Deploy.rmiConnectionPort13: 24078
Deploy.rmiConnectionPort14: 24078
Deploy.rmiConnectionPort15: 24078


Thanks ahead of time!

Migrateduser

Hi djtangman,

I highlighted the "important" line in your error message below. The problem, however, is not in the deploy.cfg file or with the Deploy.rmiConnectionPort entries. The problem is with your JDBC connection string (AKA the database connection URL that you have configured in <ODHOME>/etc/jmsConfig.xml

For Hypersonic, it looks like this:
[formatted]

url="jdbc:hsqldb:C:\localsrc\OpenDeployNG\db
\openjms.db"
user="sa"
password=""
retries="5"
timeout="10" />
[/formatted]

For Oracle, or any other DBMS, you should consult the JDBC driver's documentation on how to properly form the connection string URL so that it contains all the options that you want/intend.

Thanks,
Mike

Hello: Trying to reconfigure OD to Oracle rather than HypersonicSQL, and I'm getting the following error when starting up OpenDeploy: SVR: 2007-06-04 12:39:21 MDT GMT-06:00 Start logging to OpenDeploy server log. OpenJMS 0.7.6.1 The OpenJMS Group. (C) 1999-2004. All rights reserved. http://openjms.sourceforge.net org.exolab.jms.server.ServerException: org.exolab.jms.persistence.PersistenceException: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory, cause: java.sql.SQLException: Io exception: Invalid number format for port number 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:333) at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:404) at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:82) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:300) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:838) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:821) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518) at org.exolab.jms.persistence.DBCPConnectionManager.getConnection(DBCPConnectionManager.java:119) at org.exolab.jms.persistence.RDBMSAdapter.getConnection(RDBMSAdapter.java:709) at org.exolab.jms.persistence.RDBMSAdapter.(RDBMSAdapter.java:180) at org.exolab.jms.persistence.DatabaseService.createRdbmsAdapter(DatabaseService.java:236) at org.exolab.jms.persistence.DatabaseService.(DatabaseService.java:163) at org.exolab.jms.persistence.DatabaseService.instance(DatabaseService.java:115) at org.exolab.jms.server.JmsServer.registerServices(JmsServer.java:274) at org.exolab.jms.server.JmsServer.init(JmsServer.java:185) at org.exolab.jms.server.JmsServer.main(JmsServer.java:229) OpenDeploy server and its RMI registry started. Anyone got any ideas on what to do about this? The rmi port configurations in the deploy.cfg file are as follows: #-- server administration RMI connection ports: Deploy.rmiConnectionPort1: 24071 Deploy.rmiConnectionPort2: 24071 Deploy.rmiConnectionPort3: 24071 Deploy.rmiConnectionPort4: 24071 Deploy.rmiConnectionPort5: 24071 Deploy.rmiConnectionPort6: 24071 Deploy.rmiConnectionPort7: 24071 # #-- event reporting RMI connection ports: Deploy.rmiConnectionPort8: 24078 Deploy.rmiConnectionPort9: 24078 Deploy.rmiConnectionPort10: 24078 Deploy.rmiConnectionPort11: 24078 Deploy.rmiConnectionPort12: 24078 Deploy.rmiConnectionPort13: 24078 Deploy.rmiConnectionPort14: 24078 Deploy.rmiConnectionPort15: 24078 Thanks ahead of time!