Re: Decoding data from the database in DBD

2011-05-12 Thread Tim Bunce
it to the previous behaviour. I could have done it the other way around but this default seems more logical to me. If you have any comments before I make this change I'd be happy to hear them. Sounds good to me. Thanks. Tim.

(Fwd) Perl DBI on Mac OS X

2011-05-02 Thread Tim Bunce
- Forwarded message from david_st...@mcafee.com - Date: Mon, 2 May 2011 18:40:11 -0700 From: david_st...@mcafee.com To: tim.bu...@pobox.com Subject: Perl DBI on Mac OS X Hi Tim, Sorry to bother you. I am new to Perl DBI. I have it working fine on my Windows 7 box. I have

Re: General DBI spec Question?

2011-04-18 Thread Tim Bunce
that kind of functionality. Tim. p.s. In this case I'd like to see the Oracle::OCI module revived. It could handle this requirement and much else besides.

Re: Problem: given a dbh, extract the original args passed to connect()

2011-04-11 Thread Tim Bunce
. However, I can't find a way to get those args out of the dbh. Normally I would try looping over the contents of the tied hash, but FIRSTKEY and NEXTKEY both have null method bodies (i.e. { }), so looping is effectively disabled. Any ideas? Tim, would you be amenable to a patch that implemented

(Fwd) Re: DBD::Oracle: table_info, PUBLIC schema

2011-03-21 Thread Tim Bunce
YahooMailWebService/0.8.109.295617 Hi Tim and Steffen, How can I get the sample schema for DBD or scripts for DBD. Any URL. Please send it to me asap. Thanks, Satish Patil - End forwarded message -

Re: One of us can't count....

2011-02-23 Thread Tim Bunce
(some) sense from that perspective. On the other hand, I wouldn't complain if you wanted to create a bug ticket for this. The simplest fix would be for execute() to clear ParamValues when it detects that error. Tim.

Re: Réf. : Re: compile dbi in aix with gcc

2011-02-07 Thread Tim Bunce
Great. Thanks Eric. Tim. On Tue, Jan 25, 2011 at 08:18:46AM -0600, ericbamba...@discover.com wrote: Anecdotally we have used DBI versions 1.5.1 on AIX 5.3 with perl 5.8.8 and DBI 1.6.1.5 on AIX 6.1 with perl 5.12.2. All were (read: had to be) compiled with gcc so I know its possible. We're

Re: DBI 1.611 + DBD::mysql 4.016 = segfaults on Ubuntu 10.10 amd64 ?

2011-02-07 Thread Tim Bunce
On Tue, Jan 25, 2011 at 02:54:30PM +, Tony Esposito wrote: Hello Tim, Just curious, Tim, when is DBI 2.0 to be released? [Fx: Tim stares off into the middle-distance whistling quietly to himself] For Perl 5, possibly never. For Perl 6, sooner than that - but don't hold your breath

Re: When might DBI v2 be released

2011-02-07 Thread Tim Bunce
On Tue, Jan 25, 2011 at 07:25:43AM -0800, Jonathan Leffler wrote: On Tue, Jan 25, 2011 at 06:54, Tony Esposito tony1234567...@yahoo.co.ukwrote: Hello Tim, Just curious, Tim, when is DBI 2.0 to be released? Thanks for all your hard work, by the way. DBI-great_stuff()! IIRC

Re: Downside to ora_envhp=0 to fix OCIHandleAlloc(OCI_HTYPE_ERROR) problem

2011-01-26 Thread Tim Heath
noticeable for our application. Tim

Re: DBI 1.611 + DBD::mysql 4.016 = segfaults on Ubuntu 10.10 amd64 ?

2011-01-24 Thread Tim Bunce
::mysql (I have 4.016) and dbi (1.611), but nothing seems to mention any segfault fixes. I'll try installing the most recent versions from CPAN for now. Any other idea? A stack trace from a core file is always a good place to start. Tim.

Announce DBI 1.616

2010-12-30 Thread Tim Bunce
thanks to Emmanuel Rodriguez. =cut Wishing everyone a New Year of full of joy and peace. Enjoy! Tim.

Re: Connection pooling w/ DBD::Gofer

2010-12-30 Thread Tim Bunce
children would then connect to the local Gofer daemon over a unix socket or maybe localhost:someport. The key issues are the tranasctions and extra db request latency. Tim.

Do you use PostgreSQL PL/Perl?

