This is my acctual bean that is supposetly to connect to DB:
I put the 'markers' so that i know where it stops.
As soon as it hits Connection conn = ... it stops
because in my jsp page print the propert userName
so that i know wher do i get stuck.
JSP page is displayed without any errors
My DSN
silly question- should that be 'CoffeePot' in the url?
also call getConnection(url); rather than passing empty username/password
regards, paul
> -Original Message-
> From: Tarik Makota [mailto:[EMAIL PROTECTED]]
> Sent: 09 August 2000 17:37
> To: [EMAIL PROTECTED
is CofeePot supposed to be spelled with 1 f or 2?
-Original Message-
From: A mailing list about Java Server Pages specification and reference
[mailto:[EMAIL PROTECTED]]On Behalf Of Tarik Makota
Sent: Wednesday, August 09, 2000 11:37 AM
To: [EMAIL PROTECTED]
Subject: DB Access problem
Hi,
I ran your code with slight changes and it works. I
suggest you look at the odbc configuration.
ron
modified code below. if you set break points inside
the rs.next loop you will see the names.
import java.util.*;
import java.sql.*;
import java.net.URL.*;
public class DBLoginBean6{
priva
: Matthews,Paul <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 09, 2000 12:45 PM
Subject: Re: DB Access problem
> silly question- should that be 'CoffeePot' in the url?
>
> also call getConnection(url); rather than passing empty username/password
>
&
]On Behalf Of Tarik Makota
Sent: Wednesday, August 09, 2000 11:06 AM
To: [EMAIL PROTECTED]
Subject: Re: DB Access problem
I changed odbc from CoffeePot to NorthWind (MSSQL 7.0)
I have DSN under System and can access it from PowerBuilder so it works.
This is the error i get when i run .
AIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 09, 2000 2:06 PM
Subject: Re: DB Access problem
> I changed odbc from CoffeePot to NorthWind (MSSQL 7.0)
> I have DSN under System and can access it from PowerBuilder so it works.
>
> This is the error i ge
t; if (count > 0) {
> Yipi.
> else
> buuu--hh
> end if
>
>
>
>
>
> Thanks guys.
>
>
> - Original Message -
> From: Tarik Makota <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, Augus
That Sucks doesnt it??
It would make a sense to have either variable embeded into SQL
or have SQL return the integer.
Tarik
- Original Message -
From: "Ron Chan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 09, 2000 3:30 PM
Subject: Re: DB