Results 1 to 2 of 2
  1. #1
    ron2794 is offline Member
    Join Date
    Dec 2010
    Posts
    38
    Rep Power
    0

    Default lexical error in javadb

    i through mysqldump loaded all my create definition in a sql file now i am copying the data from that sql file into the netbeans sql editor while working on java db , the following error is coming :

    Error code -1, SQL state 42X02: Lexical error at line 1, column 14. Encountered: "`" (96), after : "".

    why this is coming even when the same script is running succesfully in mysql.

  2. #2
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    10

    Default

    Because MySQL'y SQL syntax is seemingly slightly different from JavaDBs, which isn't surprising since JavaDB is completely SQL 92/98 conformant and MySQL is not.

Similar Threads

  1. Help setting up JavaDB
    By java_beginner in forum JDBC
    Replies: 1
    Last Post: 05-08-2010, 08:34 AM
  2. Lexical error at line 1, column 32.
    By javamula in forum AWT / Swing
    Replies: 4
    Last Post: 10-05-2009, 10:12 AM
  3. JavaDB Help
    By Sysem in forum New To Java
    Replies: 5
    Last Post: 05-29-2008, 09:21 PM
  4. JavaDB Installation
    By PhilArmstrong in forum New To Java
    Replies: 6
    Last Post: 05-13-2008, 02:09 PM
  5. Help with Lexical units, use hashmap
    By zoe in forum Advanced Java
    Replies: 1
    Last Post: 08-07-2007, 06:14 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •