Skip to Content.
Sympa Menu

freetds - [freetds] FreeTDS & PreparedStatements

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Bhagya Prasad" <bhprasad AT gmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] FreeTDS & PreparedStatements
  • Date: Thu, 26 Jul 2007 14:35:38 -0700

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




Archive powered by MHonArc 2.6.24.

Top of Page