Using H2 database and Spring for testing:
),
My JPA:
@Column(name="SOR", length=20)
private String sor;
Is there a different way to Search on a CHAR field?
Thanks
jewettdiane wrote:
>
> I posted to the Spring forum, but have no responses yet.
>
> This is my spring config:
>
gt; with Spring. I just don't know enough about the getJpaTemplate to give a
>> complete answer. Have you tried touching base with Spring to see if they
>> have some ideas on how to resolve this? Or, maybe they are pointing
>> fingers
>> back at us? :-)
>>
>&g
pass-thru type
> wrapper, but they must be doing something unique in this case.
>
> Thanks,
> Kevin
>
> On Tue, Jul 14, 2009 at 11:06 AM, jewettdiane
> wrote:
>
>>
>> I find out more. It is not open jpa problem. It looks like jpatemplate.
>>
>> Thi
#x27;m grabbing at straws. But, given what you've told us thus far, I can't
> figure out how generated SQL would produce different results from within
> JPA
> vs a command line. Not sure if it will tell me anything of interest, but
> could you provide your OpenJPA SQL trace fi
any results should be massaged into objects for
> the
> application.
>
> Kevin
>
> On Fri, Jul 10, 2009 at 2:29 PM, jewettdiane
> wrote:
>
>>
>> I have a named query that produces the following sql:
>> SELECT t0.ORG_ID, t0.LST_UPDT_CD, t0.LST_UPDT_TMP, t0.LST_UP
I have a named query that produces the following sql:
SELECT t0.ORG_ID, t0.LST_UPDT_CD, t0.LST_UPDT_TMP, t0.LST_UPDT_USER_ID,
t0.ADP_ACCOUNT_TYPE_CD, t0.BILLING_CYCLE_CD,
t0.BILLING_FIRST_DT, t0.CONTRACT_SIGNED_DT, t0.CUST_ORG_ID,
t0.DUNS_NBR, t0.fein, t0.INTEGRATION_HOS