oracle + java = slow?
Date: Mon, 7 Oct 2002 14:20:55 +0100
Message-ID: <ans22q$320$1_at_pheidippides.axion.bt.co.uk>
String sourceURL = "jdbc:oracle:thin:_at_(DESCRIPTION = (ADDRESS_LIST =
The above two lines of java code work but the response is so slow. It takes
perhaps fifteen minutes to connect. My personal felling is that there is a
problem with Oracle itself on the server. I believe so because other
applications connecting to the same Oracle database have similar problems.
Is there a way to check the Oracle server. I tried logging in Oracle console
and the net manager, I cannot see anything wrong but frankly I do not know
where to look.
(ADDRESS = (COMMUNITY = server1.info.bt.co.uk) (PROTOCOL = TCP) (Host =
server1) (Port = 1521) ) ) (CONNECT_DATA = (SID = oracle)
(SERVER=DEDICATED) ))";
databaseConnection = DriverManager.getConnection(sourceURL,usr,psw);
PS: I know ordinarily the first line should be something like: String sourceURL = "jdbc:oracle:thin:_at_server1.info.bt.co.uk:1521:oracle"; but this did not work and the above is the work arround.
many thanks in advance Received on Mon Oct 07 2002 - 15:20:55 CEST