How to get ResultSet Message when no Exception is thrown

[RobbMN]

I'm using a product called Neon to invoke an app that returns an ODBC (JDBC) result set. It is capable of returning metadata, a message, and no rows. I'm able to get the SQLState and Message text when a SQLException occurs, but am unable to get the message text when a request for a ResultSet does not throw an exception.

Does anyone know how to get the text returned from "getMessage()" when an exception has not been thrown?

I tried SQLWarning, the object is null.
(I am able to get at the message text thru a Visual Basic app).

 

[stefanwagner]

Perhaps you don't get a message, because there is no message?
(Perhaps it is only generated from VB?)
Which message are you looking for?

 

[sedj]

Many of the JDBC API method calls are *vendor specific* - so if they want to return null, they can ... if you are getting no rows returned from the call, then perhaps there *are no rows returned* - ie SQL has been executed successfuly and then result is no rows ...

 

[RobbMN]

Problem Clarification:

The execution is returning a "success_with_info".

How do I get at the "info", as this type of return does not appear to cause and Exception or Warning.

 

[stefanwagner]

I didn't see any sql-statement before, which returned "success_with_info", beside oracles:
'SELECT "success_with_info" FROM dual';

Is this info important?
There is a rule 'no news are good news' - so if it's only a minor info ('executed in 0.213 sec.'): I would ignore it.

Can you tell more about the info, and the query?

But I think, it's a non-standard solution, and returning this info would break the interface. Perhaps the JDBC-driver - vendor has information on his site/ in his forum?