[Sqlrelay-discussion] FreeBSD

[Arturo L. <kin...@gm...>]

Hello,

- I'm trying to connect from a FreeBSD box to an oracle server running on
RH.

- SQLRelay is up and running fine on RH box.  Wrote test Perl Script and am
able to insert/select from a table on RH box.

- On Freebsd box , I installed from ports p5-sqlrelay.  When I run the same
script that i used on the RH server, it hangs on Fetch .
The insert occurs , but the script never returns....


- anything obvious I"m mising here ?


oracle@oractest2[tests]=3D>./testsqlr.pl -S sqlr_sequioa
testing connection thru sqlrelay
Connecting to listener...
Inet socket: dbdev1:1531
Authenticating with listener : dbuser:xxxx
No authentication error.
Must Not Reconnect.
Authenticating with connection : dbuser:xxxx
No authentication error.
Setting AutoCommiton...
Sending Query:
insert into arthur values(3,'doors')
Length: 36
Requesting a new cursor.
Sending 0 Input Bind Variables:
Sending Output Bind Variables:
Send Column Info: yes
Skipping and Fetching
Skipping 0 rows
Fetching 0 rows
Checking For An Error... none.
Getting Cursor ID...
Cursor ID: 0
Previous result set was not suspended.
Parsing Column Info
Actual row count: unknown
Affected row count: 0
Column count: 65537
Receiving Output Bind Values:
(null)=3D
(null)=3D
(null)=3D
^C

-- perl snippet

# use SQLRelay API
  # --SQLRelay::Connection->new(server, port, socket, user, password,
retrytime, tries);

$dbh=3DSQLRelay::Connection->new("$host",$port,"","$dbuser","$dbpassword",0=
,1);
  $sql=3DSQLRelay::Cursor->new($dbh);
  $dbh->debugOn();
  $dbh->autoCommitOn();
  $sql->prepareQuery("insert into arthur values(3,'doors')");
  $sql->executeQuery();
  $dbh->endSession();


-- connection log output

done waiting for listener
releasing announce mutex
done releasing announce mutex
done announcing availability...
waiting for client...
pass succeeded
done waiting for client
client session...
getting command...
done getting command
authenticate
authenticate...
authentication was done on listener
getting command...
done getting command
autocommit...
autocommit on
getting command...
done getting command
getting a cursor...
found a free cursor:
0
done getting a cursor
new query
handling query...
getting query...
querylength:
36
query:
insert into arthur values(3,'doors')
getting query succeeded
getting input binds...
done getting input binds
getting output binds...
done getting output binds
getting send column info...
send column info
done getting send column info...
processing query...
preparing/executing...
commit or rollback check...
commit or rollback needed
done with commit or rollback check
processing query succeeded
done processing query
returning result set header...
returning row counts...
sending row counts...
actual rows unknown
affected rows: 1
done sending row counts
done returning row counts
column info will be sent
returning column counts...
done returning column counts
sending column type format...
id's
done sending column type format
returning column info...
done returning column info
returning output bind values
0
done returning output bind values
done returning result set header
handle query succeeded
returning result set data...

< manual Cntrl-C of perl script>


returning result set data failed
ending session...
aborting all busy cursors...
0
done aborting all busy cursors
committing...
done committing...
resetting autocommit behavior...
setting autocommit off...
done setting autocommit off...
done resetting autocommit behavior...
done ending session
waiting for client to close the connection...
done waiting for client to close the connection...
closing sockets from a previously suspended session...
done closing sockets from a previously suspended session...
done with client session
decrementing session count...
acquiring session count mutex
done acquiring session count mutex
0
releasing session count mutex
done releasing session count mutex
done decrementing session count
waiting for available database...
database is available
database is available
initializing session...
done initializing session...
announcing availability...
acquiring announce mutex
done acquiring announce mutex
handoff=3Dpass
signalling listener to read
done signalling listener to read
waiting for listener


thanks

Art