perl.dbi.users...Re: Detecting auto-incrementing primary keys by Daniel Kasak- July 5, 2008 Damned anti-spam server thinks I&39;m a spammer ... ... resending with my ISP&39;s mail server.See attached ...http://www.nntp.perl.org/group/perl.dbi.users/2008/07/msg33043.html DBD::CSV group by on multiple columns not working by John Krystynak- July 5, 2008 I cannot get DBD::CSV & SQL::Statement to work correctly when there ismore than 1 column in the group by.I have version 1.15 of SQL::Statement and version 0.22 of DBD::CSV.I wonder if this is a known bug, or I am missing something, becausethe docs for SQL::Statement show that it should be supportedExample:% cat > testData.csv1,1,101,2,101,3,102,1,102,1,102,1,10% cat > testdbdcsv.pl!usrbinperluse strict;use warnings;use DBI;my $csvdb = DBI->connect( "dbi:CSV:" ) die...http://www.nntp.perl.org/group/perl.dbi.users/2008/07/msg33042.html Re: No line number with RaiseError in DBD::Sybase by Michael Peppler- July 4, 2008 Douglas Wilson wrote:> On Thu, Jun 19, 2008 at 1:53 PM, Tim Bunce <Tim.Buncepobox.com> wrote:>> On Wed, Jun 18, 2008 at 02:14:06PM -0700, Douglas Wilson wrote:>>> With RaiseError or PrintError set, if DBD::Sybase throws an error, the>>> error message does not indicate what line number of the program that the>>> error was on ... or what programmodule that the error was in.>> I&39;d guess that that&39;s because sybase error messages tend to end with.http://www.nntp.perl.org/group/perl.dbi.users/2008/07/msg33041.html Kdb by Stephen Sprague- July 3, 2008 Hi fellow DBI&39;ers,I was interested to know if there&39;s been any conversations about creating aDBD::Kdb module for Kx Systems Kdb database product I see the module onCPAN called simply Kx which is a standard api into their product. Now i&39;dlike to go one step further and abstract the SQL tables portion of thisproduct into a DBI Class.Anybody hear any of any rumblings in this regard If not, i will proceed towrite one.Thanks,Stephen Spraguehttp://www.nntp.perl.org/group/perl.dbi.users/2008/07/msg33040.html Re: Nonnumeric Primary Keys by C.J. Adams-Collier- July 3, 2008 Maybe it had to do with string comparisons being more expensive thannumeric comparisons I think you can make whatever datatype you&39;d likea primary key.On Thu, 2008-07-03 at 13:41 -0400, Karen Hoofnagle wrote:> Hey, all I have a db in production that uses a whole lot of string > values as primary keys. (It&39;s Oracle, FWIW) Does DBIX::Class care > what data type a primary key is I vaguely remember hearing some > sort of remark in the Catalyst master class Jon Rockway taught.http://www.nntp.perl.org/group/perl.dbi.users/2008/07/msg33039.html Nonnumeric Primary Keys by Karen Hoofnagle- July 3, 2008 Hey, all I have a db in production that uses a whole lot of string values as primary keys. (It&39;s Oracle, FWIW) Does DBIX::Class care what data type a primary key is I vaguely remember hearing some sort of remark in the Catalyst master class Jon Rockway taught at YAPC that this is an issue, but I might have imagined it.Thanks,Karenhttp://www.nntp.perl.org/group/perl.dbi.users/2008/07/msg33038.html Re: Out of memory error with DBI - DBD::Oracle by Rich White- July 2, 2008 After getting the current versions of DBI and DBD::Oracle built and working, I no longer got the error. When I moved my "fix" from our development environment to our test environment, I found that I still got the error. I started removing the items in my "fix" from the development environment to find what really fixed it.I did not have the ORACLE_HOME environment variable set. On further investigation, I found that it does not even need to be set correctly as long as it...http://www.nntp.perl.org/group/perl.dbi.users/2008/07/msg33037.html rt.cpan.org 36395 by Tim_Bunce via RT- July 1, 2008 Queue: DBI Ticket <URL: http:rt.cpan.orgTicketDisplay.htmlid=36395 >On Tue Jul 01 01:37:00 2008, RTHANGAM wrote:> On Tue Jun 24 17:17:23 2008, TIMB wrote:> > The DBI is acting as defined. It&39;s not a bug.> > You should avoid using an array to pass arguments to execute().> > I could still see the following examples mentioned in the documentation> in CPAN where we are passing an array to execute method(). Please> comment on this.> > $rv =...http://www.nntp.perl.org/group/perl.dbi.users/2008/07/msg33036.html Re: Detecting auto-incrementing primary keys by Greg Sabino Mullane- July 1, 2008 -----BEGIN PGP SIGNED MESSAGE-----Hash: RIPEMD160> I&39;m writing a generic database interface, similar to MS Access. Up until..> So, I take it the answer is still &39;no&39;; I can&39;t portably detect this kind> of thing. I&39;ll go back to parsing the output of $dbh->column_info then.column_info() won&39;t help with with things like triggers. A generic databaseabstraction layer (at a higher level than DBI) is a wheel that has beeninvented many times over. You might be better...http://www.nntp.perl.org/group/perl.dbi.users/2008/07/msg33035.html Re: Out of memory error with DBI - DBD::Oracle by Christian Merz- July 1, 2008 Hello Rich,i checked one of my Solaris Sparc boxes. There is a much more current DBI version installed: > perl -MDBI -e &39;DBI->installed_versions&39; Perl : 5.008005 (sun4-solaris) OS : solaris (2.9) DBI : 1.48 DBD::Sponge : 11.10 DBD::Proxy : install_driver(Proxy) failed: Can&39;t locate RPCPlClient.pm in INC DBD::Oracle : 1.16Could this be a problemOn Solaris 10 (i.e. 2.10) lots of changes took place. Especially in...http://www.nntp.perl.org/group/perl.dbi.users/2008/07/msg33034.html |