0

I have my queries in SQLite DB. I want to run these queries on a different DB reading through Java. I am able to run the same queries on SQL developer manually copying from SQLite.

java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

will come when executed through java program. There is no wrong in program as well as query. Please tell me where I am leaving the track.(It has no semicolons in the end. I have checked it).

k4sia
  • 414
  • 1
  • 6
  • 18
Krishnakanth Jc
  • 183
  • 1
  • 14
  • Do you have a trace of the query being executed from Java? Its probably do to a misquoted string. – Noah Dec 02 '13 at 14:56
  • It was "�" character which was creeping in. finally was able to figure it out. I am now removing via string.replace method. Thanks – Krishnakanth Jc Dec 05 '13 at 13:44

0 Answers0