Ok, I filed this ticket:

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

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

-Matthias

On Tue, Dec 2, 2014 at 9:35 AM, Ivan Gürtler <ivan.gurtler@ahead-itec.com> wrote:
We used VARCHAR2 ... but max value is lower than 4K ... 

yes ... the reason for LONG is large size ...  and LONG in oracle have much problems ... e.g. it is imposible use LONG in "where" -> exception

Mgr. Ivan Gürtler
Mobile software developer

AHEAD iTec, s.r.o., Botanická 554/68a,
602 00 Brno (Czech Republic)

www.ahead-itec.com | twitter | mobile security solutions

2014-12-01 20:49 GMT+01:00 Matthias Wessendorf <matzew@apache.org>:


On Monday, December 1, 2014, Ivan Gürtler <ivan.gurtler@ahead-itec.com> wrote:
Problem is with Instalation Table ... object Instalation have "String deviceToken..." and in database it is LONG ... 

weird, because type is string.
Is hibernate getting that mapping wrong?

 
when we try add Instalation to Aerogear ... it threw exception ... when we hardly changed in database LONG to VARCHAR(255) it is ok ... 

you want it a bit larger:

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 | mobile security solutions

2014-11-27 13:52 GMT+01:00 Karel Piwko <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@lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/aerogear-dev


_______________________________________________
aerogear-dev mailing list
aerogear-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/aerogear-dev



--
Sent from Gmail Mobile

_______________________________________________
aerogear-dev mailing list
aerogear-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/aerogear-dev


_______________________________________________
aerogear-dev mailing list
aerogear-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/aerogear-dev



--
Matthias Wessendorf

blog: http://matthiaswessendorf.wordpress.com/
sessions: http://www.slideshare.net/mwessendorf
twitter: http://twitter.com/mwessendorf