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

    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 Invalid argument: unknown column name upsert_ts ionTranslator.translate(SQLStateSQLExceptionTransl ceptionTranslator.translate(SQLErrorCodeSQLExcepti
    org.springframework.jdbc.core.JdbcTemplate.execute (
    org.springframework.jdbc.core.namedparam.NamedPara meterJdbcTemplate.query(NamedParameterJdbcTemplate .java:132) ade.getFormsForFullfillment(BasicPersistenceFacade .java:724) ntroller.retrieveFormsForFullfillment(FulfillmentL ntroller.handleRequestInternal(FulfillmentListCont
    org.springframework.web.servlet.mvc.AbstractContro ller.handleRequest(
    org.springframework.web.servlet.mvc.SimpleControll erHandlerAdapter.handle(SimpleControllerHandlerAda
    org.springframework.web.servlet.DispatcherServlet. doDispatch(
    org.springframework.web.servlet.DispatcherServlet. doService(
    org.springframework.web.servlet.FrameworkServlet.p rocessRequest(
    org.springframework.web.servlet.FrameworkServlet.d oGet(
    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
    Rep Power


    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, 06:58 PM
  2. executing the java file
    By TheBayWatchMan in forum New To Java
    Replies: 4
    Last Post: 01-12-2008, 10:31 AM
  3. queries regarding SWT
    By ravian in forum New To Java
    Replies: 0
    Last Post: 11-26-2007, 04:06 PM
  4. some queries
    By Feng in forum New To Java
    Replies: 7
    Last Post: 11-24-2007, 09: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