Hinting for datatype in Modeler?

[John Armstrong <si...@gmail.com>]

Hi everyone,
  My database (Firebird) does not support boolean types. Cayenne helps
me with this by letting me use a char(1) to emulate booleans. Thanks!

  The problem I have is that I am doing a lot of back and forth in my
database design and I treat the database as authoritative rather then
using the modeler for all activities and just reverse engineer the db
into the modeler. This means that every time I regen the model this
way I have to manually set 50+ fields from java.lang.String to boolean
types.

Anyone have a tip for getting around this?

John-

Re: Hinting for datatype in Modeler?

[John Armstrong <si...@gmail.com>]

Thanks Tore, a few hours after I sent this I stumbled across the
Migrate feature.

This feature is amazing and works very well with Firebird for which I
use the generic JDBC implementation

Thanks everyone, cayenne continues to amaze. I have it working nicely
with Wicket now as I migrate away from Struts, very very nice (it just
'works'!)

John-

On Tue, Dec 30, 2008 at 1:13 AM, Tore Halset <ha...@pvv.ntnu.no> wrote:
> Hello.
>
> The new merge functionality in the modeler was created to handle this.
> Firebird is not supported, but please try it out and report any problem.
>
>  - Tore.
>
> On Dec 29, 2008, at 23:07, "John Armstrong" <si...@gmail.com> wrote:
>
>> Hi everyone,
>>  My database (Firebird) does not support boolean types. Cayenne helps
>> me with this by letting me use a char(1) to emulate booleans. Thanks!
>>
>>  The problem I have is that I am doing a lot of back and forth in my
>> database design and I treat the database as authoritative rather then
>> using the modeler for all activities and just reverse engineer the db
>> into the modeler. This means that every time I regen the model this
>> way I have to manually set 50+ fields from java.lang.String to boolean
>> types.
>>
>> Anyone have a tip for getting around this?
>>
>> John-
>>
>

Re: Hinting for datatype in Modeler?

[Tore Halset <ha...@pvv.ntnu.no>]

Hello.

The new merge functionality in the modeler was created to handle this.  
Firebird is not supported, but please try it out and report any problem.

  - Tore.

On Dec 29, 2008, at 23:07, "John Armstrong" <si...@gmail.com> wrote:

> Hi everyone,
>  My database (Firebird) does not support boolean types. Cayenne helps
> me with this by letting me use a char(1) to emulate booleans. Thanks!
>
>  The problem I have is that I am doing a lot of back and forth in my
> database design and I treat the database as authoritative rather then
> using the modeler for all activities and just reverse engineer the db
> into the modeler. This means that every time I regen the model this
> way I have to manually set 50+ fields from java.lang.String to boolean
> types.
>
> Anyone have a tip for getting around this?
>
> John-
>