Hello
this is my log output:
------
DEBUG SimpleDataSource - Created connection 33534746.
DEBUG Connection - {conn-100000} Connection
DEBUG Connection - {conn-100000} Preparing Statement: SELECT WID FROM
WI.WITABLE
DEBUG PreparedStatement - {pstm-100001} Executing Statement: SELECT WID
FROM WI.WITABLE
DEBUG PreparedStatement - {pstm-100001} Parameters: []
DEBUG PreparedStatement - {pstm-100001} Types: []
DEBUG ResultSet - {rset-100002} ResultSet
DEBUG SimpleDataSource - Returned connection 33534746 to pool.
------------------------------------------------------------------------
[ERROR]BUILD ERROR
------------------------------------------------------------------------
null
Ungültiger Spaltenname
------------------------------------------------------------------------
"Ungültiger Spaltenname" means "Invalid column name".
I don't think that I have some type as the mapping files are generated by
Abator.
best wishes
Claus
> 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
> >
--
GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail
