What about hypersonic? No reason it shouldn't work with jpa but not sure about native image.
On Fri, Mar 19, 2021 at 12:33 PM Romain Manni-Bucau <rmannibu...@gmail.com> wrote: > Quick follow up: derby has some runtime code generation+loading (see my > last comment on https://issues.apache.org/jira/browse/DERBY-7108) so it > can not be the simplest solution to get openjpa knight. What about a fake > driver to validate openjpa and see if we can come with a java 8 (seems > their last release is j9 :s) solution with derby? Worse case we can move to > a remote connection for the DB and reuse test containers we already have in > the project. > > Romain Manni-Bucau > @rmannibucau <https://twitter.com/rmannibucau> | Blog > <https://rmannibucau.metawerx.net/> | Old Blog > <http://rmannibucau.wordpress.com> | Github > <https://github.com/rmannibucau> | LinkedIn > <https://www.linkedin.com/in/rmannibucau> | Book > <https://www.packtpub.com/application-development/java-ee-8-high-performance> > > > Le jeu. 18 mars 2021 à 16:51, Romain Manni-Bucau <rmannibu...@gmail.com> > a écrit : > >> Hi all, >> >> Just to let you know, I just pushed an "openjpa" branch on arthur >> repository. >> It contains two new modules/knights: openjpa and derby. >> Goal is to be able to use openjpa in a native app easily (it is already >> doable with a lot of conf). >> >> integration-test/src/test/resources/integration-tests/openjpa >> <https://github.com/apache/geronimo-arthur/tree/openjpa/integration-test/src/test/resources/integration-tests/openjpa> >> provides >> the test I'm trying to run. >> It is not yet a setup which can be merged but current setup enables to >> run the test from this folder using "mvn clean package -Parthur >> arthur:native-image@runtime && ./target/openjpa.graal.bin >> -Dorg.slf4j.simpleLogger.defaultLogLevel=INFO" command. It means that if >> you modify derby/openjpa knight, you recompile the knight (mvn install) and >> can rerun this command from the test folder directly to see if it changes >> something/works - it is faster than recompiling everything or going through >> docker test layer. >> >> It seems that openjpa EMF started and fails when sending DDL to derby due >> to a threadlocal issue: >> >> Exception in thread "main" <openjpa-0.0.0-rnull nonfatal general error> >> org.apache.openjpa.persistence.PersistenceException: XJ001.U : [0] >> org.apache.derby.shared.common.sanity.AssertFailure, [1] ASSERT FAILED >> lcc=org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext@24a77e1e >> getContextOrNull=null >> at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:625) >> at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:489) >> at >> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:177) >> at >> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:182) >> at >> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:138) >> at >> org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:213) >> at >> org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:166) >> at >> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:262) >> at >> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:177) >> at >> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:167) >> at >> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:64) >> at >> org.apache.geronimo.arthur.integrationtests.OpenJPAMain.main(OpenJPAMain.java:77) >> Caused by: java.sql.SQLException: XJ001.U : [0] >> org.apache.derby.shared.common.sanity.AssertFailure, [1] ASSERT FAILED >> lcc=org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext@24a77e1e >> getContextOrNull=null >> at >> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:115) >> at >> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:141) >> at org.apache.derby.impl.jdbc.Util.seeNextException(Util.java:252) >> at org.apache.derby.impl.jdbc.Util.javaException(Util.java:274) >> at >> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:437) >> at >> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:353) >> at >> org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2405) >> at >> org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:88) >> at >> org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQueryUsingSystemTables(EmbedDatabaseMetaData.java:3642) >> at >> org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQuery(EmbedDatabaseMetaData.java:3686) >> at >> org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQuery(EmbedDatabaseMetaData.java:3713) >> at >> org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.doGetCols(EmbedDatabaseMetaData.java:1969) >> at >> org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getColumns(EmbedDatabaseMetaData.java:1941) >> at >> org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getColumns(DelegatingDatabaseMetaData.java:227) >> at >> org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getColumns(DelegatingDatabaseMetaData.java:227) >> at >> org.apache.openjpa.lib.jdbc.DelegatingDatabaseMetaData.getColumns(DelegatingDatabaseMetaData.java:137) >> at >> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingDatabaseMetaData.getColumns(LoggingConnectionDecorator.java:737) >> at >> org.apache.openjpa.lib.jdbc.DelegatingDatabaseMetaData.getColumns(DelegatingDatabaseMetaData.java:137) >> at >> org.apache.openjpa.jdbc.sql.DBDictionary.getColumns(DBDictionary.java:4428) >> at >> org.apache.openjpa.jdbc.schema.SchemaGenerator.generateTables(SchemaGenerator.java:532) >> at >> org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchema(SchemaGenerator.java:368) >> at >> org.apache.openjpa.jdbc.schema.SchemaGenerator.generateSchemas(SchemaGenerator.java:303) >> at >> org.apache.openjpa.jdbc.schema.SchemaTool.getDBSchemaGroup(SchemaTool.java:1314) >> at org.apache.openjpa.jdbc.schema.SchemaTool.drop(SchemaTool.java:410) >> at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:375) >> at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:571) >> ... 11 more >> Caused by: ERROR XJ001: XJ001.U : [0] >> org.apache.derby.shared.common.sanity.AssertFailure, [1] ASSERT FAILED >> lcc=org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext@24a77e1e >> getContextOrNull=null >> at >> org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory.java:170) >> at >> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:75) >> ... 36 more >> Caused by: org.apache.derby.shared.common.sanity.AssertFailure: ASSERT >> FAILED >> lcc=org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext@24a77e1e >> getContextOrNull=null >> at >> org.apache.derby.shared.common.sanity.SanityManager.ASSERT(SanityManager.java:120) >> at >> org.apache.derby.iapi.util.InterruptStatus.restoreIntrFlagIfSeen(InterruptStatus.java:245) >> at >> org.apache.derby.impl.jdbc.EmbedConnection.prepareMetaDataStatement(EmbedConnection.java:2889) >> at >> org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.prepareSPS(EmbedDatabaseMetaData.java:3803) >> at >> org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQueryUsingSystemTables(EmbedDatabaseMetaData.java:3635) >> ... 28 more >> >> >> The not debug mode looks more raw - yeah, jdbc driver still publish not >> debuggable jars but derby is easy to build from sources and then you can >> set it as systemPath in the pom to debug: >> >> Caused by: ERROR XJ001: XJ001.U : [0] java.lang.NullPointerException, [1] >> at >> org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown >> Source) >> ... 42 more >> Caused by: java.lang.NullPointerException >> at org.apache.derby.impl.sql.compile.CastNode.bindCastNodeOnly(Unknown >> Source) >> at org.apache.derby.impl.sql.compile.CastNode.bindExpression(Unknown >> Source) >> at org.apache.derby.impl.sql.compile.ResultColumn.bindExpression(Unknown >> Source) >> at >> org.apache.derby.impl.sql.compile.ResultColumnList.bindExpressions(Unknown >> Source) >> at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown >> Source) >> at >> org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown >> Source) >> at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source) >> at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown >> Source) >> at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) >> at org.apache.derby.impl.sql.GenericStatement.prepareStorable(Unknown >> Source) >> at >> org.apache.derby.iapi.sql.dictionary.SPSDescriptor.compileStatement(Unknown >> Source) >> at >> org.apache.derby.iapi.sql.dictionary.SPSDescriptor.prepareAndRelease(Unknown >> Source) >> at >> org.apache.derby.iapi.sql.dictionary.SPSDescriptor.getPreparedStatement(Unknown >> Source) >> at >> org.apache.derby.iapi.sql.dictionary.SPSDescriptor.getPreparedStatement(Unknown >> Source) >> at org.apache.derby.impl.sql.compile.ExecSPSNode.generate(Unknown Source) >> at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) >> at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) >> at >> org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown >> Source) >> ... 34 more >> >> Overall it is mainly about making derby graalifyable I think. >> I need to switch to another topic for a moment so if anyone wants to >> continue the experimentations just jump in. >> >> The small side notes I can gives are: >> >> 1. we can do a dbcp2-knight and a commons-logging-knight (for now they >> are in openjpa one - it is commented as such), these ones should be easy >> since already coded, just not packaged properly >> 2. the immediate fix for deby will likely sit either >> in org.apache.geronimo.arthur.knight.derby.DerbyExtension or a substitution >> in the same module >> 3. if easier we can use another database (h2 does not work and will >> likely not work in embedded mode so hsqldb can be saner - at least I don't >> know for this one) >> >> If you are motivated to proove openjpa runs in native mode and finish >> this branch, don't hesitate to answer this thread, I'd also be happy to >> discuss more on slack or by mail details if it helps. >> >> Romain Manni-Bucau >> @rmannibucau <https://twitter.com/rmannibucau> | Blog >> <https://rmannibucau.metawerx.net/> | Old Blog >> <http://rmannibucau.wordpress.com> | Github >> <https://github.com/rmannibucau> | LinkedIn >> <https://www.linkedin.com/in/rmannibucau> | Book >> <https://www.packtpub.com/application-development/java-ee-8-high-performance> >> > -- *Raymond Augé* (@rotty3000) Senior Software Architect *Liferay, Inc.* (@Liferay) OSGi Fellow