Hi Hugi, Unfortunately, I think you’re right.
I wanted to leave FrontbaseSQL too but as Andrus say, the meeting in Frankfurt help me to resolve some cases and finally we keep our softwares using FrontbaseSQL. According to your experience, is there an easy way to migrate/transfert from PostgreSQL to FrontBaseSQL ? It could respond to the request from developers to have access to programming tools with the database, not offered by FrontbaseSQL. Thank’s for this highlight, Jérémy > Le 16 avr. 2021 à 09:53, Hugi Thordarson <h...@karlmenn.is> a écrit : > > Hi Jérémy, > > I believe you hit a bug in the FrontBase JDBC driver: > https://issues.apache.org/jira/browse/CAY-2574 > <https://issues.apache.org/jira/browse/CAY-2574> > > Andrus wrote to FrontBase about this after our Frankfurt meetup: > https://mail-archives.apache.org/mod_mbox/cayenne-dev/201905.mbox/%3C52EC2486-4736-4854-AE49-A7CF77904E52%40objectstyle.org%3E > <https://mail-archives.apache.org/mod_mbox/cayenne-dev/201905.mbox/browser> > > I haven't seen anything from FB about this since this thread, perhaps you > should give their support a check? > I also wrote to them last year about their JDBC driver not working on more > recent Java versions, but don't think they've fixed it. I ended up migrating > that one last FrontBase app to Postgres. > > Cheers, > - hugi > > > >> On 15 Apr 2021, at 20:59, Jérémy DE ROYER <jeremy.dero...@ingencys.net> >> wrote: >> >> Hi John, >> >> I know that FrontbaseSQL is not commonly used but our all apps are based on. >> >> I’ve just : >> - created the model explained on the doc >> https://cayenne.apache.org/docs/3.0/modeling-single-table-inheritance.html >> - wrote the code below inside the ‘Application’ class of a simple woapp >> >> But yes, maybe Cayenne is not done to work with FrontbaseSQL… as it works >> well with PostregSQL. >> >> Thank’s for your answer and have a nice day, >> >> Jérémy >> >> Le 15 avr. 2021 à 22:50, John Huss >> <johnth...@gmail.com<mailto:johnth...@gmail.com>> a écrit : >> >> I don't think FrontBase is very commonly used. I would recommend submitting >> a minimal example of the problem and someone should be able to fix the >> issue then. >> >> On Thu, Apr 15, 2021 at 3:44 PM Jérémy DE ROYER >> <jeremy.dero...@ingencys.net<mailto:jeremy.dero...@ingencys.net>> >> wrote: >> >> Hello, >> >> I switched my model from FrontBase to PostgreSQL and it works great. >> >> Does someone use Cayenne 4.1 with FrontbaseSQL successfully ? >> >> Is there something specific to know ? >> >> Thank’s for any tip, >> >> Jérémy >> >> Le 14 avr. 2021 à 23:05, Jérémy DE ROYER >> <jeremy.dero...@ingencys.net<mailto:jeremy.dero...@ingencys.net>> >> a écrit : >> >> Hi all, >> >> I’m trying to find a solution for the (temporary ?) lack of horizontal >> inheritance so I did model vertical inheritance following : >> >> https://cayenne.apache.org/docs/3.0/modeling-vertical-inheritance.html >> >> using a Frontbase database. >> >> I did : >> - create the model, >> - generate the database, >> - fix lack of jars and other things like username, password, jdbc driver >> >> The demo code below starts well and connects to database... >> >> try { >> ServerRuntime cayenneRuntime = ServerRuntime.builder() >> .addConfig("cayenne-CayenneTest.xml") >> .build(); >> >> ObjectContext context = cayenneRuntime.newContext(); >> >> Book _newBook = context.newObject(Book.class); >> _newBook.setTitle("Nouveau Book"); >> _newBook.setCreated(new Date()); >> >> context.commitChanges(); >> >> EBook _newEBook = context.newObject(EBook.class); >> _newEBook.setTitle("Nouveau EBook"); >> _newEBook.setCreated(new Date()); >> _newEBook.setDownloadUrl("https://www.google.fr/";); >> >> context.commitChanges(); >> >> PaperBook _newPaperBook = context.newObject(PaperBook.class); >> _newPaperBook.setTitle("Nouveau PaperBook"); >> _newPaperBook.setCreated(new Date()); >> _newPaperBook.setShippingWeight(1000); >> >> context.commitChanges(); >> >> List<Book> _books = ObjectSelect.query(Book.class).select(context); >> >> System.out.println("** ALL **"); >> >> for (Book currentBook : _books) >> { >> System.out.println(currentBook.getTitle() + " created on " + >> currentBook.getCreated()); >> } >> } >> catch (Exception e) { >> System.out.println("An error occured : " + e.getMessage()); >> e.printStackTrace(); >> } >> >> …but throws this exception >> >> An error occured : [v.4.1 Jul 14 2020 10:40:45] Commit Exception >> org.apache.cayenne.CayenneRuntimeException: [v.4.1 Jul 14 2020 10:40:45] >> Commit Exception >> at >> org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:774) >> at >> org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:691) >> at your.app.Application.<init>(Application.java:50) >> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >> at >> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) >> at >> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) >> at java.lang.reflect.Constructor.newInstance(Constructor.java:423) >> at java.lang.Class.newInstance(Class.java:442) >> at com.webobjects.appserver.WOApplication.main(WOApplication.java:547) >> at your.app.Application.main(Application.java:25) >> Caused by: java.lang.NullPointerException >> at >> org.apache.cayenne.access.jdbc.SQLTemplateAction.execute(SQLTemplateAction.java:242) >> at >> org.apache.cayenne.access.jdbc.SQLTemplateAction.runWithNamedParametersBatch(SQLTemplateAction.java:179) >> at >> org.apache.cayenne.access.jdbc.SQLTemplateAction.performAction(SQLTemplateAction.java:111) >> at >> org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:97) >> at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:273) >> at >> org.apache.cayenne.dba.frontbase.FrontBasePkGenerator.longPkFromDatabase(FrontBasePkGenerator.java:143) >> at >> org.apache.cayenne.dba.JdbcPkGenerator.generatePk(JdbcPkGenerator.java:220) >> at >> org.apache.cayenne.access.DataDomainInsertBucket.createPermIds(DataDomainInsertBucket.java:168) >> at >> org.apache.cayenne.access.DataDomainInsertBucket.appendQueriesInternal(DataDomainInsertBucket.java:76) >> at >> org.apache.cayenne.access.DataDomainSyncBucket.appendQueries(DataDomainSyncBucket.java:78) >> at >> org.apache.cayenne.access.DataDomainFlushAction.preprocess(DataDomainFlushAction.java:185) >> at >> org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:143) >> at org.apache.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:624) >> at >> org.apache.cayenne.access.DataDomain.onSyncNoFilters(DataDomain.java:594) >> at >> org.apache.cayenne.access.DataDomain$DataDomainSyncFilterChain.onSync(DataDomain.java:822) >> at >> org.apache.cayenne.tx.TransactionFilter.lambda$onSync$0(TransactionFilter.java:61) >> at >> org.apache.cayenne.tx.DefaultTransactionManager$BaseTransactionHandler.performInTransaction(DefaultTransactionManager.java:183) >> at >> org.apache.cayenne.tx.DefaultTransactionManager$BaseTransactionHandler.performInNewTransaction(DefaultTransactionManager.java:155) >> at >> org.apache.cayenne.tx.DefaultTransactionManager$NestedTransactionHandler.handle(DefaultTransactionManager.java:98) >> at >> org.apache.cayenne.tx.DefaultTransactionManager.performInTransaction(DefaultTransactionManager.java:65) >> at >> org.apache.cayenne.tx.DefaultTransactionManager.performInTransaction(DefaultTransactionManager.java:43) >> at >> org.apache.cayenne.tx.TransactionFilter.onSync(TransactionFilter.java:61) >> at >> org.apache.cayenne.access.DataDomain$DataDomainSyncFilterChain.onSync(DataDomain.java:821) >> at org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:581) >> at >> org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:742) >> ... 9 more >> >> It seem’s to be related to pk generation so I try a select unqiue from >> Book in FrontBase and it worked lije a charm. >> >> Any idea ? >> >> Many thank’s, >> >> Jérémy >> >> >> >
