Hi listers,
I really hope one of you has a solution for me here.
We have developed an SRDBC driver for connection to a DB2 database. in the
production environment we need to connect to two different databases, so I have
configured two <plugins> in pluginsvr_config.xml:
<plugin>
<name>CD99</name>
<type>ARDBC</type>
<code>JAVA</code>
<filename>C:/Program Files/BMC
Software/ARSystem/Arserver/api/javaplugins/BECplugins/arapi.jar</filename>
<classname>com.bmc.arsys.plugins.jdbc.JdbcDataSource</classname>
<pathelement
type="location">C:/Programmer/IBM/SQLLIB/java/db2java.zip</pathelement>
<userDefined>
<url>jdbc:db2:CD99</url>
<driver>COM.ibm.db2.jdbc.app.DB2Driver</driver>
<user>someUser</user>
<password>somePassword</password>
<dbtableprefix>T</dbtableprefix>
<dbtablecreator>CD99</dbtablecreator>
</userDefined>
</plugin>
<plugin>
<name>OD99</name>
<type>ARDBC</type>
<code>JAVA</code>
<filename>C:/Program Files/BMC
Software/ARSystem/Arserver/api/javaplugins/BECplugins/arapi.jar</filename>
<classname>com.bmc.arsys.plugins.jdbc.JdbcDataSource</classname>
<pathelement
type="location">C:/Programmer/IBM/SQLLIB/java/db2java.zip</pathelement>
<userDefined>
<url>jdbc:db2:OD99</url>
<driver>COM.ibm.db2.jdbc.app.DB2Driver</driver>
<user>someOtherUser</user>
<password>someOtherpassword</password>
<dbtableprefix>TD</dbtableprefix>
<dbtablecreator>OD99</dbtablecreator>
</userDefined>
</plugin>
If I enable one of them, I can connect with no problem whatsoever, however; as
soon as I enable the second driver, It gives me the following error:
2009-08-14 14:02:10,676 INFO [pool-2-thread-1]
com.bmc.arsys.pluginsvr.plugins.g (?:?) - Attempting to Create an instance of
the plugin CD99
2009-08-14 14:02:10,676 INFO [pool-2-thread-1]
com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - <CD99>initialize()
2009-08-14 14:02:10,755 INFO [main] com.bmc.arsys.pluginsvr.ARPluginServerMain
(?:?) - AR System Plugin Server Version 7.5.00 Patch 002 200906100308
2009-08-14 14:02:11,083 INFO [pool-2-thread-1]
com.bmc.arsys.pluginsvr.plugins.g (?:?) - Thread 11 successfully created an
instance of CD99
2009-08-14 14:02:11,098 INFO [pool-2-thread-1]
com.bmc.arsys.pluginsvr.plugins.g (?:?) - Attempting to Create an instance of
the plugin OD99
2009-08-14 14:02:11,098 INFO [pool-2-thread-1]
com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - <OD99>initialize()
No suitable driver found for jdbc:db2:OD992009-08-14 14:02:11,114 INFO
[pool-2-thread-1] com.bmc.arsys.pluginsvr.plugins.g (?:?) - Thread 11
successfully created an instance of OD99
2009-08-14 14:02:11,114 INFO [pool-2-thread-1] com.bmc.arsys.pluginsvr.d.b
(?:?) - Done iniPlugins for thread: 11
2009-08-14 14:02:11,114 INFO [pool-2-thread-1] com.bmc.arsys.pluginsvr.d.b
(?:?) - Java plug-in server has initialized plug-ins for all 1 core threads.
The server is ready to receive RPC calls.
Java plug-in server has initialized plug-ins for all 1 core threads. The server
is ready to receive RPC calls.
I have a feeling that it has something to do with a limitation of the driver,
but I am not sure - any bits and bids are most welcome
Cheers
Jonas Stevnsvig
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
