在定义PostGIS连接时未找到Oracle连接 [英] Not finding Oracle Connection when a PostGIS connection is defined
问题描述
我有一个运行在Spring 3.1.1上的应用程序，Hibernate 3.6.0.Final和Tomcat 8.0.20上的Hibernate Spatial 1.1.1。到目前为止，我们使用的是Oracle 11.2.0.4，但我们希望迁移到PostgreSQL 9.2-1002.jdbc4 / PostGIS 2.1.6。
我们将在不同阶段迁移数据库模式，因此在某个阶段，我们需要一些连接来与Oracle合作，一些连接使用PostGIS。为了开始开发和测试这个，我删除了任何Oracle Maven依赖项，并添加了必要的与Postgres一起工作，如 在Tomcat中 context.xml 我现在配置了一个单一连接： 这很好。我可以在数据库中插入一条记录，首先在其几何字段中输入一个空值，然后我将用该点的坐标值更新它。该字段定义为： 这很有效，没问题。一旦我包含Maven对Oracle的依赖关系，问题就来了： 尽管我没有配置任何其他连接，也没有更改我的项目中的任何内容以便使用Oracle ，该记录按预期插入到Postgres中，但是当涉及到更新其几何字段时，我会在下面粘贴堆栈跟踪，即使连接保持不变，这也是意外的发现Oracle连接问题。 org.hibernatespatial.helper.FinderException：无法从PreparedStatement获取OracleSpatial Connection对象。 我不明白为什么Hibernate能够将数据插入到数据库中，但在尝试更新空间数据时会查找Oracle连接，仅当添加不应使用的Oracle Maven依赖项时，因为我保留为PostGIS配置的连接。 任何关于我可能做错的想法？ 预先致谢。 编辑：看起来，当启动Tomcat并初始化GeometryUserType时，配置方法被称为null作为属性。所以它默认为一个spatialDialect，它将是第一个从可用的中找到的。由于有两个（Oracle和PostGIS），它只会选择第一个（这恰好是Oracle）。 所以我必须在配置中丢失一些东西，但我认为这足以进入* persistence.xml *并声明持久化单元应该使用该方言。 正如所评论的，它让我觉得Hibernate将默认使用spatialDialect，它将首先从可用的中找到，在这种情况下，它是Oracle，尽管在persistence.xml中指定了它。 我发现的第一个解决方法是在实体中注释，对于GeometryUserType，我会使用Postgis方言： 这将迫使Hibernate为该实体使用Postgis。第二种解决方法对我更好（我需要能够根据持久性单元和环境对其进行配置并为不同的方言使用不同的方言）在持久单元中使用映射文件。 在我的pom文件中，我将使用Maven配置文件将该映射文件设置为所需的映射文件和变量。 或者： 所以我会举例来说 并且 我想知道是否有更好的方法来做到这一点，但在这些日子里我找不到，或者我在这里回答。希望这有助于某人。 I have an application running with Spring 3.1.1 , Hibernate 3.6.0.Final and Hibernate Spatial 1.1.1 on Tomcat 8.0.20. Until now, we were using Oracle 11.2.0.4 , but we want to migrate to PostgreSQL 9.2-1002.jdbc4 / PostGIS 2.1.6. We will migrate the database schemas on different phases, so at some stage, we will need some connections to be working with Oracle and some with PostGIS. In order to begin developing and testing this, I removed any Oracle Maven dependency and added the necessary ones to work with Postgres as described in Hibernate Spatial 1.1.1 Tutorial, mostly : In Tomcat context.xml I have configured one single connection by now : This works fine. I can insert a record into the database with an empty value in its Geometry field first, and then I will update it with a coordinate value for that point. The field is defined as : That works, no problem. The issue comes as soon as I include Maven dependency for Oracle : Even though I don't configure any additional connection nor change anything in my project in order to use Oracle, the record is inserted in Postgres as expected, but when it comes to update its Geometry field, I get the stacktrace pasted below, that is an unexpected "Problem finding Oracle Connection" even if the connection stays the same. org.hibernatespatial.helper.FinderException: Couldn't get at the OracleSpatial Connection object from the PreparedStatement. I can't understand why Hibernate would be able to insert the data into the database, but would look for an Oracle connection when trying to update spatial data, only when I add an Oracle Maven dependency which shouldn't be used, as I keep my connection configured for PostGIS. Any idea about what I could be doing wrong? Thanks in advance. EDIT : It seems that when starting Tomcat and initializing GeometryUserType, the configure method is called with null as properties. So it defaults to a spatialDialect which will be the first it finds from the available. As there are two (Oracle and PostGIS) it will just pick the first one (which happens to be Oracle). So I must be missing something in the configuration, but I thought it would be enough to go to the * persistence.xml * and declare that the persistence unit should use that dialect.
<依赖性>
< groupId> org.hibernatespatial< / groupId>
< artifactId> hibernate-spatial-postgis< / artifactId>
< version> 1.1.1< / version>
< /依赖关系>
<资源accessToUnderlyingConnectionAllowed =trueauth =容器
autoReconnect =truedriverClassName =org .postgresql.Driver
logAbandoned = 真 MAXWAIT = 5000 minEvictableIdleTimeMillis = 60000
NAME = JDBC / DBNAME numTestsPerEvictionRun = 3 密码= XXX
removeAbandoned = 真 removeAbandonedTimeout = 60 testOnBorrow = 真正的
testWhileIdle = 真 timeBetweenEvictionRunsMillis = 60000
型= javax.sql.DataSource中的 URL =的jdbc：在PostgreSQL：// servername：5432 / dbname
username =usernamevalidationQuery =select 1/>
@Type（type =org.hibernatespatial.GeometryUserType）
@Column（ name =geom，columnDefinition =Geometry，nullable = true）
保护几何几何;
< dependency>
< artifactId> hibernate-spatial-oracle< / artifactId>
< groupId> org.hibernatespatial< / groupId>
< version> 1.1.1< / version>
< /依赖关系>
< persistence-unit name =pu_nametransaction-type =JTA>
< provider> org.hibernate.ejb.HibernatePersistence< / provider>
< jta-data-source> $ {jta.datasource.prefix} datasource_name< / jta-data-source>
< class> com.myorganization.MyClass< / class>
< exclude-unlisted-classes> true< / exclude-unlisted-classes>
<属性>
< property name =hibernate.dialectvalue =org.hibernatespatial.postgis.PostgisDialect/>
（...）
<$ p $
at org.hibernate.ejb.AbstractEntityManagerImpl.convert（AbstractEntityManagerImpl.java:1389）
at javax.persistence.PersistenceException：org.hibernate.HibernateException： org.hibernate.ejb.AbstractEntityManagerImpl.convert（AbstractEntityManagerImpl.java:1317）
位于org.hibernate.ejb.AbstractEntityManagerImpl.convert（AbstractEntityManagerImpl.java:1323）
位于org.hibernate.ejb.AbstractEntityManagerImpl。在sun.reflect.NativeMethodAccessorImpl.invoke在sun.reflect.NativeMethodAccessorImpl.invoke0冲洗（AbstractEntityManagerImpl.java:965）
（本机方法）
（NativeMethodAccessorImpl.java:62）
在阳光下。 reflect.DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl.java:43）
在java.lang.reflect.Method.invoke（Method.java:497）
在org.springframework.orm.jpa.ExtendedEntityManagerCreator $ ExtendedEntityManagerInvocation Handler.invoke（ExtendedEntityManagerCreator.java:365）
at com.sun.proxy。$ Proxy62.flush（Unknown Source）
at sun.reflect.NativeMethodAccessorImpl.invoke0（Native Method）
at sun.reflect.NativeMethodAccessorImpl.invoke（NativeMethodAccessorImpl.java:62）
at sun.reflect.DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl.java:43）
at java.lang.reflect.Method.invoke（Method。 Java的：497）
在org.springframework.orm.jpa.SharedEntityManagerCreator $ SharedEntityManagerInvocationHandler.invoke（SharedEntityManagerCreator.java:240）
在com.sun.proxy $ Proxy45.flush（来源不明）$ b。 $ b at com.mapflow.geotagdata.common.processing.impl.ProcessorInnerStepsImpl $ 6.executeTransactionalCommand（ProcessorInnerStepsImpl.java:1056）
at com.mapflow.geotagdata.common.processing.impl.ProcessorInnerStepsImpl $ 6.executeTransactionalCommand（ProcessorInnerStepsImpl。 java：1）
at com.mapflow.geotagdata.common.transactions.TransactionalComm andExecutor.executeTxRequiresNew（TransactionalCommandExecutor.java:37）
at com.mapflow.geotagdata.common.transactions.TransactionalCommandExecutor $$ FastClassByCGLIB $$ 7beb81b5.invoke（<生成>）
at net.sf.cglib .proxy.MethodProxy.invoke（MethodProxy.java:191）
at org.springframework.aop.framework.Cglib2AopProxy $ CglibMethodInvocation.invokeJoinpoint（Cglib2AopProxy.java:689）
at org.springframework.aop.framework .ReflectiveMethodInvocation.proceed（ReflectiveMethodInvocation.java:150）
在org.springframework.transaction.interceptor.TransactionInterceptor.invoke（TransactionInterceptor.java:110）
在org.springframework.aop.framework.ReflectiveMethodInvocation.proceed （ReflectiveMethodInvocation.java:172）
at org.springframework.aop.framework.Cglib2AopProxy $ DynamicAdvisedInterceptor.intercept（Cglib2AopProxy.java:622）
at com.mapflow.geotagdata.common.transactions.TransactionalCommandExecutor $$ EnhancerByCGLIB $$ 4c535b1b.execute TxRequiresNew（< generated>）
at com.mapflow.geotagdata.common.processing.impl.ProcessorInnerStepsImpl.synchPendingTaggedBatchToDB（ProcessorInnerStepsImpl.java:1012）
at com.mapflow.geotagdata.common.processing.impl .ProcessorInnerStepsImpl.access $ 0（ProcessorInnerStepsImpl.java:996）
。在在com.mapflow.geotagdata com.mapflow.geotagdata.common.processing.impl.ProcessorInnerStepsImpl $ 5.call（ProcessorInnerStepsImpl.java:969）
.common.processing.impl.ProcessorInnerStepsImpl $ 5.call（ProcessorInnerStepsImpl.java:1）
在com.mapflow.geotagdata.common.processing.utility.RetryOnExceptionBuilder.execute（RetryOnExceptionBuilder.java:96）
。在com.mapflow.geotagdata.common.processing.impl.ProcessorInnerStepsImpl.dataTaggingPhase（ProcessorInnerStepsImpl.java:964）
at com.mapflow.geotagdata.common.processing.impl.ProcessorOuterStepsImpl.doOuterStepLineByLineInnerSteps（ProcessorOuterStepsImpl.java:107）
在com.mapflow.geotagdata.common.proc essing.impl.ProcessorImpl.process（ProcessorImpl.java:149）
at com.mapflow.geotagdata.common.processing.impl.ProcessorImpl.processFile（ProcessorImpl.java:80）
at sun.reflect。 NativeMethodAccessorImpl.invoke0（本机方法）
at sun.reflect.NativeMethodAccessorImpl.invoke（NativeMethodAccessorImpl.java:62）
at sun.reflect.DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl.java:43）
at java.lang.reflect.Method.invoke（Method.java:497）
处org.springframework.aop org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection（AopUtils.java:318）
。 framework.ReflectiveMethodInvocation.invokeJoinpoint（ReflectiveMethodInvocation.java:183）
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed（ReflectiveMethodInvocation.java:150）
at org.springframework.aop.interceptor.AsyncExecutionInterceptor $ 1 .call（AsyncExecutionInterceptor.java:80）
at java.util.concurrent.FutureTask.run（Fut ureTask.java:266）在java.util.concurrent.ThreadPoolExecutor.runWorker（ThreadPoolExecutor.java:1142
）
在java.util.concurrent.ThreadPoolExecutor中的$ Worker.run（ThreadPoolExecutor.java:617）
在java.lang.Thread.run（Thread.java:745）
引起：org.hibernate.HibernateException：在org.hibernatespatial.oracle.OracleJDBCTypeFactory.createStruct中发现Oracle Connection
的问题（OracleJDBCTypeFactory.java:38）在org.hibernatespatial.oracle.SDOGeometry.store（SDOGeometry.java:154）
在org.hibernatespatial.oracle.SDOGeometryType.conv2DBGeometry（SDOGeometryType.java:88）
。在org.hibernatespatial.oracle.SDOGeometryType.nullSafeSet（SDOGeometryType.java:77）
处org.hibernate.type org.hibernatespatial.GeometryUserType.nullSafeSet（GeometryUserType.java:201）
。 CustomType.nullSafeSet（CustomType.java:140）
at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate（AbstractEntityPersister.java:2184）
at org.hibernate.persister.entity.AbstractEntityPersister.update（AbstractEntityPersister.java:2559）
处org.hibernate作为org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert（AbstractEntityPersister.java:2495）
。 persister.entity.AbstractEntityPersister.update（AbstractEntityPersister.java:2822）
在org.hibernate.action.EntityUpdateAction.execute（EntityUpdateAction.java:113）
在org.hibernate.engine.ActionQueue.execute（ ActionQueue.java:273）
在org.hibernate.engine.ActionQueue.executeActions（ActionQueue.java:265）
在org.hibernate.engine.ActionQueue.executeActions（ActionQueue.java:185）$ b在org.hibernate.event.def.AbstractFlushingEventListener.performExecutions（AbstractFlushingEventListener.java:321）
$ b在org.hibernate.event.def.DefaultFlushEventListener.onFlush（DefaultFlushEventListener.java:51）
。在组织.hibernate.impl.SessionImpl.flush（SessionImpl.java:1216）
at org.hibernate.ejb.AbstractEntityMana gerImpl.flush（AbstractEntityManagerImpl.java:962）
... 44 more
导致：org.hibernatespatial.helper.FinderException：无法从PreparedStatement获取OracleSpatial Connection对象。在org.hibernatespatial.oracle.DefaultConnectionFinder.find（DefaultConnectionFinder.java:82）
在org.hibernatespatial.oracle.DefaultConnectionFinder.find（DefaultConnectionFinder.java:68）
在org.hibernatespatial .oracle.DefaultConnectionFinder.find（DefaultConnectionFinder.java:68）
at org.hibernatespatial.oracle.DefaultConnectionFinder.find（DefaultConnectionFinder.java:51）
at org.hibernatespatial.oracle.OracleJDBCTypeFactory.createStruct（OracleJDBCTypeFactory .java：36）
... 61 more
@TypeDefs（{@ TypeDef（name =org.hibernatespatial.GeometryUserType，
parameters = {@ org.hibernate.annotations.Parameter（name =dialect ，value =org.hibernatespatial.postgis.PostgisDialect）}，
typeClass = org.hibernatespatial.GeometryUserType.class）}）
< persistence-unit name =persistence_unit_nametransaction-type =JTA>
< provider> org.hibernate.ejb.HibernatePersistence< / provider>
< jta-data-source> jta_data_source_name< / jta-data-source>
< mapping-file> $ {hibernate.mappingfile}< / mapping-file>
< class>（...）< / class>
< hibernate.mappingfile> oracle.hbm.xml< /hibernate.mappingfile>
< hibernate.mappingfile> postgis.hbm.xml< /hibernate.mappingfile>
postgis.hbm.xml file：
<？xml version =1.0encoding =utf-8？>
<！DOCTYPE hibernate-mapping PUBLIC
- // Hibernate / Hibernate映射DTD // EN
http://www.hibernate.org/dtd/hibernate-mapping- 3.0.dtd>
< hibernate-mapping>
< typedef name =org.hibernatespatial.GeometryUserTypeclass =org.hibernatespatial.GeometryUserType>
< param name =dialect> org.hibernatespatial.postgis.PostgisDialect< / param>
< / typedef>
< / hibernate-mapping>
oracle.hbm.xml ：
<？xml version =1.0encoding =utf-8？>
<！DOCTYPE hibernate-mapping PUBLIC
- // Hibernate / Hibernate映射DTD // EN
http://www.hibernate.org/dtd/hibernate-mapping- 3.0.dtd>
< hibernate-mapping>
< typedef name =org.hibernatespatial.GeometryUserTypeclass =org.hibernatespatial.GeometryUserType>
< param name =dialect> org.hibernatespatial.oracle.OracleSpatial10gDialect< / param>
< / typedef>
< / hibernate-mapping>
<dependency>
<groupId>org.hibernatespatial</groupId>
<artifactId>hibernate-spatial-postgis</artifactId>
<version>1.1.1</version>
</dependency>
<Resource accessToUnderlyingConnectionAllowed="true" auth="Container"
autoReconnect="true" driverClassName="org.postgresql.Driver"
logAbandoned="true" maxWait="5000" minEvictableIdleTimeMillis="60000"
name="jdbc/dbname" numTestsPerEvictionRun="3" password="xxx"
removeAbandoned="true" removeAbandonedTimeout="60" testOnBorrow="true"
testWhileIdle="true" timeBetweenEvictionRunsMillis="60000"
type="javax.sql.DataSource" url="jdbc:postgresql://servername:5432/dbname"
username="username" validationQuery="select 1" />
@Type(type = "org.hibernatespatial.GeometryUserType")
@Column(name = "geom", columnDefinition="Geometry", nullable = true)
protected Geometry geom;
<dependency>
<artifactId>hibernate-spatial-oracle</artifactId>
<groupId>org.hibernatespatial</groupId>
<version>1.1.1</version>
</dependency>
<persistence-unit name="pu_name" transaction-type="JTA">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<jta-data-source>${jta.datasource.prefix}datasource_name</jta-data-source>
<class>com.myorganization.MyClass</class>
<exclude-unlisted-classes>true</exclude-unlisted-classes>
<properties>
<property name="hibernate.dialect" value="org.hibernatespatial.postgis.PostgisDialect" />
(...)
javax.persistence.PersistenceException: org.hibernate.HibernateException: Problem finding Oracle Connection
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1389)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1317)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1323)
at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:965)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:365)
at com.sun.proxy.$Proxy62.flush(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:240)
at com.sun.proxy.$Proxy45.flush(Unknown Source)
at com.mapflow.geotagdata.common.processing.impl.ProcessorInnerStepsImpl$6.executeTransactionalCommand(ProcessorInnerStepsImpl.java:1056)
at com.mapflow.geotagdata.common.processing.impl.ProcessorInnerStepsImpl$6.executeTransactionalCommand(ProcessorInnerStepsImpl.java:1)
at com.mapflow.geotagdata.common.transactions.TransactionalCommandExecutor.executeTxRequiresNew(TransactionalCommandExecutor.java:37)
at com.mapflow.geotagdata.common.transactions.TransactionalCommandExecutor$$FastClassByCGLIB$$7beb81b5.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
at com.mapflow.geotagdata.common.transactions.TransactionalCommandExecutor$$EnhancerByCGLIB$$4c535b1b.executeTxRequiresNew(<generated>)
at com.mapflow.geotagdata.common.processing.impl.ProcessorInnerStepsImpl.synchPendingTaggedBatchToDB(ProcessorInnerStepsImpl.java:1012)
at com.mapflow.geotagdata.common.processing.impl.ProcessorInnerStepsImpl.access$0(ProcessorInnerStepsImpl.java:996)
at com.mapflow.geotagdata.common.processing.impl.ProcessorInnerStepsImpl$5.call(ProcessorInnerStepsImpl.java:969)
at com.mapflow.geotagdata.common.processing.impl.ProcessorInnerStepsImpl$5.call(ProcessorInnerStepsImpl.java:1)
at com.mapflow.geotagdata.common.processing.utility.RetryOnExceptionBuilder.execute(RetryOnExceptionBuilder.java:96)
at com.mapflow.geotagdata.common.processing.impl.ProcessorInnerStepsImpl.dataTaggingPhase(ProcessorInnerStepsImpl.java:964)
at com.mapflow.geotagdata.common.processing.impl.ProcessorOuterStepsImpl.doOuterStepLineByLineInnerSteps(ProcessorOuterStepsImpl.java:107)
at com.mapflow.geotagdata.common.processing.impl.ProcessorImpl.process(ProcessorImpl.java:149)
at com.mapflow.geotagdata.common.processing.impl.ProcessorImpl.processFile(ProcessorImpl.java:80)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:80)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.HibernateException: Problem finding Oracle Connection
at org.hibernatespatial.oracle.OracleJDBCTypeFactory.createStruct(OracleJDBCTypeFactory.java:38)
at org.hibernatespatial.oracle.SDOGeometry.store(SDOGeometry.java:154)
at org.hibernatespatial.oracle.SDOGeometryType.conv2DBGeometry(SDOGeometryType.java:88)
at org.hibernatespatial.oracle.SDOGeometryType.nullSafeSet(SDOGeometryType.java:77)
at org.hibernatespatial.GeometryUserType.nullSafeSet(GeometryUserType.java:201)
at org.hibernate.type.CustomType.nullSafeSet(CustomType.java:140)
at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2184)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2559)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2495)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2822)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:113)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:962)
... 44 more
Caused by: org.hibernatespatial.helper.FinderException: Couldn't get at the OracleSpatial Connection object from the PreparedStatement.
at org.hibernatespatial.oracle.DefaultConnectionFinder.find(DefaultConnectionFinder.java:82)
at org.hibernatespatial.oracle.DefaultConnectionFinder.find(DefaultConnectionFinder.java:68)
at org.hibernatespatial.oracle.DefaultConnectionFinder.find(DefaultConnectionFinder.java:68)
at org.hibernatespatial.oracle.DefaultConnectionFinder.find(DefaultConnectionFinder.java:51)
at org.hibernatespatial.oracle.OracleJDBCTypeFactory.createStruct(OracleJDBCTypeFactory.java:36)
... 61 more
As commented, it looked to me that Hibernate will default to a spatialDialect which will be the first it finds from the available, and in that case it was Oracle, despite whatever was specified in the persistence.xml.
The first workaround that I found was to annotate in the entity that for the GeometryUserType I would use Postgis dialect as in :
@TypeDefs({@TypeDef(name="org.hibernatespatial.GeometryUserType",
parameters={@org.hibernate.annotations.Parameter(name="dialect",value="org.hibernatespatial.postgis.PostgisDialect")},
typeClass=org.hibernatespatial.GeometryUserType.class)})
That would force Hibernate to use Postgis for that entity.
The second workaround, which worked better for me (I need to be able to configure this and use different dialects for one entity depending on the persistence unit and the environment) is to use a mapping file in the persistence unit.
<persistence-unit name="persistence_unit_name" transaction-type="JTA">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<jta-data-source>jta_data_source_name</jta-data-source>
<mapping-file>${hibernate.mappingfile}</mapping-file>
<class>(...)</class>
In my pom file, I will make that mapping file to the one that I need, using Maven profiles and variables.
<hibernate.mappingfile>oracle.hbm.xml</hibernate.mappingfile>
Or :
<hibernate.mappingfile>postgis.hbm.xml</hibernate.mappingfile>
So I would have for example a postgis.hbm.xml file :
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<typedef name="org.hibernatespatial.GeometryUserType" class="org.hibernatespatial.GeometryUserType" >
<param name="dialect">org.hibernatespatial.postgis.PostgisDialect</param>
</typedef>
</hibernate-mapping>
And an oracle.hbm.xml :
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<typedef name="org.hibernatespatial.GeometryUserType" class="org.hibernatespatial.GeometryUserType" >
<param name="dialect">org.hibernatespatial.oracle.OracleSpatial10gDialect</param>
</typedef>
</hibernate-mapping>
I wonder if there is a better way to do this, but none that I could find during these days, or that I was answered here. Hope that this helps to somebody.
这篇关于在定义PostGIS连接时未找到Oracle连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
