<div dir="ltr">Problem is with Instalation Table ... object Instalation have "String deviceToken..." and in database it is LONG ... when we try add Instalation to Aerogear ... it threw exception ... when we hardly changed in database LONG to VARCHAR(255) it is ok ... but it is not a solution ... there in no problem with table PushMessageInformation alhough it also contains LONG column<div>When we try in wildfly again it has same problem ... </div><div>And the worst is that LONG is deprecated in Oracle ... and CLOB should be used</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div><span style="color:rgb(7,55,99)"><b>Mgr. Ivan Gürtler</b></span><br></div><span style="color:rgb(102,102,102)">Mobile software developer</span><br><br>AHEAD iTec, s.r.o., Botanická 554/68a,<br>602 00 Brno (Czech Republic)<br><br><a href="http://www.ahead-itec.com/" style="color:rgb(17,85,204)" target="_blank">www.ahead-itec.com</a> | <a href="https://www.twitter.com/AHEADiTec" style="color:rgb(17,85,204)" target="_blank">twitter</a> | mobile security solutions<br></div></div></div>
<br><div class="gmail_quote">2014-11-27 13:52 GMT+01:00 Karel Piwko <span dir="ltr"><<a href="mailto:kpiwko@redhat.com" target="_blank">kpiwko@redhat.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Ivan,<br>
<br>
I'll have time to check your setup starting next week and I'll try<br>
reproduce the problem. I would appreciate if you can send me exact<br>
commit sha of UnifiedPush you are using as I've noticed that you are<br>
deploying -SNAPSHOT version. It would also help me to know whether you<br>
are able to reproduce the behavior with UPS 1.0.2 tag/release and<br>
detailed sql query log, that can be enabled in persistence.xml.<br>
<br>
Given the exception, I suspect that default Oracle dialect mapping has<br>
changed from Hibernate 4.1 (EAP 6.3.0) to Hibernate 4.3 (WF 9.0.0.A1).<br>
<br>
Thanks,<br>
<br>
Karel<br>
<span class=""><br>
<br>
On Wed, 2014-11-26 at 17:21 +0100, Ivan Gürtler wrote:<br>
> Hi,<br>
> I tried to use aerogear with oracle database. When I used wildfly it was<br>
> good.<br>
><br>
> I create module.xml for "ojdbc6-12.1.0.1.jar":<br>
><br>
</span>> *<?xml version="1.0" encoding="UTF-8"?>*<br>
><br>
> *<module xmlns="urn:jboss:module:1.0" name="com.oracle">*<br>
> * <resources>*<br>
> * <resource-root path="ojdbc6-12.1.0.1.jar"/>*<br>
> * <!-- Insert resources here -->*<br>
> * </resources>*<br>
> * <dependencies>*<br>
> * <module name="javax.api"/>*<br>
> * <module name="javax.transaction.api"/>*<br>
> * </dependencies>*<br>
> *</module>*<br>
><br>
> next I create oracle-database-config-wildfly.cli<br>
><br>
> *# $WILDFLY_HOME/bin/jboss-cli.sh --file=/path/to/this/file.*<br>
> *connect*<br>
> *batch*<br>
><br>
> *## Add Oracle driver*<br>
> */subsystem=datasources/jdbc-driver=oracleup:add(driver-name=oracleup,driver-module-name=com.oracle,driver-xa-datasource-class-name=oracle.jdbc.xa.client.OracleXADataSource)*<br>
><br>
> *## Add UnifiedPush Datasource*<br>
> *data-source add --name=UnifiedPushDS --driver-name=oracleup<br>
<span class="">> --jndi-name=java:jboss/datasources/UnifiedPushDS<br>
> --connection-url=jdbc:oracle:thin:@localhost:1521:XE<br>
> --user-name=unifiedpush --password=unifiedpush --use-ccm=false<br>
</span>> --max-pool-size=25 --blocking-timeout-wait-millis=5000 --enabled=true*<br>
><br>
> *run-batch*<br>
> *#:reload*<br>
<span class="">><br>
> next I configurate wildfly with this and deploy 2 war files. It was very<br>
> good :)<br>
><br>
> But when I tried it with EAP 6.3.0 with same "ojdbc6-12.1.0.1.jar",<br>
> module.xml and<br>
> next oracle-database-config.cli<br>
><br>
</span>> *# $JBOSS_HOME/bin/jboss-cli.sh --file=/path/to/this/file.*<br>
> *connect*<br>
> *batch*<br>
><br>
> *## Add Oracle driver*<br>
> */subsystem=datasources/jdbc-driver=oracleup:add(driver-name=oracleup,driver-module-name=com.oracle,driver-xa-datasource-class-name=oracle.jdbc.xa.client.OracleXADataSource)*<br>
><br>
> *## Add UnifiedPush Datasource*<br>
> *data-source add --name=UnifiedPushDS --driver-name=oracleup<br>
<span class="">> --jndi-name=java:jboss/datasources/UnifiedPushDS<br>
> --connection-url=jdbc:oracle:thin:@localhost:1521:XE<br>
> --user-name=unifiedpush --password=unifiedpush --use-ccm=false<br>
</span>> --max-pool-size=25 --blocking-timeout-wait-millis=5000*<br>
> *data-source enable --name=UnifiedPushDS*<br>
><br>
> *run-batch*<br>
> *#:reload*<br>
<span class="">><br>
><br>
> after configurating database and deploying 2 war files (ag-push.war<br>
> specialy for AS7), it started Aerogear administration web UI and I can<br>
> login to web interface. After creating application and variant, I tried to<br>
> register mobile device in AG with successfull status in mobile device, but<br>
> without creating instalation in AG and server threw exception (log)<br>
><br>
</span>> *17:10:06,593 WARN [org.jboss.resteasy.core.ResourceLocator]<br>
<span class="">> (http-/0.0.0.0:8080-2) Field uriInfo of subresource<br>
> org.keycloak.services.resources.PublicRealmResource will not be injected<br>
</span>> according to spec*<br>
> *17:10:06,594 WARN [org.jboss.resteasy.core.ResourceLocator]<br>
<span class="">> (http-/0.0.0.0:8080-2) Field request of subresource<br>
> org.keycloak.services.resources.PublicRealmResource will not be injected<br>
</span>> according to spec*<br>
> *17:10:06,594 WARN [org.jboss.resteasy.core.ResourceLocator]<br>
<span class="">> (http-/0.0.0.0:8080-2) Field response of subresource<br>
> org.keycloak.services.resources.PublicRealmResource will not be injected<br>
</span>> according to spec*<br>
> *17:10:06,671 INFO [org.jboss.resteasy.cdi.CdiInjectorFactory]<br>
> (http-/0.0.0.0:8080-1) Found BeanManager at java:comp/BeanManager*<br>
> *17:10:06,698 INFO [org.jboss.resteasy.spi.ResteasyDeployment]<br>
<span class="">> (http-/0.0.0.0:8080-1) Deploying javax.ws.rs.core.Application: class<br>
</span>> org.jboss.aerogear.unifiedpush.rest.RestApplication$Proxy$_$$_WeldClientProxy*<br>
> *17:10:07,074 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB<br>
> default - 1) SQL Error: 997, SQLState: 42000*<br>
> *17:10:07,074 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB<br>
> default - 1) ORA-00997: illegal use of LONG datatype*<br>
><br>
> *17:10:07,094 ERROR [org.jboss.as.ejb3.invocation] (EJB default - 1)<br>
<span class="">> JBAS014134: EJB Invocation failed on component<br>
> ClientInstallationServiceImpl for method public abstract void<br>
> org.jboss.aerogear.unifiedpush.service.ClientInstallationService.addInstallation(org.jboss.aerogear.unifiedpush.api.Variant,org.jboss.aerogear.unifiedpush.api.Installation):<br>
> javax.ejb.EJBException: javax.persistence.PersistenceException:<br>
</span>> org.hibernate.exception.SQLGrammarException: could not extract ResultSet*<br>
> * at<br>
> org.jboss.as.ejb3.tx.CMTTxInterceptor.handleExceptionInOurTx(CMTTxInterceptor.java:189)<br>
> [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:274)<br>
> [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:339)<br>
> [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:238)<br>
> [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)<br>
> [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)<br>
> [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)<br>
> [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)<br>
> [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55)<br>
> [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)<br>
> [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)<br>
> [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182)<br>
> [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.as.ejb3.component.interceptors.AsyncFutureInterceptorFactory$1$1.runInvocation(AsyncFutureInterceptorFactory.java:89)<br>
> [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.as.ejb3.component.interceptors.AsyncInvocationTask.run(AsyncInvocationTask.java:73)<br>
> [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)<br>
> [rt.jar:1.7.0_67]*<br>
> * at<br>
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)<br>
> [rt.jar:1.7.0_67]*<br>
> * at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_67]*<br>
> * at org.jboss.threads.JBossThread.run(JBossThread.java:122)*<br>
> *Caused by: javax.persistence.PersistenceException:<br>
> org.hibernate.exception.SQLGrammarException: could not extract ResultSet*<br>
> * at<br>
> org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)<br>
> [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * at<br>
> org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)<br>
> [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:277)<br>
> [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * at<br>
> org.jboss.aerogear.unifiedpush.jpa.dao.impl.JPAInstallationDao.getSingleResultForQuery(JPAInstallationDao.java:199)<br>
> [unifiedpush-model-jpa-1.1.0-SNAPSHOT.jar:]*<br>
> * at<br>
> org.jboss.aerogear.unifiedpush.jpa.dao.impl.JPAInstallationDao.findInstallationForVariantByDeviceToken(JPAInstallationDao.java:72)<br>
> [unifiedpush-model-jpa-1.1.0-SNAPSHOT.jar:]*<br>
> * at<br>
> org.jboss.aerogear.unifiedpush.service.impl.ClientInstallationServiceImpl.findInstallationForVariantByDeviceToken(ClientInstallationServiceImpl.java:177)<br>
> [unifiedpush-service-1.1.0-SNAPSHOT.jar:]*<br>
> * at<br>
> org.jboss.aerogear.unifiedpush.service.impl.ClientInstallationServiceImpl.addInstallation(ClientInstallationServiceImpl.java:51)<br>
> [unifiedpush-service-1.1.0-SNAPSHOT.jar:]*<br>
> * at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br>
> [rt.jar:1.7.0_67]*<br>
> * at<br>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br>
> [rt.jar:1.7.0_67]*<br>
> * at<br>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br>
> [rt.jar:1.7.0_67]*<br>
> * at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_67]*<br>
> * at<br>
> org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)<br>
> [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)<br>
> [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:86)<br>
> [jboss-as-weld-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:97)<br>
> [jboss-as-weld-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)<br>
> [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)<br>
> [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)<br>
> [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)<br>
> [jboss-as-jpa-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:93)<br>
> [jboss-as-weld-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)<br>
> [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51)<br>
> [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * at<br>
> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
> [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
> * at<br>
> org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:272)<br>
> [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
> * ... 25 more*<br>
> *Caused by: org.hibernate.exception.SQLGrammarException: could not extract<br>
> ResultSet*<br>
> * at<br>
> org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82)<br>
> [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * at<br>
> org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)<br>
> [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * at<br>
> org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124)<br>
> [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * at<br>
> org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)<br>
> [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * at<br>
> org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:88)<br>
> [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * at org.hibernate.loader.Loader.getResultSet(Loader.java:2062)<br>
> [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1859)<br>
> [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)<br>
> [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * at org.hibernate.loader.Loader.doQuery(Loader.java:906)<br>
> [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * at<br>
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)<br>
> [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * at org.hibernate.loader.Loader.doList(Loader.java:2550)<br>
> [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * at org.hibernate.loader.Loader.doList(Loader.java:2536)<br>
> [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2366)<br>
> [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * at org.hibernate.loader.Loader.list(Loader.java:2361)<br>
> [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:495)<br>
> [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * at<br>
> org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:357)<br>
> [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * at<br>
> org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:198)<br>
> [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1194)<br>
> [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)<br>
> [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:268)<br>
> [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * ... 60 more*<br>
> *Caused by: java.sql.SQLSyntaxErrorException: ORA-00997: illegal use of<br>
> LONG datatype*<br>
><br>
> * at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)*<br>
> * at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)*<br>
> * at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)*<br>
> * at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)*<br>
> * at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)*<br>
> * at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)*<br>
> * at<br>
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)*<br>
> * at<br>
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)*<br>
> * at<br>
> oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)*<br>
> * at<br>
> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)*<br>
> * at<br>
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)*<br>
> * at<br>
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)*<br>
> * at<br>
> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)*<br>
> * at<br>
> oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)*<br>
> * at<br>
> org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)*<br>
> * at<br>
> org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)<br>
> [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
> * ... 75 more*<br>
<span class="im HOEnZb">><br>
> I use same ojdbc6-12.1.0.1.jar and same database with wildfly and EAP ... I<br>
> tried to fix it for a 3 days, but I haven't found solution.<br>
><br>
> Can you help me with this problem? Thanks.<br>
</span><div class="HOEnZb"><div class="h5">> _______________________________________________<br>
> aerogear-dev mailing list<br>
> <a href="mailto:aerogear-dev@lists.jboss.org">aerogear-dev@lists.jboss.org</a><br>
> <a href="https://lists.jboss.org/mailman/listinfo/aerogear-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/aerogear-dev</a><br>
<br>
<br>
_______________________________________________<br>
aerogear-dev mailing list<br>
<a href="mailto:aerogear-dev@lists.jboss.org">aerogear-dev@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/aerogear-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/aerogear-dev</a></div></div></blockquote></div><br></div>