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

2009-01-28 Thread Tim Bunce
ng precision. DBD::Oracle could be smart enough to recognize > the safe 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: 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 1

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

(Fwd) Views on DBI 2.0

2008-12-29 Thread Tim Bunce
- Forwarded message from Marcin Guzowski - Date: Mon, 29 Dec 2008 05:14:17 -0800 (PST) From: Marcin Guzowski To: Tim Bunce Subject: Views on DBI 2.0 Hi Tim, We have developed a distributed system written in Perl that needs to maintain multiple db connections across multiple

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

2008-12-07 Thread Tim Bunce
ormix definitely rolls back incomplete > transactions. For drivers using 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. i

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
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
they see a bind with { TYPE => ... } is internally map the international standard type number 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

Re: DBD::Oracle + BLOB

2008-10-31 Thread Tim Bunce
't set LongReadLen to "as much memory as you have"? (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-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

Re: DBD::Oracle + BLOB

2008-10-30 Thread Tim Bunce
be sure to read the ODBC manual to ensure you can implement the exact semantics. Otherwise you're just 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 w

(Fwd) DBI.pm

2008-10-22 Thread Tim Bunce
- Forwarded message from John Rowan <[EMAIL PROTECTED]> - Date: Wed, 22 Oct 2008 09:50:23 -0400 From: John Rowan <[EMAIL PROTECTED]> Subject: DBI.pm Good day Tim. I need to steal some of your time. I run a content management system from PlainBlack Software called Web

Re: DSN corruption

2008-09-16 Thread Tim Bunce
Use DBI->trace() (or DBI_TRACE env var) to see what's happening. Tim. On Tue, Sep 16, 2008 at 10:34:55AM +1000, Ron Savage wrote: > Hi Folks > > OS: Debian. > > I just used aptitude to install Postgres V 8.3.3, and recompiled DBD::Pg > V 2.10.3. > > >Fro

Re: strange error with local and LongReadLen

2008-09-14 Thread Tim Bunce
it stores the 10. Using trace() at a suitable level should show the STORE method calls. Tim.

Re: MySQL support for NULL in WHERE clause

2008-08-11 Thread Tim Bunce
Thanks Siward. Can you confirm what version of mysql server you used, and what options it was using (like ansi mode)? Can anyone else confirm the results with old or new mysql versions, and perhaps offer an example stored procedure. Tim. On Sun, Aug 10, 2008 at 01:13:10AM +0200, Siward de

Re: Bug in DBD::Oracle v 1.21 ?

2008-08-06 Thread Tim Bunce
as a binary string. In which case you need to use pack("H*",...). (I might be wrong though, it's been a while since I've used RAW.) Tim.

Re: Perl+DBI question [C1]

2008-07-29 Thread Tim Bunce
", "make", and "make test" you should "make install" to install the appropriate files into the appropriate directories. You can change where the files get put using either the INSTALL_BASE=... or PREFIX=... arguments to "perl Makefile.PL", See "perldoc ExtUtils::MakeMaker" for more information. Tim.

Re: DBI::Gofer howto?

2008-07-28 Thread Tim Bunce
On Mon, Jul 28, 2008 at 10:57:23AM -0500, Brian Millett wrote: > Tim Bunce escribío: >>> Any pointers on how to setup a simple stateless proxy with >>> DBI::Gofer::mod_perl would be nice. >> >> The docs say: >> >> ---snip--

Re: DBI::Gofer howto?

2008-07-28 Thread Tim Bunce
perl-script PerlHandler DBI::Gofer::Transport::mod_perl ---snip--- did you try that? Tim.

Re: Volunteers sought to help with or take over Oracle::OCI

