cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nikita Timofeev (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CAY-2574) FronBase integration issues
Date Thu, 02 May 2019 07:24:00 GMT

     [ https://issues.apache.org/jira/browse/CAY-2574?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Nikita Timofeev updated CAY-2574:
---------------------------------
    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)

!Screen Shot 2019-04-12 at 14.44.30.png!

Short instructions for running Cayenne tests against FrontBase DB:
 * install FB JDBC driver to local maven repo
{code:java}
$ mvn install:install-file -Dfile=frontbasejdbc.jar -DgroupId=com.frontbase \
       -DartifactId=frontbase-driver -Dversion=4.1 -Dpackaging=jar -DgeneratePom=true
{code}

 * clone Cayenne repo
{code:java}
$ git clone https://github.com/apache/cayenne.git
$ cd cayenne
{code}

 * run tests
{code:java}
$ mvn verify -DcayenneTestConnection=frontbase \
   -DcayenneAdapter=org.apache.cayenne.dba.frontbase.FrontBaseAdapter \
   -DcayenneJdbcUsername=_system \
   -DcayenneJdbcUrl=jdbc:frontbase://localhost/test \
   -DcayenneJdbcDriver=com.frontbase.jdbc.FBJDriver
{code}

See additional details [here|https://cayenne.apache.org/dev/running-unit-tests.html]
  

  was:
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 (like just call {{mvn verify}} with FrontBase
connection)

!Screen Shot 2019-04-12 at 14.44.30.png!

 


> FronBase integration issues
> ---------------------------
>
>                 Key: CAY-2574
>                 URL: https://issues.apache.org/jira/browse/CAY-2574
>             Project: Cayenne
>          Issue Type: Bug
>          Components: Database integration
>    Affects Versions: 4.0.1, 4.1.B1
>         Environment: FronBase
>            Reporter: Nikita Timofeev
>            Priority: Minor
>         Attachments: Screen Shot 2019-04-12 at 14.44.30.png
>
>
> 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)
> !Screen Shot 2019-04-12 at 14.44.30.png!
> Short instructions for running Cayenne tests against FrontBase DB:
>  * install FB JDBC driver to local maven repo
> {code:java}
> $ mvn install:install-file -Dfile=frontbasejdbc.jar -DgroupId=com.frontbase \
>        -DartifactId=frontbase-driver -Dversion=4.1 -Dpackaging=jar -DgeneratePom=true
> {code}
>  * clone Cayenne repo
> {code:java}
> $ git clone https://github.com/apache/cayenne.git
> $ cd cayenne
> {code}
>  * run tests
> {code:java}
> $ mvn verify -DcayenneTestConnection=frontbase \
>    -DcayenneAdapter=org.apache.cayenne.dba.frontbase.FrontBaseAdapter \
>    -DcayenneJdbcUsername=_system \
>    -DcayenneJdbcUrl=jdbc:frontbase://localhost/test \
>    -DcayenneJdbcDriver=com.frontbase.jdbc.FBJDriver
> {code}
> See additional details [here|https://cayenne.apache.org/dev/running-unit-tests.html]
>   



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message