From sfarley1 at gmu.edu Wed Feb 3 15:12:18 2010 From: sfarley1 at gmu.edu (sfarley1 at gmu.edu) Date: Wed, 3 Feb 2010 15:12:18 +0000 Subject: [Pljava-dev] Install Error Message-ID: <230598078-1265209815-cardhu_decombobulator_blackberry.rim.net-2130733305-@bda033.bisx.prod.on.blackberry> I'm trying to install pl/java on my laptop for Postgres. I originally tried it with 8.4, but reverted to 8.4 hoping it would fix the problem, but I am getting the same error. The error is: ERROR: could not load library "D:/Program Files/PostgreSQL/8.3/lib/pljava.dll": The specified module could not be found I have the following in poosgressql.conf file custom_variable_classes = 'pljava'# list of custom variable class names pljava.classpath='D:\\Program Files\\PostgreSQL\\8.3\\share\\pljava\\pljava.jar' dynamic_library_path = 'D:\\Program Files\\PostgreSQL\\8.3\\lib\\postgresql' My Path variable is: %SSJHOME%\lib;%JAVA_HOME%\bin ;D:\Program Files\Java\jre6\bin;D:\Program Files\Java\jre6\bin\client;D:/Program Files/PostgreSQL/8.3/lib; And my Classpath variable is: .;%SSJHOME%\lib\ssj.jar;%SSJHOME%\lib\colt.jar;D:\Program Files\PostgreSQL\pgJDBC\postgresql-8.4-701.jdbc3.jar;D:\Program Files\PostgreSQL\8.3\share\pljava\deploy.jar I'm using Windows 7 and have the java JDK 1.6 and jre 6 installed. Any ideas of how to resolve this? Thank you, Susan Sent from my Verizon Wireless BlackBerry From tim.clarke at manifest.co.uk Sun Mar 7 19:33:00 2010 From: tim.clarke at manifest.co.uk (Tim Clarke) Date: Sun, 07 Mar 2010 19:33:00 +0000 Subject: [Pljava-dev] Using JDBC in PL/Java 1.4.0: Statement.executeQuery() automatically closes the statement redux Message-ID: <4B93FF6C.1000605@manifest.co.uk> I've been tracking down a problem where checking getWarnings() after an executeQuery() in pljava and found an exchange on the list from 2008 that matches my symptoms exactly: http://pgfoundry.org/pipermail/pljava-dev/2008/001298.html Kris Jurka replied swiftly and fixed the issue in the source tree. Was this ever released live? I've just downloaded the latest: http://pgfoundry.org/frs/download.php/1597/pljava-i686-pc-linux-gnu-pg8.2-1.4.0.tar.gz To run against our PG 8.2.15 database and I'm still getting the problem. -- Tim Clarke AMBCS MIAP IT Director Manifest 9 Freebournes Court Newland Street Witham, Essex CM8 2BL England Phone: +44 1376 503500 Direct: +44 1376 504510 Fax: +44 1376 503550 Email: tim.clarke at manifest.co.uk Web: http://www.manifest.co.uk Skype: callto:tim.clarke Manifest is the trading name of: Manifest Information Services Ltd: Registered in England Number 3401145 & The Manifest Voting Agency Ltd: Registered in England Number 2920820. Registered Office at above address. VAT Registration Number: GB 700 1880 77 Copyright: This e-mail may contain confidential or legally privileged information. If you are not the named addressee you must not use or disclose such information, instead please report it to: admin at manifest.co.uk Please see http://www.manifest.co.uk/legal/legal_notices.htm for further information. From jcllario at hotmail.com Wed Mar 10 23:15:45 2010 From: jcllario at hotmail.com (JOSE CARLOS MARTINEZ LLARIO) Date: Thu, 11 Mar 2010 00:15:45 +0100 Subject: [Pljava-dev] sqlj.install_jar vs classpath Message-ID: Hi all, I am using PLJAVA in a project that needs many other jars, around 20 different jars. I have configured PLJAVA with my project in t2o different ways: 1) I configured the postgres.conf file with the classpath pointing out to pljava.jar and the rest of the jars. I didnt use sqlj.install_jar 2) I configured the postgres.conf file with pljava.jar and the rest of jars with sqlj.install_jar Both options are working well and I think the postmaster is using the same amount of memory in each connection. So my question is: Both procedures are similar or I should use one of them in particular?.. Another question I wanted to ask to this forum is: The only way to share the jars between different postgres clients is to use GCJ? What about using the option Xshareclasses in the virtual machines (someone has tried that?). Thanx a lot for the answers, Jose MArtinez _________________________________________________________________ Escucha a quienes ya han probado Windows 7 ?Hazlo aqu?! http://www.sietesunpueblodeexpertos.com/index_windows7.html -------------- next part -------------- An HTML attachment was scrubbed... URL: From jcllario at hotmail.com Wed Mar 10 23:23:16 2010 From: jcllario at hotmail.com (JOSE CARLOS MARTINEZ LLARIO) Date: Thu, 11 Mar 2010 00:23:16 +0100 Subject: [Pljava-dev] Pljava not using the default java virtual machine Message-ID: Hi everyone..again! sorry because I already sent another post just few secs ago, but I had another question that I couldnt solved surfing on the internet. I want to change the java vm used in pljava, but I do not want to change the system variables java_home, etc. What I would like to download a JRE in a directory just for PLJAVA and then to put there all the jars and configuration files I need. So there is some way that pljava could point out to another java vm? If not, it is possible to change to source code to make it? Currently Im developing a spatial extension to postgres similar to postgis but just using java. its working fine but i need to make easier to the final user the installation process. I though about downloading the JRE plus pljava.jar and other files and to keep a JRE prepared just for this software. thanx a lot guys, Jose MArtinez _________________________________________________________________ Ahora Messenger en tu Blackberry? 8520 con Movistar por 0 ?. ?A qu? esperas? http://serviciosmoviles.es.msn.com/messenger/blackberry.aspx -------------- next part -------------- An HTML attachment was scrubbed... URL: From tim.clarke at manifest.co.uk Fri Mar 12 13:35:45 2010 From: tim.clarke at manifest.co.uk (Tim Clarke) Date: Fri, 12 Mar 2010 13:35:45 +0000 Subject: [Pljava-dev] Using JDBC in PL/Java 1.4.0: Statement.executeQuery() automatically closes the statement redux In-Reply-To: <4B93FF6C.1000605@manifest.co.uk> References: <4B93FF6C.1000605@manifest.co.uk> Message-ID: <4B9A4331.4020408@manifest.co.uk> > > I've been tracking down a problem where checking getWarnings() after an > executeQuery() in pljava and found an exchange on the list from 2008 > that matches my symptoms exactly: > > http://pgfoundry.org/pipermail/pljava-dev/2008/001298.html > > > Kris Jurka replied swiftly and fixed the issue in the source tree. Was > this ever released live? I've just downloaded the latest: > > http://pgfoundry.org/frs/download.php/1597/pljava-i686-pc-linux-gnu-pg8.2-1.4.0.tar.gz > > To run against our PG 8.2.15 database and I'm still getting the problem. > > I (think) I've managed to get a compile now using Eclipse and jdk1.5_10. Unfortunately when registering my java function calls using set search_path=voting; select sqlj.install_jar('file:///usr/local/manifest/vote.jar', 'vote', false); select sqlj.install_jar('file:///usr/share/java/log4j.jar', 'log4j', false); SELECT sqlj.set_classpath('voting', 'vote:log4j'); CREATE or replace FUNCTION vote(AccountID int8, CapitalID int8, EventID int8, CanCopy bool, CopyFromEventID int8) RETURNS varchar AS 'uk.co.manifest.postgres.vote.VoteCalc.vote(long, long, long, boolean, long)' volatile LANGUAGE java; I get the error: java.lang.NoSuchMethodError: Method org.postgresql.pljava.internal.Portal._ fetch(JZI)I on that first install_jar() call followed by "failed to create JVM" on any subsequent calls :-/ I've not found an answer by googling. Can anyone help? -- Tim Clarke AMBCS MIAP IT Director Manifest 9 Freebournes Court Newland Street Witham, Essex CM8 2BL England Phone: +44 1376 503500 Direct: +44 1376 504510 Fax: +44 1376 503550 Email: tim.clarke at manifest.co.uk Web: http://www.manifest.co.uk Skype: callto:tim.clarke Manifest is the trading name of: Manifest Information Services Ltd: Registered in England Number 3401145 & The Manifest Voting Agency Ltd: Registered in England Number 2920820. Registered Office at above address. VAT Registration Number: GB 700 1880 77 Copyright: This e-mail may contain confidential or legally privileged information. If you are not the named addressee you must not use or disclose such information, instead please report it to: admin at manifest.co.uk Please see http://www.manifest.co.uk/legal/legal_notices.htm for further information. From jcllario at hotmail.com Mon Mar 15 20:22:56 2010 From: jcllario at hotmail.com (JOSE CARLOS MARTINEZ LLARIO) Date: Mon, 15 Mar 2010 21:22:56 +0100 Subject: [Pljava-dev] How to cancel a trigger operation Message-ID: HI all, Some of you knows how to cancel a trigger operation (insert, delete or update) from a trigger function in PLJAVA? In PLPGSQL I know I can get it returning a null value. I tried several things in PLJAVA but i couldnt make it. Thanx a lot, Best, Jose Martinez _________________________________________________________________ Recibe en tu m?vil un SMS con tu Hotmail recibido. ?Date de alta ya! http://serviciosmoviles.es.msn.com/ -------------- next part -------------- An HTML attachment was scrubbed... URL: From jcllario at hotmail.com Tue Mar 16 09:35:03 2010 From: jcllario at hotmail.com (JOSE CARLOS MARTINEZ LLARIO) Date: Tue, 16 Mar 2010 10:35:03 +0100 Subject: [Pljava-dev] How to cancel a trigger operation In-Reply-To: <3fccaa691003151328x175f77a3i7c6a84d0a198b169@mail.gmail.com> References: , <3fccaa691003151328x175f77a3i7c6a84d0a198b169@mail.gmail.com> Message-ID: Hi Andres, Thanks for the answer. Throwing an exception works but not in the way i need because the transaction is aborted. I was looking for something that I already read in this list: http://pgfoundry.org/pipermail/pljava-dev/2006/001000.html http://pgfoundry.org/pipermail/pljava-dev/2006/001001.html I was expecting someone already fixed that bug (i think its a bug because we can not use triggers in a proper way) because these posts are from 4 years ago. Has someone already worked in this bug? Thanks to all, Best, Jose _________________________________________________________________ ?Te gustar?a tener Hotmail en tu m?vil Movistar? ?Es gratis! http://serviciosmoviles.es.msn.com/hotmail/movistar-particulares.aspx -------------- next part -------------- An HTML attachment was scrubbed... URL: