Patrice DUROUX created OPENJPA-2903:
---------------------------------------
Summary: compatibility with MariaDB Java Client 3.0.6
Key: OPENJPA-2903
URL: https://issues.apache.org/jira/browse/OPENJPA-2903
Project: OpenJPA
Issue Type: Wish
Affects Versions: 3.2.0
Environment: Operating System: Ubuntu
JRE: OpenJDK Runtime Environment (build 11.0.16+8-post-Ubuntu-0ubuntu1)
Reporter: Patrice DUROUX
Hi,
Here is what I got at runtime upgrading the MariaDB Java Client from 2.7.6 to
3.0.6:
{noformat}
<openjpa-3.2.0-r6f721f6 nonfatal user error>
org.apache.openjpa.persistence.ArgumentException: There was an error packing
the projection and/or aggregate results of the query into result type "class
org.imgt.model.genedb2.CustomBeanLIGMDB". See the nested Throwable exception
for details. FailedObject: SELECT sa.gene AS gene,sa.species AS species,sa.exon
AS exon,sa.number AS alleleNumber,se.seqnuc AS fullSeq,fe2.feadeb AS
posDeb,fe2.feafin AS posFin,sa.numacc AS numacc,fe2.phase AS phase,sa.taxon AS
taxon,fe2.partial AS partiality,fe2.complement AS rc,sa.ordre AS exonorder FROM
genedb.seqalleles sa,ligmdb_v12.sequences se,ligmdb_v12.features
fe1,ligmdb_v12.features fe2,ontology.labels la1,ontology.labels la2 WHERE
sa.is_ref=1 AND sa.numacc=se.numacc AND sa.numacc=fe1.numacc AND
sa.feanum=fe1.feanum AND sa.labcode=fe1.labcode AND la1.label=sa.exon AND
la1.labcode=la2.labcode AND la2.labcode=fe2.labcode AND sa.numacc=fe2.numacc
AND fe1.feadeb<=fe2.feadeb AND fe2.feafin<=fe1.feafin AND sa.gene=? AND
sa.species=? AND sa.numacc=? AND sa.exon=? [java.lang.String] at
org.apache.openjpa.kernel.ResultPacker.packUserType(ResultPacker.java:299) at
org.apache.openjpa.kernel.ResultPacker.pack(ResultPacker.java:262) at
org.apache.openjpa.jdbc.kernel.SQLProjectionResultObjectProvider.getResultObject(SQLProjectionResultObjectProvider.java:98)
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:38)
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1314) at
org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1061) at
org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:911) at
org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:842) at
org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601) at
org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297) at
org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314) at
org.imgt.dao.GENEDBDAO.getLIGMDBentries(GENEDBDAO.java:590) at
org.imgt.dao.GENEDBDAO.getLIGMDBentries(GENEDBDAO.java:616) at
org.imgt.util.fasta.GeneFastaSeq2.getFastaSeq(GeneFastaSeq2.java:46) at
org.imgt.toolbox.genedb.GenedbFlatFile.run(GenedbFlatFile.java:81) at
org.imgt.tools.cmd.FFile.run(FFile.java:18) at
picocli.CommandLine.executeUserObject(CommandLine.java:1939) at
picocli.CommandLine.access$1300(CommandLine.java:145) at
picocli.CommandLine$RunAll.recursivelyExecuteUserObject(CommandLine.java:2431)
at
picocli.CommandLine$RunAll.recursivelyExecuteUserObject(CommandLine.java:2433)
at picocli.CommandLine$RunAll.handle(CommandLine.java:2428) at
picocli.CommandLine$RunAll.handle(CommandLine.java:2389) at
picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2179)
at picocli.CommandLine$RunAll.execute(CommandLine.java:2391) at
picocli.CommandLine.execute(CommandLine.java:2078) at
org.imgt.tools.SeqTool.main(SeqTool.java:19) Caused by:
java.lang.ClassCastException: Cannot convert object
"org.mariadb.jdbc.MariaDbBlob@2178ae3b" of type "class
org.mariadb.jdbc.MariaDbBlob" into an instance of "class [B". at
org.apache.openjpa.kernel.Filters.convert(Filters.java:395) at
org.apache.openjpa.kernel.Filters.convert(Filters.java:271) at
org.apache.openjpa.kernel.ResultPacker.packUserType(ResultPacker.java:280) ...
25 more{noformat}
Not sure on which side (OpenJPA? MariaDB Java Client?) the problem belongs to.
Regards,
Patrice
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
