insert query in odbc

[lipun4u]

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("jdbc:odbc: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();

}

}

[Tolls]

1. What error are you getting (stack trace and all), and on what line...ie point out the line.

2. Put code in CODE tags to retain the formatting there's a button ('#') above the message box.

[Harpreet1111]

hello lipun4u,

it is sun.jdbc.odbc.JdbcOdbcDriver.
create the appropriate dsn and run....

[Tolls]

By the way, if this is an Oracle db (and it looks like it might be, unless scott/tiger is used by everyone as a demo login) you should be using the Oracle drivers.