Thread: ms-acess with jdbc

// Access.java
import java.sql.*;
public class AccessTest

{
public static void main(String [] args) throws Exception
{
try
{




//register driver and establish the connection
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con =DriverManager.getConnection("jdbcdbc:accdsn");
//create statement object
Statement st =con.createStatement();
//send and execute query
ResultSet rs =st.executeQuery("select * from student");
// precess the result object
while(rs.next())
{
System.out.println(rs.getInt(1)+" "+rs.getString(2)+" " +rs.getString(3));
}
//close jdbc objects
rs.close();
st.close();
con.close();
}
catch (Exception e)
{
e.printStackTrace();
}



}//main()

}//class

i am getting run time error in xp3 please help to me....................

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\admin>d:

D:\>javac SelectTest.java

D:\>java SelectTest
Exception in thread "main" java.lang.ClassNotFoundException: oracle .jdbc.driver
.OracleDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at SelectTest.main(SelectTest.java:11)

D:\>cd ms access

D:\ms access>javac AccessTest.java

D:\ms access>java AccessTestt k
Exception in thread "main" java.lang.NoClassDefFoundError: AccessTestt
Caused by: java.lang.ClassNotFoundException: AccessTestt
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
Could not find the main class: AccessTestt. Program will exit.

D:\ms access>java AccessTestt
Exception in thread "main" java.lang.NoClassDefFoundError: AccessTestt
Caused by: java.lang.ClassNotFoundException: AccessTestt
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
Could not find the main class: AccessTestt. Program will exit.

D:\ms access>java AccessTest
java.sql.SQLException: No data found
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknow n Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at AccessTest.main(AccessTest.java:13)

D:\ms access>javac ConnectionExample.java
javac: file not found: ConnectionExample.java
Usage: javac <options> <source files>
use -help for a list of possible options

D:\ms access>cd\

D:\>javac ConnectionExample.java

D:\>java ConnectionExample
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not fou
nd and no default driver specified

D:\>javac ConnectionExample.java

D:\>javac AccessTest.java
javac: file not found: AccessTest.java
Usage: javac <options> <source files>
use -help for a list of possible options

D:\>cd ms access

D:\ms access>javac AccessTest.java

D:\ms access>java AccessTest
java.sql.SQLException: No data found
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknow n Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at AccessTest.main(AccessTest.java:13)

D:\ms access>java AccessTest
java.sql.SQLException: No data found
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknow n Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at AccessTest.main(AccessTest.java:13)

D:\ms access>javac AccessTest.java

D:\ms access>java AccessTest
Exception in thread "main" java.lang.ClassNotFoundException: sun.jdbc.odbc.Jdbco
dbcDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at AccessTest.main(AccessTest.java:12)

D:\ms access>

please check my message and check it and give the answer as soon as possible... please

--- Update ---

class not found
my sql exception no data found it gives please tell message

Originally Posted by Norm

Where is the definition for the class that was not found? Its definition must be on the classpath for the java command.

how to define please tell to me i am beginner of jdbc please tell to me:

it is present in oracle or java jdk 1.6 please tell

i am trying to connect with ms-access it gives run time error class not found if u have videos of ms-access