2010-12-06 Thread Tim Bunce
PL/Perl in the server for? How much PL/Perl code do you have (approximate number of functions and lines)? What kinds of CPAN modules would you like to use in PL/Perl? Thanks! Tim.

Re: There's an error, but $sth-execute returns -1

2010-10-19 Thread Tim Bunce
On Tue, Oct 19, 2010 at 08:59:19AM +0100, Martin J. Evans wrote: On 18/10/10 22:54, Tim Bunce wrote: On Mon, Oct 18, 2010 at 04:45:51PM +0100, Martin J. Evans wrote: State 23000 you are getting is Integrity constraint violation which is an error but note the text on the end of the error

Re: There's an error, but $sth-execute returns -1

2010-10-18 Thread Tim Bunce
, I see that message might get appended even if the code then decides not to change the err value. You could use something like $h-{HandleSetErr} = sub { warn @_; return 0; } to see the second event getting recorded. Tim. So something is a amiss there. Having said that the MS native client reports

Re: There's an error, but $sth-execute returns -1

2010-10-18 Thread Tim Bunce
there's a workaround. (Tim Bunce, if you see this could you clarify what dbd_st_execute is supposed to return as I could not find the full details in DBI::DBD. It would appear DBD::ODBC returns -2 for error, -1 for rowcount not known and a positive number for rows affected). I see it's

Re: DBD SQL::Statement change in Maintainership

2010-09-08 Thread Tim Bunce
doing a lot of work on the DBD::File driver and related modules that underly the drivers that use SQL::Statement. I'm very grateful to them. Tim. On Tue, Sep 07, 2010 at 11:03:21AM +0200, Roger Evans wrote: And a big round of applause for Tim Bunce who has given the community a solid piece

Re: Strange Error

2010-09-04 Thread Tim Bunce
DBI docs) would help identify what's happening when this message (from sv_dump) is produced. Tim.

Re: Strange Error

2010-09-04 Thread Tim Bunce
messes with $SIG{__DIE__}. I will enable tracing later today and report the results. Neither of the two files you sent contain the sv_dump output you're concerned about. So I can't determine where it's coming from. Tim.

(Fwd) DBI Performance for SQL Server

2010-08-26 Thread Tim Bunce
- Forwarded message from Mahesh y mahesh@gmail.com - Date: Thu, 26 Aug 2010 17:29:35 +0530 From: Mahesh y mahesh@gmail.com To: tim.bu...@pobox.com Subject: DBI Performance for SQL Server Hi Tim, Hope you are doing good. I am a software programmer struggling to solve

ANNOUNCE: DBI 1.613

2010-07-26 Thread Tim Bunce
for DBD::File (H.Merijn Brand, Jens Rehsack) Extract dealing with Perl SQL engines from DBD::File into DBI::DBD::SqlEngine for better subclassing of 3rd party non-db DBDs (Jens Rehsack) Updated and clarified documentation for finish method (Tim Bunce). Changes to DBD::File for better

ANNOUNCE: DBI 1.612

2010-07-16 Thread Tim Bunce
Rehsack) Added basic test for DBD::File (H.Merijn Brand, Jens Rehsack) Extract dealing with Perl SQL engines from DBD::File into DBI::DBD::SqlEngine for better subclassing of 3rd party non-db DBDs (Jens Rehsack) Updated and clarified documentation for finish method (Tim Bunce

(Fwd) Cannot install DBI package

2010-06-15 Thread Tim Bunce
- Forwarded message from Joe Vinod joevi...@hotmail.com - Date: Tue, 15 Jun 2010 12:04:21 +0530 From: Joe Vinod joevi...@hotmail.com To: tim.bu...@pobox.com Subject: Cannot install DBI package Hi Tim, I am Joe and manage a test team. We use PERL extensively for our test automation

(Fwd) Help in installing DBD - DB2 for Perl

2010-06-02 Thread Tim Bunce
- Forwarded message from raghav sridharan raghava...@yahoo.co.in - Date: Wed, 2 Jun 2010 06:56:01 +0530 (IST) From: raghav sridharan raghava...@yahoo.co.in To: tim.bu...@pobox.com Subject: Help in installing DBD - DB2 for Perl X-Mailer: YahooMailRC/374.4 YahooMailWebService/0.8.103.269680

Off-topic questions (was: How to suss out module dependencies...)

2010-06-01 Thread Tim Bunce
, helps everyone. Tim.

You (almost certainly) do NOT need to call finish()

2010-06-01 Thread Tim Bunce
not fetched all the data from a statement handle. http://search.cpan.org/~timb/DBI-1.611/DBI.pm#finish Tim.

Announce: DBI 1.611

2010-04-29 Thread Tim Bunce
) Added Note to column_info for drivers which do not support it (Martin J. Evans) Updated dbipport.h to Devel::PPPort 3.19 (H.Merijn Brand) =cut Many thanks to those who've contributed to this release. Enjoy! Tim.

