Fwd: please help with DBD-Oracle-1.76

2022-09-05 Thread Tim Bunce
> Begin forwarded message: > > From: Daniel Chmielewski > Subject: Fwd: please help with DBD-Oracle-1.76 > Date: 5 September 2022 at 10:03:15 IST > To: t...@cpan.org > > Tim, please help. > Regards, > Daniel > > > -- Forwarded mes

Oracle DBD with 19c - forked child hangs on exit

2022-05-10 Thread Tim Wolfe
We just upgraded one of our database servers from Oracle 12.2.0.1 to 19.15.0 and one our perl programs is behaving differently. We are running with RedHat 8.4 using Perl v5.26.3 and the latest DBD::Oracle and DBI from cpan. Under 19c, a forked child hangs on exit if the parent has (or had) an

(Fwd) DBD:Oracle

2020-07-13 Thread Tim Bunce
- Forwarded message from Ajay Kumar - Date: Mon, 13 Jul 2020 15:32:55 + From: Ajay Kumar To: Tim Bunce Subject: DBD:Oracle Hi Tim, Hope, you are sound and safe with your loved ones. I am trying to install the ORA2PG tool which migrates Oracle data into PostgreSQL

Announce: DBI 1.643

2020-01-31 Thread Tim Bunce
eError, thanks to Pali =cut Many thanks to those who contributed to this somewhat overdue release. Enjoy! Tim.

Announce: DBI 1.642

2018-10-29 Thread Tim Bunce
pali #64 Added a new XS API function variant dbd_db_do6() thanks to Pali #61 Fix misprints in doc of selectall_hashref thanks to Perlover #69 Remove outdated links to DBI related training resources. RT#125999 =cut Many thanks to those who contributed to this release. En

Re: Extend API for last_insert_id

2018-05-15 Thread Tim Bunce
On Fri, May 04, 2018 at 02:10:18PM +0200, p...@cpan.org wrote: > Hello, do you have any opinion or comments? > > Tim, you as a DBI maintainer, what do you think about those ideas? > > On Friday 27 April 2018 16:03:59 p...@cpan.org wrote: > > > > So I'm proposi

Re: debugging and stepping into ->do

2018-04-27 Thread Tim Bunce
gt; I'd examine the Statement and >"die" accordingly. This would allow me to validate database logic that > rolled back a transaction. https://metacpan.org/pod/DBI#Callbacks may help. Tim.

Announce DBI-1.640

2018-01-28 Thread Tim Bunce
Perl 5.10.0 and 5.8.1 specific versions to Travis testing thanks to pali #57 Add registration of mariadb_ prefix for new DBD::MariaDB driver thanks to pali #56 =cut Many thanks to pali for these contributions. Enjoy! Tim.

Re: Need help with an unexpected behaviour

2018-01-28 Thread Tim Bunce
ich I have overlooked? The DBI (and most drivers) have extensive tracing built in. The trace output is often very helpful to see what's really happening. See https://metacpan.org/pod/DBI#TRACING It'll show you the effect of the local AutoCommit assignment and re-setting assignment at scope-exit. Tim.

Announce: DBI 1.639

2017-12-30 Thread Tim Bunce
to pali #55 =cut Many thanks to those who contributed. Enjoy! Tim. p.s. There wasn't a 1.638 release.

Re: Oracle encoding query

2017-12-11 Thread Tim Bunce
On Wed, Dec 06, 2017 at 04:53:36PM +0100, H.Merijn Brand wrote: > On Wed, 6 Dec 2017 15:34:17 +0000, Tim Bunce <tim.bu...@pobox.com> > wrote: > > > A view might be useful. Or perhaps define your own function to wrap the > > expression. > > That worked very well

Re: Oracle encoding query

