Hi Dominic, for some unknown reason, the driver seems not to know that there is a column 'CENTER_GUID' in the result set.
If the select statement is > SELECT T_PATIENT.GUID FROM T_PATIENT WHERE > T_PATIENT.CENTER_GUID='Freiburg' AND > T_PATIENT.DATE_CREATED='2003-06-06' AND ... then it is of course not in the result, as you selected 'GUID'. Alexander Schr�der SAP DB > -----Original Message----- > From: Dominic Veit [mailto:[EMAIL PROTECTED] > Sent: Friday, June 06, 2003 10:42 AM > To: Schroeder, Alexander > Cc: [EMAIL PROTECTED] > Subject: RE: JDBC: Invalid Column - but column exists > > > Hi Alexander, > > the complete Exception is: > > 2003-06-06 08:51:11,154 ERROR [org.jboss.ejb.plugins.LogInterceptor] > EJBException: > javax.ejb.EJBException: DBMapping throws SQL-Exception in > ProcessSelectStatement:com.sap.dbtech.jdbc.exceptions.InvalidC > olumnException: SAP DBTech JDBC: Invalid column CENTER_GUID.; > Statement: SELECT T_PATIENT.GUID FROM T_PATIENT WHERE > T_PATIENT.CENTER_GUID='Freiburg' AND > T_PATIENT.DATE_CREATED='2003-06-06' AND > T_PATIENT.TIME_CREATED='10:40:12' > at > org.meddataonline.core.DB.DBMapping.ProcessSelectStatement(DBM > apping.java:643) > at > org.meddataonline.core.DB.DBMapping.ProcessUpdateInsertStateme > nt(DBMapping.java:661) > at org.meddataonline.core.DB.DBMapping.set(DBMapping.java:508) > at > org.meddataonline.core.DB.DBMapping.ProcessDBAction(DBMapping. > java:225) > at > org.meddataonline.core.DB.DBMapping.DBAction(DBMapping.java:155) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess > orImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth > odAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.in > voke(StatefulSessionContainer.java:878) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInter > ceptor.java:117) > at > org.jboss.resource.connectionmanager.CachedConnectionIntercept > or.invoke(CachedConnectionInterceptor.java:186) > at > org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invok > e(StatefulSessionInstanceInterceptor.java:271) > at > org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(Abstrac > tTxInterceptor.java:84) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxI > nterceptorCMT.java:243) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT > .java:104) > at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191) > at > org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(Pro > xyFactoryFinderInterceptor.java:122) > at > org.jboss.ejb.StatefulSessionContainer.internalInvoke(Stateful > SessionContainer.java:410) > at org.jboss.ejb.Container.invoke(Container.java:674) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess > orImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth > odAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(Reflec > tedMBeanDispatcher.java:284) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoke > r.java:359) > at sun.reflect.GeneratedMethodAccessor60.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth > odAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) > at sun.rmi.transport.Transport$1.run(Transport.java:148) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:144) > at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport > .java:460) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTr > ansport.java:701) > at java.lang.Thread.run(Thread.java:536) > > The JDBC trace is: > > DriverManager.getConnection("jdbc:sapdb://193.196.234.229/HIV_DATA") > trying > driver[className=org.hsqldb.jdbcDriver,[EMAIL PROTECTED] > trying > driver[className=org.hsqldb.jdbcDriver,[EMAIL PROTECTED] > trying > driver[className=com.sap.dbtech.jdbc.DriverSapDB,com.sap.dbtec > [EMAIL PROTECTED] > getConnection returning > driver[className=com.sap.dbtech.jdbc.DriverSapDB,com.sap.dbtec > [EMAIL PROTECTED] > creating statement > creating statement > creating statement > SQLException: SQLState() vendor code(-1) > com.sap.dbtech.jdbc.exceptions.InvalidColumnException: nullInvalid > column CENTER_GUID. > at > com.sap.dbtech.jdbc.ResultSetSapDB.findColumnInfo(ResultSetSap > DB.java:2751) > at > com.sap.dbtech.jdbc.ResultSetSapDB.getString(ResultSetSapDB.java:1243) > at > org.meddataonline.core.DB.DBMapping.ProcessSelectStatement(DBM > apping.java:620) > at > org.meddataonline.core.DB.DBMapping.ProcessUpdateInsertStateme > nt(DBMapping.java:661) > at org.meddataonline.core.DB.DBMapping.set(DBMapping.java:508) > at > org.meddataonline.core.DB.DBMapping.ProcessDBAction(DBMapping. > java:225) > at > org.meddataonline.core.DB.DBMapping.DBAction(DBMapping.java:155) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess > orImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth > odAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.in > voke(StatefulSessionContainer.java:878) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInter > ceptor.java:117) > at > org.jboss.resource.connectionmanager.CachedConnectionIntercept > or.invoke(CachedConnectionInterceptor.java:186) > at > org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invok > e(StatefulSessionInstanceInterceptor.java:271) > at > org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(Abstrac > tTxInterceptor.java:84) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxI > nterceptorCMT.java:243) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT > .java:104) > at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191) > at > org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(Pro > xyFactoryFinderInterceptor.java:122) > at > org.jboss.ejb.StatefulSessionContainer.internalInvoke(Stateful > SessionContainer.java:410) > at org.jboss.ejb.Container.invoke(Container.java:674) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess > orImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth > odAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(Reflec > tedMBeanDispatcher.java:284) > at > org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549) > at > org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoke > r.java:359) > at > sun.reflect.GeneratedMethodAccessor60.invoke(Unknown Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth > odAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) > at sun.rmi.transport.Transport$1.run(Transport.java:148) > at java.security.AccessController.doPrivileged(Native Method) > at sun.rmi.transport.Transport.serviceCall(Transport.java:144) > at > sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport > .java:460) > at > sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTr > ansport.java:701) > at java.lang.Thread.run(Thread.java:536) > closing connection > > I hope this helps. > > Regards, > > Dominic > > On Fri, 2003-06-06 at 09:31, Schroeder, Alexander wrote: > > 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 > -- > 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
