Results 1 to 2 of 2
  1. 12-16-2010, 09:29 AM #1
    ron2794
    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.
    Reply With Quote Reply With Quote
  2. 12-16-2010, 11:27 AM #2
    masijade
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,366
    Rep Power
    7

    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.
    Reply With Quote Reply With Quote
« Jdbc Prepared Statement execute() | [very noob] toggle next record/previous »

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

Bookmarks

Posting Permissions

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

Forum Rules