Skip to Content
avatar image
Former Member

update oracle database

Hi all,

I tried to search sample tutorial with oracle database, can any one share the link if you have got.

I am trying to build application with user input and storing in the oracle database.

thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 02, 2011 at 10:23 PM

    just some jdbc programming.

    what kind of code you want?

    you just get the value from the context, and use jdbc to persist the data, i don't see any difficulty there.

    Add comment
    10|10000 characters needed characters exceeded

    • you haven't done any jdbc code?

      ? means you can put the context value.

      please google some basic jdbc tutorial to help you understand the code

      try {
             con = ds.getConnection("webLogin", "webPassword");
             pstmt = con.prepareStatement("UPDATE COFFEES " +
               "SET TOTAL = TOTAL + ? WHERE COF_NAME = ?");
             pstmt.setInt(1, incr);
             pstmt.setString(2, cofName);
             pstmt.executeUpdate();
             stmt.close();
      
           } finally {
             if (con != null) con.close();
           }

  • Jan 03, 2011 at 04:03 AM

    Hi Kiran,

    Create EJB Module and use it as Model in your project. You need to have the drivers for oracle installed on your server and datasource created in J2EE engine.

    See the below link help you for this approach.

    [oracle-webdynpro-tables]

    Regards,

    Add comment
    10|10000 characters needed characters exceeded