Re: 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]> 
Yes, Tim.
We made it to work. It was a "concurrent" activity between us and our 
sysadmin that made our openjms.xml obsolete. :-)
Once fixed, everything seems to be working correctly with mysql.
Thank you anyway for the quick response.
M.

Tim Anderson wrote:

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