AnsweredAssumed Answered

Can't get JDBC connection to a database which name has space

Question asked by lihongyang on Jul 28, 2010

Title

Can't get JDBC connection to a database which name has space

Post

Hi,

I can get a JDBC connection to a database whose name does not have space, e.g., test_DB,

Connection con = DriverManager.getConnection("jdbc:filemaker://localhost/test_DB", "user", "password");

it works fine.

But when I try to get a JDBC connection to a database whose name does have space, e.g, test DB,

Connection con = DriverManager.getConnection("jdbc:filemaker://localhost/test DB", "user", "password");

The java program just hang. It does not return any error code or exception. And when I check the filemaker server, fmxdbc_listener was using 98% of the CPU. Unless restart server or the JDBC listener of the server, I can't get any other connection to the filemaker database.

In the previous versions of Filemaker ODBC/JDBC manual, they mentioned you should use escaped character %20 for space in the database name, but this is not mentioned in Filemaker11 ODBC/JDBC manual. I tried it anyway,

Connection con = DriverManager.getConnection("jdbc:filemaker://localhost/test%20DB", "user", "password");

The java program still hangs. fmxdbc_listener still goes crazy on the server.

Can anyone please let me know what should I do to access a database whose name has space?

thanks,

yang

Outcomes