Re: Can you recomend a DBMS?

2001-03-05 Thread Peter J . Holzer
in the latest versions. It also has (and always had) BLOBS but is rather limited in using them. It still lacks some other features which may be important such as constraints, views, and triggers. hp -- _ | Peter J. Holzer | Any machine that doesn't have perl

Re: Stored Procedure (arguments)

2001-03-13 Thread Peter J . Holzer
with the value of the variable (an empty string). Use "-w" and "use strict" to catch such errors. at compile time. Use either single quotes for the statement or escape the $ sign with a backslash. hp -- _ | Peter J. Holzer | Any machine that doesn't have perl on it

Re: Can DBD::Oracle connect to various versions of Oracle?

2001-04-30 Thread Peter J . Holzer
databases, though. hp [1] Someone once figured out the minimum of files which was needed to run DBD::Oracle. You should be able to find it in the archives, but it may change from release to release. The best is probably to do a full client installation. -- _ | Peter J. Holzer

Re: Checking for the existence of a certain row.

2001-07-09 Thread Peter J . Holzer
index on the column. I don't know how exists is implemented in oracle or sybase. hp -- _ | Peter J. Holzer | It's nice to fix problems by accident. |_|_) | Sysadmin WSR / LUGA |-- Theo de Raadt | | | [EMAIL PROTECTED]| [EMAIL PROTECTED] __/ | http

Re: Checking for the existence of a certain row.

2001-07-09 Thread Peter J . Holzer
took almost 4 hours with the CBO (two nested full table scans on the translations table), and less than 0.01 seconds with the RBO). hp -- _ | Peter J. Holzer | It's nice to fix problems by accident. |_|_) | Sysadmin WSR / LUGA |-- Theo de Raadt | | | [EMAIL PROTECTED

Re: Checking for the existence of a certain row.

2001-07-09 Thread Peter J . Holzer
slower than a normal index. If you have the space, add extra columns with the preprocessed values. hp -- _ | Peter J. Holzer | It's nice to fix problems by accident. |_|_) | Sysadmin WSR / LUGA |-- Theo de Raadt | | | [EMAIL PROTECTED]| [EMAIL PROTECTED

Re: bugzilla installation issues thought someone here might know what is going on...

2001-07-18 Thread Peter J . Holzer
on the version of Bugzilla. Redhat ported it to oracle (unfortunately, AFAICS, they didn't make a version which works with both). The Oracle-Bugzilla is available from the redhat ftp server. hp -- _ | Peter J. Holzer | It's nice to fix problems by accident. |_|_) | Sysadmin WSR / LUGA

Re: '?' in SQL-comments fails

2001-09-12 Thread Peter J . Holzer
example from Oracle8i Designing and Tuning for Performance: SELECT /*+ ORDERED */ glcc.segment1||' '||glcc.segment2||' '||glcc.segment3||' ' ||glcc.segment4||' ' ||glcc.segment5 account, [...] hp -- _ | Peter J. Holzer | My definition of a stupid question

Re: Problem installing DBI :(

2001-09-13 Thread Peter J . Holzer
-- _ | Peter J. Holzer | My definition of a stupid question is |_|_) | Sysadmin WSR / LUGA | a question that if you're embarassed to | | | [EMAIL PROTECTED]| ask it, you stay stupid. __/ | http://www.hjp.at/ |-- Tim Helck on dbi-users, 2001-07-30 PGP signature

Re: OT Perl Optimizations Was: undef NULL

2001-09-14 Thread Peter J . Holzer
{ $i = $i ? $i : 1 }, } ); I don't trust the Benchmark module, though. It reported one negative wallclock secs value at every run, and the wallclock and usr times differ too much for a test which should essentially take 100% user time. hp -- _ | Peter J. Holzer | My definition

Re: Large BLOBs

2001-09-21 Thread Peter J . Holzer
DBI's emulate-varchar behaviour in this case). hp -- _ | Peter J. Holzer | My definition of a stupid question is |_|_) | Sysadmin WSR / LUGA | a question that if you're embarassed to | | | [EMAIL PROTECTED]| ask it, you stay stupid. __/ | http://www.hjp.at

Re: ORA-01801 problem again

2001-09-21 Thread Peter J . Holzer
') with sysdate [82 lines of quotes deleted - please quote only relevant material and reply below it] hp -- _ | Peter J. Holzer | My definition of a stupid question is |_|_) | Sysadmin WSR / LUGA | a question that if you're embarassed to | | | [EMAIL PROTECTED]| ask it, you stay

Re: Oracle and date conversion

2002-07-25 Thread Peter J. Holzer
strings to time_t values, hp -- _ | Peter J. Holzer | Aeltere Sources (also solche, die schon |_|_) | Sysadmin WSR / LUGA | aelter als 12 Stunden sind) sollte man | | | [EMAIL PROTECTED]| bei Linux generell nicht einsetzen - __/ | http://www.hjp.at/ | Real Time Linux

Re: Inserting spaces into a primary key column

2002-08-16 Thread Peter J. Holzer
) It complains about trying to insect a NULL value. Oracle first strips trailing spaces and then converts the resulting empty string into a null value. You can prevent the stripping by binding the column with type ORA_CHAR. hp -- _ | Peter J. Holzer | Aeltere Sources (also solche

Re: no output with fetchrow_array

2002-11-27 Thread Peter J. Holzer
; } Hopefully I'm not mangling DBI in some evil way here, but this type of structure has worked for me repeatedly in the past It is also in the fine manual: In a scalar context, fetchrow_array returns the value of the first field. hp -- _ | Peter J. Holzer | Unser

Re: question: DBD::Oracle needed for DBI on another host?

2003-02-18 Thread Peter J. Holzer
machine running the script, Good. You don't need the database, but you do need the libraries, config files, etc. but that's not the database we want to access Simply specify the other database in the connect string. hp -- _ | Peter J. Holzer | Unser Universum wäre betrüblich

Re: Using perl 5.8.0?

2003-02-26 Thread Peter J. Holzer
. hp -- _ | Peter J. Holzer | Unser Universum wäre betrüblich |_|_) | Sysadmin WSR / LUGA | unbedeutend, hätte es nicht jeder | | | [EMAIL PROTECTED]| Generation neue Probleme bereit. __/ | http://www.hjp.at/ | -- Seneca, naturales quaestiones pgp0.pgp Description

Re: Using perl 5.8.0?

2003-02-27 Thread Peter J. Holzer
On 2003-02-27 06:17:53 -0800, Jonathan Leffler wrote: Peter J. Holzer wrote: As a workaround, you can unset the EDITOR variable. Intriguing -- and effective. I wonder how that happens! What's your value for $EDITOR - mine is usually vi or vim. Mine, too. hp -- _ | Peter

Re: DBD::CSV

2003-03-03 Thread Peter J. Holzer
an ORDERED BY clause. Tables have NO defined order in SQL. hp -- _ | Peter J. Holzer | Unser Universum wäre betrüblich |_|_) | Sysadmin WSR / LUGA | unbedeutend, hätte es nicht jeder | | | [EMAIL PROTECTED]| Generation neue Probleme bereit. __/ | http://www.hjp.at

Re: Strange security problem...

2003-03-18 Thread Peter J. Holzer
for himself) and point DBI_CREDENTIAL_FILE to it. hp -- _ | Peter J. Holzer | Unser Universum wäre betrüblich |_|_) | Sysadmin WSR / LUGA | unbedeutend, hätte es nicht jeder | | | [EMAIL PROTECTED]| Generation neue Probleme bereit. __/ | http://www.hjp.at/ | -- Seneca

Re: Strange security problem...

2003-03-18 Thread Peter J. Holzer
On 2003-03-18 15:07:23 +0100, Peter J. Holzer wrote: On 2003-03-18 02:15:25 -0500, Paul Boutros wrote: That way passwords are both centralized (for regular changes) and not present in the script itself. But are there better solutions facilitated by DBI itself? You could set

Re: DBIx::DBH - Perl extension for simplifying database connections

2004-12-09 Thread Peter J. Holzer
visit the site.) The connection strings there are for ODBC, OLE and .NET. No DBI connection strings, AFAICS. hp -- _ | Peter J. Holzer | If the code is old but the problem is new |_|_) | Sysadmin WSR / LUGA | then the code probably isn't the problem. | | | [EMAIL PROTECTED

Re: DBIx::DBH - Perl extension for simplifying database connectio ns

2004-12-09 Thread Peter J. Holzer
different and b) already has another name? This way you will confuse both MySQL users (who don't know what a tablespace is) and Oracle users (who know what a tablespace is, but expect something else). hp -- _ | Peter J. Holzer | If the code is old but the problem is new

Re: DBIx::DBH - Perl extension for simplifying database connectio ns

2004-12-09 Thread Peter J. Holzer
}); hp -- _ | Peter J. Holzer | If the code is old but the problem is new |_|_) | Sysadmin WSR / LUGA | then the code probably isn't the problem. | | | [EMAIL PROTECTED]| __/ | http://www.hjp.at/ | -- Tim Bunce on dbi-users, 2004-11-05 pgpqZzy3WZa2i.pgp

CAN-2005-0077

2005-01-28 Thread Peter J. Holzer
to overwrite arbitrary files owned by the person executing the parts of the library. I haven't seen this discussed on this list yet. Will this be fixed in DBI 1.47, and if so, when can we expect that release? hp -- _ | Peter J. Holzer | If the code is old but the problem is new

Re: CAN-2005-0077

2005-01-28 Thread Peter J. Holzer
On 2005-01-28 17:35:50 +, Tim Bunce wrote: On Fri, Jan 28, 2005 at 04:26:52PM +0100, Peter J. Holzer wrote: I just read a Debian advisory about CAN-2005-0077, claiming Javier Fernández-Sanguino Peña from the Debian Security Audit Project discovered that the DBI library, the Perl5

Re: DBD::CSV much slower on osX ?

2005-02-16 Thread Peter J. Holzer
[...] It seems that there is no bottleneck. Most of the CPU time is spent in SQL::Statement::eval_where. Unless you can change your query, you probably can't make it much faster (except maybe by moving from CSV to a real RDBMS or maybe SQLite). hp -- _ | Peter J. Holzer | If the code is old

Re: OT: No incoming messages - just wondering whether the list still works.

2005-03-07 Thread Peter J. Holzer
the weekend. (or fighting with XML instead of DBI :-)). hp -- _ | Peter J. Holzer \Beta means we're down to fixing misspelled comments in |_|_) | Sysadmin WSR \the source, and you might run into a memory leak if | | | [EMAIL PROTECTED] \you enable embedded haskell as a loadable

Re: hang with mysql in execute

2005-03-23 Thread Peter J. Holzer
on the firewall. In this case the server will terminate the connection gracefully and the client will notice this and can reopen the connection. hp -- _ | Peter J. Holzer \Beta means we're down to fixing misspelled comments in |_|_) | Sysadmin WSR \the source, and you might run

Re: hang with mysql in execute

2005-03-24 Thread Peter J. Holzer
is probably to use some keepalive mechanism. TCP keepalive would be the simplest, but there is no obvious way to enable it on either the client or the server side, so he has to change his application to issue a dummy query every $n minutes. hp -- _ | Peter J. Holzer \Beta means

Re: db or file access?

2005-04-11 Thread Peter J. Holzer
optimized for larger data items organized into trees. There is considerable overlap where neither has a clear advantage, and of course it varies depending on what RDBMS and filesystem you use. hp -- _ | Peter J. Holzer \Beta means we're down to fixing misspelled comments

Re: DBI v2 - The Plan and How You Can Help

2005-07-19 Thread Peter J. Holzer
was included in the official release, I missed the announcement). hp -- _ | Peter J. Holzer \Beta means we're down to fixing misspelled comments in |_|_) | Sysadmin WSR \the source, and you might run into a memory leak if | | | [EMAIL PROTECTED] \you enable embedded haskell

Re: DBI v2 - The Plan and How You Can Help

2005-07-19 Thread Peter J. Holzer
(as Jonathan explained at length) needs a database and a server name instead of the hostname and port, so his application won't be able to connect to Informix. hp -- _ | Peter J. Holzer \Beta means we're down to fixing misspelled comments in |_|_) | Sysadmin WSR \the source, and you

Re: DBI-1.48 bind_param_inout produces ORA-01461 colliding with a CLOB

2005-07-20 Thread Peter J. Holzer
them as parameters to execute, DBD::Oracle will perform the necessary magic for you. hp -- _ | Peter J. Holzer \Beta means we're down to fixing misspelled comments in |_|_) | Sysadmin WSR \the source, and you might run into a memory leak if | | | [EMAIL PROTECTED] \you enable

DBD::SQLite 1.09 dies if select returns 0 rows

2005-08-10 Thread Peter J. Holzer
--8--8--- The result is: 23 DBD::SQLite::db selectrow_array failed: not an error(21) at dbdimp.c line 371 at ./test_sqlite line 29. Issuing rollback() for database handle being DESTROY'd without explicit disconnect(). hp -- _ | Peter J. Holzer| In our modern say,learn,know

