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

Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X

Connect TWX to Firebird using JDBC driver

ddecesaris
6-Contributor

Connect TWX to Firebird using JDBC driver

I'm trying to connect to a Firebird DB using JDBC connector. I used the JDBC Connector Extension (from Marketplace) to create my template using Jaybird 2.2.11 and I imported it correctly.

Then I created a new Thing based on that template with the following configuration:

  • JDBC Driver Class Name: org.firebirdsql.jdbc
  • JDBC Connection String: jdbc:firebirdsql://[IP:PORT]//D:\...\.FDB
  • connectionValidationString: SELECT * FROM [KNOWN TABLE]
  • Database User Name: [USER]
  • Database Password: [PASSWORD]

If I check the "isConnected" property, the value is false and if I try writing a service (SQL query) I received an error loading tables/columns.

What's wrong with my configuration? What should I try to solve it?

1 REPLY 1

Hello Davide, I would first check the connection string (you have some examples at below link), then I would get the a jar files which contains all dependencies, a full one like jaybird-full-2.1.6.jar.

Firebird connection with java - Stack Overflow

Let me know if this helps.

Top Tags