[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