Jsp and AS400

  • Follow


Hello All,         I am fresher , working on jsp .I am getting the followingerror.I have searched on net, I have found the same problem posted butwithout 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  HTPLI 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 errorErrorjava.sql.SQLException: [SQL5016] Qualified object name F57202 notvalid.when i change the code in:PreparedStatement stat=conn.prepareStatement("select * fromHTPL.f57202 where USERID=? and PASWRD=?");i receive this errorDescriptor index not valid.... but when i make a query by the client as/400and wrote select * from htpl/f57202it work correctlyi can't find the solution..Someone can me help?Thanks for your helpSavita
0
Reply savita.raskar (11) 3/17/2007 1:43:45 PM


0 Replies
147 Views

(page loaded in 0.005 seconds)

Similiar Articles:












6/29/2012 7:08:21 AM


Reply: