topic Re: Error while accessing the H2 database from a thing service in ThingWorx Developers

Error while accessing the H2 database from a thing service

pbadiger — Wed, 22 Nov 2017 07:32:36 GMT

I am using internal H2 db to host my application data as well. So I have created a database and a table in H2 database from H2 console. When I try to connect to this database and access the table data, I am getting error IO Exception: "java.io.IOException: The filename, directory name, or volume label syntax is incorrect"; "TCP:C:/ThingworxStorage/database/<my_database_name>.mv.db" [90031-192]

Note: I can see that <my_database_name>.mv file is getting created under ThingworxStorage/database

Message was edited by: Pawan Badiger added note

Re: Error while accessing the H2 database from a thing service

supandey — Wed, 22 Nov 2017 09:41:46 GMT

Hi Pawan, just curious any specific reason why you prefer to create custom tables in H2 DB rather than connecting an RDBMS via JDBC driver?

Can you share your connection string?

Re: Error while accessing the H2 database from a thing service

pbadiger — Wed, 22 Nov 2017 11:02:45 GMT

This is because we are currently working on a PoC and are restricted to working with limited resources.

Below are the connection details

JDBC Driver class: org.h2.Driver

jdbc:h2:TCP:C:\ThingworxStorage\database\<my_database_name>

Thank you in advance

Re: Error while accessing the H2 database from a thing service

pbadiger — Wed, 22 Nov 2017 14:01:35 GMT

This is now resolved.

I changed the connection string to use H2 console, I closed all the browser sessions, which included the H2 console session. This closed the open H2 session allowing thingworx to access the H2 db properly and it worked.

Re: Error while accessing the H2 database from a thing service

supandey — Wed, 22 Nov 2017 14:57:16 GMT

thanks for confirming, was still in the process of validating with a local setup.