Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X
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
Solved! Go to Solution.
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.
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?
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
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.
thanks for confirming, was still in the process of validating with a local setup.