search

yuva2achieve / solidbase

Automatically exported from code.google.com/p/solidbase
Apache License 2.0
0 stars 0 forks source link

Unclear error message for DUMP JSON #165

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
The following command (which is incorrect):

DUMP JSON FILE "JASPERSERVER/JIADHOCCHARTMEASURE.JSON.GZ" GZIP
BINARY FILE "JASPERSERVER/JIADHOCCHARTMEASURE.BIN.GZ" GZIP
DATE AS TIMESTAMP
SELECT * FROM JIADHOCCHARTMEASURE;

Gives the following error:

ERROR: 42000: ORA-00900: Ongeldige SQL-statement.

While executing line 4 of file 
C:/PROJECTS/EDSN/PERSONAL/CALL379253-Jasper/export/export-jasperserver.sql: 
DUMP JSON FILE "JASPERSERVER/JIADHOCCHARTMEASURE.JSON.GZ" GZIP
BINARY FILE "JASPERSERVER/JIADHOCCHARTMEASURE.BIN.GZ" GZIP
DATE AS TIMESTAMP
SELECT * FROM JIADHOCCHARTMEASURE

So, you can't see the statement that is actually sent to Oracle, which is this:

DATE AS TIMESTAMP
SELECT * FROM JIADHOCCHARTMEASURE

How should we solve this?
1. Introduce the 'QUERY' keyword;
2. Show the statement that is sent to Oracle.

Maybe option 1 is the better one. Gives more flexibility for the future.

Original issue reported on code.google.com by rene.de....@gmail.com on 27 Jun 2012 at 2:08