2017-12-06 Thread Tim Bunce
get the expected display with > > select utl_i18n.raw_to_nchar (utl_i18n.string_to_raw (land_u), 'utf8') from > land where c_land = 7072; > > which experiences as rather overcomplicated, esp if I need to do this > for all _u fields in the query :( A view might be useful. Or perhaps define your own function to wrap the expression. Tim.

Announce: DBI 1.637

2017-08-17 Thread Tim Bunce
ypo fix thanks to bor #37 =cut Many thanks to those who contributed to this release. Enjoy! Tim.

(Fwd) Oracle.pm

2017-03-06 Thread Tim Bunce
- Forwarded message from Gowtham <shiningstargau...@gmail.com> - Date: Mon, 6 Mar 2017 15:40:59 -0600 From: Gowtham <shiningstargau...@gmail.com> To: tim.bu...@pobox.com Subject: Oracle.pm Hi Tim, I feel that you are the right person to check this with. I am trying t

Re: FetchHashKeyName emits invalid keys for utf8 fieldnames

2017-02-25 Thread Tim Bunce
Thanks for the report Chris. Any chance you could write up a small test case for us? Ideally in a new issue at https://github.com/perl5-dbi/dbi/issues Thanks. Tim. On Fri, Feb 24, 2017 at 12:55:23PM +1100, Chris Hutchinson wrote: > Using DBI v 1.636 > > $dbi->{FetchHashKeyNa

(Fwd) RE: Issues with Oracle DBD in Cygwin

2016-10-12 Thread Tim Bunce
- Forwarded message from "Neargarder, Keith" - Date: Wed, 12 Oct 2016 12:22:00 + From: "Neargarder, Keith" To: "'t...@cpan.org'" , "'byter...@cpan.org'" ,

Re: sth->prepare() setting Active?

2016-10-01 Thread Tim Bunce
Looks good. Thanks David! Tim. On Fri, Sep 30, 2016 at 04:03:35PM -0500, David Nicol wrote: > sorry, this one is better > >"Active" > >Type: boolean, read-only > >The "Active" attribute is true if the handle object

Re: sth->prepare() setting Active?

2016-09-30 Thread Tim Bunce
gets Class::DBI working with DBD::Sybase. > > Our current code overrides db_Main which seems like an unnecessary hack > to me, and confuses Class::DBI somewhat, triggering warnings. > > I'm halfway down this rabbit hole and not really sure which turning to > take now! I'd take the view that $sth->{Active} shouldn't be true until after a successful execute(). I'd happily take a doc patch that tightens up the docs in that direction. Tim.

(Fwd) Issues with Oracle DBD in Cygwin

2016-09-17 Thread Tim Bunce
- Forwarded message from "Neargarder, Keith" - Date: Fri, 16 Sep 2016 22:16:11 + From: "Neargarder, Keith" To: "'t...@cpan.org'" , "'byter...@cpan.org'" ,

Re: DBD::XML

2016-09-04 Thread Tim Bunce
On Sun, Sep 04, 2016 at 08:33:21AM -0400, Nigel Horne wrote: > > On 4/9/16 05:56, Tim Bunce wrote: > > > So here's an interesting one. Any thoughts on this? I assumed it all got > > > pulled in magically, but I guess I'm missing something. But what? > > > >

Re: DBD::XML

2016-09-04 Thread Tim Bunce
8a4b8c I've not listed DBI as a prerequisite, nor DBI::DBD::SqlEngine (which is the first thing the module loads) so that test might have been running with a funky older version. Tim.

Re: DBD::XML

2016-08-21 Thread Tim Bunce
at seems fine. So DBD::XMLSimple and a prefix of xmls_. Tim.

Re: DBD::XML

2016-08-19 Thread Tim Bunce
On Fri, Aug 19, 2016 at 10:09:45AM -0400, Nigel Horne wrote: > On 8/19/16 9:56 AM, Tim Bunce wrote: > > On Fri, Aug 19, 2016 at 09:30:32AM -0400, Nigel Horne wrote: > > > > > > Apart from one change I need to make in terms of column names, I'm pretty > > > m

Re: DBD::XML

2016-08-19 Thread Tim Bunce
that's all I need. How do I set about requesting driver registration, or is > this mentioning enough? Probably :) But I wonder about the name. "DBD::XML" seems to be a bold name, implying that it's _the_ DBI interface for data stored in XML files. Of course the same kind of issue applies to many other drivers, so it's not a major concern, but does seem worth dicussing. Tim.

(Fwd) DBD::Oracle quote_identifier

2016-08-17 Thread Tim Bunce
- Forwarded message from "LAWS, MICHAEL H" - Date: Tue, 16 Aug 2016 21:04:20 + From: "LAWS, MICHAEL H" To: "t...@cpan.org" Subject: DBD::Oracle quote_identifier Hello, I was using quote_identifier for table names on an oracle

Re: suppress quoting in prepared sql

2016-04-05 Thread Tim Bunce
I'd happily take a patch to the DBI docs to mention the common use case described by this thread. Tim. On Tue, Apr 05, 2016 at 05:29:34PM +, Vaughan, Mark wrote: > This works if the number of elements remains static. You'd have to run the > prepare again if the number of elements c

(Fwd) perl DBI bug report

2015-09-01 Thread Tim Bunce
- Forwarded message from Dave Dyer - Date: Tue, 01 Sep 2015 12:40:00 -0700 From: Dave Dyer To: tim.bu...@pobox.com Subject: perl DBI bug report This query produces results with lots of trailing nulls embedded in the "outcome" value. I suppose

Announce: DBI 1.634

2015-08-03 Thread Tim Bunce
(Martin J. Evans) Added support for DBD prefixes with numbers (Jens Rehsack) #19 Added extra initializer for DBI::DBD::SqlEngine based DBD's (Jens Rehsack) Added Memory Leaks section to the DBI docs (Tim) Added Artistic v1 GPL v1 LICENSE file (Jose Luis Perez Diez) #21 =cut Enjoy

Please test DBI-1.633_91 - recently uploaded to CPAN

2015-07-20 Thread Tim Bunce
. Please build it, install it, test it, and let us know how it goes. cpanm https://cpan.metacpan.org/authors/id/T/TI/TIMB/DBI-1.633_91.tar.gz Thanks! Tim.

Re: Potential dbi memory leak.

2015-05-28 Thread Tim Bunce
On Thu, May 28, 2015 at 03:59:51PM +1200, Duncan McEwan wrote: On Tue, 26 May 2015 14:13:05 +0100 Tim Bunce tim.bu...@pobox.com wrote: I've added this as a note: Note that the ChildHandles array holds weak references and that 'from time to time' the old slots get freed up

Re: Potential dbi memory leak.

2015-05-26 Thread Tim Bunce
that if the DBI did have a real leak a) a great many people would be affected and b) it would get fixed very quickly. I think 'from time to time' is every 120 or so newly created child handles. Tim. On Tue, May 26, 2015 at 07:57:53AM -0300, Steve Cookson - gmail wrote: It seems to be further documented

