On Thu, Mar 07, 2002 at 12:13:49AM -0700, Mark Hazen wrote:
>> I have been trying for weeks to capture the data DBI sends to STDERR
during
>> a trace to anything OTHER than a file. The reason for this is that I'd
like
>> to have tracing on all the time, and writing to a file several hundred
times
On Fri, 8 Mar 2002, Orlando Andico wrote:
...
> I've found a sort-of solution, and it's not an alarm.
>
> $sth = $dbh->prepare ("SELECT * FROM table_to_check FOR UPDATE NOWAIT");
> $rv = $sth->execute;
> $sth->finish;
>
> if ($rv != 0E0) {
> return undef;
> }
>
> # do the update down here
An add
On Thu, 7 Mar 2002, Rob Bloodgood wrote:
...
> > I found the reason why my Radiator Perl module was getting stuck:
> > deadlocks when two RADIUS machines tried to update the same row in a
> > table. Anyway I'm trying to set up an alarm handler to catch this sort of
> > evilness.
>
> I have a THOUG
We're running Oracle 9i on Solaris 5.8, connecting from the
Server itself (DBD::Oracle linked againt the Oracle 9i libs)
and from HP-UX 10.20 workstations (DBD::Oracle linked againt
Oracle 7.3.4) also with no Problems (except a strange TWO_TASK
error relalted to NLS_LANG conversion when working w
Could someone please give me insight as to what might be the issue here. I am
installing DBD::DB2 on a solaris platform. I have already installed the
DB2Connect Client and DBI.
Here is the output from running the installation:
% perl Makefile.PL
Configuring DBD::DB2...
Remember to actually read
Hate to be totally off-topic but: Has anyone ever successfully installed
oracle 9i on Debian? I've done my share of google searches and came up
nothing (except a total kludge of making a dual boot debian/suse, boot
suse - install - oracle, boot deb, mount suse partition)
Anyone???
Thanks
Jay
> I found the reason why my Radiator Perl module was getting stuck:
> deadlocks when two RADIUS machines tried to update the same row in a
> table. Anyway I'm trying to set up an alarm handler to catch this sort of
> evilness.
I have a THOUGHT, not an ANSWER:
I've seen this error message once or
I am using DBI/DBD (current version) with 9i client libs against 9i and
8i databases without any problems. Also tried DBI/DBD with an 8i client
against 8i and 9i databases. No problems seen whatsoever.
I'm not using any 9i specific features, though.
Client machines are running SuSE 7.3 and HP/
Hi,
I have the same problem with solaris 8 , i reinstall
perl and the bin for gcc-2.95,
I compiled perl with:
sh Configure -Dcc='gcc -B/usr/ccs/bin/'
make ..
...
and run the perlxxx/ints/solaris_2.sh before compile
the perl...
The DBI 1.20 /DBD 1.12 should compiled fine then..
bye.
Tim Bunce wrote:
> It's not just the writing to the file. The DBI internals do much
> more work when debug is enabled. Your programs will run much slower.
> Try benchmarking with and without
>
> $h->trace(2, "/dev/null");
Good point. So the question is what exactly do you need to captur
I wrote a script on an NT workstation using AS Perl 5.6.1, DBI 1.14, DBD-Oracle 1.06
and it works fine. It's supposed to run on an NT server and it fails there where the
version of perl is 5.005_02, PPM query shows that DBI and DBD are present but does not
give version information. I looked i
Thanks for clarifying.
Tim.
On Thu, Mar 07, 2002 at 08:34:50AM -0800, Tim Carlson wrote:
> On Thu, 7 Mar 2002, Tim Bunce wrote:
>
> That is a pretty broad statment. Which versions of gcc do you think need
> gnu as? I have gcc-3.0.3 working on Solaris 2.8 and 2.6 with the
> assembler in /usr/cc
On Thu, 7 Mar 2002, Tim Bunce wrote:
That is a pretty broad statment. Which versions of gcc do you think need
gnu as? I have gcc-3.0.3 working on Solaris 2.8 and 2.6 with the
assembler in /usr/ccs/bin/as
To me this sounds more like a problem with a precompiled gcc downloaded
from sunfreeware.co
Hi
I finally reproduce the problem with another system here's the setup
Solaris 8 (sparc dual cpu)
perl v5.6.1
DBI-1.21
DBD-ODBC-0.38
ISLIodbc ODBC (Open DataBase Connectivity) Driver Manager (sparc) 2.11,REV=1.0
RedPoint SnmpQL
This is the script use for the test
**
On Thu, Mar 07, 2002 at 10:21:12AM -, Andy Crichton wrote:
> The prepare call fails
> Can't call method "prepare" on an undefined value
>
> Q? is there a way of doing IN on an array and why can I not convert the
> array into a comma separated list of text for IN, what is undefined?
This erro
On Wed, Mar 06, 2002 at 07:05:06PM -0800, Chris Geen wrote:
> I am attempting to use a "where not exists" sql statement with the DBI and
> am getting the following error message- "DBD::Oracle::db prepare failed:
> ORA-00903: invalid table name (DBD ERROR: OCIStmtExecute/Describe) at
> ../t_dbi.pl
[Changed quoting - I find the "append whole message at bottom" quoting
style *extremely* unreadable]
On 2002-03-07 08:39:41 -0500, Vorce, Tim (T.) wrote:
> > From: Peter J. Holzer [mailto:[EMAIL PROTECTED]]
> > Subject: Re: Using IN with prepare clause
> >
> > > From: Andy Crichton [mailto:[EMAI
You need to use quotes, the correct syntext is
$stmt="SELECT fruit FROM tree WHERE fruit in ('$fruit1','$fruit2')"
-Original Message-
From: Peter J. Holzer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 8:36 AM
To: [EMAIL PROTECTED]
Subject: Re: Using IN with prepare clause
On 2002-03-07 08:16:04 -0500, [EMAIL PROTECTED] wrote:
[Haven't seen the original message, so I'm replying to Tim's instead of
Andy's]
> -Original Message-
> From: Andy Crichton [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 07, 2002 5:21 AM
> To: [EMAIL PROTECTED]
> Subject: Using IN
Andy,
The first step in debugging this sort of problem is to print the select
statement and see if it looks like what you thought it would look like (or
just run the query in sql*plus or whatever to see if it's correct).
For example (assuming that the fruits column is varchar2), does this:
Your gcc us using the wrong assembler. Recent gcc's need to use gnu as.
http://www.google.com/search?as_q=&num=10&btnG=Google+Search&as_epq=error%3A+unknown+opcode&as_oq=&as_eq=&lr=&as_ft=i&as_filetype=&as_qdr=all&as_occt=any&as_dt=i&as_sitesearch=&safe=off
Tim.
On Thu, Mar 07, 2002 at 09:19:04
Hi there,
I'm having problems compiling the perl DBI module for solaris - The
DBI.o fails to compile.
The output is shown below.
Any ideas/help would be appreciated.
Thanks - Gee.
=> make
cp Changes blib/lib/DBI/Changes.pm
cp lib/DBD/Proxy.pm blib/lib/DBD/Proxy.pm
cp lib/DBI/ProxyServer.pm b
I'm converting several MS Access (.mdb) files into a single MySql database.
The core of the script is a call to a COTS converter utility that generates
a temporary data base and automatically takes care of table creation and
data insertion. Then, I (effectively) copy the temporary MySql data base
Hi,
Sorry if this is covered somewhere , I looked about but was unable to
find the answer.
I wish to do something to the effect of:
$stmt="SELECT fruit FROM tree WHERE fruit in (@fruits)"
OR
$stmt="SELECT fruit FROM tree WHERE fruit in ($fruit1,$fruit2)"
The prepare call fails
Can't call met
On Thu, Mar 07, 2002 at 12:13:49AM -0700, Mark Hazen wrote:
> I have been trying for weeks to capture the data DBI sends to STDERR during
> a trace to anything OTHER than a file. The reason for this is that I'd like
> to have tracing on all the time, and writing to a file several hundred times
>
On Thu, 7 Mar 2002 00:13:49 -0700, Mark Hazen wrote:
>The reason for this is that I'd like
>to have tracing on all the time, and writing to a file several hundred times
>per minute would heavily tax my system.
Does it? Opening the file should be the slow process, writing to it once
its open need
26 matches
Mail list logo
