From: mitchchapman at earthlink.net (Mitch Chapman)
Date: Mon, 31 Jul 2006 16:04:30 -0600
Subject: [Pljava-dev] Stack depth limit exceeded with pljava 1.2.0
In-Reply-To: <C26F5C40-4FF2-409A-89C2-83A44B544569@earthlink.net>
References: <C26F5C40-4FF2-409A-89C2-83A44B544569@earthlink.net>
Message-ID: <F23BE0BE-0AB5-4163-BFC9-14D3C54E29B0@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