Help with SQLException from jsp

[Guest_imported]

Hi, friends,
I am using JRun3.0 Web and App servers to run my jsp pages. I have also developed JavaBean classes talking to MSSQL database. The bean successfully updated my table in the database when i tested independently, however, when I use the bean class in my jsp to update my table in MSSQL database, I got an error: .SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 's'.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:4089)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:4246)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:1172)
......
Please help !
Thanks

 

[Guest_imported]

I feel there is some proble with the SQL. Some minor mistakes like extra spaces some times create problem when accessing thru JDBC, Just try to paste the query that you have been passing or the bean itself.
So that i can come out with the answer

Regards,
Rip Van Winkle