Connecting to Firebird from AwareIm

bondicoffee

Hi friends,

I am trying to connect to External db(Firebird) from AwareIm. However, I am getting this error:
Server encountered an exception No suitable driver found for "jdbc:firebirdsql://DBpath","username","password"

Following are the steps I tried :
1)Added jar file that has Firebird jdbc file : jaybird-3.0.2.jar in CustomJars folder in awareim then restarted server
2) Under Persistence settings for a B.O, I selected Database existing external
3)Created Database :
configuration :
i) Database engine : custom
ii) JDBC Driver class name : org.firebirdsql.jdbc.FBDriver
iii: Connection URL: "jdbc:firebirdsql://DBpath","username","password"
3)Added Table for discovering columns

I got this error :
Server Output :
Server encountered an exception No suitable driver found for "jdbc:firebirdsql://DBpath","username","password"

I tried to restart server and tried to discover again ... but same result.

cishpix

bondicoffee wrote
1)Added jar file that has Firebird jdbc file : jaybird-3.0.2.jar in CustomJars folder in awareim then restarted server

I'm not too familiar with FireBird but as my experience when connecting to external DB with PostgreSQL, the jdbc driver (I mean the .jar file) should be located in AwareIM\Tomcat\lib\ directory not in CustomJars folder.

bondicoffee

On adding the jar file to Tomcat/lib directory, on discovering Attributes, I am getting the below error in server output:
Server encountered an exception javax/resource/ResourceException

aware_support

The problem was that Aware IM did not allow specifying user name and password as separate fields, rather than part of the connection URL (which is a standard approach).

Build 2372 fixes this - there is now a provision for specifying user name and password as separate properties.