topic Re: connecting to a H2 database in Talend Studio

connecting to a H2 database

_AnonymousUser — Thu, 25 Apr 2013 21:28:19 GMT

I am trying to connect to a H2 database (not Talend).
I can connect to this H2 database using H2 Admin Console
(the H2 Admin Console has the following settings)
Driver Class: org.h2.Driver
JDBC URL: jdbc:h2:C:\Guidewire\TrainingApp\db\ta.h2.db
User Name: sa
Password:
so I drag a tJDBC connection node and enter the following parameters
JDBC URL: "jdbc:h2:C:\Guidewire\TrainingApp\db\ta.h2.db"
Driver JAR:
Driver Class: "org.h2.Driver"
User Name: "sa"
Password:

And I get the following two errors
* Invalid escape characters (valid ones are \b \t \n \f \r \" \' \\)
* Parameter (Driver JAR) must have at least one value
what am I doing wrong?

Re: connecting to a H2 database

Anonymous — Fri, 26 Apr 2013 02:53:59 GMT

Hi,
As the error showed, you have to specify the driver jar, the driver jar name is h2.jar for h2 database, you can download it from
http://www.h2database.com

Best regards
Sabrina

Re: connecting to a H2 database

Anonymous — Fri, 26 Apr 2013 07:24:54 GMT

Take al look at your URL! You have to use / (slash) instead of back slash! If you prefer backslashes in this case you must escape them like this \\ for one and \\\\ for two.