Results 1 to 3 of 3
Thread: jdbc connectivity error
- 03-14-2010, 03:37 PM #1
Member
- Join Date
- Mar 2010
- Posts
- 23
- Rep Power
- 0
jdbc connectivity error
What driver can I use for database connectivity with Oracle 9i? I created a new driver using administrative tools --> Data sources(ODBC).
I'm having trouble establishing database connectivity.
Java Code:private void jButton1MouseClicked(java.awt.event.MouseEvent evt) { String user= new String(jTextField1.getText()); String pass= new String(jPasswordField1.getPassword()); if(a<4) { Connection con = null; String driver = "oracle.jdbc.driver.OracleDriver"; String user1 = "system"; String pass1 = "manager"; try{ Class.forName(driver); con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521/test",user1,pass1); Statement s=con.createStatement(); ResultSet password=s.executeQuery("Select pass from login where username="+user); s.close(); con.close(); if(pass.contentEquals(password.getString(1))) { a=0; JOptionPane.showMessageDialog(rootPane, "Access Granted"); ResultSet access=s.executeQuery("Select access_power from login where username="+user); access_power=access.getString(1); new Exam_Season().setVisible(true); this.setVisible(false); } else { JOptionPane.showMessageDialog(rootPane, "Access Denied."); a++; } } catch(Exception e) { e.printStackTrace(); JOptionPane.showMessageDialog(rootPane, "Connection not successful."); } } else { JOptionPane.showMessageDialog(rootPane, "Too many attempts."); System.exit(0); } }
- 03-16-2010, 04:00 PM #2
Senior Member
- Join Date
- Dec 2009
- Location
- Belgrade, Serbia
- Posts
- 364
- Rep Power
- 4
What error do you get?
You can always download JDBC driver,
like "ojdbc14.jar" place it in classpath and try.
regards
- 03-16-2010, 05:10 PM #3
Member
- Join Date
- Mar 2010
- Posts
- 23
- Rep Power
- 0
Similar Threads
-
SQL exception error in JDBC conection with servlet+ jsp
By morya123 in forum New To JavaReplies: 2Last Post: 12-09-2009, 09:58 AM -
Help me this error in JDBC-ODBC connection
By lordelf in forum Java ServletReplies: 3Last Post: 04-04-2009, 08:37 AM -
How to use JDBC Template classes to control basic JDBC processing and error handling
By Java Tip in forum Java TipReplies: 0Last Post: 04-01-2008, 10:17 AM -
JDBC error
By ARADHYEV in forum JDBCReplies: 0Last Post: 01-09-2008, 08:56 AM -
How to use JDBC Template classes to control basic JDBC processing and error handling
By JavaBean in forum Java TipReplies: 0Last Post: 09-28-2007, 12:56 PM


LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks