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

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

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

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 >

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(a)apache.org&gt;: > > > 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 > _______________________________________________ aerogear-dev mailing list aerogear-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/aerogear-dev

We find that problem is with hibernate + oracle (not with EAP... becasue we found same problem in wildfly) _______________________________________________ aerogear-dev mailing list aerogear-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/aerogear-dev