(Fwd) Problems inserting into a CLOB field type using DBI PERL

2010-04-28 Thread Tim Bunce
- Forwarded message from Arshad Mahmood arshad.mahm...@manchester.ac.uk - Date: Mon, 26 Apr 2010 12:52:41 +0100 From: Arshad Mahmood arshad.mahm...@manchester.ac.uk To: Tim Bunce tim.bu...@pobox.com Subject: Problems inserting into a CLOB field type using DBI PERL X-Mailer: Oracle

(Fwd) How to loop through a database, row by row, and select and update one row at a time

2010-04-13 Thread Tim Bunce
- Forwarded message from Troy Mulder mulde...@gmail.com - Date: Mon, 12 Apr 2010 17:48:37 -0400 From: Troy Mulder mulde...@gmail.com To: tim.bu...@pobox.com Subject: How to loop through a database, row by row, and select and update one row at a time Hello Tim (is it Dr. Bunce

Re: Problems with empty/NULL lobs

2010-02-23 Thread Tim Bunce
The Oracle::OCI module might be useful. See lob examples in http://cpansearch.perl.org/src/TIMB/Oracle-OCI-0.06/05dbi.t Tim. On Tue, Feb 23, 2010 at 07:17:20PM +, Martin J. Evans wrote: On 23/02/2010 18:48, John Scoles wrote: Martin Evans wrote: Most likely you are running

Re: Placeholders for profiling?

2010-02-10 Thread Tim Bunce
it works out. Remember that the code ref gets called for _every_ DBI method call, so keep it fast. Tim. p.s. The slides for DBI::Profile in the Advanced DBI Tutorial (2004) on CPAN are out of date http://cpansearch.perl.org/src/TIMB/DBI_AdvancedTalk_2004/sld022.htm I gave a talk at the Italian

(Fwd) DBD::Oracle

2010-01-27 Thread Tim Bunce
Hi Tim, We are re-installing some of our perl packages and I was using what we have now as a template to find the corresponding packages on CPAN. Our version currently is: # Oracle.pm # # Copyright (c) 1994-2005 Tim Bunce, Ireland # # See COPYRIGHT section

Re: HTTP Authentication for Gofer

2010-01-23 Thread Tim Bunce
On Thu, Jan 21, 2010 at 05:04:05PM -0600, Stuart Johnston wrote: The POD for DBD::Gofer::Transport::http says that authentication is not currently supported. Has anyone worked on this? Nope. Would there be any interest in patches? Yes. Thanks! Tim.

Help sought for testing PL/Perl changes destined for PostgreSQL 8.5

2010-01-19 Thread Tim Bunce
to you: https://commitfest.postgresql.org/action/commitfest_view?id=5 Tim. [1] The login page has a link to register yourself. [2] http://archives.postgresql.org/pgsql-hackers/

Re: strange bug with DBI, Sybase, and mod_perl

2010-01-08 Thread Tim Bunce
. Tim. Jon On Jan 7, 2010, at 2:57 PM, Martin J. Evans wrote: Jonathan Swartz wrote: Something in which code is closing STDOUT? I know that mod_perl redirects STDOUT to $r-print... Incidentally the code to reprodce for mysql is even easier - just need one connection. This will do

Re: strange bug with DBI, Sybase, and mod_perl

2010-01-08 Thread Tim Bunce
not fragile as open() is defined to do just that. Thanks for your help in pinpointing this. I'm glad I was able to help. Tim. Jon On Jan 8, 2010, at 1:43 PM, Tim Bunce wrote: On Thu, Jan 07, 2010 at 03:36:21PM -0800, Jonathan Swartz wrote: So, is this a bug in DBI, or in the code

Re: strange bug with DBI, Sybase, sendmail and mod_perl

2010-01-07 Thread Tim Bunce
, =$_) and printf $_\n for 0..100' 421 0 1 2 42 (Using = or = doesn't seem to matter for this simple case.) Tim.

Re: strange bug with DBI, Sybase, and mod_perl

