[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[xmlblaster] xmlBlaster with Firebird Database

To: xmlBlaster at server.xmlBlaster.org
Subject: [xmlblaster] xmlBlaster with Firebird Database
From: chris lau <ckl_88 at yahoo.ca>
Date: Wed, 15 Jun 2005 15:20:57 -0400 (EDT)
Reply-to: xmlblaster at server.xmlBlaster.org
Sender: owner-xmlblaster at server.xmlBlaster.org
Hi,

has anyone had any success with using Firebird 1.5 as
the database for persistent messages?

If so, how would I go about setting up the
xmlBlaster.properties file? Seems like there are alot
of properties to change.

I was trying to setup a web service on Tomcat (with
Firebird as the database) that publishes messages to
XmlBlaster running on the same machine. However, the
tomcat logs showed this error about no suitable
driver. No suitable driver for what?

ConnectQos is 
 <qos>
  <securityService type="htpasswd"
version="1.0"><![CDATA[
   <user>SYSTEM</user>
   <passwd>secret</passwd>
  ]]></securityService>
  <session name='client/SYSTEM' timeout='86400000'
maxSessions='10' clearSessions='false'
reconnectSameClientOnly='false'/>
  <queue relating='connection' maxEntries='10000000'
maxEntriesCache='1000'>
   <address type='IOR' dispatchPlugin='undef'>
    
   </address>
  </queue>
  <queue relating='subject'/>
  <queue relating='callback' maxEntries='1000'
maxEntriesCache='1000'/>
 </qos>
[Jun 15, 2005 11:47:11 AM INFO  http-8443-Processor24
XmlBlasterAccess] Loaded security plugin=htpasswd
version=1.0
[Jun 15, 2005 11:47:11 AM ERROR http-8443-Processor24
JdbcConnectionPool-jdbc:hsqldb:C:\Documents and
Settings\Default User\tmp\clientSYSTEM1118861231411] 
connecting to DB, error code : '0 : No suitable
driver' DB configuration details follow (check if the
DB is running)
[Jun 15, 2005 11:47:11 AM INFO  http-8443-Processor24
JdbcConnectionPool-jdbc:hsqldb:C:\Documents and
Settings\Default User\tmp\clientSYSTEM1118861231411]
diagnostics: initialize -url                 :
'jdbc:hsqldb:C:\Documents and Settings\Default
User\tmp\clientSYSTEM1118861231411'
[Jun 15, 2005 11:47:11 AM INFO  http-8443-Processor24
JdbcConnectionPool-jdbc:hsqldb:C:\Documents and
Settings\Default User\tmp\clientSYSTEM1118861231411]
diagnostics: initialize -user                : 'sa'
[Jun 15, 2005 11:47:11 AM INFO  http-8443-Processor24
JdbcConnectionPool-jdbc:hsqldb:C:\Documents and
Settings\Default User\tmp\clientSYSTEM1118861231411]
diagnostics: initialize -password            : ''
[Jun 15, 2005 11:47:11 AM INFO  http-8443-Processor24
JdbcConnectionPool-jdbc:hsqldb:C:\Documents and
Settings\Default User\tmp\clientSYSTEM1118861231411]
diagnostics: initialize -max number of conn  : '1'
[Jun 15, 2005 11:47:11 AM INFO  http-8443-Processor24
JdbcConnectionPool-jdbc:hsqldb:C:\Documents and
Settings\Default User\tmp\clientSYSTEM1118861231411]
diagnostics: initialize -conn busy timeout   : '90000'
[Jun 15, 2005 11:47:11 AM INFO  http-8443-Processor24
JdbcConnectionPool-jdbc:hsqldb:C:\Documents and
Settings\Default User\tmp\clientSYSTEM1118861231411]
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.mysql.jdbc.Driver:org.postgresql.Driver:de.sag.jdbc.adabasd.ADriver:com.sybase.jdbc2.jdbc.SybDriver:SQLite.JDBCDriver'
[Jun 15, 2005 11:47:11 AM INFO  http-8443-Processor24
JdbcConnectionPool-jdbc:hsqldb:C:\Documents and
Settings\Default User\tmp\clientSYSTEM1118861231411]
diagnostics: initialize -max. waiting Threads: '300'
java.sql.SQLException: No suitable driver
	at java.sql.DriverManager.getConnection(Unknown
Source)
	at java.sql.DriverManager.getConnection(Unknown
Source)
	at
