Re: DBD::Oracle and 10g

2006-01-10 Thread Thomas Porschberg
On Tue, Jan 10, 2006 at 02:17:37PM -0500, John Scoles wrote: > Thomas Porschberg Wrote > > >Thanks for your reply ! > > >On Tue, Jan 10, 2006 at 10:09:08AM -0500, John Scoles wrote: > > Yes there is a newer Makfile.pl You might want to try that. > > >I used a newer one. But the same result. Comp

Re: extra dependancies vs. testability?

2006-01-10 Thread Tyler MacDonald
Robert Loomans <[EMAIL PROTECTED]> wrote: > > That's what it does right now. The tests don't depend on SQLite2 > > per-se, just a DSN that points to a DBI driver that supports transactions > > (eg; pretty much everything except MySQL ;-) > Errr MySQL supports transactions just fine at least

Re: extra dependancies vs. testability?

2006-01-10 Thread Darren Duncan
At 7:26 PM -0800 1/10/06, Tyler MacDonald wrote: Another option that occured to me while I was loading the dishwasher was bundling SQLite2 (or something like it) in my t/ directory. Sure, it will consume a bit of extra bandwidth when the package is downloaded, but it won't leave the bloat

Re: extra dependancies vs. testability?

2006-01-10 Thread Tyler MacDonald
Ted Behling <[EMAIL PROTECTED]> wrote: > Sorry for replying to my own e-mail, but I had another thought. What > about just failing gracefully if SQLite2 isn't available? If it's > installed, it gets used; if not, a warning is shown and the dependent > tests are skipped. That's what it do

RE: extra dependancies vs. testability?

2006-01-10 Thread Ted Behling
Sorry for replying to my own e-mail, but I had another thought. What about just failing gracefully if SQLite2 isn't available? If it's installed, it gets used; if not, a warning is shown and the dependent tests are skipped. -Original Message- From: Ted Behling Sent: Tuesday, January

RE: extra dependancies vs. testability?

2006-01-10 Thread Ted Behling
I haven't used this module myself, but perhaps create two test suites: "make test" tests everything you can test without burdensome external dependencies, and "make testsql" either depends specifically SQLite2 or using a user-provided DSN. The users who want to put more effort into testing can

extra dependancies vs. testability?

2006-01-10 Thread Tyler MacDonald
DBIx::Transaction currently only depends on DBI, but for it's unit tests to run you need a DBI driver available. If SQLite2 is available, it gives you a nice default DSN to test DBIx::Transaction in a completely self-contained environment. The problem I'm facing is that smoke teste

Re: How many rows can be fetched using DBD::Informix?

2006-01-10 Thread Tim Bunce
On Tue, Jan 10, 2006 at 01:14:35PM -0500, Jeffrey Seger wrote: > I can attest that there is no max number of rows set, or at least if there > is, it's way higher than 35k. I have pulled hundreds of thousands of rows > from an informix database using DBI with no limit found yet. However, what > yo

RE: DBD::Oracle and 10g

2006-01-10 Thread Andy Hassall
> Yes there is a newer Makfile.pl You might want to try that. > > One other quick suggestion id to set > > NLS_LANG=WE8ISO8859P15 > > This is the the value I have used sucessfully in the past. Presumably you mean NLS_LANG=.WE8ISO8859P15 The leading "." is required (to skip the language and t

Re: DBD::Oracle and 10g

2006-01-10 Thread John Scoles
Thomas Porschberg Wrote >Thanks for your reply ! >On Tue, Jan 10, 2006 at 10:09:08AM -0500, John Scoles wrote: > Yes there is a newer Makfile.pl You might want to try that. >I used a newer one. But the same result. Compilation is ok, >but the tests fail. > > One other quick suggestion id to set

Re: DBD::Oracle and 10g

2006-01-10 Thread Thomas Porschberg
Thanks for your reply ! On Tue, Jan 10, 2006 at 10:09:08AM -0500, John Scoles wrote: > Yes there is a newer Makfile.pl You might want to try that. I used a newer one. But the same result. Compilation is ok, but the tests fail. > > One other quick suggestion id to set > > NLS_LANG=WE8ISO8859P15

Re: install DBD-Oracle win32

2006-01-10 Thread John Scoles
I have seen similar when there is a space in a path someplace. Could that be it? Check to ensure you do not have a space in you Perl dir. ""Christopher T. Brown"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I am running the install DBD-Oracle command on my WIN machine with the >

RE: [Fwd: install DBD-Oracle win32]

2006-01-10 Thread Matthew Ramadanovic
Have you tried only using the / character or even not using them at all? C:\PPM i c:/temp/DBD_Oracle-1-872-1136408691 Or Cd c:\ppm Ppm i DBD_Oracle-1-872-1136408691 Works fine on XP SP2. -M > -Original Message- > From: Christopher T. Brown [mailto:[EMAIL PROTECTED] > Sent: Tuesday, Ja

[Fwd: install DBD-Oracle win32]

2006-01-10 Thread Christopher T. Brown
Actually the full error is: I am running the install DBD-Oracle command on my WIN machine with the following error: Can't remove directory C:\TEMP/DBD_Oracle-1-872-1136408691: Permission denied at C:/Perl/site/lib/PPM/Repository.pm line 247 Can't figure out where the '/' is coming from. I wa

install DBD-Oracle win32

2006-01-10 Thread Christopher T. Brown
I am running the install DBD-Oracle command on my WIN machine with the following error: Can't remove directory C:TEMP/DBD_Oracle-1-872-1136408691: Permission denied at C:/Perl/site/lib/PPM/Repository.pm line 247 I was able to install other packages. Any ideas. Thanks -- --

Re: How many rows can be fetched using DBD::Informix?

2006-01-10 Thread Jeffrey Seger
I can attest that there is no max number of rows set, or at least if there is, it's way higher than 35k. I have pulled hundreds of thousands of rows from an informix database using DBI with no limit found yet. However, what you are doing with those rows matters greatly. If you are throwing them

Re: How many rows can be fetched using DBD::Informix?

2006-01-10 Thread John Scoles
I do not think there is any maximum # of rows. As I have have use queries with it well over 35k rows. It would be dependant on the size of fields in each row and the amount of memory you have. In this case I think you query is simply running out of memory. Try using a cursor in your SQL or use

Re: How many rows can be fetched using DBD::Informix?

2006-01-10 Thread Jonathan Leffler
On 1/10/06, Elton Hughes <[EMAIL PROTECTED]> wrote: > I have run into a problem I have not seen before. I need to select > all of the rows in a table and I am getting the following error: > > # upd_wia_test.pl > Today's date: 1/10/2006 > Running 'execute' done > Running 'fetch' Out of me

Re: Convenience function selectall_hasharrayref

2006-01-10 Thread Tim Bunce
On Tue, Jan 10, 2006 at 12:47:54PM +0100, Peter J. Holzer wrote: > or selectall_arrayhashref? > > 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 that the order is pre

How many rows can be fetched using DBD::Informix?

2006-01-10 Thread Elton Hughes
Hello All, I have run into a problem I have not seen before. I need to select all of the rows in a table and I am getting the following error: # upd_wia_test.pl Today's date: 1/10/2006 Running 'execute' done Running 'fetch' Out of memory! Issuing rollback() for database handle being

Re: DBI 1.48 connection failure to MS SQL

2006-01-10 Thread John Scoles
"Claire Lee" wrote >I didn't recompile. What I did was just use the script to try to >connect. Do I need to recompile? How do I do it? Thanks. >Jing There are a number of tutorials on the web for this. If you tell me what sort of operating system you are using I might be able to point you in the

Re: DBD::Oracle and 10g

2006-01-10 Thread John Scoles
Yes there is a newer Makfile.pl You might want to try that. One other quick suggestion id to set NLS_LANG=WE8ISO8859P15 This is the the value I have used sucessfully in the past. "Thomas Porschberg" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, > > I have 10g client install

Re: Convenience function selectall_hasharrayref

2006-01-10 Thread JupiterHost.Net
Peter J. Holzer wrote: or selectall_arrayhashref? 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 that the order is preserved, and the columns can be accessed by name

Re: Convenience function selectall_hasharrayref

2006-01-10 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > 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 that the order is preserved, and > the columns can be accessed by name

DBD::Oracle and 10g

2006-01-10 Thread Thomas Porschberg
Hi, I have 10g client installed under linux, DBI version 1.50, DBD::Oracle module 1.16. The make runs fine for DBD::Oracle but the "make test" failed. t/10general.DBI connect('','/@',...) failed: ERROR OCIEnvNlsCreate (check ORACLE_HOME and NLS settings etc.) at t/10general.t line

Re: Convenience function selectall_hasharrayref

2006-01-10 Thread John Scoles
"Peter J. Holzer" wrote >or selectall_arrayhashref? >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 that the order is preserved, and >the columns can be accessed by nam

Re: (Fwd) dbi-users@perl.org

2006-01-10 Thread John Scoles
I would have to agree most likly cause is the required packages are either not installed on your web server or were insatlled and you webserver does not have permission to read them. "Tim Bunce" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > - Forwarded message from yuehua wu <[

Re: DBI 1.48 connection failure to MS SQL

2006-01-10 Thread John Scoles
This may be a very obvious question did you recompile your DBI:ODBC at the same time? "Claire Lee" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I have a script that connects to ms sql server with > DBI::ODBC. But this code works only for DBI 1.37 > version, not for version 1.48. I

Convenience function selectall_hasharrayref

2006-01-10 Thread Peter J. Holzer
or selectall_arrayhashref? 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 that the order is preserved, and the columns can be accessed by name. Proposed use: my $emp =