[CAY-2574] FronBase integration issues

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 4.0.1, 4.1.B1
• Component/s: Database integration
• Environment: FronBase
• Assignee: Unassigned
• Reporter: Nikita Timofeev
• Created: 30/Apr/19 09:37
• Updated: 02/May/19 07:23

Description

Here are known problems with FronBase DB integration in Cayenne:

• FronBase jdbc driver incorrectly returns null instead of statement (or throwing SQLException at least) when connection.prepareStatement(sql, Statement.NO_GENERATED_KEYS) is called.
  We have simple workaround for this: just call connection.prepareStatement(sql). But it would be better if driver could do this for us, and there could be other places that do not follow JDBC specification as we can't run all tests, see second issue.

• Driver randomly hangs on socket read operation, see attached image for stack trace.
  This happens on every run of Cayenne tests (see short instructions below)

Short instructions for running Cayenne tests against FrontBase DB:

• install FB JDBC driver to local maven repo

  $ mvn install:install-file -Dfile=frontbasejdbc.jar -DgroupId=com.frontbase \
         -DartifactId=frontbase-driver -Dversion=4.1 -Dpackaging=jar -DgeneratePom=true
  

• clone Cayenne repo

  $ git clone https://github.com/apache/cayenne.git
  $ cd cayenne
  

• run tests

  $ mvn verify -DcayenneTestConnection=frontbase \
     -DcayenneAdapter=org.apache.cayenne.dba.frontbase.FrontBaseAdapter \
     -DcayenneJdbcUsername=_system \
     -DcayenneJdbcUrl=jdbc:frontbase://localhost/test \
     -DcayenneJdbcDriver=com.frontbase.jdbc.FBJDriver
  

See additional details here