Hibernate Spatial, Oracle and Wildfly - Problem finding Oracle Connection

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Hibernate Spatial, Oracle and Wildfly - Problem finding Oracle Connection

Jayne Kumar
Hi,

We are just starting to use Hibernate Spatial 4.3 (Hibernate-core 4.3.1) with Oracle 11g and Wildfly 8.0, and 
I have a problem in that I can read a geometry field but not persist it because there is a problem finding the Oracle Connection.

Debugging the DefaultConnectionFinder there are three connections found:- 
org.jboss.jca.adapters.jdbc.jdk7.WrappedConnection
oracle.jdbc.driver.LogicalConnection
oracle.jdbc.driver.T4CConnection

But none of these is an instance of OracleConnectionClass, so null is eventually returned.

Is there something wrong with my set up ?
Note – when I just use persistence.xml it works fine but from within wildfly using the standalone datasource it doesn’t work.

Please help, I’ve been going round in circles, for a while now, with this issue.
Thanks so much,
Jayne

Here is the setup and logs:-

The field is defined as

@Type(type = "org.hibernate.spatial.GeometryType")
private Point geometricValue;

using

@PersistenceContext(unitName="myPersistence", type=PersistenceContextType.TRANSACTION)



Here is what I have the POM
<dependency>
                     <groupId>org.hibernate.javax.persistence</groupId>
                     <artifactId>hibernate-jpa-2.1-api</artifactId>
                     <scope>provided</scope>
                </dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-entitymanager</artifactId>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-spatial</artifactId>
<version>4.3</version>
</dependency>
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.3</version>
</dependency>
In Wildfly the ojdbc6.jar is in modules/system/layers/base/com/oracle

In my persistence.xml I have

<persistence-unit name="myPersistence"

transaction-type="JTA">

<jta-data-source>java:/myPersistence </jta-data-source>

<shared-cache-mode>ENABLE_SELECTIVE</shared-cache-mode>

<properties>

<property name="hibernate.archive.autodetection" value="class, hbm" />

<property name="hibernate.cache.use_second_level_cache" value="true"/>

<property name="hibernate.jdbc.batch_size" value="50" />

<property name="hibernate.show_sql" value="false" />

<property name="hibernate.format_sql" value="false" />

<property name="hibernate.order_inserts" value="true" />

<property name="hibernate.order_updates" value="true" />

<property name="hibernate.dialect" value="org.hibernate.spatial.dialect.oracle.OracleSpatial10gDialect" />

<property name="hibernate.jdbc.batch_versioned_data" value="true" />

</properties>

</persistence-unit>


In the standalone/xml I have an xa-datasource
                <xa-datasource jndi-name="java:/myPersistence" pool-name="myPersistence_pool" enabled="true" use-java-context="true" use-ccm="true">
                    <xa-datasource-property name="URL">
                        jdbc:oracle:thin:@dev-mydevdb.org:1521:D_SID
                    </xa-datasource-property>
                    <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
                    <driver>oracle</driver>
….
</xa-datasource> 

<driver name="oracle" module="com.oracle.ojdbc6”> 
<xa-datasource-class>oracle.jdbc.OracleDriver</xa-datasource-class> 
</driver> 


Here is the log :-
2014-07-29 10:37:07,648 ERROR [io.undertow.request] (default task-3) UT005023: Exception handling request to /myWebApp/types: org.jboss.resteasy.spi.UnhandledException: javax.ejb.EJBTransactionRolledbackException: org.hibernate.HibernateException: Problem finding Oracle Connection
at org.jboss.resteasy.core.ExceptionHandler.handleApplicationException(ExceptionHandler.java:76) [resteasy-jaxrs-3.0.6.Final.jar:]
at org.jboss.resteasy.core.ExceptionHandler.handleException(ExceptionHandler.java:212) [resteasy-jaxrs-3.0.6.Final.jar:]
at org.jboss.resteasy.core.SynchronousDispatcher.writeException(SynchronousDispatcher.java:149) [resteasy-jaxrs-3.0.6.Final.jar:]
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:372) [resteasy-jaxrs-3.0.6.Final.jar:]
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:179) [resteasy-jaxrs-3.0.6.Final.jar:]
at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:220) [resteasy-jaxrs-3.0.6.Final.jar:]
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56) [resteasy-jaxrs-3.0.6.Final.jar:]
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51) [resteasy-jaxrs-3.0.6.Final.jar:]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) [jboss-servlet-api_3.1_spec-1.0.0.Final.jar:1.0.0.Final]
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:61) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:113) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
at io.undertow.security.handlers.AuthenticationCallHandler.handleRequest(AuthenticationCallHandler.java:52) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:45) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:61) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:240) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:227) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:73) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:146) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:168) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:687) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51]
at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]
Caused by: javax.ejb.EJBTransactionRolledbackException: org.hibernate.HibernateException: Problem finding Oracle Connection
at org.jboss.as.ejb3.tx.CMTTxInterceptor.handleInCallerTx(CMTTxInterceptor.java:163) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:253) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:342) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:239) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:95) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:439) [wildfly-security-manager-1.0.0.Final.jar:1.0.0.Final]
at org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)
at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)
at org.neoninc.cds.pdr.data.access.LocationDAO$$$view123.flush(Unknown Source) [classes:]
at org.neoninc.cds.pdr.rest.TypeResource.postType(TypeResource.java:542) [classes:]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_51]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_51]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_51]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:82) [wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93) [wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47) [wildfly-jpa-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:46) [weld-core-impl-2.1.2.Final.jar:2014-01-09 09:23]
at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83) [wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45) [wildfly-ee-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:273) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:340) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:239) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:95) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:448) [wildfly-security-manager-1.0.0.Final.jar:1.0.0.Final]
at org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)
at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)
at org.neoninc.cds.pdr.rest.TypeResource$$$view102.postType(Unknown Source) [classes:]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_51]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_51]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_51]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:137) [resteasy-jaxrs-3.0.6.Final.jar:]
at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:280) [resteasy-jaxrs-3.0.6.Final.jar:]
at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:234) [resteasy-jaxrs-3.0.6.Final.jar:]
at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:221) [resteasy-jaxrs-3.0.6.Final.jar:]
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356) [resteasy-jaxrs-3.0.6.Final.jar:]
... 29 more
Caused by: javax.persistence.PersistenceException: org.hibernate.HibernateException: Problem finding Oracle Connection
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763) [hibernate-entitymanager-4.3.1.Final.jar:4.3.1.Final]
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677) [hibernate-entitymanager-4.3.1.Final.jar:4.3.1.Final]
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1683) [hibernate-entitymanager-4.3.1.Final.jar:4.3.1.Final]
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1338) [hibernate-entitymanager-4.3.1.Final.jar:4.3.1.Final]
at org.jboss.as.jpa.container.AbstractEntityManager.flush(AbstractEntityManager.java:445) [wildfly-jpa-8.0.0.Final.jar:8.0.0.Final]
at org.neoninc.cds.pdr.data.access.GenericHibernateSpatialDAO.flush(GenericHibernateSpatialDAO.java:258) [classes:]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_51]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_51]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_51]
at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:82) [wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93) [wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47) [wildfly-jpa-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:46) [weld-core-impl-2.1.2.Final.jar:2014-01-09 09:23]
at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83) [wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45) [wildfly-ee-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:251) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
... 140 more
Caused by: org.hibernate.HibernateException: Problem finding Oracle Connection
at org.hibernate.spatial.dialect.oracle.OracleJDBCTypeFactory.createStruct(OracleJDBCTypeFactory.java:121) [hibernate-spatial-4.3.jar:4.3.0.Final]
at org.hibernate.spatial.dialect.oracle.SDOGeometryValueBinder.store(SDOGeometryValueBinder.java:76) [hibernate-spatial-4.3.jar:4.3.0.Final]
at org.hibernate.spatial.dialect.oracle.SDOGeometryValueBinder.toNative(SDOGeometryValueBinder.java:83) [hibernate-spatial-4.3.jar:4.3.0.Final]
at org.hibernate.spatial.dialect.oracle.SDOGeometryValueBinder.bind(SDOGeometryValueBinder.java:66) [hibernate-spatial-4.3.jar:4.3.0.Final]
at org.hibernate.spatial.dialect.oracle.SDOGeometryValueBinder.bind(SDOGeometryValueBinder.java:52) [hibernate-spatial-4.3.jar:4.3.0.Final]
at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:282) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:277) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
at org.hibernate.type.AbstractSingleColumnStandardBasicType.nullSafeSet(AbstractSingleColumnStandardBasicType.java:56) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2843) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3121) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3587) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:103) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:453) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:345) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1218) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1335) [hibernate-entitymanager-4.3.1.Final.jar:4.3.1.Final]
... 177 more
Caused by: org.hibernate.spatial.helper.FinderException: Tried retrieving OracleConnection from oracle.jdbc.driver.T4CConnection using method _getPC, but received null.
at org.neoninc.cds.pdr.data.helper.MyNewConnectionFinder.find(MyNewConnectionFinder.java:98) [classes:]
at org.neoninc.cds.pdr.data.helper.MyNewConnectionFinder.find(MyNewConnectionFinder.java:96) [classes:]
at org.neoninc.cds.pdr.data.helper.MyNewConnectionFinder.find(MyNewConnectionFinder.java:96) [classes:]
at org.neoninc.cds.pdr.data.helper.MyNewConnectionFinder.find(MyNewConnectionFinder.java:49) [classes:]
at org.hibernate.spatial.dialect.oracle.OracleJDBCTypeFactory.createStruct(OracleJDBCTypeFactory.java:119) [hibernate-spatial-4.3.jar:4.3.0.Final]
... 194 more
    



_______________________________________________
hibernatespatial-users mailing list
[hidden email]
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users
Reply | Threaded
Open this post in threaded view
|

Re: Hibernate Spatial, Oracle and Wildfly - Problem finding Oracle Connection

Karel Maesen
Administrator
Hi Jayne,

Looks like you found the section “ConnectionFinder Interface” in the HS Oracle documentation. I find a reference in the stacktrace to “org.neoninc.cds.pdr.data.helper.MyNewConnectionFinder”, but don’t see where this is configured, or how it is defined.

Looking through some Oracle documentation it looks like you can cast the T4CConnection to an OracleConnection, but beware that you need then the OracleConnection class loaded by the Wildfire container (so best get rid of the ojdbc6 dep in your application). See for example this thread: https://community.oracle.com/thread/556480


Btw, I don’t use Wildfly but if you get a ConnectionFinder implementation that works in Wildfly, please consider to share it with the community by submitting it for inclusion in the HS source code.

Regards,

Karel

On 29 Jul 2014, at 22:17, Jayne Kumar <[hidden email]> wrote:

> Hi,
>
> We are just starting to use Hibernate Spatial 4.3 (Hibernate-core 4.3.1) with Oracle 11g and Wildfly 8.0, and
> I have a problem in that I can read a geometry field but not persist it because there is a problem finding the Oracle Connection.
>
> Debugging the DefaultConnectionFinder there are three connections found:-
> org.jboss.jca.adapters.jdbc.jdk7.WrappedConnection
> oracle.jdbc.driver.LogicalConnection
> oracle.jdbc.driver.T4CConnection
>
> But none of these is an instance of OracleConnectionClass, so null is eventually returned.
>
> Is there something wrong with my set up ?
> Note – when I just use persistence.xml it works fine but from within wildfly using the standalone datasource it doesn’t work.
>
> Please help, I’ve been going round in circles, for a while now, with this issue.
> Thanks so much,
> Jayne
>
> Here is the setup and logs:-
>
> The field is defined as
>
> @Type(type = "org.hibernate.spatial.GeometryType")
> private Point geometricValue;
>
> using
> @PersistenceContext(unitName="myPersistence", type=PersistenceContextType.TRANSACTION)
>
>
> Here is what I have the POM
> <dependency>
>                      <groupId>org.hibernate.javax.persistence</groupId>
>                      <artifactId>hibernate-jpa-2.1-api</artifactId>
>                      <scope>provided</scope>
>                 </dependency>
> <dependency>
> <groupId>org.hibernate</groupId>
> <artifactId>hibernate-entitymanager</artifactId>
> <scope>provided</scope>
> </dependency>
> <dependency>
> <groupId>org.hibernate</groupId>
> <artifactId>hibernate-spatial</artifactId>
> <version>4.3</version>
> </dependency>
> <dependency>
> <groupId>com.oracle</groupId>
> <artifactId>ojdbc6</artifactId>
> <version>11.2.0.3</version>
> </dependency>
> In Wildfly the ojdbc6.jar is in modules/system/layers/base/com/oracle
>
> In my persistence.xml I have
> <persistence-unit name="myPersistence"
> transaction-type="JTA">
> <jta-data-source>java:/myPersistence </jta-data-source>
> <shared-cache-mode>ENABLE_SELECTIVE</shared-cache-mode>
> <properties>
> <property name="hibernate.archive.autodetection" value="class, hbm" />
> <property name="hibernate.cache.use_second_level_cache" value="true"/>
> <property name="hibernate.jdbc.batch_size" value="50" />
> <property name="hibernate.show_sql" value="false" />
> <property name="hibernate.format_sql" value="false" />
> <property name="hibernate.order_inserts" value="true" />
> <property name="hibernate.order_updates" value="true" />
> <property name="hibernate.dialect" value="org.hibernate.spatial.dialect.oracle.OracleSpatial10gDialect" />
> <property name="hibernate.jdbc.batch_versioned_data" value="true" />
> </properties>
> </persistence-unit>
>
> In the standalone/xml I have an xa-datasource
>                 <xa-datasource jndi-name="java:/myPersistence" pool-name="myPersistence_pool" enabled="true" use-java-context="true" use-ccm="true">
>                     <xa-datasource-property name="URL">
>                         jdbc:oracle:thin:@dev-mydevdb.org:1521:D_SID
>                     </xa-datasource-property>
>                     <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
>                     <driver>oracle</driver>
> ….
> </xa-datasource>
>
> <driver name="oracle" module="com.oracle.ojdbc6”>
> <xa-datasource-class>oracle.jdbc.OracleDriver</xa-datasource-class>
> </driver>
>
>
> Here is the log :-
> 2014-07-29 10:37:07,648 ERROR [io.undertow.request] (default task-3) UT005023: Exception handling request to /myWebApp/types: org.jboss.resteasy.spi.UnhandledException: javax.ejb.EJBTransactionRolledbackException: org.hibernate.HibernateException: Problem finding Oracle Connection
> at org.jboss.resteasy.core.ExceptionHandler.handleApplicationException(ExceptionHandler.java:76) [resteasy-jaxrs-3.0.6.Final.jar:]
> at org.jboss.resteasy.core.ExceptionHandler.handleException(ExceptionHandler.java:212) [resteasy-jaxrs-3.0.6.Final.jar:]
> at org.jboss.resteasy.core.SynchronousDispatcher.writeException(SynchronousDispatcher.java:149) [resteasy-jaxrs-3.0.6.Final.jar:]
> at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:372) [resteasy-jaxrs-3.0.6.Final.jar:]
> at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:179) [resteasy-jaxrs-3.0.6.Final.jar:]
> at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:220) [resteasy-jaxrs-3.0.6.Final.jar:]
> at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56) [resteasy-jaxrs-3.0.6.Final.jar:]
> at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51) [resteasy-jaxrs-3.0.6.Final.jar:]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) [jboss-servlet-api_3.1_spec-1.0.0.Final.jar:1.0.0.Final]
> at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
> at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:61) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
> at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
> at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
> at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
> at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:113) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
> at io.undertow.security.handlers.AuthenticationCallHandler.handleRequest(AuthenticationCallHandler.java:52) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
> at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:45) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
> at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:61) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
> at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
> at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
> at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
> at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
> at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
> at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
> at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:240) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
> at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:227) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
> at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:73) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
> at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:146) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
> at io.undertow.server.Connectors.executeRootHandler(Connectors.java:168) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
> at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:687) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51]
> at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]
> Caused by: javax.ejb.EJBTransactionRolledbackException: org.hibernate.HibernateException: Problem finding Oracle Connection
> at org.jboss.as.ejb3.tx.CMTTxInterceptor.handleInCallerTx(CMTTxInterceptor.java:163) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:253) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:342) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:239) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:95) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:439) [wildfly-security-manager-1.0.0.Final.jar:1.0.0.Final]
> at org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)
> at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)
> at org.neoninc.cds.pdr.data.access.LocationDAO$$$view123.flush(Unknown Source) [classes:]
> at org.neoninc.cds.pdr.rest.TypeResource.postType(TypeResource.java:542) [classes:]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_51]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_51]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_51]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
> at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:82) [wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93) [wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47) [wildfly-jpa-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:46) [weld-core-impl-2.1.2.Final.jar:2014-01-09 09:23]
> at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83) [wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45) [wildfly-ee-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:273) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:340) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:239) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:95) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:448) [wildfly-security-manager-1.0.0.Final.jar:1.0.0.Final]
> at org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)
> at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)
> at org.neoninc.cds.pdr.rest.TypeResource$$$view102.postType(Unknown Source) [classes:]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_51]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_51]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_51]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
> at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:137) [resteasy-jaxrs-3.0.6.Final.jar:]
> at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:280) [resteasy-jaxrs-3.0.6.Final.jar:]
> at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:234) [resteasy-jaxrs-3.0.6.Final.jar:]
> at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:221) [resteasy-jaxrs-3.0.6.Final.jar:]
> at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356) [resteasy-jaxrs-3.0.6.Final.jar:]
> ... 29 more
> Caused by: javax.persistence.PersistenceException: org.hibernate.HibernateException: Problem finding Oracle Connection
> at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763) [hibernate-entitymanager-4.3.1.Final.jar:4.3.1.Final]
> at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677) [hibernate-entitymanager-4.3.1.Final.jar:4.3.1.Final]
> at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1683) [hibernate-entitymanager-4.3.1.Final.jar:4.3.1.Final]
> at org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1338) [hibernate-entitymanager-4.3.1.Final.jar:4.3.1.Final]
> at org.jboss.as.jpa.container.AbstractEntityManager.flush(AbstractEntityManager.java:445) [wildfly-jpa-8.0.0.Final.jar:8.0.0.Final]
> at org.neoninc.cds.pdr.data.access.GenericHibernateSpatialDAO.flush(GenericHibernateSpatialDAO.java:258) [classes:]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_51]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_51]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_51]
> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
> at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:82) [wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93) [wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47) [wildfly-jpa-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:407) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:46) [weld-core-impl-2.1.2.Final.jar:2014-01-09 09:23]
> at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83) [wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45) [wildfly-ee-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
> at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:251) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
> ... 140 more
> Caused by: org.hibernate.HibernateException: Problem finding Oracle Connection
> at org.hibernate.spatial.dialect.oracle.OracleJDBCTypeFactory.createStruct(OracleJDBCTypeFactory.java:121) [hibernate-spatial-4.3.jar:4.3.0.Final]
> at org.hibernate.spatial.dialect.oracle.SDOGeometryValueBinder.store(SDOGeometryValueBinder.java:76) [hibernate-spatial-4.3.jar:4.3.0.Final]
> at org.hibernate.spatial.dialect.oracle.SDOGeometryValueBinder.toNative(SDOGeometryValueBinder.java:83) [hibernate-spatial-4.3.jar:4.3.0.Final]
> at org.hibernate.spatial.dialect.oracle.SDOGeometryValueBinder.bind(SDOGeometryValueBinder.java:66) [hibernate-spatial-4.3.jar:4.3.0.Final]
> at org.hibernate.spatial.dialect.oracle.SDOGeometryValueBinder.bind(SDOGeometryValueBinder.java:52) [hibernate-spatial-4.3.jar:4.3.0.Final]
> at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:282) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
> at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:277) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
> at org.hibernate.type.AbstractSingleColumnStandardBasicType.nullSafeSet(AbstractSingleColumnStandardBasicType.java:56) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
> at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2843) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
> at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3121) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
> at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3587) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
> at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:103) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
> at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:453) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
> at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:345) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
> at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
> at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
> at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1218) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
> at org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1335) [hibernate-entitymanager-4.3.1.Final.jar:4.3.1.Final]
> ... 177 more
> Caused by: org.hibernate.spatial.helper.FinderException: Tried retrieving OracleConnection from oracle.jdbc.driver.T4CConnection using method _getPC, but received null.
> at org.neoninc.cds.pdr.data.helper.MyNewConnectionFinder.find(MyNewConnectionFinder.java:98) [classes:]
> at org.neoninc.cds.pdr.data.helper.MyNewConnectionFinder.find(MyNewConnectionFinder.java:96) [classes:]
> at org.neoninc.cds.pdr.data.helper.MyNewConnectionFinder.find(MyNewConnectionFinder.java:96) [classes:]
> at org.neoninc.cds.pdr.data.helper.MyNewConnectionFinder.find(MyNewConnectionFinder.java:49) [classes:]
> at org.hibernate.spatial.dialect.oracle.OracleJDBCTypeFactory.createStruct(OracleJDBCTypeFactory.java:119) [hibernate-spatial-4.3.jar:4.3.0.Final]
> ... 194 more
>    
>
>
> _______________________________________________
> 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
Reply | Threaded
Open this post in threaded view
|

