Why not just use AIE? It has a DB2 integration and you are not limited to the 15 character request ID field.
Sean From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Jonas Stumph Stevnsvig Sent: Tuesday, August 18, 2009 12:52 PM To: [email protected] Subject: SV: Java ARDBC plugin failing with multiple instances "No suitable driver found for " ** Hi - I'm still messing with this problem. I just stumbled across this: * Note: If you are using the same class as two different plugins identified by two * different ids, then these will not be able to share any resources as they are * loaded by two different classloaders, unless they were grouped in a plugingroup * in the plugin configuration, in which case they will be able to share resources. in this file: http://svn.arswiki.org/arapi/releases/win71/src/javaplugins/samplesrc/java/com/bmc/arsys/plugin/sample/ARDBCSample.java has anyone got an idea how to group the plugins in pluginsvr_config.xml?? <plugingroup> <plugin> ... </plugin> <plugin> ... </plugin> </plugingroup> does not load anything at all - nor does it give an error... I wish there was a DTD i could refer to. Med venlig hilsen Jonas Stumph Stevnsvig Remedy Udvikler BEC Kompetence Centret Telefon (+45) 46 38 20 08 Mobil (+45) 61 56 20 08 [email protected] Til remedy spørgsmål: [email protected] BEC - det fælles it-hus, der gør forskellen for finansielle virksomheder ________________________________ Fra: Action Request System discussion list(ARSList) [mailto:[email protected]] På vegne af Jonas Stumph Stevnsvig Sendt: 14. august 2009 14:32 Til: [email protected] Emne: Java ARDBC plugin failing with multiple instances "No suitable driver found for " ** Hi listers, I really hope one of you has a solution for me here. We have developed an ARDBC 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 _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
