Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008
    Posts
    1
    Rep Power
    0

    Unhappy Porblem Executing Queries in Java

    I have a web application which i have deployed using a xml file in the conf/catalina/localhost directory on a windows machine in tomcat 5.5.My docbase is on the same machine but at a diffferent location.

    I am using jdbc to connect to the database and execute queries ( i have a class for my queries),however whenever i change my queries it still excutes the old one and throws an error.I am doing a re-build using ant and re-start tomcat everytime but it does not help.

    The error that i get is ,although there is no column which is called upsert_ts it still throws me the error

    org.springframework.jdbc.UncategorizedSQLException : PreparedStatementCallback; uncategorized SQLException for SQL [SELECT * FROM ( SELECT ROWNUMBER() OVER(ORDER BY ea.account_number_c) row_number_i, a.form_id_i, ea.account_number_c, ffs.last_modified_ts, 0 hold_count_i FROM ( SELECT fa.form_id_i FROM tbl_esc_form_assignment fa INNER JOIN tbl_esc_fullfill_set ffs ON ffs.form_id_c=fa.form_id_i ) a INNER JOIN tbl_esc_fullfill_set ffs ON ffs.form_id_c= a.form_id_i INNER JOIN tbl_esc_form ef ON ef.form_id_i = ffs.form_id_c INNER JOIN tbl_esc_account ea ON ea.account_id_i = ef.account_id_i ) b WHERE b.row_number_i BETWEEN ? AND ? ]; SQL state [null]; error code [-99999]; Invalid argument: unknown column name upsert_ts; nested exception is com.ibm.db2.jcc.b.SqlException: Invalid argument: unknown column name upsert_ts
    org.springframework.jdbc.support.SQLStateSQLExcept ionTranslator.translate(SQLStateSQLExceptionTransl ator.java:120)
    org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.translate(SQLErrorCodeSQLExcepti onTranslator.java:276)
    org.springframework.jdbc.core.JdbcTemplate.execute (JdbcTemplate.java:554)
    org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java:588)
    org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java:613)
    org.springframework.jdbc.core.JdbcTemplate.query(J dbcTemplate.java:645)
    org.springframework.jdbc.core.namedparam.NamedPara meterJdbcTemplate.query(NamedParameterJdbcTemplate .java:132)
    com.gs.tefra.model.persistence.BasicPersistenceFac ade.getFormsForFullfillment(BasicPersistenceFacade .java:724)
    com.gs.tefra.console.web.control.FulfillmentListCo ntroller.retrieveFormsForFullfillment(FulfillmentL istController.java:80)
    com.gs.tefra.console.web.control.FulfillmentListCo ntroller.handleRequestInternal(FulfillmentListCont roller.java:40)
    org.springframework.web.servlet.mvc.AbstractContro ller.handleRequest(AbstractController.java:153)
    org.springframework.web.servlet.mvc.SimpleControll erHandlerAdapter.handle(SimpleControllerHandlerAda pter.java:48)
    org.springframework.web.servlet.DispatcherServlet. doDispatch(DispatcherServlet.java:858)
    org.springframework.web.servlet.DispatcherServlet. doService(DispatcherServlet.java:792)
    org.springframework.web.servlet.FrameworkServlet.p rocessRequest(FrameworkServlet.java:476)
    org.springframework.web.servlet.FrameworkServlet.d oGet(FrameworkServlet.java:431)
    javax.servlet.http.HttpServlet.service(HttpServlet .java:690)
    javax.servlet.http.HttpServlet.service(HttpServlet .java:803)

    Any pointers to this ?

  2. #2
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    9

    Default

    Ask on an sql forum. But you are referencing a column that, seemingly, doesn't exist in the referenced table(s).

Similar Threads

  1. [SOLVED] executing java over network
    By jmHoekst in forum New To Java
    Replies: 6
    Last Post: 06-30-2008, 05:58 PM
  2. executing the java file
    By TheBayWatchMan in forum New To Java
    Replies: 4
    Last Post: 01-12-2008, 09:31 AM
  3. queries regarding SWT
    By ravian in forum New To Java
    Replies: 0
    Last Post: 11-26-2007, 03:06 PM
  4. some queries
    By Feng in forum New To Java
    Replies: 7
    Last Post: 11-24-2007, 08:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •