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 <[EMAIL PROTECTED]> To: [email protected] 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) > > >
