> 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
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
- 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
eError,
thanks to Pali
=cut
Many thanks to those who contributed to this somewhat overdue release.
Enjoy!
Tim.
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
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
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.
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.
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.
to pali #55
=cut
Many thanks to those who contributed.
Enjoy!
Tim.
p.s. There wasn't a 1.638 release.
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
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.
ypo fix thanks to bor #37
=cut
Many thanks to those who contributed to this release.
Enjoy!
Tim.
- 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
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
- Forwarded message from "Neargarder, Keith"
-
Date: Wed, 12 Oct 2016 12:22:00 +
From: "Neargarder, Keith"
To: "'t...@cpan.org'" , "'byter...@cpan.org'"
,
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
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.
- Forwarded message from "Neargarder, Keith"
-
Date: Fri, 16 Sep 2016 22:16:11 +
From: "Neargarder, Keith"
To: "'t...@cpan.org'" , "'byter...@cpan.org'"
,
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?
> > >
>
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.
at seems fine. So DBD::XMLSimple and a prefix of xmls_.
Tim.
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
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.
- 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
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
- 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
(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 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.
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
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
a look at https://metacpan.org/pod/PGObject::Type::Composite
Tim.
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
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
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.
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
on the dbi-dev mailing list.
Tim.
/TURNSTEP/DBD-Pg-3.5.0/Changes
Many thanks Greg.
Tim.
allows make test to succeed.
So there's no problem now? Or did that just fix t/06attr.t?
Tim.
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
. (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.
Sometime over the holiday period I hope to write up a summary of the
arguments for and against and suggest ways forwards.
Tim.
, 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
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
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
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.
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
as:
INSERT INTO SomeTable(DateTimeCol)
VALUES(DATETIME(2014-12-31 23\:59\:59) YEAR TO SECOND);
Tim.
think of realistic examples? (For ANY DBI driver or backend.)
Tim.
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
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
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
://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.
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.
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.
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
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
to all the contributors.
Enjoy!
Tim.
evaluated like this:
(my ($x, $y) = foo() ) or die ...;
Tim.
- 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
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
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
- 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
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
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
- 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
= 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
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.
in selectall_arrayref docs RT#84873
Spelling fixes [Ville Skyttä]
Changed $VERSIONs to hardcoded strings [H.Merijn Brand]
=cut
Enjoy!
Tim.
(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.
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
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.
. If there was then a lot of
people would be affected and complaining about it.
Tim.
runtime how many fields? How can I put the (?,?,?)
into a variable and have it recognised as placeholders?
Thanks,
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
#Threads_and_Thread_Safety
Tim.
- 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
;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.
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
.
=cut
Enjoy!
Tim.
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
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
previous Changes to credit Booking.com for sponsoring
Dave Mitchell's recent DBI optimization work.
=cut
Enjoy!
Tim.
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
test the patch ASAP, or else test the trial
release.
Thanks.
Tim.
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.
to this release, especially Dave
Mitchell for his optimization work.
Enjoy!
Tim.
.
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.
);
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
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.
frustrated.
Hopefully between Charles, Martin, and yourself, we can breath some new
life into Oracle::OCI.
Tim.
of the OCITrans*() calls as well.
Tim.
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.
as
hourly text files and then, when each is complete, using a proprietary
bulk-loading tool to load it.
Tim.
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
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.
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
- 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
- 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
- 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 - 100 of 2517 matches
Mail list logo