2008-07-21 Thread Tim Bunce
recent Oracle versions (it's bound to need some build changes after all these years). We can coordinate via [EMAIL PROTECTED] Meanwhile, I'll move the code to a public repository. Thanks! Tim.

Volunteers sought to help with or take over Oracle::OCI

2008-07-20 Thread Tim Bunce
ve before it's ready for prime-time. Interesting? Interested? Tim.

(Fwd)

2008-07-12 Thread Tim Bunce
- Forwarded message from Ejaz <[EMAIL PROTECTED]> - From: Ejaz <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Date: Sat, 12 Jul 2008 17:39:17 +0300 Dear sir, As a favour Please could you tell me DBD-Oracle.xxx version can be installed on Solaris 10x6 or not ??? Ejaz

Re: DBI 1.605 $dbh->ping crashes Perl (seg fault) when autoreconnect=1 and connection goes away (at least with DBD::mysql)

2008-07-08 Thread Tim Bunce
ql_ping function in the mysql client library. Disabiling mysql_auto_reconnect is probably a good idea anyway as auto reconnection is unsafe (ie you could loose a lock and not know). You're more likely to get help is you can post a stack trace from the core file. Tim.

Emails from rt.cpan.org to dbi-users@perl.org

2008-07-01 Thread Tim Bunce
I've taken steps to get this fixed, but it may take a few days. Tim. On Tue, Jul 01, 2008 at 03:24:04AM -0400, Robert Roggenbuck via RT wrote: > http://rt.cpan.org/Ticket/Display.html?id=36696 > > > Can You please remove the address 'dbi-users@perl.org' from an

Re: 2 part question for DBI-1.604

2008-06-21 Thread Tim Bunce
used to build the perl executable itself. Build and install a new perl, then use that perl to build DBI etc. Tim.

Re: No line number with RaiseError in DBD::Sybase

2008-06-19 Thread Tim Bunce
7;d guess that that's because sybase error messages tend to end with a newline character. Hopefully that's a simple fix for Michael to get into the next release. You could always send a patch to help out... Tim.

ANNOUNCE: DBI 1.605

2008-06-16 Thread Tim Bunce
trace message to DBD::Gofer transport class. Added $drh->dbixs_revision method. Added explicit LICENSE specification (perl) to META.yaml =cut Enjoy! Tim.

Re: Error in DBD::Sybase 1.08 handling of severe 5702 error

2008-06-13 Thread Tim Bunce
On Fri, Jun 13, 2008 at 07:29:29AM +0200, Michael Peppler wrote: > Tim Bunce wrote: >> >> I've appended a patch that seems to fix the problem, but I don't know if >> it's doing the right thing in the best way. For example, I tried >> adjusting the "

Error in DBD::Sybase 1.08 handling of severe 5702 error

2008-06-12 Thread Tim Bunce
;severity > 10" to "severity >= 10" in the code below but that caused some tests to fail. Michael, any chance you could review this and get it (or a better fix) released soonish? Tim. --- DBD-Sybase-1.08/dbdimp.c2007-04-19 11:31:19.0 -0700 +++ DBD-Syb

Re: Perl - connecting to Oracle

2008-05-21 Thread Tim Bunce
Nevertheless, I've seen several instances of people not understanding that the "<*>" was added to the statement by DBD::Oracle as a marker when it reports the error. Changing it to something unambiguous would help. Tim. On Wed, May 21, 2008 at 05:42:17PM +0800, Paul Gall

Re: Perl - connecting to Oracle

2008-05-21 Thread Tim Bunce
On Tue, May 20, 2008 at 07:44:33PM -0400, John Scoles wrote: > No the <*> is DBI way of pointing to where the error is. Seems like a common misunderstanding. Perhaps the "<*>" should be changed to something like "" Tim.

Re: How Can I use ssh in my perl code

2008-05-19 Thread Tim Bunce
See http://www.catb.org/~esr/faqs/smart-questions.html Especially the "Choose your forum carefully" section near the start. perlmonks.org is probably a good forum to ask. Tim. On Mon, May 19, 2008 at 07:56:43PM +0530, [EMAIL PROTECTED] wrote: > Hi Matt, > > Thanks

Re: DBD::ODBC and cancel()

2008-05-14 Thread Tim Bunce
; Is this a known sequencing problem ? Is Active not getting > set until the rows start returning ? If so, shouldn't it get > set immediately upon calling SQLExecute ? I don't think it should be checking the Active flag at all. Active (which is poorly named) wouldn't be set for an UPDATE statement, for example, but you'd still want to be able to cancel it. Tim.

Re: DBI::_new_handle leak?

2008-05-12 Thread Tim Bunce
me with a small self-contained example that demonstrates a leak in the DBI. (Either by using only drivers shipped with the DBI, or demonstrating the leak with more than one third-party driver.) Tim.

Re: Unable to install DBD::ODBC on OSX Leopard 10.5.2

2008-05-06 Thread Tim Bunce
you suggests he thought > you have an old DBI. Are you absolutely sure DBI 1.604 is installed in an > accessible path? Just installing DBI 1.604 is not enough. The key point is that the driver must be recompiled *after DBI 1.604 is installed* in order for the driver to pick up this particular change. Tim.

(Fwd) Perl DBI and MySQL

2008-05-06 Thread Tim Bunce
- Forwarded message from "Dorp, Ronald van (W&O SO OPS NET FIA Beheer)" <[EMAIL PROTECTED]> - Subject: Perl DBI and MySQL Date: Tue, 6 May 2008 16:24:59 +0200 From: "Dorp, Ronald van (W&O SO OPS NET FIA Beheer)" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] X-ESAFE-STATUS: Mail allowed X-ESAF

Pay no attention to that DBI callback behind the curtain

2008-05-01 Thread Tim Bunce
I found an interesting use for the (undocumented) DBI callback mechanism recently. You might find it interesting (in lieu of documentation, for now). http://blog.timbunce.org/2008/05/01/pay-no-attention-to-that-callback-behind-the-curtain/ Tim.

Re: problem with DBD::ODBC and placeholders [SEC=UNCLASSIFIED]

2008-04-29 Thread Tim Bunce
which would be a bug anyway. If the driver is capable of mapping execute() arguments to ":N" style placeholders then the original code should work. If it's not then a useful error message should be generated. > but I'd change your SQL to use ? for parameters anyway as > it is more portable and quicker in DBD::ODBC. Perhaps if Tim is reading > this he could clarify whether it was ever his intention that the example > above should work? I'll add a note to the docs (hopefully) clarifying the issue. Tim.

(Fwd) DBI on AIX

2008-04-28 Thread Tim Bunce
- Forwarded message from János <[EMAIL PROTECTED]> - To: [EMAIL PROTECTED] From: János <[EMAIL PROTECTED]> Subject: DBI on AIX Date: Mon, 28 Apr 2008 13:06:37 -0400 X-YaleITSMailFilter: Version 1.2c (attachment(s) not renamed) Tim, I want to run the test bench for my

Re: Unable to install DBD::ODBC on OSX Leopard 10.5.2

2008-04-21 Thread Tim Bunce
I suspect you're using an old version of DBI (I'd guess <= 1.55). Try using a more recent version. Tim. On Mon, Apr 21, 2008 at 01:35:08PM +0100, Neil Beddoe wrote: > > Thanks for looking at this Martin. I'm a bit out of my depth here. > > The li

Re: Multiple selectrow_array calls with statement handle error

2008-04-17 Thread Tim Bunce
On Wed, Apr 16, 2008 at 12:12:47PM -0700, Douglas Wilson wrote: > On Tue, Apr 15, 2008 at 2:30 PM, Tim Bunce <[EMAIL PROTECTED]> wrote: > > > Try this (completely untested) patch to the DBI: > > like I said...it works for me, but if that's the fix, then > you&

Re: Multiple selectrow_array calls with statement handle error

