If you're asking the db server to create a prepared statement or stored procedure with column names or table names as params, then it may not work (definitely not in the case of table names). I tried that with oracle once to no avail.
-----Original Message----- From: Henry Lu [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 11, 2006 11:15 AM To: user-java@ibatis.apache.org Subject: dynamic sql map 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 >> >> >> > > > >
