Hi, I'm trying to get the news-example that comes with orion to work on a linux machine using IBM DB2 (v7.1, Fixpack 4) as a data-source.
Deploying & auto-creating tables work just fine, but invoking the application in a brwoser with "http://myhost:8080/news/"; results in following exception: com.evermind[Orion/1.5.2 (build 10460)].server.rmi.OrionRemoteException: Database error: [IBM][CLI Driver][DB2/LINUX] SQL0418N A statement contains a use of a parameter marker that is not valid. SQLSTATE=42610 at NewsItemHome_EntityHomeWrapper4.findByParent(NewsItemHome_EntityHomeWrapper4.java:1626) at com.evermind[Orion/1.5.2 (build 10460)].ejb.NewsSessionEJB.getChildren(NewsSessionEJB.java:44) at NewsSession_StatefulSessionBeanWrapper1.getChildren(NewsSession_StatefulSessionBeanWrapper1.java:66) at /news.jsp._jspService(/news.jsp.java:104) (JSP page line 25) at com.orionserver[Orion/1.5.2 (build 10460)].http.OrionHttpJspPage.service(Unknown Source) at com.evermind[Orion/1.5.2 (build 10460)]._ah._rad(Unknown Source) at com.evermind[Orion/1.5.2 (build 10460)].server.http.JSPServlet.service(Unknown Source) at com.evermind[Orion/1.5.2 (build 10460)]._cxb._abe(Unknown Source) at com.evermind[Orion/1.5.2 (build 10460)]._cxb._uec(Unknown Source) at com.evermind[Orion/1.5.2 (build 10460)]._io._twc(Unknown Source) at com.evermind[Orion/1.5.2 (build 10460)]._io._gc(Unknown Source) at com.evermind[Orion/1.5.2 (build 10460)]._if.run(Unknown Source) Nested exception is:COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0418N A statement contains a use of a parameter marker that is not valid. SQLSTATE=42610 at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:269) at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:206) at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:457) at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(DB2PreparedStatement.java:1369) at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeQuery(DB2PreparedStatement.java:880) at com.evermind[Orion/1.5.2 (build 10460)]._lm.executeQuery(Unknown Source) at com.evermind[Orion/1.5.2 (build 10460)]._lm.executeQuery(Unknown Source) at NewsItemHome_EntityHomeWrapper4.findByParent(NewsItemHome_EntityHomeWrapper4.java:1474) at com.evermind[Orion/1.5.2 (build 10460)].ejb.NewsSessionEJB.getChildren(NewsSessionEJB.java:44) at NewsSession_StatefulSessionBeanWrapper1.getChildren(NewsSession_StatefulSessionBeanWrapper1.java:66) at /news.jsp._jspService(/news.jsp.java:104) (JSP page line 25) at com.orionserver[Orion/1.5.2 (build 10460)].http.OrionHttpJspPage.service(Unknown Source) at com.evermind[Orion/1.5.2 (build 10460)]._ah._rad(Unknown Source) at com.evermind[Orion/1.5.2 (build 10460)].server.http.JSPServlet.service(Unknown Source) at com.evermind[Orion/1.5.2 (build 10460)]._cxb._abe(Unknown Source) at com.evermind[Orion/1.5.2 (build 10460)]._cxb._uec(Unknown Source) at com.evermind[Orion/1.5.2 (build 10460)]._io._twc(Unknown Source) at com.evermind[Orion/1.5.2 (build 10460)]._io._gc(Unknown Source) at com.evermind[Orion/1.5.2 (build 10460)]._if.run(Unknown Source) I have seen the sql-statement that is executed, and it contains a "?"-symbol. Obviously this is a variable in a prepared statement or something, wich is not correctly replaced by the IBM JDBC-Driver. (Thats what I assume) Has anyone experience in setting up orion and DB2? Are there other JDBC-driver than IBM's? Thanks, Sven Lüdtke
