[aerogear-dev] use oracle database

Ivan Gürtler ivan.gurtler at ahead-itec.com
Tue Dec 2 04:35:53 EST 2014 

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/aerogear-dev/attachments/20141202/ef18abed/attachment-0001.html

More information about the aerogear-dev mailing list