-----Original Message-----
From: chc_225 [mailto:chc_225@...]
Sent: Friday, November 01, 2002 8:59 AM
To: Firebird-Java@yahoogroups.com
Subject: [Firebird-Java] jaybird problem

Hello,

I am still having problem with the jaybird jdbc driver. this is my
configuration

I am using a windows NT 4.0  and J2sdk1.4.0

this is my classpath:-

CLASSPATH=G:\fbjdbc\lib\mini-j2ee.jar; G:\fbjdbc\lib\mini-
concurrent.jar; G:\fbjdbc\jaas.jar;  G:\fbjdbc\lib\log4j-core.jar; 
G:\fbjdbc\firebirdsql.jar; G:\fbjdbc\firebirdjmx.jar; D:\j2sdk1.4.0
\bin; D:\j2sdk1.4.0\lib; D:\j2sdk1.4.0\jre\lib;


I called my program with the following:-
F:\practice>java  TstFb

and get the following error:-
Couldn't locate the driver class: java.lang.ClassNotFoundException:
org.firebirdsql.jdbc.FBDriver


can anyone help me find the problem please.


this is my program listing - pls note that it is not that garbled in
my editor :-

import java.sql.*;

public class TstFb
{
     public static void main(String args[])
     {
         String lname = null;
         String fname = null;
         Connection con;
          Statement sment;
          ResultSet rs;

           try
           {
               Class.forName("org.firebirdsql.jdbc.FBDriver");
                con = DriverManager.getConnection
("jdbc:firebirdsql://localhost/3050:Ibaccess.gdb", "SYSDBA",
              "masterkey");
                     
                String sql = "SELECT lname, fname FROM customer WHERE
custno = 3";

                sment = con.createStatement();

                rs = sment.executeQuery(sql);

                if ( rs.next() )
                { lname = rs.getString("lname");
                   fname = rs.getString("fname");
                 }
                 rs.close();
                 sment.close();
                 con.close();

            }

            catch ( ClassNotFoundException cnfe )
            {
                System.err.println("Couldn't locate the driver
class: "+cnfe);
             }
             catch ( SQLException se )
             {
                 System.err.println("Exception creating the database
connection: "+se);
             }


                 

      } // main
  } // CLASS




this is the structure of my directory where I have jaybird files:-

Directory of G:\fbjdbc

06/08/02  09:44p        <DIR>          .
06/08/02  09:44p        <DIR>          ..
09/22/02  10:25p                73,089 firebirdjmx.jar
09/22/02  10:25p                94,126 firebirdsql-test.jar
09/22/02  10:25p               229,301 firebirdsql.jar
09/22/02  10:25p               215,721 firebirdsql.rar
06/08/02  09:44p        <DIR>          lib
09/11/02  11:42p                98,743 release_notes.html


Directory of G:\fbjdbc\lib

06/08/02  09:44p        <DIR>          .
06/08/02  09:44p        <DIR>          ..
05/09/01  10:30a               104,195 jaas.jar
02/02/02  01:45p                66,624 log4j-core.jar
09/22/02  10:25p                 6,473 mini-concurrent.jar
09/22/02  10:25p                31,186 mini-j2ee.jar



thanks in advance for your help




To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.