I'm currently looking for the most convenient way to connect to a Transbase DB with Spring Boot. Is it even possible with Spring JDBC? Do I need additional drivers? And what do I need to configure in my application.properties? I couldn't make it work by now.

Already tried to search for someone who has done this before but Transbase does not seem to be very popular, so without success.

Best regards

CodePudding user response：

Yes, you need to add additional Transbase jdbc driver to your classpath.

And you can configure your your spring boot with following properties:

spring.datasource.driver-class-name: transbase.jdbc.Driver
spring.datasource.url: jdbc:<your jdbc url>
spring.datasource.username: <username>
spring.datasource.password: <password>

And if you got any database specific additional properties, set it like this

spring.datasource.hikari.data-source-properties.<your datasource specific property key> : <value>