Re: [aerogear-dev] use oracle database

On Monday, December 1, 2014, Ivan Gürtler <ivan.gurtler(a)ahead-itec.com&gt; 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... 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(a)redhat.com&gt;: > >> 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 >> > https://lists.jboss.org/mailman/listinfo/aerogear-dev >> >> >> _______________________________________________ >> aerogear-dev mailing list >> aerogear-dev(a)lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/aerogear-dev >> > > -- Sent from Gmail Mobile _______________________________________________ aerogear-dev mailing list aerogear-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/aerogear-dev