2008-04-15 Thread Tim Bunce
handle if not already */ +if ( (mg = mg_find(SvRV(sth),'P')) ) +sth = mg->mg_obj; } else { /* --- prepare --- */ (For a quick test it's probably easiest to apply it to the preprocessed Driver.xsi in the DBD::Sybase directory after a 'make'.) Tim.

Re: Multiple selectrow_array calls with statement handle error

2008-04-14 Thread Tim Bunce
On Thu, Apr 10, 2008 at 10:47:32PM -0800, Douglas Wilson wrote: > On Thu, Apr 10, 2008 at 3:36 PM, Tim Bunce <[EMAIL PROTECTED]> wrote: > > On Thu, Apr 10, 2008 at 11:15:30AM -0700, Douglas Wilson wrote: > > > > Are you *certain* that that code is running with DBI 1.6

Re: Multiple selectrow_array calls with statement handle error

2008-04-10 Thread Tim Bunce
uck on an old DBI version try something like this as a workaround: sub DBI::st::DELETE { my ($h, $key) = @_; delete $h->{$key} } Tim.

Re: Multiple selectrow_array calls with statement handle error

2008-04-10 Thread Tim Bunce
my_id = ?'; > my $sth = $dbh->prepare($sql); > my $id = 10600; > my $total; > ( $total ) = $dbh->selectrow_array( $sth, undef, $id ); > ( $total ) = $dbh->selectrow_array( $sth, undef, $id ); Code looks fine (it's okay to use an $sth instead of sql for the first arg). Looks like a driver bug at first sight. A DBI trace should shed more light on it. Tim.

Re: execute() failing with: Not an error!

2008-04-02 Thread Tim Bunce
I'm able to try at > the moment). Any ideas before I start submitting bugs to RT? I believe it's an error from DBD::SQLite Google http://www.google.com/search?q=sqlite+error+%2B21 suggests http://www.sqlite.org/cvstrac/wiki?p=LibraryRoutineCalledOutOfSequence Tim. > Cheers,

Re: TDS (M$ SQL Server) in the high-latency environments

2008-03-30 Thread Tim Bunce
S does > roundtrips to fetch the data... that's my guess... Im going to sit down with > Wireshark to see what's going on exactly, but meanwhile > > Does anyone have any experience with that, or have any good pointers to > documentation / info on that? I wasn't able to find anything decent on the > Net :( You might find DBD::Gofer useful. Tim.

Re: Automatically managing inactiveDestroy property.

2008-03-25 Thread Tim Bunce
Sounds like you could just set InactiveDestroy on all handles by default, but then turn it off in the parent process just before it disconnects/exits. You could also possibly play games overriding CORE::GLOBAL::fork() and CORE::GLOBAL::system(). Tim. On Mon, Mar 24, 2008 at 12:04:48PM -0400

Re: Statement handle still Active: prepare_cached

2008-03-25 Thread Tim Bunce
re what you're saying here, but the warning is generated by prepare_cached() in DBI.pm using carp(). > I'm also really curious why I can't repeat > this behavour on my machine, but *every* CPAN tester sees this result. There's always an answer, you just have to dig deep enough to find it. Perhaps you're using a different version of some key module(s), like DBD::SQLite. Tim.

Cwd failing on PA-RISC2.0-thread-multi-LP64 (was: New DBI-1.604)

2008-03-25 Thread Tim Bunce
That error doesn't look like a DBI problem, they're not even DBI tests. So I'm not sure what you're asking. Tim. On Mon, Mar 24, 2008 at 04:39:34PM -0400, Richard T Malafa wrote: > Tim, > Does the new DBI-1.604 support Perl 64 bit, & dynamic linking??? > > I

Re: ODBC 3.5 spec ?

2008-03-24 Thread Tim Bunce
org may help. > Last clue I had was some MSDN CD circa 2000. Sounds plausible. You may be able to find a copy of the "ODBC 3.5 Developers Guide" book by Roger Sanders (pub Mc Graw Hill). Have fun! Tim.

ANNOUNCE: DBI 1.604

2008-03-24 Thread Tim Bunce
ore useful for manual testing. =cut Enjoy! Tim.

ANNOUNCE: DBI 1.603

2008-03-24 Thread Tim Bunce
to avoid spurious failures on slow systems. Added options to t/85gofer.t so it's more useful for manual testing. =cut Enjoy! Tim.

Re: Google SoC: Fame and Fortune ($4500) await you!

2008-03-20 Thread Tim Bunce
r as I think Tim's > plan was to make that compatible with memcached It already is: http://search.cpan.org/~timb/DBI/lib/DBD/Gofer.pm#cache Tim. > Cheers > John Scoles > > mikhail maluyk wrote: >> I'm currently very interested in DBI related stuff, and have a few of

DBI & memcached (was: Google SoC: Fame and Fortune ($4500) await you!)

2008-03-19 Thread Tim Bunce
class that implements get($key) and set($key, $value) methods. In fact you can enable basic caching for idempotent queries in *any* application, with no code changes, just by setting an env var: DBI_AUTOPROXY='dbi:Gofer:transport=null;cache=1' Tim.

Google SoC: Fame and Fortune ($4500) await you!

2008-03-18 Thread Tim Bunce
are plenty of other interesting and useful projects. Tim.

General Perl DBI News

2008-03-18 Thread Tim Bunce
l my work deserves it, your Kudos are welcome. *** Blog And finally, I've taken the plunge and got myself one of those shiny weblog things. Perhaps you'll find it occasionally interesting. http://blog.timbunce.org A recent post provides a handy presentation for countering perl myths http://blog.timbunce.org/2008/03/08/perl-myths/ Tim.

Re: Statement prep fails with "Error calling SQLGetInfo"

2008-03-12 Thread Tim Bunce
Enable tracing to see what's really going on. Tim. On Tue, Mar 11, 2008 at 12:02:01PM -0700, Mark wrote: > Hi all, > > I'm a DBI newb, trying to pull some data from a DB2 database. This was > actually working yesterday, but part way through the day, I started > gett

Re: DBD::Sybase context allocation routine failed

2008-02-13 Thread Tim Bunce
True, but _very_ unlikely to be relevant to this problem. Tim. On Wed, Feb 13, 2008 at 04:04:23PM +0100, Alexander Foken wrote: > You need the module, but you should not load it explicitly. DBI will take > care of loading and initialising the module. > > Alexander > > On 13.02

ANNOUNCE: DBI 1.602

2008-02-11 Thread Tim Bunce
value of err for internal errors. Gofer changes: track_recent now also keeps track of N most recent errors. The connect method is now also counted in stats. =cut Enjoy! Tim.

Re: Trouble installing Isa::DBI (prereq for Class::DBI)

2008-02-05 Thread Tim Bunce
On Tue, Feb 05, 2008 at 04:04:35PM +, Victor Churchill wrote: > Any other suggestions would be very welcome! > > DBI version is 1.32 > Perl is 5.8.0 Upgrading, if at all possible, would be good start. Tim.

(Fwd) DBI Install error Tim Bunce and Ilya Sterin

2008-02-01 Thread Tim Bunce
- Forwarded message from "Laster, Mikal J via RT" <[EMAIL PROTECTED]> - Subject: [perl #50456] DBI Install error Tim Bunce and Ilya Sterin From: "Laster, Mikal J via RT" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] RT-Ticket: perl #50456 RT-Originator

Re: Any news on CPAN bug 32309 in DBI - faulty definition of DBIS for big-endian 64-bit machines with MULTIPLICITY

2008-01-30 Thread Tim Bunce
think the answer is no. I suggest someone test and post a patch here that others can try out on a variety of drivers. Tim. On Tue, Jan 29, 2008 at 01:16:03PM -0800, Jonathan Leffler wrote: > CPAN Bug 32309 was created recently, but I'm told that the underlying > problems was first

SSL connection with DBD::Oracle?

2008-01-25 Thread Tim Hester
I need to connect to an Oracle db on a remote machine, on the local network, that only supports ssl connections. Is there a way to do this using DBD::Oracle? Is there some other way to do this? Any assistance appreciated. Tim Hester

Re: Using q() to define a query

2008-01-11 Thread Tim Bunce
needs changing I'd find the extra effort to maintain that layout would be a pain, literally. I almost always use q{} or qq{} for multi-line strings. (Using a bracketing character like {, (, [ etc. means that perl will also take care of skipping any nested brackets within the string without them beeding to be escaped.) Tim.

Re: fetchrow_array warning and error in cleanup

2008-01-04 Thread Tim Bunce
27;t call method "FETCH" on an undefined value at > C:/Perl/site/lib/Win32/TieRegistry.pm line 1486 during global destruction. Old problem. I can't remember off-hand if upgrading DBI, or Win32::TieRegistry will help. Check the archives. Tim.

DBI interface for Amazon SimpleDB?

2007-12-14 Thread Tim Bunce
So, who's going to be first to mash up Amazon::SimpleDB::* and perhaps DBI::SQL::Nano into a DBI driver for Amazon's new SimpleDB service? http://www.amazon.com/gp/browse.html?node=342335011 Tim.

Re: ORA-12154: TNS:could not resolve the connect identifier specified

2007-12-12 Thread Tim Bunce
er, $password, > { RaiseError => 0, AutoCommit => 0, ora_envhp=> 0 }); As documented in the fine manual. Tim. http://www.catb.org/~esr/faqs/smart-questions.html

Re: Connecting to Database

2007-12-10 Thread Tim Bunce
ot;How do I access a MS SQL Server database from Linux?" The > "Linux" could should be "Unix". That needs updating to say something like "Use DBD::Proxy if you need transactions and DBD::Gofer if you don't." Tim.

Re: Setting up DBI on a Mac for a novice

2007-12-06 Thread Tim Bunce
You're more likely to get people to give their time to help you if it's clear that you've already tried to help yourself. See http://www.catb.org/~esr/faqs/smart-questions.html Tim. On Wed, Dec 05, 2007 at 04:14:56PM -0500, Bruce Martin wrote: > Hello all, > > I know t

Pedant at the London Perl Workshop

2007-12-03 Thread Tim Bunce
great photo Billy Abbott took of my DBD::Gofer talk: http://billyabbott.livejournal.com/209360.html Tim.

Re: New edition of the Cheetah?

2007-12-02 Thread Tim Bunce
doubt it'll be touched anytime soon. We still plan to complete it, but first I want to have something concrete to put in it about DBI2 and Perl6. If only to give myself the inspiration I need to write prose. But at the moment I don't have anything concrete to say about DBI2 and Perl6. T

(Fwd) RE: using $dbh->quote with UTF

2007-10-23 Thread Tim Bunce
- Forwarded message from "Schultz, Len" <[EMAIL PROTECTED]> - Subject: RE: using $dbh->quote with UTF Date: Tue, 23 Oct 2007 01:52:49 -0400 From: "Schultz, Len" <[EMAIL PROTECTED]> To: Tim Bunce <[EMAIL PROTECTED]> Hello Tim, I thought there shou

Re: using $dbh->quote with UTF

2007-10-22 Thread Tim Bunce
gt; that now, the string has extra characters in it because $dbh->quote is > losing the utf flag. Perhaps your DBD::mysql driver is an old version. The latest certainly has code to pass through the utf8 flag. Tim.

ANNOUNCE: DBI-1.601

2007-10-22 Thread Tim Bunce
st define the DBI_AUTOPROXY environment variable like this: DBI_AUTOPROXY='dbi:Gofer:transport=null;cache=1' Couldn't be any simpler. Enjoy! Tim.

(Fwd) Strange memory leak (?) with DBI ? DBD::Pg

2007-10-21 Thread Tim Bunce
- Forwarded message from Troy Davis <[EMAIL PROTECTED]> - x-pobox-client-address: 216.37.68.82 x-pobox-client-name: cafeautism.net Date: Sat, 20 Oct 2007 11:22:42 -0500 From: Troy Davis <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Strange memory leak (?) with DBI Hell

Re: DBI and DBD::Oracle throw error Had to create DBD::Oracle::dr::imp_data_size unexpectedly

2007-10-10 Thread Tim Bunce
oint me as to how we get down to finding the files, > permissions that cause the error it would be appreciated Start by setting the PERL_DL_DEBUG env var to 1 and rerun the command. It'll show you which DBD/Oracle.so file is being loaded. Also try running perl -Mblib -MDBI -e ... in

Re: DBI and DBD::Oracle throw error Had to create DBD::Oracle::dr::imp_data_size unexpectedly

2007-10-05 Thread Tim Bunce
that match DBD/Oracle.*) If you still have problems after that then post a one liner that demonstrates the problem: perl -MDBI -e 'DBI->connect("...", ...)' and we'll talk you through getting more info to diagnose the problem. Tim.

