That's always fun :). BarCode.CODE is a LONGVARCHAR mapped to a TEXT-column in
a MySQL db.
- hugi
> On 26 May 2017, at 12:48, Nikita Timofeev <ntimof...@objectstyle.com> wrote:
>
> Yes, fix definitely affected this query, but seems that it's not broke
> something, but rather revealed some other hidden bug.
> What is the type of DbAttribute mapped on BarCode.CODE property?
>
> On Fri, May 26, 2017 at 3:37 PM, Hugi Thordarson <h...@karlmenn.is> wrote:
>> Is it possible the fix broke something else? I'm now getting exceptions for
>> queries that worked this morning. I only see it happening in queries where
>> i'm traversing to-many relationships in the where-part of the query though.
>> This method:
>>
>> public String number() {
>> return ObjectSelect
>> .query( BarCode.class )
>> .column( BarCode.CODE )
>> .where( BarCode.BAR_CODE_SKUS.dot( BarCodeSku.SKU
>> ).eq( this ) )
>> .selectFirst( getObjectContext() );
>> }
>>
>> (BarCode.CODE is a string)
>>
>> Now causes this error:
>>
>> java.lang.ClassCastException: java.lang.String cannot be cast to
>> org.apache.cayenne.DataRow
>> at
>> org.apache.cayenne.access.jdbc.DistinctResultIterator.checkNextUniqueRow(DistinctResultIterator.java:147)
>> at
>> org.apache.cayenne.access.jdbc.DistinctResultIterator.checkNextRow(DistinctResultIterator.java:136)
>> at
>> org.apache.cayenne.access.jdbc.DistinctResultIterator.<init>(DistinctResultIterator.java:74)
>> at
>> org.apache.cayenne.access.jdbc.SelectAction.forSuppressedDistinct(SelectAction.java:236)
>> at
>> org.apache.cayenne.access.jdbc.SelectAction.performAction(SelectAction.java:121)
>> at
>> org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:97)
>> at
>> org.apache.cayenne.access.DataNode.performQueries(DataNode.java:293)
>> at
>> org.apache.cayenne.access.DataDomainQueryAction.runQuery(DataDomainQueryAction.java:471)
>> at
>> org.apache.cayenne.access.DataDomainQueryAction.access$000(DataDomainQueryAction.java:72)
>> at
>> org.apache.cayenne.access.DataDomainQueryAction$2.perform(DataDomainQueryAction.java:446)
>> at
>> org.apache.cayenne.tx.DefaultTransactionManager.performInTransaction(DefaultTransactionManager.java:87)
>> at
>> org.apache.cayenne.tx.DefaultTransactionManager.performInLocalTransaction(DefaultTransactionManager.java:59)
>> at
>> org.apache.cayenne.tx.DefaultTransactionManager.performInTransaction(DefaultTransactionManager.java:52)
>> at
>> org.apache.cayenne.tx.DefaultTransactionManager.performInTransaction(DefaultTransactionManager.java:40)
>> at
>> org.apache.cayenne.access.DataDomainQueryAction.runQueryInTransaction(DataDomainQueryAction.java:443)
>> at
>> org.apache.cayenne.access.DataDomainQueryAction.execute(DataDomainQueryAction.java:122)
>> at
>> org.apache.cayenne.access.DataDomain.onQueryNoFilters(DataDomain.java:564)
>> at
>> org.apache.cayenne.access.DataDomain$DataDomainQueryFilterChain.onQuery(DataDomain.java:748)
>> at
>> org.apache.cayenne.commitlog.CommitLogFilter.onQuery(CommitLogFilter.java:61)
>> at
>> org.apache.cayenne.access.DataDomain$DataDomainQueryFilterChain.onQuery(DataDomain.java:748)
>> at
>> org.apache.cayenne.tx.TransactionFilter.onQuery(TransactionFilter.java:49)
>> at
>> org.apache.cayenne.access.DataDomain$DataDomainQueryFilterChain.onQuery(DataDomain.java:748)
>> at org.apache.cayenne.access.DataDomain.onQuery(DataDomain.java:556)
>> at
>> org.apache.cayenne.util.ObjectContextQueryAction.runQuery(ObjectContextQueryAction.java:382)
>> at
>> org.apache.cayenne.util.ObjectContextQueryAction.executePostCache(ObjectContextQueryAction.java:107)
>> at
>> org.apache.cayenne.util.ObjectContextQueryAction.execute(ObjectContextQueryAction.java:94)
>> at org.apache.cayenne.access.DataContext.onQuery(DataContext.java:965)
>> at
>> org.apache.cayenne.access.DataContext.performQuery(DataContext.java:954)
>> at org.apache.cayenne.BaseContext.select(BaseContext.java:307)
>> at org.apache.cayenne.BaseContext.selectFirst(BaseContext.java:331)
>> at
>> org.apache.cayenne.query.ColumnSelect.selectFirst(ColumnSelect.java:660)
>> at strimillinn.core.model.Sku.number(Sku.java:54)
>>
>> Cheers,
>> - hugi
>>
>>
>>
>>> On 26 May 2017, at 11:56, Nikita Timofeev <ntimof...@objectstyle.com> wrote:
>>>
>>> Hi again,
>>>
>>> I've pushed fix for this issue.
>>> https://github.com/apache/cayenne/commit/eac1f31073045fec6eafef3f3fd6cb05f0201994
>>>
>>> On Wed, May 24, 2017 at 7:03 PM, Hugi Thordarson <h...@karlmenn.is> wrote:
>>>> Thanks Nikita, at least I know I'm not doing anything wrong then :)
>>>>
>>>> - hugi
>>>>
>>>>
>>>>> On 24 May 2017, at 14:52, Nikita Timofeev <ntimof...@objectstyle.com>
>>>>> wrote:
>>>>>
>>>>> Hi Hugi,
>>>>>
>>>>> Seems like custom types are broken in ColumnSelect, I see this bug in
>>>>> my test too.
>>>>>
>>>>> On Wed, May 24, 2017 at 5:34 PM, Hugi Thordarson <h...@karlmenn.is> wrote:
>>>>>> I'm using today's version of 4.0.M6-SNAPSHOT. Always living on the edge
>>>>>> :)
>>>>>>
>>>>>> - hugi
>>>>>>
>>>>>>
>>>>>>> On 24 May 2017, at 14:31, Andrus Adamchik <and...@objectstyle.org>
>>>>>>> wrote:
>>>>>>>
>>>>>>> Or .. if you already have cayenne-java8 in your app, and the problem is
>>>>>>> specific to just the column select query, you may also need to switch
>>>>>>> to M6. IIRC there were some issues in M5 with the behavior that you
>>>>>>> describe.
>>>>>>>
>>>>>>> Andrus
>>>>>>>
>>>>>>>> On May 24, 2017, at 5:28 PM, Andrus Adamchik <and...@objectstyle.org>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>> You need to add cayenne-java8 dependency.
>>>>>>>>
>>>>>>>> Unfortunately the fallback behavior (treat unknown class as
>>>>>>>> Serializable) is extremely confusing. Though I think we log some
>>>>>>>> warnings before doing that.
>>>>>>>>
>>>>>>>> ANdrus
>>>>>>>>
>>>>>>>>
>>>>>>>>> On May 24, 2017, at 5:20 PM, Hugi Thordarson <h...@karlmenn.is> wrote:
>>>>>>>>>
>>>>>>>>> Hi all,
>>>>>>>>> if I try to fetch Java 8 date objects using ColumnSelect, the values
>>>>>>>>> get returned as byte arrays instead of actual objects. Example:
>>>>>>>>>
>>>>>>>>> LocalDateTime creationDate = ObjectSelect
>>>>>>>>> .query( User.class )
>>>>>>>>> .column( User.CREATION_DATE )
>>>>>>>>> .selectFirst( Jambalaya.newContext() );
>>>>>>>>>
>>>>>>>>> User.creationDate() is a LocalDateTime—but the fetch will fail since
>>>>>>>>> the returned value is a byte array.
>>>>>>>>>
>>>>>>>>> Bug?
>>>>>>>>>
>>>>>>>>> Cheers,
>>>>>>>>> - hugi
>>>>
>>>
>>>
>>>
>>> --
>>> Best regards,
>>> Nikita Timofeev
>>
>
>
>
> --
> Best regards,
> Nikita Timofeev
