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.InvalidColumnException: 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(DBMapping.java:643)
at
org.meddataonline.core.DB.DBMapping.ProcessUpdateInsertStatement(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(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.invoke(StatefulSessionContainer.java:878)
at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:117)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
at
org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invoke(StatefulSessionInstanceInterceptor.java:271)
at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.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(ProxyFactoryFinderInterceptor.java:122)
at
org.jboss.ejb.StatefulSessionContainer.internalInvoke(StatefulSessionContainer.java:410)
at org.jboss.ejb.Container.invoke(Container.java:674)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
at
org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:359)
at sun.reflect.GeneratedMethodAccessor60.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.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(TCPTransport.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,[EMAIL PROTECTED]
getConnection returning
driver[className=com.sap.dbtech.jdbc.DriverSapDB,[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(ResultSetSapDB.java:2751)
at
com.sap.dbtech.jdbc.ResultSetSapDB.getString(ResultSetSapDB.java:1243)
at
org.meddataonline.core.DB.DBMapping.ProcessSelectStatement(DBMapping.java:620)
at
org.meddataonline.core.DB.DBMapping.ProcessUpdateInsertStatement(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(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.invoke(StatefulSessionContainer.java:878)
at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:117)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
at
org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invoke(StatefulSessionInstanceInterceptor.java:271)
at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.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(ProxyFactoryFinderInterceptor.java:122)
at
org.jboss.ejb.StatefulSessionContainer.internalInvoke(StatefulSessionContainer.java:410)
at org.jboss.ejb.Container.invoke(Container.java:674)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
at
org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:359)
at sun.reflect.GeneratedMethodAccessor60.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.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(TCPTransport.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