Re: DBD::SQLite 1.09 dies if select returns 0 rows

2005-08-12 Thread Peter J. Holzer
On 2005-08-12 14:36:02 -0400, Owen wrote: On Wed, 10 Aug 2005 21:35:31 +0200 Peter J. Holzer [EMAIL PROTECTED] wrote: the next line causes an exception, but shouldn't: $tkcount = $dbh-selectrow_array($sth, {}, 'baz'); print $tkcount\n; Yes, I get the same error message when s/baz/bar

Re: DBD::Oracle - prepare() and the utf-8 flag.

2005-08-14 Thread Peter J. Holzer
be set to AL32UTF8 to get consistent behaviour. hp -- _ | Peter J. Holzer| In our modern say,learn,know in a day |_|_) | Sysadmin WSR | world, perhaps being an expert is an | | | [EMAIL PROTECTED] | outdated concept. __/ | http://www.hjp.at/ |-- Catharine Drozdowski

Re: Bulk Inserts

2005-08-18 Thread Peter J. Holzer
On 2005-08-16 14:22:26 +0100, Tim Bunce wrote: On Tue, Jul 19, 2005 at 12:58:59PM +0200, Peter J. Holzer wrote: On 2005-07-19 14:49:57 +0530, Kiran Kumar wrote: We could have an option to do Bulk Inserts .. Seconded. Actually, DBIv1 already has it (look for bind_param_array

Re: ORA-12704: character set mismatch problem with DBD::Oracle

2005-10-27 Thread Peter J. Holzer
. It seems to work if the database is Oracle 9.2. I cannot reproduce the problem with perl, v5.8.3 built for i386-linux-thread-multi DBI 1.46 DBD::Oracle 1.15 on the same machine. hp -- _ | Peter J. Holzer| In our modern say,learn,know in a day |_|_) | Sysadmin WSR | world

mysql: begin_work after commit fails

2005-10-28 Thread Peter J. Holzer
at MySQL.pm line 336 How can this happen? hp -- _ | Peter J. Holzer| In our modern say,learn,know in a day |_|_) | Sysadmin WSR | world, perhaps being an expert is an | | | [EMAIL PROTECTED] | outdated concept. __/ | http://www.hjp.at/ |-- Catharine Drozdowski

Re: mysql: begin_work after commit fails

2005-10-28 Thread Peter J. Holzer
On 2005-10-28 18:17:22 +0200, Peter J. Holzer wrote: I have a strange problem with mysql 4.1 (innodb engine) and DBD::mysql 2.9006: A dbh-begin_work immediately after a dbh-commit fails with the error Already in a transaction. Reading the docs before posting wouldn't hurt

Re: What's the best free DB for a web-based app?

2005-11-30 Thread Peter J. Holzer
. hp -- _ | Peter J. Holzer| In our modern say,learn,know in a day |_|_) | Sysadmin WSR | world, perhaps being an expert is an | | | [EMAIL PROTECTED] | outdated concept. __/ | http://www.hjp.at/ |-- Catharine Drozdowski on dbi-users. pgpvb0THgf0gK.pgp Description

Re: [cgiapp] Best free DB for a web-based Perl app response results...

2005-12-02 Thread Peter J. Holzer
competition comes immediately to mind. hp -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users

Re: LongReadLen, lengthb() and Oracle

2005-12-14 Thread Peter J. Holzer
, NVARCHAR2, CLOB, or NCLOB. Seems that LONG and BLOB are not allowed. I always used select dbms_lob.getlength(lob_column) as length from table ... to get the size of a LOB. hp -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd

Convenience function selectall_hasharrayref

2006-01-10 Thread Peter J. Holzer
= $dbh-selectall_hasharrayref(select * from emp order by ename); for (@$emp) { print $_-{ename} ($_-{empno}): $_-{job}\n; } or for ($first .. $last) { print $emp-[$_]{ename}, \n; } or something like that. What do you think? hp -- _ | Peter J. Holzer| If I wanted

Re: Convenience function selectall_hasharrayref

2006-01-11 Thread Peter J. Holzer
On 2006-01-11 10:34:21 +0100, Peter J. Holzer wrote: On 2006-01-10 17:17:21 +, Tim Bunce wrote: Anything wrong with the existing my $emp = $dbh-selectall_arrayref(..., { Slice = {} }); ? Nothing, except that I didn't know about it. Looks like it was too obvious for me

Re: Convenience function selectall_hasharrayref

2006-01-11 Thread Peter J. Holzer
On 2006-01-10 17:17:21 +, Tim Bunce wrote: On Tue, Jan 10, 2006 at 12:47:54PM +0100, Peter J. Holzer wrote: Anyway, I rather frequently find that the most natural way to represent a query result is an array of hashes: Each row is hashref, but the the rows are in an array(ref) so

Re: Future versions of DBI to require perl = 5.8

2006-01-31 Thread Peter J. Holzer
On 2006-01-31 09:40:32 +1100, Ron Savage wrote: On Mon, 30 Jan 2006 12:55:53 +0100, Peter J. Holzer wrote: Redhat EL 2.1 perl 5.6.1 supported until May 2009 Redhat EL 3 perl 5.8.0 supported until Oct 2010 Oh. I didn't know that. Thanx. So, if Tim wants to support those sysadmins who

Re: DBI - AnnoCPAN note added

2006-03-06 Thread Peter J. Holzer
if it does, there remains a window of opportunity. hp -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi

Re: Message from Maintainer to DBD::mysql users, developers

2006-03-29 Thread Peter J. Holzer
would break a lot of existing scripts, so it should be an option at first) hp -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http://www.hjp.at

Re: Message from Maintainer to DBD::mysql users, developers

2006-04-07 Thread Peter J. Holzer
On 2006-03-29 09:58:16 -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: Since mysql supports different charsets per table and even per column, I'd like an option to automatically convert them to and from

Setting the MySQL client character set

2006-04-12 Thread Peter J. Holzer
, it does not work, and you will get very strange results. hp -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http://www.hjp.at/ | -- Jesse Erlbaum

Re: Setting the MySQL client character set

2006-04-13 Thread Peter J. Holzer
On 2006-04-12 13:25:49 -0500, Paul DuBois wrote: On 4/12/06 13:03, Peter J. Holzer [EMAIL PROTECTED] wrote: This just cost me a few hours of debugging, so I am posting it to spare others: The mysql client character set can be set to UTF-8 with: $dbh-do(set character set utf8

Re: how to hide oracle instance name within dbi code??

2006-04-13 Thread Peter J. Holzer
-- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users pgpTw9aZY499q.pgp Description: PGP signature

Re: how to hide oracle instance name within dbi code??

2006-04-13 Thread Peter J. Holzer
/environ for a process which you do not own. You cannot read that unless you are root. So on linux, putting sensitive data into the environment is about as safe as putting them into a file. -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd

Re: Installing DBD::Oracle on HP/UX

2006-05-02 Thread Peter J. Holzer
PROTECTED] The user needs the privilege to connect (of course) and create tables, indexes, etc, but no special admin privileges. hp -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I

Re: Installing DBD::Oracle on HP/UX

2006-05-03 Thread Peter J. Holzer
On 2006-05-02 15:02:46 -0400, Robert Hicks wrote: Peter J. Holzer wrote: On 2006-05-01 14:07:02 -0400, Robert Hicks wrote: It tried to connect with the scott/tiger thing on a lot of tests...and they fail (of course). You can tell the testsuite to use a different user by setting

Re: ANNOUNCE: DBI 1.52 - plus PDF of What's New presentation

2006-08-09 Thread Peter J. Holzer
? I missed OSCON this year. http://www.cpan.org/modules/by-authors/id/TIMB/DBI_WhatsNewTalk_200607.pdf hp -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm

Re: Minor gotcha with bind variables and type CHAR.

2006-08-14 Thread Peter J. Holzer
discussions about this behaviour over the years, and so far nobody could come up with a method which does the right thing in all cases - the current behaviour is the one which is least surprising in most cases. hp -- _ | Peter J. Holzer| If I wanted to be academically correct

Re: managing updates/versions of DBI on a prod box?

2006-08-28 Thread Peter J. Holzer
file to use the current version of the DBI. Details are explained on www.rpm.org. hp -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http

Re: db2 - persistent connection

2006-09-06 Thread Peter J. Holzer
server can be a lot simpler. For example, you can use a unix socket and set the permissions so that only authorized users can open it. hp -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED

Re: Migration dbi files ?

2006-09-20 Thread Peter J. Holzer
matter but a Perl hash file By Perl hash file you mean a dbm file tied to a Perl hash? If so, how does DBI fit into the picture? hp -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED

Re: Oracle and bindcolumns

2006-10-19 Thread Peter J. Holzer
. For recent versions of DBD::Oracle is a lot faster then execute for bulk inserts. hp -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http

Re: fetch or fetch hash/array ref?

2006-11-06 Thread Peter J. Holzer
with this method or should I switch to fetch hashref? This is a question only you yourself answer. Rewrite your code to use hashref. *Measure* how much slower it is. Decide whether the performance is sufficient for your purposes. hp -- _ | Peter J. Holzer| If I wanted

Re: fetch or fetch hash/array ref?

2006-11-06 Thread Peter J. Holzer
On 2006-11-06 14:37:20 -, [EMAIL PROTECTED] wrote: On 6 Nov 2006 at 14:12, Also Sprach Peter J. Holzer: On 2006-11-06 11:58:44 -, [EMAIL PROTECTED] wrote: I'm currently, for speed, using execute, bind_columns, fetch. [...] So, given that speed is paramount, should I continue

Re: Creating XML from an Oracle DB

2006-11-16 Thread Peter J. Holzer
-- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users pgpwprR6YeUgZ.pgp Description: PGP signature

Re: utf8 encoding problem

2006-12-22 Thread Peter J. Holzer
actually use, i.e., AMERICAN_AMERICA.UTF8 in your case. hp PS: Why are you using WE8DEC at all, and not ISO-8859-1? -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't

Re: utf8 encoding problem

2006-12-22 Thread Peter J. Holzer
On 2006-12-22 10:11:57 +0100, Michael Kröll wrote: Peter J. Holzer wrote: $node_name = 'wre'; my $pound = \xc2\xa3; print Pound =$pound\n; That doesn't look like a pound sign in WE8DEC. You need to set NLS_LANG to the charset that you actually use, i.e., AMERICAN_AMERICA.UTF8 in your

Re: Recommended load balancing solutions?

2007-01-11 Thread Peter J. Holzer
( [ 'dbi:Sybase:server=prod1;database=test', 'user1', 'pass1', $attrib ], [ 'dbi:Sybase:server=prod2;database=test', 'user2', 'pass2', $attrib ], [ 'dbi:Sybase:server=prod3;database=test', 'user3', 'pass3', $attrib ], ) ], ... hp -- _ | Peter J. Holzer| If I wanted

Re: Help Required:Installing DBI in Perl 5.005

2007-01-18 Thread Peter J. Holzer
/ The Oracle versions only go back to 1.14 - and may not cover the latest ones either; you can hunt those down yourself. You can find even older versions on BackPAN: http://backpan.cpan.org/authors/Tim_Bunce/ starts with DBI-0.89 and DBD-Oracle-0.47 from 1997. hp -- _ | Peter J

Re: environment variable

2007-01-22 Thread Peter J. Holzer
, not the user's login shell, so you don't have to worry about that. hp -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http://www.hjp.at/ | -- Jesse

Re: DBD::Oracle with Oracle client on Redhat Linux 7.1

2001-09-27 Thread Peter J . Holzer
the requirements (Kernel 2.4.x and glibc 2.2) are met by RH 7.1, too, so it would probably work). hp -- _ | Peter J. Holzer | My definition of a stupid question is |_|_) | Sysadmin WSR / LUGA | a question that if you're embarassed to | | | [EMAIL PROTECTED]| ask it, you stay

Re: One query on DBI-DBD for Oracle

2001-12-13 Thread Peter J . Holzer
as the normal character set and used simple VARCHAR2 and CLOB columns. hp -- _ | Peter J. Holzer | My definition of a stupid question is |_|_) | Sysadmin WSR / LUGA | a question that if you're embarassed to | | | [EMAIL PROTECTED]| ask it, you stay stupid. __/ | http

Re: Whitespace being truncated with Oracle

2002-02-28 Thread Peter J. Holzer
test and not test. But it ain't so, and it should be fixed. hp [1] DBI 1.201, DBD::Oracle 1.12. -- _ | Peter J. Holzer | My definition of a stupid question is |_|_) | Sysadmin WSR / LUGA | a question that if you're embarassed to | | | [EMAIL PROTECTED]| ask it, you

Re: Whitespace being truncated with Oracle

