[aerogear-dev] use oracle database

[Ivan Gürtler]

I have database with user unifiedpush (same as for wildfly) ... and
use  jboss-cli.sh
--file=/path/to/ocracle-database-config.cli .... depoly 2 war files ... and
start server
Yes I do let hibernate create the schema.

*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 8:27 GMT+01:00 Erik Jan de Wit <edewit at redhat.com>:

>
>
> 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
>
>
> How did you configure the database? Do you let hibernate create the
> schema? Because LONG is not a type that can be queried in a easy way. A
> java.lang.Long should be mapped to a NUMBER(19)
>
>
> *Caused by: java.sql.SQLSyntaxErrorException: ORA-00997: illegal use of
> LONG datatype*
>
> * at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)*
> * at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)*
> * at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)*
> * at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)*
> * at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)*
> * at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)*
> * at
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)*
> * at
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)*
> * at
> oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)*
> * at
> oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)*
> * at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)*
> * at
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)*
> * at
> oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)*
> * at
> oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)*
> * at
> org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)*
> * at
> org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)
> [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]*
> * ... 75 more*
>
> I use same ojdbc6-12.1.0.1.jar and same database with wildfly and EAP ...
> I tried to fix it for a 3 days, but I haven't found solution.
>
> Can you help me with this problem? Thanks.
>  _______________________________________________
> aerogear-dev mailing list
> aerogear-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/aerogear-dev
>
>
>
> _______________________________________________
> aerogear-dev mailing list
> aerogear-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/aerogear-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/aerogear-dev/attachments/20141127/5a44712e/attachment-0001.html