Re: DBD::Sybase, serverType

2007-10-03 Thread Tim Bunce
rsion via @@version, etc.) and avoid > spurious errors. > > Where can we find a list of the other types aside from "ASE"? At first glance it looks like that's all it does: http://search.cpan.org/grep?release=DBD-Sybase-1.08&string=serverType&F=1&n=1 Tim.

Re: DBD::Oracle 1.19 fails to find Oracle version, problem and solution

2007-09-27 Thread Tim Bunce
installation. Or something like that. (Naturally common code should be moved out into private modules.) Tim.

Re: DBD::Oracle and CHLD signals

2007-09-22 Thread Tim Bunce
It's Oracle, not DBD::Oracle, that's changing the signal settings. Yes, do try altering the CHLD signal handler after connecting and report back what you find. Also read the archives. Tim. On Thu, Sep 20, 2007 at 06:56:37PM -0700, Aaron Saarela wrote: > Hi, > > I'm hop

Re: DBI::ProfileDumper::Apache and mod_perl 2

2007-09-10 Thread Tim Bunce
hen the child process exits. > Does anyone have any suggestions how I can debug this further and figure > out why I cannot get it working? Check the above. Then check $dbh->{Profile} is true. (If you've still no joy I may be able to check a mod_perl2 setup in a day or two.) Tim. &

Re: fetchrow_array() vs fetchrow_arrayref() efficiency etc.

2007-09-07 Thread Tim Bunce
query itself is the same.) Given that level of variability (probably due to db load and/or network issues) you can't expect to get a meaningful comparison of the two methods. And even if you could, it should be clear that the difference is but a tiny fraction of the overall time spent processing the query. Tim.

