|Re: JBOSS 4.2 + BIRT: common data source [message #264906 is a reply to message #264904]
||Tue, 22 January 2008 13:33
Registered: July 2009
Ahh, ok now i understand your problem.|
I use JBoss 4.0.2, so i dont really know, if it is the same with JBOSS
But here the JBOSS 4.0.2 solution:
In the deploy-directory of your jboss-server you got a *-ds.xml file,
where your datasources are defined. I got e.g. this datasource:
You have to use your jndi-name with the suffix "java:/".
In my example: java:/ds.ident.
The jdbc configuration is only needed for the birt-report-disigner
(BIRT-Eclipse-plugin). You cannt connect from your BIRT-Plugin to JNDI,
so you need the jdbc-configuration there.
The jdbc-configuration is only used, if the JNDI connection cant be found.
In my application i do this:
When someone uploads a report, the jdbc-configuration will be deleted
automatically. In my application another user could download the file
and "read" the jdbc configuration. I dont want that, so i delete them.
Its just a suggestion.
I hope this helps you.
Radek Żmuda schrieb:
> I have problems with data source - more precisely with connection do
> database, where data source IS NOT hardcoded into report <data-sources>
> part as JDBC conenction.
> In my situation, I would like to use JNDI connection because of
> integration of my BIRT report with JBOSS 4.3 GA.
> I have problem with setting up JNDI data source for birt report.
> Suppose I configure my data source in such a way, that my <data-sources>
> element looks like this:
> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
> <property name="odaDriverClass">org.postgresql.Driver</
> <property name="odaURL">jdbc:postgresql://220.127.116.11:5432/
> <property name="odaUser">myUser</property>
> <encrypted-property name="odaPassword"
> <property name="odaJndiName">java:comp/env/jdb/myConnection</
> It NOT work.
> My question is, how it should look like (maybe some examples) to be
> possible to connect by JNDI.
> How it works? Does jdbc configuration is needed? Why?
Powered by FUDForum
. Page generated in 0.03259 seconds