I am attempting to setup the IBM DB2 sample database on a local web server. I have imported the code that IBM uses and changed the userid and password and owner as well as the dbname value to sample. I export the servlet to Webpshere and attempt to load the servlet. In the IBM code there is an if statement that states if there is not results then display on the page "NOBODY NAMED PARKER" the select statement: String query = "Select FirstNme " + "from " + owner + ".Employee " + "where LASTNAME = 'PARKER'"; should return a result because we have looked into the database and seen that there is someone by the lastname of 'Parker'. so we don't believe this is the problem. What we do believe is that there is no mention of the database server anywhere is the example code. There is a mention of a 'url' valiue, which is jdbc:db2:sample - is this complete?? Please can you help us with this problem because we know that it can be done. Thanks Chris Cheers, Chris Irvine - Associate Consultant Naratis, Melbourne Ph: +61 3 9820 1333 Fax: +61 3 9820 1888 Mob: 0401 672 062 Email: [EMAIL PROTECTED] ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
