[aerogear-dev] use oracle database

Tue Dec 2 11:51:46 EST 2014

Ok, I filed this ticket:

https://hibernate.atlassian.net/browse/HHH-9526

Ivan, can you review this ticket and update, if needed? Thanks!

-Matthias

On Tue, Dec 2, 2014 at 9:35 AM, Ivan Gürtler <ivan.gurtler at ahead-itec.com>
wrote:

> We used VARCHAR2 ... but max value is lower than 4K ...
>
> yes ... the reason for LONG is large size ...  and LONG in oracle have
> much problems ... e.g. it is imposible use LONG in "where" -> exception
>
> *Mgr. Ivan Gürtler*
> Mobile software developer
>
> AHEAD iTec, s.r.o., Botanická 554/68a,
> 602 00 Brno (Czech Republic)
>
> www.ahead-itec.com | twitter <https://www.twitter.com/AHEADiTec> | mobile
> security solutions
>
> 2014-12-01 20:49 GMT+01:00 Matthias Wessendorf <matzew at apache.org>:
>
>>
>>
>> On Monday, December 1, 2014, Ivan Gürtler <ivan.gurtler at ahead-itec.com>
>> wrote:
>>
>>> Problem is with Instalation Table ... object Instalation have "String
>>> deviceToken..." and in database it is LONG ...
>>>
>>
>> weird, because type is string.
>> Is hibernate getting that mapping wrong?
>>
>>
>>
>>> when we try add Instalation to Aerogear ... it threw exception ... when
>>> we hardly changed in database LONG to VARCHAR(255) it is ok ...
>>>
>>
>> you want it a bit larger:
>>
>> https://github.com/aerogear/aerogear-unifiedpush-server/blob/master/model/jpa/src/main/resources/META-INF/orm.xml#L44
>>
>> is that large size the reason for LONG being used?
>>
>>
>>
>>> but it is not a solution ... there in no problem with table
>>> PushMessageInformation alhough it also contains LONG column
>>> When we try in wildfly again it has same problem ...
>>> And the worst is that LONG is deprecated in Oracle ... and CLOB should
>>> be used
>>>
>>> *Mgr. Ivan Gürtler*
>>> Mobile software developer
>>>
>>> AHEAD iTec, s.r.o., Botanická 554/68a,
>>> 602 00 Brno (Czech Republic)
>>>
>>> www.ahead-itec.com | twitter <https://www.twitter.com/AHEADiTec> |
>>> mobile security solutions
>>>
>>> 2014-11-27 13:52 GMT+01:00 Karel Piwko <kpiwko at redhat.com>:
>>>
>>>> Hi Ivan,
>>>>
>>>> I'll have time to check your setup starting next week and I'll try
>>>> reproduce the problem. I would appreciate if you can send me exact
>>>> commit sha of UnifiedPush you are using as I've noticed that you are
>>>> deploying -SNAPSHOT version. It would also help me to know whether you
>>>> are able to reproduce the behavior with UPS 1.0.2 tag/release and
>>>> detailed sql query log, that can be enabled in persistence.xml.
>>>>
>>>> Given the exception, I suspect that default Oracle dialect mapping has
>>>> changed from Hibernate 4.1 (EAP 6.3.0) to Hibernate 4.3 (WF 9.0.0.A1).
>>>>
>>>> Thanks,
>>>>
>>>> Karel
>>>>
>>>>
>>>> On Wed, 2014-11-26 at 17:21 +0100, Ivan Gürtler wrote:
>>>> > Hi,
>>>> > I tried to use aerogear with oracle database. When I used wildfly it
>>>> was
>>>> > good.
>>>> >
>>>> > I create module.xml for "ojdbc6-12.1.0.1.jar":
>>>> >
>>>> > *<?xml version="1.0" encoding="UTF-8"?>*
>>>> >
>>>> > *<module xmlns="urn:jboss:module:1.0" name="com.oracle">*
>>>> > *  <resources>*
>>>> > *    <resource-root path="ojdbc6-12.1.0.1.jar"/>*
>>>> > *        <!-- Insert resources here -->*
>>>> > *  </resources>*
>>>> > *  <dependencies>*
>>>> > *    <module name="javax.api"/>*
>>>> > *    <module name="javax.transaction.api"/>*
>>>> > *  </dependencies>*
>>>> > *</module>*
>>>> >
>>>> > next I create oracle-database-config-wildfly.cli
>>>> >
>>>> > *# $WILDFLY_HOME/bin/jboss-cli.sh --file=/path/to/this/file.*
>>>> > *connect*
>>>> > *batch*
>>>> >
>>>> > *## Add Oracle driver*
>>>> >
>>>> */subsystem=datasources/jdbc-driver=oracleup:add(driver-name=oracleup,driver-module-name=com.oracle,driver-xa-datasource-class-name=oracle.jdbc.xa.client.OracleXADataSource)*
>>>> >
>>>> > *## Add UnifiedPush Datasource*
>>>> > *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*
>>>> >
>>>> > *run-batch*
>>>> > *#:reload*
>>>> >
>>>> > next I configurate wildfly with this and deploy 2 war files. It was
>>>> very
>>>> > good :)
>>>> >
>>>> > But when I tried it with EAP 6.3.0 with same "ojdbc6-12.1.0.1.jar",
>>>> > module.xml and
>>>> > next oracle-database-config.cli
>>>> >
>>>> > *# $JBOSS_HOME/bin/jboss-cli.sh --file=/path/to/this/file.*
>>>> > *connect*
>>>> > *batch*
>>>> >
>>>> > *## Add Oracle driver*
>>>> >
>>>> */subsystem=datasources/jdbc-driver=oracleup:add(driver-name=oracleup,driver-module-name=com.oracle,driver-xa-datasource-class-name=oracle.jdbc.xa.client.OracleXADataSource)*
>>>> >
>>>> > *## Add UnifiedPush Datasource*
>>>> > *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*
>>>> > *data-source enable --name=UnifiedPushDS*
>>>> >
>>>> > *run-batch*
>>>> > *#:reload*
>>>> >
>>>> >
>>>> > 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)
>>>> >
>>>> > *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*
>>>> > *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*
>>>> > *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*
>>>> > *17:10:06,671 INFO  [org.jboss.resteasy.cdi.CdiInjectorFactory]
>>>> > (http-/0.0.0.0:8080-1) Found BeanManager at java:comp/BeanManager*
>>>> > *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*
>>>> > *17:10:07,074 WARN
>>>> [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB
>>>> > default - 1) SQL Error: 997, SQLState: 42000*
>>>> > *17:10:07,074 ERROR
>>>> [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB
>>>> > default - 1) ORA-00997: illegal use of LONG datatype*
>>>> >
>>>> > *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*
>>>> > * 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]*
>>>> > * 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]*
>>>> > * 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]*
>>>> > * 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]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * 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]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * 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]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * 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]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * 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]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * 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]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * 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]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * 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]*
>>>> > * 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]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * 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]*
>>>> > * 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]*
>>>> > * at
>>>> >
>>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>>>> > [rt.jar:1.7.0_67]*
>>>> > * at
>>>> >
>>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>>>> > [rt.jar:1.7.0_67]*
>>>> > * at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_67]*
>>>> > * at org.jboss.threads.JBossThread.run(JBossThread.java:122)*
>>>> > *Caused by: javax.persistence.PersistenceException:
>>>> > org.hibernate.exception.SQLGrammarException: could not extract
>>>> ResultSet*
>>>> > * at
>>>> >
>>>> org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
>>>> >
>>>> [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
>>>> > * at
>>>> >
>>>> org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
>>>> >
>>>> [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
>>>> > * at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:277)
>>>> >
>>>> [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
>>>> > * at
>>>> >
>>>> org.jboss.aerogear.unifiedpush.jpa.dao.impl.JPAInstallationDao.getSingleResultForQuery(JPAInstallationDao.java:199)
>>>> > [unifiedpush-model-jpa-1.1.0-SNAPSHOT.jar:]*
>>>> > * at
>>>> >
>>>> org.jboss.aerogear.unifiedpush.jpa.dao.impl.JPAInstallationDao.findInstallationForVariantByDeviceToken(JPAInstallationDao.java:72)
>>>> > [unifiedpush-model-jpa-1.1.0-SNAPSHOT.jar:]*
>>>> > * at
>>>> >
>>>> org.jboss.aerogear.unifiedpush.service.impl.ClientInstallationServiceImpl.findInstallationForVariantByDeviceToken(ClientInstallationServiceImpl.java:177)
>>>> > [unifiedpush-service-1.1.0-SNAPSHOT.jar:]*
>>>> > * at
>>>> >
>>>> org.jboss.aerogear.unifiedpush.service.impl.ClientInstallationServiceImpl.addInstallation(ClientInstallationServiceImpl.java:51)
>>>> > [unifiedpush-service-1.1.0-SNAPSHOT.jar:]*
>>>> > * at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>> > [rt.jar:1.7.0_67]*
>>>> > * at
>>>> >
>>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>>>> > [rt.jar:1.7.0_67]*
>>>> > * at
>>>> >
>>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>>> > [rt.jar:1.7.0_67]*
>>>> > * at java.lang.reflect.Method.invoke(Method.java:606)
>>>> [rt.jar:1.7.0_67]*
>>>> > * 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]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * 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]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * 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]*
>>>> > * 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]*
>>>> > * 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]*
>>>> > * 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]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * 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]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * 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]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * 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]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * 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]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * 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]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * 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]*
>>>> > * at
>>>> >
>>>> org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
>>>> > [jboss-invocation-1.1.2.Final-redhat-1.jar:1.1.2.Final-redhat-1]*
>>>> > * 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]*
>>>> > * ... 25 more*
>>>> > *Caused by: org.hibernate.exception.SQLGrammarException: could not
>>>> extract
>>>> > ResultSet*
>>>> > * 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]*
>>>> > * 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]*
>>>> > * 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]*
>>>> > * 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]*
>>>> > * 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]*
>>>> > * at org.hibernate.loader.Loader.getResultSet(Loader.java:2062)
>>>> > [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
>>>> > * at
>>>> org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1859)
>>>> > [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
>>>> > * at
>>>> org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)
>>>> > [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
>>>> > * at org.hibernate.loader.Loader.doQuery(Loader.java:906)
>>>> > [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
>>>> > * at
>>>> >
>>>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348)
>>>> > [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
>>>> > * at org.hibernate.loader.Loader.doList(Loader.java:2550)
>>>> > [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
>>>> > * at org.hibernate.loader.Loader.doList(Loader.java:2536)
>>>> > [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
>>>> > * at
>>>> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2366)
>>>> > [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
>>>> > * at org.hibernate.loader.Loader.list(Loader.java:2361)
>>>> > [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
>>>> > * 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]*
>>>> > * 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]*
>>>> > * 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]*
>>>> > * at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1194)
>>>> > [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
>>>> > * at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
>>>> > [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
>>>> > * at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:268)
>>>> >
>>>> [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
>>>> > * ... 60 more*
>>>> > *Caused by: java.sql.SQLSyntaxErrorException: ORA-00997: illegal use
>>>> of
>>>> > LONG datatype*
>>>> >
>>>> > * at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)*
>>>> > * at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)*
>>>> > * at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)*
>>>> > * at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)*
>>>> > * at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)*
>>>> > * at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)*
>>>> > * at
>>>> >
>>>> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)*
>>>> > * at
>>>> >
>>>> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)*
>>>> > * at
>>>> >
>>>> oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)*
>>>> > * at
>>>> >
>>>> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)*
>>>> > * at
>>>> >
>>>> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)*
>>>> > * at
>>>> >
>>>> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)*
>>>> > * at
>>>> >
>>>> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)*
>>>> > * at
>>>> >
>>>> oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)*
>>>> > * at
>>>> >
>>>> org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)*
>>>> > * 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]*
>>>> > * ... 75 more*
>>>> >
>>>> > 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.
>>>> >
>>>> > Can you help me with this problem? Thanks.
>>>> > _______________________________________________
>>>> > aerogear-dev mailing list
>>>> > aerogear-dev at lists.jboss.org
>>>> > https://lists.jboss.org/mailman/listinfo/aerogear-dev
>>>>
>>>>
>>>> _______________________________________________
>>>> aerogear-dev mailing list
>>>> aerogear-dev at lists.jboss.org
>>>> https://lists.jboss.org/mailman/listinfo/aerogear-dev
>>>>
>>>
>>>
>>
>> --
>> Sent from Gmail Mobile
>>
>> _______________________________________________
>> aerogear-dev mailing list
>> aerogear-dev at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/aerogear-dev
>>
>
>
> _______________________________________________
> aerogear-dev mailing list
> aerogear-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/aerogear-dev
>

-- 
Matthias Wessendorf

blog: http://matthiaswessendorf.wordpress.com/
sessions: http://www.slideshare.net/mwessendorf
twitter: http://twitter.com/mwessendorf
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/aerogear-dev/attachments/20141202/d82f8f5f/attachment-0001.html 