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
