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
