Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

PowerBuilder -> ASA8---> java in database ---Exceptions

2 posts in General Discussion Last posting was on 2003-02-18 18:58:38.0Z
Renato Gonzalez Posted on 2003-02-14 18:04:49.0Z
From: "Renato Gonzalez" <rengon@hotmail.com>
Subject: PowerBuilder -> ASA8---> java in database ---Exceptions
Date: Fri, 14 Feb 2003 12:04:49 -0600
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <CJemGZF1CHA.198@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 168.234.143.59
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:130
Article PK: 1951

We are developing a client/server application using:

PowerBuilder 8.03 (GUI)
ASA8 (Database)
ASA8 Java (Bussines Rules)

But when a java exception ocurrs (for example: SQLException: column xxxxx
does not allow nulls ), in powerbuilder clients a window prompt with the
following message: " Unhandled java exception SQLException " instead of
"column xxxx does not allow nulls).
The client application does not recieve the original message. What can I
do?
The same application running on Oracle works fine (PowerBuilder8, Oracle 8i
& Oracle8 java)


Nick Elson Posted on 2003-02-18 18:58:38.0Z
From: "Nick Elson" <nick.elson@sybase.com>
References: <CJemGZF1CHA.198@forums.sybase.com>
Subject: Re: PowerBuilder -> ASA8---> java in database ---Exceptions
Date: Tue, 18 Feb 2003 13:58:38 -0500
Lines: 40
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <q3$X8J41CHA.142@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.141.181
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:302
Article PK: 2121

The Oracle behaviour suggests that they have a non-standard
exception class or have a family of (say) SqlException classes
that map back to SQL errors when the classes themselves
to catch and handle them.

That would make a nice future enhancement suggestion but
in the meantime, you might have better success 'catch'ing
those and raising your own errors.

The actual SQL used could possibly be embellished to handle this,
but Java exception handling may still be required in some cases.

Not a complete answer but utilizing the errormsg( ) SQL function
should prove helpful.

just my CDN$.02

"Renato Gonzalez" <rengon@hotmail.com> wrote in message
news:CJemGZF1CHA.198@forums.sybase.com...
> We are developing a client/server application using:
>
> PowerBuilder 8.03 (GUI)
> ASA8 (Database)
> ASA8 Java (Bussines Rules)
>
> But when a java exception ocurrs (for example: SQLException: column xxxxx
> does not allow nulls ), in powerbuilder clients a window prompt with the
> following message: " Unhandled java exception SQLException " instead of
> "column xxxx does not allow nulls).
> The client application does not recieve the original message. What can
I
> do?
> The same application running on Oracle works fine (PowerBuilder8, Oracle
8i
> & Oracle8 java)
>
>
>