Re: fetchrow_array() vs fetchrow_arrayref() efficiency etc.

2007-09-07 Thread Tim Bunce
ods is so small that it's only remotely relevant when fetching very large numbers of rows and doing very little with them within the loop. Beware premature optimization. If it's not hurting, don't "fix" it. Tim. On Fri, Sep 07, 2007 at 02:33:26PM +0800, Ow Mun Heng wrote:

Re: DBI upgrade and binary compatibility

2007-09-05 Thread Tim Bunce
Check the Changes file. (Including beyond 1.54 to see any problems in 1.54.) Tim. On Tue, Sep 04, 2007 at 02:23:49PM -0700, Ian Burrell wrote: > Is DBI backward compatible with DBD drivers built against older > versions of DBI? We are finally upgrading DBI from 1.38 to 1.54. We > are

Re: Fun with UTF-8 and Oracle

2007-09-04 Thread Tim Bunce
On Mon, Sep 03, 2007 at 07:20:42PM +0200, Peter J. Holzer wrote: > On 2007-09-03 13:03:37 +0100, Tim Bunce wrote: > > Oh the joys of Oracle character set support. > > > > See the dbd_rebind_ph() code in dbdimp.c. Especially from the line > > "csform = phs->

Re: Fun with UTF-8 and Oracle

