dbTalk Databases Forums  

what's the config to have arith-overflows be 'fatal'?

comp.databases.sybase comp.databases.sybase


Discuss what's the config to have arith-overflows be 'fatal'? in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Joe Weinstein
 
Posts: n/a

Default what's the config to have arith-overflows be 'fatal'? - 11-14-2003 , 01:25 PM






Hi. What's the DBMS configuration variable that toggles whether
an arith-overflow is given a fatal or non-fatal level? I have a
jdbc app that does a query with an AVG function, which occasionally
suffers an arith overflow, but the client doesn't get a fatal
message, so the driver just complains that the SQL didn't produce
a result set. I'd rather the driver get the fatal-level message
so the client knows clearly that a DBMS failure was involved.
thanks
Joe Weinstein at BEA


Reply With Quote
  #2  
Old   
Joe Weinstein
 
Posts: n/a

Default Re: what's the config to have arith-overflows be 'fatal'? - 11-14-2003 , 02:23 PM







PS: I know I can send the SQL 'set arithabort arith_overflow on',
but what I want is either a way to make this the default behavior
for all connections, or a sybase jdbc driver property to make this
true for the connection.
thanks,
Joe Weinstein at BEA

Joe Weinstein wrote:

Quote:
Hi. What's the DBMS configuration variable that toggles whether
an arith-overflow is given a fatal or non-fatal level? I have a
jdbc app that does a query with an AVG function, which occasionally
suffers an arith overflow, but the client doesn't get a fatal
message, so the driver just complains that the SQL didn't produce
a result set. I'd rather the driver get the fatal-level message
so the client knows clearly that a DBMS failure was involved.
thanks
Joe Weinstein at BEA



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.