I always try to simplify first, then add stuff until it breaks.
For example, try this:
<statement id="select_list" resultClass="domain.NameValue">
select
STATE_ABBRV as m_name,
STATE as m_value
FROM USSTATE_DESC
</statement>
Does that work?
You may also want to enable logging, and/or try something like p6spy
to see the SQL. This is a SQL error, based on the message, not
something in Spring or iBATIS.
Larry
PS: Please, please, please do not hijack other threads (like you did
this one) with new questions. Send them to user-java@ibatis.apache.org
directly.
On 1/11/06, Henry Lu <[EMAIL PROTECTED]> wrote:
> I got errors:
>
> org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in
> task 'SqlMapClient operation'; nested exception is
> com.ibatis.common.jdbc.exception.NestedSQLException: --- The error
> occurred in edu/umich/med/umms/coreyp/dao/ibatis_map/misc.xml. --- The
> error occurred while applying a parameter map. --- Check the
> select_list-InlineParameterMap. --- Check the statement (query failed).
> --- Cause: java.sql.SQLException: ORA-00942: table or view does not exist
> org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator
>
> with the sql:
>
> <statement id="select_list"
> resultClass="domain.NameValue">
> select $col_code$ as m_name,
> $col_descr$ as m_value
> FROM $my_table_name$
> </statement>
>
> and java code:
>
> Map map = new HashMap(4);
> map.put("col_code", "STATE_ABBRV");
> map.put("col_descr", "STATE");
> map.put("my_table_name", "USSTATE_DESC");
> map.put("where_order_str",
> "ORDER BY STATE");
>
> return getSqlMapClientTemplate().queryForList(
> "select_list", map);
>
> Is there anyone can help me out this?
>
> -Henry
>
>
>
>
> Larry Meadors wrote:
>
> >Vector myVector = new Vector(theList);
> >
> >Larry
> >
> >On 1/11/06, Ashish Kulkarni <[EMAIL PROTECTED]> wrote:
> >
> >
> >>Hi
> >>I have defined a query as
> >><select id="selectLinesFromView"
> >>resultClass="java.lang.String">
> >>SELECT L083LINE FROM PL1083 WHERE L083CODE = #value#
> >>ORDER BY L083SQNO
> >></select>
> >>
> >>and in my java code i do
> >>List list = client.queryForList("selectLinesFromView",
> >>"ABC");
> >>
> >>Suppose if i want a Vector as output, i just cannot
> >>parse it as it gives me classcastexception,
> >>so what is a best way of getting Vector as output, or
> >>do i have to iterate through list and uild my own
> >>vector
> >>
> >>
> >>Ashish
> >>
> >>
> >>
> >>A$HI$H
> >>
> >>__________________________________________________
> >>Do You Yahoo!?
> >>Tired of spam? Yahoo! Mail has the best spam protection around
> >>http://mail.yahoo.com
> >>
> >>
> >>
> >
> >
> >
> >
>
