[Vertica][VJDBC](3781) FATAL: Invalid username or password

[jerald]

Code: Select all

Class.forName("com.vertica.jdbc.Driver");
        String serverName = "**.***.*.*";
        String portNumber = "5433";
        String sid = "mydb";
        String url = "jdbc:vertica://"+serverName+":"+portNumber+"/mydb";
        String username = "mydb";
        String password = "myd";
        Connection conn = DriverManager.getConnection(url, username, password);

while i'm trying to connect i'm getting.
[Vertica][VJDBC](3781) FATAL: Invalid username or password

i create database user mydb and given password mydb,

what will be the ERROR please help me out...

[scutter]

Is that code snippet accurate?

String password = "myd";

You said the password is mydb?

[jerald]

Code: Select all

String username = "mydb";
        String password = "mydb";
        

now also getting the same Error:

java.sql.SQLInvalidAuthorizationSpecException: [Vertica][VJDBC](3781) FATAL: Invalid username or password

[NorbertKrupa]

Try connecting using vsql with the credentials you provided.