Vertica 7 JDBC support
Posted: Mon Oct 12, 2015 6:54 pm
Hello
Im trying to connect to vertica 7.1.2 in a test ubuntu 14 virtual machine, i created a table and uploaded a csv with the csvparser it works ok, but im not able to connect using jdbc (i downloaded the file vertica-jdbc-7.1.2-0.jar) neither from custom java code or using dbvisualizer , in both clients i got the error on connection test
Java Code: Connection attempt failed: [Vertica][VJDBC](100024) IOException while communicating with server: java.net.SocketException: Connection reset
Dbvisualizer:
Long Message:
[Vertica][VJDBC](100024) IOException while communicating with server: java.net.SocketException: Connection reset
Details:
Type: java.sql.SQLRecoverableException
Error Code: 100024
SQL State: 08S01
also, I can see this error in vertica.log Poll dispatch:0x9b34bb0 [Dist] <INFO> Non-Vertica connection from 192.168.1.47:61869 rejected, closing fd 15
Tx in advance for any help
Im trying to connect to vertica 7.1.2 in a test ubuntu 14 virtual machine, i created a table and uploaded a csv with the csvparser it works ok, but im not able to connect using jdbc (i downloaded the file vertica-jdbc-7.1.2-0.jar) neither from custom java code or using dbvisualizer , in both clients i got the error on connection test
Java Code: Connection attempt failed: [Vertica][VJDBC](100024) IOException while communicating with server: java.net.SocketException: Connection reset
Dbvisualizer:
Long Message:
[Vertica][VJDBC](100024) IOException while communicating with server: java.net.SocketException: Connection reset
Details:
Type: java.sql.SQLRecoverableException
Error Code: 100024
SQL State: 08S01
also, I can see this error in vertica.log Poll dispatch:0x9b34bb0 [Dist] <INFO> Non-Vertica connection from 192.168.1.47:61869 rejected, closing fd 15
Tx in advance for any help