Fw: The Network Adapter could not establish the connection

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_at_tiscali.de> To: <jdunn_at_sefas.com>; <oracle-l_at_freelists.org> 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_at_sefas.com>
> To: <oracle-l_at_freelists.org>
> 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?
> >
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
>

--
http://www.freelists.org/webpage/oracle-l