insert query in ODBC

[asit]

Why the following code gives error ????

import java.sql.*;

public class Main {

/**
* @param args
*/
public static void main(String[] args) throws Exception {
// TODO Auto-generated method stub
Class.forName("jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbcdbc:dsn1",
"scott", "tiger");
Statement stmt = con.createStatement();
int x = stmt.executeUpdate("insert into emp (empno, ename, job)
values (1000, 'asit dhal', 'clerk')");
System.out.println(x + " rows updated");
con.close();

}

}

 

[asit]

Why the following code gives error ????

import java.sql.*;

public class Main {

        /**
         * @param args
         */
        public static void main(String[] args) throws Exception {
                // TODO Auto-generated method stub
                Class.forName("jdbc.odbc.JdbcOdbcDriver");
                Connection con = DriverManager.getConnection("jdbcdbc:dsn1",
"scott", "tiger");
                Statement stmt = con.createStatement();
                int x = stmt.executeUpdate("insert into emp (empno, ename, job)
values (1000, 'asit dhal', 'clerk')");
                System.out.println(x + " rows updated");
                con.close();

        }

}

Thanx for checking my code.
I have solved this.

sorry for waiting ur time...

 

[John B. Matthews]

Why the following code gives error ????

[...]

Thanx for checking my code. I have solved this.

sorry for waiting ur time...

So, what was the error and the solution?

 

[asit]

Why the following code gives error ????

[...]

Thanx for checking my code. I have solved this.

sorry for waiting ur time...

So, what was the error and the solution?

I made the mistake in cl;ass name jdbc.odbc.JdbcOdbcDriver. The actual
class name is sun.jdbc.odbc.JdbcOdbcDriver.

 

[Roedy Green]

Why the following code gives error ????

what is the precise wording of the error message?
--
Roedy Green Canadian Mind Products
http://mindprod.com

"For reason that have a lot to do with US Government bureaucracy, we settled on the one issue everyone could agree on, which was weapons of mass destruction."
~ Paul Wolfowitz 2003-06, explaining how the Bush administration sold the Iraq war to a gullible public.