[postgis-users] [PGBox3D] Could not load org.postgis.PGbox3d

[Henning Bredel]

Hi there,

I try to store some entities in postgres using postGIS, since
spatial objects should be stored, too.

Running the makePersistent-method results in the following
exception:

(The error: Could not load org.postgis.PGbox3d which is
responsible for box3d)


2007-06-16 18:20:47,983 WARN (main) [cfg.SettingsFactory]: Could not 
obtain connection metadata
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create 
PoolableConnectionFactory (Die für den Datentyp box3d verantwortliche 
Klasse org.postgis.PGbox3d konnte nicht geladen werden.)
    at 
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)
    at 
org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
    at

 [...]

sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at java.lang.Class.newInstance0(Class.java:355)
    at java.lang.Class.newInstance(Class.java:308)
    at 
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1055)
    at 
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:932)
    at 
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3951)
    at 
org.apache.catalina.core.StandardContext.start(StandardContext.java:4225)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
    at 
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
    at 
org.apache.catalina.core.StandardService.start(StandardService.java:450)
    at 
org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
Caused by: org.postgresql.util.PSQLException: Die für den Datentyp box3d 
verantwortliche Klasse org.postgis.PGbox3d konnte nicht geladen werden.
    at 
org.postgresql.jdbc2.AbstractJdbc2Connection.initObjectTypes(AbstractJdbc2Connection.java:497)
    at 
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:162)
    at 
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
    at 
org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:18)
    at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
    at org.postgresql.Driver.makeConnection(Driver.java:382)
    at org.postgresql.Driver.connect(Driver.java:260)
    at org.postgis.DriverWrapper.connect(DriverWrapper.java:155)
    at 
org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
    at 
org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
    at 
org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
    at 
org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
    ... 35 more

Using JNDI, the resource set up correctly (getEntities from db works),
appropriate postgres_jdbc.jar and postGIS.jar are stored in the
common/lib of tomcat..

Please: could you give me a hint, where the problem is?

Thanks

Henning