query to send
==========
SELECT DISTINCT column_name
FROM dba_tab_columns
WHERE owner = 'WEBUSER'
AND table_name = 'users'
reference.xml
==========
<select id="runSql" parameterClass="java.lang.String"
resultClass="java.lang.Object">
<![CDATA[$sentenciaSql$]]>
</select>
this works in other places I use, for example with this query
SELECT DISTINCT table_name FROM dba_tables WHERE owner = 'WEBUSER'
and the error trace
=============
[STDERR] com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in
py/com/sif/dna/sgc/persistence/sqlmap/sql/referencia.xml.
--- The error occurred while applying a result map.
--- Check the Ref.runSql-AutoResultMap.
--- Check the result mapping for the 'TABLE_NAME' property.
--- Cause: java.sql.SQLException: Nombre de columna no válido
ERROR [STDERR] at
com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)
what could be the problem ?
--
Betto McRose Gamarra
IcarusDB
"Soluciones Informáticas"
Cel.: +595 992 686947
