I/O error JDBC connecting to oracle 9i

From: K P (k.p_at_cox.net)
Date: 11/16/03 

To: dbi-users@perl.org
Date: Sun, 16 Nov 2003 2:41:55 -0500

hi
hope someone can tell me what i am doing wrong here. i have to connect to an oracle 9i database on the network in perl. i was already using oracle9201.jar driver for connecting squirrel-sql client (and am able to connect to the database from that without any issues.) so the driver itself seems good.

but from perl.having setup the DBD::JDBC server, and running on some port (15001) i am not able to connect from inside perl. (both jdbc server and the perl script reside on my box. the oracle database is on a remote box) here is a level2 trace of whats happening:

------
DEBUG: these are the drivers: ExampleP JDBC Proxy Sponge
    DBI 1.38-nothread dispatch trace level set to 2
DEBUG: connecting to JDBC using this conn string -- dbi:JDBC:hostname=lintest.somedomain.com:1790;url=@lintest.somedomain.com:1790:TEST
    -> DBI->connect(dbi:JDBC:hostname=lintest.somedomain.com:1790;url=@lintest.somedomain.com:1790:TEST, some_user, ****)
    -> DBI->install_driver(JDBC) for linux perl=5.006001 pid=8067 ruid=1000 euid=1000
       install_driver: DBD::JDBC version 0.64 loaded from /usr/local/share/perl/5.6.1/DBD/JDBC.pm
    <- install_driver= DBI::dr=HASH(0x81d2fe0)
    -> connect for DBD::JDBC::dr (DBI::dr=HASH(0x81d2fe0)~0x838b0ec 'hostname=lintest.somedomain.com:1790;url=@lintest.somedomain.com:1790:TEST' 'some_user' **** HASH(0x822b9b0))
1 -> trace in DBD::_::common for DBD::JDBC::dr (DBI::dr=HASH(0x838b0ec)~INNER)
1 <- trace= 2 at JDBC.pm line 88
    !! ERROR: 101 'I/O Error '
    <- connect= undef at DBI.pm line 585
    -> errstr in DBD::_::common for DBD::JDBC::dr (DBI::dr=HASH(0x81d2fe0)~0x838b0ec)
       error: 101 'I/O Error '
    <- errstr= 'I/O Error ' at DBI.pm line 588
       DBI connect('hostname=lintest.somedomain.com:1790;url=@lintest.somedomain.com:1790:TEST','some_user',...) failed: I/O Error
DBI connect('hostname=lintest.somedomain.com:1790;url=@lintest.somedomain.com:1790:TEST','some_user',...) failed: I/O Error at ./db.pl line 23
    -> $DBI::errstr (&) FETCH from lasth=HASH
>> DBD::JDBC::dr::errstr
    <- $DBI::errstr= 'I/O Error '
    -> $DBI::errstr (&) FETCH from lasth=HASH
>> DBD::JDBC::dr::errstr
    <- $DBI::errstr= 'I/O Error '
I/O Error at ./db.pl line 23.
    -- DBI::END
    -> disconnect_all for DBD::JDBC::dr (DBI::dr=HASH(0x81d2fe0)~0x838b0ec)
1 -> FETCH for DBD::JDBC::dr (DBI::dr=HASH(0x838b0ec)~INNER 'jdbc_connections')
1 <- FETCH= ( undef ) [1 items] at JDBC.pm line 316
    <- disconnect_all= undef at DBI.pm line 653
! -> DESTROY for DBD::JDBC::dr (DBI::dr=HASH(0x838b0ec)~INNER)
! <- DESTROY= (not implemented) during global destruction

---------------

i noticed that nmap even as root does not show 15001 running, although i have (seemingly) successfully brought up the JDBC server (it said accepting connections and i can see all the prrocs running.)

btw that wasnt the only connection string i used. i used several variants starting from the standard one given in perldoc DBI but those all gave me some errors in JDBC.pm. this format was the one which did not give me any JDBC errors but connection errors.

i am running perl on a debain woody box and java 1.4. (is that an issue?)