actually thats what i did. but still won't work. i am using
oracle thin because my project is multithreading/socket server which
will handle data manipulation in different remote oracle  database.
i tried to trace the code, i put some println in it. i inserted it
between

while (rs.next()){
System.out.println("test");
String temp = rs.getString("name");
System.out.println("after test");
}

the screen only displays the word "test", so meaning, it halts on the
rs.getString.

i also tried to put

while(connection.isClosed()){
system.out.println("connection closed");
}

But it bypasses the println connection  closed. so i assumed there is
a connection.

are there any way i can check if i connected successfully?
can anyon help me figure this out? thanks a lot!!!!