2010-01-07 Thread Tim Bunce
Ah. I think something in the code is closing STDOUT (fd 1) before the handler() is called. The socket that the driver then creates to connect to the server will get fd 2, aka STDOUT, and thus be inherited by the child. Or something like that. Tim. On Thu, Jan 07, 2010 at 10:03:06AM -0800

Re: strange bug with DBI, Sybase, sendmail and mod_perl

2010-01-06 Thread Tim Bunce
) been changed (from the default 2)? Use a system call tracing tool (truss, strace, dtrace etc) to see what's *actually* happening at a low level. Focus on identifying the sybase file descriptor and tracing what happens to it. Report back your findings so we can all play along with you ;-) Tim.

Re: eclipse

2009-12-17 Thread Tim Bunce
On Thu, Dec 17, 2009 at 07:42:45AM -0500, Bretz, Ellen Ms. CIV DSADC wrote: Has anyone used eclipse for perl. If so what are your thoughts? This isn't really the right forum for that kind of question. Try http://perlmonks.org Tim.

Re: data retrieved from database is unexpectedly tainted

2009-12-15 Thread Tim Bunce
a statement then any new values created by that statement are marked as tainted. The 'tainted value seen' flag gets reset for each statement. So I'd guess that you're using a single statement, like a select*_* method, to pass the (tained) SQL in and get the result data back. Tim.

Re: Help saving MySQL

2009-12-15 Thread Tim Bunce
On Tue, Dec 15, 2009 at 07:06:50AM -0700, Mike Howard wrote: So, how do we write to the Eurpoean Commission? Do they have an address? In Monty's post he says: Send this to: comp-merger-regis...@ec.europa.eu If you want to keep us updated, send a copy to e...@askmonty.org Tim. Tim

Re: data retrieved from database is unexpectedly tainted

2009-12-15 Thread Tim Bunce
://search.cpan.org/~rgarcia/perl-5.10.0/pod/perl5100delta.pod Mentions tainting a couple of times, but nothing obviously matches. Tim.

Help saving MySQL

2009-12-14 Thread Tim Bunce
at http://monty-says.blogspot.com/2009/12/help-saving-mysql.html and act on it, if you so choose. If you work for a company that makes use of MySQL then please make sure the relevant managers are aware of the issues. Tim.

Re: How to catch the returned error message.

2009-11-09 Thread Tim Tisdall
If you have something like $dbh-do(); You can get the error code with $dbh-err and the full error message with $dbh-errstr . for more info: http://search.cpan.org/~timb/DBI/DBI.pm#err On Mon, Nov 9, 2009 at 5:37 AM, Parag Kalra paragka...@gmail.com wrote: Hello All, This is my first post

Re: DBI for Perl 5.6.1

2009-11-05 Thread Tim Bunce
The cpan-testers are your (awesome) friends: http://matrix.cpantesters.org/?dist=DBI;maxver=1 Tim. On Thu, Nov 05, 2009 at 02:33:39PM +0100, Patrick Mischler wrote: Hello Which version of DBI (and DBD::mysql) does work with Perl 5.6.1? Regards, Patrick Patrick Mischler Riedweg

Re: collecting some simple profiling statistics

2009-10-24 Thread Tim Bunce
time inside DBI routines (or certain DBI routines). Is there any easy way to do get these numbers? Yes. http://search.cpan.org/perldoc?DBI::Profile http://cpansearch.perl.org/src/TIMB/DBI_AdvancedTalk_2004/sld001.htm Tim.

Re: Does Pg's psql have an equivalent to Oracle's spool cmd?

