cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Error while accessing the H2 database from a thing service

SOLVED
Highlighted
Newbie

Error while accessing the H2 database from a thing service

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

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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

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.

View solution in original post

4 REPLIES 4
Highlighted

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

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?

Highlighted

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

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

Highlighted

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

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.

View solution in original post

Highlighted

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

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

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum!