2

I'm connecting to a Firebird 3.0 database using the Jaybird JDBC 3.0.3 driver. I'm connecting from within the ColdFusion Administrator -> Data Sources area. In the past, using JDBC 2.0 driver I created my data source as follows.

JDBC URL: jdbc:firebirdsql:localhost/3050:DATABASE_FILE_NAME
Driver Class: org.firebirdsql.jdbc.FBDriver
Username: USERNAME
Password: PASSWORD

However, this is not working now. I do not see anything obvious that I'm missing. I just get the error

Timed out trying to establish connection

I did read that Jaybird 3.0 does not support Wire Encryption - so I need to set it to Enabled (not Required which is the default). I have already done this in the firebird.conf file and restarted the Firebird service.

Mark Rotteveel
  • 82,132
  • 136
  • 114
  • 158
Phil
  • 3,779
  • 3
  • 51
  • 94
  • 1
    Although you already fixed the issue, could you also post the full exception stacktrace from the logs? This might make it easier for people running into the same problem to find this question. – Mark Rotteveel Apr 07 '18 at 16:34

1 Answers1

2

Turns out I needed to download and use the Jaybird driver for JDK 1.7 rather than 1.8. After I did that and restarted ColdFusion everything worked.

Phil
  • 3,779
  • 3
  • 51
  • 94