retrieveMessageText=false attribute

The retrieveMessageText=false attribute, if set to true (the default), retrieves the message text for each SQLException from the server.

A stored procedure call retrieves the message text and may start a new unit of work.

Set this property to false if you do not want the performance impact of the procedure call or do not want to start a new unit of work.

This attribute is meaningful only if used with the network driver.

Combining with other attributes

You can combine this attribute with other attributes.

Example

-- do not retrieve message text for SQLExceptions
jdbc:derby://localhost:1527/salesDB;retrieveMessageText=false