Re: DBI-Performace-Problem

2002-12-02 Thread Tim Bunce
ectified. > > Should be trying this in the next couple of weeks. > > I'll let you know how it turns out. Please do! I expect to be working on DBD::Oracle again very soon, after what has become an extended period of, er, stability. :) Tim. > Jared > > > > On

Re: Problem installing perl+dbi+dbd-oracle on HP-UX

2002-12-02 Thread Tim Bunce
Possibly due to errors in Oracle's own Makefile' (which DBD::Oracle copies chunks of). What do those lines in the generated Makefile say (and pay special attention to whether lines start with spaces or tabs). Tim. On Mon, Dec 02, 2002 at 12:35:52PM -, Carlos Barroso wrote: > Hy. > I'm trying

Re: DBI 1.32 Warning

2002-12-02 Thread Tim Bunce
On Mon, Dec 02, 2002 at 12:30:04PM +0100, H.Merijn Brand wrote: > On Mon 02 Dec 2002 12:28, "H.Merijn Brand" <[EMAIL PROTECTED]> wrote: > > On Mon 02 Dec 2002 02:32, David Wheeler <[EMAIL PROTECTED]> wrote: > > > Tim, > > > > > > Got just one warning with the new 1.32 release on Mac OS X 10.2.2: >

Re: Problem installing perl+dbi+dbd-oracle on HP-UX

2002-12-02 Thread Tim Bunce
don't email me directly, always use the dbi-user mailing list. Thanks. > -Original Message- > From: Tim Bunce [mailto:[EMAIL PROTECTED]] > Sent: segunda-feira, 2 de Dezembro de 2002 13:23 > To: Carlos Barroso > Cc: [EMAIL PROTECTED] > Subject: Re: Problem installing

Re: Problem installing perl+dbi+dbd-oracle on HP-UX

2002-12-02 Thread Tim Bunce
> > Making x2p stuff > make[1]: Entering directory `/tmp/perl_dbi/perl-5.6.1/x2p' > make[1]: *** No rule to make target `', needed by `hash.o'. Stop. > make[1]: Leaving directory `/tmp/perl_dbi/perl-5.6.1/x2p' > make: *** [translators] Error 2 >

Re: Problem installing perl+dbi+dbd-oracle on HP-UX

2002-12-02 Thread Tim Bunce
On Mon, Dec 02, 2002 at 11:19:41AM -0500, Jeff Urlwin wrote: > > > > I've deleted the lines as you said, and the following error appeared: > > > > make: *** No rule to make target ` > `miniperlmain.o'. Stop. > > I do not believe the dbi-users mailing list is the best place to get > help on

Re: Connecting MS Access Database with DBI

2002-12-03 Thread Tim Bunce
On Tue, Dec 03, 2002 at 02:03:49AM -0800, Timothy Johnson wrote: > > You never actually "use" your DataBase Driver, so DBI has no idea how to do > what you've asked. I think this is what the error message is trying to tell > you. Try installing DBD::ODBC and then putting the line "use DBD::ODBC"

Re: Missing prereq in 1.32?

2002-12-03 Thread Tim Bunce
On Mon, Dec 02, 2002 at 11:49:19AM -0800, Scott Alexander wrote: > I'm just started to prep a new machine for our web cluster. Using CPAN, > I tried to install DBI. It made everything just fine, but when it went > to tests, it failed t/40profile. The test uses Time::HiRes which wasn't > installe

Re: Fw: Strange web log errors

2002-12-03 Thread Tim Bunce
On Mon, Dec 02, 2002 at 06:25:35PM -0800, Dean Arnold wrote: > Someone reported the following error occuring w/ DBI 1.32 and > DBD::Chart: > > > [Tue Dec 3 00:55:57 2002] nul: DBD::Sponge::db do failed: No rows > > attribute supplied to prepare at c:/Perl/site/lib/Deakin/Base.pm line > > 2822.

(Fwd) DBD::Oracle, Solaris 8, Oracle 9 and big bug on libclntsh

2002-12-03 Thread Tim Bunce
- Forwarded message from "Luc VEILLON (ERMES)" <[EMAIL PROTECTED]> - Delivered-To: [EMAIL PROTECTED] Date: Tue, 3 Dec 2002 16:14:59 +0100 (MET) From: "Luc VEILLON (ERMES)" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: DBD::Oracle, Solaris 8, Oracl

Re: threads,dbi 1.30,odbc 0.43, perl 5.8 (AS)

2002-12-03 Thread Tim Bunce
Please show a (very) small example script. Tim. On Tue, Dec 03, 2002 at 02:31:01PM -0500, Trey Gregory wrote: > I'm sure this has been answered before, but I wasn't able to find anything in the >archives. (Is there a search interface available?) > > I have a multithreaded program. My problem is

Re: DBI 1.31 on MacOS X 10.2.2 with no prior install of DBI - problem maybe...

2002-12-03 Thread Tim Bunce
Thanks Jonathan. I'll look into it. The Makefile is probably missing a dependency. Tim. On Sun, Dec 01, 2002 at 08:24:26PM -0800, Jonathan Leffler wrote: > Dear Tim, > > An odd one, and I'm not sure whether you even want to do anything > about it, but... > > I was using 'cpan' from Perl 5.8.0

Re: attempting to use DBI::Profile

2002-12-03 Thread Tim Bunce
DBI 1.21 is very old. Download and install the full DBI-1.32 distribution. (Read the Changes file carefully for changes that may affect you) Send all emails to [EMAIL PROTECTED] (as per the README). Tim. On Tue, Dec 03, 2002 at 01:18:26PM -0500, Jeff Nucciarone wrote: > > Greetings. > > I wan

Re: threads,dbi 1.30,odbc 0.43, perl 5.8 (AS)

2002-12-03 Thread Tim Bunce
On Tue, Dec 03, 2002 at 03:47:29PM -0500, Trey Gregory wrote: > Here is a short example. Short overview is: main connects, queries, then spawns >thread (test_thread) which creates a new connection and attempts to query. The error >received is: > > thread failed to start: DBD::ODBC::dr connect fa

Re: DBD::Pg 1.20 uncompatible with Postgres 7.3?

2002-12-03 Thread Tim Bunce
On Tue, Dec 03, 2002 at 10:56:47AM -0800, David Wheeler wrote: > On Tuesday, December 3, 2002, at 10:34 AM, Jeff Boes wrote: > > >Nope, not quite: > > > >$ grep pg_ Pg.pm > > > >of Pg.pm 1.13 will show you that it relies on pg_database, pg_user, > >pg_class, pg_description, pg_attribute, pg_type,

Re: (Fwd) DBD::Oracle / alarm() problem

2002-12-04 Thread Tim Bunce
On Tue, Dec 03, 2002 at 05:16:27PM -0800, Josh Wilmes wrote: > Tim- > > Your suggestion did seem to do the trick. However, this is going to be > pretty painful for us to implement, as new new build of perl uses a > different architecture-specific directory (sun4-solaris-thread-multi vs. > sun

Re: (Fwd) DBD::Oracle / alarm() problem

2002-12-04 Thread Tim Bunce
;m not wild about > > either option, really. > > > > Is this our only choice at this point, or is there any way to work around > > this in the DBD world? > > > > Do you know what's happening here? I presume that it's got something to > >

Getting Oracle version number via DBI (was: DBD::Pg 1.20 uncompatible with Postgres 7.3?)

2002-12-04 Thread Tim Bunce
On Wed, Dec 04, 2002 at 08:20:52AM +1100, Steve Baldwin wrote: > I'm sure this has been asked many times before, but Tim's reply here > prompted me to ask again. Is there any way to access the DB version (as > per your example of get_info(18) below) from DBI. For example as an > attribute of the

Re: Any timeframe on DBD:Oracle supporting array inserts

2002-12-04 Thread Tim Bunce
On Tue, Dec 03, 2002 at 04:07:36PM -0500, John Milardovic wrote: > >From a thread last month > (http:[EMAIL PROTECTED]/msg14522.html) it was > indicated that DBD-Oracle 1.13 would support array inserts. That was mostly wishful thinking. > Can anyone > (Tim?) confirm this? If so is there a projec

Re: $sth->{ParamValues} using mysql

2002-12-04 Thread Tim Bunce
On Thu, Jan 02, 2003 at 06:03:25PM -0600, Moritz von Schweinitz wrote: > hi there, > > somehow i can't get $sth->{ParamValues} working using DBD::mysql (i > guess it should support that feature, or?). > > anyhow, the docs say: > - > ParamValues (hash ref, read-only) > Ret

Re: Any timeframe on DBD:Oracle supporting array inserts

2002-12-04 Thread Tim Bunce
On Wed, Dec 04, 2002 at 12:24:15PM -0600, Stephen Clouse wrote: > > On Wed, Dec 04, 2002 at 11:21:53AM +0000, Tim Bunce wrote: > > On Tue, Dec 03, 2002 at 04:07:36PM -0500, John Milardovic wrote: > > > >From a thread last month > > > (http:[EMAIL PROTECTED]/msg1

Re: driver specific prefix

2002-12-05 Thread Tim Bunce
On Thu, Dec 05, 2002 at 10:54:14AM -0600, Stephen R. Wilcoxon wrote: > On Wed 2002/12/04 21:38:12 PST, Jonathan Leffler <[EMAIL PROTECTED]> write > s: > > Stephen R. Wilcoxon wrote: > > > Is it possible to get the driver specific prefix programmatically with a > > > database handle (or statement h

(Fwd) Question about Oracle DBD:DBI

2002-12-06 Thread Tim Bunce
- Forwarded message from "Pauley, Alan" <[EMAIL PROTECTED]> - Delivered-To: [EMAIL PROTECTED] From: "Pauley, Alan" <[EMAIL PROTECTED]> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Subject: Question about Oracle DBD:DBI Date: Thu, 5 Dec 2002 16:24:02 -0700 I'm a little confused can you

Re: Fetching large Oracle CLOBS

2002-12-06 Thread Tim Bunce
The t/long.t test script in the distribution tests with >>64KB strings. Take a look at that. Your bind_param_inout call is wrong. You're missing the maxlen param. Tim. On Thu, Dec 05, 2002 at 10:08:25PM +0100, Johann Kandlbauer wrote: > Hi all, > > we're trying to read Oracle 9.0.1/2 CLOBS whic

Re: Prepare misbehavior

2002-12-09 Thread Tim Bunce
If ISSU.iss_typ is a CHAR type field then you should call bind_param ans specify SQL_CHAR type. See the FAQ. Tim. On Sun, Dec 08, 2002 at 02:58:20PM -0500, Rozengurtel, Daniel wrote: > Hello all gurus, > > I am writing a program that fetches counts for each security type th

Re: error ORA-28011 during connect

2002-12-10 Thread Tim Bunce
On Mon, Dec 09, 2002 at 03:43:57PM +0800, [EMAIL PROTECTED] wrote: > While trying to connect to an Oracle db (8.1.7.2) I get the following > message: > DBI->connect(aojprd) failed: ORA-28011: the account will expire soon; change > your password now (DBD SUCCESS_WITH_INFO: OCISessionBegin) > > How

Re: DBD::Oracle 1.12 on Oracle 9iR2 9.2.0.2 test errors (again)

2002-12-10 Thread Tim Bunce
On Mon, Dec 09, 2002 at 12:01:25PM -, Ben Middleton wrote: > Hello again, > > I am still not having any luck in getting the tests to pass. It appears to > be the CLOB re-reading that is failing. > > I have checked all the usual places for help. I have also tried creating a > test stub that do

Wherefore art thou DBI::Shell? (was: multiple DBI::Format's in CPAN installing to different locations, and $VERSION bug)

2002-12-10 Thread Tim Bunce
On Mon, Dec 09, 2002 at 09:43:41AM -0800, David Dyck wrote: > > DBI::Format comes with > > DBI-1.32 in lib/DBI/Format.pm as VERSION 11.4 > and > DBI-Shell-11.9in lib/DBI/Format.pm as VERSION 11.8 > > According to the .packlist files DBI installs Format.pm in > /usr

(Fwd) DBD::Oracle

2002-12-10 Thread Tim Bunce
- Forwarded message from Smith Chad - chasmi <[EMAIL PROTECTED]> - Delivered-To: [EMAIL PROTECTED] From: Smith Chad - chasmi <[EMAIL PROTECTED]> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Subject: DBD::Oracle Date: Mon, 9 Dec 2002 14:08:13 -0600 I am having problems compiling this on A

Re: t/10examp failed on solaris8

2002-12-11 Thread Tim Bunce
I'm not sure why it's happening, but unless you depend on Tainting I think you could ignore that test failure. Tim. On Wed, Dec 11, 2002 at 10:04:44AM +0100, [EMAIL PROTECTED] wrote: > The test t/10examp failed with perl 5.005_03 for sun4-solaris. > > > > t/10examp...Insecure dependen

Re: Problem installing DBI: "can't locate Time/HiRes.pm in @INC"

2002-12-11 Thread Tim Bunce
On Wed, Dec 11, 2002 at 03:50:14PM -0500, Francis Hwang wrote: > I'm doing a server migration and having trouble installing DBI. t/40profile > isn't compiling, I guess, because it can't find Time/HiRes: > > It seems like this is a prereq that's going to be taken o

Re: Interesting problem with Cache::MemoryCache

2002-12-12 Thread Tim Bunce
On Wed, Dec 11, 2002 at 03:20:59PM -0700, Ken Miller wrote: > I'm playing around with using Cache::MemoryCache to store some database > 'objects'. However, when I stuff an object into the cache, and the cache > goes out of scope, I get these messages: > > (in cleanup) dbih_getcom handle D

Re: Oracle::OCI make test failure

2002-12-15 Thread Tim Bunce
On Thu, Dec 12, 2002 at 04:56:25PM -0700, Ron Reidy wrote: > extra.xsh: In function `XS_Oracle__OCI_oci_buf_len': > extra.xsh:51: warning: assignment from incompatible pointer type > extra.xsh:52: warning: assignment from incompatible pointer type Possibly unrelated, but best to fix that. See the

Re: Problem building DBI >1.30

2002-12-15 Thread Tim Bunce
On Fri, Dec 13, 2002 at 04:33:11PM -0500, Crown David T. (DNREC) wrote: > Can I have an authoritative answer on whether this is the case? If so > I'll throw it up on the faq. thanks Google does authoritative answer's for DBI... just add "bunce" to the query :) http://www.google.com/search?as_q=bu

Re: Wherefore art thou DBI::Shell? (was: multiple DBI::Format's in CPAN installing to different locations, and $VERSION bug)

2002-12-15 Thread Tim Bunce
On Fri, Dec 13, 2002 at 06:43:47PM -0500, Thomas A. Lowery wrote: > > It turned out that Tom had used a bunch of recent perl features that > > would have meant the DBI would no longer pass tests on many systems > > (although some would be okay after installing some more modules). > > So at the last

Re: DBI 1.30 make test problem

2002-12-15 Thread Tim Bunce
I wasn't able to test with 5.005 prior to release. [Note that I've given notice that the DBI won't support 5.005 much longer. You should give serious consideration to upgrading your perl soon. Both 5.6.1 and 5.8.0 are excellent releases of perl.] Meanwhile, you could try commenting out the "use s

Re: DBI 1.30 make test problem

2002-12-16 Thread Tim Bunce
On Sun, Dec 15, 2002 at 09:48:47PM -0500, Matthew O. Persico wrote: > On Sun, 15 Dec 2002 22:12:43 +, "Tim Bunce" <[EMAIL PROTECTED]>said: > >I wasn't able to test with 5.005 prior to release. > > > >[Note that I've given notice that the DBI won&

Re: Test failure with DBI 1.32 on MacOS X

2002-12-16 Thread Tim Bunce
On Mon, Dec 16, 2002 at 08:56:26AM +0100, Christian Schaffner wrote: > Hi Tim > > I am the fink (http://fink.sf.net) package maintainer of the DBI perl > module for MacOS X. I tried to update the package to version 1.32 and > got the following test error: > > ... > t/10examp...1..245 >

Re: unexpected results with perl and mysql

2002-12-16 Thread Tim Bunce
Use trace! (see the docs) Tim. On Mon, Dec 16, 2002 at 11:37:18AM -0500, chad kellerman wrote: > Ney guys, > > I am trying to fetch and array form a table and I am not getting the > results I thought I would get: > > I thought it was quote simple but when I print them outwell you'll > s

(Fwd) Oracle 9i Release 2(64 bit) on Solaris8 64 bit and DBD 1.12

2002-12-18 Thread Tim Bunce
- Forwarded message from Sarabjit Singh <[EMAIL PROTECTED]> - Delivered-To: [EMAIL PROTECTED] Date: Wed, 18 Dec 2002 12:20:05 +0800 From: "Sarabjit Singh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: Oracle 9i Release 2(64 bit) on Solaris8 64 bit and DBD 1.12 Hi Tim We have 9i

(Fwd) Enquiry

2002-12-19 Thread Tim Bunce
- Forwarded message from Abhishek_Gupta <[EMAIL PROTECTED]> - Delivered-To: [EMAIL PROTECTED] From: Abhishek_Gupta <[EMAIL PROTECTED]> To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Enquiry Date: Thu, 19 Dec 2002 13:03:44 +0530 Hi, I was searching thru the net and saw an article in a

Re: Unicode in DBD::Pg

2002-12-19 Thread Tim Bunce
On Wed, Dec 18, 2002 at 06:09:33PM +, Dominic Mitchell wrote: > David Wheeler wrote: > >On Wednesday, December 18, 2002, at 01:27 AM, Dominic Mitchell wrote: > >>% psql -l > >>List of databases > >> Name| Owner | Encoding > >>---+--+--- > >> dom |

Re: Unicode in DBD::Pg

2002-12-19 Thread Tim Bunce
On Thu, Dec 19, 2002 at 01:30:50PM -, Dominic Mitchell wrote: > Tim Bunce wrote: > > High bit doesn't always mean uft8 - may be latin1 etc etc. > > I realise this. Also, this utf8 flag toggling should only occur when the > field is a text field and not any other

Re: Unicode in DBD::Pg

2002-12-19 Thread Tim Bunce
On Thu, Dec 19, 2002 at 03:23:34PM +, Dominic Mitchell wrote: > Tim Bunce wrote: > >Maybe drivers could use something like > > > > $sth->bind_col( 1, \$foo, { CharSet => ... } ); > > > >to indicate that a column is UTF8. > > It's a little

Re: Using DBI::Proxy with DBIx::Procedure::Oracle

2002-12-20 Thread Tim Bunce
On Thu, Dec 19, 2002 at 03:58:45PM -0500, Ted Gilchrist wrote: > Hello, > > I have been happily using DBD::Proxy for some time now. But now > I would like to expand my horizons and use something like > DBIx::Procedure::Oracle. Is this possible? I'd guess you haven't tried. Always the best way t

Re: text problem with ODBC

2002-12-29 Thread Tim Bunce
On Sat, Dec 28, 2002 at 11:06:32AM -0800, Michael A Chase wrote: > On Sat, 28 Dec 2002 14:01:28 -0500 Jeff Thies <[EMAIL PROTECTED]> wrote: > > > I'm getting this error when I try to retrieve a field that is a text > > field (memo, blob, or whatever Access calls it). > > > > (1: [Microsoft][OD

Re: Problem with login as sysdba in DBI/DBD::Oracle

2002-12-30 Thread Tim Bunce
On Tue, Dec 24, 2002 at 07:31:00AM -0800, Jared Still wrote: > > The problem you are having is most likely due to your > use of v$session_connect_info. Getting your own sessions > SID and using it to choose the correct row from v$session_connect_info > is notoriously tricky. > > Try doing this i

Re: Oracle 8i and DBD 1.0X performance.

2002-12-30 Thread Tim Bunce
On Thu, Dec 26, 2002 at 11:13:54AM -0500, Eric Robinson wrote: > Hi all, > > When using Oracle 8i and DBD 1.0X we see very poor performance when > accessing > data across the WAN. It appears from our testing that it does single row > fetches > to retrieve the data. Setting RowCacheSize and RowsI

Re: Response

2003-01-03 Thread Tim Bunce
On Fri, Jan 03, 2003 at 03:56:52AM +0200, Boris Penchev wrote: > Dear All, > > I has this fromlem when I have a lot of MySQL request. Now i do not have free time >to explain this problem, but I give you smal > example: > my $sth = $dbh->prepare(qq~SELECT id, name FROM all~) || die "$DBI::errstr\n

Re: $sth->finish

2003-01-03 Thread Tim Bunce
On Fri, Jan 03, 2003 at 05:01:53AM +0200, Boris Penchev wrote: > Dear All, > > 1. Yes, I know that if you have prepare you can make a lot of execute of it, and >that i can make this query in start of my program > or in one module. > 2. I think that is a good idea to declare $id and $name in while

Re: DBI V 1.32/ODBC V 1.01. Select * from x works, Select a,b from x fails

2003-01-03 Thread Tim Bunce
On Fri, Jan 03, 2003 at 07:08:25PM +1100, Ron Savage wrote: > On Thu, 2 Jan 2003 23:17:10 -0800 (PST), Michael A Chase wrote: > >Comments interspersed. > > >Fortunately it is part of the trace() output. > > Nevertheless, this is still a bug in DBI/Other. It's probably related > to the fact that

Re: Detecting active statement handles

2003-01-03 Thread Tim Bunce
On Fri, Jan 03, 2003 at 01:35:15PM +1100, Steve Baldwin wrote: > I am getting the following error on disconnect ... > > DBI::db=HASH(0x104dd094)->disconnect invalidates 1 active statement > handle (either destroy statement handles or call finish on them before > disconnecting) at yyy line xxx >

Re: $sth->finish

2003-01-03 Thread Tim Bunce
On Fri, Jan 03, 2003 at 07:57:01AM -0800, Michael Peppler wrote: > On Fri, 2003-01-03 at 02:42, Tim Bunce wrote: > > On Fri, Jan 03, 2003 at 05:01:53AM +0200, Boris Penchev wrote: > > > Dear All, > > > > > > 1. Yes, I know that if you have prepare you can make

Re: $sth->finish

2003-01-03 Thread Tim Bunce
On Fri, Jan 03, 2003 at 06:34:36PM -0500, Paul Boutros wrote: > See question below: > > On Fri, 3 Jan 2003, Tim Bunce wrote: > > On Fri, Jan 03, 2003 at 07:57:01AM -0800, Michael Peppler wrote: > > > On Fri, 2003-01-03 at 02:42, Tim Bunce wrote: > > > > On F

Re: Detecting active statement handles

2003-01-03 Thread Tim Bunce
On Sat, Jan 04, 2003 at 07:53:20AM +1100, Steve Baldwin wrote: > I assume this is the sort of thing you're talking about ... > > -> DESTROY for DBD::Oracle::st (DBI::st=HASH(0x105ec244)~INNER) > > I'm not sure how this helps me. I can see a statement handle is being > destroyed, but how do I

Re: Detecting active statement handles

2003-01-05 Thread Tim Bunce
ent} attribute of it's child sth's because it doesn't keep a copy of the references. If it did there would be a reference loop. An alternative would be to include the {Statement} attribute of an sth in the trace log when it's DESTOY'd. That would be easier to code. Tim.

Re: $dbh->ping() not pinging?

2003-01-05 Thread Tim Bunce
I don't know if this is relevant but DBD::mysql checks for a lost connection in many places in the code and will automatically try to reconnect 'behind the scenes' (except when AutoCommit is off). Maybe there's some interaction/bug with that logic. Hopefully a trace would show what's going on. Ti

(Fwd) DBI::Shell vs. dbMan

2003-01-05 Thread Tim Bunce
http://search.cpan.org/author/MILSO/dbMan-0.29/ - Forwarded message from Milan Sorm <[EMAIL PROTECTED]> - Delivered-To: [EMAIL PROTECTED] Date: Sat, 4 Jan 2003 05:50:56 +0100 From: Milan Sorm <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: DBI::Shell vs. dbMan User-Agent: Mutt/1.5.1i

Re: Problem with login as sysdba in DBI/DBD::Oracle

2003-01-06 Thread Tim Bunce
:Oracle or that I have an older version > thereof. However, I have downloaded this package recently (the day I > wrote the first mail) with ppm. > > Any suggestion? Thanks. > > > > -Original Message- > > From: Tim Bunce [SMTP:[EMAIL PROTECTED]] > >

Re: CLOB substrings

2003-01-07 Thread Tim Bunce
On Tue, Jan 07, 2003 at 10:22:19AM -0500, [EMAIL PROTECTED] wrote: > Dear Tim Bunce: > > I've been porting a number of my company's apps from Sybase to Oracle, > using DBI as the primary database interface, and ran into a problem I hope > you can help me with; I haven&#

Re: [dbi] Re: SQL Server Invalid string...

2003-01-07 Thread Tim Bunce
On Tue, Jan 07, 2003 at 09:28:19AM -, [EMAIL PROTECTED] wrote: > > On 06-Jan-2003 Jeff Urlwin wrote: > > [snip] > >> > >> BTW, SQLConnect (the ODBC 1.0 function DBD::ODBC can use) has > >> a limit on the size of the string you can pass in the first > >> argument (I think it is 32). DBD::ODB

Re: Bug: DBI issues wrong (ie previous) SQL upon error

2003-01-07 Thread Tim Bunce
Thanks for the test case. I'll look into it. Tim. On Tue, Jan 07, 2003 at 07:54:16PM +1100, Ron Savage wrote: > Folks > > #!/usr/bin/perl > use strict; > use warnings; > use DBI; > # - > my($dbh) = DBI -> connect > ( > 'dbi:mysql:test', 'user', 'pass', > { >

Re: [dbi] Re: SQL Server Invalid string...

2003-01-08 Thread Tim Bunce
On Tue, Jan 07, 2003 at 10:04:30PM -0500, Jeff Urlwin wrote: > > > > > > The only situation I've seen that can be a little confusing is this: > > > > > > DBI->connect('dbi:ODBC:dsnname', 'dbuser', 'dbpass') > > > > > > works > > > > > > and > > > > > > DBI->connect('dbi:ODBC:DSN=dsnname', 'dbu

Re: DBD Oracle CLOBs on UTF8 database

2003-01-08 Thread Tim Bunce
On Wed, Jan 08, 2003 at 09:50:16AM -, Ben Middleton wrote: > Hello, > > Last month I reported a problem I was having with testing the DBD Oracle > module on Oracle 9.2.0.2. The tests were failing on the CLOB section. > > It turns out that my problem was due to my database character set having

Re: DBI namespace

2003-01-08 Thread Tim Bunce
Thanks. It's being discussed, with the author, on the [EMAIL PROTECTED] mailing list. Tim. On Mon, Jan 06, 2003 at 09:56:22PM +0100, [EMAIL PROTECTED] wrote: > Hi Tim, > > Someone uploaded a module called 'DBI::Simple' to CPAN. > > I believe you don't want the DBI:: namespace to be used by othe

(Fwd) DBD::Oracle - interface

2003-01-09 Thread Tim Bunce
- Forwarded message from [EMAIL PROTECTED] - Delivered-To: [EMAIL PROTECTED] Subject: DBD::Oracle - interface To: [EMAIL PROTECTED] From: [EMAIL PROTECTED] Date: Thu, 9 Jan 2003 10:55:55 +0100 Hi! Sorry for my bad English... I have a question according to your DBD::Oracle-interface... I

Re: Problem with login as sysdba in DBI/DBD::Oracle

2003-01-15 Thread Tim Bunce
n operation, that somebody must have used this > > parameter before. On the other hand, my example is so trivial, that I do > > not see what could be wrong in it. My suspicion is that I lack some > > package belonging to DBD::Oracle or that I have an older version > > thereof. However

Re: bind_param "success" when it should fail

2003-01-15 Thread Tim Bunce
Thanks. I'll fix it. Tim. On Wed, Jan 15, 2003 at 02:38:08PM -0500, Roels, Steven wrote: > Hello, > > I found what seems to be a bug (or at least a change in behavior I don't > understand) affecting DBI 1.30 (I haven't checked a later version). > > Specifically, I had accidentally given bind_pa

Re: Problem with DBD::Proxy and Apache::DBI

2003-01-15 Thread Tim Bunce
On Mon, Jan 13, 2003 at 02:08:12PM -0500, Bob Showalter wrote: > I'm using Apache::DBI under mod_perl to manage connections to a remote > database using DBD::Proxy. My problem is that Apache::DBI is not properly > issuing a rollback to DBD::Proxy handles in the PerlCleanupHandler. > > The relevant

(Fwd)

2003-01-21 Thread Tim Bunce
- Forwarded message from Mustafa Attaree <[EMAIL PROTECTED]> - Delivered-To: [EMAIL PROTECTED] From: "Mustafa Attaree" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: Date: Fri, 17 Jan 2003 11:17:30 +0530 I have been using Perl in my company extensively since last 3 yrs i have requl

Re: Problem with login as sysdba in DBI/DBD::Oracle

2003-01-21 Thread Tim Bunce
On Thu, Jan 16, 2003 at 01:41:55PM -, Steve Haslam wrote: > > Hmmm, I haven't used apptrace on Solaris, but using ltrace on Linux: Ah, cool. Thanks for demonstrating that. > bash# ltrace -e `nm -D $ORACLE_HOME/lib/libclntsh.so.8.0 | awk '$3 ~ /^OCI/ > { print $3 }' | perl -le 'print join(","

Re: [patch] making tests locale independent

2003-01-21 Thread Tim Bunce
Does that work on Windows? and Mac OS? and VMS? and ... Tim. On Tue, Jan 21, 2003 at 08:15:06PM +0100, Christian Hammers wrote: > Hi > > Currently the regression tests fail when using a locale that produces > something else than "No such file or directory". Please apply the > attached patch. >

Re: DBI-1.32, IRIX compile warnings - DBI.xs

2003-01-23 Thread Tim Bunce
On Thu, Jan 23, 2003 at 08:59:47AM -0500, Blake, Paul wrote: > > "DBI.xs", line 919: warning(1178): argument is incompatible with > corresponding > format string conversion > (IV)DBIc_MY_H(imp_xxh), (IV)SvRVx(DBIc_MY_H(imp_xxh)), > ^ > > Is this serious? No. > Make tes

(Fwd) DBD::ODBC Transaction Error with Oracle

2003-01-29 Thread Tim Bunce
- Forwarded message from [EMAIL PROTECTED] - Delivered-To: [EMAIL PROTECTED] Date: Thu, 30 Jan 2003 13:14:36 +0530 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: DBD::ODBC Transaction Error with Oracle User-Agent: Internet Messaging Program (IMP) 3.0 X-Originating-IP: 192.168.2.214

Re: DBI crash w/ Perl 5.8 and perl_clone()s

2003-01-30 Thread Tim Bunce
Thanks. I plan to change it to just do DBIS->logfp = PerlIO_stderr(); Let me know if that won't work for you. Tim. On Wed, Jan 29, 2003 at 12:13:07PM -0800, Todd Richmond wrote: > There is special code in dbi_bootinit() in DB.xs for Perl5.8 only that calls >fp_dup() to change the logfp variabl

Re: Perl OO - Dynamic method call

2003-01-30 Thread Tim Bunce
This is too off-topic to be starting a thread about. Please take it elsewhere. Thanks. Tim. On Thu, Jan 30, 2003 at 05:45:00PM +0100, NYIMI Jose (BMB) wrote: > Is it possible to do something similar with Java ? > > José. > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAI

Re: Running DBI in a Safe compartment

2003-01-31 Thread Tim Bunce
Safe is best viewed as a failed experiment. It has many problems. Someone on perl5-porters has recently started work on it again so there may be some progress. Check the perl5-porters archives. Tim. On Thu, Jan 30, 2003 at 11:19:58AM -1000, Franck PORCHER wrote: > Hello, > > I'm trying to use DB

Re: platform independence and ISNULL/nolock with MsSQL?

2003-02-03 Thread Tim Bunce
See also http://search.cpan.org/src/TIMB/DBI-1.32/lib/DBI/Const/GetInfo/ODBC.pm Tim. On Sun, Feb 02, 2003 at 09:46:06PM -0500, Jeff Urlwin wrote: > Perldoc DBI :) > > DBI has the minimal values documented. For DBD::ODBC, you can look up > SQLGetInfo on http://msdn.microsoft.com (among other pla

Re: Bradley Baetz contact info

2003-02-11 Thread Tim Bunce
Goggle says [EMAIL PROTECTED] http://www.rosat.mpe-garching.mpg.de/mailing-lists/dbi/2002-12/msg00013.html Tim. On Tue, Feb 11, 2003 at 01:41:08PM -, Jonathan Hall [Dial] wrote: > Hi dbi-users, > > Do any of you know how I can contact Bradley Baetz? > > According to the DBI 1-32 Changes fi

(Fwd) Perl 5.8.0 / DBI 1.25 large data transfer - broken?

2003-02-11 Thread Tim Bunce
- Forwarded message from Thomas Good <[EMAIL PROTECTED]> - Delivered-To: [EMAIL PROTECTED] X-Authentication-Warning: q8.nrnet.org: tomg owned process doing -bs Date: Tue, 11 Feb 2003 10:10:04 -0500 (EST) From: Thomas Good <[EMAIL PROTECTED]> X-X-Sender: [EMAIL PROTECTED] To: [EMAIL PROTECT

Re: An interesting DBD::Oracle OSAuth bug

2003-02-12 Thread Tim Bunce
On Tue, Feb 11, 2003 at 01:58:31PM -0800, Christopher R. Baker wrote: > > Here's an interesting little bug that's been driving me crazy and a quick fix to it. >It only appears when using Oracle's OS authentication on a script called with the -w >flag > > #!/usr/local/bin/perl > > use s

Re: dbi_time() - microseconds patch for win32 [DBI 1.32]

2003-02-12 Thread Tim Bunce
On Wed, Feb 12, 2003 at 04:41:34PM +0100, Smejkal Petr wrote: > Tim, > > why don't you take advantage of Time::HiRes instead of your own dbi_time() >implementation. I believe, perhaps wrongly, that a Win32 build of perl defined it's own gettimeofday() which dbi_time() would then use. Notice, fo

Re: Q: Supported data types per verdor?

2003-02-13 Thread Tim Bunce
On Thu, Feb 13, 2003 at 06:56:50PM +1100, Ron Savage wrote: > Folks > > Is there, in DBI, a vendor-independent call which will return a > usable list of data types per vendor? > > I'm thinking of things like tinyint, smallint, etc, when I say data > type. perldoc DBI Tim.

Re: DBD::Sybase and DBD::Oracle inconsistency

2001-08-14 Thread Tim Bunce
and destroys England. All because execute returned '0E0' on > select statements. ;-) Well, since I'm moving to Ireland in a few weeks... :-) Tim. > > -Original Message- > > From: Tim Bunce [mailto:[EMAIL PROTECTED]] > > Sent: Monday, August 13, 2001 3:27

Re: DBI 1.19 installation errors (make -j3)

2001-08-14 Thread Tim Bunce
On Tue, Aug 14, 2001 at 04:45:10PM +0200, Ton Verhagen wrote: > Dear All, > > I am experiencing some problems installing DBI-1.19 on a clean RH7.1 system > running perl-5.6.1 > make: *** No rule to make target `blib/arch/auto/DBI/Driver.xst', needed by > `Perl.xsi'. Stop. > make: *** Waiting

Re: 1.19 breaks simple @ISA stuff?

2001-08-15 Thread Tim Bunce
On Wed, Aug 15, 2001 at 02:32:04PM -0400, Phil R Lawrence wrote: > The following simple tests show something changed from 1.15 to 1.19 when it > comes to inheriting and ultimately subclassing the DBI. Can anyone help me > see what it is? > > This simple script works fine with our new Perl 5.6.1

Re: Binding cursors: what's going wrong here?

2001-08-16 Thread Tim Bunce
Try a $update->bind_param_inout(..., { ora_type => ORA_RSET }) so oracle knows you're passing a cursor. Use trace to see more detail. Tim. On Wed, Aug 15, 2001 at 06:14:28PM -0700, Rob McMillin wrote: > Revisions: > > Oracle 8.1.7.1.1 (8i release 3) > RedHat 6.2 > Perl 5.6.0 > DBD::Oracle 1.07

Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08

2001-08-16 Thread Tim Bunce
On Thu, Aug 16, 2001 at 03:41:06PM +0200, Oleg Mechtcheriakov wrote: > > The point is that connection from perl script failes whereas the connection > with SQLPLUS works OK. With what command line, exactly? > P.S. Forgot to say that to get to that point we had to recompile Perl and > DBI/DBD wi

Re: [Fwd: Re: general.t error]

2001-08-16 Thread Tim Bunce
On Thu, Aug 16, 2001 at 12:16:02PM -0500, Dana Kaempen wrote: > I *am* the SysAdmin on this system. *BG* > > We haven't done anything as far as modifying the warnings - this is a straight 4.3.3 >install. The Perl version is 5.6.0. I understand that we CAN ignore this error, but >I'm a bit le

Re: Binding cursors: what's going wrong here?

2001-08-16 Thread Tim Bunce
On Thu, Aug 16, 2001 at 01:49:28PM -0700, Rob McMillin wrote: > Tim Bunce wrote: > > > Try a $update->bind_param_inout(..., { ora_type => ORA_RSET }) so > > oracle knows you're passing a cursor. Use trace to see more detail. > > Okay, specifics? While I got

Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08

2001-08-17 Thread Tim Bunce
t > > ==> > > Select is made just to make sure that it really works:-) And it is really > the Oracle instance on the remote host as can be seen from version > numbers... > > Reg's > Oleg > > > > > > -Original Message- > >

Re: DBI-1.19 leak?

2001-08-17 Thread Tim Bunce
Keep removing bits till the leak stops to find out which bit leaks. Tim. On Fri, Aug 17, 2001 at 01:30:51AM +0200, Toni Andjelkovic wrote: > the following code appears to leak memory with > DBI-1.19, but not with DBI-1.18. i tried with > perl-5.6.1. > > can anyone confirm this? > > # --- > use

Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08

2001-08-17 Thread Tim Bunce
e just to make sure that it really works:-) And it is really > the Oracle instance on the remote host as can be seen from version > numbers... > > Reg's > Oleg > > > > > > -Original Message- > > From: Tim Bunce [mailto:[EMAIL PROTECTED]] &g

Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08