2002-02-28 Thread Peter J. Holzer
like the 4000 byte limit or the 38 digit limit in numbers. But DBI should not introduce any additional limits. -- _ | Peter J. Holzer | My definition of a stupid question is |_|_) | Sysadmin WSR / LUGA | a question that if you're embarassed to | | | [EMAIL PROTECTED]| ask

Re: Whitespace being truncated with Oracle

2002-02-28 Thread Peter J. Holzer
On 2002-02-28 13:38:23 -0800, Michael Peppler wrote: Jeff Hunter writes: I agree, it should be fixed. Peter J. Holzer wrote: I don't think the current behaviour[1] is correct. In perl, strings can have trailing spaces: test and test compare as not equal. In Oracle

Re: Whitespace being truncated with Oracle

2002-03-01 Thread Peter J. Holzer
features could only ever really be tested after they have been standardized (and then it's too late to change it again, if it doesn't work well). hp -- _ | Peter J. Holzer | My definition of a stupid question is |_|_) | Sysadmin WSR / LUGA | a question that if you're embarassed

Re: Whitespace being truncated with Oracle

2002-03-01 Thread Peter J. Holzer
-- _ | Peter J. Holzer | My definition of a stupid question is |_|_) | Sysadmin WSR / LUGA | a question that if you're embarassed to | | | [EMAIL PROTECTED]| ask it, you stay stupid. __/ | http://www.hjp.at/ |-- Tim Helck on dbi-users, 2001-07-30 msg09296/pgp0.pgp

Re: Using IN with prepare clause

2002-03-07 Thread Peter J. Holzer
in ( . join(',', map { ? } @fruits); $sth = $dbh-prepare($stmt); $sth-execute(@fruits); hp -- _ | Peter J. Holzer | My definition of a stupid question is |_|_) | Sysadmin WSR / LUGA | a question that if you're embarassed to | | | [EMAIL PROTECTED]| ask it, you stay stupid

Re: Using IN with prepare clause

2002-03-07 Thread Peter J. Holzer
[Changed quoting - I find the append whole message at bottom quoting style *extremely* unreadable] On 2002-03-07 08:39:41 -0500, Vorce, Tim (T.) wrote: From: Peter J. Holzer [mailto:[EMAIL PROTECTED]] Subject: Re: Using IN with prepare clause From: Andy Crichton [mailto:[EMAIL

Re: Need help with map and sort

2002-03-13 Thread Peter J. Holzer
-- _ | Peter J. Holzer | My definition of a stupid question is |_|_) | Sysadmin WSR / LUGA | a question that if you're embarassed to | | | [EMAIL PROTECTED]| ask it, you stay stupid. __/ | http://www.hjp.at/ |-- Tim Helck on dbi-users, 2001-07-30 msg09582/pgp0.pgp Description

Re: Float vs. double in MySQL

2002-03-18 Thread Peter J. Holzer
is 1007575872. hp -- _ | Peter J. Holzer | My definition of a stupid question is |_|_) | Sysadmin WSR / LUGA | a question that if you're embarassed to | | | [EMAIL PROTECTED]| ask it, you stay stupid. __/ | http://www.hjp.at/ |-- Tim Helck on dbi-users, 2001

Re: Float vs. double in MySQL

2002-03-22 Thread Peter J. Holzer
, MySQL chooses an appropriate longer type (presumably double), but this doesn't seem to be the case (at least not with 3.23.49, which is what I have here). hp -- _ | Peter J. Holzer | My definition of a stupid question is |_|_) | Sysadmin WSR / LUGA | a question that if you're

Re: BUG: Perl DBI truncates Trailing Spaces from Placeholder Bind Variables.

2002-04-03 Thread Peter J. Holzer
spaces, but doesn't allow NUL characters). hp -- _ | Peter J. Holzer | My definition of a stupid question is |_|_) | Sysadmin WSR / LUGA | a question that if you're embarassed to | | | [EMAIL PROTECTED]| ask it, you stay stupid. __/ | http://www.hjp.at/ |-- Tim

Re: fetch clob larger than 4000 chars

2002-05-29 Thread Peter J. Holzer
. Character strings cannot be longer than 4000 characters AFAIK. With DBD::Oracle you can simply use SELECT CONSENSUS_NUCL_SEQ from ... See the manual page for details. hp -- _ | Peter J. Holzer | Aeltere Sources (also solche, die schon |_|_) | Sysadmin WSR / LUGA | aelter als 12