Re: Making DBD::Pg to return Postgres arrays as Perl arrays

2015-05-07 Thread Tim Bunce
a look at https://metacpan.org/pod/PGObject::Type::Composite Tim.

Re: May CPAN Pull request chalenge

2015-05-01 Thread Tim Bunce
On Fri, May 01, 2015 at 06:34:58PM +0200, jl...@escomposlinux.org wrote: Hi Tim, Hi! I have got as a May a assignment your module DBI. Congratulations :) In Neil's message he sugested 3 areas for the pull request: Notes on your distribution: * It has a file 'test.pl' in the top

Re: DESTROY ignored for outer handle

2015-04-29 Thread Tim Bunce
statement of the problem behaviour, the circumstances, and what you've explored changing and what effect it had. Post again here if you find there is a problem related to the DBI. Otherwise perhaps a more general web development forum would be more help. Good luck. Tim. On Wed, Apr 29, 2015 at 12

Re: DESTROY ignored for outer handle

2015-04-28 Thread Tim Bunce
any errors in that log. I suggest you enable RaiseError, if you haven't already, then any errors will be obvious. (DESTROY ignored for outer handle is an internal detail that's almost certainly irrelevant to whatever problem you're having.) Tim.

Re: DBD::ODBC Destroy bug?

2015-04-08 Thread Tim Bunce
might not be ok. I don't know if Tim could comment on this. DBIc_IMPSET_off is how the driver indicates that it's done all the cleanup it can. The current code seems reasonable. Tim. So, in summary, I cannot reproduce your error, I've seen freeTDS error and fail to tell us the error before, your

Re: Perl 6 and DBI

2015-02-06 Thread Tim Bunce
on the dbi-dev mailing list. Tim.

Re: Escaping placeholders, take 2

