Refresh connection to database every 5 seconds through a java program 3

[pjeypal]

Hi

I am writing a small java program to connect every 5 seconds via the jdbc-odbc bridge driver. Is there any option to refresh connection every 5 secs?

Thanks in advance

 

[Diancecht]

Why would you want to refresh the connection? Does the driver requires that?

What's your question about: how to refresh, how to launch every 5 seconds ...?

Cheers,
Dian

 

[pjeypal]

Thanks Dian for your reply

I need to launch the connection every 5 secs. Is this possible?

 

[sedj]

Why on earth would you need to do that ?

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[Miros]

Use the SwingWorker class to fire off a background thread and loop forever with "wait(5000);launchconnection()"

 

[timw]

... but we would still be interested to know why you'd like to do this.

Tim

 

[Diancecht]

Timer and TimerTask classes are intented for repetitive or scheduled work, but I agree it's not a good thing to do.

Cheers,
Dian

 

[pjeypal]

Thanks for all the replies

Actually what i need to do is connect to an oracle database, wait for 2 secs and then disconnect (This need to be done only once).

 

[pjeypal]

This is the script

import java.sql.*;

class JdbcTest1 {

public static void main (String[] args) {
try {

// Step 1: Load the JDBC driver.
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

// Step 2: Establish the connection to the database.
String url = "jdbcdbc:contact_mgr";
Connection conn = DriverManager.getConnection(url,"user1","password");

} catch (Exception e) {
System.err.println("Got an exception! ");
System.err.println(e.getMessage());
}
}
}

 

[Diancecht]

Please use code tags when posting

import java.sql.*;  

class JdbcTest1 {  
      
    public static void main (String[] args) {  
        try {  

            // Step 1: Load the JDBC driver.  
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  

            // Step 2: Establish the connection to the database.  
            String url = "jdbc:odbc:contact_mgr";  
            Connection conn = DriverManager.getConnection(url,"user1","password");   
            Thread.currentThread.sleep(2000);
             conn.close();
        } catch (Exception e) {  
            System.err.println("Got an exception! ");  
            System.err.println(e.getMessage());  
        }  
    }  
}

Cheers,
Dian

 

[pjeypal]

Thanks a lot

 

[timw]

... or

import java.sql.*;  

class JdbcTest1 {  
      
    public static void main (String[] args) {  
        Connection conn = null;
        try {  

            // Step 1: Load the JDBC driver.  
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  

            // Step 2: Establish the connection to the database.  
            String url = "jdbc:odbc:contact_mgr";  
            conn = DriverManager.getConnection(url,"user1","password");   
            Thread.currentThread.sleep(2000);
        } catch (Exception e) {  
            System.err.println("Got an exception! ");  
            System.err.println(e.getMessage());  
        } finally {
            try {
                if ( conn != null )
                    conn.close();
            } catch (SqlException ex){}
        }
    }  
}

Just in case the sleep is interrupted by another thread, to guarantee the connection is closed.

Tim

 

[pjeypal]

Thanks to you Tim

 

[pjeypal]

Any idea why this error


C:\>javac JdbcTest.java
JdbcTest.java:14: cannot resolve symbol
symbol : variable currentThread
location: class java.lang.Thread
Thread.currentThread.sleep(2000);
^
1 error

C:\>

 

[sedj]

#1 You really should be using the oracle driver (a jar called classes12.jar or ojdbc14.jar - either is fine) to connect to Oracle.

#2 To sleep for two seconds :

try {
  Thread.sleep(2000);
} catch (InterruptedException ie) {
   ie.printStackTrace(System.err);
}

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk