Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: Tricks with DBI (esp. Connect)

by htoug (Deacon)
on Aug 15, 2001 at 12:33 UTC ( #104986=note: print w/ replies, xml ) Need Help??


in reply to Tricks with DBI

In newer versions of DBI the connect call has changed (the old one still works, but is depreceated). The call should be:

my $dbh = DBI->connect("dbi:mysql:foo", "bar", "baz", { AutoCommit => 1, RaiseError => 1}) or die die "Can't connect: ", $DBI::errstr;
Where the "dbi:mysql:foo" bit is "dbi:'DBD-driver-name':'database-name-and-options'".
You will have to see in the documentation for your chosen DBD to see what is possible and legal for the 'database-name-and-options' part.

RaiseError is set in an anonymous hash - along with other database attributes.

Note that I set AutoCommit state in the connect call. This is highly recommended, and will become mandatory in a coming DBI release.
The reason is that the ODBC spec (which DBI follows as closely as possible) has AutoCommit=>1 as default, while many (most?) major database systems have AutoCommit=>0 as default. This has lead to much confusion and tearing of hairs in the past, as things were commited unintentionally.


Comment on Re: Tricks with DBI (esp. Connect)
Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://104986]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (17)
As of 2015-07-29 18:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (267 votes), past polls