Jsp and AS400

Discussion in 'Java' started by savita.raskar@gmail.com, Mar 17, 2007.

  1. Guest

    Hello All,

    I am fresher , working on jsp .I am getting the following
    error.I have searched on net, I have found the same problem posted but
    without solution.


    i have made a jsp page to access to as/400 db.
    ...but it don't work correctly.
    in the as/400 there is table f57202 under the library HTPL

    I have written down :
    connection =
    DriverManager.getConnection("jdbc:as400://","xxxx","xxx");


    PreparedStatement stat=conn.prepareStatement("select * from HTPL/
    f57202 where USERID=? and PASWRD=?");
    but i receive a error

    Errorjava.sql.SQLException: [SQL5016] Qualified object name F57202 not
    valid.

    when i change the code in:
    PreparedStatement stat=conn.prepareStatement("select * from
    HTPL.f57202 where USERID=? and PASWRD=?");

    i receive this error

    Descriptor index not valid.

    ... but when i make a query by the client as/400

    and wrote
    select * from htpl/f57202

    it work correctly


    i can't find the solution..

    Someone can me help?

    Thanks for your help
    Savita
     
    , Mar 17, 2007
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?RC5TYXJhdmFuYW4=?=

    DB_E_BADPROPERTYVALUE error when connecting to AS400 db2 udb

    =?Utf-8?B?RC5TYXJhdmFuYW4=?=, Jun 18, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    588
    =?Utf-8?B?RC5TYXJhdmFuYW4=?=
    Jun 18, 2004
  2. Manuel Arroba
    Replies:
    0
    Views:
    2,258
    Manuel Arroba
    Jun 28, 2004
  3. kh
    Replies:
    2
    Views:
    18,563
    bruce barker
    Nov 23, 2004
  4. Drew
    Replies:
    1
    Views:
    962
    Rhino
    Feb 17, 2005
  5. Tom Gugger
    Replies:
    0
    Views:
    473
    Tom Gugger
    May 28, 2005
  6. Replies:
    0
    Views:
    4,936
  7. Enrique

    python As400

    Enrique, Jan 20, 2004, in forum: Python
    Replies:
    2
    Views:
    850
    Jarek Zgoda
    Jan 20, 2004
  8. savita
    Replies:
    0
    Views:
    487
    savita
    Mar 24, 2007
Loading...