Re: [xmlblaster] debugging Firebird storage

[Michele <michele at laghi.eu>]

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