2007-09-03 Thread Tim Bunce
he the Oracle docs. It's entirely possible that the code is doing the wrong thing. Tim. On Thu, Aug 23, 2007 at 04:20:16PM +0200, Peter J. Holzer wrote: > While investigating a performance problem I found a curious behaviour. > > I have an oracle database (10.2.0.3) and matching

Re: make test for DBI fails on Win98

2007-08-28 Thread Tim Bunce
On Mon, Aug 27, 2007 at 10:33:21AM -0700, Jeff Zucker wrote: > Tim Bunce wrote: > > On Sun, Aug 26, 2007 at 11:41:08PM +0200, Bart Lateur wrote: > t/41prof_dump.flock() unimplemented on this platform at > > Try the appended patch and let me know if it works

Re: make test for DBI fails on Win98

2007-08-28 Thread Tim Bunce
On Mon, Aug 27, 2007 at 11:02:47PM +0200, Bart Lateur wrote: > On Mon, 27 Aug 2007 10:17:16 +0100, Tim Bunce wrote: > > >Try the appended patch and let me know if it works for you. > > Yes, after the patch all tests pass. > > Funny, CPAN.pm also recently introduced s

Re: make test for DBI fails on Win98

2007-08-27 Thread Tim Bunce
; pass on XP. > > The culprit appears to be in DBI::ProfileDumper. A typical error message line: > > t/41prof_dump.flock() unimplemented on this platform at Try the appended patch and let me know if it works for you. Tim. Index:

