File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jtds driver gives following error

 
Vilpesh Mistry
Ranch Hand
Posts: 62
Eclipse IDE Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Vilpesh Mistry
Ranch Hand
Posts: 62
Eclipse IDE Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic