I consulted the FAQ on this forum, searched this and suns forum and google as well.. still I am clueless with this. Dear all,
I am failry versed with java and jdbc. I did a lot of google and searched a lot of forums but no one gave me all the details. I have done a lot of oracle jdbc. I would appreciate if some one could give me all the details please. I dont even know which jar files should be in the classpath.
Oracle Comparision : place ojdb14.jar in classpath
Class.forName("oracle.jdbc.driver.OracleDriver"); // Create a connection to the database String serverName = "127.0.0.1"; String portNumber = "1521"; String sid = "oracle"; String url = "jdbcracle:thin:@" + serverName + ":" + portNumber + ":" + sid; String username = "scott"; String password = "tiger"; connection = DriverManager.getConnection(url, username, password); // Create a result set containing all data from my_table Statement stmt = connection.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM sometable");
I am just about clueless on db2 .. (was able to scape through the install and the install is fine.)....just know that db2java.zip should be on the classpath....thats all..
Joined: Mar 20, 2007
right.. i went very far with this. I have a trial version installed on my machine. The prog. kept saying wrong user id an pwd. Finally, it revoked the administrators account... and now even after pouring through googles search I still dont know how to "un-revoke" my admin account. I am able to connect to db2 on another machine though. So now essesntially the question lingers on, 1)how can I reactivate my admin account(the one it asks while installing the db).?2) After learning this, I created an account on the other machine using the control center, however there is no place where I can give a password. Any ideas with this ?
i know this is very very basic, but I am stuck at this.
On my Window's machine, the db2 admin password is an operating system level account. It locks out when I type the password in wrong a certain number of times. To unlock it, I have to go into the windows control panel and unlock the account.