Kbase P126522: Receiving "[JDBC Progress Driver]:Syntax error (7587)" when running SQL statements in SQLExplorer to
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/23/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
SYMPTOM(s):
Receiving "[JDBC Progress Driver]:Syntax error (7587)" when running SQL statements in SQLExplorer tool.
=== SQL Exception 1 ===
SQLState=42000
ErrorCode=-20003
[JDBC Progress Driver]:Syntax error (7587)
GO statement is used to commit database changes.
No ending semi-colon for each SQL statement present.
CAUSE:
The SQL statements are not syntactically correct. Each SQL statement must end with a semi-colon in order to separate them. Also, the GO statement is not supported in Progress SQL-92 for committing a transaction after executing one or more SQL statements.
FIX:
In order to make the SQL statements syntactically correct perform the following:
1. End each SQL statement present with a semi-colon.
2. Remove the GO statement and replace it with a COMMIT statement.