I remember seeing your past postings but do not recall why you were building the plugin. However, if you are trying to build a plugin to connect to a database I would highly recommend using the plugins from James Croom ( http://croomconsulting.com/). I used them at my last company and they worked perfectly. Also, the development time it would've taken to build the plugin would've far exceeded the purchase price.
Frank On Tue, Jun 30, 2009 at 11:48 AM, Jonas Stumph Stevnsvig < [email protected]> wrote: > ** Hi listers > > As some of you may have noticed - I've been battling to get some ARDBC > connections up and running. After plenty of reading and advice, and > considerable problems with our C developer tools, I've decided to switch to > Java. I started off by downloading the 7.1 Java ARDBC/filter plugin sample > from > *http://developer.bmc.com/communities/docs/DOC-2548*<http://developer.bmc.com/communities/docs/DOC-2548>. > Unfortunately I cannot get the code to work as intended. I have tried with > several different JDBC drivers, and the result is always the same: > > Here is the plugin > <plugin> > <name>JdbcDataSourceDBIX</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:/Program > Files/BMC > Software/ARSystem/Arserver/api/javaplugins/JDBCdrivers/jtds.jar</pathelement> > --> > <pathelement > type="location">C:/Programmer/IBM/SQLLIB/TOOLS/db2jdbcext.jar</pathelement> > <userDefined> > <url>jdbc:db2:TD99</url> > <!-- > <driver>net.sourceforge.jtds.jdbc.Driver</driver> --> > > <driver>COM.ibm.db2.jdbc.app.DB2Driver</driver> > <user>XXXX</user> > <password>yyyy</password> > > </userDefined> > </plugin> > > The thread quits with a nullPointerException, when the getTables method is > called, which leads me to think that there is something going wrong in the > initialize function. Unfortunately initialize is called so soon after > starting the server, that i cannot connect the debugger fast enough to debug > it. > Here is a snippet from the logs which puzzles me: > > 2009-06-30 09:23:31,695 INFO [main] com.bmc.arsys.pluginsvr.plugins.g > (?:?) - No static init routine found, skipping init call - > JdbcDataSourceDBIX > 2009-06-30 09:23:31,695 DEBUG [main] com.bmc.arsys.pluginsvr.plugins.g > (?:?) - Failed found init plugin JdbcDataSourceDBIX > 2009-06-30 09:23:31,695 INFO [main] com.bmc.arsys.pluginsvr.plugins.g > (?:?) - Done to call init plugin JdbcDataSourceDBIX > > Is it looking for an init routine? I can't seem to find any references in > the API documentation, other than the initialize method!? Or is it skipping > the method it found? > > I have not modified the code found on the bmc developer site, and as far as > I can see others have used it successfully - what am I doing wrong? > > > And here the logs for that attempt: > > 2009-06-30 09:23:31,054 INFO [main] com.bmc.arsys.pluginsvr.f (?:?) - > Loading the Configuration File ::* > file:/C:/Program%20Files/BMC%20Software/ARSystem/pluginsvr/pluginsvr_config.xml > * > 2009-06-30 09:23:31,070 ERROR [main] com.bmc.arsys.pluginsvr.f (?:?) - Java > plug-in server does not support C plug-ins. Contact Customer Support for > details. > 2009-06-30 09:23:31,070 DEBUG [main] com.bmc.arsys.pluginsvr.f (?:?) - > Plugin Accessible Configured Values: > 2009-06-30 09:23:31,070 DEBUG [main] com.bmc.arsys.pluginsvr.f (?:?) - port > 9999 > 2009-06-30 09:23:31,070 DEBUG [main] com.bmc.arsys.pluginsvr.f (?:?) - > numCoreThreads 5 > 2009-06-30 09:23:31,211 WARN [main] > org.apache.commons.configuration.ConfigurationFactory$FileConfigurationFactory > (ConfigurationFactory.java:530) - Could not load optional configuration > arsys_api.xml > 2009-06-30 09:23:31,304 DEBUG [main] com.bmc.arsys.pluginsvr.c.a (?:?) - > os.name: Windows 2003 > 2009-06-30 09:23:31,304 DEBUG [main] com.bmc.arsys.pluginsvr.c.a (?:?) - > os.arch: x86 > 2009-06-30 09:23:31,304 DEBUG [main] com.bmc.arsys.pluginsvr.c.a (?:?) - > java.vendor: Sun Microsystems Inc. > 2009-06-30 09:23:31,304 DEBUG [main] com.bmc.arsys.pluginsvr.c.a (?:?) - > Constructor ARPluginServerEncryptionInfo > 2009-06-30 09:23:31,648 INFO [main] com.bmc.arsys.pluginsvr.plugins.g > (?:?) - Loading all Java Plugins and Plugin sets > 2009-06-30 09:23:31,648 INFO [main] com.bmc.arsys.pluginsvr.plugins.g > (?:?) - Attempting to load Java Plugin JdbcDataSourceDBIX > 2009-06-30 09:23:31,648 INFO [main] com.bmc.arsys.pluginsvr.plugins.g > (?:?) - Number of URLs for plugin JdbcDataSourceDBIX is 2 > 2009-06-30 09:23:31,664 INFO [main] com.bmc.arsys.pluginsvr.plugins.g > (?:?) - URL1: * > file:/C:/Program%20Files/BMC%20Software/ARSystem/Arserver/api/javaplugins/BECplugins/arapi.jar > * > 2009-06-30 09:23:31,664 INFO [main] com.bmc.arsys.pluginsvr.plugins.g > (?:?) - URL2: *file:/C:/Programmer/IBM/SQLLIB/TOOLS/db2jdbcext.jar* > 2009-06-30 09:23:31,695 INFO [main] com.bmc.arsys.pluginsvr.plugins.g > (?:?) - No static init routine found, skipping init call - > JdbcDataSourceDBIX > 2009-06-30 09:23:31,695 DEBUG [main] com.bmc.arsys.pluginsvr.plugins.g > (?:?) - Failed found init plugin JdbcDataSourceDBIX > 2009-06-30 09:23:31,695 INFO [main] com.bmc.arsys.pluginsvr.plugins.g > (?:?) - Done to call init plugin JdbcDataSourceDBIX > 2009-06-30 09:23:31,695 INFO [main] com.bmc.arsys.pluginsvr.plugins.g > (?:?) - Successfully loaded Java Plugin JdbcDataSourceDBIX > 2009-06-30 09:23:31,695 INFO [main] com.bmc.arsys.pluginsvr.d.a (?:?) - > ARPluginSvrThreadPoolExecutor: coreT:5 maxT:10 ThreadAliveIdleInSecond:0 > 2009-06-30 09:23:31,711 INFO [main] com.bmc.arsys.pluginsvr.d.b (?:?) - > Java plug-in server is initializing all plug-ins for 5 core threads. Please > wait ... > 2009-06-30 09:23:31,711 INFO [pool-2-thread-5] com.bmc.arsys.pluginsvr.d.b > (?:?) - Will iniPlugins for thread: 16 Thread[pool-2-thread-5,5,main] > 2009-06-30 09:23:31,711 INFO [pool-2-thread-4] com.bmc.arsys.pluginsvr.d.b > (?:?) - Will iniPlugins for thread: 15 Thread[pool-2-thread-4,5,main] > 2009-06-30 09:23:31,711 INFO [pool-2-thread-3] com.bmc.arsys.pluginsvr.d.b > (?:?) - Will iniPlugins for thread: 14 Thread[pool-2-thread-3,5,main] > 2009-06-30 09:23:31,726 INFO [pool-2-thread-2] com.bmc.arsys.pluginsvr.d.b > (?:?) - Will iniPlugins for thread: 13 Thread[pool-2-thread-2,5,main] > 2009-06-30 09:23:31,726 INFO [pool-2-thread-1] com.bmc.arsys.pluginsvr.d.b > (?:?) - Will iniPlugins for thread: 12 Thread[pool-2-thread-1,5,main] > 2009-06-30 09:23:31,742 INFO [pool-2-thread-5] > com.bmc.arsys.pluginsvr.plugins.g (?:?) - Attempting to Create an instance > of the plugin JdbcDataSourceDBIX > 2009-06-30 09:23:31,742 INFO [pool-2-thread-5] > com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - > <JdbcDataSourceDBIX>initialize() > 2009-06-30 09:23:31,742 INFO [pool-2-thread-5] > com.bmc.arsys.pluginsvr.plugins.g (?:?) - Thread 16 successfully created an > instance of JdbcDataSourceDBIX > 2009-06-30 09:23:31,742 INFO [pool-2-thread-5] com.bmc.arsys.pluginsvr.d.b > (?:?) - Done iniPlugins for thread: 16 > 2009-06-30 09:23:31,742 INFO [pool-2-thread-1] > com.bmc.arsys.pluginsvr.plugins.g (?:?) - Attempting to Create an instance > of the plugin JdbcDataSourceDBIX > 2009-06-30 09:23:31,742 INFO [pool-2-thread-1] > com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - > <JdbcDataSourceDBIX>initialize() > 2009-06-30 09:23:31,742 INFO [pool-2-thread-1] > com.bmc.arsys.pluginsvr.plugins.g (?:?) - Thread 12 successfully created an > instance of JdbcDataSourceDBIX > 2009-06-30 09:23:31,742 INFO [pool-2-thread-1] com.bmc.arsys.pluginsvr.d.b > (?:?) - Done iniPlugins for thread: 12 > 2009-06-30 09:23:31,742 INFO [pool-2-thread-2] > com.bmc.arsys.pluginsvr.plugins.g (?:?) - Attempting to Create an instance > of the plugin JdbcDataSourceDBIX > 2009-06-30 09:23:31,742 INFO [pool-2-thread-2] > com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - > <JdbcDataSourceDBIX>initialize() > 2009-06-30 09:23:31,742 INFO [pool-2-thread-2] > com.bmc.arsys.pluginsvr.plugins.g (?:?) - Thread 13 successfully created an > instance of JdbcDataSourceDBIX > 2009-06-30 09:23:31,742 INFO [pool-2-thread-2] com.bmc.arsys.pluginsvr.d.b > (?:?) - Done iniPlugins for thread: 13 > 2009-06-30 09:23:31,742 INFO [pool-2-thread-3] > com.bmc.arsys.pluginsvr.plugins.g (?:?) - Attempting to Create an instance > of the plugin JdbcDataSourceDBIX > 2009-06-30 09:23:31,742 INFO [pool-2-thread-3] > com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - > <JdbcDataSourceDBIX>initialize() > 2009-06-30 09:23:31,757 INFO [pool-2-thread-3] > com.bmc.arsys.pluginsvr.plugins.g (?:?) - Thread 14 successfully created an > instance of JdbcDataSourceDBIX > 2009-06-30 09:23:31,757 INFO [pool-2-thread-3] com.bmc.arsys.pluginsvr.d.b > (?:?) - Done iniPlugins for thread: 14 > 2009-06-30 09:23:31,757 INFO [pool-2-thread-4] > com.bmc.arsys.pluginsvr.plugins.g (?:?) - Attempting to Create an instance > of the plugin JdbcDataSourceDBIX > 2009-06-30 09:23:31,757 INFO [pool-2-thread-4] > com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - > <JdbcDataSourceDBIX>initialize() > 2009-06-30 09:23:31,757 INFO [pool-2-thread-4] > com.bmc.arsys.pluginsvr.plugins.g (?:?) - Thread 15 successfully created an > instance of JdbcDataSourceDBIX > 2009-06-30 09:23:31,757 INFO [pool-2-thread-4] com.bmc.arsys.pluginsvr.d.b > (?:?) - Done iniPlugins for thread: 15 > 2009-06-30 09:23:31,757 INFO [pool-2-thread-4] com.bmc.arsys.pluginsvr.d.b > (?:?) - Java plug-in server has initialized plug-ins for all 5 core threads. > The server is ready to receive RPC calls. > 2009-06-30 09:23:31,820 INFO [main] > com.bmc.arsys.pluginsvr.ARPluginServerMain (?:?) - AR System Plugin Server > Version 7.5.00 Patch 001 200903100038 > > I'm running ARS 7.5 on win2k3 > > Any help is much appreciated. > > best regards, > > > > *Jonas Stumph Stevnsvig* > Remedy Developer > *BEC* Competence Centre > Phone (+45) 46 38 20 08 > Mobile (+45) 61 56 20 08 > [email protected] > [email protected] > > > _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"
