JDBC to SQLBase

[pmendes]

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 😕

[Anonymous]

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

[pmendes]

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