Can you provide the log? Maybe error is raised not at the query execution but while mapping resultset to java object, i.e. you have typo in columnname in resultMap
On 10/5/07, Claus Hausberger <[EMAIL PROTECTED]> wrote: > > Jeff, thanks. but that didn't help. > > I made a mistake describing my problem. the Oracle error message was > in German and I didn't translate it correctly. > > it does not say "Unknown" column name, but "Invalid" column name. > > maybe this is something different. sorry for the error. > > Claus > > > > It sounds like you should set remapResults="true" in the <select> > element. > > > > Jeff Butler > > > > > > > > On 10/4/07, Claus Hausberger <[EMAIL PROTECTED]> wrote: > > > > > > Hello > > > > > > I am using IBatis 2.3 with Spring and a Oracle 10g database.When I use > a > > > select query where I specify the columns > > > I always get an "Unknown column name" error. But the database does not > > > say which column. I switched one debugging output > > > with a log4j.xml to get the SQL IBatis uses for the query. When I copy > > > the query of the log output into an Oracle client > > > and execute the SQL, it works fine. > > > > > > any idea what I might be doing wrong here ? > > > > > > best wishes > > > > > > Claus > > > -- > > > Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten > > > Browser-Versionen downloaden: http://www.gmx.net/de/go/browser > > > > > -- > Psssst! Schon vom neuen GMX MultiMessenger gehört? > Der kanns mit allen: http://www.gmx.net/de/go/multimessenger >
