| Author |
jtds driver gives following error
|
Vilpesh Mistry
Ranch Hand
Joined: May 27, 2003
Posts: 60
|
|
hi my database is sql server 7.0. Driver used is jtds-0.9.jar from sourceforge.net iam executing a stored procedure. in the log file, following message comes up Invalid JDBC escape syntax at line position 33 '}' character expected 1>what does it mean and what must be done ? 2> is there any site where one can get list of all possible jdbc errors? thanks
|
Thanks.
|
 |
Paul Sturrock
Bartender
Joined: Apr 14, 2004
Posts: 10336
|
|
|
jTDS 0.9 is a fairly stable release, so I'd say its unlikely (though by no means impossible) for this error to be the result of a bug in the Driver. I'd guess its more likely its the result of a syntax error in your Stored Procedure. Does you procedure acually run? Driver's typically only report the messages whichever database they are for throw. Check your issue on the DB first.
|
JavaRanch FAQ HowToAskQuestionsOnJavaRanch
|
 |
Vilpesh Mistry
Ranch Hand
Joined: May 27, 2003
Posts: 60
|
|
Hi, well i was calling a stored procedure like this, removing the blank spaces "{call my_sp(?)}". Actually the procedure my_sp returns a resultset, which was not written while calling the my_sp procedure. We were earlier using JSQLConnect driver on which the stored procedure "{call my_sp(?)}" used to run without any problem. Now when moving to jTDS i faced the problem. So i had to change the calling string to "{? = call my_sp(?)}" and had to register an outputparameter while working with jTDS 0.9. thanks
|
 |
 |
|
|
subject: jtds driver gives following error
|
|
|