You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cayenne.apache.org by Lawrence Gerstley <la...@gmail.com> on 2008/11/25 02:02:06 UTC
Using Cayenne with RCP and Birt?
Hello,
I've been using Cayenne with great success in making a variety of RCP
applications. I'm trying to integrate in BIRT to these applications
now, and want to do so without separately specifying JDBC mappings
just for BIRT. Has anyone integrated the two together? Especially
inside of RCP, but outside would work as well. Any snippets would be
greatly appreciated.
Many Thanks,
Lawrence
Re: Using Cayenne with RCP and Birt?
Posted by Lawrence Gerstley <la...@gmail.com>.
I've already launched into learning about ODAs for my app, so I'll
definitely keep in touch and contribute back if all goes well. I've
been pushing Cayenne hard and resisting the "it must use Hibernate"
mandate from a couple of companies that I'm working with, and frankly
I think that integrating the BIRT framework into their RCP
applications so they get canned reports AND the ability to compose
their own custom reporting will just amaze.
Kind regards,
Lawrence
==================================
Lawrence Gerstley, Ph.D.
On Nov 26, 2008, at 3:37 AM, Laurent Marchal wrote:
> If you write an ODA driver to integrate Cayenne with BIRT, It would
> be a really nice contribution ! I am really interrested in this, so
> keep us in touch if you do something !
>
> Cheers.
> Laurent
>
> Lawrence Gerstley wrote:
>> Hello,
>>
>> I definitely agree that BIRT+JDBC is nice and simple, and it's
>> really a joy to get started with. The problem is one of
>> generalization: I've spent all of this time using Cayenne to
>> abstract from the physical database, and I only want to do that
>> once. My application can now smoothly move between Oracle, MySQL,
>> and Apache Derby, and Cayenne has work better than I expected to
>> accomplish this. Now, I want to leverage that work so that my
>> reporting can be platform independent as well. Of course, the JDBC
>> connection could be configurable as well, but that's much more
>> opportunity for something to go wrong. The Hibernate example may
>> take me a long way in understanding what to do--thanks for the link!
>>
>> Lawrence
>>
>>
>> On Nov 25, 2008, at 2:03 AM, Laurent Marchal wrote:
>>
>>> Hello,
>>>
>>> I am sucessfully using cayenne in a big eclipse RCP application
>>> (25 plugins), we use BIRT chart library to programmatically create
>>> dynamic charts, and we are also integrating some BIRT reports into
>>> the RCP.
>>>
>>> I don't know exaclty what you want to do, but BIRT can't use
>>> Cayenne directly (you will have to develop an ODA driver to bridge
>>> the two), it's possible but i don't see the utility, BIRT + JDBC
>>> is pretty nice and simple.
>>>
>>> You can see an example of BIRT using hibernate as data source
>>> here : http://docs.jboss.org/tools/whatsnew/birt/birt-news-1.0.0.Alpha1.html
>>> https://jira.jboss.org/jira/browse/JBIDE-2220
>>>
>>> Cheers.
>>>
>>> Laurent Marchal
>>>
>>> Andrus Adamchik wrote:
>>>> Hi Lawrence,
>>>>
>>>> Don't recall BIRT being mentioned on this list. You could be the
>>>> first one to try it (?)
>>>>
>>>> Andrus
>>>>
>>>>
>>>> On Nov 25, 2008, at 3:02 AM, Lawrence Gerstley wrote:
>>>>> Hello,
>>>>>
>>>>> I've been using Cayenne with great success in making a variety
>>>>> of RCP applications. I'm trying to integrate in BIRT to these
>>>>> applications now, and want to do so without separately
>>>>> specifying JDBC mappings just for BIRT. Has anyone integrated
>>>>> the two together? Especially inside of RCP, but outside would
>>>>> work as well. Any snippets would be greatly appreciated.
>>>>>
>>>>> Many Thanks,
>>>>>
>>>>> Lawrence
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>
Re: Using Cayenne with RCP and Birt?
Posted by Laurent Marchal <co...@genux.fr>.
If you write an ODA driver to integrate Cayenne with BIRT, It would be a
really nice contribution ! I am really interrested in this, so keep us
in touch if you do something !
Cheers.
Laurent
Lawrence Gerstley wrote:
> Hello,
>
> I definitely agree that BIRT+JDBC is nice and simple, and it's really
> a joy to get started with. The problem is one of generalization: I've
> spent all of this time using Cayenne to abstract from the physical
> database, and I only want to do that once. My application can now
> smoothly move between Oracle, MySQL, and Apache Derby, and Cayenne has
> work better than I expected to accomplish this. Now, I want to
> leverage that work so that my reporting can be platform independent as
> well. Of course, the JDBC connection could be configurable as well,
> but that's much more opportunity for something to go wrong. The
> Hibernate example may take me a long way in understanding what to
> do--thanks for the link!
>
> Lawrence
>
>
> On Nov 25, 2008, at 2:03 AM, Laurent Marchal wrote:
>
>> Hello,
>>
>> I am sucessfully using cayenne in a big eclipse RCP application (25
>> plugins), we use BIRT chart library to programmatically create
>> dynamic charts, and we are also integrating some BIRT reports into
>> the RCP.
>>
>> I don't know exaclty what you want to do, but BIRT can't use Cayenne
>> directly (you will have to develop an ODA driver to bridge the two),
>> it's possible but i don't see the utility, BIRT + JDBC is pretty nice
>> and simple.
>>
>> You can see an example of BIRT using hibernate as data source here :
>> http://docs.jboss.org/tools/whatsnew/birt/birt-news-1.0.0.Alpha1.html
>> https://jira.jboss.org/jira/browse/JBIDE-2220
>>
>> Cheers.
>>
>> Laurent Marchal
>>
>> Andrus Adamchik wrote:
>>> Hi Lawrence,
>>>
>>> Don't recall BIRT being mentioned on this list. You could be the
>>> first one to try it (?)
>>>
>>> Andrus
>>>
>>>
>>> On Nov 25, 2008, at 3:02 AM, Lawrence Gerstley wrote:
>>>> Hello,
>>>>
>>>> I've been using Cayenne with great success in making a variety of
>>>> RCP applications. I'm trying to integrate in BIRT to these
>>>> applications now, and want to do so without separately specifying
>>>> JDBC mappings just for BIRT. Has anyone integrated the two
>>>> together? Especially inside of RCP, but outside would work as well.
>>>> Any snippets would be greatly appreciated.
>>>>
>>>> Many Thanks,
>>>>
>>>> Lawrence
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>
RE: Using Cayenne with RCP and Birt?
Posted by Scott Anderson <sa...@airvana.com>.
You should be able to, theoretically, use a scripted data source to pull
in data through your CDOs. It really does seem pointless though, since
you're just doing SELECT queries, and those are pretty standard. I think
it would be more work to write the scripted data sources than to just
write a canned SELECT query - not to mention that BIRT already uses a
ton of RAM before bringing Cayenne in to the picture.
-----Original Message-----
From: Lawrence Gerstley [mailto:lawgers@gmail.com]
Sent: Tuesday, November 25, 2008 11:28 AM
To: user@cayenne.apache.org
Subject: Re: Using Cayenne with RCP and Birt?
Hello,
I definitely agree that BIRT+JDBC is nice and simple, and it's really
a joy to get started with. The problem is one of generalization: I've
spent all of this time using Cayenne to abstract from the physical
database, and I only want to do that once. My application can now
smoothly move between Oracle, MySQL, and Apache Derby, and Cayenne has
work better than I expected to accomplish this. Now, I want to
leverage that work so that my reporting can be platform independent as
well. Of course, the JDBC connection could be configurable as well,
but that's much more opportunity for something to go wrong. The
Hibernate example may take me a long way in understanding what to do--
thanks for the link!
Lawrence
On Nov 25, 2008, at 2:03 AM, Laurent Marchal wrote:
> Hello,
>
> I am sucessfully using cayenne in a big eclipse RCP application
> (25 plugins), we use BIRT chart library to programmatically create
> dynamic charts, and we are also integrating some BIRT reports into
> the RCP.
>
> I don't know exaclty what you want to do, but BIRT can't use Cayenne
> directly (you will have to develop an ODA driver to bridge the two),
> it's possible but i don't see the utility, BIRT + JDBC is pretty
> nice and simple.
>
> You can see an example of BIRT using hibernate as data source here :
http://docs.jboss.org/tools/whatsnew/birt/birt-news-1.0.0.Alpha1.html
> https://jira.jboss.org/jira/browse/JBIDE-2220
>
> Cheers.
>
> Laurent Marchal
>
> Andrus Adamchik wrote:
>> Hi Lawrence,
>>
>> Don't recall BIRT being mentioned on this list. You could be the
>> first one to try it (?)
>>
>> Andrus
>>
>>
>> On Nov 25, 2008, at 3:02 AM, Lawrence Gerstley wrote:
>>> Hello,
>>>
>>> I've been using Cayenne with great success in making a variety of
>>> RCP applications. I'm trying to integrate in BIRT to these
>>> applications now, and want to do so without separately specifying
>>> JDBC mappings just for BIRT. Has anyone integrated the two
>>> together? Especially inside of RCP, but outside would work as
>>> well. Any snippets would be greatly appreciated.
>>>
>>> Many Thanks,
>>>
>>> Lawrence
>>>
>>>
>>>
>>>
>>>
>>
Re: Using Cayenne with RCP and Birt?
Posted by Lawrence Gerstley <la...@gmail.com>.
Hello,
I definitely agree that BIRT+JDBC is nice and simple, and it's really
a joy to get started with. The problem is one of generalization: I've
spent all of this time using Cayenne to abstract from the physical
database, and I only want to do that once. My application can now
smoothly move between Oracle, MySQL, and Apache Derby, and Cayenne has
work better than I expected to accomplish this. Now, I want to
leverage that work so that my reporting can be platform independent as
well. Of course, the JDBC connection could be configurable as well,
but that's much more opportunity for something to go wrong. The
Hibernate example may take me a long way in understanding what to do--
thanks for the link!
Lawrence
On Nov 25, 2008, at 2:03 AM, Laurent Marchal wrote:
> Hello,
>
> I am sucessfully using cayenne in a big eclipse RCP application
> (25 plugins), we use BIRT chart library to programmatically create
> dynamic charts, and we are also integrating some BIRT reports into
> the RCP.
>
> I don't know exaclty what you want to do, but BIRT can't use Cayenne
> directly (you will have to develop an ODA driver to bridge the two),
> it's possible but i don't see the utility, BIRT + JDBC is pretty
> nice and simple.
>
> You can see an example of BIRT using hibernate as data source here : http://docs.jboss.org/tools/whatsnew/birt/birt-news-1.0.0.Alpha1.html
> https://jira.jboss.org/jira/browse/JBIDE-2220
>
> Cheers.
>
> Laurent Marchal
>
> Andrus Adamchik wrote:
>> Hi Lawrence,
>>
>> Don't recall BIRT being mentioned on this list. You could be the
>> first one to try it (?)
>>
>> Andrus
>>
>>
>> On Nov 25, 2008, at 3:02 AM, Lawrence Gerstley wrote:
>>> Hello,
>>>
>>> I've been using Cayenne with great success in making a variety of
>>> RCP applications. I'm trying to integrate in BIRT to these
>>> applications now, and want to do so without separately specifying
>>> JDBC mappings just for BIRT. Has anyone integrated the two
>>> together? Especially inside of RCP, but outside would work as
>>> well. Any snippets would be greatly appreciated.
>>>
>>> Many Thanks,
>>>
>>> Lawrence
>>>
>>>
>>>
>>>
>>>
>>
Re: Using Cayenne with RCP and Birt?
Posted by Laurent Marchal <co...@genux.fr>.
Hello,
I am sucessfully using cayenne in a big eclipse RCP application (25
plugins), we use BIRT chart library to programmatically create dynamic
charts, and we are also integrating some BIRT reports into the RCP.
I don't know exaclty what you want to do, but BIRT can't use Cayenne
directly (you will have to develop an ODA driver to bridge the two),
it's possible but i don't see the utility, BIRT + JDBC is pretty nice
and simple.
You can see an example of BIRT using hibernate as data source here :
http://docs.jboss.org/tools/whatsnew/birt/birt-news-1.0.0.Alpha1.html
https://jira.jboss.org/jira/browse/JBIDE-2220
Cheers.
Laurent Marchal
Andrus Adamchik wrote:
> Hi Lawrence,
>
> Don't recall BIRT being mentioned on this list. You could be the first
> one to try it (?)
>
> Andrus
>
>
> On Nov 25, 2008, at 3:02 AM, Lawrence Gerstley wrote:
>> Hello,
>>
>> I've been using Cayenne with great success in making a variety of RCP
>> applications. I'm trying to integrate in BIRT to these applications
>> now, and want to do so without separately specifying JDBC mappings
>> just for BIRT. Has anyone integrated the two together? Especially
>> inside of RCP, but outside would work as well. Any snippets would be
>> greatly appreciated.
>>
>> Many Thanks,
>>
>> Lawrence
>>
>>
>>
>>
>>
>
Re: Using Cayenne with RCP and Birt?
Posted by Lawrence Gerstley <la...@gmail.com>.
Well, I'll report back when I get it working. Theoretically, this
should work fine, so I'm sure it's just a matter of time and trials.
Lawrence
On Nov 25, 2008, at 12:29 AM, Andrus Adamchik wrote:
> Hi Lawrence,
>
> Don't recall BIRT being mentioned on this list. You could be the
> first one to try it (?)
>
> Andrus
>
>
> On Nov 25, 2008, at 3:02 AM, Lawrence Gerstley wrote:
>> Hello,
>>
>> I've been using Cayenne with great success in making a variety of
>> RCP applications. I'm trying to integrate in BIRT to these
>> applications now, and want to do so without separately specifying
>> JDBC mappings just for BIRT. Has anyone integrated the two
>> together? Especially inside of RCP, but outside would work as well.
>> Any snippets would be greatly appreciated.
>>
>> Many Thanks,
>>
>> Lawrence
>>
>>
>>
>>
>>
>
Re: Using Cayenne with RCP and Birt?
Posted by Andrus Adamchik <an...@objectstyle.org>.
Hi Lawrence,
Don't recall BIRT being mentioned on this list. You could be the first
one to try it (?)
Andrus
On Nov 25, 2008, at 3:02 AM, Lawrence Gerstley wrote:
> Hello,
>
> I've been using Cayenne with great success in making a variety of
> RCP applications. I'm trying to integrate in BIRT to these
> applications now, and want to do so without separately specifying
> JDBC mappings just for BIRT. Has anyone integrated the two together?
> Especially inside of RCP, but outside would work as well. Any
> snippets would be greatly appreciated.
>
> Many Thanks,
>
> Lawrence
>
>
>
>
>