Yes, SQLTemplate is processed via a different JDBC call in 4.1.
> On Oct 18, 2020, at 7:57 PM, Amedeo Mantica <amedeomant...@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 <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
>>
>