tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jabali Acuatico <jabaliacuat...@yahoo.com.ar>
Subject DB2 problem: AM_BASE_TASKS ¿is a ghost table?
Date Tue, 25 Nov 2008 04:32:03 GMT
I know this is not a DB2 list, but certainly the problem is between Tomcat and DB2, because
everything doing manually, with DB2 terminal, using a console, is working properly.  

I am using a  java connection class and a JDBC driver : "db2jcc.jar" for developing a webapp
in Tomcat 6.0.18 on Ubuntu 7.10. 



I am connecting, querying and updating without problems using the same
user, the same driver and even the same jsp pages to connect many DB2
databases. All of them are running locally, with the exactly same
conditions and owner, in my laptop, and they are working properly. But
there is a single one, called "cafe". I put some OUT.PRINTLN for
debugging and know what was going on.



The problem is when I tried to retrieve the tables from the schema, and
then selecting all of each table. I also print its names, as I do with
the rest of dbs, an exception happens, and the output of Tomcat showing
me a "table" that is not existing in the "reality" of the schema. I am
really surprised of this, as a newbie of DB2... Although, in the db2
console, everything seems to be normal, showing me the 8 tables there
are in fact exists. ¿Why Tomcat throws me an exception and shows me
this ghost table called AM_BASE_TASKS.



This is part of the output of my connection class (the last part):



...
Consulta : select * from PRICES
SETRESPUESTA:          ENTRO
SETRESPUESTA:  CONSULTA VALE : select * from PRICES
SETRESPUESTA:  Sentencia vale : [com.ibm.db2.jcc.b.zc@13ec2dd]
SETRESPUESTA:   dentro del IF
SETRESPUESTA:   dentro del TRY
SETRESPUESTA: EL RESULTADO NO ES NULO!
SETRESPUESTA:     ....Datos : com.ibm.db2.jcc.b.m@1e4eb5b
SETRESPUESTA:  ....Columnas : 3
SETFILAS:  ... Entro
SETFILAS:  ... Filas inicial : 5
SETFILAS:  ... Filas final : 5
SETRESPUESTA:     ....Filas : 5
SALIO DE SETRESPUESTA
SETFILAS:  ... Entro
SETFILAS:  ... Filas inicial : 5
SETFILAS:  ... Filas final : 5
Consulta : select * from AM_BASE_TASKS
SETRESPUESTA:          ENTRO
SETRESPUESTA:  CONSULTA VALE : select * from AM_BASE_TASKS
SETRESPUESTA:  Sentencia vale : [com.ibm.db2.jcc.b.zc@13ec2dd]
SETRESPUESTA:   dentro del IF
SETRESPUESTA:   dentro del TRY
com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: DB2INST1.AM_BASE_TASKS
        at com.ibm.db2.jcc.b.zc.e(zc.java:1606)
        at com.ibm.db2.jcc.b.zc.a(zc.java:1206)
        at com.ibm.db2.jcc.a.db.h(db.java:149)
        at com.ibm.db2.jcc.a.db.a(db.java:43)
        at com.ibm.db2.jcc.a.r.a(r.java:30)
        at com.ibm.db2.jcc.a.sb.g(sb.java:152)
        at com.ibm.db2.jcc.b.zc.n(zc.java:1186)
        at com.ibm.db2.jcc.b.zc.a(zc.java:1857)
        at com.ibm.db2.jcc.b.zc.e(zc.java:775)
        at com.ibm.db2.jcc.b.zc.execute(zc.java:759)
        at peerca.Conexion.setResultado(Conexion.java:354)
        at peerca.Conexion.getTablas(Conexion.java:802)
        at org.apache.jsp.peericadd_jsp._jspService(peericadd_jsp.java:160)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
       
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:619)




The output for the normal situation is here:

~$ db2 connect to cafe
 
   Database Connection Information
 
 Database server        = DB2/LINUX 9.5.0
 SQL authorization ID   = DB2INST1
 Local database alias   = CAFE




There are no problems to connect this database. And even if I list its tables, there are no
problems...

$ db2 list tables
 
Table/View                      Schema          Type  Creation time             
------------------------------- --------------- ----- --------------------------
CAMPUS                          DB2INST1        T     2008-09-02-17.50.52.121176
FACULTY                         DB2INST1        T     2008-09-02-17.50.53.654183
FOODITEMS                       DB2INST1        T     2008-09-02-17.50.53.004854
MEMBERS                         DB2INST1        T     2008-09-02-17.50.52.762783
ORDERLINE                       DB2INST1        T     2008-09-02-17.50.53.384942
ORDERS                          DB2INST1        T     2008-09-02-17.50.53.153659
POSITION                        DB2INST1        T     2008-09-02-17.50.52.645900
PRICES                          DB2INST1        T     2008-09-02-17.50.52.951344
 
  8 record(s) selected.




As we can see, there is no table number 9! I repeat: this only happens
with this database and the other ones are working properly. I tried to
do:



$db2 activate db cafe
 and did the same with the other dbs, but Tomcat is still throwing the exception. ¿Any comments?

I don't know what is the error.



Hoping you could helped me, best regards.

*~ Ariela ~*


      ¡Todo sobre Amor y Sexo!
La guía completa para tu vida en Mujer de Hoy.                       
http://mx.mujer.yahoo.com/
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message