topic JDBC to SQLBase in Talend Studio

JDBC to SQLBase

pmendes — Mon, 29 Oct 2018 13:39:20 GMT

Hello,

I'm facing troubles trying to connect a SQLBase database using the JDBC component.

It tells me that the connexion is refused while the user/pwd is ok. An ODBC connexion with these credentials works fine.

I think the URL is good and the driver too. I'm on a 32bits server with Talend 6.4 32bits.

Any Idea ? I'm totally blocked 😕

Re: JDBC to SQLBase

Anonymous — Wed, 31 Oct 2018 03:43:54 GMT

Hello,

Are you using 32 bit JDK 1.8 also? What's sqlbase jdbc driver are you using? Could you please show us the full error stack trace?

Best regards

Sabrina

Re: JDBC to SQLBase

pmendes — Wed, 31 Oct 2018 09:51:44 GMT

Hello xdshi,

Thanks for reply.

I have some news, the port 2155 was not open on the server.

But now I have another error message telling me that the Database Name is invalid while I'm using the name defined in the SQL.ini file :

Exception in component tJDBCConnection_1 (test)
java.sql.SQLException: 00162 SQL IDN Invalid database name
at jdbc.gupta.sqlbase.SqlbaseConnection.<init>(SqlbaseConnection.java:171)
at jdbc.gupta.sqlbase.SqlbaseDriver.connect(SqlbaseDriver.java:169)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at test_amistot.test_0_1.test.tJDBCConnection_1Process(test.java:339)
at test_amistot.test_0_1.test.runJobInTOS(test.java:611)
at test_amistot.test_0_1.test.main(test.java:460)

In attachment you'll find the TJDBCConnection configuration. The Database name is AMSIBOXI on the sqlw2008 instance on the server named vqp10bdsql05.

I'm using JAVA 1.8 32bits and the driver is SQLBaseJDBC12.1.1.jar I found on the net.

Thanks,

Patrick

tJDBCConnection.JPG