<div dir="ltr"><div>Hi,</div><div>I tried to use aerogear with oracle database. When I used wildfly it was good.</div><div><br></div><div>I create module.xml for "ojdbc6-12.1.0.1.jar":</div><div><br></div><div><div><i><font color="#0000ff"><?xml version="1.0" encoding="UTF-8"?></font></i></div><div><i><font color="#0000ff"><module xmlns="urn:jboss:module:1.0" name="com.oracle"><br></font></i></div><div><i><font color="#0000ff"> <resources></font></i></div><div><i><font color="#0000ff"> <resource-root path="ojdbc6-12.1.0.1.jar"/></font></i></div><div><i><font color="#0000ff"> <!-- Insert resources here --></font></i></div><div><i><font color="#0000ff"> </resources></font></i></div><div><i><font color="#0000ff"> <dependencies></font></i></div><div><i><font color="#0000ff"> <module name="javax.api"/></font></i></div><div><i><font color="#0000ff"> <module name="javax.transaction.api"/></font></i></div><div><i><font color="#0000ff"> </dependencies></font></i></div><div><i><font color="#0000ff"></module></font></i></div></div><div><br></div><div>next I create oracle-database-config-wildfly.cli</div><div><br></div><div><div><i style="background-color:rgb(255,255,255)"><font color="#0000ff"># $WILDFLY_HOME/bin/jboss-cli.sh --file=/path/to/this/file.</font></i></div><div><i style="background-color:rgb(255,255,255)"><font color="#0000ff">connect</font></i></div><div><i style="background-color:rgb(255,255,255)"><font color="#0000ff">batch</font></i></div><div><i style="background-color:rgb(255,255,255)"><font color="#0000ff"><br></font></i></div><div><i style="background-color:rgb(255,255,255)"><font color="#0000ff">## Add Oracle driver</font></i></div><div><i style="background-color:rgb(255,255,255)"><font color="#0000ff">/subsystem=datasources/jdbc-driver=oracleup:add(driver-name=oracleup,driver-module-name=com.oracle,driver-xa-datasource-class-name=oracle.jdbc.xa.client.OracleXADataSource)</font></i></div><div><i style="background-color:rgb(255,255,255)"><font color="#0000ff"><br></font></i></div><div><i style="background-color:rgb(255,255,255)"><font color="#0000ff">## Add UnifiedPush Datasource</font></i></div><div><i style="background-color:rgb(255,255,255)"><font color="#0000ff">data-source add --name=UnifiedPushDS --driver-name=oracleup --jndi-name=java:jboss/datasources/UnifiedPushDS --connection-url=jdbc:oracle:thin:@localhost:1521:XE --user-name=unifiedpush --password=unifiedpush --use-ccm=false --max-pool-size=25 --blocking-timeout-wait-millis=5000 --enabled=true</font></i></div><div><i style="background-color:rgb(255,255,255)"><font color="#0000ff"><br></font></i></div><div><i style="background-color:rgb(255,255,255)"><font color="#0000ff">run-batch</font></i></div><div><i style="background-color:rgb(255,255,255)"><font color="#0000ff">#:reload</font></i></div></div><div><br></div><div>next I configurate wildfly with this and deploy 2 war files. It was very good :)</div><div><br></div><div>But when I tried it with EAP 6.3.0 with same "ojdbc6-12.1.0.1.jar", module.xml and</div><div>next oracle-database-config.cli<br></div><div><br></div><div><div><font color="#0000ff"><i># $JBOSS_HOME/bin/jboss-cli.sh --file=/path/to/this/file.</i></font></div><div><font color="#0000ff"><i>connect</i></font></div><div><font color="#0000ff"><i>batch</i></font></div><div><font color="#0000ff"><i><br></i></font></div><div><font color="#0000ff"><i>## Add Oracle driver</i></font></div><div><font color="#0000ff"><i>/subsystem=datasources/jdbc-driver=oracleup:add(driver-name=oracleup,driver-module-name=com.oracle,driver-xa-datasource-class-name=oracle.jdbc.xa.client.OracleXADataSource)</i></font></div><div><font color="#0000ff"><i><br></i></font></div><div><font color="#0000ff"><i>## Add UnifiedPush Datasource</i></font></div><div><font color="#0000ff"><i>data-source add --name=UnifiedPushDS --driver-name=oracleup --jndi-name=java:jboss/datasources/UnifiedPushDS --connection-url=jdbc:oracle:thin:@localhost:1521:XE --user-name=unifiedpush --password=unifiedpush --use-ccm=false --max-pool-size=25 --blocking-timeout-wait-millis=5000</i></font></div><div><font color="#0000ff"><i>data-source enable --name=UnifiedPushDS</i></font></div><div><font color="#0000ff"><i><br></i></font></div><div><font color="#0000ff"><i>run-batch</i></font></div><div><font color="#0000ff"><i>#:reload</i></font></div></div><div><br></div><div><br></div><div>after configurating database and deploying 2 war files (ag-push.war specialy for AS7), it started Aerogear administration web UI and I can login to web interface. After creating application and variant, I tried to register mobile device in AG with successfull status in mobile device, but without creating instalation in AG and server threw exception (log)</div><div><br></div><div><div><i><font color="#0000ff">17:10:06,593 WARN [org.jboss.resteasy.core.ResourceLocator] (http-/0.0.0.0:8080-2) Field uriInfo of subresource org.keycloak.services.resources.PublicRealmResource will not be injected according to spec</font></i></div><div><i><font color="#0000ff">17:10:06,594 WARN [org.jboss.resteasy.core.ResourceLocator] (http-/0.0.0.0:8080-2) Field request of subresource org.keycloak.services.resources.PublicRealmResource will not be injected according to spec</font></i></div><div><i><font color="#0000ff">17:10:06,594 WARN [org.jboss.resteasy.core.ResourceLocator] (http-/0.0.0.0:8080-2) Field response of subresource org.keycloak.services.resources.PublicRealmResource will not be injected according to spec</font></i></div><div><i><font color="#0000ff">17:10:06,671 INFO [org.jboss.resteasy.cdi.CdiInjectorFactory] (http-/0.0.0.0:8080-1) Found BeanManager at java:comp/BeanManager</font></i></div><div><i><font color="#0000ff">17:10:06,698 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (http-/0.0.0.0:8080-1) Deploying javax.ws.rs.core.Application: class org.jboss.aerogear.unifiedpush.rest.RestApplication$Proxy$_$$_WeldClientProxy</font></i></div><div><i><font color="#0000ff">17:10:07,074 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 1) SQL Error: 997, SQLState: 42000</font></i></div><div><i><font color="#0000ff">17:10:07,074 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 1) ORA-00997: illegal use of LONG datatype</font></i></div><div><i><font color="#0000ff"><br></font></i></div><div><i><font color="#0000ff">17:10:07,094 ERROR [org.jboss.as.ejb3.invocation] (EJB default - 1) JBAS014134: EJB Invocation failed on component ClientInstallationServiceImpl for method public abstract void org.jboss.aerogear.unifiedpush.service.ClientInstallationService.addInstallation(org.jboss.aerogear.unifiedpush.api.Variant,org.jboss.aerogear.unifiedpush.api.Installation): javax.ejb.EJBException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.ejb3.tx.CMTTxInterceptor.handleExceptionInOurTx(CMTTxInterceptor.java:189) [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:274) [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:339) [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:238) [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64) [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59) [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55) [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45) [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185) [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182) [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.ejb3.component.interceptors.AsyncFutureInterceptorFactory$1$1.runInvocation(AsyncFutureInterceptorFactory.java:89) [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.ejb3.component.interceptors.AsyncInvocationTask.run(AsyncInvocationTask.java:73) [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_67]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_67]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_67]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.threads.JBossThread.run(JBossThread.java:122)</font></i></div><div><i><font color="#0000ff">Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387) [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310) [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:277) [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.aerogear.unifiedpush.jpa.dao.impl.JPAInstallationDao.getSingleResultForQuery(JPAInstallationDao.java:199) [unifiedpush-model-jpa-1.1.0-SNAPSHOT.jar:]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.aerogear.unifiedpush.jpa.dao.impl.JPAInstallationDao.findInstallationForVariantByDeviceToken(JPAInstallationDao.java:72) [unifiedpush-model-jpa-1.1.0-SNAPSHOT.jar:]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.aerogear.unifiedpush.service.impl.ClientInstallationServiceImpl.findInstallationForVariantByDeviceToken(ClientInstallationServiceImpl.java:177) [unifiedpush-service-1.1.0-SNAPSHOT.jar:]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.aerogear.unifiedpush.service.impl.ClientInstallationServiceImpl.addInstallation(ClientInstallationServiceImpl.java:51) [unifiedpush-service-1.1.0-SNAPSHOT.jar:]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_67]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_67]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_67]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_67]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52) [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63) [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:86) [jboss-as-weld-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:97) [jboss-as-weld-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63) [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63) [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43) [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47) [jboss-as-jpa-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:93) [jboss-as-weld-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53) [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51) [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:272) [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>... 25 more</font></i></div><div><i><font color="#0000ff">Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:88) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.loader.Loader.getResultSet(Loader.java:2062) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1859) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.loader.Loader.doQuery(Loader.java:906) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.loader.Loader.doList(Loader.java:2550) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.loader.Loader.doList(Loader.java:2536) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2366) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.loader.Loader.list(Loader.java:2361) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:495) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:357) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:198) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1194) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:268) [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>... 60 more</font></i></div><div><i><font color="#0000ff">Caused by: java.sql.SQLSyntaxErrorException: ORA-00997: illegal use of LONG datatype</font></i></div><div><i><font color="#0000ff"><br></font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]</font></i></div><div><i><font color="#0000ff"><span class="" style="white-space:pre"> </span>... 75 more</font></i></div></div><div><br></div><div>I use same ojdbc6-12.1.0.1.jar and same database with wildfly and EAP ... I tried to fix it for a 3 days, but I haven't found solution.</div><div><br></div><div><span style="font-family:arial,sans-serif;font-size:13px">Can you help me with this problem? Thanks.</span><br></div>
</div>