<div dir="ltr">Ok, I filed this ticket:<div><br></div><div><a href="https://hibernate.atlassian.net/browse/HHH-9526">https://hibernate.atlassian.net/browse/HHH-9526</a><br></div><div><br></div><div>Ivan, can you review this ticket and update, if needed? Thanks!</div><div><br></div><div>-Matthias</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Dec 2, 2014 at 9:35 AM, Ivan Gürtler <span dir="ltr">&lt;<a href="mailto:ivan.gurtler@ahead-itec.com" target="_blank">ivan.gurtler@ahead-itec.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">We used VARCHAR2 ... but max value is lower than 4K ... <div><br></div><div>yes ... the reason for LONG is large size ...  and LONG in oracle have much problems ... e.g. it is imposible use LONG in &quot;where&quot; -&gt; exception</div></div><div class="gmail_extra"><span class=""><br clear="all"><div><div><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></span><div><div class="h5"><div class="gmail_quote">2014-12-01 20:49 GMT+01:00 Matthias Wessendorf <span dir="ltr">&lt;<a href="mailto:matzew@apache.org" target="_blank">matzew@apache.org</a>&gt;</span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span><br><br>On Monday, December 1, 2014, Ivan Gürtler &lt;<a href="mailto:ivan.gurtler@ahead-itec.com" target="_blank">ivan.gurtler@ahead-itec.com</a>&gt; wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Problem is with Instalation Table ... object Instalation have &quot;String deviceToken...&quot; and in database it is LONG ... </div><div dir="ltr"></div></blockquote><div><br></div></span><div>weird, because type is string.</div><div>Is hibernate getting that mapping wrong?</div><span><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">when we try add Instalation to Aerogear ... it threw exception ... when we hardly changed in database LONG to VARCHAR(255) it is ok ... </div><div dir="ltr"></div></blockquote><div><br></div></span><div>you want it <span></span>a bit larger:</div><div><a href="https://github.com/aerogear/aerogear-unifiedpush-server/blob/master/model/jpa/src/main/resources/META-INF/orm.xml#L44" target="_blank">https://github.com/aerogear/aerogear-unifiedpush-server/blob/master/model/jpa/src/main/resources/META-INF/orm.xml#L44</a><br></div><div><br></div><div>is that large size the reason for LONG being used?</div><div><div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">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><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">&lt;<a>kpiwko@redhat.com</a>&gt;</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&#39;ll have time to check your setup starting next week and I&#39;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&#39;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><br>
<br>
On Wed, 2014-11-26 at 17:21 +0100, Ivan Gürtler wrote:<br>
&gt; Hi,<br>
&gt; I tried to use aerogear with oracle database. When I used wildfly it was<br>
&gt; good.<br>
&gt;<br>
&gt; I create module.xml for &quot;ojdbc6-12.1.0.1.jar&quot;:<br>
&gt;<br>
</span>&gt; *&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;*<br>
&gt;<br>
&gt; *&lt;module xmlns=&quot;urn:jboss:module:1.0&quot; name=&quot;com.oracle&quot;&gt;*<br>
&gt; *  &lt;resources&gt;*<br>
&gt; *    &lt;resource-root path=&quot;ojdbc6-12.1.0.1.jar&quot;/&gt;*<br>
&gt; *        &lt;!-- Insert resources here --&gt;*<br>
&gt; *  &lt;/resources&gt;*<br>
&gt; *  &lt;dependencies&gt;*<br>
&gt; *    &lt;module name=&quot;javax.api&quot;/&gt;*<br>
&gt; *    &lt;module name=&quot;javax.transaction.api&quot;/&gt;*<br>
&gt; *  &lt;/dependencies&gt;*<br>
&gt; *&lt;/module&gt;*<br>
&gt;<br>
&gt; next I create oracle-database-config-wildfly.cli<br>
&gt;<br>
&gt; *# $WILDFLY_HOME/bin/jboss-cli.sh --file=/path/to/this/file.*<br>
&gt; *connect*<br>
&gt; *batch*<br>
&gt;<br>
&gt; *## Add Oracle driver*<br>
&gt; */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>
&gt;<br>
&gt; *## Add UnifiedPush Datasource*<br>
&gt; *data-source add --name=UnifiedPushDS --driver-name=oracleup<br>
<span>&gt; --jndi-name=java:jboss/datasources/UnifiedPushDS<br>
&gt; --connection-url=jdbc:oracle:thin:@localhost:1521:XE<br>
&gt; --user-name=unifiedpush --password=unifiedpush --use-ccm=false<br>
</span>&gt; --max-pool-size=25 --blocking-timeout-wait-millis=5000 --enabled=true*<br>
&gt;<br>
&gt; *run-batch*<br>
&gt; *#:reload*<br>
<span>&gt;<br>
&gt; next I configurate wildfly with this and deploy 2 war files. It was very<br>
&gt; good :)<br>
&gt;<br>
&gt; But when I tried it with EAP 6.3.0 with same &quot;ojdbc6-12.1.0.1.jar&quot;,<br>
&gt; module.xml and<br>
&gt; next oracle-database-config.cli<br>
&gt;<br>
</span>&gt; *# $JBOSS_HOME/bin/jboss-cli.sh --file=/path/to/this/file.*<br>
&gt; *connect*<br>
&gt; *batch*<br>
&gt;<br>
&gt; *## Add Oracle driver*<br>
&gt; */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>
&gt;<br>
&gt; *## Add UnifiedPush Datasource*<br>
&gt; *data-source add --name=UnifiedPushDS --driver-name=oracleup<br>
<span>&gt; --jndi-name=java:jboss/datasources/UnifiedPushDS<br>
&gt; --connection-url=jdbc:oracle:thin:@localhost:1521:XE<br>
&gt; --user-name=unifiedpush --password=unifiedpush --use-ccm=false<br>
</span>&gt; --max-pool-size=25 --blocking-timeout-wait-millis=5000*<br>
&gt; *data-source enable --name=UnifiedPushDS*<br>
&gt;<br>
&gt; *run-batch*<br>
&gt; *#:reload*<br>
<span>&gt;<br>
&gt;<br>
&gt; after configurating database and deploying 2 war files (ag-push.war<br>
&gt; specialy for AS7), it started Aerogear administration web UI and I can<br>
&gt; login to web interface. After creating application and variant, I tried to<br>
&gt; register mobile device in AG with successfull status in mobile device, but<br>
&gt; without creating instalation in AG and server threw exception (log)<br>
&gt;<br>
</span>&gt; *17:10:06,593 WARN  [org.jboss.resteasy.core.ResourceLocator]<br>
<span>&gt; (http-/0.0.0.0:8080-2) Field uriInfo of subresource<br>
&gt; org.keycloak.services.resources.PublicRealmResource will not be injected<br>
</span>&gt; according to spec*<br>
&gt; *17:10:06,594 WARN  [org.jboss.resteasy.core.ResourceLocator]<br>
<span>&gt; (http-/0.0.0.0:8080-2) Field request of subresource<br>
&gt; org.keycloak.services.resources.PublicRealmResource will not be injected<br>
</span>&gt; according to spec*<br>
&gt; *17:10:06,594 WARN  [org.jboss.resteasy.core.ResourceLocator]<br>
<span>&gt; (http-/0.0.0.0:8080-2) Field response of subresource<br>
&gt; org.keycloak.services.resources.PublicRealmResource will not be injected<br>
</span>&gt; according to spec*<br>
&gt; *17:10:06,671 INFO  [org.jboss.resteasy.cdi.CdiInjectorFactory]<br>
&gt; (http-/0.0.0.0:8080-1) Found BeanManager at java:comp/BeanManager*<br>
&gt; *17:10:06,698 INFO  [org.jboss.resteasy.spi.ResteasyDeployment]<br>
<span>&gt; (http-/0.0.0.0:8080-1) Deploying javax.ws.rs.core.Application: class<br>
</span>&gt; org.jboss.aerogear.unifiedpush.rest.RestApplication$Proxy$_$$_WeldClientProxy*<br>
&gt; *17:10:07,074 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB<br>
&gt; default - 1) SQL Error: 997, SQLState: 42000*<br>
&gt; *17:10:07,074 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB<br>
&gt; default - 1) ORA-00997: illegal use of LONG datatype*<br>
&gt;<br>
&gt; *17:10:07,094 ERROR [org.jboss.as.ejb3.invocation] (EJB default - 1)<br>
<span>&gt; JBAS014134: EJB Invocation failed on component<br>
&gt; ClientInstallationServiceImpl for method public abstract void<br>
&gt; org.jboss.aerogear.unifiedpush.service.ClientInstallationService.addInstallation(org.jboss.aerogear.unifiedpush.api.Variant,org.jboss.aerogear.unifiedpush.api.Installation):<br>
&gt; javax.ejb.EJBException: javax.persistence.PersistenceException:<br>
</span>&gt; org.hibernate.exception.SQLGrammarException: could not extract ResultSet*<br>
&gt; * at<br>
&gt; org.jboss.as.ejb3.tx.CMTTxInterceptor.handleExceptionInOurTx(CMTTxInterceptor.java:189)<br>
&gt; [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:274)<br>
&gt; [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:339)<br>
&gt; [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:238)<br>
&gt; [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)<br>
&gt; [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)<br>
&gt; [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)<br>
&gt; [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)<br>
&gt; [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:55)<br>
&gt; [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)<br>
&gt; [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:185)<br>
&gt; [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:182)<br>
&gt; [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.as.ejb3.component.interceptors.AsyncFutureInterceptorFactory$1$1.runInvocation(AsyncFutureInterceptorFactory.java:89)<br>
&gt; [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.as.ejb3.component.interceptors.AsyncInvocationTask.run(AsyncInvocationTask.java:73)<br>
&gt; [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)<br>
&gt; [rt.jar:1.7.0_67]*<br>
&gt; * at<br>
&gt; java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)<br>
&gt; [rt.jar:1.7.0_67]*<br>
&gt; * at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_67]*<br>
&gt; * at org.jboss.threads.JBossThread.run(JBossThread.java:122)*<br>
&gt; *Caused by: javax.persistence.PersistenceException:<br>
&gt; org.hibernate.exception.SQLGrammarException: could not extract ResultSet*<br>
&gt; * at<br>
&gt; org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)<br>
&gt; [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)<br>
&gt; [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:277)<br>
&gt; [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.aerogear.unifiedpush.jpa.dao.impl.JPAInstallationDao.getSingleResultForQuery(JPAInstallationDao.java:199)<br>
&gt; [unifiedpush-model-jpa-1.1.0-SNAPSHOT.jar:]*<br>
&gt; * at<br>
&gt; org.jboss.aerogear.unifiedpush.jpa.dao.impl.JPAInstallationDao.findInstallationForVariantByDeviceToken(JPAInstallationDao.java:72)<br>
&gt; [unifiedpush-model-jpa-1.1.0-SNAPSHOT.jar:]*<br>
&gt; * at<br>
&gt; org.jboss.aerogear.unifiedpush.service.impl.ClientInstallationServiceImpl.findInstallationForVariantByDeviceToken(ClientInstallationServiceImpl.java:177)<br>
&gt; [unifiedpush-service-1.1.0-SNAPSHOT.jar:]*<br>
&gt; * at<br>
&gt; org.jboss.aerogear.unifiedpush.service.impl.ClientInstallationServiceImpl.addInstallation(ClientInstallationServiceImpl.java:51)<br>
&gt; [unifiedpush-service-1.1.0-SNAPSHOT.jar:]*<br>
&gt; * at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br>
&gt; [rt.jar:1.7.0_67]*<br>
&gt; * at<br>
&gt; sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br>
&gt; [rt.jar:1.7.0_67]*<br>
&gt; * at<br>
&gt; sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br>
&gt; [rt.jar:1.7.0_67]*<br>
&gt; * at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_67]*<br>
&gt; * at<br>
&gt; org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)<br>
&gt; [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)<br>
&gt; [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:374)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:86)<br>
&gt; [jboss-as-weld-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:97)<br>
&gt; [jboss-as-weld-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)<br>
&gt; [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)<br>
&gt; [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)<br>
&gt; [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)<br>
&gt; [jboss-as-jpa-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:93)<br>
&gt; [jboss-as-weld-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)<br>
&gt; [jboss-as-ee-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51)<br>
&gt; [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * at<br>
&gt; org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)<br>
&gt; [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:272)<br>
&gt; [jboss-as-ejb3-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]*<br>
&gt; * ... 25 more*<br>
&gt; *Caused by: org.hibernate.exception.SQLGrammarException: could not extract<br>
&gt; ResultSet*<br>
&gt; * at<br>
&gt; org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82)<br>
&gt; [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)<br>
&gt; [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124)<br>
&gt; [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)<br>
&gt; [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:88)<br>
&gt; [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * at org.hibernate.loader.Loader.getResultSet(Loader.java:2062)<br>
&gt; [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1859)<br>
&gt; [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)<br>
&gt; [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * at org.hibernate.loader.Loader.doQuery(Loader.java:906)<br>
&gt; [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)<br>
&gt; [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * at org.hibernate.loader.Loader.doList(Loader.java:2550)<br>
&gt; [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * at org.hibernate.loader.Loader.doList(Loader.java:2536)<br>
&gt; [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2366)<br>
&gt; [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * at org.hibernate.loader.Loader.list(Loader.java:2361)<br>
&gt; [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:495)<br>
&gt; [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:357)<br>
&gt; [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * at<br>
&gt; org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:198)<br>
&gt; [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1194)<br>
&gt; [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)<br>
&gt; [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:268)<br>
&gt; [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * ... 60 more*<br>
&gt; *Caused by: java.sql.SQLSyntaxErrorException: ORA-00997: illegal use of<br>
&gt; LONG datatype*<br>
&gt;<br>
&gt; * at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)*<br>
&gt; * at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)*<br>
&gt; * at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)*<br>
&gt; * at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)*<br>
&gt; * at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)*<br>
&gt; * at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)*<br>
&gt; * at<br>
&gt; oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)*<br>
&gt; * at<br>
&gt; oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)*<br>
&gt; * at<br>
&gt; oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)*<br>
&gt; * at<br>
&gt; oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)*<br>
&gt; * at<br>
&gt; oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)*<br>
&gt; * at<br>
&gt; oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)*<br>
&gt; * at<br>
&gt; oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)*<br>
&gt; * at<br>
&gt; oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)*<br>
&gt; * at<br>
&gt; org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)*<br>
&gt; * at<br>
&gt; org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)<br>
&gt; [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*<br>
&gt; * ... 75 more*<br>
<span>&gt;<br>
&gt; I use same ojdbc6-12.1.0.1.jar and same database with wildfly and EAP ... I<br>
&gt; tried to fix it for a 3 days, but I haven&#39;t found solution.<br>
&gt;<br>
&gt; Can you help me with this problem? Thanks.<br>
</span><div><div>&gt; _______________________________________________<br>
&gt; aerogear-dev mailing list<br>
&gt; <a>aerogear-dev@lists.jboss.org</a><br>
&gt; <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>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>
</blockquote><br><br></div></div><span><font color="#888888">-- <br>Sent from Gmail Mobile<br>
</font></span><br>_______________________________________________<br>
aerogear-dev mailing list<br>
<a href="mailto:aerogear-dev@lists.jboss.org" target="_blank">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></blockquote></div><br></div></div></div>
<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><br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature">Matthias Wessendorf <br><br>blog: <a href="http://matthiaswessendorf.wordpress.com/" target="_blank">http://matthiaswessendorf.wordpress.com/</a><br>sessions: <a href="http://www.slideshare.net/mwessendorf" target="_blank">http://www.slideshare.net/mwessendorf</a><br>twitter: <a href="http://twitter.com/mwessendorf" target="_blank">http://twitter.com/mwessendorf</a></div>
</div>