JDBC connection string of Firebird

Source: Internet
Author: User
Tags netbeans

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.