Re: Error handling for auto-reconnect?

2006-01-26 Thread Steven Lembark
Is there any way to restart the failed transaction from within the HandleError sub? I cannot find anything in the DBI doc's that allows me to tell what the last op on the dbh was. thanx -- Steven Lembark [EMAIL PROTECTED] Systems Management Phone:

DBD::Oracle object version 1.15 does not match bootstrap parameter 1.06

2006-01-26 Thread Rusek Sebastian-ASR046
HI, I did according to the instruciton: http://www.esoftmatic.com/DBI/. But I found the problem as in title : install_driver(Oracle) failed: DBD::Oracle object version 1.15 does not match bootstrap parameter 1.06 at C:/Software/ActiveState/ActivePerl/586/lib/DynaLoader.pm line 253.

got problem with installing DBI

2006-01-26 Thread Nizar LAHYANI
Hello everybody i got concerns when installing DBI that is after making perl Makefile.pl there is noway to exécute make or nmake or dmake (command not found) after that can anyone give me a simple example whith connecting from Windows to an Oracle Databse that is on an AIX system ? Hope that you

RE: got problem with installing DBI

2006-01-26 Thread Reidy, Ron
The easiest way to install DBI/DBD::Oracle is directly from AS using ppm. As for connecting to the DB from Windows, after the install, type 'perldoc DBD::Oracle' and read this doc. -- Ron Reidy Lead DBA Array BioPharma, Inc -Original Message- From: Nizar LAHYANI [mailto:[EMAIL

Re: got problem with installing DBI

2006-01-26 Thread Alexander Foken
nmake is available for free from Microsoft, use Google for the URL. It is included in VC++, but not always installed properly. Search and run vcvars32.bat in the DOS window you run makefile.pl and nmake. Why don't you simply use ActivePerl and the packages found at ppm.activestate.com? (For

Re: DBD::Oracle object version 1.15 does not match bootstrap parameter 1.06

2006-01-26 Thread John Scoles
Rusek Sebastian-ASR046 [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] HI, I did according to the instruciton: http://www.esoftmatic.com/DBI/. But I found the problem as in title : install_driver(Oracle) failed: DBD::Oracle object version 1.15 does not match bootstrap parameter 1.06

have problems in intalling dbi module

2006-01-26 Thread Faten BEN JEMAA
hello evrybody, I have problems in installing DBI module, it require another library cl that i dont find please help me thinks cp Driver.xst blib\arch\auto\DBI\Driver.xst cp lib/DBI/ProxyServer.pm blib\lib\DBI\ProxyServer.pm cp dbipport.h blib\arch\auto\DBI\dbipport.h cp lib/DBD/NullP.pm

Re: have problems in intalling dbi module

2006-01-26 Thread Alexander Foken
You don't have VC++ installed properly. CL is the Linker from VC++. Maybe you just forgot to run vcvars32.bat in the dos window you started your makefile in. If you use ActivePerl, consider using ppm (see documentation in C:\perl\html\bin\ppm.html) instead of building modules yourself.

Re: Possible extension for DBI error handler (fwd)

2006-01-26 Thread Henri Asseily
Tim Bunce wrote: On Wed, Jan 25, 2006 at 02:51:14PM -0500, Steven Lembark wrote: -- Tim Bunce [EMAIL PROTECTED] $dbh-connect_cached( @{ $meta{ $dbh } } ); If the connection has failed then connect_cached() will return a new, different, $dbh which would be lost with the code

Re: Statement handle side effects of swap_inner_handle?

2006-01-26 Thread Henri Asseily
You may want to check the source of DBIx::HA. I did a lot of that type of work, see below for a sample. Be warned though that I think some of that code could be cleaned up now that we have $h-{ChildHandles}. It's a lifesaver. Also having the upgraded error handler will allow for cleaner code as

Re: have problems in intalling dbi module

2006-01-26 Thread John Scoles
have a look at this file http://svn.perl.org/modules/dbd-oracle/trunk/README.win32.txt it has very detailed instructions on how to install DBD:Oracle on windows. Though not for DBI the steps 5 through 11 will show you hao to configure your C++ enviroment

Re: Error handling for auto-reconnect?

2006-01-26 Thread Henri Asseily
Are you talking about $dbh-{Statement} ? If you want full transactional integrity and you've been sending multiple statements within the transaction, you could overload execute() and track every time there's an open tran or commit in the statement. Anything in between, you store in an array of

Re: Statement handle side effects of swap_inner_handle?

2006-01-26 Thread Tim Bunce
On Thu, Jan 26, 2006 at 02:04:28AM -0500, Steven Lembark wrote: The inner handle carries all the DBI info, including CachedKids. So swap_inner_handle is a simple and total brain transplant. Q: Any chance of getting $sth-clone? Doubtful. Patches always welcome of course. You've got

Re: DBD::Oracle object version 1.15 does not match bootstrap parameter 1.06

2006-01-26 Thread Tim Bunce
On Thu, Jan 26, 2006 at 07:58:51AM -0500, John Scoles wrote: That being said I did have some luck once by doing this I changed the line $DBD::Oracle::VERSION = '1.16'; in Oracle.pm to $DBD::Oracle::VERSION = '1.06'; but this is very risky and may not work. Or worse, may appear to work

Re: Error handling for auto-reconnect?

2006-01-26 Thread Steven Lembark
-- Henri Asseily [EMAIL PROTECTED] Are you talking about $dbh-{Statement} ? If you want full transactional integrity and you've been sending multiple statements within the transaction, you could overload execute() and track every time there's an open tran or commit in the statement.

Re: Statement handle side effects of swap_inner_handle?

2006-01-26 Thread Steven Lembark
Q: If the cached kids are stored in $new_dbh, wouldn't I overwrite the statement handles when I performed the $old_dbh-swap_inner_handle( $new_dbh )? True. If you swap_inner_handle for all ChildHandles then you'll automatically deal with CachedKids as well. Simple. Some good news on

Re: Statement handle side effects of swap_inner_handle?

2006-01-26 Thread Tim Bunce
On Thu, Jan 26, 2006 at 02:33:21PM -0500, Steven Lembark wrote: The only thing this doesn't pull across that I can think of is the current row state of each handle You could use $sth-rows and fetch to the same row count (but there's no guarantee you'll be getting the same values).