Passing Table Names in PreparedStatement

[Senthil Kumar]

Hi all,
I was trying to pass a table name in the query dynamically like

query = "select * from ?";
PreparedStatement pstmt = connection.prepareStatement(query);
pstmt.setString(1,"table1");

It Throws an Exception
"Exception in thread "main" com.sybase.jdbc3.jdbc.SybSQLException: ASA Error -141: Table '@p0' not found"

Is there a way to pass the table name dynamically?
Thanks in Advance

[Prem Shankar]

Senthil,
We cannot pass tables as bind variable using prepared statement..
Instead form the query string dynamically.
eg: query="select * from "+var1;

[Anubhav Anand]

Well we can't pass the tablename directly to prepared statements.

But, if you want to use stored procedures then you can pass table name dynamically using Dynamic SQL.

For further reading of Dynamic SQL refer this article on Dynamic SQL.