How to resolve a Generic SQL exception - 10.x

How to resolve a Generic SQL exception - 10.x

Symptoms

You see an SQL Exception returned.

Cause

Unknown. 

Resolution

Consult your database documentation as SQL has some database specific differences. It is best to validate your SQL database outside of Confluence before putting it on a page.

Use database administration tools such as pgAdmin, some general SQL client, or, various Eclipse database plugins, to understand the differences between various databases.