2015-01-09 Thread Tim Bunce
/TURNSTEP/DBD-Pg-3.5.0/Changes Many thanks Greg. Tim.

Re: make test fails installing DBI-1.632 (linux, perl5.8.8)

2015-01-08 Thread Tim Bunce
allows make test to succeed. So there's no problem now? Or did that just fix t/06attr.t? Tim.

Re: Escaping placeholders, take 2

2015-01-02 Thread Tim Bunce
On Wed, Dec 31, 2014 at 03:55:42AM -, Greg Sabino Mullane wrote: Tim Bunce wrote: Wherein I attempt to summarize the requirements, the background, the options, the risks, and the counter-proposal ... Thanks for taking the time to write all this out in a coherent manner. You're

Escaping placeholders, take 2

2014-12-28 Thread Tim Bunce
. (Naturally I'll add tests and docs etc. to this before sending a pull request.) Tim p.s. When replying, please edit your replies to only quote the relevant parts of this (very long) email.

Re: Escaping placeholders (was: [Dbix-class] Using Postgres JSONB operators in queries)

2014-12-24 Thread Tim Bunce
Sometime over the holiday period I hope to write up a summary of the arguments for and against and suggest ways forwards. Tim.

Re: Escaping placeholders

2014-12-21 Thread Tim Bunce
, if they want to. (The DBI has a built-in preparse function that's intended for parsing placeholders but few, if any, drivers use it. I know DBD::Informix doesn't.) Tim. On Sat, Dec 20, 2014 at 2:17 PM, Tim Bunce [2]tim.bu...@pobox.com wrote: On Sat, Dec 20, 2014 at 01:14:29PM -0800

Re: Escaping placeholders

2014-12-21 Thread Tim Bunce
On Sun, Dec 21, 2014 at 10:27:18AM +0100, pe...@vanroose.be wrote: On 20.12.2014 15:38, Tim Bunce wrote: [...] Can you, or anyone else, think of any situation where a backslash before a ? or :foo (or even $1) style placeholder might be valid SQL? Inside quoted text: of course, yes

Re: Escaping placeholders

2014-12-20 Thread Tim Bunce
Thanks David :) Tim. On Fri, Dec 19, 2014 at 12:23:23PM -0600, David Nicol wrote: Please disregard my previous. After reading Tim Bunce's earlier response and thinking about this some more, although backslash escaping can be tricky, that is how Perl does these things, and Perl coders

Re: Escaping placeholders

2014-12-20 Thread Tim Bunce
placeholder might be valid SQL? So far no one has come up with one, so I'm getting more comfortable with the idea that a backslash before a placeholder is a safe change. I.e., there's a near-zero risk that upgrading a DBI driver to support backslashes would cause breakage in existing code. Tim.

Re: Escaping placeholders

