[Pljava-dev] Stack depth limit exceeded with pljava 1.2.0

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