You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cayenne.apache.org by Amedeo Mantica <am...@me.com.INVALID> on 2020/10/17 11:20:16 UTC

Issue with FrontBase PK generation in Cayenne 4.1

Hi,

I have noticed an NPE in PrimaryKey generation when using Frointbase database

Cayenne version 4.0.2 works fine, but in Cayenne 4.1 there is an issue in SQLTemplateAction

the line

PreparedStatement statement = connection.prepareStatement(compiled.getSql());

returns a null statement, causing NPE in statement.close(), even if the compiled SQL is valid.

Thoughts ?

Thank you
Amedeo

Re: Issue with FrontBase PK generation in Cayenne 4.1

Posted by Andrus Adamchik <an...@objectstyle.org>.
Yes, SQLTemplate is processed via a different JDBC call in 4.1.

> On Oct 18, 2020, at 7:57 PM, Amedeo Mantica <am...@me.com.INVALID> wrote:
> 
> btw I have no issues using Cayenne 4.0.2, the issue happens only in 4.1
> 
>> On 18 Oct 2020, at 09:36, Andrus Adamchik <an...@objectstyle.org> wrote:
>> 
>> Hi Amedeo,
>> 
>> You hit this issue: https://issues.apache.org/jira/browse/CAY-2574 <https://issues.apache.org/jira/browse/CAY-2574> . This is a bug in FrontBase driver. We started a conversation with FrontBase folks a year and a half ago, and even made some progress. But it died down and we are where we are. I suppose we are back to Plan B - fixing the driver bug on Cayenne end in the FrontBaseAdapter (e.g. by skipping SQLTemplate and using raw JDBC). 
>> 
>> Andrus
>> 
>> P.S. How many FrontBase users are still out there? We are having a hard time testing Cayenne against FB because of the various issues in the driver. We may use some help from someone motivated to maintain the adapter, or it is going to deteriorate even further. 
>> 
>> 
>>> On Oct 17, 2020, at 2:20 PM, Amedeo Mantica <am...@me.com.INVALID> wrote:
>>> 
>>> Hi,
>>> 
>>> I have noticed an NPE in PrimaryKey generation when using Frointbase database
>>> 
>>> Cayenne version 4.0.2 works fine, but in Cayenne 4.1 there is an issue in SQLTemplateAction
>>> 
>>> the line
>>> 
>>> PreparedStatement statement = connection.prepareStatement(compiled.getSql());
>>> 
>>> returns a null statement, causing NPE in statement.close(), even if the compiled SQL is valid.
>>> 
>>> Thoughts ?
>>> 
>>> Thank you
>>> Amedeo
>> 
>

Re: Issue with FrontBase PK generation in Cayenne 4.1

Posted by Amedeo Mantica <am...@me.com.INVALID>.
btw I have no issues using Cayenne 4.0.2, the issue happens only in 4.1

> On 18 Oct 2020, at 09:36, Andrus Adamchik <an...@objectstyle.org> wrote:
> 
> Hi Amedeo,
> 
> You hit this issue: https://issues.apache.org/jira/browse/CAY-2574 <https://issues.apache.org/jira/browse/CAY-2574> . This is a bug in FrontBase driver. We started a conversation with FrontBase folks a year and a half ago, and even made some progress. But it died down and we are where we are. I suppose we are back to Plan B - fixing the driver bug on Cayenne end in the FrontBaseAdapter (e.g. by skipping SQLTemplate and using raw JDBC). 
> 
> Andrus
> 
> P.S. How many FrontBase users are still out there? We are having a hard time testing Cayenne against FB because of the various issues in the driver. We may use some help from someone motivated to maintain the adapter, or it is going to deteriorate even further. 
> 
> 
>> On Oct 17, 2020, at 2:20 PM, Amedeo Mantica <am...@me.com.INVALID> wrote:
>> 
>> Hi,
>> 
>> I have noticed an NPE in PrimaryKey generation when using Frointbase database
>> 
>> Cayenne version 4.0.2 works fine, but in Cayenne 4.1 there is an issue in SQLTemplateAction
>> 
>> the line
>> 
>> PreparedStatement statement = connection.prepareStatement(compiled.getSql());
>> 
>> returns a null statement, causing NPE in statement.close(), even if the compiled SQL is valid.
>> 
>> Thoughts ?
>> 
>> Thank you
>> Amedeo
>

Re: Issue with FrontBase PK generation in Cayenne 4.1

Posted by Andrus Adamchik <an...@objectstyle.org>.
Hi Amedeo,

You hit this issue: https://issues.apache.org/jira/browse/CAY-2574 <https://issues.apache.org/jira/browse/CAY-2574> . This is a bug in FrontBase driver. We started a conversation with FrontBase folks a year and a half ago, and even made some progress. But it died down and we are where we are. I suppose we are back to Plan B - fixing the driver bug on Cayenne end in the FrontBaseAdapter (e.g. by skipping SQLTemplate and using raw JDBC). 

Andrus

P.S. How many FrontBase users are still out there? We are having a hard time testing Cayenne against FB because of the various issues in the driver. We may use some help from someone motivated to maintain the adapter, or it is going to deteriorate even further. 


> On Oct 17, 2020, at 2:20 PM, Amedeo Mantica <am...@me.com.INVALID> wrote:
> 
> Hi,
> 
> I have noticed an NPE in PrimaryKey generation when using Frointbase database
> 
> Cayenne version 4.0.2 works fine, but in Cayenne 4.1 there is an issue in SQLTemplateAction
> 
> the line
> 
> PreparedStatement statement = connection.prepareStatement(compiled.getSql());
> 
> returns a null statement, causing NPE in statement.close(), even if the compiled SQL is valid.
> 
> Thoughts ?
> 
> Thank you
> Amedeo