Hibernate spatial with oracle
|
|
Roy Braam
|
Some javascript/style in this post has been disabled (why?)
Hello List,We are using hibernatespatial for a while now to read and write geometries to a postgres database. But now i want to use it on a oracle 11g database. I keep ketting the following error: INFO org.hibernate.dialect.Dialect - Using dialect: org.hibernatespatial.oracle.OracleSpatial10gDialect 2009-06-18 13:48:17,161 [http-8084-4] WARN org.hibernate.dialect.Oracle9Dialect - The Oracle9Dialect dialect has been deprecated; use either Oracle9iDialect or Oracle10gDialect instead 2009-06-18 13:48:17,162 [http-8084-4] FATAL nl.b3p.put.rdp.persistance.MyEMFDatabase - Error initializing EntityManagerFactory: javax.persistence.PersistenceException: org.hibernate.HibernateException: Wrong column type: geom, expected: geom at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:737) at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:121) at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:51) at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:33) at nl.b3p.put.rdp.persistance.MyEMFDatabase.openEntityManagerFactory(MyEMFDatabase.java:38) at nl.b3p.put.rdp.persistance.MyEMFDatabase.getEntityManagerFactory(MyEMFDatabase.java:50) at nl.b3p.put.rdp.persistance.MyEMFDatabase.createEntityManager(MyEMFDatabase.java:116) at nl.b3p.put.rdp.struts.BaseDatabaseAction.execute(BaseDatabaseAction.java:55) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.securityfilter.filter.SecurityFilter.doFilter(SecurityFilter.java:188) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:619) Caused by: org.hibernate.HibernateException: Wrong column type: geom, expected: geom at org.hibernate.mapping.Table.validateColumns(Table.java:261) at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1083) at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:116) at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:317) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294) at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:915) at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:730) ... 28 more My geometry column mapping: <property name="geom" type="org.hibernatespatial.GeometryUserType"> <column name="geom" sql-type="MDSYS.SDO_GEOMETRY"/> </property> I'm using version 1.0-m2 Tia Roy _______________________________________________ hibernatespatial-users mailing list [hidden email] http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users |
||||||||||||||||
Davis Ford
|
Did you setup the user_sdo_metadata table in Oracle?
On Thu, Jun 18, 2009 at 8:01 AM, Roy Braam<[hidden email]> wrote: > Hello List, > > We are using hibernatespatial for a while now to read and write geometries > to a postgres database. But now i want to use it on a oracle 11g database. > I keep ketting the following error: > INFO org.hibernate.dialect.Dialect - Using dialect: > org.hibernatespatial.oracle.OracleSpatial10gDialect > 2009-06-18 13:48:17,161 [http-8084-4] WARN > org.hibernate.dialect.Oracle9Dialect - The Oracle9Dialect dialect has been > deprecated; use either Oracle9iDialect or Oracle10gDialect instead > 2009-06-18 13:48:17,162 [http-8084-4] FATAL > nl.b3p.put.rdp.persistance.MyEMFDatabase - Error initializing > EntityManagerFactory: > javax.persistence.PersistenceException: org.hibernate.HibernateException: > Wrong column type: geom, expected: geom > at > org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:737) > at > org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:121) > at > javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:51) > at > javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:33) > at > nl.b3p.put.rdp.persistance.MyEMFDatabase.openEntityManagerFactory(MyEMFDatabase.java:38) > at > nl.b3p.put.rdp.persistance.MyEMFDatabase.getEntityManagerFactory(MyEMFDatabase.java:50) > at > nl.b3p.put.rdp.persistance.MyEMFDatabase.createEntityManager(MyEMFDatabase.java:116) > at > nl.b3p.put.rdp.struts.BaseDatabaseAction.execute(BaseDatabaseAction.java:55) > at > org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) > at > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) > at > org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) > at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.securityfilter.filter.SecurityFilter.doFilter(SecurityFilter.java:188) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) > at > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) > at > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) > at java.lang.Thread.run(Thread.java:619) > Caused by: org.hibernate.HibernateException: Wrong column type: geom, > expected: geom > at org.hibernate.mapping.Table.validateColumns(Table.java:261) > at > org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1083) > at > org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:116) > at > org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:317) > at > org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294) > at > org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:915) > at > org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:730) > ... 28 more > > My geometry column mapping: > <property name="geom" type="org.hibernatespatial.GeometryUserType"> > <column name="geom" sql-type="MDSYS.SDO_GEOMETRY"/> > </property> > > I'm using version 1.0-m2 > > Tia > > Roy > > _______________________________________________ > hibernatespatial-users mailing list > [hidden email] > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users > > -- Zeno Consulting, Inc. home: http://www.zenoconsulting.biz blog: http://zenoconsulting.wikidot.com p: 248.894.4922 f: 313.884.2977 _______________________________________________ hibernatespatial-users mailing list [hidden email] http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users |
||||||||||||||||
|
Roy Braam
|
Some javascript/style in this post has been disabled (why?)
Hello Davis,No i didn't..... That must be the problem. I'll try to find out what i need to insert, Thanks! Roy
_______________________________________________ hibernatespatial-users mailing list [hidden email] http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users |
||||||||||||||||
|
Roy Braam
|
In reply to this post
by Davis Ford
Some javascript/style in this post has been disabled (why?)
Hello,I inserted a user_sdo_geom_metadata record: INSERT INTO USER_SDO_GEOM_METADATA VALUES('COMMENTAAR','GEOM', MDSYS.SDO_DIM_ARRAY( MDSYS.SDO_DIM_ELEMENT('X',0,290000,0.005), MDSYS.SDO_DIM_ELEMENT('Y',290000,650000,0.005) ),28992); But i still get the same error... Roy
_______________________________________________ hibernatespatial-users mailing list [hidden email] http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users |
||||||||||||||||
Karel Maesen
|
Roy,
Are you sure that the Geometries in the table are of type SDO_GEOMETRY? In Oracle11g geometries can be declared using ST_GEOMETRY, which is currently unsupported by Hibernate Spatial. Regards, Karel On 22 Jun 2009, at 11:58, Roy Braam wrote: > Hello, > > I inserted a user_sdo_geom_metadata record: > INSERT INTO USER_SDO_GEOM_METADATA VALUES('COMMENTAAR','GEOM', > MDSYS.SDO_DIM_ARRAY( > MDSYS.SDO_DIM_ELEMENT('X',0,290000,0.005), > MDSYS.SDO_DIM_ELEMENT('Y',290000,650000,0.005) > ),28992); > > But i still get the same error... > > Roy > From: Davis Ford [mailto:[hidden email]] > To: Hibernate Spatial Users Discussion [mailto:hibernatespatial- > [hidden email]] > Sent: Thu, 18 Jun 2009 14:58:12 +0200 > Subject: Re: [hibernatespatial-users] Hibernate spatial with oracle > > Did you setup the user_sdo_metadata table in Oracle? > > On Thu, Jun 18, 2009 at 8:01 AM, Roy Braam<[hidden email]> > wrote: > > Hello List, > > > > We are using hibernatespatial for a while now to read and write > geometries > > to a postgres database. But now i want to use it on a oracle 11g > database. > > I keep ketting the following error: > > INFO org.hibernate.dialect.Dialect - Using dialect: > > org.hibernatespatial.oracle.OracleSpatial10gDialect > > 2009-06-18 13:48:17,161 [http-8084-4] WARN > > org.hibernate.dialect.Oracle9Dialect - The Oracle9Dialect dialect > has been > > deprecated; use either Oracle9iDialect or Oracle10gDialect instead > > 2009-06-18 13:48:17,162 [http-8084-4] FATAL > > nl.b3p.put.rdp.persistance.MyEMFDatabase - Error initializing > > EntityManagerFactory: > > javax.persistence.PersistenceException: > org.hibernate.HibernateException: > > Wrong column type: geom, expected: geom > > at > > org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory > (Ejb3Configuration.java:737) > > at > > org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory > (HibernatePersistence.java:121) > > at > > javax.persistence.Persistence.createEntityManagerFactory > (Persistence.java:51) > > at > > javax.persistence.Persistence.createEntityManagerFactory > (Persistence.java:33) > > at > > nl.b3p.put.rdp.persistance.MyEMFDatabase.openEntityManagerFactory > (MyEMFDatabase.java:38) > > at > > nl.b3p.put.rdp.persistance.MyEMFDatabase.getEntityManagerFactory > (MyEMFDatabase.java:50) > > at > > nl.b3p.put.rdp.persistance.MyEMFDatabase.createEntityManager > (MyEMFDatabase.java:116) > > at > > nl.b3p.put.rdp.struts.BaseDatabaseAction.execute > (BaseDatabaseAction.java:55) > > at > > org.apache.struts.action.RequestProcessor.processActionPerform > (RequestProcessor.java:431) > > at > > org.apache.struts.action.RequestProcessor.process > (RequestProcessor.java:236) > > at > > org.apache.struts.action.ActionServlet.process(ActionServlet.java: > 1196) > > at org.apache.struts.action.ActionServlet.doGet > (ActionServlet.java:414) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > (ApplicationFilterChain.java:290) > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter > (ApplicationFilterChain.java:206) > > at > > org.securityfilter.filter.SecurityFilter.doFilter > (SecurityFilter.java:188) > > at > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > (ApplicationFilterChain.java:235) > > at > > org.apache.catalina.core.ApplicationFilterChain.doFilter > (ApplicationFilterChain.java:206) > > at > > org.apache.catalina.core.StandardWrapperValve.invoke > (StandardWrapperValve.java:233) > > at > > org.apache.catalina.core.StandardContextValve.invoke > (StandardContextValve.java:191) > > at > > org.apache.catalina.core.StandardHostValve.invoke > (StandardHostValve.java:128) > > at > > org.apache.catalina.valves.ErrorReportValve.invoke > (ErrorReportValve.java:102) > > at > > org.apache.catalina.core.StandardEngineValve.invoke > (StandardEngineValve.java:109) > > at > > org.apache.catalina.connector.CoyoteAdapter.service > (CoyoteAdapter.java:286) > > at > > org.apache.coyote.http11.Http11Processor.process > (Http11Processor.java:845) > > at > > org.apache.coyote.http11.Http11Protocol > $Http11ConnectionHandler.process(Http11Protocol.java:583) > > at > > org.apache.tomcat.util.net.JIoEndpoint$Worker.run > (JIoEndpoint.java:447) > > at java.lang.Thread.run(Thread.java:619) > > Caused by: org.hibernate.HibernateException: Wrong column type: > geom, > > expected: geom > > at org.hibernate.mapping.Table.validateColumns(Table.java:261) > > at > > org.hibernate.cfg.Configuration.validateSchema(Configuration.java: > 1083) > > at > > org.hibernate.tool.hbm2ddl.SchemaValidator.validate > (SchemaValidator.java:116) > > at > > org.hibernate.impl.SessionFactoryImpl.<init> > (SessionFactoryImpl.java:317) > > at > > org.hibernate.cfg.Configuration.buildSessionFactory > (Configuration.java:1294) > > at > > org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory > (AnnotationConfiguration.java:915) > > at > > org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory > (Ejb3Configuration.java:730) > > ... 28 more > > > > My geometry column mapping: > > <property name="geom" type="org.hibernatespatial.GeometryUserType"> > > <column name="geom" sql-type="MDSYS.SDO_GEOMETRY"/> > > </property> > > > > I'm using version 1.0-m2 > > > > Tia > > > > Roy > > > > _______________________________________________ > > hibernatespatial-users mailing list > > [hidden email] > > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ > hibernatespatial-users > > > > > > > > -- > Zeno Consulting, Inc. > home: http://www.zenoconsulting.biz > blog: http://zenoconsulting.wikidot.com > p: 248.894.4922 > f: 313.884.2977 > _______________________________________________ > hibernatespatial-users mailing list > [hidden email] > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ > hibernatespatial-users > _______________________________________________ > hibernatespatial-users mailing list > [hidden email] > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ > hibernatespatial-users _______________________________________________ hibernatespatial-users mailing list [hidden email] http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users |
||||||||||||||||
|
Roy Braam
|
Some javascript/style in this post has been disabled (why?)
Karel,This is the script that i used to create the table: create table commentaar ( id number not null, bestemmingsplangebiedid varchar2(255 char), eigenaar varchar2(255 char), beleidsveld varchar2(255 char), tekst varchar2(255 char), geom SDO_GEOMETRY, primary key (id) ); So i'm sure that the geometry column type is SDO_GEOMETRY. I also inserted a geometry with the statement: INSERT INTO COMMENTAAR(ID,GEOM) VALUES(1, SDO_GEOMETRY(2003, 28992, NULL, SDO_ELEM_INFO_ARRAY(1,1003,1), SDO_ORDINATE_ARRAY(100000,400000, 200000,400000, 200000,500000, 100000,500000, 100000,400000) ) ); That worked fine.... It's the only record in the table. Roy
_______________________________________________ hibernatespatial-users mailing list [hidden email] http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users |
||||||||||||||||
fgdrf
|
In reply to this post
by Roy Braam
Hello Roy,
have you created a spatial index for the geom-column with the given srid (28992)? If possible, please show the the part of the code where yout try to persist a object. What version of the ojdb14.jar file are you using? Frank Karel, > This is the script that i used to create the table: > create table commentaar ( > id number not null, > bestemmingsplangebiedid varchar2(255 char), > eigenaar varchar2(255 char), > beleidsveld varchar2(255 char), > tekst varchar2(255 char), > geom SDO_GEOMETRY, > primary key (id) > ); > So i'm sure that the geometry column type is SDO_GEOMETRY. I also > inserted a geometry with the statement: > > INSERT INTO COMMENTAAR(ID,GEOM) VALUES(1, > SDO_GEOMETRY(2003, > 28992, > NULL, > SDO_ELEM_INFO_ARRAY(1,1003,1), > SDO_ORDINATE_ARRAY(100000,400000, 200000,400000, 200000,500000, > 100000,500000, 100000,400000) > ) > ); > > That worked fine.... > It's the only record in the table. > > Roy > *From:* Karel Maesen [mailto:[hidden email]] > *To:* Hibernate Spatial Users Discussion [mailto:hibernatespatial- > [hidden email]] > *Sent:* Mon, 22 Jun 2009 12:19:57 +0200 > *Subject:* Re: [hibernatespatial-users] Hibernate spatial with oracle > > Roy, > > Are you sure that the Geometries in the table are of type > SDO_GEOMETRY? In Oracle11g geometries can be declared using > ST_GEOMETRY, which is currently unsupported by Hibernate Spatial. > > Regards, > > Karel > On 22 Jun 2009, at 11:58, Roy Braam wrote: > > > Hello, > > > > I inserted a user_sdo_geom_metadata record: > > INSERT INTO USER_SDO_GEOM_METADATA VALUES('COMMENTAAR','GEOM', > > MDSYS.SDO_DIM_ARRAY( > > MDSYS.SDO_DIM_ELEMENT('X',0,290000,0.005), > > MDSYS.SDO_DIM_ELEMENT('Y',290000,650000,0.005) > > ),28992); > > > > But i still get the same error... > > > > Roy > > From: Davis Ford [mailto:[hidden email]] > > To: Hibernate Spatial Users Discussion [mailto:hibernatespatial- > > [hidden email]] > > Sent: Thu, 18 Jun 2009 14:58:12 +0200 > > Subject: Re: [hibernatespatial-users] Hibernate spatial with oracle > > > > Did you setup the user_sdo_metadata table in Oracle? > > > > On Thu, Jun 18, 2009 at 8:01 AM, Roy Braam<[hidden email]> > > wrote: > > > Hello List, > > > > > > We are using hibernatespatial for a while now to read and write > > geometries > > > to a postgres database. But now i want to use it on a oracle 11g > > database. > > > I keep ketting the following error: > > > INFO org.hibernate.dialect.Dialect - Using dialect: > > > org.hibernatespatial.oracle.OracleSpatial10gDialect > > > 2009-06-18 13:48:17,161 [http-8084-4] WARN > > > org.hibernate.dialect.Oracle9Dialect - The Oracle9Dialect dialect > > has been > > > deprecated; use either Oracle9iDialect or Oracle10gDialect instead > > > 2009-06-18 13:48:17,162 [http-8084-4] FATAL > > > nl.b3p.put.rdp.persistance.MyEMFDatabase - Error initializing > > > EntityManagerFactory: > > > javax.persistence.PersistenceException: > > org.hibernate.HibernateException: > > > Wrong column type: geom, expected: geom > > > at > > > org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory > > (Ejb3Configuration.java:737) > > > at > > > org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory > > (HibernatePersistence.java:121) > > > at > > > javax.persistence.Persistence.createEntityManagerFactory > > (Persistence.java:51) > > > at > > > javax.persistence.Persistence.createEntityManagerFactory > > (Persistence.java:33) > > > at > > > nl.b3p.put.rdp.persistance.MyEMFDatabase.openEntityManagerFactory > > (MyEMFDatabase.java:38) > > > at > > > nl.b3p.put.rdp.persistance.MyEMFDatabase.getEntityManagerFactory > > (MyEMFDatabase.java:50) > > > at > > > nl.b3p.put.rdp.persistance.MyEMFDatabase.createEntityManager > > (MyEMFDatabase.java:116) > > > at > > > nl.b3p.put.rdp.struts.BaseDatabaseAction.execute > > (BaseDatabaseAction.java:55) > > > at > > > org.apache.struts.action.RequestProcessor.processActionPerform > > (RequestProcessor.java:431) > > > at > > > org.apache.struts.action.RequestProcessor.process > > (RequestProcessor.java:236) > > > at > > > org.apache.struts.action.ActionServlet.process(ActionServlet.java: > > > 1196) > > > at org.apache.struts.action.ActionServlet.doGet > > (ActionServlet.java:414) > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > > (ApplicationFilterChain.java:290) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter > > (ApplicationFilterChain.java:206) > > > at > > > org.securityfilter.filter.SecurityFilter.doFilter > > (SecurityFilter.java:188) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > > (ApplicationFilterChain.java:235) > > > at > > > org.apache.catalina.core.ApplicationFilterChain.doFilter > > (ApplicationFilterChain.java:206) > > > at > > > org.apache.catalina.core.StandardWrapperValve.invoke > > (StandardWrapperValve.java:233) > > > at > > > org.apache.catalina.core.StandardContextValve.invoke > > (StandardContextValve.java:191) > > > at > > > org.apache.catalina.core.StandardHostValve.invoke > > (StandardHostValve.java:128) > > > at > > > org.apache.catalina.valves.ErrorReportValve.invoke > > (ErrorReportValve.java:102) > > > at > > > org.apache.catalina.core.StandardEngineValve.invoke > > (StandardEngineValve.java:109) > > > at > > > org.apache.catalina.connector.CoyoteAdapter.service > > (CoyoteAdapter.java:286) > > > at > > > org.apache.coyote.http11.Http11Processor.process > > (Http11Processor.java:845) > > > at > > > org.apache.coyote.http11.Http11Protocol > > $Http11ConnectionHandler.process(Http11Protocol.java:583) > > > at > > > org.apache.tomcat.util.net.JIoEndpoint$Worker.run > > (JIoEndpoint.java:447) > > > at java.lang.Thread.run(Thread.java:619) > > > Caused by: org.hibernate.HibernateException: Wrong column type: > > geom, > > > expected: geom > > > at org.hibernate.mapping.Table.validateColumns(Table.java:261) > > > at > > > org.hibernate.cfg.Configuration.validateSchema(Configuration.java: > > > 1083) > > > at > > > org.hibernate.tool.hbm2ddl.SchemaValidator.validate > > (SchemaValidator.java:116) > > > at > > > org.hibernate.impl.SessionFactoryImpl.<init> > > (SessionFactoryImpl.java:317) > > > at > > > org.hibernate.cfg.Configuration.buildSessionFactory > > (Configuration.java:1294) > > > at > > > org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory > > (AnnotationConfiguration.java:915) > > > at > > > org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory > > (Ejb3Configuration.java:730) > > > ... 28 more > > > > > > My geometry column mapping: > > > <property name="geom" type="org.hibernatespatial.GeometryUserType" > > > > > <column name="geom" sql-type="MDSYS.SDO_GEOMETRY"/> > > > </property> > > > > > > I'm using version 1.0-m2 > > > > > > Tia > > > > > > Roy > > > > > > _______________________________________________ > > > hibernatespatial-users mailing list > > > [hidden email] > > > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ > > hibernatespatial-users > > > > > > > > > > > > > > -- > > Zeno Consulting, Inc. > > home: http://www.zenoconsulting.biz > > blog: http://zenoconsulting.wikidot.com > > p: 248.894.4922 > > f: 313.884.2977 > > _______________________________________________ > > hibernatespatial-users mailing list > > [hidden email] > > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ > > hibernatespatial-users > > _______________________________________________ > > hibernatespatial-users mailing list > > [hidden email] > > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ > > hibernatespatial-users > > _______________________________________________ > hibernatespatial-users mailing list > [hidden email] > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespati > al-users > _______________________________________________ hibernatespatial- > users mailing list [hidden email] > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespati > > al-users _______________________________________________ hibernatespatial-users mailing list [hidden email] http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users |
||||||||||||||||
|
Roy Braam
|
Some javascript/style in this post has been disabled (why?)
Hello Frank,I have created a spatial index: CREATE INDEX INDEX_COMMENTAAR on COMMENTAAR(GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX; The version info of the ojdbc14.jar: Met vriendelijke groet, Roy Braam B3partners BV 030 214 2082 06 21844955
_______________________________________________ hibernatespatial-users mailing list [hidden email] http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users |
||||||||||||||||
|
fgdrf
|
In reply to this post
by Roy Braam
Roy,
I guess you have forgotten the version number. Do you use thr right version tken from an 10g installation? After you created the index you still have the problem? cheers, Frank > Hello Frank, > > I have created a spatial index: > CREATE INDEX INDEX_COMMENTAAR on COMMENTAAR(GEOM) INDEXTYPE IS MDSYS. > SPATIAL_INDEX; > > The version info of the ojdbc14.jar: > > Met vriendelijke groet, > > Roy Braam > B3partners BV > 030 214 2082 > 06 21844955 > *From:* [hidden email] > *To:* Hibernate Spatial Users Discussion [mailto:hibernatespatial- > [hidden email]] > *Sent:* Mon, 22 Jun 2009 12:51:20 +0200 > *Subject:* Re: [hibernatespatial-users] Hibernate spatial with oracle > > Hello Roy, > > have you created a spatial index for the geom-column with the given > srid (28992)? If possible, please show the the part of the code where > yout try to persist a object. > > What version of the ojdb14.jar file are you using? > > Frank > > Karel, > > This is the script that i used to create the table: > > create table commentaar ( > > id number not null, > > bestemmingsplangebiedid varchar2(255 char), > > eigenaar varchar2(255 char), > > beleidsveld varchar2(255 char), > > tekst varchar2(255 char), > > geom SDO_GEOMETRY, > > primary key (id) > > ); > > So i'm sure that the geometry column type is SDO_GEOMETRY. I also > > inserted a geometry with the statement: > > > > INSERT INTO COMMENTAAR(ID,GEOM) VALUES(1, > > SDO_GEOMETRY(2003, > > 28992, > > NULL, > > SDO_ELEM_INFO_ARRAY(1,1003,1), > > SDO_ORDINATE_ARRAY(100000,400000, 200000,400000, 200000,500000, > > 100000,500000, 100000,400000) > > ) > > ); > > > > That worked fine.... > > It's the only record in the table. > > > > Roy > > *From:* Karel Maesen [mailto:[hidden email]] > > *To:* Hibernate Spatial Users Discussion [mailto:hibernatespatial- > > [hidden email]] > > *Sent:* Mon, 22 Jun 2009 12:19:57 +0200 > > *Subject:* Re: [hibernatespatial-users] Hibernate spatial with > oracle > > > > Roy, > > > > Are you sure that the Geometries in the table are of type > > SDO_GEOMETRY? In Oracle11g geometries can be declared using > > ST_GEOMETRY, which is currently unsupported by Hibernate Spatial. > > > > Regards, > > > > Karel > > On 22 Jun 2009, at 11:58, Roy Braam wrote: > > > > > Hello, > > > > > > I inserted a user_sdo_geom_metadata record: > > > INSERT INTO USER_SDO_GEOM_METADATA VALUES('COMMENTAAR','GEOM', > > > MDSYS.SDO_DIM_ARRAY( > > > MDSYS.SDO_DIM_ELEMENT('X',0,290000,0.005), > > > MDSYS.SDO_DIM_ELEMENT('Y',290000,650000,0.005) > > > ),28992); > > > > > > But i still get the same error... > > > > > > Roy > > > From: Davis Ford [mailto:[hidden email]] > > > To: Hibernate Spatial Users Discussion [mailto:hibernatespatial- > > > [hidden email]] > > > Sent: Thu, 18 Jun 2009 14:58:12 +0200 > > > Subject: Re: [hibernatespatial-users] Hibernate spatial with > oracle > > > > > > Did you setup the user_sdo_metadata table in Oracle? > > > > > > On Thu, Jun 18, 2009 at 8:01 AM, Roy Braam<[hidden email]> > > > > wrote: > > > > Hello List, > > > > > > > > We are using hibernatespatial for a while now to read and write > > > geometries > > > > to a postgres database. But now i want to use it on a oracle > 11g > > > database. > > > > I keep ketting the following error: > > > > INFO org.hibernate.dialect.Dialect - Using dialect: > > > > org.hibernatespatial.oracle.OracleSpatial10gDialect > > > > 2009-06-18 13:48:17,161 [http-8084-4] WARN > > > > org.hibernate.dialect.Oracle9Dialect - The Oracle9Dialect > dialect > > > has been > > > > deprecated; use either Oracle9iDialect or Oracle10gDialect > instead > > > > 2009-06-18 13:48:17,162 [http-8084-4] FATAL > > > > nl.b3p.put.rdp.persistance.MyEMFDatabase - Error initializing > > > > EntityManagerFactory: > > > > javax.persistence.PersistenceException: > > > org.hibernate.HibernateException: > > > > Wrong column type: geom, expected: geom > > > > at > > > > org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory > > > (Ejb3Configuration.java:737) > > > > at > > > > org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory > > > > (HibernatePersistence.java:121) > > > > at > > > > javax.persistence.Persistence.createEntityManagerFactory > > > (Persistence.java:51) > > > > at > > > > javax.persistence.Persistence.createEntityManagerFactory > > > (Persistence.java:33) > > > > at > > > > nl.b3p.put.rdp.persistance.MyEMFDatabase.openEntityManagerFactory > > > > (MyEMFDatabase.java:38) > > > > at > > > > nl.b3p.put.rdp.persistance.MyEMFDatabase.getEntityManagerFactory > > > > (MyEMFDatabase.java:50) > > > > at > > > > nl.b3p.put.rdp.persistance.MyEMFDatabase.createEntityManager > > > (MyEMFDatabase.java:116) > > > > at > > > > nl.b3p.put.rdp.struts.BaseDatabaseAction.execute > > > (BaseDatabaseAction.java:55) > > > > at > > > > org.apache.struts.action.RequestProcessor.processActionPerform > > > (RequestProcessor.java:431) > > > > at > > > > org.apache.struts.action.RequestProcessor.process > > > (RequestProcessor.java:236) > > > > at > > > > org.apache.struts.action.ActionServlet.process(ActionServlet. > java: > > > > > 1196) > > > > at org.apache.struts.action.ActionServlet.doGet > > > (ActionServlet.java:414) > > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) > > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > > > > at > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > > > > (ApplicationFilterChain.java:290) > > > > at > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter > > > (ApplicationFilterChain.java:206) > > > > at > > > > org.securityfilter.filter.SecurityFilter.doFilter > > > (SecurityFilter.java:188) > > > > at > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > > > > (ApplicationFilterChain.java:235) > > > > at > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter > > > (ApplicationFilterChain.java:206) > > > > at > > > > org.apache.catalina.core.StandardWrapperValve.invoke > > > (StandardWrapperValve.java:233) > > > > at > > > > org.apache.catalina.core.StandardContextValve.invoke > > > (StandardContextValve.java:191) > > > > at > > > > org.apache.catalina.core.StandardHostValve.invoke > > > (StandardHostValve.java:128) > > > > at > > > > org.apache.catalina.valves.ErrorReportValve.invoke > > > (ErrorReportValve.java:102) > > > > at > > > > org.apache.catalina.core.StandardEngineValve.invoke > > > (StandardEngineValve.java:109) > > > > at > > > > org.apache.catalina.connector.CoyoteAdapter.service > > > (CoyoteAdapter.java:286) > > > > at > > > > org.apache.coyote.http11.Http11Processor.process > > > (Http11Processor.java:845) > > > > at > > > > org.apache.coyote.http11.Http11Protocol > > > $Http11ConnectionHandler.process(Http11Protocol.java:583) > > > > at > > > > org.apache.tomcat.util.net.JIoEndpoint$Worker.run > > > (JIoEndpoint.java:447) > > > > at java.lang.Thread.run(Thread.java:619) > > > > Caused by: org.hibernate.HibernateException: Wrong column type: > > > geom, > > > > expected: geom > > > > at org.hibernate.mapping.Table.validateColumns(Table.java:261) > > > > at > > > > org.hibernate.cfg.Configuration.validateSchema(Configuration. > java: > > > > > 1083) > > > > at > > > > org.hibernate.tool.hbm2ddl.SchemaValidator.validate > > > (SchemaValidator.java:116) > > > > at > > > > org.hibernate.impl.SessionFactoryImpl.<init> > > > (SessionFactoryImpl.java:317) > > > > at > > > > org.hibernate.cfg.Configuration.buildSessionFactory > > > (Configuration.java:1294) > > > > at > > > > org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory > > > (AnnotationConfiguration.java:915) > > > > at > > > > org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory > > > (Ejb3Configuration.java:730) > > > > ... 28 more > > > > > > > > My geometry column mapping: > > > > <property name="geom" type="org.hibernatespatial.GeometryUserType > " > > > > > > > <column name="geom" sql-type="MDSYS.SDO_GEOMETRY"/> > > > > </property> > > > > > > > > I'm using version 1.0-m2 > > > > > > > > Tia > > > > > > > > Roy > > > > > > > > _______________________________________________ > > > > hibernatespatial-users mailing list > > > > [hidden email] > > > > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ > > > hibernatespatial-users > > > > > > > > > > > > > > > > > > > > -- > > > Zeno Consulting, Inc. > > > home: http://www.zenoconsulting.biz > > > blog: http://zenoconsulting.wikidot.com > > > p: 248.894.4922 > > > f: 313.884.2977 > > > _______________________________________________ > > > hibernatespatial-users mailing list > > > [hidden email] > > > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ > > > hibernatespatial-users > > > _______________________________________________ > > > hibernatespatial-users mailing list > > > [hidden email] > > > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ > > > hibernatespatial-users > > > > _______________________________________________ > > hibernatespatial-users mailing list > > [hidden email] > > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespa > ti > > al-users > > _______________________________________________ hibernatespatial- > > users mailing list [hidden email] > > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespa > ti > > > > al-users > > _______________________________________________ > hibernatespatial-users mailing list > [hidden email] > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespati > al-users > _______________________________________________ hibernatespatial- > users mailing list [hidden email] > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespati > > al-users _______________________________________________ hibernatespatial-users mailing list [hidden email] http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users |
||||||||||||||||
|
Roy Braam
|
In reply to this post
by fgdrf
Some javascript/style in this post has been disabled (why?)
Hello Frank,Sorry, something went wrong, here is the complete mail: I have created a spatial index: CREATE INDEX INDEX_COMMENTAAR on COMMENTAAR(GEOM) INDEXTYPE IS MDSYS.SPATIAL_INDEX; Here is the code where i get the error, we use a EntittyManager: ------- public static void openEntityManagerFactory(String persistenceUnit) throws Exception { log.info("ManagedPersistence.openEntityManagerFactory(" + persistenceUnit + ")"); if (emf != null) { log.warn("EntityManagerFactory already initialized: " + emf.toString()); return; } if (persistenceUnit == null || persistenceUnit.trim().length() == 0) { throw new Exception("PersistenceUnit cannot be left empty."); } try { emf = Persistence.createEntityManagerFactory(persistenceUnit); } catch (Throwable t) { log.fatal("Error initializing EntityManagerFactory: ", t); } if (emf == null) { throw new Exception("Cannot initialize EntityManagerFactory"); } log.info("EntityManagerFactory initialized: " + emf.toString()); } -------- The version info of the ojdbc14.jar: Specification-Vendor: Oracle Corporation Specification-Version: Oracle JDBC Driver version - "10.2.0.1.0" Implementation-Version: Oracle JDBC Driver version - "10.2.0.1.0" Implementation-Vendor: Oracle Corporation Implementation-Time: Wed Jun 22 18:55:48 2005 The exact code works with postgres/gis and the hibernate spatial lib. I changed some things: http://www.hibernatespatial.org/tutorial.html (see 'but i use oracle, so what do i do'). and i hoped it will work for oracle.... But obviously i forgot something.... Thanks, Roy
_______________________________________________ hibernatespatial-users mailing list [hidden email] http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users |
||||||||||||||||
|
Roy Braam
|
In reply to this post
by fgdrf
Some javascript/style in this post has been disabled (why?)
Hello,I removed the OJDBC14.jar and replaced it with a ojdbc5.jar from the oracle server with version: Implementation-Title: ojdbc5.jar Specification-Vendor: Oracle Corporation Specification-Version: Oracle JDBC Driver version - "11.1.0.6.0-Production" Implementation-Version: Oracle JDBC Driver version - "11.1.0.6.0-Production" Implementation-Vendor: Oracle Corporation Implementation-Time: Wed Jul 25 08:32:34 2007 But i still get the same error. Roy
_______________________________________________ hibernatespatial-users mailing list [hidden email] http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users |
||||||||||||||||
|
fgdrf
|
In reply to this post
by Roy Braam
Hello again,
> My geometry column mapping: > <property name="geom" type="org.hibernatespatial.GeometryUserType"> > <column name="geom" sql-type="MDSYS.SDO_GEOMETRY"/> > </property> I guess the mapping information is dublicated, try only <property name="geom" type="org.hibernatespatial.GeometryUserType"/> I use annotations and the special geometry part looks similarly like that: ... @Column(name="GEOMETRY", unique=false, nullable=true, insertable=true, updatable=true) @Type(type = "org.hibernatespatial.GeometryUserType") public Geometry getGeometry() { return geometry; } .... good luck ;) Frank _______________________________________________ hibernatespatial-users mailing list [hidden email] http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users |
||||||||||||||||
|
Karel Maesen
|
In reply to this post
by Roy Braam
Roy,
I had a second look at the stacktrace. It seems like you are using the hbm2dll for some reason (automatic schema generation or schema update). Is that correct? If you do, could you try to disable it? A second thing that might work is changing the mapping to: <property name="geom" type="org.hibernatespatial.GeometryUserType"> <column name="geom" sql-type="SDO_GEOMETRY"/> </property> Regards, Karel Maesen On 22 Jun 2009, at 13:51, Roy Braam wrote: > Hello, > I removed the OJDBC14.jar and replaced it with a ojdbc5.jar from > the oracle server with version: > Implementation-Title: ojdbc5.jar > Specification-Vendor: Oracle Corporation > Specification-Version: Oracle JDBC Driver version - "11.1.0.6.0- > Production" > Implementation-Version: Oracle JDBC Driver version - "11.1.0.6.0- > Production" > Implementation-Vendor: Oracle Corporation > Implementation-Time: Wed Jul 25 08:32:34 2007 > > But i still get the same error. > Roy > From: Frank Gasdorf [mailto:[hidden email]] > To: Hibernate Spatial Users Discussion [mailto:hibernatespatial- > [hidden email]] > Sent: Mon, 22 Jun 2009 13:29:35 +0200 > Subject: Re: [hibernatespatial-users] Hibernate spatial with oracle > > Roy, > > I guess you have forgotten the version number. Do you use thr right > version tken from an 10g installation? > After you created the index you still have the problem? > > cheers, Frank > > > Hello Frank, > > > > I have created a spatial index: > > CREATE INDEX INDEX_COMMENTAAR on COMMENTAAR(GEOM) INDEXTYPE IS > MDSYS. > > SPATIAL_INDEX; > > > > The version info of the ojdbc14.jar: > > > > Met vriendelijke groet, > > > > Roy Braam > > B3partners BV > > 030 214 2082 > > 06 21844955 > > *From:* [hidden email] > > *To:* Hibernate Spatial Users Discussion [mailto:hibernatespatial- > > [hidden email]] > > *Sent:* Mon, 22 Jun 2009 12:51:20 +0200 > > *Subject:* Re: [hibernatespatial-users] Hibernate spatial with > oracle > > > > Hello Roy, > > > > have you created a spatial index for the geom-column with the given > > srid (28992)? If possible, please show the the part of the code > where > > yout try to persist a object. > > > > What version of the ojdb14.jar file are you using? > > > > Frank > > > > Karel, > > > This is the script that i used to create the table: > > > create table commentaar ( > > > id number not null, > > > bestemmingsplangebiedid varchar2(255 char), > > > eigenaar varchar2(255 char), > > > beleidsveld varchar2(255 char), > > > tekst varchar2(255 char), > > > geom SDO_GEOMETRY, > > > primary key (id) > > > ); > > > So i'm sure that the geometry column type is SDO_GEOMETRY. I also > > > inserted a geometry with the statement: > > > > > > INSERT INTO COMMENTAAR(ID,GEOM) VALUES(1, > > > SDO_GEOMETRY(2003, > > > 28992, > > > NULL, > > > SDO_ELEM_INFO_ARRAY(1,1003,1), > > > SDO_ORDINATE_ARRAY(100000,400000, 200000,400000, 200000,500000, > > > 100000,500000, 100000,400000) > > > ) > > > ); > > > > > > That worked fine.... > > > It's the only record in the table. > > > > > > Roy > > > *From:* Karel Maesen [mailto:[hidden email]] > > > *To:* Hibernate Spatial Users Discussion [mailto:hibernatespatial- > > > [hidden email]] > > > *Sent:* Mon, 22 Jun 2009 12:19:57 +0200 > > > *Subject:* Re: [hibernatespatial-users] Hibernate spatial with > > oracle > > > > > > Roy, > > > > > > Are you sure that the Geometries in the table are of type > > > SDO_GEOMETRY? In Oracle11g geometries can be declared using > > > ST_GEOMETRY, which is currently unsupported by Hibernate Spatial. > > > > > > Regards, > > > > > > Karel > > > On 22 Jun 2009, at 11:58, Roy Braam wrote: > > > > > > > Hello, > > > > > > > > I inserted a user_sdo_geom_metadata record: > > > > INSERT INTO USER_SDO_GEOM_METADATA VALUES('COMMENTAAR','GEOM', > > > > MDSYS.SDO_DIM_ARRAY( > > > > MDSYS.SDO_DIM_ELEMENT('X',0,290000,0.005), > > > > MDSYS.SDO_DIM_ELEMENT('Y',290000,650000,0.005) > > > > ),28992); > > > > > > > > But i still get the same error... > > > > > > > > Roy > > > > From: Davis Ford [mailto:[hidden email]] > > > > To: Hibernate Spatial Users Discussion [mailto:hibernatespatial- > > > > [hidden email]] > > > > Sent: Thu, 18 Jun 2009 14:58:12 +0200 > > > > Subject: Re: [hibernatespatial-users] Hibernate spatial with > > oracle > > > > > > > > Did you setup the user_sdo_metadata table in Oracle? > > > > > > > > On Thu, Jun 18, 2009 at 8:01 AM, Roy > Braam<[hidden email]> > > > > > > wrote: > > > > > Hello List, > > > > > > > > > > We are using hibernatespatial for a while now to read and > write > > > > geometries > > > > > to a postgres database. But now i want to use it on a oracle > > 11g > > > > database. > > > > > I keep ketting the following error: > > > > > INFO org.hibernate.dialect.Dialect - Using dialect: > > > > > org.hibernatespatial.oracle.OracleSpatial10gDialect > > > > > 2009-06-18 13:48:17,161 [http-8084-4] WARN > > > > > org.hibernate.dialect.Oracle9Dialect - The Oracle9Dialect > > dialect > > > > has been > > > > > deprecated; use either Oracle9iDialect or Oracle10gDialect > > instead > > > > > 2009-06-18 13:48:17,162 [http-8084-4] FATAL > > > > > nl.b3p.put.rdp.persistance.MyEMFDatabase - Error initializing > > > > > EntityManagerFactory: > > > > > javax.persistence.PersistenceException: > > > > org.hibernate.HibernateException: > > > > > Wrong column type: geom, expected: geom > > > > > at > > > > > org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory > > > > (Ejb3Configuration.java:737) > > > > > at > > > > > > org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory > > > > > > (HibernatePersistence.java:121) > > > > > at > > > > > javax.persistence.Persistence.createEntityManagerFactory > > > > (Persistence.java:51) > > > > > at > > > > > javax.persistence.Persistence.createEntityManagerFactory > > > > (Persistence.java:33) > > > > > at > > > > > > nl.b3p.put.rdp.persistance.MyEMFDatabase.openEntityManagerFactory > > > > > > (MyEMFDatabase.java:38) > > > > > at > > > > > > nl.b3p.put.rdp.persistance.MyEMFDatabase.getEntityManagerFactory > > > > > > (MyEMFDatabase.java:50) > > > > > at > > > > > nl.b3p.put.rdp.persistance.MyEMFDatabase.createEntityManager > > > > (MyEMFDatabase.java:116) > > > > > at > > > > > nl.b3p.put.rdp.struts.BaseDatabaseAction.execute > > > > (BaseDatabaseAction.java:55) > > > > > at > > > > > org.apache.struts.action.RequestProcessor.processActionPerform > > > > (RequestProcessor.java:431) > > > > > at > > > > > org.apache.struts.action.RequestProcessor.process > > > > (RequestProcessor.java:236) > > > > > at > > > > > org.apache.struts.action.ActionServlet.process(ActionServlet. > > java: > > > > > > > 1196) > > > > > at org.apache.struts.action.ActionServlet.doGet > > > > (ActionServlet.java:414) > > > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java: > 617) > > > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java: > 717) > > > > > at > > > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > > > > > > (ApplicationFilterChain.java:290) > > > > > at > > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter > > > > (ApplicationFilterChain.java:206) > > > > > at > > > > > org.securityfilter.filter.SecurityFilter.doFilter > > > > (SecurityFilter.java:188) > > > > > at > > > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter > > > > > > (ApplicationFilterChain.java:235) > > > > > at > > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter > > > > (ApplicationFilterChain.java:206) > > > > > at > > > > > org.apache.catalina.core.StandardWrapperValve.invoke > > > > (StandardWrapperValve.java:233) > > > > > at > > > > > org.apache.catalina.core.StandardContextValve.invoke > > > > (StandardContextValve.java:191) > > > > > at > > > > > org.apache.catalina.core.StandardHostValve.invoke > > > > (StandardHostValve.java:128) > > > > > at > > > > > org.apache.catalina.valves.ErrorReportValve.invoke > > > > (ErrorReportValve.java:102) > > > > > at > > > > > org.apache.catalina.core.StandardEngineValve.invoke > > > > (StandardEngineValve.java:109) > > > > > at > > > > > org.apache.catalina.connector.CoyoteAdapter.service > > > > (CoyoteAdapter.java:286) > > > > > at > > > > > org.apache.coyote.http11.Http11Processor.process > > > > (Http11Processor.java:845) > > > > > at > > > > > org.apache.coyote.http11.Http11Protocol > > > > $Http11ConnectionHandler.process(Http11Protocol.java:583) > > > > > at > > > > > org.apache.tomcat.util.net.JIoEndpoint$Worker.run > > > > (JIoEndpoint.java:447) > > > > > at java.lang.Thread.run(Thread.java:619) > > > > > Caused by: org.hibernate.HibernateException: Wrong column > type: > > > > geom, > > > > > expected: geom > > > > > at org.hibernate.mapping.Table.validateColumns(Table.java:261) > > > > > at > > > > > org.hibernate.cfg.Configuration.validateSchema(Configuration. > > java: > > > > > > > 1083) > > > > > at > > > > > org.hibernate.tool.hbm2ddl.SchemaValidator.validate > > > > (SchemaValidator.java:116) > > > > > at > > > > > org.hibernate.impl.SessionFactoryImpl.<init> > > > > (SessionFactoryImpl.java:317) > > > > > at > > > > > org.hibernate.cfg.Configuration.buildSessionFactory > > > > (Configuration.java:1294) > > > > > at > > > > > org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory > > > > (AnnotationConfiguration.java:915) > > > > > at > > > > > org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory > > > > (Ejb3Configuration.java:730) > > > > > ... 28 more > > > > > > > > > > My geometry column mapping: > > > > > <property name="geom" > type="org.hibernatespatial.GeometryUserType > > " > > > > > > > > > <column name="geom" sql-type="MDSYS.SDO_GEOMETRY"/> > > > > > </property> > > > > > > > > > > I'm using version 1.0-m2 > > > > > > > > > > Tia > > > > > > > > > > Roy > > > > > > > > > > _______________________________________________ > > > > > hibernatespatial-users mailing list > > > > > [hidden email] > > > > > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ > > > > hibernatespatial-users > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > Zeno Consulting, Inc. > > > > home: http://www.zenoconsulting.biz > > > > blog: http://zenoconsulting.wikidot.com > > > > p: 248.894.4922 > > > > f: 313.884.2977 > > > > _______________________________________________ > > > > hibernatespatial-users mailing list > > > > [hidden email] > > > > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ > > > > hibernatespatial-users > > > > _______________________________________________ > > > > hibernatespatial-users mailing list > > > > [hidden email] > > > > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ > > > > hibernatespatial-users > > > > > > _______________________________________________ > > > hibernatespatial-users mailing list > > > [hidden email] > > > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ > hibernatespa > > ti > > > al-users > > > _______________________________________________ hibernatespatial- > > > users mailing list hibernatespatial- > [hidden email] > > > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ > hibernatespa > > ti > > > > > > al-users > > > > _______________________________________________ > > hibernatespatial-users mailing list > > [hidden email] > > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ > hibernatespati > > al-users > > _______________________________________________ hibernatespatial- > > users mailing list [hidden email] > > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ > hibernatespati > > > > al-users > > > _______________________________________________ > hibernatespatial-users mailing list > [hidden email] > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ > hibernatespatial-users > _______________________________________________ > hibernatespatial-users mailing list > [hidden email] > http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ > hibernatespatial-users _______________________________________________ hibernatespatial-users mailing list [hidden email] http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users |
||||||||||||||||
|
Roy Braam
|
Some javascript/style in this post has been disabled (why?)
Thanks all,I removed a hbm2ddl configuration setting: <property name="hibernate.hbm2ddl.auto" value="validate"/> And after that, i got some error that had to do with the c3p0 connection pool, i found this thread: http://n2.nabble.com/C3P0-Connection-pool-support-td1141094.html. I removed the c3p0 settings. So it seems to work now, many thanks! Roy Braam From: Karel Maesen [mailto:[hidden email]] _______________________________________________ hibernatespatial-users mailing list [hidden email] http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users |
||||||||||||||||
| Free Embeddable Forum Powered by Nabble | Help |
