RE: Did someone succeed in running 0.7.7-dev version on non-derby db?

MySQL works for me. I'm using version 4.0.12 of
the server, and 3.0.6 of the jdbc driver.

  <DatabaseConfiguration>
    <RdbmsDatabaseConfiguration
      driver="com.mysql.jdbc.Driver" 
      url="jdbc:mysql://myhost/openjms"
      user="openjms" 
      password="openjms"/>
  </DatabaseConfiguration>


> -----Original Message-----
> From: openjms-user-admin-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org 
> [mailto:openjms-user-admin-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org] On Behalf 
> Of Marco Lettere
> Sent: Friday, 6 May 2005 8:27 PM
> To: [email protected]
> Subject: [openjms-user] Did someone succeed in running 
> 0.7.7-dev version on non-derby db?
> 
> 
> 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(NonRegisteringDriv
> er.java:411)
>         at 
> org.apache.commons.dbcp.DriverConnectionFactory.createConnecti
> on(DriverConne
> ctionFactory.java:82)
>         at 
> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(P
> oolableConnect
> ionFactory.java:300)
>         at 
> org.apache.commons.dbcp.BasicDataSource.validateConnectionFact
> ory(BasicDataS
> ource.java:838)
>         at 
> org.apache.commons.dbcp.BasicDataSource.createDataSource(Basic
> DataSource.jav
> a:821)
>         at 
> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDat
> aSource.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(NonRegisteringDriv
> er.java:411)
>         at 
> org.apache.commons.dbcp.DriverConnectionFactory.createConnecti
> on(DriverConne
> ctionFactory.java:82)
>         at 
> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(P
> oolableConnect
> ionFactory.java:300)
>         at 
> org.apache.commons.dbcp.BasicDataSource.validateConnectionFact
> ory(BasicDataS
> ource.java:838)
>         at 
> org.apache.commons.dbcp.BasicDataSource.createDataSource(Basic
> DataSource.jav
> a:821)
>         at 
> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDat
> aSource.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 
> _______________________________________________
> openjms-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/openjms-user
> 



-------------------------------------------------------
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