Subject: [Pljava-dev] Stack depth limit exceeded with pljava 1.2.0
Date: Mon, 31 Jul 2006 16:04:30 -0600
Message-ID: <F23BE0BE-0AB5-4163-BFC9-14D3C54E29B0@earthlink.net> (raw)
In-Reply-To: <C26F5C40-4FF2-409A-89C2-83A44B544569@earthlink.net>
References: <C26F5C40-4FF2-409A-89C2-83A44B544569@earthlink.net>
Never mind!
PL/Java 1.3.0 seems to solve the problem, and I don't know of any
reason why we can't migrate to it.
The only minor problem I've had with 1.3.0 is that, on Mac OS X
10.4.7, with PostgreSQL 8.1.3 from DarwinPorts, 'sudo make install'
creates /opt/local/lib/pgsql8/pljava.so instead of the expected .../
libpljava.so.
--
Mitch
On Jul 31, 2006, at 8:41 AM, Mitch Chapman wrote:
> I've an extension class with two public static methods, both of which
> worked under PL/Java 1.1.0 / PostgreSQL 8.0.3. With PL/Java 1.2.0
> and PostgreSQL 8.1.3 one of the methods still works alright, but the
> other produces an exception as seen below. Can anyone advise as to
> how to debug?
>
> Thanks in advance. Please let me know if you need additional
> information.
>
> DEBUG: 00000: Exception in function SPI_prepare
> LOCATION: Exception_throw_ERROR, /Users/mitchchapman/Documents/
> Downloads/pljava-1.2.0/src/C/pljava/Exception.c:159
> STATEMENT: select findSubStructures('c1ccccc1',
> 0.01, 200, 30000, 'JChemProperties', 'structure');
> INFO: 00000: 28 Jul 06 18:48:38 org.postgresql.pljava.sqlj.Loader
> Failed to load class
> org.postgresql.pljava.internal.ServerException: stack depth
> limit exceeded
> at
> org.postgresql.pljava.internal.ExecutionPlan._prepare(Native Method)
> at
> org.postgresql.pljava.internal.ExecutionPlan.prepare
> (ExecutionPlan.java:214)
> at
> org.postgresql.pljava.jdbc.SPIPreparedStatement.execute
> (SPIPreparedStatement.java:261)
> at
> org.postgresql.pljava.jdbc.SPIPreparedStatement.executeQuery
> (SPIPreparedStatement.java:72)
> at org.postgresql.pljava.sqlj.Loader.findClass
> (Loader.java:171)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:
> 306)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:
> 251)
> at java.lang.ClassLoader.loadClassInternal
> (ClassLoader.java:319)
> at java.lang.ClassLoader.defineClass1(Native Method)
> at java.lang.ClassLoader.defineClass
> (ClassLoader.java:620)
> at java.lang.ClassLoader.defineClass
> (ClassLoader.java:465)
> at org.postgresql.pljava.sqlj.Loader.findClass
> (Loader.java:177)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:
> 306)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:
> 251)
> at java.lang.ClassLoader.loadClassInternal
> (ClassLoader.java:319)
> at chemaxon.sss.search.StructureSearch.initAtoms
> (StructureSearch.java:2494)
> at chemaxon.sss.search.StructureSearch.initSearch
> (StructureSearch.java:1297)
> at chemaxon.sss.search.StructureSearch.findFirst0
> (StructureSearch.java:4542)
> at chemaxon.sss.search.StructureSearch.isMatching0
> (StructureSearch.java:4942)
> at chemaxon.sss.search.StructureSearch.isMatching
> (StructureSearch.java:4934)
> at chemaxon.sss.search.MolSearch.isMatching
> (MolSearch.java:684)
> at chemaxon.jchem.db.JChemSearch.isMatching
> (JChemSearch.java:3436)
> at chemaxon.jchem.db.JChemSearch.access$700
> (JChemSearch.java:71)
> at chemaxon.jchem.db.JChemSearch$ABASThread.run
> (JChemSearch.java:349)
> --
> Mitch Chapman
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] Stack depth limit exceeded with pljava 1.2.0
In-Reply-To: <F23BE0BE-0AB5-4163-BFC9-14D3C54E29B0@earthlink.net>
References: <C26F5C40-4FF2-409A-89C2-83A44B544569@earthlink.net> <F23BE0BE-0AB5-4163-BFC9-14D3C54E29B0@earthlink.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox