From: NageshwarR at PLANETASIA.COM (Nageshwar Rao)
Date: Thu, 2 Jun 2005 14:59:11 +0530 
Subject: [Pljava-dev] Accessing OpenJMS Queue from PLJava
Message-ID: <3214799999CED64882731155DB0AAD92024BC2CA@MLSW00103>

Hi,
 We are facing some problems in Pljava trigger.
 
Problem
---------
In our application, we have written a trigger to call a java program. In the
program the triggeredData is converted to string and writen to a OpenJMS
queue1(preconfigured) as message. We are accessing OpenJMS queue via JNDI
InitialContextFactory. The necessary jar files (jndi-1.2.1.jar,
commons-logging-1.0.4.jar, jms-1.0.2a.jar, exolabcore-0.3.7.jar,
openjms-client-0.7.6.1.jar) are installed and add to the PLjava classpath as
per the PLjava documentation. 
 
When the trigger fires, we are getting NoIntialContextException.
 
javax.naming.NoInitialContextException: Cannot instantiate class:
org.exolab.jms.jndi.InitialContextFactory [Root exception is
java.lang.ClassNotFoundException: org.exolab.jms.jndi.InitialContextFactory]
        at
javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:652)
        at
javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:243)
        at javax.naming.InitialContext.init(InitialContext.java:219)
        at javax.naming.InitialContext.<init>(InitialContext.java:195)
        at
com.ge.gis.pgtrigger.EventTrigger.checkinsert(EventTrigger.java:96)
Caused by: java.lang.ClassNotFoundException:
org.exolab.jms.jndi.InitialContextFactory
        at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:219)
        at
com.sun.naming.internal.VersionHelper12.loadClass(VersionHelper12.java:42)
        at
javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:649)
        ... 4 more
 
What can be the possible cause for the exception ?
 
PLjava SQL commands.
----------------------
 
select sqlj.install_jar('file:/var/lib/pljava/gis.jar','gis',true);
select sqlj.install_jar('file:/var/lib/pljava/jndi-1.2.1.jar','jndi',true);
select
sqlj.install_jar('file:/var/lib/pljava/commons-logging-1.0.4.jar','logging',
true);
select sqlj.install_jar('file:/var/lib/pljava/jms-1.0.2a.jar','jms',true);
select
sqlj.install_jar('file:/var/lib/pljava/exolabcore-0.3.7.jar','exolabcore',tr
ue);
select
sqlj.install_jar('file:/var/lib/pljava/openjms-client-0.7.6.1.jar','openjms'
,true);
select sqlj.install_jar('file:/var/lib/pljava/dom4j-1.4.jar','dom4j',true);
select
sqlj.set_classpath('public','exolabcore:openjms:jms:jndi:gis:dom4j:logging')
;
 
create or replace function public.funcinsertevent() returns trigger as
'com.ge.gis.pgtrigger.EventTrigger.checkinsert' language 'java' volatile;
create or replace function public.getnodedata() returns trigger as
'com.ge.gis.pgtrigger.NodeDataChangedTrigger.addNodeData' language 'java'
volatile; create trigger nodetrigger after insert on public.node for each
row execute procedure public.getnodedata(); create trigger trigginsertevent
after insert on public.events for each row execute procedure
public.funcinsertevent();
 
 
Thanks
Rao
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20050602/999ec702/attachment.html>