Re: [aerogear-dev] use oracle database

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 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(a)redhat.com <javascript:_e(%7B%7D,'cvml','kpiwko@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(a)lists.jboss.org > <javascript:_e(%7B%7D,'cvml','aerogear-dev@lists.jboss.org');> > > https://lists.jboss.org/mailman/listinfo/aerogear-dev > > > _______________________________________________ > aerogear-dev mailing list > aerogear-dev(a)lists.jboss.org > <javascript:_e(%7B%7D,'cvml','aerogear-dev@lists.jboss.org');> > https://lists.jboss.org/mailman/listinfo/aerogear-dev >