2014-12-20 Thread Tim Bunce
On Sat, Dec 20, 2014 at 05:35:55PM +0100, Alexander Foken wrote: On 20.12.2014 15:38, Tim Bunce wrote: Can you, or anyone else, think of any situation where a backslash before a ? or :foo (or even $1) style placeholder might be valid SQL? I found two situations for PostgreSQL: (1

Re: Escaping placeholders

2014-12-20 Thread Tim Bunce
as: INSERT INTO SomeTable(DateTimeCol) VALUES(DATETIME(2014-12-31 23\:59\:59) YEAR TO SECOND); Tim.

Escaping placeholders (was: [Dbix-class] Using Postgres JSONB operators in queries)

2014-12-19 Thread Tim Bunce
think of realistic examples? (For ANY DBI driver or backend.) Tim.

Re: First time DBI user crashing perl

2014-10-30 Thread Tim Bunce
Turning on tracing is usually a good idea when odd things are happening. Read https://metacpan.org/pod/DBI#TRACING and set the DBI_TRACE environment variable. Tim. On Wed, Oct 29, 2014 at 09:56:27PM -0600, Jon wrote: Hello Peter, Well, that's kinda what I figured but never hurts try

Re: First time DBI user crashing perl

2014-10-30 Thread Tim Bunce
looks like a crash within the DBD::DB2 driver. Hopefully someone here can help but you could also try http://www.software.ibm.com/data/db2/perl Tim. Here is my perl version This is perl 5, version 18, subversion 1 (v5.18.1) built for MSWin32-x64-multi-thread Thanks! Peter

Re: Using DBI::Profile to count and time database calls

2014-10-16 Thread Tim Bunce
better to collect using '!MethodName' and post-process to merge the stats for the methods you're interested in. Tim. I can use this to just gather grand totals: DBI::Profile-new( Path = [ ] ); The total time is fine even if it includes the small amount of time in DBI instead

Re: DBI Mysql Driver Handle Mysteriously Changes!

2014-03-27 Thread Tim Bunce
://metacpan.org/pod/DBI#connect and https://metacpan.org/source/TIMB/DBI-1.631/DBI.pm#L571 Keep focused on why a new drh appears. See https://metacpan.org/source/TIMB/DBI-1.631/DBI.pm#L652 Perhaps something is altering %DBI::installed_drh Tim.

Re: DBI Mysql Driver Handle Mysteriously Changes!

2014-03-25 Thread Tim Bunce
wonder if something like the following might be better given the persistent nature of our application provided by fcgid. my $dbi = new DBI; my $dbh = $dbi-connect_cached(...) No. Using new DBI (or DBI-new) isn't a valid way to use the DBI. Just DBI-connect_cached is fine. Tim.

Re: PostgreSQL driver DBD::Pg releases version 3.0.0

2014-02-06 Thread Tim Bunce
the method call form: $utf8_encoding-decode($$item{$_} || ''): And each module tested under V 3.0.0 broke. But a 1-line change fixes them: $$attr{pg_enable_utf8}= 0 if ($$config{dsn} =~ /dbi:Pg/i); Sweet. Gotta love utf8. :) Tim.

Re: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

2014-01-31 Thread Tim Bunce
slighly. Are you sure? This is the first I've heard of such a leak. Tim. The latest version of DBI with the $sth-{ParamValues}, Should solve all you problems As a bonus I have another topic for me blog Cheers John

Re: Issues with DBI Oracle Input Array Binds (ORA_VARCHAR2_TABLE)

2014-01-31 Thread Tim Bunce
On Fri, Jan 31, 2014 at 12:50:36PM -0500, John Scoles wrote: Well I did do some testing. The leak was very small (1k over 10 min run) but only when one does $shift-FETCH( 'ParamValues' ), in the child callback. If it doesn't keep growing with more call then it's not a leak. Tim

Announce: DBI 1.631

2014-01-20 Thread Tim Bunce
to all the contributors. Enjoy! Tim.

Re: DBI: selectrow_array() return first column when called in list context

2013-12-26 Thread Tim Bunce
evaluated like this: (my ($x, $y) = foo() ) or die ...; Tim.

(Fwd) Problems with DBD::Oracle package: function plsql_errstr

2013-11-03 Thread Tim Bunce
- Forwarded message from Eljot na Onet.pl eljot_...@poczta.onet.pl - Date: Sat, 02 Nov 2013 21:11:48 +0100 From: Eljot na Onet.pl eljot_...@poczta.onet.pl To: t...@cpan.org Subject: Problems with DBD::Oracle package: function plsql_errstr Hi, I have found two problems with your

Please test DBI-1.628_50 re change in PrintWarn

2013-10-11 Thread Tim Bunce
it *with your application code* (not just make test) and report back. Please report back whether you have extra warnings logged *OR NOT* and don't forget to mention what driver you're using. Thanks! Tim. p.s. DBI-1.628_50 will install as $DBI::VERSION 1.629. Changes: https://metacpan.org

Re: Please test DBI-1.628_50 re change in PrintWarn

2013-10-11 Thread Tim Bunce
this trial version, then you'll need to recompile your drivers again. Sorry for the inconvenience!) Tim. On Fri, Oct 11, 2013 at 01:49:04PM +0100, Tim Bunce wrote: The PrintWarn attribute used to default to the same value as $^W. In other words, if you ran perl with -w then would be on. See

(Fwd) Can't use an undefined value as an ARRAY reference at /usr/local/lib/perl/5.14.2/DBI.pm

