hi there
I'm working with RH 7.0 and Oracle 8.1.5. The installation was no problem and the
Proxy is working
fine. When I try to execute sqls from a script everything works fine. Now I made a
small script and
try to execute sqls which are defined in the proxy.cfg. I get the following message:
err, Unknown SQL query: at
/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/DBI/ProxyServer.pm line
251
the script looks like this:
DBI->trace(4);
use DBI;
$dbh = DBI->connect("dbi:Proxy:hostname=localhost;port=2001;dsn=dbi:Oracle:somewhere",
"***", "***")
|| print "$DBI::errstr";
$sth = $dbh->prepare("test ?") || print "$DBI::errstr";
$sth->execute("90399") || print "$DBI::errstr";
my $hash = $sth->fetchrow_hashref();
my %hash = %{$hash};
$sth->finish;
$dbh->disconnect;
I try to execute the sql "test" which I define in the proxy.cfg
the proxy.cfg looks like this:
require DBD::Oracle;
{
facility => 'daemon',
pidfile => '/var/dbiproxy/dbiproxy.pid',
localport => '2001',
logfile => '/var/log/dbiproxy.log',
mode => 'fork',
clients => [
# Akzeptiere nur die IP-Nummer von ***************** (regexpecs moegl.)
{
mask => '^127\.0\.0\.1$',
accept => 1,
sql => {
'test' => 'SELECT * from TABLE WHERE SOMETHING=(?)'
}
},
]
}
I traced the script:
-> DBI->connect(dbi:Proxy:hostname=localhost;port=2001;dsn=dbi:Oracle:*****, ***, ***)
-> DBI->install_driver(Proxy) for perl=5.006001 pid=3875 ruid=0 euid=0
install_driver: DBD::Proxy loaded (version 0.2003)
New DBI::dr (for DBD::Proxy::dr, parent=, id=)
dbih_setup_handle(DBI::dr=HASH(0x8195da0)=>DBI::dr=HASH(0x8344a74),
DBD::Proxy::dr, 0, Null!)
dbih_make_com(Null!, DBD::Proxy::dr, 172)
<- install_driver= DBI::dr=HASH(0x8195da0)
-> connect for DBD::Proxy::dr (DBI::dr=HASH(0x8195da0)~0x8344a74
'hostname=localhost;port=2001;dsn=dbi:Oracle:****' '***' **** HASH(0x824d1f0))
New DBI::db (for DBD::Proxy::db, parent=DBI::dr=HASH(0x8344a74), id=)
dbih_setup_handle(DBI::db=HASH(0x834f980)=>DBI::db=HASH(0x8361afc),
DBD::Proxy::db, 8193210,
Null!)
dbih_make_com(DBI::dr=HASH(0x8344a74), DBD::Proxy::db, 172)
<- connect= DBI::db=HASH(0x834f980) at DBI.pm line 412.
-> STORE for DBD::Proxy::db (DBI::db=HASH(0x8361afc)~INNER 'PrintError' 1)
STORE DBI::db=HASH(0x8361afc) 'PrintError' => 1
<- STORE= 1 at DBI.pm line 437.
-> STORE for DBD::Proxy::db (DBI::db=HASH(0x8361afc)~INNER 'AutoCommit' 1)
<- STORE= '1' at DBI.pm line 437.
<- connect= DBI::db=HASH(0x834f980)
prepare
-> prepare for DBD::Proxy::db (DBI::db=HASH(0x834f980)~0x8361afc 'test ?')
New DBI::st (for DBD::Proxy::st, parent=DBI::db=HASH(0x8361afc), id=)
dbih_setup_handle(DBI::st=HASH(0x8361acc)=>DBI::st=HASH(0x8366e58),
DBD::Proxy::st, 8361ad8,
Null!)
dbih_make_com(DBI::db=HASH(0x8361afc), DBD::Proxy::st, 172)
<- prepare= DBI::st=HASH(0x8361acc) at televn.cgi line 89.
execute
-> execute for DBD::Proxy::st (DBI::st=HASH(0x8361acc)~0x8366e58 '90399')
!! ERROR: 1 'Server returned error: Failed to execute method CallMethod: Unknown
SQL query: at
/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/DBI/ProxyServer.pm line 251.
'
<- execute= undef at televn.cgi line 91.
DBD::Proxy::st execute failed: Server returned error: Failed to execute method
CallMethod:
Unknown SQL query: at
/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/DBI/ProxyServer.pm line 251.
-> $DBI::errstr (&) FETCH from lasth=DBI::st=HASH(0x8366e58)
>> DBD::Proxy::st::errstr
Server returned error: Failed to execute method CallMethod: Unknown SQL query: at
/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/DBI/ProxyServer.pm line 251.
The Oracle_Home Variable is set.
RH 7.0
Oracle Client 8.1.5
Perl 5.6.1
DBI 1.1.15
DBD::Oracle 1.06
Thanks for your help
Jan-Hendrik
--
Mit freundlichem Gruß
i.A. Jan-Hendrik Petersen
+ KomTel Gesellschaft fuer
+ Kommunikations- und
+ Informationsdienste mbH
+
+ Jan-Hendrik Petersen
+ Nordstaße 2, D-24937 Flensburg
+
+ Fon: +49-461-9090-685, Fax: +49-461-9090-071
+ EMail: [EMAIL PROTECTED], Internet: http://www.komtel.net
+ ----------------------------------------------------------------------------- +
