<div dir="ltr">I have database with user unifiedpush (same as for wildfly) ... and use <span style="color:rgb(0,0,0);font-family:monospace,serif;font-size:11px;line-height:15.6800003051758px;white-space:pre;background-color:rgb(240,240,240)">jboss-cli.sh --f</span><span style="color:rgb(0,0,0);font-family:monospace,serif;font-size:11px;line-height:15.6800003051758px;white-space:pre;background-color:rgb(240,240,240)">ile=/path/to/ocracle-database-config.cli </span>.... depoly 2 war files ... and start server<div>Yes I do let hibernate create the schema.</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div><span style="color:rgb(7,55,99)"><b>Mgr. Ivan Gürtler</b></span><br></div><span style="color:rgb(102,102,102)">Mobile software developer</span><br><br>AHEAD iTec, s.r.o., Botanická 554/68a,<br>602 00 Brno (Czech Republic)<br><br><a href="http://www.ahead-itec.com/" style="color:rgb(17,85,204)" target="_blank">www.ahead-itec.com</a> | <a href="https://www.twitter.com/AHEADiTec" style="color:rgb(17,85,204)" target="_blank">twitter</a> | mobile security solutions<br></div></div></div>
<br><div class="gmail_quote">2014-11-27 8:27 GMT+01:00 Erik Jan de Wit <span dir="ltr"><<a href="mailto:edewit@redhat.com" target="_blank">edewit@redhat.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div><span class=""><br><blockquote type="cite"><div dir="ltr"><div><br></div><div>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 </div></div></blockquote><div><br></div></span><div>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 <span style="color:rgb(85,85,85);font-family:Monaco,Courier,'Courier New',monospace">NUMBER(19) </span></div><br><blockquote type="cite"><span class=""><div dir="ltr"><div><br></div><div><div><i><font color="#0000ff">Caused by: java.sql.SQLSyntaxErrorException: ORA-00997: illegal use of LONG datatype</font></i></div><div><i><font color="#0000ff"><br></font></i></div><div><i><font color="#0000ff"><span style="white-space:pre-wrap"> </span>at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)</font></i></div><div><i><font color="#0000ff"><span style="white-space:pre-wrap"> </span>at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)</font></i></div><div><i><font color="#0000ff"><span style="white-space:pre-wrap"> </span>at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)</font></i></div><div><i><font color="#0000ff"><span style="white-space:pre-wrap"> </span>at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)</font></i></div><div><i><font color="#0000ff"><span style="white-space:pre-wrap"> </span>at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)</font></i></div><div><i><font color="#0000ff"><span style="white-space:pre-wrap"> </span>at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)</font></i></div><div><i><font color="#0000ff"><span style="white-space:pre-wrap"> </span>at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)</font></i></div><div><i><font color="#0000ff"><span style="white-space:pre-wrap"> </span>at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)</font></i></div><div><i><font color="#0000ff"><span style="white-space:pre-wrap"> </span>at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)</font></i></div><div><i><font color="#0000ff"><span style="white-space:pre-wrap"> </span>at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)</font></i></div><div><i><font color="#0000ff"><span style="white-space:pre-wrap"> </span>at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)</font></i></div><div><i><font color="#0000ff"><span style="white-space:pre-wrap"> </span>at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)</font></i></div><div><i><font color="#0000ff"><span style="white-space:pre-wrap"> </span>at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)</font></i></div><div><i><font color="#0000ff"><span style="white-space:pre-wrap"> </span>at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)</font></i></div><div><i><font color="#0000ff"><span style="white-space:pre-wrap"> </span>at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)</font></i></div><div><i><font color="#0000ff"><span style="white-space:pre-wrap"> </span>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]</font></i></div><div><i><font color="#0000ff"><span style="white-space:pre-wrap"> </span>... 75 more</font></i></div></div><div><br></div><div>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.</div><div><br></div><div><span style="font-family:arial,sans-serif;font-size:13px">Can you help me with this problem? Thanks.</span><br></div>
</div></span>
_______________________________________________<br>aerogear-dev mailing list<br><a href="mailto:aerogear-dev@lists.jboss.org" target="_blank">aerogear-dev@lists.jboss.org</a><br><a href="https://lists.jboss.org/mailman/listinfo/aerogear-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/aerogear-dev</a></blockquote></div><br></div><br>_______________________________________________<br>
aerogear-dev mailing list<br>
<a href="mailto:aerogear-dev@lists.jboss.org">aerogear-dev@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/aerogear-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/aerogear-dev</a><br></blockquote></div><br></div>