Professional Web Applications Themes

Java stored procedure - IBM DB2

andylee <member30971dbforums.com> wrote in message news:<2983974.1055232065dbforums.com>... > I got the following error while running the java stored procedure after > upgrading to db2 V8.1, > > 2003-06-10 15:52:09.879 ERROR COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI > Driver] CLI0114E Datetime field overflow. SQLSTA > TE=22008 > at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLExceptio- > n(SQLExceptionGenerator.java(Compiled Code)) > at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLExceptio- > n(SQLExceptionGenerator.java(Inlined Compiled Cod > e)) > at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_r eturn_code- > (SQLExceptionGenerator.java(Compiled Code)) > at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2 (DB2Prepar- > edStatement.java(Compiled Code)) > at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeU pdate(DB2P- > reparedStatement.java:1731) > at support.be.eskb.SPTechDoent.insertTechDoc(SPTec hDoent- > .java:274) > at support.be.eskb.SPTechDoent.doInsert(SPTechDocu ment- > .java:124) > > The stored procedure worked fine in the previous db2 ...

  1. #1

    Default Re: Java stored procedure

    andylee <member30971dbforums.com> wrote in message news:<2983974.1055232065dbforums.com>...
    > I got the following error while running the java stored procedure after
    > upgrading to db2 V8.1,
    >
    > 2003-06-10 15:52:09.879 ERROR COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI
    > Driver] CLI0114E Datetime field overflow. SQLSTA
    > TE=22008
    > at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLExceptio-
    > n(SQLExceptionGenerator.java(Compiled Code))
    > at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLExceptio-
    > n(SQLExceptionGenerator.java(Inlined Compiled Cod
    > e))
    > at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_r eturn_code-
    > (SQLExceptionGenerator.java(Compiled Code))
    > at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2 (DB2Prepar-
    > edStatement.java(Compiled Code))
    > at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeU pdate(DB2P-
    > reparedStatement.java:1731)
    > at support.be.eskb.SPTechDoent.insertTechDoc(SPTec hDoent-
    > .java:274)
    > at support.be.eskb.SPTechDoent.doInsert(SPTechDocu ment-
    > .java:124)
    >
    > The stored procedure worked fine in the previous db2 7.2. Anyone
    > encounter the same problem as me did?? Can anyone give me a help?
    > Thanks alot.
    Hi,

    I'm having the same error when I upgraded to db2 8.1. I installed
    fixpaks 1 and 2 and this problem still exists. Did you ever find a
    solution?

    Thanks,

    Tim
    Tim Engler Guest

  2. #2

    Default Re: Java stored procedure


    For our case, it is cause by trying to put a timestamp value into the
    database's "date" field. I think this downcasting operation(timestamp
    -> date) is happened automatically in 7.2 but somehow they took out this
    function, which causes overflow for us when the code is trying to insert
    the timestamp.

    Hope this will help you. Good Luck! :)

    --
    Posted via [url]http://dbforums.com[/url]
    andylee Guest

  3. #3

    Default Re: Java stored procedure


    Hi,
    I also faced the same problem while upgrading from DB2 5.1 to 8.1. Is
    there any way to change some settings in the database to correct this
    error. Or should we have to tackle it in the Application only. Please
    let me know if you have any idea..
    Thanks a lot..

    Regards,
    Siva.
    Originally posted by andylee
    > For our case, it is cause by trying to put a timestamp value into the
    > database's "date" field. I think this downcasting operation(timestamp
    > -> date) is happened automatically in 7.2 but somehow they took out
    > this function, which causes overflow for us when the code is trying to
    > insert the timestamp.
    >
    Hope this will help you. Good Luck! :)

    --
    Posted via [url]http://dbforums.com[/url]
    Siva_nv1976 Guest

Similar Threads

  1. Empty java.library.path in linux stored procedure
    By Almund Sebi in forum IBM DB2
    Replies: 5
    Last Post: February 13th, 01:05 PM
  2. stored procedure help
    By Maria in forum Dreamweaver AppDev
    Replies: 3
    Last Post: April 20th, 06:55 PM
  3. stored procedure value
    By -D- in forum Dreamweaver AppDev
    Replies: 1
    Last Post: March 28th, 07:48 PM
  4. System.out.println from java stored procedure
    By efiryago@profitlogic.com in forum IBM DB2
    Replies: 0
    Last Post: August 5th, 06:56 PM
  5. Replies: 0
    Last Post: January 8th, 06:17 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139