Reports from RDMS and Jackrabbit

[Wayne Rasmuss <wa...@popstarnetworks.com>]

I have a product that uses Crystal Reports to generate reports from a JDBC
database. I would like to begin transitioning some of my data from JDBC to
JCR/Jackrabbit, but I can't figure out a good way to create reports from
both the sources. In fact, I don't see a path to connect Crystal Reports to
a JCR repository at all. Even if the particular repository (Jackrabbit)
supports SQL queries. So I have a couple questions.

1.) Does anybody have experience using crystal reports or another reporting
package with a JCR repository, particularly jackrabbit?

2.) Has anyone ever queried a JCR repository via JDBC?

3.) Can I make a JCR repository save the data in a database, then connect to
the database directly and expect the contents of the database to be
intelligible to create a report?

4.) Does anybody have ideas or experience about/with this kind of problem?

Thanks for your help,
Wayne

-- 
View this message in context: http://www.nabble.com/Reports-from-RDMS-and-Jackrabbit-tp18494253p18494253.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.

Re: Reports from RDMS and Jackrabbit

[Thomas Müller <th...@day.com>]

Hi,

I have created a wiki page for this:
http://wiki.apache.org/jackrabbit/QueryUsingJdbc

You will find an example application that runs a query against a
database using the JDBC API and the H2 Database. In the database, a
Jackrabbit session is created, and a XPath queries against Jackrabbit
is run. This describes a general way how to solve the problem, but
needs to be adapter to your needs.

Does this solve the problem?

Regards,
Thomas