SquirrelSQL is a great tool for working with databases. However, I had a bit of trouble running queries against DB2 databases. When a query had a syntax problem (or encountered any other error during execution), it would just show me the SQL Error Code, not the human-readable error string.
There's an easy way to fix that:
In the connection alias, add a property that says:
retrieveMessagesFromServerOnGetMessage=true
jdbc:db2://<server>:<port>/<db-name>:retrieveMessagesFromServerOnGetMessage=true;
Excerpt from the DB2 infocenter:
"During a connection to a data server, set the retrieveMessagesFromServerOnGetMessage property to true if you want full message text from an SQLException.getMessage call."
http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/index.jsp
No comments:
Post a Comment