Hi again, their trial download link appears broken. I'd still like to try to get a hole through with the java plugin. any help is appreciated
with 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] ________________________________ Fra: Action Request System discussion list(ARSList) [mailto:[email protected]] På vegne af Frank Caruso Sendt: 30. juni 2009 11:33 Til: [email protected] Emne: Re: Java ARDBC ** 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]<mailto:[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 . 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<http://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]<mailto:[email protected]> [email protected]<mailto:[email protected]> _Platinum Sponsor: [email protected]<mailto:[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"