org.xmlBlaster.util.queue.jdbc.JdbcConnectionPool.connect(JdbcConnectionPool.java:235)
	at
org.xmlBlaster.util.queue.jdbc.JdbcConnectionPool.initialize(JdbcConnectionPool.java:423)
	at
org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin.getJdbcQueueManagerCommonTable(JdbcQueueCommonTablePlugin.java:155)
	at
org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin.initialize(JdbcQueueCommonTablePlugin.java:217)
	at
org.xmlBlaster.util.queue.QueuePluginManager.getPlugin(QueuePluginManager.java:83)
	at
org.xmlBlaster.util.queue.QueuePluginManager.getPlugin(QueuePluginManager.java:59)
	at
org.xmlBlaster.util.queue.cache.CacheQueueInterceptorPlugin.initialize(CacheQueueInterceptorPlugin.java:266)
	at
org.xmlBlaster.util.queue.QueuePluginManager.getPlugin(QueuePluginManager.java:83)
	at
org.xmlBlaster.util.queue.QueuePluginManager.getPlugin(QueuePluginManager.java:73)
	at
org.xmlBlaster.client.XmlBlasterAccess.connect(XmlBlasterAccess.java:220)
	at
RequestHandler.doSendAppointment(RequestHandler.java:488)
	at RequestHandler.doPost(RequestHandler.java:155)
	at RequestHandler.doGet(RequestHandler.java:73)
	at
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
	at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:407)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825)
	at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:731)
	at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
	at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Unknown Source)
[Jun 15, 2005 11:47:11 AM ERROR http-8443-Processor24
org.xmlBlaster.util.queue.cache.CacheQueueInterceptorPlugin-connection:client/SYSTEM]
Could not initialize the persistent queue
'connection:client/SYSTEM'. Is the JDBC Driver jar
file in the CLASSPATH ? Is the DB up and running ? We
continue RAM based ...XmlBlasterException
errorCode=[resource.db.unavailable]
serverSideException=false
location=[org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin-connection:client/SYSTEM/type
'JDBC' version '1.0'] message=[#1.0.2
getJdbcCommonTableQueueManager: sql exception when
initializing the connection pool :
java.sql.SQLException: No suitable driver] [See URL
http://www.xmlblaster.org/xmlBlaster/doc/requirements/admin.errorcodes.listing.html#resource.db.unavailable]
The propery settings are:
 <queue relating='connection' maxEntries='10000000'
maxEntriesCache='1000'>
  <address type='IOR' dispatchPlugin='undef'>
   
  </address>
 </queue>
errorCode=resource.db.unavailable message=#1.0.2
getJdbcCommonTableQueueManager: sql exception when
initializing the connection pool :
java.sql.SQLException: No suitable driver
	at
org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin.getJdbcQueueManagerCommonTable(JdbcQueueCommonTablePlugin.java:179)
	at
org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin.initialize(JdbcQueueCommonTablePlugin.java:217)
	at
org.xmlBlaster.util.queue.QueuePluginManager.getPlugin(QueuePluginManager.java:83)
	at
org.xmlBlaster.util.queue.QueuePluginManager.getPlugin(QueuePluginManager.java:59)
	at
org.xmlBlaster.util.queue.cache.CacheQueueInterceptorPlugin.initialize(CacheQueueInterceptorPlugin.java:266)
	at
org.xmlBlaster.util.queue.QueuePluginManager.getPlugin(QueuePluginManager.java:83)
	at
org.xmlBlaster.util.queue.QueuePluginManager.getPlugin(QueuePluginManager.java:73)
	at
org.xmlBlaster.client.XmlBlasterAccess.connect(XmlBlasterAccess.java:220)
	at
RequestHandler.doSendAppointment(RequestHandler.java:488)
	at RequestHandler.doPost(RequestHandler.java:155)
	at RequestHandler.doGet(RequestHandler.java:73)
	at
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
	at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:407)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825)
	at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:731)
	at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526)
	at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Unknown Source)

Any help would be appreciated.

Thanks.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com
Follow-Ups:
- Re: [xmlblaster] xmlBlaster with Firebird Database
  - From: Michele <laghi at swissinfo.org>
Prev by Date: Re: Re: [xmlblaster] about CorbaConnection.cpp
Next by Date: Re: [xmlblaster] xmlBlaster with Firebird Database
Previous by thread: AW: [xmlblaster] SocketDriver
Next by thread: Re: [xmlblaster] xmlBlaster with Firebird Database
Index(es):
- Date
- Thread