1 Reply Latest reply on Nov 26, 2009 6:07 AM by FluffyBear

    JDBC issue when querying columns with space in its name

    whiteb

      Title

      JDBC issue when querying columns with space in its name

      Your post

      Third party's database (FileMaker Server 10) has some column names with space. I am not allowed to changed these names.

       

      When I use jdbc to query the FileMaker database data, I got trouble to query the value of these columns.

       

      For example, using following query:

      SELECT `Serial Number` FROM Inventory

       

      I get error: java.sql.SQLException: [DataDirect][SequeLink JDBC Driver][ODBC Socket][DataDirect][ODBC FileMaker driver][FileMaker]Parse Error in SQL

       

      I have tried  "SELECT [Serial Number] FROM Inventor", I get same error message.

       

      By the way, I am using the JDBC driver coming with the FileMaker 10. It is DataDirect 5.5.

       

      Please advise how to solve this problem.

       

      Thanks in advance for your help.