From: mitchchapman at earthlink.net (Mitch Chapman)
Date: Mon, 31 Jul 2006 08:41:05 -0600
Subject: [Pljava-dev] Stack depth limit exceeded with pljava 1.2.0
Message-ID: <C26F5C40-4FF2-409A-89C2-83A44B544569@earthlink.net>

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