From: thhal at mailblocks.com (Thomas Hallgren)
Date: Thu, 02 Jun 2005 11:53:13 +0200
Subject: [Pljava-dev] Accessing OpenJMS Queue from PLJava
In-Reply-To: <3214799999CED64882731155DB0AAD92024BC2CA@MLSW00103>
References: <3214799999CED64882731155DB0AAD92024BC2CA@MLSW00103>
	<429ED709.5060603@mailblocks.com>
	<thhal-0i296A7FCzjYgozM5m3J80uMevYeldA@mailblocks.com>
Message-ID: <thhal-0i296A7NCzjY5KmCCIpy2oIjNfTRTGS@mailblocks.com>

The jars that you list here, have you installed them using install_jar 
or are you trying to load them from disk using a classpath? The former 
is the correct approach. The classpath should *only* be used to find the 
pljava.jar.

Regards,
Thomas Hallgren

Nageshwar Rao wrote:

> 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',true);
>
> 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
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Pljava-dev mailing list
>Pljava-dev at gborg.postgresql.org
>http://gborg.postgresql.org/mailman/listinfo/pljava-dev
>  
>