.
=cut
Enjoy!
Tim.
- Forwarded message from Rouquart Wim [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
X-SPF-Guess: pass (seems reasonable for [EMAIL PROTECTED] to mail through
193.121.44.105)
X-Pobox-Antispam: Bad HELO hostname returned DENY: no A or MX records found for
sweeper.CRONOS.BE
Subject:
for everyone :-)
Tim.
It's a DBI bug (or at least mis-feature) that I'll fix for the next
release.
Meanwhile a workaround is to bypass the implicit tie STORE method
and store the attribute directly into the hash. This is probably
the simplest way (untested):
tied(%$sth)-{ParamValues} = \%ParamValues;
Tim.
On Wed
9.2.0.1 connecting to Oracle database 9.2.0.5
kathyproblem.log
I see lots of Can't run this test using Perl 5.006001 without DBI = 1.38
Is that not clear?
Tim.
the Makefile.PL- here's my diff
diff Makefile.PL.orig Makefile.PL
1122a1123,1126
# Tim Barrass: hacked for Oracle Instant Client
if ( $OH =~ /instantclient/ ) {
$linkvia = $ENV{ORACLE_HOME}/lib/libclntsh.so;
}
1254a1259
$OH/include, # Tim Barrass, hacked for OIC install from
On 17 Feb 2005, at 14:52, Tim Barrass wrote:
# look out for where your DBD-Oracle actually gets installed
export
PERL5LIB=${ORACLE_HOME}/perl-modules/lib/perl5/site_perl/5.8.0/i386-
linux-thread-multi
The eagle-eyed will notice that this should be
# look out for where your DBD-Oracle actually
could start by posting the perl -V output for the two perls.
Tim.
of clob data.
Can anyone help me ASAP.
Start here http://www.catb.org/~esr/faqs/smart-questions.html
Tim.
, this is the wrong mailing list.
Tim.
- eg configured for threads or not
- perhaps on OS X you're using unicode data
Tim.
: application/octet-stream
so most people can't easily read them.
Tim.
was planning to support Instant Client for the
next DBD::Oracle release. You've just saved me a little time digging.
Tim.
--- Makefile.PL.orig 2004-10-22 18:07:04.0 +0900
+++ Makefile.PL 2005-02-02 12:39:56.703125000 +0900
@@ -276,7 +276,7 @@
print Oracle sysliblist: $syslibs
Thanks for the information.
Tim.
On Mon, Jan 31, 2005 at 09:25:32AM +0100, csg wrote:
Hello!
I'm reacting to an old message:
http://www.nntp.perl.org/group/perl.dbi.users/24851
(alternate link: http://www.mail-archive.com/dbi-users@perl.org/msg23002.html)
I had got a similar problem
1.47,
Yes.
and if so, when can we expect that release?
Soonish.
Feel free to get the current (already patched) sources from
svn.perl.org (http://search.cpan.org/~timb/DBI/DBI.pm#CONTRIBUTING)
Tim.
SQLGetConnectOption/SQL_CURRENT_QUALIFIER */
Attached is a patch - if Tim likes it?
Is there any reason not to? I can't see any harm in including
deprecated names.
Tim.
it's probable that the bug is in your Mimer ODBC driver.
A patch to DBD::ODBC could be used to work around it.
Tim.
Oh, the joys of Oracle. Add require DBD::Oracle; to check if it's
a load-time or connect-time issue. Print $!. Use process tracing
tools (like truss, ktrace etc) to see what's happening. Let us know
what you find. Have the appropriate amount of fun!
Tim.
On Tue, Jan 25, 2005 at 03:51:40PM +0100
On Fri, Jan 21, 2005 at 02:04:21PM -, Addison, Mark wrote:
From: Tim Bunce Sent: 20 January 2005 11:18
On Wed, Jan 19, 2005 at 05:37:42PM -, Addison, Mark wrote:
Hello,
I'm having a very strange problem with DBD::Proxy and have ended
up with brain meltdown - so now its your
On Wed, Jan 19, 2005 at 05:37:42PM -, Addison, Mark wrote:
Hello,
I'm having a very strange problem with DBD::Proxy and have ended
up with brain meltdown - so now its your turn ;-)
Here's a patch...
Tim.
Index: t/80proxy.t
The DBI provides a neatsvpv(sv, maxlen) function specifically for
use in trace messages etc (it's the same as DBI::neat).
It handles undefs and much else besides. I'd recommend it.
Tim.
p.s. I'd also recommend turning of wrapping in your mail tool,
or setting the wrap marging higher.
On Mon
Feel free to create a DBD::DBH or somesuch.
Tim.
p.s. Best not to cross-post dbi-users and dbi-dev. This sort of 'requirements
spec'
discussion is best on dbi-users as they would be your customers.
On Thu, Jan 13, 2005 at 12:40:49AM -0600, David Nicol wrote:
That's what DBI wrappers do
(OCI_ATTR_CHARSET_FORM)
calls.
Tim.
From the oerr utility:
$ oerr ora 24328
24328, 0, illegal attribute value
// *Cause: The attribute value passed in is illegal.
// *Action: Consult the users manual and specify a legal attribute value
// for the handle.
-
Ron Reidy
as not
supporting connecting to Oracle 7. DBD::Oracle supports connecting
to whatever the Oracle you built it with can connect to.
Having said that, there may be problems with how newer features of
the OCI API are used when connected to older versions. This is probably
an example of that.
Tim.
'; #$ARGV[0];
$salt = rand(99);
$cryptpasswd = unix_md5_crypt($password, $salt);
This is off-topic for dbi-users. Please pick a more suitable forum for your
problem.
Tim.
On Tue, Dec 21, 2004 at 08:28:43PM -0500, Lincoln A. Baxter wrote:
Hi Alan,
Can you turn this script into a test using t/23wide_db_al32utf8.t
as a model. You could call it t/23wide_db_al32uft8_sp.t
Please send it to me (and Tim).
If you do, one of us can take a closer look. I think
On Mon, Dec 20, 2004 at 02:57:02PM -0500, Teddy Choi wrote:
Dear Tim Bunce,
Could you please let me know what the status is on the availability of
Oracle::OCI ?
It isn't in CPAN yet, and I haven't been able to google up a beta version.
It's been on CPAN since 31 Aug 2001: See http
disable fetchrow_hashref
I'd suggest:
columns = undef # read from first row
columns = 0 # don't read, automatically name col1,col2.,,,
Tim.
On Thu, Dec 16, 2004 at 01:01:46AM +0100, Bart Lateur wrote:
On Wed, 15 Dec 2004 12:46:16 +, Tim Bunce wrote:
It's one of those things why people say Mysql isn't a proper database.
This isn't the place to start that particular flame-fest, so I'd
appreciate it if no one does.
Sorry
enabled.
Tim.
gcc -c -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING
-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -DVERSION=\\
-DXS_VERSION=\\ -fPIC -I/usr/lib/perl5/5.8.0/ia64-linux-thread-multi/CORE
learnt. It'll make it much easier for us to help you.
Tim.
one of those things why people say Mysql isn't a proper database.
This isn't the place to start that particular flame-fest, so I'd
appreciate it if no one does.
Tim.
);
}
}
}
#endif
is_utf8_string() is defined for perl 5.8.x. That'll slow down
fetching of strings. Especially if any are long or have high bits set.
It ought not to be default behaviour as it's playing 'guessing
games' with the data without the applications permission.
}
}
Tim
On Fri, Dec 10, 2004 at 01:48:26AM +0100, Bart Lateur wrote:
There's a few bugs in the code of the section of LongReadLen, even in
the latest version of DBI that is on CPAN.
Thanks. Here's a patch.
Tim.
Index: DBI.pm
On Sun, Dec 12, 2004 at 07:08:14PM -0500, Bryan Scott wrote:
I am sort a Perl newbie. Does anyone know what I'm
Doing wrong or what I'm missing?
Don't try to build DBD::Oracle yourself.
Download a pre-built one from http://ftp.esoftmatic.com/DBI
Tim.
data, right truncation (SQL-01004)(DBD: st_fetch/SQLFetch (long
truncated DBI attribute LongTruncOk not set and/or LongReadLen too small)
err=-1) at ./tut2_9.pl line 24.
LongTruncOk is false so therefore it's an error for a long to be
truncated by LongReadLen. So the error is correct.
Tim.
support it, the DBI provides a fall-back
implementation that works - allbeit more slowly.
Tim.
On Thu, Dec 09, 2004 at 10:07:37AM -0500, Jeff Urlwin wrote:
At least DBD::ODBC supports it. Not sure of any others.
Er, ummm, not yet.
Uh. Oh well.
Tim.
p.s. You forgot to say Patches Welcome :)
On Tue, Dec 07, 2004 at 12:38:53PM -0500, Mark Stosberg wrote:
On Tue, Dec 07, 2004 at 12:38:12PM +, Tim Bunce wrote:
---
The simplest fix is to standardize one set of driver DSN attribute
names so that at least the host, port, and database (schema) can
be specified in a portable
time for motivated people to
make and send patches for their DBDs...
Tim.
with it.
I think this topic is closed.
Tim.
On Tue, Dec 07, 2004 at 08:01:16PM -0500, John Siracusa wrote:
Additions? Votes?
No additions, no votes.
We have host, port and database, with db as an alternative to database.
The bikeshed is painted. Case closed. Thank you all for playing along.
:)
Tim.
you zelots out there need to do is (gently) nag the
authors of your favorite drivers to implement this change.
The most gentle and effective way of doing that is to send them a patch.
Tim.
the CC list.
Tim.
meaning
(database vs dbname vs db vs sid etc etc).
Tim.
the Unicode section of the DBD::Oracle docs.
Tim.
On Fri, Dec 03, 2004 at 05:48:35PM +1300, Sam Vilain wrote:
Ken Williams wrote:
On Dec 1, 2004, at 3:48 AM, Tim Bunce wrote:
I know what it does, I'm trying to find real examples that demonstrate
why people think it's needed. Nick has provided a good one. Any others?
Suppose someone's
=/com.ibm.db2v7.doc/db2l0/sqll1402.htm
Tim.
On Fri, Dec 03, 2004 at 01:09:52PM -, Martin J. Evans wrote:
On 03-Dec-2004 Tim Bunce wrote:
On Fri, Dec 03, 2004 at 10:56:27AM -, Orton, Yves wrote:
It would seem that its reasonable to expect the
DSN thingee to be queryable so you can say:
my %fields=DSN
On Thu, Dec 02, 2004 at 08:53:38AM +0100, Cosimo Streppone wrote:
Tim Bunce wrote:
I know what it does, I'm trying to find real examples that demonstrate
why people think it's needed. Nick has provided a good one. Any others?
Something like DBIx::DBH is in use in our organization
case the reproduces
the problem there's little more we can do. But once you do have a test
case that shows a problem we'll aim to get it fixed quickly.
Tim.
On Tue, Nov 30, 2004 at 10:40:34PM +, Nicholas Clark wrote:
On Tue, Nov 30, 2004 at 10:32:12PM +, Tim Bunce wrote:
On Tue, Nov 30, 2004 at 09:38:47PM +, Nicholas Clark wrote:
On Tue, Nov 30, 2004 at 08:53:51PM +, Tim Bunce wrote:
The one that I've hit - specifying port
I know what it does, I'm trying to find real examples that demonstrate
why people think it's needed. Nick has provided a good one. Any others?
Tim.
On Tue, Nov 30, 2004 at 06:37:01PM -0800, Terrence Brannon wrote:
I don't get it. Can someone give me some small but real examples
On Wed, Dec 01, 2004 at 02:02:57AM -0800, Terrence Brannon wrote:
Tim Bunce wrote:
On Tue, Nov 30, 2004 at 10:40:34PM +, Nicholas Clark wrote:
I guess I don't find it natural thinking about parameters as a single
string.
Do you generally pass URLs around as a string or broken up
On Wed, Dec 01, 2004 at 10:09:55AM -0500, Ricardo SIGNES wrote:
* Tim Bunce [EMAIL PROTECTED] [2004-12-01T04:48:40]
I know what it does, I'm trying to find real examples that demonstrate
why people think it's needed. Nick has provided a good one. Any others?
I have a very similar set
On Thu, Dec 02, 2004 at 08:34:20AM +1100, Ron Savage wrote:
On Wed, 1 Dec 2004 18:39:00 +, Tim Bunce wrote:
H Tim
need a better understanding of the underlying issues. More real-
world examples would help.
Here's a real world example of how I do things, although I am in no way
On Wed, Dec 01, 2004 at 01:45:50PM -0500, John Siracusa wrote:
On Wed, 1 Dec 2004 18:39:00 +, Tim Bunce [EMAIL PROTECTED] wrote:
FWIW, the reason I'm digging here is because I agree there may be
some value in the DBI supporting something along these lines, but
I need a better
to polymorphically wind your way
through when getting the DBI attributes and driver-dsn and
driver-attributes to all meld together.
I don't get it. Can someone give me some small but real examples
of the problem that's being solved here?
Tim.
On Mon, Nov 29, 2004 at 12:19:09PM +0100, Honza Pazdziora wrote:
The latest issue of the Oracle Magazine came with this year's Editors'
Choice Awards. Since I haven't seen it mentioned here yet I thought
I'd send in a note that
Congrats, Tim!
Thanks. (Actually it was mentioned here a few
On Sun, Nov 28, 2004 at 07:15:43AM -0700, Reidy, Ron wrote:
What about allowing/forcing a has to be added to the prepare() calls to defer
describes until execute (ora_check_sql = 1)?
That attribute ought to be able to be set at the $dbh level.
Patches welcome.
Tim.
--
Ron Reidy
Lead DBA
with
threads and debugging? Do I have to remove perl 5.8.2 with threads and
debugging and install perl 5.8.2 without threads and debugging?
I hope you appreciate that both threads and debugging each slow down
perl significantly. Configuring both is even worse.
Tim.
not be safe to use. (Not because of any problem in
the DBI that I'm aware of, but because the database client code
and/or driver may have been left in a corrupted state.)
For reliability you'll need to destroy the database handle and
reconnect.
Tim.
is limited by
using prepare(). You could allow the importer to specify if
they'd like to use prepare_cached for extra speed:
use DBIx::ProcedureCall qw(sysdate:cached dbms_random.initialize);
so sysdate($dbh) then uses prepare_cached().
Tim.
Module: http://perl-pad.sourceforge.net/dbi/DBIx-Call
On Wed, Nov 24, 2004 at 08:07:33AM -0500, Hardy Merrill wrote:
Tim, can you elaborate a little? I've tried to find the referenced
documentation but can't. I don't quite understand how a CHAR datatype
can cause this problem.
Well there's:
See
http://search.cpan.org/~timb/DBD-Oracle-1.16
sometimes here (eg HPUX 11.23 Itanium Oracle
9.2.0)
);
@h_dir = keys %h_dir;
One day (soon, I'm told) they'll get the SDK files added to their
Instant Client and these headaches will be greatly reduced.
Tim.
were used when building the mysql
client
libraries.
Couldn't Makefile.PL detect this situation and give a clear message?
Tim.
There ought to be a better way. I'm not very familar with web issues
but for plain CGI I'd have expected a SIGHUP and/or SIGPIPE to be
delivered to the process. Those could be caught and trigger cleanup.
Tim.
On Sun, Nov 21, 2004 at 09:12:30AM -0700, Reidy, Ron wrote:
Look at setting
Cool.
Tim [who likes DBI plumbing modules]
If either or both of you sent the full information asked for in the
README then I'd be able to patch Makefile.PL to do-the-right-thing
for Oracle 8.0 (without risking breaking other versions).
Just send the info to me and I'll aim to deal with it before the
next release.
Tim.
On Fri, Nov 19
::OCI module).
Tim.
On Fri, Nov 19, 2004 at 04:50:45PM +, Charles Jardine wrote:
I have just tried to compile Oracle::OCI 0.06 under DBI 1.46
and DBD::Oracle 1.16. (Using perl 5.8.5-dor under Solaris 8).
The compilation failed. The first error message was:
OCI.xs, line 6: cannot find
[Please direct all questions to dbi-users. Thanks.]
On Thu, Nov 18, 2004 at 10:00:53AM +0100, Giovanni Borri wrote:
Hi Tim,
we are not using prepare_cache.
how can you destroy the handle?
The handle is a reference to an object. When there are no longer
any references the object is destroyed
the XS_DBI_dispatch function in DBI.xs especially the block
starting at line 2856.
You probably also want to read the docs for HandleError and HandleSetErr.
Tim.
with a smaller data set (using the above info)
so it can be reproduced more easily. Enable tracing. Etc etc.
Tim.
p.s. quoting performance figures is generally meaningless.
On Wed, Nov 17, 2004 at 08:40:39PM +1100, Ron Savage wrote:
Hi Folks
I've just run a test on a Pentium III @ 800 MHz
If you can post a small self-contained example that demonstrates
the problem then I'll take a look.
Tim.
On Wed, Nov 17, 2004 at 09:15:52AM -0800, Susan Cassidy wrote:
I never got any response to my question about this problem. I thought I'd
try again.
This is DBD::Oracle
Make sure your statement handles are being destroyed
as soon as they're not needed.
Using prepare_cached() is one possible cause of long-lived
statement handles.
print $dbh-{Kids} will tell you how many statement handles
exist for a given database handle.
Tim.
On Wed, Nov 17, 2004 at 06:16
elements
in the array. For 3-5 elements, works fine...the query that is dying
has 19 attributes being UPDATEd and it dies unceremoniously.
If that's true, and not a problem with your code, then there's a
bug somewhere in Pg, or DBD::Pg. Use trace() to see what's happening.
Tim.
site, I went thru the changes for all versions 4.1.0 .. 4.1.8
and 4.1.x, but did not see anything relating to this change in behaviour.
I'd guess it's a side effect of a bug fix.
But please log a bug report with them about it so a note does get added.
Tim.
information.\n;
print *\n\n;
Tim.
() data_string_desc() and data_diff()
utility functions to help diagnose Unicode issues.
All can be imported via the use DBI qw(:utils) tag.
=cut
Enjoy!
Tim.
contracts
for the DBI. These provide longer-term sustained support for DBI
development, and longer-term sustained value for you in return.
Contact me for details.
Thank you.
Tim Bunce
to many questions, including who to contact
for answers to other questions.
Tim.
p.s. The official name of the non-profit is Yet Another Society. See:
http://www.guidestar.org/controller/searchResults.gs?action_gsReport=1npoId=11592
Thanks!
Michael Tacelosky
-Original Message
On Mon, Nov 15, 2004 at 07:31:40PM +, Matt Sergeant wrote:
On 14 Nov 2004, at 23:17, Tim Bunce wrote:
On Sun, Nov 14, 2004 at 10:23:07PM +0100, Max Maischein wrote:
Tim Bunce wrote:
Anyone got an update to this?
Nope - http://www.perlmonks.org/index.pl?node_id=404191 points out
with this subject.
Too late - at least a couple of thousand people have seen this request.
Please don't post off-topic questions here. I'm sure there are many people
willing to help but it's simply an abuse of the list.
http://www.catb.org/~esr/faqs/smart-questions.html#forum
Tim.
- Forwarded message from Wikander, Ronald J [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
X-SPF-Guess: pass (seems reasonable for [EMAIL PROTECTED] to mail through
171.159.192.79)
X-Pobox-Antispam: Bad HELO hostname returned DENY: no A or MX records found for
On Fri, Nov 05, 2004 at 02:48:59PM +, Tim Bunce wrote:
On Mon, Nov 01, 2004 at 12:31:38PM -0800, David Oswald wrote:
I wanted to draw your attention to the following discussion regarding a Perl
segfault that exists across multiple platforms, and across multiple
databases:
http
On Sun, Nov 14, 2004 at 10:23:07PM +0100, Max Maischein wrote:
Tim Bunce wrote:
Anyone got an update to this?
Nope - http://www.perlmonks.org/index.pl?node_id=404191 points out that
the problem also appeared with the MySQL DBD (no version info), but I
can't replicate that with DBD::mysql
I can assure that DBD::Oracle does no such thing.
Tim.
On Mon, Nov 08, 2004 at 04:05:41PM -0500, [EMAIL PROTECTED] wrote:
My DBA is having a fit because every connection from DBI/DBD Oracle is
issuing a ALTER SESSION SET TIME_ZONE='-04:00'; . She sees this as
unneccessary and a waste
On Tue, 9 Nov 2004 10:21:48 -0500, [EMAIL PROTECTED] wrote:
Tim Bunce writes:
I can assure that DBD::Oracle does no such thing.
s/assure that/assure you that/
I have no clue what the DBA is using to watch the session traffic, and
she isn't sharing very much with me... Any way, I have a simpel
DBI
component = 'st_comp-1'** ORA-03120: two-task
conversion routine: integer overflow (DBD: oexfet error)
The Oracle OCI 7 API (which your old DBD::Oracle module is using)
does not support LOB types. Upgrade.
Tim.
BTW, perl version is 5.6.0
Any helps would be appreciated.
thx,
Richard
On Tue, 9 Nov
as it is the future of the Perl in the world and if we go by the correct way,
because the directors of the company think that no.
as it is its use in the world.
Thanks Tim
--
Open WebMail Project (http://openwebmail.org)
- End forwarded message -
On Fri, Nov 05, 2004 at 10:09:52AM +, Tim Bunce wrote:
On Thu, Nov 04, 2004 at 01:42:13PM -0800, Susan Cassidy wrote:
I finally got my large, complex cgi/Oracle application working with
DBD::Oracle 1.16, using database character set AL32UTF8, NLS_LANG=.UTF8,
etc.
And what
print out the status of utf8 below this, it now says it
is NOT utf8.
Of course.
I have re-read the Encode perldoc stuff several times. It seems to be
working (on my system) backwards, sort of?
I the DBD::Oracle 1.16 docs, Tim says:
If the string passed to bind_param() is considered
on Sun Solaris, I have perl 5.6.1, DBI 1.38 and DBD::ODBC 1.06
Is this a new problem or has it been happening for a long time
(your DBI and DBD::ODBC versions are over a year old).
Try upgrading.
Tim.
Here is a core stack:
1:
=[1] XS_DBI_dispatch(0x2ef618, 0xff107464, 0x16e4a4, 0x5, 0x11fee4
()
is returning SQLITE_OK but setting imp_sth-stmt to null.
[CC'd to Matt Sergeant for comment]
Tim.
On Fri, Nov 05, 2004 at 10:14:51AM -0500, [EMAIL PROTECTED] wrote:
Tim,
This is a new problem for me, I use this version of modules for a long time
and never had a problem, that is why, didn't upgrade it.
If the code is old but the problem is new then the code probably
isn't the problem
On Fri, Nov 05, 2004 at 10:24:39AM -0800, Susan Cassidy wrote:
Hi,
Thanks Tim.
I'm not sure what you mean by the _client_ CHAR and NCHAR character sets.
How do I check? (Obviously, I did not install the Oracle stuff myself, and
we do not have our own DBA).
What are your NLS_LANG
please use 1.45 to get the stack trace.
Tim.
Use trace() an post (an _extract_ of) the log.
Don't forget to include relevant version numbers
(perl -MDBI -e 'DBI-installed_versions' will help).
Tim.
On Wed, Nov 03, 2004 at 03:24:20PM -0700, Ian Harisay wrote:
Hi All,
I have a query that when executed in sqlplus I get the oracle error
On Thu, Nov 04, 2004 at 02:39:00PM +0300, Odhiambo Washington wrote:
* Tim Bunce [EMAIL PROTECTED] [20041104 12:56]: wrote:
Use trace() an post (an _extract_ of) the log.
Don't forget to include relevant version numbers
(perl -MDBI -e 'DBI-installed_versions' will help).
I am not yet
(telephone interview at OSCON[1]
and a photo shoot at my house :) but the exact timing of the
announcement was a surprise.
Tim.
[1] Funny how an hour's conversation covering many topics gets
distilled down into ~200 words...
701 - 800 of 2517 matches
Mail list logo