Official Guide to Tourism Establishments

S'ha produït un error


Error: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [ SELECT * FROM ( SELECT a.*, ROWNUM rnum FROM ( SELECT ID, ID_REGISTRAL, TIPUS, RETOL, EMAIL, WEB, MARCA, TELEFON, FAX, ADR_VIA, ADR_NOM, ADR_NUM, ADR_PIS, ADR_BLOC, ADR_PORTA, ADR_CODI_POSTAL, INFRAMUNICIPI_DES, MUNICIPI_ID, MUNICIPI_DES, COMARCA_ID, COMARCA_DES, PROVINCIA_ID, PROVINCIA_DES, MARCATUR_ID, MARCATUR_DES, TRAMIT_OBERT, FORA_CATALUNYA, CERTJA, CERTQT, CERTQA, CERTSC, CERTI1, CERTECL FROM CERCADOR_AGENCIES WHERE 1=1 ORDER BY MARCATUR_DES, MUNICIPI_DES, RETOL, ID_REGISTRAL, ID) a WHERE ROWNUM<=5) WHERE rnum>0]; nested exception is java.sql.SQLException: Invalid column name

Descripció: StatementCallback; bad SQL grammar [ SELECT * FROM ( SELECT a.*, ROWNUM rnum FROM ( SELECT ID, ID_REGISTRAL, TIPUS, RETOL, EMAIL, WEB, MARCA, TELEFON, FAX, ADR_VIA, ADR_NOM, ADR_NUM, ADR_PIS, ADR_BLOC, ADR_PORTA, ADR_CODI_POSTAL, INFRAMUNICIPI_DES, MUNICIPI_ID, MUNICIPI_DES, COMARCA_ID, COMARCA_DES, PROVINCIA_ID, PROVINCIA_DES, MARCATUR_ID, MARCATUR_DES, TRAMIT_OBERT, FORA_CATALUNYA, CERTJA, CERTQT, CERTQA, CERTSC, CERTI1, CERTECL FROM CERCADOR_AGENCIES WHERE 1=1 ORDER BY MARCATUR_DES, MUNICIPI_DES, RETOL, ID_REGISTRAL, ID) a WHERE ROWNUM<=5) WHERE rnum>0]; nested exception is java.sql.SQLException: Invalid column name


http://establimentsturistics.gencat.cat:80/rtcwebguies