Multi-language database and JPA/OpenJPA

[Simone Gianni <si...@apache.org>]

Hi all,
the problem of having a database containing localized data is quite 
common, and a number of ways to do it are used here and there on the 
internet.

What is, from your experience or from your knowledge of JPA, the best 
way of doing it in JPA? Are there any recommendation or study papers on 
this? (Google seems to find nothing unseful).

Does the JPA 2.0 specs adds some useful new features for this problem?

Thanks in advance,
Simone

-- 
Simone Gianni            CEO Semeru s.r.l.           Apache Committer
http://www.simonegianni.it/

Re: Multi-language database and JPA/OpenJPA

[Kevin Sutter <kw...@gmail.com>]

Adam's observations seem in synch with mine.  Although I don't have personal
experience with storing localized data, I have exchanged e-mails with a few
people who have attempted it with the OpenJPA Entity Listeners.  No
"reference accounts" per se, but it does seem doable.

Kevin

On Mon, Feb 2, 2009 at 8:19 AM, Adam Hardy <ad...@cyberspaceroad.com>wrote:

> Simone Gianni on 01/02/09 22:11, wrote:
>
>> Hi all,
>> the problem of having a database containing localized data is quite
>> common, and a number of ways to do it are used here and there on the
>> internet.
>>
>> What is, from your experience or from your knowledge of JPA, the best way
>> of doing it in JPA? Are there any recommendation or study papers on this?
>> (Google seems to find nothing unseful).
>>
>> Does the JPA 2.0 specs adds some useful new features for this problem?
>>
>
> One project which I worked on in the past which was pre-JPA had this
> requirement.
>
> The language strings were heavily cached and not mapped as part of any
> entity bean, rather added to the bean post-select by a listener.
>
> It worked well.
>
> Regards
> Adam
>
>

Re: Multi-language database and JPA/OpenJPA

[Adam Hardy <ad...@cyberspaceroad.com>]

Simone Gianni on 01/02/09 22:11, wrote:
> Hi all,
> the problem of having a database containing localized data is quite 
> common, and a number of ways to do it are used here and there on the 
> internet.
> 
> What is, from your experience or from your knowledge of JPA, the best 
> way of doing it in JPA? Are there any recommendation or study papers on 
> this? (Google seems to find nothing unseful).
> 
> Does the JPA 2.0 specs adds some useful new features for this problem?

One project which I worked on in the past which was pre-JPA had this requirement.

The language strings were heavily cached and not mapped as part of any entity 
bean, rather added to the bean post-select by a listener.

It worked well.

Regards
Adam