B.7. Firebird

B.7.1. Known issues with Firebird

Example B.7. Example properties for Firebird

javax.jdo.option.ConnectionDriverName: org.firebirdsql.jdbc.FBDriver
javax.jdo.option.ConnectionURL: jdbc:firebirdsql://SERVER_NAME:SERVER_PORT/DB_PATH

B.7.1. Known issues with Firebird

  • The Firebird JDBC driver does not have proper support for batch updates, so batch updates are disabled.

  • Firebird does not support auto-increment columns.

  • Firebird does not support the LOWER, SUBSTRING, or INSTR SQL functions, which means that toLowerCase(), indexOf(), and substring() methods in JDOQL cannot be used.