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 <and...@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 <amedeomant...@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
>
