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

2014-11-27 8:27 GMT+01:00 Erik Jan de Wit <edewit@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@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