AnsweredAssumed Answered

JDBC issue when querying columns with space in its name

Question asked by whiteb on Nov 23, 2009
Latest reply on Nov 26, 2009 by FluffyBear

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.

Outcomes