Have you tried doing a System.out.println of your query and then running
that against your database using some sort of SQL client tool?
Your code example doesn't show how you load the driver or get the
database connection. Are you sure you are doing this exactly the same
in your servlet as your application? Could you be connecting to a
different database and not realizing it?
Keith Ball wrote:
>
> I have decided that problem must be that of a SERVER problem and my code is
> fine. I am running Apache 1.3.9 with Jserver 1.0. Using a JDBC driver
> given like this in the code....
>
> url = "jdbc:interbase://myipaddress/d:/ballie/versions.gdb";
>
> I am on a NT Box. If you have set-up a database tell me do I have to
> implement policy files ? Or do I have to mess around with the securtiy
> files of the server. As my code returns no error's anywhere. The Log's dont
> show any problems. My code works as a application. So I dont understand ?
>
> Thnx for anyhelp given, I really am bewildered.
>
> Keith
>
> ---------------------------------------------------------------------------
> Keith Ball - Praktikant
> AF12 Operationelle Analysen Luftwaffe
> IABG MbH Einsteinstr. 20 85521 Ottobrunn
> Phone : 0049-89-6088-2556
> Email : [EMAIL PROTECTED] WWW site : www.iabg.de
> ----------------------------------------------------------------------------
>
> ----- Original Message -----
> From: Sahirad, Mohammed (London) <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, October 08, 1999 4:01 PM
> Subject: Re: JDBC Problem in my servlet.....
>
> > Keith,
> > Instead of
> > correctpass = rs.getString("USER_PASS");
> > try putting
> > correctpass = rs.getString(1);
> > or
> > correctpass = rs.getString(2);
> > etc.
> > depending on the position of the USER_PASS Column in you table
> >
> > Regards,
> > Mo.
> >
> >
> > Mohammad Sahirad
> > Merrill Lynch Swaps Technology
> > RMP-06-05
> > 6A Ropemaker
> > 25 Ropemaker Street
> > London EC2Y 9LY
> > +44 (0)171 867 4925
> >
> > > -----Original Message-----
> > > From: Keith Ball [SMTP:[EMAIL PROTECTED]]
> > > Sent: 08 October 1999 16:35
> > > To: [EMAIL PROTECTED]
> > > Subject: JDBC Problem in my servlet.....
> > >
> > > Here is my code for my servlet which goes to a database and checks to
> see
> > > if the password has been entered correctly.
> > >
> > >
> > > String query = "SELECT * FROM USERS WHERE USER_USERNAME = '" + username
> +
> > > "'";
> > >
> > > ResultSet rs = stmt.executeQuery(query);
> > >
> > > while (rs.next()) {
> > > correctpass = rs.getString("USER_PASS");
> > > }
> > >
> > > if(correctpass.equals(password))
> > > {
> > > iscorrect = true;
> > > } else {
> > > iscorrect = false;
> > > }
> > >
> > > return iscorrect;
> > >
> > > Correctpass results in a NULL. This code works fine when I run it as a
> > > application. Is there some sort of security issue, I dont know about ?
> I
> > > thought that servlets worked on the same security system as
> applications.
> > >
> > > Thnx for the help in advance.
> > >
> > > Keith
> >
> > --------------------------------------------------------------------------
> > > -
> > > Keith Ball - Praktikant
> > > AF12 Operationelle Analysen Luftwaffe
> > > IABG MbH Einsteinstr. 20 85521 Ottobrunn
> > > Phone : 0049-89-6088-2556
> > > Email : [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> WWW
> > > site : www.iabg.de <http://www.iabg.de>
> >
> > --------------------------------------------------------------------------
> > > --
> > >
> >
> >
> ___________________________________________________________________________
> > 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
>
> ___________________________________________________________________________
> 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
___________________________________________________________________________
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
