I have in my CLASSPATH
/home/oracle/oracle/product/10.2.0/db_1/jdbc/lib/ojdbc14_g.jar
using in xmlBlaster.properties
JdbcDriver.drivers=oracle.jdbc.driver.OracleDriver
and an url
JdbcStorage[Oracle]=org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin,\
url=jdbc:oracle:thin:@localhost:1521:xmlb,\
user=xmlblaster,\
password=,\
connectionPoolSize=1,\
connectionBusyTimeout=9,\
maxWaitingThreads=300,\
tableNamePrefix=XB_,\
entriesTableName=ENTRIES,\
dbAdmin=true
StoragePlugin[JDBC][1.0]=${JdbcStorage[Oracle]}
QueuePlugin[JDBC][1.0]=${JdbcStorage[Oracle]}
and this works fine for me,
regards
Marcel
[EMAIL PROTECTED] wrote:
Hello
I try to use Oracle as persistence layer. I'v add the ojdbc14.jar in
the lib directory of xmlblaster. I still get the following error : (I
tried with SQLServer and got the same error)
java.sql.SQLException: No suitable driver found for
jdbc:oracle:thin:@benotesdev:1521:orcl
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
org.xmlBlaster.util.queue.jdbc.JdbcConnectionPool.addConnectionToPool(JdbcConnectionPool.java:362)
at
org.xmlBlaster.util.queue.jdbc.JdbcConnectionPool.connect(JdbcConnectionPool.java:392)
at
org.xmlBlaster.util.queue.jdbc.JdbcConnectionPool.initialize(JdbcConnectionPool.java:613)
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:292)
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:127)
at org.xmlBlaster.Main.init(Main.java:185)
at org.xmlBlaster.Main.init(Main.java:122)
at org.xmlBlaster.Main.main(Main.java:604)
Jun 25, 2007 4:40:10 PM SEVERE 10-XmlBlaster.MainThread RL0
org.xmlBlaster.util.queue.cache.CacheQueueInterceptorPlugin
initialize:
subject:/node/xmlBlaster_10_110_21_7_3412/client/__RequestBroker_in
ternal[xmlBlaster_10_110_21_7_3412]: Could not initialize the
persistent queue
'subject:/node/xmlBlaster_10_110_21_7_3412/client/__RequestBroker_internal[xmlBlaster_10_110_21_7_3412]'.
Is the JDBC Dri
ver jar file in the CLASSPATH ? Is the DB up and running ? We continue
RAM based ...XmlBlasterException errorCode=[resource.db.unavailable]
serverSideException=true location=[org.xmlBlaster.util.queue
.jdbc.JdbcQueueCommonTablePlugin-subject:/node/xmlBlaster_10_110_21_7_3412/client/__RequestBroker_internal[xmlBlaster_10_110_21_7_3412]/type
'JDBC' version '1.0'] message=[#exported getJdbcCommonTable
QueueManager: sql exception when initializing the connection pool :
java.sql.SQLException: No suitable driver found for
jdbc:oracle:thin:@benotesdev:1521:orcl] [See URL
http://www.xmlblaster.org/xmlBl
aster/doc/requirements/admin.errorcodes.listing.html#resource.db.unavailable]
The propery settings are:
queue relating='subject'/
errorCode=resource.db.unavailable message=#exported
getJdbcCommonTableQueueManager: sql exception when initializing the
connection pool : java.sql.SQLException: No suitable driver found for
jdbc:oracl
e:thin:@benotesdev:1521:orcl
at
org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin.getJdbcQueueManagerCommonTable(JdbcQueueCommonTablePlugin.java:185)
As another trial, I've add the ojdbc14.jar file to the CLASSPATH
directory. This gave the same problem.
What am I doing wrong ?
Best regards
*
Koen Boutsen *
--
Marcel Ruff
http://www.xmlBlaster.org
