Jump to content

New data source H2 db for Spotfire

Gustavo PESCADOR 3

Recommended Posts


Has anyone here created a new data source to connect Sptfire to a H2 db (as standalone)

I did put the .jar and the template into the server but when trying to create a new h2 data source via the information designer I get the error:


Cannot connect to data source '', due to invalid configuration or that the data source is not running.

Database reported:

Wrong user name or password [28000-197]


Could anyone advice

Spotfire version 10.9



Link to comment
Share on other sites

Before trying the things in Spotfire, I would suggest you create a sample connection to the H2 DB by making use of any third-party tool likehttps://www.dbvis.com/download/11.0and create a sample connection to figure out all the drivers which are required along with a confirmation that you are using the correct username and password for connecting to the database.
Link to comment
Share on other sites

  • 2 weeks later...

Hello Manoj,Thanks for taking the time to reply and sorry for my late reply.

So managed to create the H2 db wiht dbvis as you suggested but from Spotfire side the issue was that the "password" fiel cannot be left out empty. So I had to create a password to my user (we are still in dev).Another issue that I had, and this was my mistake, is that the db was embedded so I was doing all the ocnfiguration locally rather than in the server. Kind regards,GP 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...