Re: Hibernate Spatial, Oracle and Wildfly - Problem finding Oracle Connection

Jayne Kumar
Hi Karel,

Yes that MyNewConnectionFinder was just a clone of the
DefaultConnectionFinder I was using to debug :-)
I omitted the property name="hibernate.spatial.connection_finder"
value="org.neoninc.cds.pdr.data.helper.MyNewConnectionFinder² when I
posted.

Thanks so much for the suggestion - I¹ll try removing that ojdbc6
dependency, hopefully that¹s the issue.

If I get something working in Wildfly I¹ll definitely share it.

Thanks again,
Jayne





On 7/30/14, 3:21 AM, "Karel Maesen" <[hidden email]> wrote:

>Hi Jayne,
>
>Looks like you found the section ³ConnectionFinder Interface² in the HS
>Oracle documentation. I find a reference in the stacktrace to
>³org.neoninc.cds.pdr.data.helper.MyNewConnectionFinder², but don¹t see
>where this is configured, or how it is defined.
>
>Looking through some Oracle documentation it looks like you can cast the
>T4CConnection to an OracleConnection, but beware that you need then the
>OracleConnection class loaded by the Wildfire container (so best get rid
>of the ojdbc6 dep in your application). See for example this thread:
>https://community.oracle.com/thread/556480
>
>
>Btw, I don¹t use Wildfly but if you get a ConnectionFinder implementation
>that works in Wildfly, please consider to share it with the community by
>submitting it for inclusion in the HS source code.
>
>Regards,
>
>Karel
>
>On 29 Jul 2014, at 22:17, Jayne Kumar <[hidden email]> wrote:
>
>> Hi,
>>
>> We are just starting to use Hibernate Spatial 4.3 (Hibernate-core
>>4.3.1) with Oracle 11g and Wildfly 8.0, and
>> I have a problem in that I can read a geometry field but not persist it
>>because there is a problem finding the Oracle Connection.
>>
>> Debugging the DefaultConnectionFinder there are three connections
>>found:-
>> org.jboss.jca.adapters.jdbc.jdk7.WrappedConnection
>> oracle.jdbc.driver.LogicalConnection
>> oracle.jdbc.driver.T4CConnection
>>
>> But none of these is an instance of OracleConnectionClass, so null is
>>eventually returned.
>>
>> Is there something wrong with my set up ?
>> Note ­ when I just use persistence.xml it works fine but from within
>>wildfly using the standalone datasource it doesn¹t work.
>>
>> Please help, I¹ve been going round in circles, for a while now, with
>>this issue.
>> Thanks so much,
>> Jayne
>>
>> Here is the setup and logs:-
>>
>> The field is defined as
>>
>> @Type(type = "org.hibernate.spatial.GeometryType")
>> private Point geometricValue;
>>
>> using
>> @PersistenceContext(unitName="myPersistence",
>>type=PersistenceContextType.TRANSACTION)
>>
>>
>> Here is what I have the POM
>> <dependency>
>>                      <groupId>org.hibernate.javax.persistence</groupId>
>>                      <artifactId>hibernate-jpa-2.1-api</artifactId>
>>                      <scope>provided</scope>
>>                 </dependency>
>> <dependency>
>> <groupId>org.hibernate</groupId>
>> <artifactId>hibernate-entitymanager</artifactId>
>> <scope>provided</scope>
>> </dependency>
>> <dependency>
>> <groupId>org.hibernate</groupId>
>> <artifactId>hibernate-spatial</artifactId>
>> <version>4.3</version>
>> </dependency>
>> <dependency>
>> <groupId>com.oracle</groupId>
>> <artifactId>ojdbc6</artifactId>
>> <version>11.2.0.3</version>
>> </dependency>
>> In Wildfly the ojdbc6.jar is in modules/system/layers/base/com/oracle
>>
>> In my persistence.xml I have
>> <persistence-unit name="myPersistence"
>> transaction-type="JTA">
>> <jta-data-source>java:/myPersistence </jta-data-source>
>> <shared-cache-mode>ENABLE_SELECTIVE</shared-cache-mode>
>> <properties>
>> <property name="hibernate.archive.autodetection" value="class, hbm" />
>> <property name="hibernate.cache.use_second_level_cache" value="true"/>
>> <property name="hibernate.jdbc.batch_size" value="50" />
>> <property name="hibernate.show_sql" value="false" />
>> <property name="hibernate.format_sql" value="false" />
>> <property name="hibernate.order_inserts" value="true" />
>> <property name="hibernate.order_updates" value="true" />
>> <property name="hibernate.dialect"
>>value="org.hibernate.spatial.dialect.oracle.OracleSpatial10gDialect" />
>> <property name="hibernate.jdbc.batch_versioned_data" value="true" />
>> </properties>
>> </persistence-unit>
>>
>> In the standalone/xml I have an xa-datasource
>>                 <xa-datasource jndi-name="java:/myPersistence"
>>pool-name="myPersistence_pool" enabled="true" use-java-context="true"
>>use-ccm="true">
>>                     <xa-datasource-property name="URL">
>>                         jdbc:oracle:thin:@dev-mydevdb.org:1521:D_SID
>>                     </xa-datasource-property>
>>                
>><xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasou
>>rce-class>
>>                     <driver>oracle</driver>
>> Š.
>> </xa-datasource>
>>
>> <driver name="oracle" module="com.oracle.ojdbc6²>
>> <xa-datasource-class>oracle.jdbc.OracleDriver</xa-datasource-class>
>> </driver>
>>
>>
>> Here is the log :-
>> 2014-07-29 10:37:07,648 ERROR [io.undertow.request] (default task-3)
>>UT005023: Exception handling request to /myWebApp/types:
>>org.jboss.resteasy.spi.UnhandledException:
>>javax.ejb.EJBTransactionRolledbackException:
>>org.hibernate.HibernateException: Problem finding Oracle Connection
>> at
>>org.jboss.resteasy.core.ExceptionHandler.handleApplicationException(Excep
>>tionHandler.java:76) [resteasy-jaxrs-3.0.6.Final.jar:]
>> at
>>org.jboss.resteasy.core.ExceptionHandler.handleException(ExceptionHandler
>>.java:212) [resteasy-jaxrs-3.0.6.Final.jar:]
>> at
>>org.jboss.resteasy.core.SynchronousDispatcher.writeException(SynchronousD
>>ispatcher.java:149) [resteasy-jaxrs-3.0.6.Final.jar:]
>> at
>>org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatche
>>r.java:372) [resteasy-jaxrs-3.0.6.Final.jar:]
>> at
>>org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatche
>>r.java:179) [resteasy-jaxrs-3.0.6.Final.jar:]
>> at
>>org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.serv
>>ice(ServletContainerDispatcher.java:220)
>>[resteasy-jaxrs-3.0.6.Final.jar:]
>> at
>>org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(H
>>ttpServletDispatcher.java:56) [resteasy-jaxrs-3.0.6.Final.jar:]
>> at
>>org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(H
>>ttpServletDispatcher.java:51) [resteasy-jaxrs-3.0.6.Final.jar:]
>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
>>[jboss-servlet-api_3.1_spec-1.0.0.Final.jar:1.0.0.Final]
>> at
>>io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.
>>java:85) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
>> at
>>io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRe
>>quest(ServletSecurityRoleHandler.java:61)
>>[undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
>> at
>>io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(Serv
>>letDispatchingHandler.java:36)
>>[undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
>> at
>>org.wildfly.extension.undertow.security.SecurityContextAssociationHandler
>>.handleRequest(SecurityContextAssociationHandler.java:78)
>> at
>>io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandl
>>er.java:25) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
>> at
>>io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.ha
>>ndleRequest(SSLInformationAssociationHandler.java:113)
>>[undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
>> at
>>io.undertow.security.handlers.AuthenticationCallHandler.handleRequest(Aut
>>henticationCallHandler.java:52)
>>[undertow-core-1.0.0.Final.jar:1.0.0.Final]
>> at
>>io.undertow.security.handlers.AbstractConfidentialityHandler.handleReques
>>t(AbstractConfidentialityHandler.java:45)
>>[undertow-core-1.0.0.Final.jar:1.0.0.Final]
>> at
>>io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHan
>>dler.handleRequest(ServletConfidentialityConstraintHandler.java:61)
>>[undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
>> at
>>io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.h
>>andleRequest(CachedAuthenticatedSessionHandler.java:70)
>>[undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
>> at
>>io.undertow.security.handlers.SecurityInitialHandler.handleRequest(Securi
>>tyInitialHandler.java:76) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
>> at
>>io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandl
>>er.java:25) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
>> at
>>org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleR
>>equest(JACCContextIdHandler.java:61)
>> at
>>io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandl
>>er.java:25) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
>> at
>>io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandl
>>er.java:25) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
>> at
>>io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(Ser
>>vletInitialHandler.java:240)
>>[undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
>> at
>>io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(Servle
>>tInitialHandler.java:227) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
>> at
>>io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInit
>>ialHandler.java:73) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
>> at
>>io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(Servle
>>tInitialHandler.java:146) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
>> at
>>io.undertow.server.Connectors.executeRootHandler(Connectors.java:168)
>>[undertow-core-1.0.0.Final.jar:1.0.0.Final]
>> at
>>io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:687)
>>[undertow-core-1.0.0.Final.jar:1.0.0.Final]
>> at
>>java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java
>>:1145) [rt.jar:1.7.0_51]
>> at
>>java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.jav
>>a:615) [rt.jar:1.7.0_51]
>> at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]
>> Caused by: javax.ejb.EJBTransactionRolledbackException:
>>org.hibernate.HibernateException: Problem finding Oracle Connection
>> at
>>org.jboss.as.ejb3.tx.CMTTxInterceptor.handleInCallerTx(CMTTxInterceptor.j
>>ava:163) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.j
>>ava:253) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:342)
>> [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.
>>java:239) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextIntercep
>>tor.processInvocation(CurrentInvocationContextInterceptor.java:41)
>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.process
>>Invocation(WaitTimeInterceptor.java:43)
>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(S
>>ecurityContextInterceptor.java:95)
>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.pro
>>cessInvocation(ShutDownInterceptorFactory.java:64)
>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvoca
>>tion(LoggingInterceptor.java:59)
>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(N
>>amespaceContextInterceptor.java:50)
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.proce
>>ssInvocation(AdditionalSetupInterceptor.java:55)
>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(Cont
>>extClassLoaderInterceptor.java:64)
>>[jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
>>[jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecu
>>rityManager.java:439)
>>[wildfly-security-manager-1.0.0.Final.jar:1.0.0.Final]
>> at
>>org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCh
>>eckingInterceptor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
>>[jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(
>>PrivilegedWithCombinerInterceptor.java:80)
>>[jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedIntercep
>>tor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)
>> at
>>org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescrip
>>tion.java:182)
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedIntercep
>>tor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHa
>>ndler.java:73)
>> at org.neoninc.cds.pdr.data.access.LocationDAO$$$view123.flush(Unknown
>>Source) [classes:]
>> at
>>org.neoninc.cds.pdr.rest.TypeResource.postType(TypeResource.java:542)
>>[classes:]
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>[rt.jar:1.7.0_51]
>> at
>>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
>>:57) [rt.jar:1.7.0_51]
>> at
>>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI
>>mpl.java:43) [rt.jar:1.7.0_51]
>> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
>> at
>>org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvoca
>>tion(ManagedReferenceMethodInterceptor.java:52)
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedIntercepto
>>r.java:53) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processIn
>>vocation(UserInterceptorFactory.java:63)
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorCon
>>text.java:407) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr2
>>99BindingsInterceptor.java:82) [wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299B
>>indingsInterceptor.java:93) [wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processIn
>>vocation(UserInterceptorFactory.java:63)
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedIntercepto
>>r.java:53) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processIn
>>vocation(UserInterceptorFactory.java:63)
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.pr
>>ocessInvocation(ExecutionTimeInterceptor.java:43)
>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SB
>>InvocationInterceptor.java:47) [wildfly-jpa-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorCon
>>text.java:407) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInv
>>oke(AbstractEJBRequestScopeActivationInterceptor.java:46)
>>[weld-core-impl-2.1.2.Final.jar:2014-01-09 09:23]
>> at
>>org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocat
>>ion(EjbRequestScopeActivationInterceptor.java:83)
>>[wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation
>>(ConcurrentContextInterceptor.java:45)
>>[wildfly-ee-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.InitialInterceptor.processInvocation(InitialIntercep
>>tor.java:21) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedIntercep
>>tor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.pro
>>cessInvocation(ComponentDispatcherInterceptor.java:53)
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocat
>>ion(PooledInstanceInterceptor.java:51)
>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java
>>:273) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:340)
>> [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.
>>java:239) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextIntercep
>>tor.processInvocation(CurrentInvocationContextInterceptor.java:41)
>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.process
>>Invocation(WaitTimeInterceptor.java:43)
>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(S
>>ecurityContextInterceptor.java:95)
>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.pro
>>cessInvocation(ShutDownInterceptorFactory.java:64)
>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvoca
>>tion(LoggingInterceptor.java:59)
>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(N
>>amespaceContextInterceptor.java:50)
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.proce
>>ssInvocation(AdditionalSetupInterceptor.java:55)
>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(Cont
>>extClassLoaderInterceptor.java:64)
>>[jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
>>[jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecu
>>rityManager.java:448)
>>[wildfly-security-manager-1.0.0.Final.jar:1.0.0.Final]
>> at
>>org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCh
>>eckingInterceptor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
>>[jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(
>>PrivilegedWithCombinerInterceptor.java:80)
>>[jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedIntercep
>>tor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)
>> at
>>org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescrip
>>tion.java:182)
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedIntercep
>>tor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHa
>>ndler.java:73)
>> at org.neoninc.cds.pdr.rest.TypeResource$$$view102.postType(Unknown
>>Source) [classes:]
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>[rt.jar:1.7.0_51]
>> at
>>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
>>:57) [rt.jar:1.7.0_51]
>> at
>>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI
>>mpl.java:43) [rt.jar:1.7.0_51]
>> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
>> at
>>org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java
>>:137) [resteasy-jaxrs-3.0.6.Final.jar:]
>> at
>>org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMeth
>>odInvoker.java:280) [resteasy-jaxrs-3.0.6.Final.jar:]
>> at
>>org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoke
>>r.java:234) [resteasy-jaxrs-3.0.6.Final.jar:]
>> at
>>org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoke
>>r.java:221) [resteasy-jaxrs-3.0.6.Final.jar:]
>> at
>>org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatche
>>r.java:356) [resteasy-jaxrs-3.0.6.Final.jar:]
>> ... 29 more
>> Caused by: javax.persistence.PersistenceException:
>>org.hibernate.HibernateException: Problem finding Oracle Connection
>> at
>>org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityMan
>>agerImpl.java:1763) [hibernate-entitymanager-4.3.1.Final.jar:4.3.1.Final]
>> at
>>org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityMan
>>agerImpl.java:1677) [hibernate-entitymanager-4.3.1.Final.jar:4.3.1.Final]
>> at
>>org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityMan
>>agerImpl.java:1683) [hibernate-entitymanager-4.3.1.Final.jar:4.3.1.Final]
>> at
>>org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManag
>>erImpl.java:1338) [hibernate-entitymanager-4.3.1.Final.jar:4.3.1.Final]
>> at
>>org.jboss.as.jpa.container.AbstractEntityManager.flush(AbstractEntityMana
>>ger.java:445) [wildfly-jpa-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.neoninc.cds.pdr.data.access.GenericHibernateSpatialDAO.flush(GenericH
>>ibernateSpatialDAO.java:258) [classes:]
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>[rt.jar:1.7.0_51]
>> at
>>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
>>:57) [rt.jar:1.7.0_51]
>> at
>>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI
>>mpl.java:43) [rt.jar:1.7.0_51]
>> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
>> at
>>org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvoca
>>tion(ManagedReferenceMethodInterceptor.java:52)
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedIntercepto
>>r.java:53) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processIn
>>vocation(UserInterceptorFactory.java:63)
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorCon
>>text.java:407) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr2
>>99BindingsInterceptor.java:82) [wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299B
>>indingsInterceptor.java:93) [wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processIn
>>vocation(UserInterceptorFactory.java:63)
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedIntercepto
>>r.java:53) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processIn
>>vocation(UserInterceptorFactory.java:63)
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.pr
>>ocessInvocation(ExecutionTimeInterceptor.java:43)
>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SB
>>InvocationInterceptor.java:47) [wildfly-jpa-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorCon
>>text.java:407) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInv
>>oke(AbstractEJBRequestScopeActivationInterceptor.java:46)
>>[weld-core-impl-2.1.2.Final.jar:2014-01-09 09:23]
>> at
>>org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocat
>>ion(EjbRequestScopeActivationInterceptor.java:83)
>>[wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation
>>(ConcurrentContextInterceptor.java:45)
>>[wildfly-ee-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.InitialInterceptor.processInvocation(InitialIntercep
>>tor.java:21) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedIntercep
>>tor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.pro
>>cessInvocation(ComponentDispatcherInterceptor.java:53)
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocat
>>ion(PooledInstanceInterceptor.java:51)
>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> at
>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:3
>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>> at
>>org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.j
>>ava:251) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>> ... 140 more
>> Caused by: org.hibernate.HibernateException: Problem finding Oracle
>>Connection
>> at
>>org.hibernate.spatial.dialect.oracle.OracleJDBCTypeFactory.createStruct(O
>>racleJDBCTypeFactory.java:121) [hibernate-spatial-4.3.jar:4.3.0.Final]
>> at
>>org.hibernate.spatial.dialect.oracle.SDOGeometryValueBinder.store(SDOGeom
>>etryValueBinder.java:76) [hibernate-spatial-4.3.jar:4.3.0.Final]
>> at
>>org.hibernate.spatial.dialect.oracle.SDOGeometryValueBinder.toNative(SDOG
>>eometryValueBinder.java:83) [hibernate-spatial-4.3.jar:4.3.0.Final]
>> at
>>org.hibernate.spatial.dialect.oracle.SDOGeometryValueBinder.bind(SDOGeome
>>tryValueBinder.java:66) [hibernate-spatial-4.3.jar:4.3.0.Final]
>> at
>>org.hibernate.spatial.dialect.oracle.SDOGeometryValueBinder.bind(SDOGeome
>>tryValueBinder.java:52) [hibernate-spatial-4.3.jar:4.3.0.Final]
>> at
>>org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandard
>>BasicType.java:282) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>> at
>>org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandard
>>BasicType.java:277) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>> at
>>org.hibernate.type.AbstractSingleColumnStandardBasicType.nullSafeSet(Abst
>>ractSingleColumnStandardBasicType.java:56)
>>[hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>> at
>>org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(Abstract
>>EntityPersister.java:2843) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>> at
>>org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEnt
>>ityPersister.java:3121) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>> at
>>org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEnt
>>ityPersister.java:3587) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>> at
>>org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertActi
>>on.java:103) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>> at
>>org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:453)
>> [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>> at
>>org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:345)
>> [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>> at
>>org.hibernate.event.internal.AbstractFlushingEventListener.performExecuti
>>ons(AbstractFlushingEventListener.java:350)
>>[hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>> at
>>org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlu
>>shEventListener.java:56) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>> at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1218)
>>[hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>> at
>>org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManag
>>erImpl.java:1335) [hibernate-entitymanager-4.3.1.Final.jar:4.3.1.Final]
>> ... 177 more
>> Caused by: org.hibernate.spatial.helper.FinderException: Tried
>>retrieving OracleConnection from oracle.jdbc.driver.T4CConnection using
>>method _getPC, but received null.
>> at
>>org.neoninc.cds.pdr.data.helper.MyNewConnectionFinder.find(MyNewConnectio
>>nFinder.java:98) [classes:]
>> at
>>org.neoninc.cds.pdr.data.helper.MyNewConnectionFinder.find(MyNewConnectio
>>nFinder.java:96) [classes:]
>> at
>>org.neoninc.cds.pdr.data.helper.MyNewConnectionFinder.find(MyNewConnectio
>>nFinder.java:96) [classes:]
>> at
>>org.neoninc.cds.pdr.data.helper.MyNewConnectionFinder.find(MyNewConnectio
>>nFinder.java:49) [classes:]
>> at
>>org.hibernate.spatial.dialect.oracle.OracleJDBCTypeFactory.createStruct(O
>>racleJDBCTypeFactory.java:119) [hibernate-spatial-4.3.jar:4.3.0.Final]
>> ... 194 more
>>    
>>
>>
>> _______________________________________________
>> 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
Reply | Threaded
Open this post in threaded view
|

