Seem to be running into 10 parameter limit with JDBC

Hi,

I updated to the latest source and seem to be hitting a limit of 10 JDBC parameters - The query itself is simple (say select f1,f2 from tableName where f3 in (?,?,?,?,?,?,?,?,?,?) -

Looks like the issue referred to here: http://forums.enterprisedb.com/posts/list/1375.page

Here is the exception on the client side:

Exception in the Coordinator console.log:

2010-05-20 21:51:14,008 - ERROR Catching throwable:
com.edb.gridsql.exception.XDBServerException: Node 1 has aborted execution, cause is: java.sql.SQLException : ERROR: syntax error at or near "0"
  Position: 175
QUERY: SELECT "mydim"."dimval" as "dimval" FROM "mydim"  WHERE "mydim"."dimval" IN  ( 'dim2' , 'dim3'  , 'dim1'  , 'dim2'  , 'dim3'  , 'dim4'  , 'dim3'  , 'dim3'  , 'dim3'  , 'dim2'0  ) LIMIT 4
        at com.edb.gridsql.queryproc.QueryProcessor.executeQueryStep(QueryProcessor.java:538)
        at com.edb.gridsql.queryproc.QueryProcessor.executeQueryExecPlan(QueryProcessor.java:190)
        at com.edb.gridsql.queryproc.QueryProcessor.execute(QueryProcessor.java:1071)
        at com.edb.gridsql.parser.SqlSelect.execute(SqlSelect.java:438)
        at com.edb.gridsql.engine.ExecutableRequest.execute(ExecutableRequest.java:244)
        at com.edb.gridsql.engine.XDBSessionContext.executeRequest(XDBSessionContext.java:1037)
        at com.edb.gridsql.engine.ServerStatement.execute(ServerStatement.java:201)
        at com.edb.gridsql.engine.ServerStatement.describe(ServerStatement.java:145)
        at com.edb.gridsql.engine.XDBSessionContext.describeStatement(XDBSessionContext.java:914)
        at com.edb.gridsql.protocol.PgProtocolSession.run(PgProtocolSession.java:659)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:637)
Caused by: com.edb.gridsql.exception.XDBMessageMonitorException: Node 1 has aborted execution, cause is: java.sql.SQLException : ERROR: syntax error at or near "0"
  Position: 175
        at com.edb.gridsql.engine.MessageMonitor.checkMessages(MessageMonitor.java:245)
        at com.edb.gridsql.engine.MultinodeExecutor.executeStep(MultinodeExecutor.java:931)
        at com.edb.gridsql.queryproc.QueryProcessor.executeQueryStep(QueryProcessor.java:533)
        ... 12 more
Caused by: com.edb.gridsql.exception.XDBWrappedSQLException: java.sql.SQLException : ERROR: syntax error at or near "0"
  Position: 175
        at com.edb.gridsql.engine.NodeThread.handleSqlException(NodeThread.java:1829)
        at com.edb.gridsql.engine.NodeProducerThread.processStep(NodeProducerThread.java:617)
        at com.edb.gridsql.engine.NodeProducerThread.run(NodeProducerThread.java:297)
        ... 1 more
2010-05-20 21:51:14,035 - ERROR Throwing throwable:
com.edb.gridsql.exception.XDBServerException: Node 1 has aborted execution, cause is: java.sql.SQLException : ERROR: syntax error at or near "0"
com.edb.gridsql.exception.XDBServerException: Node 1 has aborted execution, cause is: java.sql.SQLException : ERROR: syntax error at or near "0"
  Position: 175
QUERY: SELECT "mydim"."dimval" as "dimval" FROM "mydim"  WHERE "mydim"."dimval" IN  ( 'dim2' , 'dim3'  , 'dim1'  , 'dim2'  , 'dim3'  , 'dim4'  , 'dim3'  , 'dim3'  , 'dim3'  , 'dim2'0  ) LIMIT 4
        at com.edb.gridsql.queryproc.QueryProcessor.executeQueryStep(QueryProcessor.java:538)
        at com.edb.gridsql.queryproc.QueryProcessor.executeQueryExecPlan(QueryProcessor.java:190)
        at com.edb.gridsql.queryproc.QueryProcessor.execute(QueryProcessor.java:1071)
        at com.edb.gridsql.parser.SqlSelect.execute(SqlSelect.java:438)
        at com.edb.gridsql.engine.ExecutableRequest.execute(ExecutableRequest.java:244)
        at com.edb.gridsql.engine.XDBSessionContext.executeRequest(XDBSessionContext.java:1037)
        at com.edb.gridsql.engine.ServerStatement.execute(ServerStatement.java:201)
        at com.edb.gridsql.engine.ServerStatement.describe(ServerStatement.java:145)
        at com.edb.gridsql.engine.XDBSessionContext.describeStatement(XDBSessionContext.java:914)
        at com.edb.gridsql.protocol.PgProtocolSession.run(PgProtocolSession.java:659)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:637)
Caused by: com.edb.gridsql.exception.XDBMessageMonitorException: Node 1 has aborted execution, cause is: java.sql.SQLException : ERROR: syntax error at or near "0"
  Position: 175
        at com.edb.gridsql.engine.MessageMonitor.checkMessages(MessageMonitor.java:245)
        at com.edb.gridsql.engine.MultinodeExecutor.executeStep(MultinodeExecutor.java:931)
        at com.edb.gridsql.queryproc.QueryProcessor.executeQueryStep(QueryProcessor.java:533)
        ... 12 more
Caused by: com.edb.gridsql.exception.XDBWrappedSQLException: java.sql.SQLException : ERROR: syntax error at or near "0"
  Position: 175
        at com.edb.gridsql.engine.NodeThread.handleSqlException(NodeThread.java:1829)
        at com.edb.gridsql.engine.NodeProducerThread.processStep(NodeProducerThread.java:617)
        at com.edb.gridsql.engine.NodeProducerThread.run(NodeProducerThread.java:297)
        ... 1 more
2010-05-20 21:51:14,036 - ERROR Catching throwable:
com.edb.gridsql.exception.XDBServerException: Node 1 has aborted execution, cause is: java.sql.SQLException : ERROR: syntax error at or near "0"
  Position: 175
QUERY: SELECT "mydim"."dimval" as "dimval" FROM "mydim"  WHERE "mydim"."dimval" IN  ( 'dim2' , 'dim3'  , 'dim1'  , 'dim2'  , 'dim3'  , 'dim4'  , 'dim3'  , 'dim3'  , 'dim3'  , 'dim2'0  ) LIMIT 4
        at com.edb.gridsql.queryproc.QueryProcessor.executeQueryStep(QueryProcessor.java:538)
        at com.edb.gridsql.queryproc.QueryProcessor.executeQueryExecPlan(QueryProcessor.java:190)
        at com.edb.gridsql.queryproc.QueryProcessor.execute(QueryProcessor.java:1071)
        at com.edb.gridsql.parser.SqlSelect.execute(SqlSelect.java:438)
        at com.edb.gridsql.engine.ExecutableRequest.execute(ExecutableRequest.java:244)
        at com.edb.gridsql.engine.XDBSessionContext.executeRequest(XDBSessionContext.java:1037)
        at com.edb.gridsql.engine.ServerStatement.execute(ServerStatement.java:201)
        at com.edb.gridsql.engine.ServerStatement.describe(ServerStatement.java:145)
        at com.edb.gridsql.engine.XDBSessionContext.describeStatement(XDBSessionContext.java:914)
        at com.edb.gridsql.protocol.PgProtocolSession.run(PgProtocolSession.java:659)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        at java.lang.Thread.run(Thread.java:637)
Caused by: com.edb.gridsql.exception.XDBMessageMonitorException: Node 1 has aborted execution, cause is: java.sql.SQLException : ERROR: syntax error at or near "0"
  Position: 175
        at com.edb.gridsql.engine.MessageMonitor.checkMessages(MessageMonitor.java:245)
        at com.edb.gridsql.engine.MultinodeExecutor.executeStep(MultinodeExecutor.java:931)
        at com.edb.gridsql.queryproc.QueryProcessor.executeQueryStep(QueryProcessor.java:533)
        ... 12 more
Caused by: com.edb.gridsql.exception.XDBWrappedSQLException: java.sql.SQLException : ERROR: syntax error at or near "0"
  Position: 175
        at com.edb.gridsql.engine.NodeThread.handleSqlException(NodeThread.java:1829)
        at com.edb.gridsql.engine.NodeProducerThread.processStep(NodeProducerThread.java:617)
        at com.edb.gridsql.engine.NodeProducerThread.run(NodeProducerThread.java:297)
        ... 1 more

Table Script:

Jdbc Code:

I updated to the latest version from the source tree and tested. This issue is fixed.

Thanks,

Ranga