I started to study Firebird again. Use. netbeans to load the Firebird driver Program , and then create a connection method.
the usual method is JDBC: firebirdsql: Local: X:/database/mytest. FDB. However, after a round of searching, the connection failure occurs. Then I tried JDBC: firebirdsql: locahostl: X:/database/mytest again. FDB |, JDBC: firebirdsql: 127.0.0.1: X:/database/mytest. the same error occurs in FDB. No way. You only need to open the Firebird Management Tool of ibexpert, connect to the database, and then test the connection. Use the TCP/IP mode, select 3050 on the port, and then "test ". "Test pass" is displayed. Indicates that the database connection is successful. Then try again to enter netbeans and create a connection method on the JDBC driver of Firebird. This time, JDBC: firebirdsql: localhost: 3050: X:/database/mytest. FDB is created using the port number ....... After a very helpless wait, the connection is still not found. It's a strange thing! After a lookup, I found that the Firebird connection string was
JDBC: firebirdsql: localhost/3050: X:/database/mytest. in FDB, "/" is used between the port and host instead. However, after a hard review, I finally got connected. The following describes the Firebird connection string method. There may be some differences between the Firebird type and the IDE type or the IDE type. whether this is the case is still to be investigated, but let's say it now.
DRIVER:
Org. firebirdsql. JDBC. fbdriver
Connection string:
JDBC: firebirdsql: localhost/3050: X:/database/employee. FDB
JDBC: firebirdsql: Native: localhost/3050: X:/database/employee. FDB
JDBC: firebirdsql: Local: X:/database/employee. FDB
JDBC: firebirdsql: Embedded: X:/database/employee. FDB
See example \ driverexample. Java in firebirdjdbc.