agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feed[Pljava-dev] Stack depth limit exceeded with pljava 1.2.0
3+ messages / 0 participants
[nested] [flat]
* [Pljava-dev] Stack depth limit exceeded with pljava 1.2.0
@ 2006-07-31 14:41
0 siblings, 1 reply; 3+ messages in thread
From: @ 2006-07-31 14:41 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* [Pljava-dev] Stack depth limit exceeded with pljava 1.2.0
@ 2006-07-31 22:04
parent:
0 siblings, 1 reply; 3+ messages in thread
From: @ 2006-07-31 22:04 UTC (permalink / raw)
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* [Pljava-dev] Stack depth limit exceeded with pljava 1.2.0
@ 2006-08-14 22:36
parent:
0 siblings, 0 replies; 3+ messages in thread
From: @ 2006-08-14 22:36 UTC (permalink / raw)
Mitch Chapman wrote:
> 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.
>
This is to conform with the PostgreSQL naming convention. An add-on module should not have
the 'lib' prefix. It's the same on all platforms.
Regards,
Thomas Hallgren
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-08-14 22:36 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-07-31 14:41 [Pljava-dev] Stack depth limit exceeded with pljava 1.2.0
2006-07-31 22:04 `
2006-08-14 22:36 `
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox