Re: [Sqlrelay-discussion] SQLRelay and RaiseError problem

[David M. <dav...@fi...>]

SQL Relay catches DB unavailable errors internally and attempts to
re-login over and over until the DB comes back up and then it runs the
query then.  So it never returns that particular error.

However, it should raise an exception for other errors, does it do that?

David Muse
dav...@fi...

On Fri, 2006-04-28 at 13:17 +0200, Albert Vila wrote:
> Hello,
> 
> I'm testing the SQLRelay with the perl DBI module and I have a  
> problem. The connection looks like:
> 
>    if ($sqlrelay{$hostKey}) {
> 
>     # SQLRelay connections
>      $self->{CONNECTION} = DBI->connect("DBI:SQLRelay:host=$host;port= 
> $port;", "$usuariMysql", "$pwdMysql", { RaiseError => 1, PrintError  
> => 0});
>    } else {
> 
>      # Normal connections using the DBI module
>      $self->{CONNECTION} = DBI->connect("DBI:$sgMysql:$database;host= 
> $host", "$usuariMysql", "$pwdMysql", { RaiseError => 1, PrintError =>  
> 0)};
>    }
> 
> And the code to perform an action looks like:
> 
>    eval {
>      $result = $connection->selectall_arrayref($query);
>    };
> 
>    # Error control
>    if ($@) {
>      my $error = $@;
>      if ($error =~ m/MySQL server has gone away/ || $error =~ m/Lost  
> connection to MySQL server during query/) {
>        # Reconnection
>        $self->doConnection($self->{DATABASE}, $self->{HOSTKEY});
>        $result = $connection->selectall_arrayref($query);
>      }
>    }
>    return $result;
> 
> However, using the normal DBI connection, the RaiseError works and I  
> can catch the exception. Using the SQLRelay I can't catch the  
> Exception. Is there a way to catch this Exceptions?
> 
> 
> Thanks in advance.
> 
> Albert
> 
> 
> 
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>