Can it be that the gettable return no tables, then you get a nullpointer?
Here is some information from Appajee on how to attach at debugger to a plugin:
----------------------
At this point, its debugger time!! :-)
Assuming you're using Eclipse as your Java IDE, following
information may be useful in debugging your plug-in :
The java plugin server is typically started by the armonitor, which
also starts all other ARSystem processes. The armonitor starts all
processes listed in a file <serverinstallfolder>/conf/armonitor.conf
or cfg. So instead of the pain of restarting the whole ARServer while
debugging or plugin development process, you can just comment out (put
a # at the start of the line) the line that looks like below from your
armonitor.conf file.
"C:\Program Files\Java\jre1.6.0_03\bin\java" -Xmx512m
-classpath "...whatever... arpluginsvr71.jar"
com.bmc.arsys.pluginsvr.ARPluginServerMain -x YourServerHere -i
"YourInstallDir" -m
Restart server/the service. So monitor won’t start java plugin server
anymore. Now you can start the java plugin server from command line.
For that you would just copy the command line from the armonitor.cfg
and use in the command prompt.
Now for debugging, we mostly use the jvm remote debugging mechanism.
You would add this jvm debugging options (below) to the java command
line
-Xdebug -Xrunjdwp:transport=dt_socket,address=8000,suspend=n,server=y
to get the command line as:
"C:\Program Files\Java\jre1.6.0_03\bin\java" -Xmx512m
-Xrunjdwp:transport=dt_socket,address=8000,suspend=n,server=y
-classpath "...whatever... arpluginsvr71.jar"
com.bmc.arsys.pluginsvr.ARPluginServerMain -x YourHostNameHere -i
"YourInstallDir" -m
To attach the Eclipse debugger to the process, it has to be told which
machine the external program is running on and what port it can use to
communicate with it. This information is entered through the Launcher
dialog. Select from the main menu Run, Debug to open the Launcher
dialog specific to debugging. Select Remote Java Application as the
configuration type and click New. This configuration information will
be used by the debugger to connect to the plugin server jvm. Enter the
following configuration information:
Name: Java Plugin Server
Project: My Plugin Project
Connection Type: Standard (Socket Attach)
Connection Properties: Host: localhost
Connection Properties: Port: 8000
Setup breakpoints in your plugin as needed, and click Debug to start
up the debugger. Key things here are matching up the host name and
debug port (8000 in my example) between your Java command line and the
eclipse debugger.
Hope that helps.
Appajee
----------------------
Regards,
Jarl
2009/6/30 Jonas Stumph Stevnsvig <jonas.stumph.stevns...@bec.dk>:
> **
> 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: 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
> jonas.stumph.stevns...@bec.dk
> becrem...@bec.dk
>
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
