NonStop JMS User's Manual (H06.03+, J06.03+, NonStop JMS 3.0+)

Error Reporting and Messages
NonStop Server for Java Message Service User’s Manual—522356-006
A-2
SQL/MX Messages
The SQLCODE field returns a value that describes error information after running an
embedded SQL statement:
The SQLSTATE field returns a five-character variable string that has two parts. The first
part is a two-character class code, and the second part is a three-character subclass
code. An SQLSTATE value of 00000 indicates completion. For a listing of the class and
subclass values, see the SQL/MX Programming Manual for C and COBOL .
The CONDITION_NUMBER field returns the number of an exception condition.
The MESSAGE_TEXT field returns the SQL message number and the message text.
For example, this error message might be displayed if an exception occurs while
preparing an embedded SQL statement:
For information about SQL messages, see the SQL/MX Messages Manual.
Value Description
< 0 An error occurred.
> 0 (<> 100) A warning occurred.
100 No data was found.
0 The statement completed successfully.
javax.jms.JMSException: SQL error -4081 reading messages: java.sql.SQLException:
SQLCODE: -4081
SQLSTATE: 42000
condition number: 1
message text: *** ERROR[4081] SQL/MP error:
*** ERROR from SQL [-4004]: Object \KONA.$DATA30.NSJMS.MESSAGE is not an SQL table
or view.
SQLCODE: -4082
SQLSTATE: 42000
condition number: 2
message text: *** ERROR[4082] Table \KONA.$DATA30.NSJMS.MESSAGE does not exist or
is inaccessible.
SQLCODE: -8822
SQLSTATE: X0X08
condition number: 3
message text: *** ERROR[8822] Unable to prepare the statement.
at com.tandem.nsjms.client.JmsMessageConsumer.receiveNoWaitIntJNI(JmsMessage
Consumer.java, Compiled Code)
at com.tandem.nsjms.client.JmsMessageConsumer.receive(JmsMessageConsumer.java,
Compiled Code)
at com.tandem.nsjms.examples.SimpleReceiver.main(SimpleReceiver.java, Compiled
Code)