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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.