Fw: The Network Adapter could not establish the connection
- From: "NEW pop.tiscali.de" <adolph.tony@xxxxxxxxxx>
- To: <jdunn@xxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 29 Oct 2005 16:35:41 +0100
Second to my last email John,
I've just reproduced your error (by mistake):
D:\temp>java ConnTest
Starting..
Loading drivers...done
Making a connection to the database:
jdbc:oracle:thin:@192.168.1.100:1521:DB1 as
tony...
SQL exception message = Io exception: The Network Adapter could not
establish the connection
When I looked in my properties file I found the wrong port number:
jdbc:oracle:thin:@192.168.1.100:1521:DB1
Corrected it and....
D:\temp>java ConnTest
Starting..
Loading drivers...done
Making a connection to the database:
jdbc:oracle:thin:@192.168.1.100:1524:DB1 as
tony...done
Executing statement "select to_char(sysdate,'hh24:mi.ss dd-Mon-yyyy') from
dual"
...
SYSDATE: 16:32.33 29-Oct-2005
Conn time : 0mins 1secs
Connection time: 1312ms - Statement execution time: 100ms
HTH
Cheers
Tony
----- Original Message -----
From: "NEW pop.tiscali.de" <adolph.tony@xxxxxxxxxx>
To: <jdunn@xxxxxxxxx>; <oracle-l@xxxxxxxxxxxxx>
Sent: Saturday, October 29, 2005 3:18 PM
Subject: Re: The Network Adapter could not establish the connection
> Hi John,
>
> I have a simple java prog that I use that may be useful. You can test
thick
> (oci8) and thin connections.
>
> If you're intersted let then I can email it to you.
>
> Cheers
> Tony
> ----- Original Message -----
> From: "John Dunn" <jdunn@xxxxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>
> Sent: Friday, October 28, 2005 9:08 PM
> Subject: The Network Adapter could not establish the connection
>
>
> > I am getting this error from a 3rd party application.
> >
> >
> > Create DbPool error: DatabasePoolWrapper error :DATABASEPOOL : JDBC DB
> > connection error : jdbc:oracle:thin:@10.20.66.154:1521:mysid ==> Io
> > exception:
> > The Network Adapter could not establish the connection
> >
> > Any ideas what the problem might be?
> > Environment is Oracle 9.2 on Solaris 8.
> >
> > Is there any way I can test a jdbc connection from the command line?
> >
> > --
> > //www.freelists.org/webpage/oracle-l
> >
> >
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Fw: The Network Adapter could not establish the connection
