Hi Dominic, can you please provide the complete exception (and if possible, a JDBC trace would be handy).
Thanks Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: Dominic Veit [mailto:[EMAIL PROTECTED] > Sent: Friday, June 06, 2003 10:22 AM > To: [EMAIL PROTECTED] > Subject: JDBC: Invalid Column - but column exists > > > Hi all, > > I try to execute a SELECT statement from within JBOSS (Linux). The > statement is totally simple: > > SELECT SOMECOLUMN FROM TABLENAME WHERE COLUMN_1='Value1' AND > COLUMN_2='Value2' AND COLUMN_3='Value3' > > Value 1 is VARCHAR, 2 is DATE and 3 is TIME . > > If I execute it from DBVisualizer, it is no problem. If I execute it > just by handing it over to executeQuery, the above exception is being > thrown. > > Has anybody a clue what's happening there? Even if DBVisualizer works > with prepared statements, I cannot figure out what's > happening there and > why it does not work with executeQuery. > > Regards, > > Dominic > > -- > Dominic Veit (Software Developer) > Medical Center, University of Freiburg > Dept. of Rheumatology and Clin. Immunology > Hugstetterstr. 55 > 79106 Freiburg (Germany) > Tel.: 0761 270 37 84 > Pager: 0168 73 22 60 0 > E-mail: [EMAIL PROTECTED] > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
