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 Access problem
> Hi,
>
> to get the count:
>
> String query = "SELECT count(*) FROM EMPLOYEE where
> FIRST_NAME='first'";
> while (rs.next())
> {
> int i = rs.getInt( 1 );
> System.out.println( "i: " + i );
> ...
>
> ron
>
> --- Tarik Makota <[EMAIL PROTECTED]>
> wrote:
> > OK
> > I found a problem,
> >
> > It seams that my ODBC version somehow has a glitch
> > so i need to update it.
> > My Sybase ASA connection via JDBC:ODBC is OK but
> > Microsoft based databases
> > are failing.
> > However is there a wayy in Jav ato do something
> > like:
> >
> > String validate = "SELECT count(*) FROM security
> > WHERE username = '" +
> > userName +"'"
> > Statement stmt = con.createStatement();
> > integer CountIt= stmt.execute(validate);
> >
> > or do i have to use getUpdateCount() and if Yes
> >
> > would this be correct syntax?
> >
> > String validate = "SELECT count(*) FROM security
> > WHERE username = '" +
> > userName +"'"
> > Statement stmt = con.createStatement();
> > ResultSet rs = stmt.execute(validate);
> > integer count = stmt.getUpdateCount();
> > if (count > 0) {
> > Yipppppiiiii.
> > else
> > buuu--hhhhhh
> > end if
> >
> >
> >
> >
> >
> > Thanks guys.
> >
> >
> > ----- Original Message -----
> > From: Tarik Makota <[EMAIL 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 get when i run .jsp
> > >
> > > java.sql.SQLException: [Microsoft][ODBC SQL Server
> > Driver]Invalid
> > Descriptor
> > > Index
> > >
> > >
> > >
> > > ----- Original Message -----
> > > From: 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
> > > >
> > > > regards, paul
> > > >
> > > > > -----Original Message-----
> > > > > From: Tarik Makota
> > [mailto:[EMAIL PROTECTED]]
> > > > > Sent: 09 August 2000 17:37
> > > > > To: [EMAIL PROTECTED]
> > > > > Subject: DB Access problem
> > > > >
> > > > >
> > > > > 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 is ok because i have tried User and
> > System.
> > > > >
> > > > >
> > > > >
> > > > >
> >
> ----------------------------------------------------------
> > > > > package foo;
> > > > > import java.util.*;
> > > > > import java.sql.*;
> > > > > import java.net.URL.*;
> > > > >
> > > > >
> > > > > public class DBLoginBean6{
> > > > > private boolean isValid = false;
> > > > > private String userName;
> > > > > private String userPassword;
> > > > >
> > > > > public DBLoginBean6() {
> > > > > userName="Initalized";
> > > > > userPassword="";
> > > > > String url = "jdbc:odbc:CofeePot";
> > > > > String query = "SELECT * FROM EMPLOYEES";
> > > > > String firstName;
> > > > > String lastName;
> > > > > boolean more;
> > > > > try
> > > > > {
> > > > > userName="First Try";
> > > > > try{
> > > > >
> > Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> > > > > }
> > > > > catch (java.lang.ClassNotFoundException ex)
> > > > > {
> > > > > ex.printStackTrace();
> > > > > }
> > > > > userName=" connection begin";
> > > > > Connection con =
> > DriverManager.getConnection(url,"","");
> > > > > userName="I connected";
> > > > > Statement stmt =
> > con.createStatement();
> > > > > userName="i created statement";
> > > > > ResultSet rs =
> > stmt.executeQuery(query);
> > > > > userName="i executed statement";
> > > > > while (more = rs.next())
> > > > > {
> > > > > firstName =
> > rs.getString("FIRSTNAME");
> > > > > lastName =
> > rs.getString("LASTNAME");
> > > > > System.out.println( firstName + "
> > " + lastName);
> > > > > userName = "I was executed";
> > > > > }
> > > > > userName="I did while";
> > > > > rs.close();
> > > > > stmt.close();
> > > > > con.close();
> > > > > userName="And i ewxited";
> > > > > }
> > > > > catch (SQLException ex)
> > > > > {
> > > > > ex.printStackTrace();
> > > > > }
> > > > >
> > > > >
> > > > >
> > > > > }
> > > > >
> > > > > public String getuserName() {
> > > > > return userName;
> > > > > }
> > > > > public String getuserPassword() {
> > > > > return "I am user Password";
> > > > > }
> > > > >
> > > > > }
> > > > > ----------------------------
> > > > >
> > > > >
> >
> ==============================================================
> > > > > =============
> > > > > To unsubscribe: mailto [EMAIL PROTECTED]
> > with body:
> > > > > "signoff JSP-INTEREST".
> > > > > Some relevant FAQs on JSP/Servlets can be
> > found at:
> > > > >
> > > > http://java.sun.com/products/jsp/faq.html
> > > > http://www.esperanto.org.nz/jsp/jspfaq.html
> > > >
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > > >
> >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> > > >
> > > >
> > >
> >
>
===========================================================================
> > > > To unsubscribe: mailto [EMAIL PROTECTED]
> > with body: "signoff
> > > JSP-INTEREST".
> > > > Some relevant FAQs on JSP/Servlets can be found
> > at:
> > > >
> > > > http://java.sun.com/products/jsp/faq.html
> > > > http://www.esperanto.org.nz/jsp/jspfaq.html
> > > >
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > > >
> >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> > > >
> > >
> > >
> >
>
===========================================================================
> > > To unsubscribe: mailto [EMAIL PROTECTED] with
> > body: "signoff
> > JSP-INTEREST".
> > > Some relevant FAQs on JSP/Servlets can be found
> > at:
> > >
> > > http://java.sun.com/products/jsp/faq.html
> > > http://www.esperanto.org.nz/jsp/jspfaq.html
> > >
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > >
> >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> > >
> >
> >
>
===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with
> > body: "signoff JSP-INTEREST".
> > Some relevant FAQs on JSP/Servlets can be found at:
> >
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
> __________________________________________________
> Do You Yahoo!?
> Kick off your party with Yahoo! Invites.
> http://invites.yahoo.com/
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
