Did someone succeed in running 0.7.7-dev version on non-derby db?
Marco Lettere <[email protected]>
| Newsgroups | gmane.comp.java.openjms.user |
|---|---|
| Message-ID | <[email protected]> |
Hello,
we are trying to make the 0.7.7-dev version of openjms running on a
postgres and on a mysql dbms.
The version of postgres is a 7.2.7 (jdbc driver 7.2) on a linux Red Hat
machine whilst mysql is version 3.23.58 (jdbc driver mysql-connector
3.0.15).
In both cases we get fatal exceptions running the dbtool.sh script (our
other sample programs using the same drivers/db work perfectly).
Has anyone made it to run dbtool.sh on a dbms different than derby? What
exactly are we missing?
Thanx,
M.
MYSQL EXCEPTION:
11:37:09.500 ERROR [main] - org.exolab.jms.persistence.PersistenceException:
Failed to get pooled connection
org.exolab.jms.persistence.PersistenceException:
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory, cause:
java.sql.SQLException: Communication link failure: java.io.EOFException,
underlying cause: null
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1394)
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:1413)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:625)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1782)
at com.mysql.jdbc.Connection.<init>(Connection.java:450)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConne
ctionFactory.java:82)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnect
ionFactory.java:300)
at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataS
ource.java:838)
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav
a:821)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:5
18)
at
org.exolab.jms.persistence.DBCPConnectionManager.getConnection(DBCPConnectio
nManager.java:119)
at org.exolab.jms.tools.db.DBTool.<init>(DBTool.java:132)
at org.exolab.jms.tools.db.DBTool.main(DBTool.java:237)
** END NESTED EXCEPTION **
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:1446)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:625)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1782)
at com.mysql.jdbc.Connection.<init>(Connection.java:450)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConne
ctionFactory.java:82)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnect
ionFactory.java:300)
at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataS
ource.java:838)
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.jav
a:821)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:5
18)
at
org.exolab.jms.persistence.DBCPConnectionManager.getConnection(DBCPConnectio
nManager.java:119)
at org.exolab.jms.tools.db.DBTool.<init>(DBTool.java:132)
at org.exolab.jms.tools.db.DBTool.main(DBTool.java:237)
POSTGRES EXCEPTION:
12:04:35.870 ERROR [main] - org.exolab.jms.persistence.PersistenceException:
Database does not support type=varchar(20)
org.exolab.jms.persistence.PersistenceException: Database does not support
type=varchar(20)
at
org.exolab.jms.tools.db.SchemaBrowser.getType(SchemaBrowser.java:188)
at org.exolab.jms.tools.db.RDBMSTool.getSQLType(RDBMSTool.java:277)
at org.exolab.jms.tools.db.RDBMSTool.create(RDBMSTool.java:164)
at org.exolab.jms.tools.db.RDBMSTool.create(RDBMSTool.java:110)
at org.exolab.jms.tools.db.DBTool.create(DBTool.java:142)
at org.exolab.jms.tools.db.DBTool.main(DBTool.java:256)
-------------------------------------------------------
This SF.Net email is sponsored by: NEC IT Guy Games.
Get your fingers limbered up and give it your best shot. 4 great events, 4
opportunities to win big! Highest score wins.NEC IT Guy Games. Play to
win an NEC 61 plasma display. Visit http://www.necitguy.com/?r=20