[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [xmlblaster] debugging Firebird storage
Hi Brad,
if you are still having problems with your Firebird setup, please email me (address located at the Hall of Fame link on the xmlblaster.org website), and I can send you a modified basic xmlBlaster.properties file for Firebird.
Thanks.
----- Original Message ----
From: Michele <michele at laghi.eu>
To: xmlblaster at server.xmlBlaster.org
Sent: Tuesday, October 10, 2006 12:14:40 AM
Subject: Re: [xmlblaster] debugging Firebird storage
Hi Brad,
the logs show that you are still using hsqldb, probably with the url of
your firebird settings.
If you configured in your xmlBlaster.properties:
JdbcStorage[Firebird]=org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin,\
url=jdbc:firebirdsql:localhost/3050:c:/Firebird/Data/mydb.fdb,\
user=user,\
password=password,\
connectionPoolSize=1,\
connectionBusyTimeout=90000,\
maxWaitingThreads=300,\
tableNamePrefix=XB_,\
entriesTableName=ENTRIES,\
dbAdmin=true
(with your data),
you also need to set:
StoragePlugin[JDBC][1.0]=${JdbcStorage[Firebird]
(and uncomment all other StoragePlugin[JDBC][1.0])
and
QueuePlugin[JDBC][1.0]=${JdbcStorage[Firebird]}
(and uncomment all other QueuePlugin[JDBC][1.0])
Probably your xmlBlaster.properties has still a
QueuePlugin[JDBC][1.0]=${JdbcStorage[hsbqdb]} enabled.
As far as I know there is no possibility to get out more information
from the plugin at this location.
Regards
Michele Laghi
Brad Clements wrote:
> I am trying to use Firebird for storage, and have followed the instructions in
> setting up properties file (xmlblaster version 1.3)
>
> I've also checked the mailing list, and my .properties file looks almost exacly like
> the one posted by chris lau (except it has Firebird instead of firebird)
>
> I copied jaybird-full-2.1.0.jar to the lib directory.
>
> I tried both the old and new format for the database url, and I get the same error
> in both cases. However I can use Quantum DB plugin in Eclipse to connect to the
> database.
>
> How can I get more information out of the plugin so I can see what it's
> complaining? tcpdump doesn't show the client even trying to connect to the
> firebird server.
>
> thanks
>
>
>
>
> Oct 9, 2006 12:20:26 PM SEVERE 10-XmlBlaster.MainThread RL0 org.xmlBlaster.util.queue.jdbc.JdbcConnectionPool initialize: connecting to DB, error code : '0 : SOO10 Invalid argument in JDBC call' DB configuration details follow (check if the DB is running)
> Oct 9, 2006 12:20:26 PM INFO 10-XmlBlaster.MainThread RL0 org.xmlBlaster.util.queue.jdbc.JdbcConnectionPool initialize: diagnostics: initialize -url : 'jdbc:firebirdsql://localhost:3050/usr/database/xmlblaster.gdb'
> Oct 9, 2006 12:20:26 PM INFO 10-XmlBlaster.MainThread RL0 org.xmlBlaster.util.queue.jdbc.JdbcConnectionPool initialize: diagnostics: initialize -user : 'sysdba'
> Oct 9, 2006 12:20:26 PM INFO 10-XmlBlaster.MainThread RL0 org.xmlBlaster.util.queue.jdbc.JdbcConnectionPool initialize: diagnostics: initialize -password : 'redacted'
> Oct 9, 2006 12:20:26 PM INFO 10-XmlBlaster.MainThread RL0 org.xmlBlaster.util.queue.jdbc.JdbcConnectionPool initialize: diagnostics: initialize -max number of conn : '1'
> Oct 9, 2006 12:20:26 PM INFO 10-XmlBlaster.MainThread RL0 org.xmlBlaster.util.queue.jdbc.JdbcConnectionPool initialize: diagnostics: initialize -conn busy timeout : '90000'
> Oct 9, 2006 12:20:26 PM INFO 10-XmlBlaster.MainThread RL0 org.xmlBlaster.util.queue.jdbc.JdbcConnectionPool initialize: diagnostics: initialize -driver list : 'org.hsqldb.jdbcDriver:org.ldbc.jdbc.jdbcDriver:com.mckoi.JDBCDriver:sun.jdbc.odbc.JdbcOdbcDriver:ORG.as220.tinySQL.dbfFileDriver:oracle.jdbc.driver.OracleDriver:com.microsoft.jdbc.sqlserver.SQLServerDriver:com.microsoft.sqlserver.jdbc.SQLServerDriver:com.mysql.jdbc.Driver:org.postgresql.Driver:org.firebirdsql.jdbc.FBDriver:de.sag.jdbc.adabasd.ADriver:com.sybase.jdbc2.jdbc.SybDriver:SQLite.JDBCDriver'
> Oct 9, 2006 12:20:26 PM INFO 10-XmlBlaster.MainThread RL0 org.xmlBlaster.util.queue.jdbc.JdbcConnectionPool initialize: diagnostics: initialize -max. waiting Threads: '300'
> java.sql.SQLException: SOO10 Invalid argument in JDBC call
> at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
> at org.hsqldb.jdbcDriver.connect(Unknown Source)
> at java.sql.DriverManager.getConnection(DriverManager.java:525)
> at java.sql.DriverManager.getConnection(DriverManager.java:171)
> at org.xmlBlaster.util.queue.jdbc.JdbcConnectionPool.addConnectionToPool(JdbcConnectionPool.java:263)
> at org.xmlBlaster.util.queue.jdbc.JdbcConnectionPool.connect(JdbcConnectionPool.java:286)
> at org.xmlBlaster.util.queue.jdbc.JdbcConnectionPool.initialize(JdbcConnectionPool.java:490)
> at org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin.getJdbcQueueManagerCommonTable(JdbcQueueCommonTablePlugin.java:161)
> at org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin.initialize(JdbcQueueCommonTablePlugin.java:223)
> at org.xmlBlaster.util.queue.QueuePluginManager.getPlugin(QueuePluginManager.java:84)
> at org.xmlBlaster.util.queue.QueuePluginManager.getPlugin(QueuePluginManager.java:60)
> at org.xmlBlaster.util.queue.cache.CacheQueueInterceptorPlugin.initialize(CacheQueueInterceptorPlugin.java:283)
> at org.xmlBlaster.util.queue.QueuePluginManager.getPlugin(QueuePluginManager.java:84)
> at org.xmlBlaster.util.queue.QueuePluginManager.getPlugin(QueuePluginManager.java:74)
> at org.xmlBlaster.authentication.SubjectInfo.createSubjectQueue(SubjectInfo.java:275)
> at org.xmlBlaster.authentication.SubjectInfo.toAlive(SubjectInfo.java:247)
> at org.xmlBlaster.authentication.Authenticate.unsecureCreateSession(Authenticate.java:160)
> at org.xmlBlaster.engine.RequestBroker.<init>(RequestBroker.java:233)
> at org.xmlBlaster.engine.XmlBlasterImpl.<init>(XmlBlasterImpl.java:68)
> at org.xmlBlaster.authentication.Authenticate.<init>(Authenticate.java:98)
> at org.xmlBlaster.engine.runlevel.RunlevelManager.initPluginManagers(RunlevelManager.java:110)
> at org.xmlBlaster.Main.init(Main.java:180)
> at org.xmlBlaster.Main.<init>(Main.java:117)
> at org.xmlBlaster.Main.main(Main.java:598)
>
>
>