Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by JMEHTA

  1. JMEHTA

    HP UNX Upgrad

    Hi, We recently upgraded our HP Unix box to 11i. The whole package contained the jdk version 1.4.2_04. I created the war file for our application using this version of jdk and ftp'ied it to the UNIX box and started the OC4J server. When i tried to access the application it gave me a...
  2. JMEHTA

    preparedstatement.executeupdate

    I am checking the runtime values...
  3. JMEHTA

    preparedstatement.executeupdate

    I checked my code and the RmsStockCountStatusConverter.convert(stockCount.getStatus())' does returns 'CT' in uppercase. As far as my date and time settings are concerned i checked the date setting on unix and it was EDT and my local machine too has EDT.
  4. JMEHTA

    preparedstatement.executeupdate

    Heres my code: private void updateHeader() throws RswException, SQLException { PreparedStatement preparedstatement = getPreparedStatement("UPDATE rms.stake_location SET status = ?, stocktake_end_datetime = ? WHERE cycle_count = ? AND location = ? ")...
  5. JMEHTA

    preparedstatement.executeupdate

    Hey guys whats the solution? I tried creating a dummy table and doing an insert and it works but if i do an update on that table, it fails. This is really getting frustrating. Any help will be appreciated.
  6. JMEHTA

    preparedstatement.executeupdate

    My statement is UPDATE stake_location SET status = ?, stocktake_end_datetime = ? WHERE cycle_count = ? AND location = ? and the check constraint is CONSTRAINT CHK_STAKE_LOCATION_STATUS CHECK (status in ('WS','CT','CD', 'AV', 'VP', 'AA', 'CO', 'CA', 'DE')) The...
  7. JMEHTA

    preparedstatement.executeupdate

    Hi, I have configured my application to run locally. I am getting the following error message when i try to update one of the table through the application: java.sql.SQLException: ORA-02290: check constraint (RMS.CHK_STAKE_LOCATION_STATUS) violated...

Part and Inventory Search

Back
Top