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
