Hi. I posted this question to the author of JDBC and he proposed that I
post it here.

I'm trying to execute the following code:

#!/usr/bin/perl
use JDBC;
use strict;
JDBC->load_driver("oracle.jdbc.driver.OracleDriver");
my $url = "jdbc:oracle:thin:haha/pa...@server.haha.com:1521:lsd1";
my $con = JDBC->getConnection($url);
my $sql = "SELECT TABLE_NAME FROM USER_TABLES";
my $ps  = $con->prepareStatement($sql);
my $rs  = $con->executeQuery();

while ($rs->next) {
  my $foo = $rs->getInt(1);
  my $bar = $rs->getString(2);
  print "row: foo=$foo, bar=$bar\n";
}

And I get the following error:

lsnas003 # perl ./haha
You are not allowed to invoke method prepareStatement in class
oracle.jdbc.driver.T4CConnection: Class InlineJavaUserClassLink can not
access a member of class oracle.jdbc.driver.PhysicalConnection with
modifiers "public synchronized" at (eval 56) line 927
 at ./haha line 12

Any thoughts?

TIA,
Jeff



Reply via email to