sudhir1978
07-23-03, 01:29
| My prepared Statement is SELECT dbo.EXTRACT.PRAD_ID,dbo.EXTRACT.PRCP_ID FROM dbo.EXTRACT where dbo.EXTRACT.PRAD_ID IN ? The assignment of the '?' is as follows: String test = "(\"850327237026\" , \"234567897612\")"; getPCpreparedstatementIn().getPs1().setString(1,te st); getPCpreparedstatementIn().getPs1().executeQuery() ; The Execution fails with a syntax error: Session.checkConnection(): Check connection status Session.checkConnection(): Sybase SQL State: 42000 Session.checkConnection(): Connection is UP ****** Exceptionjava.sql.SQLException: [Sybase JDBC Driver][Sybase]Incorrect syntax near '@p1'. |