+ Reply to Thread
Results 1 to 3 of 3

DB2 Error - DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704,

  1. DB2 Error - DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704,

    Hi all

    My application J2EEruns in jboss. I have migrated my database from a windows machine to a Linux machine.

    Jboss is starting without any error
    The application runs fine when running with the database in the windows machine. But when i try to run it with the database in the Linux machine (which is migrated from windows). It shows the following in the log file,


    ERROR [http-0.0.0.0-8080-1] com.infosys.saas.ecomm.catalog.dao.CatalogmasterDAOImpl - Error at the time of executing the query = CatalogmasterSearchQuery.Message B2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: cataloguser.TCATALOG_MASTER
    com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: cataloguser.TCATALOG_MASTER

    Help neded to fix this.



    Thankx in advance,
    Gokul


  2. Re: DB2 Error - DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704,

    You can get the details for any error message from a DB2 command line by issuing:

    db2 ? sqlXXXX

    where XXXX is the message number, padded if necessary with 0 so it is 4 digits long. (Depending on your OS, you may have to put a \ or ^ in front of the ?.)

    In this case, you'll find that SQLCODE -204 is "object does not exist". DB2 is looking for the object "cataloguser.TCATALOG_MASTER"
    -----------------------------------
    Doug Doole
    DB2 Universal Database Development
    IBM Toronto Labs

  3. Re: DB2 Error - DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704,

    "DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC:"

    DRIVER = "com.ibm.db2.jcc.DB2Driver";
    URL = "jdbc:db2://localhost:50000/SPT";
    UID = "DB2ADMIN";
    PASSWORD = "******";


    caused by: table cannot be found by the login ID and password.



    solved this by adding Schema of that table within sql statement.

    before added, this bring error
    sql: "SELECT * FROM tmp"

    after added
    sql: "SELECT * FROM Schema.tmp"




    in my case from the picture i attached:
    sql: "SELECT * FROM COMPANY"

    after added
    sql: "SELECT * FROM billson.COMPANY"

    then Connection successful!
    nice day,
    billson.

+ Reply to Thread