error while entering the data into oracle database

[pankaj saxena]

sir,

earlier my program having a jdbc connection with oracle ,was working properly, data was going properly into the database.

But, now an error is displayed saying: java.io.SQLException : Io exception: the Network Adapter could not establish the connection.

what should i do in this case?

regards.
pankaj.

[pankaj saxena]

sir,

I have gone through the articles given in this forum relating to the similar error, my problem is when i tried to start the OracleXETNSListener, it starts for a second then it automatically stops.

I am not getting the real reason behind that.

regards.
pankaj.

[pankaj saxena]

My code is:

import java.sql.*;
import java.io.*;

public class Oracle1
{
  public static void main(String[] args)
  {
    try{
       Class.forName("oracle.jdbc.driver.OracleDriver");
	Connection c=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","oracle");
	String t1="lalu";
	int t2=501;
	Statement s=c.createStatement();
	
	s.executeUpdate("create table kbc(name varchar(20),salary number)");
	s.close();

	//taking the data from user and passing it to database via PreparedStatement & its setString() , setInt() method

	PreparedStatement ps=c.prepareStatement("insert into kbc values(?,?)");
	

	ps.setString(1,t1);
	ps.setInt(2,t2);
	ps.executeUpdate();
	ps.close();

	//to show result
	ps=c.prepareStatement("select * from kbc");
	ResultSet rs=ps.executeQuery();
	while(rs.next())
	{
	 System.out.println("Name:"+rs.getString(1));
	 System.out.println("Id:"+rs.getString(2));
	}
	}
	catch(SQLException e)
	{System.out.println(e);}
	catch(Exception i)
	{
	System.out.println(i);}

}
}