2013-09-28 Thread Tim Bunce
- Forwarded message from Yonatan Sisay ysi...@cloudxdpo.com - Date: Sat, 28 Sep 2013 01:25:04 -0700 From: Yonatan Sisay ysi...@cloudxdpo.com To: tim.bu...@pobox.com Subject: Greetings, I have been having an issue with DBI. I installed a web system called KOHA, and in the middle

Re: DBD::mysql 4.024 released, many fixes, especially for Windows

2013-09-18 Thread Tim Bunce
I'm delighted to see DBD::mysql moving again. Many thanks to you and all those actively contributing their time, attention and energy. Tim. On Wed, Sep 18, 2013 at 08:52:25AM +0200, Michiel Beijen wrote: Patrick Galbraith has released a new version of DBD::mysql with many small fixes inside

Re: using callbacks with connect_cached

2013-09-04 Thread Tim Bunce
Both merged. Thanks! Tim. On Tue, Sep 03, 2013 at 11:07:15AM -0700, David E. Wheeler wrote: On Aug 25, 2013, at 12:10 PM, Tim Bunce tim.bu...@pobox.com wrote: p.s. I'd be delighted to get a doc patch that notes the need to use a lexical for the callbacks hashref on connect_cached

(Fwd) DBD::Gofer

2013-08-26 Thread Tim Bunce
- Forwarded message from reist87 reis...@gmail.com - Date: Mon, 26 Aug 2013 17:31:11 +0600 From: reist87 reis...@gmail.com To: tim.bu...@pobox.com Subject: DBD::Gofer Hi, Tim. Sorry for my English, I am russian) We have program on consumer computer, which connected to MS SQL

Re: using callbacks with connect_cached

2013-08-25 Thread Tim Bunce
= shift; if (++$dbh-{private_connected_count} == 1) { ... # is new connection } return; } Tim. p.s. I'd be delighted to get a doc patch that notes the need to use a lexical for the callbacks hashref on connect_cached. p.p.s. I'd also consider a patch

Re: utf8 and mysql

2013-08-01 Thread Tim Bunce
to the $dbh returned from the drivers' connect method. (So can't be used for attributes that need to be applied before the connection is established.) You can see it documented in https://metacpan.org/module/DBI#parse_dsn and the connect section below it. Tim.

Announce DBI 1.628

2013-07-22 Thread Tim Bunce
in selectall_arrayref docs RT#84873 Spelling fixes [Ville Skyttä] Changed $VERSIONs to hardcoded strings [H.Merijn Brand] =cut Enjoy! Tim.

Re: DBI Driver.xst and DBD::cego

2013-05-27 Thread Tim Bunce
(imp_dbh)==1) ? : s; +const char *plural = (DBIc_ACTIVE_KIDS(imp_dbh)==1) ? : s; but that may trigger other errors/warnings in later code which will need attending to. (Same goes for the other hunk in the patch.) Could you give that a go? Tim.

ANNOUNCE DBI-1.627

2013-05-17 Thread Tim Bunce
Changes in DBI 1.627 - 16th May 2013 Fixed VERSION regression in DBI::SQL::Nano [Tim Bunce] =head2 Changes in DBI 1.626 - 15th May 2013 Fixed pod text/link was reversed in a few cases RT#85168 [H.Merijn Brand] Handle aliasing of STORE'd attributes in DBI::DBD::SqlEngine

Re: Huh? 4=3?

2013-05-09 Thread Tim Bunce
on here -- the original code imparted a list context, which triggered another perl gotcha, whereby missing list values simply disappear: scalar(1,2,,4,,6) --- 4, not 6 That returns 6, or rather, it returns whatever happens to be the last value. Tim.

Re: Relevance of ChildHandles

2013-05-07 Thread Tim Bunce
. If there was then a lot of people would be affected and complaining about it. Tim.

Prepared statements- variable number of placeholders

2012-10-22 Thread Tim Bowden
runtime how many fields? How can I put the (?,?,?) into a variable and have it recognised as placeholders? Thanks, Tim Bowden

Re: Prepared statements- variable number of placeholders- SOLVED

2012-10-22 Thread Tim Bowden
-bind_param($i, $pass_type_id, SQL_VARCHAR); $i++; $sth-bind_param($i, $device_id, SQL_VARCHAR); $i++; $sth-execute; On Oct 22, 2012, at 9:16 AM, Tim Bowden tim.bow...@mapforge.com.au wrote: Is it possible, and if so, how can I set the number of placeholders in a prepared statement

