Subject Re: Toplink, JPA and Firebird
Author mspencewasunavailable
--- In Firebird-Java@yahoogroups.com, "mspencewasunavailable"
<firebird@...> wrote:
>
> I'm trying to use Toplink and JPA (NetBeans 6) to access a
firebird
> database. As it happens, this database was ported from BDE, and
many
> of my tables have column names that have to be quoted.
>
> Toplink seems to have trouble dealing with this. Has anyone
gotten
> JPA to work with Firebird and delimited identifiers using Toplink
(or
> for that matter, any other perisistence provider)?
>

D'oh! The answer turned out to be pretty obvious: Delimit the
fields:

Instead of @Column(name = "Last Name", nullable = false)

use @Column(name = "\"Last Name\"", nullable = false)

Sorry for the noise.

Michael D. Spence
Mockingbird Data Systems, Inc.