Re: Insert a blank value into Oracle

2002-05-31 Thread Peter J. Holzer
, { ora_type = ORA_CHAR }); hp -- _ | Peter J. Holzer | Aeltere Sources (also solche, die schon |_|_) | Sysadmin WSR / LUGA | aelter als 12 Stunden sind) sollte man | | | [EMAIL PROTECTED]| bei Linux generell nicht einsetzen - __/ | http://www.hjp.at/ | Real Time

Re: Redhat Linux trying to connect to an Oracle Server without having to install Oracle Client

2002-06-14 Thread Peter J. Holzer
customized config files in the RPM. You probably don't want to include the complete CD set in the source RPM :-). Then distribute the binary RPMs to all machines. hp -- _ | Peter J. Holzer | Aeltere Sources (also solche, die schon |_|_) | Sysadmin WSR / LUGA | aelter als 12

Re: installing DBD-Informix on fedora 6

2007-01-30 Thread Peter J. Holzer
6 specifically, but on Linux boxes of various ages I have here errno 107 is ENOTCONN Transport endpoint is not connected so it's probably the same on Core 6. hp -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java

DBD::Oracle - problem with UTF-8 charset and Oracle 8.1.7

2007-02-15 Thread Peter J. Holzer
!~ m{/}) { $fn = $ENV{HOME}/.dbi/$fn; } open(FN, $fn) or die cannot open $fn: $!; my $line = FN; close(FN); my @cred = split(/[\s\n]/, $line); return @cred; } -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd

Re: DBD::Oracle - problem with UTF-8 charset and Oracle 8.1.7

2007-02-15 Thread Peter J. Holzer
either use another charset than UTF-8 (the database uses WE8MSWIN1252 anyway) or I can explicitely encode() all strings passed to DBI. Neither is particularly appealing, and I'd rather fix the problem than program workarounds. hp -- _ | Peter J. Holzer| If I wanted

Re: Problems building DBD-Oracle-1.16 on HP

2007-03-07 Thread Peter J. Holzer
-- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users pgpp8yit4GPdE.pgp Description: PGP signature

Re: Regarding Perl DBI version issue.

2007-04-04 Thread Peter J. Holzer
do much useful work with DBI in one line ... hp -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi

Re: Regarding Perl DBI version issue.

2007-04-04 Thread Peter J. Holzer
-- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users pgpCWBBzhIqOI.pgp Description: PGP signature

Is DBI::Shell still maintained?

2007-04-12 Thread Peter J. Holzer
to submit bug reports and patches is. The dbi-users mailing list? Mail to the maintainers? hp -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http

Re: DBI pure perl version 1.54

2007-04-23 Thread Peter J. Holzer
) { return 0; } If not you should install libiconv. hp -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http://www.hjp.at/ | -- Jesse Erlbaum

Re: Is PERL -- MS SQL really that difficult?

2007-04-26 Thread Peter J. Holzer
for ODBC, it must start with dbi:ODBC:. Assuming that the data source you specified is correct for the ODBC driver, the complete data source would then be 'dbi:ODBC:driver={SQL Server};Server=192.168.0.149;database=userFeedback;uid=testUser;pwd=testPass;'. hp -- _ | Peter J. Holzer

Re: Clarification on DBI module

2007-05-10 Thread Peter J. Holzer
be changed without breaking existing code, though. hp -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi

Re: DBD::Oracle installation - make test failed - ORA-28000: accout locked

2007-06-20 Thread Peter J. Holzer
PROTECTED] before make test. hp -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't, and I'm not. __/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users pgpLEovS4lK52

Re: escaping % AND \%

2007-07-02 Thread Peter J. Holzer
\E_%])/$esc$1/g; print $search_pattern\n; } prints: % - \% \% - \\\% \\% - \% which is as it should be. hp -- _ | Peter J. Holzer| If I wanted to be academically correct, |_|_) | Sysadmin WSR | I'd be programming in Java. | | | [EMAIL PROTECTED] | I don't

Re: float bug? perl 5.8, DBI and oracle 10.2.0

2007-07-10 Thread Peter J. Holzer
an Oracle database, but convert it to 0011100010101001011010010001101001110101110011010001 if it is hard coded in the script or read from a file? hp PS: The binary representations of the numbers were made with unpack(B64, reverse(pack(d, $val2))) -- _ | Peter J

  1   2   3   >