Re: DBI Threaded use access?

2012-10-11 Thread Tim Bunce
#Threads_and_Thread_Safety Tim.

(Fwd) DBD::Oracle Continuous Query Notification

2012-08-28 Thread Tim Bunce
- Forwarded message from Rune Henssel rune.hens...@trapezegroup.eu - Date: Tue, 28 Aug 2012 13:03:08 +0200 From: Rune Henssel rune.hens...@trapezegroup.eu To: t...@cpan.org Subject: DBD::Oracle Continuous Query Notification Hi Tim I hope that you might be able to help me

Re: make test hangs when re-installing DBI under 64-bit

2012-08-27 Thread Tim Bunce
;os=aix shows only 1 pass and two fails, and those were for perl 5.10.1 (the pass report looks like it's for a 64-bit system). Tim.

Re: make test hangs when re-installing DBI under 64-bit

2012-08-27 Thread Tim Bunce
On Mon, Aug 27, 2012 at 01:42:20PM -0600, Harry Jamieson wrote: On 8/27/2012 12:07 PM, Tim Bunce wrote: On Mon, Aug 20, 2012 at 08:41:45AM -0600, Harry Jamieson wrote: Environment: IBM AIX 5.3. Perl 5.8.8 now linked to its 64-bit libraries. 64-bit compiled test simple 0.98 64-bit compiled

ANNOUNCE: DBI 1.622

2012-06-07 Thread Tim Bunce
. =cut Enjoy! Tim.

Re: Odd error using bind_param_inout

2012-06-05 Thread Tim Bunce
I wonder if it would be possible (and useful) for DBD::Oracle to warn if there are unbound params. Tim. On Mon, Jun 04, 2012 at 02:12:53PM -0400, Jeffrey Seger wrote: $dbh-do() executes your sql. You are binding the parameter after this. Use $dbh-prepare instead. On Mon, Jun 4, 2012 at 2

Re: Installing 32 bit DBI.pm

2012-05-28 Thread Tim Bunce
the actual error message. You're much more likely to get help if you include a url to a complete log of all you commands and responses. Perhaps paste them into a service like http://pastebin.com/ Tim. p.s. http://mikeash.com/getting_answers.html

ANNOUNCE: DBI 1.621

2012-05-23 Thread Tim Bunce
previous Changes to credit Booking.com for sponsoring Dave Mitchell's recent DBI optimization work. =cut Enjoy! Tim.

Re: Segfault in threaded program after upgrade to DBI 1.620

2012-05-22 Thread Tim Bunce
Ah, great. Thanks Matt. [Note to self: It's worth checking the bug tracker for updates from users.] DBI 1.621 is on it's way. Tim. On Mon, May 21, 2012 at 10:23:44AM -0500, Matthew Musgrove wrote: Tim, Yes, I updated that bug report last week to report that the patch worked for me

Re: Segfault in threaded program after upgrade to DBI 1.620

2012-05-21 Thread Tim
test the patch ASAP, or else test the trial release. Thanks. Tim.

ANNOUNCE DBI 1.620

2012-04-25 Thread Tim Bunce
your drivers after installing this release in order to get full benefit. Ilmari's changes implement ideas that came from discussions I'd had with Peter Rabbitson on IRC about fetch performance in DBIx::Class. Hopefully a future release of DBIx::Class will make full use of these changes. Enjoy! Tim.

ANNOUNCE DBI 1.618

2012-02-25 Thread Tim Bunce
to this release, especially Dave Mitchell for his optimization work. Enjoy! Tim.

Re: New DBD::ODBC 1.34_3 development release

2012-02-04 Thread Tim Bunce
. You can. You need to pass some extra args to install_method(). Something like install_method(odbc_getdiagrec, { O=0x0004 }); That's the value of the IMA_KEEP_ERR flag. See the #define IMA_*'s in DBI.xs and the O=... in DBI.pm Tim.

Re: DBI-Users RE: DBD-Oracle - obtaining OCI handles from $dbh

2011-10-28 Thread Tim Bunce
); I'd have no objection to adding a perl method to DBD::Oracle to access the get_oci_handle function. Perhaps ora_get_oci_handle($handle_type). Tim [still sad that Oracle::OCI doesn't get more love] On Thu, Oct 27, 2011 at 02:39:15PM -0400, Lyle Brooks wrote: Ok, so with the following addition

Re: DBD-Oracle - obtaining OCI handles from $dbh

2011-10-28 Thread Tim Bunce
it was you Charles who helped me last time I tried to build Oracle::OCI. Perhaps I'll find time to give it another go. That would be awesome. Tim.

Re: DBD-Oracle - obtaining OCI handles from $dbh

2011-10-28 Thread Tim Bunce
frustrated. Hopefully between Charles, Martin, and yourself, we can breath some new life into Oracle::OCI. Tim.

Re: Oracle and Two Phase commit with Perl?

2011-10-11 Thread Tim Bunce
of the OCITrans*() calls as well. Tim.

Re: Quoting of values in arrays in broken in DBD::Pg, can you help fix it? ( CPAN RT#58552 ) [SumsaultRT #9386]

2011-10-11 Thread Tim Bunce
something but I'd say the 'correct quoting' is whatever works to get any random data from the app to the database. I'm affected by the issue and would personally appreciate the help. I'd appreciate a summary of the key issues. Tim.

Re: Tail Module + DBI Module, can\'t keep up!

2011-09-16 Thread Tim Bunce
as hourly text files and then, when each is complete, using a proprietary bulk-loading tool to load it. Tim.

Re: Fwd: Idea for a Gofer transport for translating SQL - primarily intended for testing

2011-09-12 Thread Tim Bunce
On Sun, Sep 11, 2011 at 11:25:20PM +0100, Andrew Ford wrote: I suggest that we move this discussion to dbi-dev. [dbi-users dropped] On 11/09/11 18:14, Tim Bunce wrote: On Fri, Sep 09, 2011 at 03:50:53PM +0100, Andrew Ford wrote: my $next_middleware = $go_transport-middleware

Re: Fwd: Idea for a Gofer transport for translating SQL - primarily intended for testing

2011-09-11 Thread Tim Bunce
ever used for testing. It's probably not worth trying to fix though. The overhead of serialization/deserialization is probably (I'm guessing) a relatively small part of the overall overhead of using Gofer. Feel free to try, but I wouldn't make it a priority :) Tim.

Re: Fwd: Idea for a Gofer transport for translating SQL - primarily intended for testing

2011-09-09 Thread Tim Bunce
On Thu, Sep 08, 2011 at 01:19:17PM +0100, Andrew Ford wrote: Hi Tim Sorry for mailing you directly, but I don't know whether my emails are getting through to the dbi-users mailing list, [CC'd to dbi-users] and I would quite like to get this module onto CPAN and would like some

(Fwd) Sybase 15.0

2011-08-20 Thread Tim Bunce
- Forwarded message from Mackin, Thomas E. thomas.mac...@lfg.com - Date: Fri, 19 Aug 2011 14:33:11 -0400 From: Mackin, Thomas E. thomas.mac...@lfg.com To: tim.bu...@pobox.com Subject: Sybase 15.0 Tim, We migrated our Sybase database (AIX) to 15.0.2 about 2 years ago. We also

(Fwd) Question about DBD::Oracle

2011-05-24 Thread Tim Bunce
- Forwarded message from Sumiya sumiy...@tradewintech.co.jp - Date: Wed, 16 Mar 2011 09:19:15 +0900 From: Sumiya sumiy...@tradewintech.co.jp To: tim.bu...@pobox.com Subject: Question about DBD::Oracle Dear Mr. Tim Bunce, I would like to ask you about DBD::Oracle. Would you tell me what

(Fwd) Re: DBD::Oracle Slow cursors

2011-05-17 Thread Tim Bunce
- Forwarded message from P S Jameel Ahamed jaha...@idexcel.com - Date: Tue, 17 May 2011 16:11:04 +0100 From: P S Jameel Ahamed jaha...@idexcel.com To: tim.bu...@pobox.com Subject: Re: DBD::Oracle Slow cursors X-Mailer: Microsoft Office Outlook 11 HI Tim, We are facing huge

  1   2   3   4   5   6   7   8   9   10   >