JDBC issue when querying columns with space in its name
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.