2

We're using a simple report and after migration to 2.5.0.1 the export to excel button invokes an error: JDBCDataStore::execRetrieveQuery failed with SQLState: 07006 Message: Can't infer the SQL type to use for an instance of org.json.JSONArray. Use setObject() with an explicit Types value to specify the type to use. Basically the export to excel button generates the error only when you filter on a date. So when the startdate and enddate is used, the error occures. I think the date value conflicts with the cell in excel. See the stacktace: org.postgresql.util.PSQLException: Can't infer the SQL type to use for an instance of org.json.JSONArray. Use setObject() with an explicit Types value to specify the type to use. at ar.a(SourceFile:1493) Caused by: Can't infer the SQL type to use for an instance of org.json.JSONArray. Use setObject() with an explicit Types value to specify the type to use. at org.postgresql.jdbc2.AbstractJdbc2Statement.setObject(AbstractJdbc2Statement.java:1772) at org.postgresql.jdbc3g.AbstractJdbc3gStatement.setObject(AbstractJdbc3gStatement.java:37) at org.postgresql.jdbc4.AbstractJdbc4Statement.setObject(AbstractJdbc4Statement.java:46) at org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:169) at org.apache.commons.dbcp.DelegatingPreparedStatement.setObject(DelegatingPreparedStatement.java:169) at ar.a(SourceFile:371) at ar.a(SourceFile:287) at ar.a(SourceFile:164) at ar.a(SourceFile:153) at if.a(SourceFile:52) at fW.a(SourceFile:173) at fW.a(SourceFile:132) at fW.a(SourceFile:85) at lf.a(SourceFile:59) at jk.a(SourceFile:58) at iR.a(SourceFile:207) at ek.a(SourceFile:84) at ek.executeAction(SourceFile:20) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:49) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:418) at hZ.b(SourceFile:156) at com.mendix.core.Core.retrieveOQLDataTable(SourceFile:1222) at iS.a(SourceFile:892) at iS.a(SourceFile:744) at iS.a(SourceFile:90) at iS.a(SourceFile:82) at dM.execute(SourceFile:77) at ja.a(SourceFile:275) at ja.a(SourceFile:210) at ja.processRequest(SourceFile:166) at fp.a(SourceFile:75) at com.mendix.core.MxRuntime.processRequest(SourceFile:882) at com.mendix.m2ee.server.handler.RuntimeHandler.handle(RuntimeHandler.java:38) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) at org.eclipse.jetty.server.Server.handle(Server.java:334) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559) at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1007) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:747) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:209) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:462) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436) at java.lang.Thread.run(Thread.java:619)

asked 2010-09-16

0 answers