Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2012
    Location
    Queensland, Australia
    Posts
    12
    Rep Power
    0

    Default MalFormed DataBase Schema

    Hi All,

    I have created an android application that creates an sqllite database.

    The applications purpose is to collect data from of field crops in which are organised into rows and columns.

    Their are consequently columns within a sqlite database table named 'COLUMN' and 'ROW'. The android application allows
    these columns to be created with these names.

    When a take this database load it onto a computer and use the SqlLiteJDBC Driver to connect and bind the table with these columns
    to a JTable I get the following error.

    java.sql.SQLException: malformed database schema (TrialFiles) - near "Column": syntax error


    My question is: Has anybody come across this situation before and how did you get around it. I do not really want to change the android application unless absolutely necessary.

    Thanks in advance

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,953
    Rep Power
    19

    Default Re: MalFormed DataBase Schema

    WHat does your SQL look like?
    Normally, if you'd made the mistake of naming your columns after SQL keywords, you'd stick them in quotes.
    Please do not ask for code as refusal often offends.

    ** This space for rent **

  3. #3
    Join Date
    Feb 2012
    Location
    Queensland, Australia
    Posts
    12
    Rep Power
    0

    Default Re: MalFormed DataBase Schema

    Thanks for that.

    Upon rechecking the sql it appears that I did not include escape the fieldnames in the statement with backticks.

    Regards

Similar Threads

  1. Choking on malformed args?
    By blackbird in forum Networking
    Replies: 14
    Last Post: 07-19-2011, 09:14 PM
  2. PDFBox certificate malformed
    By wanderer2019 in forum Advanced Java
    Replies: 0
    Last Post: 06-09-2010, 10:29 AM
  3. Replies: 26
    Last Post: 02-25-2010, 11:56 AM
  4. Replies: 0
    Last Post: 12-01-2009, 10:01 PM
  5. problem with getting alll schema names from database
    By sandeepsai17 in forum New To Java
    Replies: 1
    Last Post: 07-21-2009, 12:38 PM

Posting Permissions

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