ommit;
sub connected;
sub rollback;
sub ping;
try adding extra lines for any methods that seem unsupported by DBD::Proxy.
Please let me know if that helps.
Tim.
ribute is the tablename, and
> even
> that can be left off if a sequence name is passed in via the %attrib. I've
> been
> meaning to get that part of the doc updated for a while, so thanks for the
> reminder. A patch would be overkill: could someone with commit access simply
> remove the "(e.g., Pg)" bit from that line in DBI.pm? Thanks much.
Done. Thanks.
Tim.
g for reading by
humans, it is not recomended for data transfer applications.
Tim.
On Wed, Apr 12, 2006 at 04:33:39PM +0200, Dr.Ruud wrote:
> "Jeffrey Seger" schreef:
>
> > perl -MData::Dumper -e' print Dumper @INC'
>
> Alternative:
>
> perl -MData::Dumper -e' print Data::Dumper->Dump([EMAIL PROTECTED],
> [qw(*INC)])'
Alternative:
perl -V
Tim.
- Forwarded message from Tomas Karlsson <[EMAIL PROTECTED]> -
Date: Wed, 12 Apr 2006 16:47:18 -0400
From: Tomas Karlsson <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Organization: 10 East Corp.
To: [EMAIL PROTECTED]
Subject: suggestion for DBI
Hi Tim,
I would like to s
Called "Oracle OLE DB"
(http://www.oracle.com/technology/tech/windows/ole_db/index.html), I
think...
on 4/11/06 5:02 PM, Ron Savage at [EMAIL PROTECTED] wrote:
> On Tue, 11 Apr 2006 12:58:23 -0400, Garrett, Philip \(MAN-Corporate\) wrote:
>
> HI Philip
>
>> * DBD::Proxy - requires another syst
On Wed, Mar 29, 2006 at 09:02:43PM +0100, Martin J. Evans wrote:
> Thanks Tim. I'm now hopefully looking in the right places.
>
> Not seeing execute on a selectrow_array threw me initially
> but it is an example of the problems I'm seeing.
>
> I'm having a few
...
Changed execute_array() to no longer require ArrayTupleStatus attribute.
...
I've updated the docs.
Thanks.
Tim.
On Wed, Mar 29, 2006 at 04:49:32PM +0100, Martin J. Evans wrote:
> Tim,
>
> Thanks, I do keep forgetting about Driver.xst.
>
> So, just to be clear. In DBI.pm, selectrow_array calls _do_selectrow which
> calls prepare/execute/fetchsomething but this may be overriden b
On Wed, Mar 29, 2006 at 09:58:16AM -0800, Mark Hedges wrote:
> On Wed, 29 Mar 2006, Tim Bunce wrote:
> >
> > On Wed, Mar 29, 2006 at 10:53:56AM +0200, Peter J. Holzer wrote:
> > > On 2006-01-31 01:24:18 +0100, Patrick Galbraith wrote:
> > > > I apologise for
s C implementations of selectall_arrayref and several other
methods into the driver itself. The selectall_arrayref code calls the
drivers C functions to do the work. The result is much, much, faster
than going though perl/DBI method dispatch for each row.
Tim.
> Martin
> --
> Martin J.
o it should be an option at
> first)
I think that translates into just asking DBD::mysql to set the
'connection charset' to utf8 and then mysql server will look after the
conversions for you.
Tim.
t yesterday.
> I cannot protect the $dbh->{Username} references by checking for existance
> first e.g.
> print "Username: " . $dbh->{Username} if (exists($dbh->{Username}));
> as I get the same warning message. Is this correct behavior?
Yes. It's a tied hash and the DBI doesn't provide a useful EXISTS method.
> I found:
Yeap. That's the right spot. Just add in a case for Username.
Tim.
at the very
> >least, you should install a newer version of DBI.
>
> Good Call, I have upgraded to 1.50, but alas *still* only
> $dbh->{'mysql_insertid'} works.
The DBI doesn't implement the last_insert_id() method, the driver needs
to do that.
Tim.
oject, and Jonathan Leffler.
Tim.
On Thu, Mar 02, 2006 at 10:14:16AM -0800, Jonathan Leffler wrote:
> - Message from Marc Deslauriers <[EMAIL PROTECTED]> on Wed,
> 01 Mar 2006 20:22:16 -0500 -
> To:bugtraq@securityfocus.com, full-disclosure@lists.grok.org.uk
> Subje
want
> ..please tell me..
> > > > > Can't mix placeholder styles (:foo/:1) at
> > > >
> > > > Well you can't, I would need to see the $statemnet in order to help.
It's the SQL statement you are passing to prepare() that has the problem,
not a perl statement. Please post the SQL statement.
Tim.
g:
>
> selectall_hashred(sql, ['meeting_id', 'race_id'])
Try producing a very small self-contained test case (one that creates and
populates the tables it uses with a small amount of data) so others can
easily investigate.
Tim.
On Mon, Feb 13, 2006 at 10:30:46AM -0500, Robert Hicks wrote:
> Tim Bunce wrote:
> >On Fri, Feb 10, 2006 at 02:50:11PM -0800, Bill Moseley wrote:
> >>I'd like to see all of the prepared_cached() and execute() statements
> >>when tracing. Currently that output
27;ll get to it at some point but, as always, patches welcome!
Tim.
> I just tried it on a machine at $VERSION 1.48 and it didn't work. :-(
>
> (This with a filehandle pointing at a pipe, I was going to try a tied
> filehandle if that worked.)
>
> Thanks,
> Ben
>
&g
I think $h->trace($level, $filehandle) works now so I think you can
used a tied filehandle - certainly that's my intention.
Then the PRINT method of your tied filehandle class can do whatever you
want.
Tim.
On Fri, Feb 10, 2006 at 08:55:30PM -0800, Ben Tilly wrote:
> Is there any
it is in the docs.
Were the docs not clear enough?
Tim.
it should fail
> gracefully.
I agree. (Though I believe there were good reasons at the time the
original lines were added - but I don't recall them now.)
I've removed them.
Tim.
rewrite it in Java, I thought this mailing list is my last hope :)
>
> What should I do to get a connection from my little perl script? I have no
> experience with ODBC, but I think it's the same problem there (yeah, the
> database is pretty old).
Install Oracle 9 and build DBD::Oracle using that.
Tim.
be reasonable for Apache::DBI to provide a way for applications
to call disconnect() and have it actually disconnect.
> Yeah, I ditched Apache::DBI early in diagnosing this problem. Then I
> wrote that hack to solve it, which is what has started this whole thread. I
> was happy just posting the hack and leaving it at that, but you guys keep
> egging me on ;-)
Like detectives egging on the chief witness :)
Tim.
s my PerlPostConfigHandler:
> [...]
> - use this as my PerlPreConnectionHandler:
> [...]
Seems like hack without actually identifying the source of any problem
in the existing DBI or Apache::DBI code.
With a little more digging I'm sure you could identify _why_
Apache::DBI::connect
is giving you back a dead handle. Fixing that would 'help save the world' for
countless other users. Can you try that?
Tim.
On Wed, Feb 01, 2006 at 01:52:02PM +0200, Marko Asplund wrote:
> On 2006-02-01, at 00.45, Tim Bunce wrote:
>
> >There are memory allocation debugging tools that may help to isolate
> >the original problem and so give some confidence that it's not present
> >in the ot
ethod to abstract this and
do-the-right-thing for the database being used.
Tim.
> Regards,
> Renee
>
> Am 31.01.2006 um 23:58 Uhr haben Sie geschrieben:
> > Alexander Foken wrote:
> > > You need to pass the quotes to the SQL engine. And by the way, you
> &g
ent.
Why?
The Perl -DPERL_POLLUTE_MALLOC option may be of use. But you might just
be trading one can of worms for another.
Also, try http://www.data-plan.com/public/DBD-Oracle-1.17-RC6.tar.gz
I don't think there are any relevant changes but I'd be interested to
know if you get similar behaviour on the various systems.
Tim.
s for you (make test passes) then please just send me
personally a short email saying so. Ideally with your Oracle client and
server version number and characters sets. Just so I can gauge progress.
Thanks you!
Tim.
=head1 Changes in DBD-Oracle 1.17 (svn rev 2460) 27th January 2006
s.) That'll have the side effect of
incrementing the row count for that $sth, but that's not a problem in
your situation.
Tim.
On Fri, Jan 27, 2006 at 07:05:15AM -0500, Jeff Urlwin wrote:
> Tim,
>
> Is this now going to be rescinded, in light of the rest of the thread
> with Gisle?
Possibly. Though I've had emails from people thanking me for saying
this since, they say, that's the only way their em
ange :)
> >
> > The 'big issue' is how to deal with attribute values that have changed
> > since the $dbh was created.
>
> Q: Which ones does clone use now?
See the docs and then the code...
Tim.
is very risky and may not work.
Or worse, may appear to work but cause subtle problems.
Tim.
> Q: Is there any chance of getting a 'seek' to handle this?
> It would look sometehing like:
>
> $sth->seek( $sth->rows );
>
> and save me from retrieving the entire list of rows into
> core on the local side just to discard them.
No. At least not till someone added even basic support for scrollable
cursors.
> Aside: How likely to change is dbh->clone as of 1.50?
>
> The "clone" method was added in DBI 1.33. It is very new and likely
> to change.
The more widely it's used the less likely it is to change :)
The 'big issue' is how to deal with attribute values that have changed
since the $dbh was created.
Tim.
l. Just how mad do you want to be?
You're going to have to do some thinking and testing yourself on this
one Steven. You're the first to walk down this particular path.
Should be an interesting journey though!
Tim.
On Wed, Jan 25, 2006 at 02:51:14PM -0500, Steven Lembark wrote:
>
>
> -- Tim Bunce <[EMAIL PROTECTED]>
>
> >> $dbh->connect_cached( @{ $meta{ $dbh } } );
> >
> > If the connection has failed then connect_cached() will return a new,
> &
, and users
O/S distributions that ship perl pre-built with threads enabled.
Tim.
rn a new,
different, $dbh which would be lost with the code above.
To change the $dbh in the application to be this new $dbh you'd need to
use swap_internal_handle(). If I was mad enough to try this I'd probably
do:
$new_dbh = $dbh->clone;
$dbh->swap_i
uld start here:
http://search.cpan.org/~timb/DBI/DBI.pm#ODBC_and_SQL%2FCLI_Standards_Reference_Information
Tim.
ux/CORE/cop.h:217: error: syntax error before
> "bool"
The compiler doesn't like perl's own header files.
Perhaps you're not using the same compiler that that perl was built with.
It's important that you do.
If all else fails, build and install a fresh perl and use that.
Tim.
s loaded before DBI, or if you do
$DBI::connect_via = "Apache::DBI::connect";
Tim.
tter, way is to use prepare_cached() along with connect_cached().
http://search.cpan.org/src/TIMB/DBI_AdvancedTalk_2004/sld029.htm and later
slides.
Tim.
al that triggers the problem?
Does changing the code to this fix it:
Scalar::Util::weaken( \my $test );
Thanks!
Tim.
Great. Thanks Tom.
Tim.
On Wed, Jan 11, 2006 at 01:10:43PM +0100, Tom Schindl wrote:
> and here's the proposed patch hopefully my english is good enough.
>
> Tom
> Index: DBI.pm
> ===
> --- DBI.pm(Revi
On Fri, Jan 06, 2006 at 06:05:51PM +, Tim Bunce wrote:
> On Fri, Jan 06, 2006 at 09:07:42AM -0800, Gerald Gallagher wrote:
> > Trying to compile DBI 1.50 on Solaris 8 using Sun WorkShop 6. The
> > "40profile" test fails because dbi_profile_merge is returning way too
On Wed, Jan 11, 2006 at 10:37:58AM +0100, Tom Schindl wrote:
> Tim Bunce wrote:
> >Anything wrong with the existing
> >
> >my $emp = $dbh->selectall_arrayref("...", { Slice => {} });
> >
> >?
> >Please spread the word. Way too many people
what a friend of mine calls
> "sip and spit", meaning read a row, process a row, read a row, process a
> row.
Yeap: http://search.cpan.org/src/TIMB/DBI_AdvancedTalk_2004/sld017.htm
Tim.
> On 1/10/06, John Scoles <[EMAIL PROTECTED]> wrote:
> >
> > I do not think
});
?
Note that selectall_*arrayref* defines the outermost data that the
method returns. What's inside that is controlled by attributes.
For example, want an array or arrays where the inner arrays contain
only the 2nd and 3rd fields? Easy:
my $emp = $dbh->selectall_arrayref("...", { Slice => [2,3] });
Please spread the word. Way too many people seem to not know about this!
Tim.
you know how to fix it? I am running windows 2000 with an
> Oracle 9i client and ActivePerl 5.8.7.815.
That's saying that the Oracle.pm file is from 1.06 but the Oracle.dll
file is from 1.16. Generally it's caused by people trying to install
DBD::Oracle by hand or rearranging the li
- Forwarded message from yuehua wu <[EMAIL PROTECTED]> -
Date: Mon, 09 Jan 2006 12:11:09 -0700
From: yuehua wu <[EMAIL PROTECTED]>
Subject: dbi-users@perl.org
To: [EMAIL PROTECTED]
Dear Tim Bunce,
I am writing this letter to get help from you. I install DBD::Oracle i
being included
via `cat app/oracle/product/10.2.0/lib/sysliblist`. Take a look.
If so, try replacing the `cat ...` with the contents of sysliblist minus
libirc.a.
Tim.
> I orginally got an error asking me to use the -fPIC flag and I have
> recompliled both Perl, DBI whith this flag and
5.8.4 compiled with
> USE_LONG_DOUBLE ? I don't have the option to recompile Perl... Anyone have
> suggestions?
You can ignore the 'failure'. The test need to be reworked to be less sensitive
to this issue.
Tim.
>
> #> make test TEST_FILES="t/40profile
lity with the old perl4 APIs (ie Oraperl).
Setting $sth->{Compat} = 1 will make DBIc_COMPAT(imp_sth) true.
So that gives you a pure-perl workaround.
Tim.
p.s. I've no idea why it's used in DBD::mysql in this way.
On Fri, Dec 30, 2005 at 12:58:02PM +0100, wernerus sebastien wrote:
> Tim, I made the changes you suggested. Here is the code:
> ---
Thanks.
> ---
>
> But it gives exactly the same result, namely:
> connection ok
>
The connect() method needs to be in a MySubDBI::dr package (that's dr not db)
Tim.
On Thu, Dec 29, 2005 at 12:39:39AM +0100, wernerus sebastien wrote:
> Hi,
>
> I'm new to OO programming, and i'd like to subclass DBI for some purpose.
>
> I made some tests to fig
options.
> ** Does anyone have an idea about what's happening?
The Makefile.PL only adds the options for GCC versions >= 3, but it
turns out that those options were only added in later versions.
What do
perl -V:gccversion
and
gcc --version
say?
Tim.
");
@fieldsNAmes = @{$sth->{NAME}}; # or NAME_lc or NAME_uc
> Also for PHP as we have phpinfo() function, what is a
> similar function in PERL?
Perhaps the Config module has whatever it is you're looking for.
See also http://www.catb.org/~esr/faqs/smart-questions.html
Tim.
ill include the OCI API calls. But they're bound to be
the same as the only think you're changing is the SQL.
I've not seen a response to my suggestion that you try other
values of ora_ph_type.
Tim.
; <- $DBI::errstr= undef
>DBI connect
> ('database=;host=*;port=5432','muuser',...) failed: (no error
> string)
>
> Any ideas? Thanks,
Whatever the underlying issue is, there's clearly a bug in DBD::Pg in
that there's some path through the code that doesn't record an error
when it should.
Tim.
- Forwarded message from Ron Warshawsky <[EMAIL PROTECTED]> -
Date: Mon, 26 Dec 2005 03:11:56 -0800 (PST)
From: Ron Warshawsky <[EMAIL PROTECTED]>
Reply-To: Ron Warshawsky <[EMAIL PROTECTED]>
Subject: Re: Cross-version DBD Oracle Connectivity for local SYSDBA conne
bit overkill
> and a PITA due to all the extra modules I'm using) how can I debug
> this to figure out why DBI is barfing?
Try using a higher level of DBI trace, such as DBI->trace(15), before
the connect call.
Tim.
undef,
> state=undef) at foo.pl line 666.
That was fixed in 1.16. The Changes file says:
Fixed setting of $DBI::err to 0 triggering PrintWarn in DBI >= 1.41.
Tim.
On Wed, Dec 21, 2005 at 09:29:18AM -0600, Igor Korolev wrote:
>Wayne, Tim,
>
>Any ideas why DBD::Oracle incorrectly binds even non-numeric value
> '1130979589-6919-090637' from the
>below example ?
I don't understand the question.
Tim.
If you use the CPAN module to download the DBI it would have looked
after that for you. Try using
perl -MCPAN -e shell
then, after a once-off configuration, just type 'install DBI'.
Tim.
p.s. perl 5.6.1 is very old. I recommend you upgrade.
On Mon, Dec 19, 2005 at 11:47:59PM +0100, [EMAIL PROTECTED] wrote:
> Hi Tim,
>
> is it possible to introduce one new "field" (attribute) for an executed
> statement?
>
> With $sth->{Statement} you just get the "prepared" statement, but if you
> use p
On Mon, Dec 19, 2005 at 01:28:32PM -0500, Mladen Gogala wrote:
> On Mon, 19 Dec 2005 14:04:27 +0000, Tim Bunce wrote:
>
> > On Sun, Dec 18, 2005 at 12:41:13PM +, Linda Westmore wrote:
> >>
> >> Hi,
> >>
> >> i am trying to get in contact with
On Sun, Dec 18, 2005 at 12:41:13PM +, Linda Westmore wrote:
>
> Hi,
>
> i am trying to get in contact with Tim bunce. He is an old friend of
> mine and i have lost his address. can you help?
Hi Linda! Great to hear from you. I'll reply separately.
Tim.
naging that is not as convenient or transparent
> as just using the higher-level methods such as selectall_arrayref().
I think the options above strike a reasonable balance. (Especially as
you're the first person to ask about it here for a long time.)
Tim.
- what are the Oracle version numbers of your client and server
- what does this print:
$nls = $dbh->ora_nls_parameters();
print "Server $nls->{NLS_CHARACTERSET} /
$nls->{NLS_NCHAR_CHARACTERSET}\n";
print "Client $ENV{NLS_LANG} / $ENV{NLS_NCHAR}\
(returns 'dr', 'db', or 'st')
Adding trace message in DESTROY if InactiveDestroy enabled.
Ported DBI::ProfileDumper::Apache to mod_perl2 RC5+
thanks to Philip M. Golluci
=cut
Enjoy!
Tim.
I don't know where the LENGTHB suggestion came from, but I'll fix it.
Thanks.
Tim.
On Wed, Dec 14, 2005 at 01:10:50PM +0100, Peter J. Holzer wrote:
> On 2005-12-14 11:38:56 +1100, Ron Savage wrote:
> > The DBI docs for LongReadLen say to use LENGTHB() for Oracle, but that
http://search.cpan.org/src/TIMB/DBI_AdvancedTalk_2004/sld022.htm
http://search.cpan.org/~timb/DBI/lib/DBI/Profile.pm
Tim.
On Mon, Dec 12, 2005 at 03:03:09PM +, Henry McGuinness wrote:
> Hi,
> I'm writing a program that uses DBI/Mysql and does a
> *lot* of selects and inserts
Has anyone got any experience with Apache::DBI::Cache that they might
like to share?
Tim.
http://search.cpan.org/~opi/Apache-DBI-Cache/
te cache
(attribute values which have been fetched and the driver has cached
because they don't change, such as $sth->{NAME})
Tim.
now handles also have
weak reference magic.)
Although the best fix would be to DBD::Oracle (which I'll do for the
next release), I'll see if I can fix it from the DBI side to avoid a lot
of inconvenience for people.
Tim.
> "You can't do it. DBD::Oracle doesn't support TAF, direct loads or array
> interface. DBI is not database neutral. DBI is geared toward MySQL and
> PostgreSQL.
>
> DBD::Oracle is not being fixed because Tim Bunce is pushin open source
> databases, and Oracle driver i
Looks like a bug. The C version of selectrow_array is using
XSRETURN_UNDEF which will return an undef not an empty list.
Patch to follow, hopefully today.
Thanks!
Tim.
On Tue, Dec 06, 2005 at 11:41:18AM -, Martin J. Evans wrote:
> The documentation for selecrow_array in DBI 1.49 s
e changes to take_imp_data required by DBI::Pool were included in DBI 1.49.
Now someone just needs to re-test and finish up work on DBI::Pool.
I'm not sure if Stas is planning to do that himself or is looking for
volunteers.
Tim.
Field 3 has an Oracle type 187 which is not explicitly supported
>
> Any ideas?
Support for TIMESTAMP columns was added in 1.15 and extended in 1.16.
Please double check that the version of the code that's actually running.
Beyond that, a relevant chunk of DBI trace would help. Say level 4.
Tim.
suspect that Oracle had a very different motivation in buying InnoDB.
> Controlling core technology used by your competition comes immediately
> to mind.
Let's keep this thread on-topic please.
Tim.
for the bind_columns method:
$sth->execute;
my %row;
$sth->bind_columns( \( @row{ @{$sth->{NAME_lc} } } ));
while ($sth->fetch) {
print "$row{region}: $row{sales}\n";
}
I hope you'll agree, Todd, that there's no need for an extra module.
CPAN has more than enough DBI helper/wrapper modules already.
Tim.
rrent_database? under Pg at least,
> schemas and db's are different) method. Which way is the right way to go here?
Generally DBI drivers should "do what the database vendors own ODBC
driver does" (or what the SQL 2003 standard mandates).
Though it seems GetSessionInfo isn't part of ODBC, it is in the SQL1999
and later standards.
I think the "right way to go here" is to add $dbh->get_session_info($type)
in a very similar way to how get_info() is handled. Patches welcome.
Tim.
On Wed, Nov 30, 2005 at 04:19:18PM -0500, Andrew Sullivan wrote:
> On Tue, Nov 29, 2005 at 07:44:05PM +0000, Tim Bunce wrote:
> > On Tue, Nov 29, 2005 at 10:50:01AM -0800, Tyler MacDonald wrote:
> > > PostgreSQL, doing a SELECT on a table that doesn't exist poisons the r
On Wed, Nov 30, 2005 at 04:25:41PM +0100, Steffen Goeldner wrote:
> Tim Bunce wrote:
>
> >
> [...]
> >
> > Why not help save the world and help me add current_schema() to the DBI
> > and send implementations to the authors of drivers you're using?
>
>
-
> Argument " " isn't numeric in repeat (x) at
I believe this is fixed in DBI-1.49 (just released).
Tim.
I'd just like to ask anyone thinking of replying to this thread to *please*
only do so if you can add something useful that's not already been said,
and do so politely, with consideration for the validity of other peoples views.
Tim.
On Tue, Nov 29, 2005 at 05:02:23PM -0800, John Armst
On Tue, Nov 29, 2005 at 04:05:26PM -0800, Tyler MacDonald wrote:
> Tim Bunce <[EMAIL PROTECTED]> wrote:
> > PostgreSQL is non-standard (and inconvenient) in this respect.
>
> I chatted with Mischa (my work's resident DB guru) about this, and
> according to him,
Type} docs (returns 'dr', 'db', or 'st')
Adding trace message in DESTROY if InactiveDestroy enabled.
Ported DBI::ProfileDumper::Apache to mod_perl2 RC5+
thanks to Philip M. Golluci
=cut
Enjoy!
Tim.
On Tue, Nov 29, 2005 at 10:50:01AM -0800, Tyler MacDonald wrote:
> Tim Bunce <[EMAIL PROTECTED]> wrote:
> > I'll guess that what you're really after is to be able to call begin_work
> > again whilst an earlier begin_work is in effect and have the DBI keep a
>
On Mon, Nov 28, 2005 at 12:12:16PM +0100, Wieland Pusch wrote:
> Hello Uthayakumar,
>
> I guess the oracle client libraries change the $SIG{CHLD} handler.
While the oracle client libraries do do that, the mysql client librarary
(being used here) doesn't - as far as I know.
Tim
error from grep will be due to awk exiting before it has processed
all the data from grep. That's probably due to the exit in the awk script.
It's not clear why using DBI should affect the behaviour.
But you've not included the whole script so I can't help more.
I suggest you rewrite the awk script to not use exit, or
rewrite the script to not need awk at all.
Tim.
On Mon, Nov 21, 2005 at 04:39:40PM -0800, Chuck Harding wrote:
> The patch does not apply against the 1.16 version of the Makefile.PL as
> the code that handles the 10g instant client is not in the file.
Okay. So what happens when you apply it by hand?
Tim.
...
(Might need to be applied by hand to your Makefile.PL)
Please (everyone) let me know if this works for you, or not.
Thanks.
Tim.
--- dbd-oracle/branches/pythian/Makefile.PL (original)
+++ dbd-oracle/branches/pythian/Makefile.PL Sun Nov 20 14:54:09 2005
@@ -327,6 +327,31 @@ elsif ($::o
'm not sure how this mailer handles
> attachments to usenet posts. The edited files are available for now at
> http://home.fnal.gov/~dbox/DBD-Oracle-1.16/
Thanks Dennis.
It would be a big help to me if you could repost using "diff -u ..."
instead of plain diff.
Tim.
Let's close this thread now. Thanks.
Tim.
On Fri, Nov 18, 2005 at 03:49:21PM +0200, Nitzan Shaked wrote:
> Thanks Tim.
>
> > I'll clarify the docs. Basically all methods calls reset err except for
> > just a few special cases such as err and errstr, obviously, and FETCH
> > eg $foo = $h->{SomeAttribute}).
ectall_hashref( ... );
die(...) if $DBI::err;
> Looking at selectrow_hashref() says that error is indicated by undef. It
> does *not* say err will be set. So I can only assume I need to:
>
> my $hr = $dbh->selectrow_hashref( ... ); !defined $hr && die( "..." );
my $hr = $dbh->selectrow_hashref( ... ) or die(...);
Tim.
- Forwarded message from liu liu <[EMAIL PROTECTED]> -
X-Pobox-Antispam: dnsbl/blackholes.five-ten-sg.com returned deny: for
65.54.168.32(bay113-f22.bay113.hotmail.com)
X-Originating-IP: [211.94.130.232]
X-Originating-Email: [EMAIL PROTECTED]
From: "liu liu" <[EMAIL PROTECTED]>
To: [EMAIL
t; ld: Unrecognized argument: -Wl,+s
> Fatal error.
>
> Maybe this isn't related to perl or dbd-oracle at all because I have a
> similar error with +DD64 while compiling mod_perl. If this finally works
> and there is some interest I will gladly publish what I have done.
Of course, please do. A patch to Makefile.PL would be nice.
Tim.
state (SQL-24000)(DBD: dbd_describe/SQLNumResultCols err=-1)
> confess at x.pl line 21
> main::error_trap('DBD::ODBC::st execute failed:
> [unixODBC][MySQL][ODBC 3.51 Dri...', 'DBI::st=HASH(0x8248b04)',
> 'undef') called at x.pl line 12
>
> It would appear setting ShowErrorStatement:
>
> 1. causes the code to run further before stopping
> 2. loses an error
>
> Any ideas?
The key is "Describe failed during
DBI::st=HASH(0x8248af8)->FETCH(ParamValues,0)".
ShowErrorStatement is fetching the value of the ParamValues attribute
so it can add the parameter values, if any, to the error message.
But the FETCH of ParamValues is itself failing.
Tim.
501 - 600 of 2828 matches
Mail list logo