Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2008
    Posts
    1

    Unanswered: not able to read from a file n dump into db using java stored proc

    hi ,

    I need to read a file and dump the data into the database.I am using java stored proc .The stored proc runs successfully, but the values are not populated in database.

    here are my doubts,

    Is it not possible to use FileStream in the java stored procs?

    I am not able to pass as arguments also , as the number of parameters exceeeds 90.

    If i pass the values as object, will it work in java stored proc?


    Please suggest a solution for this...

    I am in real trouble.

    Thanks.

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    A Java stored procedure is basically like any other Java program that connects to DB2. The scenario you describe should be working quite fine. However, we can't say anything without seeing the code.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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