Webmaster Forum / Perl / DBI Library / July 2005

there are two machines: computer1 and computer2.
Parameters of computer1:
perl 5.6.1
sname=solaris, osvers=2.8, archname=sun4-solaris-thread-64int-ld

A large Perl application (10^4 .. 10^5 lines of code) has to work with
data on an MS  SQL Server 2000 containing Unicode data in NVARCHAR
columns. Perl 5.8.6 (ActivePerl) runs on the same or another Windows
2000 Server (usually english or german). The Unicode data may contain

I think that I'd like to use params::validate to check up on values
used to create my class::dbi based objects.
Seems like the right thing to do is override sub create {} in my
subclasses, and if things validate then just call SUPER::create.

I need a kind of CDBI logging class, ie. one which logs all changes made
to the database to a loging table (within the database).
I'm guessing that this could be done through the use of triggers, but is
there a better way? Or has such a thing been implemented so many times

Hey list.
Seems the DBIx::Class thread resulted in Sebastian Riedel getting banned
from this list. I'm not sure about the reasoning behind this, but I have
to say, I find the following legal threats absolutely monstrous. Tony,

I've been following the MI vs delegation discussion with great interest.
However, Matt has been espousing NEXT quite vigorously, which is a term
unfamiliar to me in this context.
Wikipedia talks about electrical interference.

Available now for testing:
  http://homepage.eircom.net/~timbunce/DBD-Oracle-1.15-rc3-20040123.tar.gz
Hopefully this fixes (more of) the build problems.
I'd appreciate it if you could give this a whirl and report any

FYI - I've just uploaded a new test version of DBD::Sybase to CPAN (and
to www.peppler.org/downloads).
If you have the time please test this new version so that I can release
1.06 soon.

I have the same problem as described here:
http://www.nntp.perl.org/group/perl.dbi.users/7343
(searching from Oracle databases take extremely long because
DBIx::Recordset tries to get metadata for all tables), even though

I am trying to bind an undef into an IsNull on a varchar field.  When I
write the query binding directly into the IsNull I get no records, yet
if I create a SQL variable, bind the undef to that, and then use the SQL
variable - I get results.  I have created a test script that ...

(this mail also sent to both Catalyst lists but my posting addresses are
different)
People are constantly complaining on this list that Feature X hasn't made it
into Class::DBI etc. etc. or that it's too monolithic or too slow or whatever.

My current application is running on Oracle8i. The application is based
on CGI Perl and it uses DBI and DBD. I'm going to migrate my application
to Oracle9i. I would like to know which Version of DBI/DBD would be
compatible for Oracle9i.

Was this supposed to happen? A large # of tests now fail...
t/07bind.........ok 1/11Can't rebind placeholder 3 at t/ODBCTEST.pm line
228.
# Looks like you planned 11 tests but only ran 2.

does DBD::CSV supports the following select clause?
select * from table where upper (col1) like '%ab%';
I'd like to make case insensitive queries but from docs it seems
it's not allowed.

I can't see a way to have different accessor and mutator names,
depending on the calling class.
If I understand it correct alle accessors are created when the class is
use'd (from the BEGIN block?) using accessor_name, so the calling class