[freetds] FreeTDS & PreparedStatements

Bhagya Prasad bhprasad at gmail.com
Thu Jul 26 17:35:38 EDT 2007


Hi
I have a sample application which queries MSSQL Server 2005 on CentOS
using FreeTDS driver.  The application has 2 SQL statements;

sql1= select * from table_one
sql2 = select * from table_two.

When I use PreparedStatement and call executeQuery(), the first SQL
succeeds and the second SQL fails in the stage of PreparingStatement.

However, when I use createStatement and call executeQuery(stmt,sql) it
works fine!

I tested the same with PostgreSQL database with Postgres driver and it
works great with no issues.  I am seeing this only from FreeTDS.
Anything I am missing?

BP


More information about the FreeTDS mailing list