Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Class.forName("com.teradata.jdbc.TeraDriver");
- String connectionString = "jdbc:teradata://xxx.xxxxxx.com/database=xxxxxx, tmode=ANSI, charset=UTF8";
- String user = "Rocket512";
- String password = "aui8mn5";
- Connection conn = DriverManager.getConnection(connectionString, user, password);
- Exception in thread "main" com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database]
- [TeraJDBC 14.10.00.17] [Error 8017] [SQLState 28000] The UserId, Password or Account is invalid.
- at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:300)
- at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:666)
- at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:216)
- select *
- from dbc.logonoff
- where logdate >= date '2013-10-31'
- select *
- from dbc.logonoff
- where logdate >= date '2013-10-31'
- SELECT U.UserName
- , U.ProfileName
- , U.DefaultAccount
- , COALESCE(P.MAXLOGONATTEMPTS, S.MAXLOGONATTEMPTS) AS MaxLogonAttempts_
- , U.LockedCount
- , U.LockedDate
- FROM dbc.UsersV U
- LEFT JOIN
- dbc.ProfileInfoV P
- ON P.ProfileName = U.ProfileName
- CROSS JOIN
- dbc.SecurityDefaults S
- WHERE UserName = 'Rocket512';
- SELECT *
- FROM DBC.LogonRulesV
- WHERE UserName = 'Rocket512';
- String driver = "com.teradata.jdbc.TeraDriver";
- String conUrl="jdbc:teradata://xxx.xxxxxx.com/database=xxxxxx,USER=Rocket512,PASSWORD=aui8mn5,tmode=ANSI,charset=UTF8";
- Class.forName(driver);
- Connection dbConn = DriverManager.getConnection(conUrl);
Add Comment
Please, Sign In to add comment