Re: Hibernate Spatial, Oracle and Wildfly - Problem finding Oracle Connection

Jayne Kumar
Hello,

Thanks Karel for your help, as you said, it was a case of making sure
Wildfly loaded the OracleConnection class.

We got it working by removing the dependency on the ojdbc6 jar and making
sure the Wildfly loaded the ojdbc6 jar from the modules directory.
We accomplished this by creating our own manifest.mf file with the
following lines (See this post
http://hibernate-spatial.1140993.n2.nabble.com/Hibernate-Spatial-on-JBoss-A
S7-td6785354.html)
        Name: hibernate/spatial/oracle
        Dependencies: com.oracle.ojdbc6

and then excluding the ojdbc6.jar from the war file.
   <plugin>

        <artifactId>maven-war-plugin</artifactId>
        <version>${version.war.plugin}</version>
                <configuration>
                        <archive>
                                <manifestFile>src/main/resources/META-INF/MANIFEST.MF</manifestFile>
                        </archive>
                        <packagingExcludes>WEB-INF/classes/META-INF/MANIFEST.MF,WEB-INF/lib/ojdb
c6*.jar</packagingExcludes>
                </configuration>
   </plugin>


I stepped through the DefaultConnectionFinder code and interestingly
enough the oracle.jdbc.driver.LogicalConnection is an instance of
OracleConnection and everything works fine!
So there was no need to write a special connection finder for Wildfly.

