File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

java.sql.SQLException: Non supported SQL92 token at position: 377:

 
sachin kataria
Ranch Hand
Posts: 45
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,
i have to create oracle-java source from java program. my code is :

( In Java which create java source in oracle)

strQuery = "CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED
\"ASCOMPONENT\" AS ";
strQuery += "import javax.xml.parsers.DocumentBuilderFactory; ";
strQuery += "import javax.xml.parsers.DocumentBuilder; ";
strQuery += "import org.xml.sax.SAXException; ";
strQuery += "import org.xml.sax.SAXParseException; ";
strQuery += "import org.w3c.dom.Document; ";
strQuery += "import org.w3c.dom.*; ";
strQuery += "import java.io.*; ";
strQuery += "import oracle.jdbc.driver.*; ";
strQuery += "import java.sql.*; ";
strQuery += "public class ASComponent ";
strQuery += "\n ";
strQuery += "{ "; // error here.../
strQuery += "\n ";
strQuery += "public static void readXML(String strXML,String
strTable) ";
strQuery += "\n ";
strQuery += "{ ";
strQuery += "\n ";
strQuery += " } ";
strQuery += "\n ";
strQuery += " } ";
strQuery += "\n ";


System.out.println("Query = " + strQuery[i]);

stmt.executeQuery(strQuery);

i am getting error :

java.sql.SQLException: Non supported SQL92 token at position: 377:

so, what is that error ?
i think when it is getting '{ ' it is giving error...?
how we can use token '{}' in jdbc.

so, what is the error..?
please help me its urgent..

Thanks in advance...
 
bart zagers
Ranch Hand
Posts: 234
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Just a guess, is '\n' just above the problem allowed and recognised?
Why do you start using them on that line? You put all the import statements after each other and then start formatting with newlines?
 
sachin kataria
Ranch Hand
Posts: 45
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i also remove '\n' but same error....
 
B.J. Reed
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, was a fix or workaround ever found for this problem? I am having the same problem with the { when I try the same kind of thing.
 
Martijn Verburg
author
Bartender
Posts: 3275
5
Eclipse IDE Java Mac OS X
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi B.J and welcome to Javaranch!

We try not to wake up old threads here, can you post your specific problem as a new thread please?

Thanks
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic