persistence@glassfish.java.net

Re: how to map NVARCHAR2 columns

From: Mitesh Meswani <Mitesh.Meswani_at_Sun.COM>
Date: Thu, 31 Aug 2006 16:32:41 -0700

Rochelle Raccah wrote:
> Okay, the verifier bug goes away if a stateless session bean is added
> to the project, so:
>
> 1) For cmp this is still an issue - is there a better thing to
> generate than Object for this case? Can we handle char with the
> formOfUse change?
The current cmp runtime is not aware of NCHAR data type and does not
call formOfUse(). It should not be a big effort putting the support if
we are able to distinguish at run time that a given column is of this
type. Then the issue is, since this is not standard jdbc type, our
dbmodel mignt not be able to carry this information. How did you solve
this issue for generation?

Thanks,
Mitesh
> 2) For JPA, we generate
> @Id
> @Lob
> @Column(name = "GENRE", nullable = false)
> private Object genre;
> It verifies correctly, but is it okay?
>
> Thanks,
> Rochelle
>
> Rochelle Raccah wrote:
>
>> Both, I think. Right now, the generated JPA has fields of type
>> Object as well, but the verifier is not working for it:
>> <https://glassfish.dev.java.net/issues/show_bug.cgi?id=1049>
>>
>> Rochelle
>>
>> Marina Vatkina wrote:
>>
>>> Rochelle,
>>>
>>> The NB bug talks about cmp - is it cmp or JPA (or both) related
>>> question?
>>>
>>> thanks,
>>> -marina
>>>
>>> Peter Krogh wrote:
>>>
>>>> Supporting 'N' Types requires Oracle Specific JDBC calls, that are
>>>> not currently supported by TopLink Essentials. Support for N types
>>>> sounds like a good feature request to be added to the issue tracker.
>>>>
>>>> Note: Adding this support may require changes to the build system
>>>> to compile classes with references to Oracle JDBC specific classes.
>>>> -----Original Message-----
>>>> From: Rochelle.Raccah_at_Sun.COM [mailto:Rochelle.Raccah_at_Sun.COM]On
>>>> Behalf
>>>> Of Rochelle Raccah
>>>> Sent: Tuesday, August 29, 2006 8:29 PM
>>>> To: persistence_at_glassfish.dev.java.net
>>>> Subject: how to map NVARCHAR2 columns
>>>>
>>>>
>>>> For background, please see
>>>> <http://www.netbeans.org/issues/show_bug.cgi?id=68997>.
>>>>
>>>> The question is, are NVARCHAR2 columns allowed in a schema? If so,
>>>> how
>>>> can they be mapped? And, do we have a way to generate the formOfUse
>>>> calls if necessary?
>>>>
>>>> Thanks,
>>>> Rochelle
>>
>>