Thanks so much for your help.
Jayne



On 7/30/14, 10:52 AM, "Jayne Kumar" <[hidden email]> wrote:

>Hi Karel,
>
>Yes that MyNewConnectionFinder was just a clone of the
>DefaultConnectionFinder I was using to debug :-)
>I omitted the property name="hibernate.spatial.connection_finder"
>value="org.neoninc.cds.pdr.data.helper.MyNewConnectionFinder² when I
>posted.
>
>Thanks so much for the suggestion - I¹ll try removing that ojdbc6
>dependency, hopefully that¹s the issue.
>
>If I get something working in Wildfly I¹ll definitely share it.
>
>Thanks again,
>Jayne
>
>
>
>
>
>On 7/30/14, 3:21 AM, "Karel Maesen" <[hidden email]> wrote:
>
>>Hi Jayne,
>>
>>Looks like you found the section ³ConnectionFinder Interface² in the HS
>>Oracle documentation. I find a reference in the stacktrace to
>>³org.neoninc.cds.pdr.data.helper.MyNewConnectionFinder², but don¹t see
>>where this is configured, or how it is defined.
>>
>>Looking through some Oracle documentation it looks like you can cast the
>>T4CConnection to an OracleConnection, but beware that you need then the
>>OracleConnection class loaded by the Wildfire container (so best get rid
>>of the ojdbc6 dep in your application). See for example this thread:
>>https://community.oracle.com/thread/556480
>>
>>
>>Btw, I don¹t use Wildfly but if you get a ConnectionFinder implementation
>>that works in Wildfly, please consider to share it with the community by
>>submitting it for inclusion in the HS source code.
>>
>>Regards,
>>
>>Karel
>>
>>On 29 Jul 2014, at 22:17, Jayne Kumar <[hidden email]> wrote:
>>
>>> Hi,
>>>
>>> We are just starting to use Hibernate Spatial 4.3 (Hibernate-core
>>>4.3.1) with Oracle 11g and Wildfly 8.0, and
>>> I have a problem in that I can read a geometry field but not persist it
>>>because there is a problem finding the Oracle Connection.
>>>
>>> Debugging the DefaultConnectionFinder there are three connections
>>>found:-
>>> org.jboss.jca.adapters.jdbc.jdk7.WrappedConnection
>>> oracle.jdbc.driver.LogicalConnection
>>> oracle.jdbc.driver.T4CConnection
>>>
>>> But none of these is an instance of OracleConnectionClass, so null is
>>>eventually returned.
>>>
>>> Is there something wrong with my set up ?
>>> Note ­ when I just use persistence.xml it works fine but from within
>>>wildfly using the standalone datasource it doesn¹t work.
>>>
>>> Please help, I¹ve been going round in circles, for a while now, with
>>>this issue.
>>> Thanks so much,
>>> Jayne
>>>
>>> Here is the setup and logs:-
>>>
>>> The field is defined as
>>>
>>> @Type(type = "org.hibernate.spatial.GeometryType")
>>> private Point geometricValue;
>>>
>>> using
>>> @PersistenceContext(unitName="myPersistence",
>>>type=PersistenceContextType.TRANSACTION)
>>>
>>>
>>> Here is what I have the POM
>>> <dependency>
>>>                      <groupId>org.hibernate.javax.persistence</groupId>
>>>                      <artifactId>hibernate-jpa-2.1-api</artifactId>
>>>                      <scope>provided</scope>
>>>                 </dependency>
>>> <dependency>
>>> <groupId>org.hibernate</groupId>
>>> <artifactId>hibernate-entitymanager</artifactId>
>>> <scope>provided</scope>
>>> </dependency>
>>> <dependency>
>>> <groupId>org.hibernate</groupId>
>>> <artifactId>hibernate-spatial</artifactId>
>>> <version>4.3</version>
>>> </dependency>
>>> <dependency>
>>> <groupId>com.oracle</groupId>
>>> <artifactId>ojdbc6</artifactId>
>>> <version>11.2.0.3</version>
>>> </dependency>
>>> In Wildfly the ojdbc6.jar is in modules/system/layers/base/com/oracle
>>>
>>> In my persistence.xml I have
>>> <persistence-unit name="myPersistence"
>>> transaction-type="JTA">
>>> <jta-data-source>java:/myPersistence </jta-data-source>
>>> <shared-cache-mode>ENABLE_SELECTIVE</shared-cache-mode>
>>> <properties>
>>> <property name="hibernate.archive.autodetection" value="class, hbm" />
>>> <property name="hibernate.cache.use_second_level_cache" value="true"/>
>>> <property name="hibernate.jdbc.batch_size" value="50" />
>>> <property name="hibernate.show_sql" value="false" />
>>> <property name="hibernate.format_sql" value="false" />
>>> <property name="hibernate.order_inserts" value="true" />
>>> <property name="hibernate.order_updates" value="true" />
>>> <property name="hibernate.dialect"
>>>value="org.hibernate.spatial.dialect.oracle.OracleSpatial10gDialect" />
>>> <property name="hibernate.jdbc.batch_versioned_data" value="true" />
>>> </properties>
>>> </persistence-unit>
>>>
>>> In the standalone/xml I have an xa-datasource
>>>                 <xa-datasource jndi-name="java:/myPersistence"
>>>pool-name="myPersistence_pool" enabled="true" use-java-context="true"
>>>use-ccm="true">
>>>                     <xa-datasource-property name="URL">
>>>                         jdbc:oracle:thin:@dev-mydevdb.org:1521:D_SID
>>>                     </xa-datasource-property>
>>>                
>>><xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-dataso
>>>u
>>>rce-class>
>>>                     <driver>oracle</driver>
>>> Š.
>>> </xa-datasource>
>>>
>>> <driver name="oracle" module="com.oracle.ojdbc6²>
>>> <xa-datasource-class>oracle.jdbc.OracleDriver</xa-datasource-class>
>>> </driver>
>>>
>>>
>>> Here is the log :-
>>> 2014-07-29 10:37:07,648 ERROR [io.undertow.request] (default task-3)
>>>UT005023: Exception handling request to /myWebApp/types:
>>>org.jboss.resteasy.spi.UnhandledException:
>>>javax.ejb.EJBTransactionRolledbackException:
>>>org.hibernate.HibernateException: Problem finding Oracle Connection
>>> at
>>>org.jboss.resteasy.core.ExceptionHandler.handleApplicationException(Exce
>>>p
>>>tionHandler.java:76) [resteasy-jaxrs-3.0.6.Final.jar:]
>>> at
>>>org.jboss.resteasy.core.ExceptionHandler.handleException(ExceptionHandle
>>>r
>>>.java:212) [resteasy-jaxrs-3.0.6.Final.jar:]
>>> at
>>>org.jboss.resteasy.core.SynchronousDispatcher.writeException(Synchronous
>>>D
>>>ispatcher.java:149) [resteasy-jaxrs-3.0.6.Final.jar:]
>>> at
>>>org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatch
>>>e
>>>r.java:372) [resteasy-jaxrs-3.0.6.Final.jar:]
>>> at
>>>org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatch
>>>e
>>>r.java:179) [resteasy-jaxrs-3.0.6.Final.jar:]
>>> at
>>>org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.ser
>>>v
>>>ice(ServletContainerDispatcher.java:220)
>>>[resteasy-jaxrs-3.0.6.Final.jar:]
>>> at
>>>org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(
>>>H
>>>ttpServletDispatcher.java:56) [resteasy-jaxrs-3.0.6.Final.jar:]
>>> at
>>>org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(
>>>H
>>>ttpServletDispatcher.java:51) [resteasy-jaxrs-3.0.6.Final.jar:]
>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
>>>[jboss-servlet-api_3.1_spec-1.0.0.Final.jar:1.0.0.Final]
>>> at
>>>io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler
>>>.
>>>java:85) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
>>> at
>>>io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleR
>>>e
>>>quest(ServletSecurityRoleHandler.java:61)
>>>[undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
>>> at
>>>io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(Ser
>>>v
>>>letDispatchingHandler.java:36)
>>>[undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
>>> at
>>>org.wildfly.extension.undertow.security.SecurityContextAssociationHandle
>>>r
>>>.handleRequest(SecurityContextAssociationHandler.java:78)
>>> at
>>>io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHand
>>>l
>>>er.java:25) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
>>> at
>>>io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.h
>>>a
>>>ndleRequest(SSLInformationAssociationHandler.java:113)
>>>[undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
>>> at
>>>io.undertow.security.handlers.AuthenticationCallHandler.handleRequest(Au
>>>t
>>>henticationCallHandler.java:52)
>>>[undertow-core-1.0.0.Final.jar:1.0.0.Final]
>>> at
>>>io.undertow.security.handlers.AbstractConfidentialityHandler.handleReque
>>>s
>>>t(AbstractConfidentialityHandler.java:45)
>>>[undertow-core-1.0.0.Final.jar:1.0.0.Final]
>>> at
>>>io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHa
>>>n
>>>dler.handleRequest(ServletConfidentialityConstraintHandler.java:61)
>>>[undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
>>> at
>>>io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.
>>>h
>>>andleRequest(CachedAuthenticatedSessionHandler.java:70)
>>>[undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
>>> at
>>>io.undertow.security.handlers.SecurityInitialHandler.handleRequest(Secur
>>>i
>>>tyInitialHandler.java:76) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
>>> at
>>>io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHand
>>>l
>>>er.java:25) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
>>> at
>>>org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handle
>>>R
>>>equest(JACCContextIdHandler.java:61)
>>> at
>>>io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHand
>>>l
>>>er.java:25) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
>>> at
>>>io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHand
>>>l
>>>er.java:25) [undertow-core-1.0.0.Final.jar:1.0.0.Final]
>>> at
>>>io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(Se
>>>r
>>>vletInitialHandler.java:240)
>>>[undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
>>> at
>>>io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(Servl
>>>e
>>>tInitialHandler.java:227) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
>>> at
>>>io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletIni
>>>t
>>>ialHandler.java:73) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
>>> at
>>>io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(Servl
>>>e
>>>tInitialHandler.java:146) [undertow-servlet-1.0.0.Final.jar:1.0.0.Final]
>>> at
>>>io.undertow.server.Connectors.executeRootHandler(Connectors.java:168)
>>>[undertow-core-1.0.0.Final.jar:1.0.0.Final]
>>> at
>>>io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:687)
>>>[undertow-core-1.0.0.Final.jar:1.0.0.Final]
>>> at
>>>java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.jav
>>>a
>>>:1145) [rt.jar:1.7.0_51]
>>> at
>>>java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.ja
>>>v
>>>a:615) [rt.jar:1.7.0_51]
>>> at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]
>>> Caused by: javax.ejb.EJBTransactionRolledbackException:
>>>org.hibernate.HibernateException: Problem finding Oracle Connection
>>> at
>>>org.jboss.as.ejb3.tx.CMTTxInterceptor.handleInCallerTx(CMTTxInterceptor.
>>>j
>>>ava:163) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.
>>>j
>>>ava:253) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:342
>>>)
>>> [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor
>>>.
>>>java:239) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterce
>>>p
>>>tor.processInvocation(CurrentInvocationContextInterceptor.java:41)
>>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.proces
>>>s
>>>Invocation(WaitTimeInterceptor.java:43)
>>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(
>>>S
>>>ecurityContextInterceptor.java:95)
>>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.pr
>>>o
>>>cessInvocation(ShutDownInterceptorFactory.java:64)
>>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvoc
>>>a
>>>tion(LoggingInterceptor.java:59)
>>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(
>>>N
>>>amespaceContextInterceptor.java:50)
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.proc
>>>e
>>>ssInvocation(AdditionalSetupInterceptor.java:55)
>>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(Con
>>>t
>>>extClassLoaderInterceptor.java:64)
>>>[jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
>>>[jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySec
>>>u
>>>rityManager.java:439)
>>>[wildfly-security-manager-1.0.0.Final.jar:1.0.0.Final]
>>> at
>>>org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessC
>>>h
>>>eckingInterceptor.java:61)
>>>[jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
>>>[jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation
>>>(
>>>PrivilegedWithCombinerInterceptor.java:80)
>>>[jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterce
>>>p
>>>tor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)
>>> at
>>>org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescri
>>>p
>>>tion.java:182)
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterce
>>>p
>>>tor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationH
>>>a
>>>ndler.java:73)
>>> at org.neoninc.cds.pdr.data.access.LocationDAO$$$view123.flush(Unknown
>>>Source) [classes:]
>>> at
>>>org.neoninc.cds.pdr.rest.TypeResource.postType(TypeResource.java:542)
>>>[classes:]
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>[rt.jar:1.7.0_51]
>>> at
>>>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
>>>a
>>>:57) [rt.jar:1.7.0_51]
>>> at
>>>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
>>>I
>>>mpl.java:43) [rt.jar:1.7.0_51]
>>> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
>>> at
>>>org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvoc
>>>a
>>>tion(ManagedReferenceMethodInterceptor.java:52)
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedIntercept
>>>o
>>>r.java:53) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processI
>>>n
>>>vocation(UserInterceptorFactory.java:63)
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorCo
>>>n
>>>text.java:407) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr
>>>2
>>>99BindingsInterceptor.java:82)
>>>[wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299
>>>B
>>>indingsInterceptor.java:93) [wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processI
>>>n
>>>vocation(UserInterceptorFactory.java:63)
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedIntercept
>>>o
>>>r.java:53) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processI
>>>n
>>>vocation(UserInterceptorFactory.java:63)
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.p
>>>r
>>>ocessInvocation(ExecutionTimeInterceptor.java:43)
>>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(S
>>>B
>>>InvocationInterceptor.java:47) [wildfly-jpa-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorCo
>>>n
>>>text.java:407) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundIn
>>>v
>>>oke(AbstractEJBRequestScopeActivationInterceptor.java:46)
>>>[weld-core-impl-2.1.2.Final.jar:2014-01-09 09:23]
>>> at
>>>org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvoca
>>>t
>>>ion(EjbRequestScopeActivationInterceptor.java:83)
>>>[wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocatio
>>>n
>>>(ConcurrentContextInterceptor.java:45)
>>>[wildfly-ee-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterce
>>>p
>>>tor.java:21) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterce
>>>p
>>>tor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.pr
>>>o
>>>cessInvocation(ComponentDispatcherInterceptor.java:53)
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvoca
>>>t
>>>ion(PooledInstanceInterceptor.java:51)
>>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.jav
>>>a
>>>:273) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:340
>>>)
>>> [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor
>>>.
>>>java:239) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterce
>>>p
>>>tor.processInvocation(CurrentInvocationContextInterceptor.java:41)
>>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.proces
>>>s
>>>Invocation(WaitTimeInterceptor.java:43)
>>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(
>>>S
>>>ecurityContextInterceptor.java:95)
>>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.pr
>>>o
>>>cessInvocation(ShutDownInterceptorFactory.java:64)
>>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvoc
>>>a
>>>tion(LoggingInterceptor.java:59)
>>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(
>>>N
>>>amespaceContextInterceptor.java:50)
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.proc
>>>e
>>>ssInvocation(AdditionalSetupInterceptor.java:55)
>>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(Con
>>>t
>>>extClassLoaderInterceptor.java:64)
>>>[jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
>>>[jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySec
>>>u
>>>rityManager.java:448)
>>>[wildfly-security-manager-1.0.0.Final.jar:1.0.0.Final]
>>> at
>>>org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessC
>>>h
>>>eckingInterceptor.java:61)
>>>[jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:326)
>>>[jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation
>>>(
>>>PrivilegedWithCombinerInterceptor.java:80)
>>>[jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterce
>>>p
>>>tor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)
>>> at
>>>org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescri
>>>p
>>>tion.java:182)
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterce
>>>p
>>>tor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationH
>>>a
>>>ndler.java:73)
>>> at org.neoninc.cds.pdr.rest.TypeResource$$$view102.postType(Unknown
>>>Source) [classes:]
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>[rt.jar:1.7.0_51]
>>> at
>>>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
>>>a
>>>:57) [rt.jar:1.7.0_51]
>>> at
>>>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
>>>I
>>>mpl.java:43) [rt.jar:1.7.0_51]
>>> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
>>> at
>>>org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.jav
>>>a
>>>:137) [resteasy-jaxrs-3.0.6.Final.jar:]
>>> at
>>>org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMet
>>>h
>>>odInvoker.java:280) [resteasy-jaxrs-3.0.6.Final.jar:]
>>> at
>>>org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvok
>>>e
>>>r.java:234) [resteasy-jaxrs-3.0.6.Final.jar:]
>>> at
>>>org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvok
>>>e
>>>r.java:221) [resteasy-jaxrs-3.0.6.Final.jar:]
>>> at
>>>org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatch
>>>e
>>>r.java:356) [resteasy-jaxrs-3.0.6.Final.jar:]
>>> ... 29 more
>>> Caused by: javax.persistence.PersistenceException:
>>>org.hibernate.HibernateException: Problem finding Oracle Connection
>>> at
>>>org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityMa
>>>n
>>>agerImpl.java:1763)
>>>[hibernate-entitymanager-4.3.1.Final.jar:4.3.1.Final]
>>> at
>>>org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityMa
>>>n
>>>agerImpl.java:1677)
>>>[hibernate-entitymanager-4.3.1.Final.jar:4.3.1.Final]
>>> at
>>>org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityMa
>>>n
>>>agerImpl.java:1683)
>>>[hibernate-entitymanager-4.3.1.Final.jar:4.3.1.Final]
>>> at
>>>org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityMana
>>>g
>>>erImpl.java:1338) [hibernate-entitymanager-4.3.1.Final.jar:4.3.1.Final]
>>> at
>>>org.jboss.as.jpa.container.AbstractEntityManager.flush(AbstractEntityMan
>>>a
>>>ger.java:445) [wildfly-jpa-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.neoninc.cds.pdr.data.access.GenericHibernateSpatialDAO.flush(Generic
>>>H
>>>ibernateSpatialDAO.java:258) [classes:]
>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>[rt.jar:1.7.0_51]
>>> at
>>>sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
>>>a
>>>:57) [rt.jar:1.7.0_51]
>>> at
>>>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
>>>I
>>>mpl.java:43) [rt.jar:1.7.0_51]
>>> at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
>>> at
>>>org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvoc
>>>a
>>>tion(ManagedReferenceMethodInterceptor.java:52)
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedIntercept
>>>o
>>>r.java:53) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processI
>>>n
>>>vocation(UserInterceptorFactory.java:63)
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorCo
>>>n
>>>text.java:407) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr
>>>2
>>>99BindingsInterceptor.java:82)
>>>[wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299
>>>B
>>>indingsInterceptor.java:93) [wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processI
>>>n
>>>vocation(UserInterceptorFactory.java:63)
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedIntercept
>>>o
>>>r.java:53) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processI
>>>n
>>>vocation(UserInterceptorFactory.java:63)
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.p
>>>r
>>>ocessInvocation(ExecutionTimeInterceptor.java:43)
>>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(S
>>>B
>>>InvocationInterceptor.java:47) [wildfly-jpa-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorCo
>>>n
>>>text.java:407) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundIn
>>>v
>>>oke(AbstractEJBRequestScopeActivationInterceptor.java:46)
>>>[weld-core-impl-2.1.2.Final.jar:2014-01-09 09:23]
>>> at
>>>org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvoca
>>>t
>>>ion(EjbRequestScopeActivationInterceptor.java:83)
>>>[wildfly-weld-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocatio
>>>n
>>>(ConcurrentContextInterceptor.java:45)
>>>[wildfly-ee-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterce
>>>p
>>>tor.java:21) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterce
>>>p
>>>tor.java:61) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.pr
>>>o
>>>cessInvocation(ComponentDispatcherInterceptor.java:53)
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvoca
>>>t
>>>ion(PooledInstanceInterceptor.java:51)
>>>[wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> at
>>>org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:
>>>3
>>>09) [jboss-invocation-1.2.1.Final.jar:1.2.1.Final]
>>> at
>>>org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.
>>>j
>>>ava:251) [wildfly-ejb3-8.0.0.Final.jar:8.0.0.Final]
>>> ... 140 more
>>> Caused by: org.hibernate.HibernateException: Problem finding Oracle
>>>Connection
>>> at
>>>org.hibernate.spatial.dialect.oracle.OracleJDBCTypeFactory.createStruct(
>>>O
>>>racleJDBCTypeFactory.java:121) [hibernate-spatial-4.3.jar:4.3.0.Final]
>>> at
>>>org.hibernate.spatial.dialect.oracle.SDOGeometryValueBinder.store(SDOGeo
>>>m
>>>etryValueBinder.java:76) [hibernate-spatial-4.3.jar:4.3.0.Final]
>>> at
>>>org.hibernate.spatial.dialect.oracle.SDOGeometryValueBinder.toNative(SDO
>>>G
>>>eometryValueBinder.java:83) [hibernate-spatial-4.3.jar:4.3.0.Final]
>>> at
>>>org.hibernate.spatial.dialect.oracle.SDOGeometryValueBinder.bind(SDOGeom
>>>e
>>>tryValueBinder.java:66) [hibernate-spatial-4.3.jar:4.3.0.Final]
>>> at
>>>org.hibernate.spatial.dialect.oracle.SDOGeometryValueBinder.bind(SDOGeom
>>>e
>>>tryValueBinder.java:52) [hibernate-spatial-4.3.jar:4.3.0.Final]
>>> at
>>>org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandar
>>>d
>>>BasicType.java:282) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>>> at
>>>org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandar
>>>d
>>>BasicType.java:277) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>>> at
>>>org.hibernate.type.AbstractSingleColumnStandardBasicType.nullSafeSet(Abs
>>>t
>>>ractSingleColumnStandardBasicType.java:56)
>>>[hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>>> at
>>>org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(Abstrac
>>>t
>>>EntityPersister.java:2843) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>>> at
>>>org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn
>>>t
>>>ityPersister.java:3121) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>>> at
>>>org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEn
>>>t
>>>ityPersister.java:3587) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>>> at
>>>org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAct
>>>i
>>>on.java:103) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>>> at
>>>org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:453
>>>)
>>> [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>>> at
>>>org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:345
>>>)
>>> [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>>> at
>>>org.hibernate.event.internal.AbstractFlushingEventListener.performExecut
>>>i
>>>ons(AbstractFlushingEventListener.java:350)
>>>[hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>>> at
>>>org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFl
>>>u
>>>shEventListener.java:56) [hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>>> at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1218)
>>>[hibernate-core-4.3.1.Final.jar:4.3.1.Final]
>>> at
>>>org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityMana
>>>g
>>>erImpl.java:1335) [hibernate-entitymanager-4.3.1.Final.jar:4.3.1.Final]
>>> ... 177 more
>>> Caused by: org.hibernate.spatial.helper.FinderException: Tried
>>>retrieving OracleConnection from oracle.jdbc.driver.T4CConnection using
>>>method _getPC, but received null.
>>> at
>>>org.neoninc.cds.pdr.data.helper.MyNewConnectionFinder.find(MyNewConnecti
>>>o
>>>nFinder.java:98) [classes:]
>>> at
>>>org.neoninc.cds.pdr.data.helper.MyNewConnectionFinder.find(MyNewConnecti
>>>o
>>>nFinder.java:96) [classes:]
>>> at
>>>org.neoninc.cds.pdr.data.helper.MyNewConnectionFinder.find(MyNewConnecti
>>>o
>>>nFinder.java:96) [classes:]
>>> at
>>>org.neoninc.cds.pdr.data.helper.MyNewConnectionFinder.find(MyNewConnecti
>>>o
>>>nFinder.java:49) [classes:]
>>> at
>>>org.hibernate.spatial.dialect.oracle.OracleJDBCTypeFactory.createStruct(
>>>O
>>>racleJDBCTypeFactory.java:119) [hibernate-spatial-4.3.jar:4.3.0.Final]
>>> ... 194 more
>>>    
>>>
>>>
>>> _______________________________________________
>>> hibernatespatial-users mailing list
>>> [hidden email]
>>>
>>>http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatia
>>>l
>>>-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