Rev 816287 corrected many of the Oracle failures, but at least one issue remains for that platform.
-Jeremy On Mon, Sep 21, 2009 at 2:35 PM, Donald Woods <[email protected]> wrote: > After the focus on cleaning up failing junits on non-Derby databases this > month, TestReaderLob is passing now on MySQL and only has one failure on > Oracle, but still has 5 failures on MSSQL.... > > Not sure which svn check-in resolved it, as it could have been r816287 for > Oracle or a number of the other test fixes by Fay to correct case sensitive > column/table names or schema naming fixes.... > > > -Donald > > > > Miłosz Tylenda wrote: > >> Hi Simone, >> >> OpenJPA currently supports (judging from test cases) streaming LOB with >> MySQL, Oracle, PostgreSQL and SQL Server. However, even with these databases >> there are bugs to fix. OPENJPA-1248 [1] contains a few stack traces some of >> which are similar to yours. Thus the exception you are getting from a newer >> Derby might be an OpenJPA fault. >> >> [1] https://issues.apache.org/jira/browse/OPENJPA-1248 >> >> Regards, >> Milosz >> >> Hi all, >>> I've been experimenting with the streaming LOB on Apache Derby and Hsql. >>> I'm using OpenJPA 1.2.0. >>> >>> On Hsql, it is not supported because it does not support select for >>> update. >>> >>> On Derby 10.1.2.1 (reported as supported in >>> http://openjpa.apache.org/builds/1.2.0/apache-openjpa-1.2.0/docs/manual/manual.html#supported_databases) >>> and up to 10.2.2.0 it does not work. An exception [1] is thrown when trying >>> persisting. >>> >>> On Derby 10.4.1.3, 10.4.2.0, 10.3.2.1 it fails with an exception, but not >>> when writing, during read operation [2]. Looking at derby source, seems like >>> an IOException is thrown when stream value is null. >>> >>> The same application works perfectly on different versions of MySQL, both >>> on windows and linux. >>> >>> Has anyone managed to have streaming lob working on Derby? Am I missing >>> some configuration option? >>> >>> Simone >>> >>> >>> >>> [1] >>> Caused by: SQL Exception: Feature not implemented: no details. >>> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown >>> Source) >>> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown >>> Source) >>> at org.apache.derby.impl.jdbc.Util.notImplemented(Unknown Source) >>> at org.apache.derby.impl.jdbc.EmbedBlob.setBinaryStream(Unknown >>> Source) >>> at >>> org.apache.openjpa.jdbc.sql.DBDictionary.updateBlob(DBDictionary.java:4310) >>> at >>> org.apache.openjpa.jdbc.meta.strats.LobFieldStrategy.customInsert(LobFieldStrategy.java:112) >>> at >>> org.apache.openjpa.jdbc.meta.FieldMapping.customInsert(FieldMapping.java:701) >>> at >>> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager$CustomMapping.execute(AbstractUpdateManager.java:352) >>> at >>> org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:94) >>> >>> [2] >>> Caused by: java.io.IOException >>> at >>> org.apache.derby.iapi.services.io.NewByteArrayInputStream.read(Unknown >>> Source) >>> at java.io.InputStream.read(InputStream.java:85) >>> >>> >>> -- >>> Simone Gianni CEO Semeru s.r.l. Apache Committer >>> http://www.simonegianni.it/ >>> >>> >>> >>
