> I took a look the type4 driver and it seems quite nicer than the
> Borland Interclient. Just download the source and built it
> successful in Win2K. I am trying to find one sample example to use
> the driver in a java servlet.

type4 jdbc driver has two drivers inside: managed and unmanaged.
managed is targeting the application servers, while unmanaged can be
used like any other JDBC driver. The code for getting the unmanaged
connection should be like this:

import java.sql.*;
import java.util.*;

....

Class.forName("org.firebirdsql.jdbc.FBDriver");

String url =
"jdbc:firebirdsql:localhost:c:/firebird/examples/employee.gdb"

Properties dbInfo = new Properties();
dbInfo.setProperty("user", "sysdba");
dbInfo.setProperty("password", "masterkey");

Driver driver = java.sql.DriverManager.getDriver();
Connection connection = driver.connect(url, dbInfo);



Later you can use standard JDBC calls. Note, that current
implementation does not provide connection pooling, so you have to do
it by hands.

Best regards,
Roman Rokytskyy