netbeansjdbcvertica

How can I connect vertica with JDBC?

I want to connect Vertica with JDBC. But I got errors. Here is my code:

....

 Class.forName("com.vertica.jdbc.Driver");

....

 connection= DriverManager.getConnection
             (
             "jdbc:vertica://192.168.2.116:5433/schema", "dbadmin", "pass123"
             );

But I got this error (if I open the NetBeans database section, I got the same error message. But I connect to Vertica with the client (DBeaver)):

ex = (java.sql.SQLException) java.sql.SQLException: [Vertica] No enum const class com.vertica.dsi.dataengine.utilities.MetadataSourceColumnTag.COLUMN_SİZE

How can I fix this?

Solution

  • I think it is because of your locale. In this case Turkish, I guess.

    COLUMN_SİZE has upper case i → İ.

    It is Vertica's fault to use toUpper digressively.