after ugrade to 2024.07: No suitable JDBC driver found for database type: HSQL1

I upgraded/updated TeamCity on multiple Windows Servers to 2024.07 (build 160569) - from 2024.03

On all but one Server everything went well. On one server I get this error on TeamCity Server startup: 

No suitable JDBC driver found for database type: HSQL1

Current Startup State
Startup status
Current step: TeamCity server startup error
Next step: not defined yet

Data Directory
Directory path: C:\ProgramData\JetBrains\TeamCity exists

Database properties file not found, environment variables are not provided

Internal database file: 1.8.1

Database
Database type: default (using internal database)

Database connection URL: jdbc:hsqldb:file:C:/ProgramData/JetBrains/TeamCity/system/buildserver

Versions
Software version: 1008

Data directory version: 1008

Database version: unknown

Logs
Logs path: C:\TeamCity\logs

(We use HSQL database on that server)

Unfortunately I cannot glean much more from teamcity-server.log:

[2024-07-26 18:34:24,576]   INFO -  jetbrains.buildServer.STARTUP - Internal HSQL database file (C:\ProgramData\JetBrains\TeamCity\system\buildserver.data) exists, version: 1.8.1
[2024-07-26 18:34:24,576]   INFO -  jetbrains.buildServer.STARTUP - Using internal (HSQL) database
[2024-07-26 18:34:24,576]   INFO -  jetbrains.buildServer.STARTUP - Current stage: Connecting to the database
[2024-07-26 18:34:24,623]  ERROR -  jetbrains.buildServer.STARTUP - No suitable JDBC driver found for database type: HSQL1

I tried to find a solution online, and tried a few things over the past hours - but without success. I also compared this TeamCity-Installation with those on other servers, but did not find a reason for the error.

Is there someone who could help me with this error? Can I find the reason for the error in other log files?

Is there a place where one can download a JDBC driver? And if so - where do I put it?

0
3 comments
Hi Anton,

The HSQLDB driver was unbundled in the 2024.07 release. Please refer to the upgrade notes at https://www.jetbrains.com/help/teamcity/2024.07/upgrade-notes.html#bundled-tools-updates-2024-07. They also provide instructions on how to continue using it.

Best regards,
Anton
1

I fixed with a clean new install of TeamCity (using our config backup):

  1. uninstall TeamCity
  2. delete all TeamCity-related folders
  3. install TeamCity 2024.07
0

Thanks, Anton Vakhtel,

I should have read the upgrade notes right away - would have saved me a lot of time.

That also explains why my new installation “fixed” the issue - because it downloaded the HSQLDB library when I selected to use the HSQLDB.

Not sure why my previous installation did not download it (on demand) - maybe some settings were off. 

Still glad to start off with fresh install - the old one seemed to be quite "clogged up".

0

Please sign in to leave a comment.