I see. Sorry, my fault. Sorry to have spammed the mailinglist with this problem.
Regards, and thanks a lot, Dominic On Fri, 2003-06-06 at 10:32, Schroeder, Alexander wrote: > 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] > > -- 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
