Database problem.

[OMFGITSROHIT]

Errors-

java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.security.AccessController.doPrivileged(Native Method)
at sun.misc.Launcher$AppClassLoader.loadClass(Launche r.java:301)
at java.lang.Class.forName0(Native Method)


packages-

import javax.swing.*;
import java.awt.event.*;
import java.io.*;
import java.sql.*;
import java.util.*;

<code>
:confused::confused:
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 driver="sun.jdbc.odbc.JdbcOdbcDriver";
String user1 = "scott";
String pass1 = "tiger";
try{
Class.forName(driver);
con = DriverManager.getConnection("jdbc:oracle:oci8:@loc alhost",user1,pass1);
//con = DriverManager.getConnection("jdbc:odbc:test",user1 ,pass1);
//con = DriverManager.getConnection("jdbc:odbc:loginsource ","scott","tiger");
Statement s=con.createStatement();
ResultSet password=s.executeQuery("Select pass from login where username="+user);
//s.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);
}

}
</code>

[jambon]

Do you have the ojdbc6.jar (or equivalent version) in your classpath?
-J

[OMFGITSROHIT]

Yeah ojdbc14.jar

[jambon]

Hmmm..
I'm using Oracle JDeveloper 11g and I was getting that error until I put the jar file in the Project folder and then using Project Properties added the reference to the jar file in the Libraries and Classpath area.
But I don't suppose that's any help.
-J

[OMFGITSROHIT]

I'll check that out and get back to you. Thanks.

[OMFGITSROHIT]

Thanks a bunch dude. I think something's resolved.

I'm no more getting the classpath error or the message box which says "Connection not successful" (placed in the exception part). New errors that I've got are-

Exception in thread "AWT-EventQueue-0" java.lang.UnsatisfiedLinkError: oracle.jdbc.oci8.OCIDBAccess.make_c_state(ZZ) I

at oracle.jdbc.oci8.OCIDBAccess.make_c_state(Native Method)
at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.jav a:397)
at oracle.jdbc.driver.OracleConnection.<init>(OracleC onnection.java:346)
at oracle.jdbc.driver.getconnectionInstance(OracleDri ver.java:468)
at oracle.jdbc.driver.connect(OracleDriver.java:314)