Recent content by pjeypal

A simple one.I need a script to drop all packages in a schema where name starts with 'T_%'

Hi For testing purposes i need to create a schema in an oracle database which is an exact copy of an existing schema in the same database. Which is the simplest way to do this? Is there any command Thanks PJ

Thanks a lot!! Wangdong

I have an application which opens a URL connection and i found that even after completing the operation the session is hanging and not getting closed Any suggestions import java.net.URLConnection; import java.net.URL; import java.io.IOException; import java.util.HashMap; import...

Is there any way to edit this now?

I have an application which opens a URL connection and i found that even after completing the operation the session is hanging and not getting closed Any suggestions import java.net.URLConnection; import java.net.URL; import java.io.IOException; import java.util.HashMap; import...

Hi The lang package is by default imported into the class. Therefore the issue is something else. I tried with the import statement but still the same error

I am trying to compile this class 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...

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:\>

Thanks to you Tim :)

Thanks a lot :)

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...

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).

Thanks Dian for your reply I need to launch the connection every 5 secs. Is this possible?

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