2009-10-20 Thread Tim Bowden
On Tue, 2009-10-20 at 11:00 +0200, Peter J. Holzer wrote: On 2009-10-20 15:54:30 +0800, Tim Bowden wrote: On Tue, 2009-10-20 at 18:07 +1100, Ron Savage wrote: Hi Folks [for those who don't know the sqlplus (or dbish) spool command: It's similar to the Unix tee(1) command: It copies all

(Fwd) DBD::Sybase

2009-09-17 Thread Tim Bunce
- Forwarded message from greg.sm...@l-3com.com - From: greg.sm...@l-3com.com To: tim.bu...@pobox.com Subject: DBD::Sybase Date: Wed, 16 Sep 2009 14:24:55 -0400 hi Tim, I would greatly appreciate if you could guide or direct me.. I am trying to repair and old Windows 2000 server

(Fwd) DBI: accessing second recordset

2009-09-15 Thread Tim Bunce
- Forwarded message from Yuriy Tretyakov tretyakof...@ukr.net - To: tim.bu...@pobox.com From: Yuriy Tretyakov tretyakof...@ukr.net Date: Tue, 15 Sep 2009 12:31:05 +0300 Hello Tim. I have a very important task, but I'm stopped now because failed to solve one problem. I working

Anyone used Postgres PL/PerlU with Perl profilers or Devel::Cover?

2009-09-15 Thread Tim Bunce
Just checking if there's some prior experience to draw on before I head much further down this road. Tim.

Re: status of ithreads?

2009-08-30 Thread Tim Bunce
Yes. Tim. On Mon, Aug 17, 2009 at 06:03:44PM -0500, Tim Hester wrote: I'd like to have multiple ithreads share a single db connection. The DBD::mysql doc seems to indicate there wouldn't be an issue, but the DBI doc still indicates that is a no go to use a shared connection. However

status of ithreads?

2009-08-17 Thread Tim Hester
make their own connections to the database. Handles can't be shared across threads. using perl 5.8.8, DBI 1.609, DBD::mysql 4.011 mysql 5.0.45-log Is this restriction still needed / enforced? -- Tim Hester Impeva Labs, Inc. O: 850-872-7099 C: 850-832-4216 COMPANY CONFIDENTIAL NOTICE

Re: (Fwd) Question regarding DBI status

2009-08-12 Thread Tim Bunce
_databases_ can do that, but most don't. For those that don't, the client API (in Java or any other language) simply can't provide the information. For those that do the corresponding DBI driver could provide a driver-private attribute to enable table name/aliases in the hash keys. Tim.

Re: Return value of $dbh-prepare() on error

2009-08-07 Thread Tim Bunce
for the failure of my $sth = $dbh-prepare($sql);? prepare() should return undef if it failed. Having said that, returning a statement handle that will fail when executed is valid behaviour, although unusual. (Many drivers can't detect errors in the statement until it's executed.) Tim.

(Fwd) Question regarding DBI status

2009-08-06 Thread Tim Bunce
- Forwarded message from Link McGaughey link.mcgaug...@gmail.com - Date: Wed, 5 Aug 2009 18:41:56 -0400 Subject: Question regarding DBI status From: Link McGaughey link.mcgaug...@gmail.com To: tim.bu...@pobox.com Tim, I found your information from CPAN, and had a question regarding

Re: Specify an array in $sth-execute() ?

2009-08-05 Thread Tim Bunce
this: $sth-execute( $hash_data{firstname}, $hash_data{lastname} ); Using 'hash slice' syntax (http://perldoc.perl.org/perldata.html#Slices) you can shorten to: $sth-execute( @hash_data{firstname, lastname} ); Tim.

Re: Exporting a clob data type

2009-07-13 Thread Tim Tisdall
http://search.cpan.org/~timb/DBI/DBI.pm#LongReadLen_(unsigned_integer,_inherited) On Mon, Jul 13, 2009 at 7:45 AM, Simran Saun simrans...@gmail.com wrote: Hi All, I need to export contents of a table whch has one data type as CLOB. I am able to store it ina file using query, select PROFILE_ID

Re: Installing DBI that works with static version of Perl

2009-07-08 Thread Tim Bunce
Can you explain _why_ you think you need a static version of perl? You're heading into a world of pain, so you'd better have a very good reason to want to go that way. Tim. On Tue, Jul 07, 2009 at 04:09:49PM -0400, Koch, Gina (GE Infra, US) wrote: I have compiled a static version of perl

Re: Installing DBI that works with static version of Perl

2009-07-08 Thread Tim Bunce
On Wed, Jul 08, 2009 at 07:47:37AM -0400, Koch, Gina (GE Infra, US) wrote: Tim: I need to create a perl distribution that I can distribute via a Solaris package. I thought the best way to do this is create a static version. Let me know if you think otherwise. (I am not a perl internals guru

Re: Support for XA

2009-06-18 Thread Tim Bunce
On Thu, Jun 18, 2009 at 11:50:04AM -0700, Darren Duncan wrote: Tim Bunce wrote: On Wed, Jun 17, 2009 at 01:53:36PM -0500, David Dooling wrote: If any of the SQL fails, then all the DB transactions are rolled back. If two databases are being used, and the commit to the first succeeds

bind_params: Not identifying ? as a parameter placeholder

2009-06-17 Thread Tim Bowden
coordinates and SRID (Spatial Reference Id) respectively. I've tried the following code, but it fails. #!/usr/bin/perl -wT use DBI; use strict; my $srid = 4326; my $dbname = test; my $dbuser = tim; my $coord = 7653; my $dbh = DBI-connect(dbi:Pg:dbname=$dbname;host=127.0.0.1,$dbuser) or die can't connect

Re: bind_params: Not identifying ? as a parameter placeholder

2009-06-17 Thread Tim Bunce
On Wed, Jun 17, 2009 at 04:13:35PM +0800, Tim Bowden wrote: my $sth = $dbh-prepare(INSERT INTO mygeom (description, mypoint) VALUES (?, ST_GeomFromText('POINT(? ?)', ?))); $sth-bind_param(1, $_); $sth-bind_param(2, $coord); $sth-bind_param(3, $coord); The argument

Re: bind_params: Not identifying ? as a parameter placeholder

2009-06-17 Thread Tim Bowden
On Wed, 2009-06-17 at 11:23 +0100, Tim Bunce wrote: On Wed, Jun 17, 2009 at 04:13:35PM +0800, Tim Bowden wrote: my $sth = $dbh-prepare(INSERT INTO mygeom (description, mypoint) VALUES (?, ST_GeomFromText('POINT(? ?)', ?))); $sth-bind_param(1, $_); $sth-bind_param(2, $coord

Re: bind_params: Not identifying ? as a parameter placeholder

2009-06-17 Thread Tim Bunce
On Wed, Jun 17, 2009 at 06:37:12PM +0800, Tim Bowden wrote: On Wed, 2009-06-17 at 11:23 +0100, Tim Bunce wrote: On Wed, Jun 17, 2009 at 04:13:35PM +0800, Tim Bowden wrote: my $sth = $dbh-prepare(INSERT INTO mygeom (description, mypoint) VALUES (?, ST_GeomFromText('POINT

Re: Support for XA

2009-06-17 Thread Tim Bunce
, ora_use_proc_connection etc.) See also the Oracle::OCI module. That should give you access from perl to just about everything you can do with OCI. It also integrates well with DBI and DBD::Oracle. Tim.

Re: Support for XA

2009-06-17 Thread Tim Bunce
transaction to commit. If any of the SQL fails, then all the DB transactions are rolled back. If two databases are being used, and the commit to the first succeeds and the commit to the second fails, how does it rollback the first commit? Tim.

Re: What is a good reference for what bind_col types to use when?

2009-06-09 Thread Tim Bunce
to draft up a doc patch to cover this? Tim.

Announce: DBI 1.609

2009-06-09 Thread Tim Bunce
(). =cut Enjoy! Tim.

Re: DBI connect consistently fails from one httpd worker

2009-06-08 Thread Tim Heath
Yes indeed, Tim, ora_envhp = 0 fixed the problem. Many thanks! Tim Tim Bunce wrote: Try passing ora_envhp = 0 in the connect() attributes. If that fixes it then the bug is probably that dbd::oracle should not use a cached environment handle if it's not usable. (and OCIHandleAlloc

Re: DBI connect consistently fails from one httpd worker

2009-06-08 Thread Tim Bunce
You're welcome. In return, please file a bug report at http://rt.cpan.org/Public/Dist/Display.html?Name=DBD-Oracle Tim. On Mon, Jun 08, 2009 at 08:16:40AM -0500, Tim Heath wrote: Yes indeed, Tim, ora_envhp = 0 fixed the problem. Many thanks! Tim Tim Bunce wrote: Try

DBI connect consistently fails from one httpd worker

2009-06-05 Thread Tim Heath
(stock RHEL5 using preforked workers, no multithreading) mod_perl version 2 (stock RHEL5) DBI v1.607 Oracle DBD v1.22 Thanks in advance Tim Heath Qwest Communications

Re: DBI connect consistently fails from one httpd worker

2009-06-05 Thread Tim Bunce
Try passing ora_envhp = 0 in the connect() attributes. If that fixes it then the bug is probably that dbd::oracle should not use a cached environment handle if it's not usable. (and OCIHandleAlloc(OCI_HTYPE_ERROR) is a reasonable way to test that the environment handle is usable). Tim. On Fri

Re: LD_LIBRARY_PATH on x86_64 linux

2009-05-25 Thread Tim Bunce
We're now way off topic so let's drop this thread. Tim.

Re: :ODBC vs. DBD::ADO

2009-05-21 Thread Tim Bunce
is fetched using code like this: @row = map { $_-Value } Win32::OLE::in( $rs-Fields ); for ( @row ) { $_ = $_-As( Win32::OLE::Variant::VT_BSTR() ) if UNIVERSAL::isa( $_,'Win32::OLE::Variant'); } map { s/\s+$// } @row if $sth-FETCH('ChopBlanks'); Tim. -Brian

DBI does not seem to want to handle floats as a numeric type

2009-05-20 Thread Tim Bunce
Anyone want to have a go at exploring and explaining the behaviour seen in https://rt.cpan.org/Ticket/Display.html?id=46231 Tim.

Re: $DBI::neat_maxlen and execute() and debugging

2009-05-08 Thread Tim Bunce
On Thu, May 07, 2009 at 10:03:41PM -0700, Bill Moseley wrote: Hi Tim, On Fri, May 08, 2009 at 12:59:03AM +0100, Tim Bunce wrote: It might be more efficient/effective to use callbacks to enable tracing in just the calls you're interested in. Callbacks are (still) undocumented

Announce: DBI 1.608

2009-05-08 Thread Tim Bunce
docs thanks to Martin J. Evans. Improved DBI::DBD docs thanks to H.Merijn Brand. =cut Enjoy! Tim.

Re: $DBI::neat_maxlen and execute() and debugging

2009-05-07 Thread Tim Bunce
in just the calls you're interested in. Callbacks are (still) undocumented, but the test file is pretty clear: http://cpansearch.perl.org/src/TIMB/DBI-1.608/t/70callbacks.t Tim.

Re: Anyone seen a 24909 (call in progress) error using DBD::Oracle

2009-04-24 Thread Tim Bunce
::Oracle call to leave a handle in a state where a later execute() would cause an error. Another thing to check is forking, in all it's forms, as the sub-process would inherit the file descriptors and could cause problems. Tim.

Re: new question: accurately detecting ? placeholders

2009-04-20 Thread Tim Bunce
; Assuming your database and driver don't offer anything specific, you might find the DBI's (undocumented) preparse() method useful. The only docs are the tests: http://cpansearch.perl.org/src/TIMB/DBI-1.607/t/60preparse.t Tim. p.s. undocumented, unsupported, liable to change yada yada yada

Re: DBD SQL::Statement change in Maintainership

2009-04-19 Thread Tim Bunce
On Sat, Apr 18, 2009 at 10:28:02PM +0100, Tim Bunce wrote: On Fri, Apr 17, 2009 at 01:22:42PM -0700, Jeff Zucker wrote: Hi friends in the DBI community, After many years of maintaining SQL::Statement and various pure-Perl DBDs (RAM, AnyData, File, CSV) I've now finally admitted that I am

Re: DBD SQL::Statement change in Maintainership

2009-04-18 Thread Tim Bunce
of straightening out some of the messes I created in SQL::Statement. I'd also like to thank the many people over the years who sent bug reports and patches and jumped in to help when I needed it, especially Tim Bunce and Dean Arnold. And thanks you you, Jeff, for developing and supporting

Re: PATCH: DBI: misuse of %lx and %ld formats

2009-03-02 Thread Tim Bunce
Thanks Charles. Applied as r12559. Tim. On Fri, Feb 27, 2009 at 05:32:09PM +, Charles Jardine wrote: On 26/02/09 16:31, Charles Jardine wrote: I have built a 64 bit version of Perl 5.10.0 under SLES 10 (x86-64). I am now installing DBI and DBD::Oracle. Both of these modules produce

Re: DBI core dump (in List::Utils)

2009-02-10 Thread Tim Bunce
} It seems that for some reason GvSVn(rmcgv) is returing NULL. I can't imagine why using DBD::Oracle would cause that. Tim. p.s. CC'd to Graham Barr, the author, in case he can help. On Mon, Feb 09, 2009 at 03:36:43PM -0600, Pickett, Mark J wrote: I'm having the same issue as Chris. Here's

Re: Ways of ensuring integers in the database are seen as numbers in perl?

2009-01-28 Thread Tim Bunce
cases (integers with at most 9 (32 bit) resp. 18 (64 bit) digits), but AFAIK it isn't. Your best bet is probably explicitely binding with an approriate type (SQL_INTEGER). That would be the right way to do it, but DBD::Oracle doesn't support it at the moment. Tim.

Re: Ways of ensuring integers in the database are seen as numbers in perl?

2009-01-28 Thread Tim Bunce
() function. Or something like that. Tim.

Re: Ways of ensuring integers in the database are seen as numbers in perl?

2009-01-28 Thread Tim Bunce
but how to nasty little part of the safe cases?? Eh? Tim. Changing from this char *p = (char*)row_data; sv_setpvn(sv, p, (STRLEN)datalen) to something like this double dnum; (void) OCINumberToReal(fbh-imp_sth-errhp, (CONST OCINumber *) row_data

Re: Configure DBI logging to be more specific.

2009-01-15 Thread Tim Bunce
This should help: http://search.cpan.org/~timb/DBI/DBI.pm#ShowErrorStatement_(boolean,_inherited) (In theory all drivers are meant to enbale ShowErrorStatement by default, unless they have a good reson not to, such as a better mechanism built-in.) Tim. On Thu, Jan 15, 2009 at 02:55:53PM +0100

Re: Async I/O with DBI?

2009-01-13 Thread Tim Bunce
AnyEvent::DBI is cool, but only gives very limited access to the DBI. I'd really like to see someone do something similar but using DBD::Gofer to look after the serialization. That would give a much more complete and 'transparent' interface. Tim. On Wed, Jan 14, 2009 at 12:00:32AM +0500

Re: DBI core dump

2008-12-31 Thread Tim Bunce
Try to get a stack trace from the core file. (See the README file, and Devel::CoreStack on CPAN) Tim. On Tue, Dec 30, 2008 at 11:20:16AM -0600, Koester, Chris wrote: All, What would cause DBD to Segmentation coredump? 10793 Segmentation Fault(coredump) I am using perl 5.8.8 with DBI

(Fwd) Views on DBI 2.0

2008-12-29 Thread Tim Bunce
- Forwarded message from Marcin Guzowski mar...@guzowski.info - Date: Mon, 29 Dec 2008 05:14:17 -0800 (PST) From: Marcin Guzowski mar...@guzowski.info To: Tim Bunce tim.bu...@pobox.com Subject: Views on DBI 2.0 Hi Tim, We have developed a distributed system written in Perl

Re: Commiting changes [Was: Re: What is the meaning of the rows value after a select?

2008-12-07 Thread Tim Bunce
the Driver.xst 'driver interface template' (which includes DBD::Oracle), rollback() is automatcally called just before the handle is DESTROYd. I've appended the relevant code. Tim. if (DBIc_ACTIVE(imp_dbh)) { if (!DBIc_has(imp_dbh,DBIcf_AutoCommit)) { /* Application

Re: Adding Hypertable API to DBI

2008-12-02 Thread Tim Bunce
Some searching leads me to believe that Thrift is being used to implement a broker interface to Hypertable. http://qconsf.com/sf2008/file?path=/qcon-sanfran-2008/slides//DougJudd_Hypertable.pdf You might also want to consider http://thrudb.org/ Tim. On Mon, Dec 01, 2008 at 06:28:02PM -0800

Re: DBD::oracle question about auto reconnecting

2008-11-12 Thread Tim Bunce
other server state that would be silently lost by an auto reconnect. So, whatever might give the functionality to reconnect automatically I suppose it'd be the same as doing unless ($dbh-ping) { $dbh= connect ... } The DBI spells that DBI-connect_cached(...) Tim.

Re: DBD::Oracle + BLOB

2008-10-31 Thread Tim Bunce
? (That would be painful or broken when working with LONGs, were the driver would actually allocate a buffer that big, but I don't think it does that with LOBs.) Tim.

Re: DBD::Oracle + BLOB

2008-10-31 Thread Tim Bunce
to a database specific type *that has the same semantics*. (It may also require some extra logic to massage the value to get the behaviour as defined by the standard. If a driver can't implement the behaviour required by the standard then it should probably return an error. Tim. I was able

Re: DBD::Oracle + BLOB

2008-10-30 Thread Tim Bunce
creating a new portability problem. Generally, driver authors should aim to do what ODBC (and ideally DBD::ODBC) does for these types. Tim. The tack I am looking at is some sort of flag where you tell you DBD to explicitly describe before an execute. Not sure if that could even be done

Re: DBD::Oracle + BLOB

2008-10-30 Thread Tim Bunce
On Thu, Oct 30, 2008 at 09:00:38PM +0100, H.Merijn Brand wrote: On Thu, 30 Oct 2008 15:06:00 -0400, John Scoles [EMAIL PROTECTED] wrote: Again Tim and his wisdom of the ages comes to the rescue. A quick look at DBD::ORacle and his suggestion will take only a few seconds to do

<    1   2   3   4   5   6   7   8   9   10   >