[EMAIL PROTECTED] wrote:
Is DBD competes with DBI or what?
thanks,
-rkl
No. They collaborate and depend on each other. There is one DBI but
there are many DBDs. There is one DBD for each kind of database (e.g.
DBD::mysql for MySQL). DBI doesn't do much without a DBD and the DBDs
do nothing
Is DBD competes with DBI or what?
thanks,
-rkl
On Sep 26, Dan Anderson scribed:
> I am trying to create a CGI perl script that uses DBI. I want to allow
> it to use any database supported by DBI without having to code for
> anything more then mySQL. Is this possible?
>
> Will I need to include all supported DBI modules (or is it DBD?) with m
[EMAIL PROTECTED] said:
> Sorry for the lack of info to my question. I have the connection working
> fine. I wanted to know what happened to the connection when I don't
> literally issue a $dbh->disconnect(). Does the connection closes
> automaitcally or the pointer is still out there wasting away
[EMAIL PROTECTED] said:
> Can anyone show me a sample of connection caching for "use DBI;" within
> cgi/mod_perl? Currently, I am using "use DBI;" not Apache::DBI because I
> can't get Apache::DBI to work.
I'm not entirely sure what you mean by "connection caching", but I think I
might have an ans
I am trying to create a CGI perl script that uses DBI. I want to allow
it to use any database supported by DBI without having to code for
anything more then mySQL. Is this possible?
Will I need to include all supported DBI modules (or is it DBD?) with my
script? How would I set something like t
Sorry for the lack of info to my question. I have the connection working
fine. I wanted to know what happened to the connection when I don't
literally issue a $dbh->disconnect(). Does the connection closes
automaitcally or the pointer is still out there wasting away resources?
I am using this in a
Just adding use DBI doesn't create a connection. I am not familiar with
mod_perl, but in general you can/should call $dbh->disconnect() once you are
finished with the database. See perldoc DBI
Quoting [EMAIL PROTECTED]:
> Does the connection disconnect automatically when I'm using it in apach
You can wrap it in an exec block and then check $@ after completion, like this:
eval {
$sth_ins_user->execute(
$user_id,
$username,
$password
);
};
if ($@) {
# custom error-handling
$dbh->rollback();
$dbh->di
Can anyone show me a sample of connection caching for "use DBI;" within
cgi/mod_perl? Currently, I am using "use DBI;" not Apache::DBI because I
can't get Apache::DBI to work.
thanks,
-rkl
Does the connection disconnect automatically when I'm using it in apache
under cgi or mod_perl using "use DBI;"?
thanks,
-rkl
I am just begginning to utilize perl w/apache. Since the amount of
documentation for perl is so overwhelming, I hope this list can help me
out.
Question: How can I determine that a failure on insert is caused by
duplicate value/primary keys? I would like to handle this specific failure
separately
We have Oracle 9i, is there a DBD::ORACLE for Oracle 9i?
Thanks,
Mei
PRIVACY NOTICE: This e-mail message, including any attachments, is for the sole use of
the intended recipient(s) and may contain business confidential and privileged
information. Any unauthorized review, use, disclosure or
Ok, I ran GRANT and I got the error
"Can't disable AUTOCOMMIT"
When I turn off autocommit then I can connect.
I did a perldoc on mysqlPP but didn't see anything about autocommit.
Greg
Gregory L. Hering
4807 Bradford Drive
Huntsville, AL 35805
(256) 722-6420
> -Original Message-
I'm using the PurePerl driver, mysqlPP, but I can't connect.
I've been using this locally on my MySQL server box and this is my first attempt to
connect remotely.
I did add a user/host to the mysql.user table for the remote host I was connecting
from.
I also tried to turn on tracing, but the log
The setting of environment variables is an OS-dependent issue. You can find
out how on google (replace Windows XP with your OS):
http://www.google.ca/search?hl=en&ie=UTF-8&oe=UTF-8&q=%2Bset+%2Benvironment+%
2Bvariables+%2Bwindows+XP&meta=
Or, if you just want to set them for a single Perl pro
mark [mark.r.o'[EMAIL PROTECTED] wrote:
> Hi,
> Anyone know how and where to set environment variables
> DBI_DSN
> DBI_USER
> DBI_PASS
That's an *AWFULLY* general question! How about telling
us your platform (OS), database, what versions of DBI and
DBD::[database] you're using, and what you've t
Hi,
Anyone know how and where to set environment variables
DBI_DSN
DBI_USER
DBI_PASS
**
This document is strictly confidential and is intended for use by
the addressee unless otherwise indicated.
Allied Irish Banks
On Fri, Sep 26, 2003 at 05:38:06AM -0500, Lodewijks, Jeroen wrote:
> Hi all again,
>
> Yesterday I had a question about DBI, Oracle and Multi processing.
> I know I sent out a lot of code, so I do understand not many people are inclined to
> answer my question.
> Perlmonks.com had some very good
Hi all again,
Yesterday I had a question about DBI, Oracle and Multi processing.
I know I sent out a lot of code, so I do understand not many people are inclined to
answer my question.
Perlmonks.com had some very good insights on my question, and I now know why it is
impossible to share a databa
Hi Steve,
as far as I ( being a DB2-DBA + perl beginner ) understand runstats it's a
db2-utility and not some kind of sql-statement, that may be run through
dbd::db2.
As I would want to program runstats with perl I would use dbd::db2 to check
which tables might need to get a update of their respe
21 matches
Mail list logo