[ https://issues.apache.org/jira/browse/OPENJPA-983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Milosz Tylenda updated OPENJPA-983: ----------------------------------- Attachment: OPENJPA-983.patch Some info and main features: 1.I have focused on Firebird versions 1.5, 2.0 and 2.1. 2.1 is the latest version and 1.0 is no longer supported by Firebird developers. I tested the dictionary with Firebird versions 1.5.5/Windows and 2.1.1/Linux, JayBird 2.1.6 JDBC driver. 2.With the new dictionary the number of failed tests drops down from over 400 to around 300. Still far from sliced bread but many errors come from using reserved words in table and column names. 3.The dictionary no longer extends InterbaseDictionary, the databases now differ too much to benefit from extension. 4.The Firebird documentation is available at their site [1]. The most useful docs in this context are Firebird 2.1 Release Notes, Firebird 2.0 Language Reference Update and InterBase 6.0 Language Reference. 5.There are three properties users can set: - firebirdVersion to force Firebird version, - rangeSyntax to force the way queries involving range are handled (two syntaxes are possible), - indexedVarcharMaxSizeFB15 to control the VARCHAR size when it is an indexed column (version 1.5 has strong limits here). If not set, these properties will be set by auto-detection. 6.When connected to Firebird 1.5, the dictionary assumes InterBase UDFs are available (can be made available by running the ib_udf.sql script). They are needed by some of JPQL functions. 7.I couldn't make indexOf method (LOCATE in JPQL) work. There is no suitable function to use in versions 1.5 and 2.0. 2.1 has the POSITION function, which seemed promising, but OpenJPA modifies the parameters by adding some expressions (see JPQLExpressionBuilder) which Firebird does not accept here. [1] http://www.firebirdsql.org/index.php?op=doc > FirebirdDictionary improvements > ------------------------------- > > Key: OPENJPA-983 > URL: https://issues.apache.org/jira/browse/OPENJPA-983 > Project: OpenJPA > Issue Type: Improvement > Components: sql > Environment: Firebird versions 1.5.5/Windows > and 2.1.1/Linux, JayBird 2.1.6 JDBC driver > Reporter: Milosz Tylenda > Assignee: Milosz Tylenda > Attachments: OPENJPA-983.patch > > > The new dictionary makes OpenJPA more up-to-date with the recent Firebird > enhancements. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.