Hii all,
I am using jconn2.jar(5.5)
jdbc driver for Sybase to connect
to a sybase database from a standalone
java application.
My jave application will read thousands of
records from a text file and insert in to the table in the
sybase database.
I have a select query with IN clause.This IN clause will have more than 10,000 values. while executing this query, the
application is returning the below error:
Caused by: com.sybase.jdbc2.jdbc.SybSQLException: Too many
parameters -- symbol table overflow.
at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:3281)
at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2548)
at
com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
at
com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
at
com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
at
com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1614)
at
com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1599)
at
com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:96)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at
org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
... 10 more
The same query is working well for values in IN clause with
up to 10,000 values.
I tried with jconnect6 and jconnect7. but same result.
Anyone is having any idea, why it's
returning the error like above for the values having more
than 10,000?
Thanks in advance