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?
Please sign in to leave a comment.
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
I fixed with a clean new install of TeamCity (using our config backup):
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".