how to connect java programme to a database

[rahana]

My java programme is unable to connect to the database..

my code is this

 
              import java.sql.*;
 
            public   class Stmt
                {
            public static void main(String args[])throws Exception
                {
 
                               try{
                       Class.forName("oracle.jdbc.driver.OracleDriver");            
 Connection con=DriverManager.getConnection("jdbc:oracle:thin@localhost:1521:xe","scott","tiger");
                        Statement stmt=con.createStatement();
                        String vsql="create table testtable(cone number,ctwo number)";
                        stmt.executeUpdate(vsql);
                        System.out.println("...Success....");
                        con.close();
                            }
                        catch(ClassNotFoundException e)
                            {
                        System.out.println(e);
                        System.out.println("hello");
                            }
 
          }
  }
 

My java programme is compiling but not running I am getting error as Exception in thread "main" java.sql.SQL exception,connection refused.


Please give answer to my question ,i am struck here and unable to go further

[JosAH]

My java programme is compiling but not running I am getting error as Exception in thread "main" java.sql.SQL exception,connection refused.


Please give answer to my question ,i am struck here and unable to go further

There are a few possible causes:

1) wrong port number
2) wrong user name and/or password
3) no database server running
4) error in your url for the connection request
5) database server too busy already
6) firewall problems

You have to check them all and google a bit.

kind regards,

Jos

[rahana]

There are a few possible causes:

1) wrong port number
2) wrong user name and/or password
3) no database server running
4) error in your url for the connection request
5) database server too busy already
6) firewall problems

You have to check them all and google a bit.

kind regards,

Jos

how can i know the port number,user name,password and url

[JosAH]

how can i know the port number,user name,password and url

What about reading your database vendor's manual?

kind regards,

Jos