ANNOUNCE: DBI 1.59

2007-08-24 Thread Tim Bunce
DBD::Proxy rows method thanks to Philip Dye. Fixed dbiprof compile errors, thanks to Alexey Tourbin. Fixed t/03handle.t to skip some tests if ChildHandles not available. Added check_response_sub to DBI::Gofer::Execute =cut Enjoy! Tim.

Re: Test t/85gofer.t fails on m68k

2007-08-20 Thread Tim Bunce
ry slow so it might hit a condition that is > unusual on a normal desktop machine. Occams's razor: Could you hack the test to increase the timeout, so say 100, and try again? Tim.

Re: ShowErrorStatement

2007-08-20 Thread Tim Bunce
it with a fairly recent version of DBI: 1.52). The exception may be caught by an eval { }. Using PrintError you'd still get a warning. Tim.

Re: Another set of DBI docs

2007-08-16 Thread Tim Bunce
iki http://search.cpan.org/~jmcnamara/Pod-Simple-Wiki/ It would be great to have a TiddlyWiki version of the DBI docs. Tim. [1] Go on, try it, especially if you've not played with a TiddlyWiki before: http://dbi.tiddlyspot.com/

Re: ShowErrorStatement

2007-08-15 Thread Tim Bunce
On Wed, Aug 15, 2007 at 01:03:03PM -0400, Robert Hicks wrote: > Tim Bunce wrote: > >On Tue, Aug 14, 2007 at 07:01:23PM -0400, Robert Hicks wrote: > >>Tim Bunce wrote: > >>>Setting ShowErrorStatement is unrelated to "or die..." so the question > >>

Re: ShowErrorStatement

2007-08-15 Thread Tim Bunce
On Tue, Aug 14, 2007 at 07:01:23PM -0400, Robert Hicks wrote: > Tim Bunce wrote: > > > >Setting ShowErrorStatement is unrelated to "or die..." so the question > >seems flawed. > > > >ShowErrorStatement just adds information to the message produce

Re: ShowErrorStatement

2007-08-14 Thread Tim Bunce
On Tue, Aug 14, 2007 at 09:16:15AM -0400, Robert Hicks wrote: > Tim Bunce wrote: > >On Tue, Aug 14, 2007 at 11:17:26AM +1000, Stuart Cooper wrote: > >>>First off, I had no idea it existed until I started going through a dbi > >>>tutorial. The idea is you don&#x

(Fwd) Re: DBD::Oracle won't install for Oracle 10G XE

2007-08-14 Thread Tim Bunce
- Forwarded message from [EMAIL PROTECTED] - X-IP: 216.150.208.7 From: [EMAIL PROTECTED] To: Tim Bunce <[EMAIL PROTECTED]> Subject: Re: DBD::Oracle won't install for Oracle 10G XE Date: Mon, 13 Aug 2007 22:42:59 -0700 X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686 (x86_64);

Re: ShowErrorStatement

2007-08-14 Thread Tim Bunce
just tweaks the behaviour of RaiseError and PrintError. $dbh = DBI->connect($DSN, $user, $pass, { RaiseError => 1, PrintError => 0, ShowErrorStatement => 1, ... Tim.

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