Hello,

I am using Eclipse Oxygen to build and test my Java code that accesses a SQL Anywhere server (a High Availability group). When I have an exception related to server access I often see the following in the exception dump:

Examine the SQLWarnings chained to this exception for the reasons(s).

Documentation for the -z option when starting a server @ the documentation says "The information appears in the database server messages window." The Eclipse Show View menu item offers various "SQL related" views but none that I can find show any Warnings info. Would some one please tell me:

1) How can Eclipse be configured to display SQLWarnings. 2) If the -z option is to be used, how does this affect launching servers in an HA group?

Thank you.

asked 05 Feb '18, 13:47

AlK's gravatar image

AlK
735313554
accept rate: 37%

Hm, I do not fully understand your question:

In my very humble JDBC understanding, SQLWarnings should be available via the according JDBC methods like stmt.getWarnings(), and if you want to be informed about warnings (instead of errors, which will throw an exception), you would need to call thoses methods after an according database operation has been done.

So does your framework display no exceptions at all or no warnings?

(05 Feb '18, 15:03) Volker Barth
Replies hidden

Hi Volker,

The Eclipse IDE has a "Console" pane in which the Java App server shows its log messages as well as all of my log messages. Sometimes a Java Exception is thrown that is displayed in the Console and, as I described above, it tells me to look at SQL Warnings for details. No (SQL) Warnings are in the Console so I'm thinking/hoping there is another Eclipse pane that picks up and Warnings being spun out of SQL Anywhere. The Warnings would have to be getting picked up by the Java app server for them to have any chance of getting back to the Console but I have no visibility into that. I'm hoping somebody here uses Eclipse for their Java dev and knows about this.

Thanks.

(05 Feb '18, 18:54) AlK
1

I haven't found a way how to stream logs from dbsrv17 to Eclipse, but Internet said you can use ssh (or remote file access) to server's logs and a tail-like application that always displays the actual data.

(06 Feb '18, 08:34) Vlad
1

Can't tell on Eclipse, haven't used it lately. However, I guess the warnings displayed by dbrsvX -z relate to communication issues whereas a connection's warnings deal usually with positive SQLCODE messages, say 100 for "Row not found" and the like. I don't think the console log would contain those...

(06 Feb '18, 09:13) Volker Barth
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×6

question asked: 05 Feb '18, 13:47

question was seen: 1,040 times

last updated: 06 Feb '18, 09:13