JDBC Oracle Driver ERROR?

From: Tomasz Olchawa <thm_at_parasoft.com.pl>
Date: Fri, 28 Sep 2001 09:48:59 +0200
Message-ID: <9p1a6p$gt7$1@news.formus.pl>

I have problem.

This simple program create connection to database ( Oracle ). If you press button 'connect' and program create connection and then you break connection (e.g. physically - pull out network cable ) and then you press button 'connect' you receive SQLException:

    "java.sql.SQLException: Wyj?tek we-wy: The Network Adapter could not establish the connection"
It's OK, because when you recreate connection ( e.g. put in network cable ) and then press button 'connect' everything is OK - you have again connection to database.

Problem is:
When you haven't connection to database ( e.g. - network cable is pull out ) and then you press button 'connect' you received SQLException and you never can create connection during work this program - you MUST RESTART THIS PROGRAM.. Help me:
Do you known how fix this problem?

//------------------------------------------------------------------------

// simple program

//------------------------------------------------------------------------

import java.sql.*;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;

public class Test extends Frame implements ActionListener {

    static String url = "jdbc:oracle:thin:@host.com.pl:1521:sid1";     static String driver = "oracle.jdbc.driver.OracleDriver";     static String user ="scott";
    static String pass = "tiger";

    Label label = null;
    Button button = null;

    public static void main(String args[])
{

       new Test();
    }

    private void connect()
{

       try {
        Class.forName(driver);
       } catch (ClassNotFoundException e) {
         label.setText("Can't load driver");
         return;
       }
       try {
        Connection con = DriverManager.getConnection(url, user, pass);
       } catch (SQLException e) {
          label.setText("Can't connect");
          return;
       }
       label.setText("Success!!!");

    }

    Test()
{

        super("JDBC test");
        label = new Label("Status: not connected");
        button = new Button("connect");
        button.addActionListener(this);
        this.setLayout(new BorderLayout());
        this.add(label, "Center");
        this.add(button, "South");

        pack();
        show();

    }
    public void actionPerformed(ActionEvent e)
{

        label.setText("connecting ....");
        connect();

    }
}

---

I have:

-    Java(TM) 2 SDK, Standard Edition Version 1.3.1
-    Oracle 8i
-    classes12.zip ( 1 931 357  Kb )

Best Regards,
Tomek Received on Fri Sep 28 2001 - 02:48:59 CDT