2001-08-17 Thread Tim Bunce
- how big would be slow-down? This big |<-->| Try it. Tim. > Reg's > Oleg > > > -Original Message- > > From: Tim Bunce [mailto:[EMAIL PROTECTED]] > > Sent: Friday, August 17, 2001 1:26 PM > > To: Oleg Mechtcheriakov > > Cc: 'Tim

Re: DBI-1.19 leak?

2001-08-17 Thread Tim Bunce
On Fri, Aug 17, 2001 at 04:32:31PM +0200, Toni Andjelkovic wrote: > Tim Bunce wrote on Fri, Aug 17 2001 (11:51:18 +0100): > > Keep removing bits till the leak stops to find out which bit leaks. > > even this leaks: > > my $dbh = DBI->connect(...); > $dbh->disco

Re: trailing whitespace

2001-08-22 Thread Tim Bunce
On Wed, Aug 22, 2001 at 03:22:53PM -0700, Tim Harsch wrote: > I have this problem where I think DBD::Oracle truncated tailing whitespace > from some input so I searched the archives and I ran accross this thread, > where someone states that DBD::Oracle trims trailing whitespace by default. > > ht

Re: :Proxy and bind_param (with ORACLE)

2001-08-23 Thread Tim Bunce
On Thu, Aug 23, 2001 at 03:57:18PM +0200, Oleg Mechtcheriakov wrote: > OK, > > sorry for a delay, I was not in the office. > > The diff files are attached. The changes could be actually too fast and > dirty -- I'm just occasional programmer so may be I missed some hidden magic > behind of these

Re: Problem with DBD::Oracle with mod_perl

2001-08-23 Thread Tim Bunce
On Thu, Aug 23, 2001 at 11:19:22AM -0700, Kyle Oppenheim wrote: > 3. Apache::DBI intercepts the connect(), looks in it's hash and sees that it > already has a connection. It pings the handle, fails, and deletes the entry > from the hash. That's the last refcount on the dbh, so DESTROY gets call

Re: is DBD::Oracle 1.08 recommended for production environments?

2001-08-24 Thread Tim Bunce
On Fri, Aug 24, 2001 at 01:49:36PM -0700, Gavin Sherlock wrote: > Hi, > I noted that 1.07 specifically said it was not recommended for > production environments. I wondered if the same was true of 1.08, as it > doesn't say anything one way or the other, I've not heard of any significant pr

ANNOUNCE: DBI 1.20

2001-08-24 Thread Tim Bunce
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.20.tar.gz size: 191676 bytes md5: 71002061526134cb4e0417e47a6b5b66 Changes in DBI 1.20,24th August 2001 WARNING: This release contains two changes that may affect your code. : Any code using selectall_hashref(), which was added in March 2001,

<    5   6   7   8   9   10   11   12   13   14   >