jdbc with mssql noob issue

[thejwal pavithran]

import java.sql.*;
class A
{
	public static void main(String[] args)
	{
		try
		{
		
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		Connection con=DriverManager.getConnection("jdbc:odbc:desktop","sa","");		
		Statement st=con.createStatement();
		String table = "CREATE TABLE Employee11(Emp_code integer, Emp_name varchar(10))";
  		st.executeUpdate(table);
  		
  		//String as="INSERT INTO Employee11 values(123,'abc')";
		//st.executeUpdate(as);
		}
		catch(Exception e)
		{
			System.out.println("error");
		}
	}
}

hey guys the line st.executeUpdate(table); seems to take control to the catch block..i am new to try catch too...what is my mistake please guide me

[Sumit Patil]

Can you post the error message you are getting?
Also, try putting a catch block with SQLException before the catch block you have given.

[Jesper de Jong]

Please change this part of your code:

catch(Exception e)
{
    System.out.println("error");
}

Into something more useful:

catch (Exception e)
{
    e.printStackTrace();
}

So that at least you have a clue about what goes wrong - just the word "error" isn't going to tell you very much.

[thejwal pavithran]

Sorry for completely editing this post I had pasted the wrong code here.hey the e.stacktrace() pointed out the error. it says that the table already exists..so the problem occurs when i try to create the same table again right?

[thejwal pavithran]

Thank you jesper your advice worked.

[Nam Ha Minh]

thejwal pavithran wrote:Sorry for completely editing this post I had pasted the wrong code here.hey the e.stacktrace() pointed out the error. it says that the table already exists..so the problem occurs when i try to create the same table again right?

You should use:

DROP TABLE IF EXISTS

or

CREATE TABLE IF NOT EXISTS

[thejwal pavithran]

Nam Ha Minh wrote:

thejwal pavithran wrote:Sorry for completely editing this post I had pasted the wrong code here.hey the e.stacktrace() pointed out the error. it says that the table already exists..so the problem occurs when i try to create the same table again right?

You should use:

DROP TABLE IF EXISTS

or

CREATE TABLE IF NOT EXISTS

yes i will try that soon..thanks for your point