|
Re: JBOSS 4.2 + BIRT: common data source [message #264906 is a reply to message #264904] |
Tue, 22 January 2008 13:33 |
orkus9 Messages: 214 Registered: July 2009 |
Senior Member |
|
|
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
4.3. GA.
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:
<local-tx-datasource>
<jndi-name>ds.ident</jndi-name>
<connection-url>jdbc:postgresql://localhost/xt_head</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<user-name>username</user-name>
<password>password</password>
<transaction-isolation>TRANSACTION_SERIALIZABLE</transaction-isolation >
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>5</idle-timeout-minutes>
<track-statements>true</track-statements>
</local-tx-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.
Orkus9
Radek Żmuda schrieb:
> Hi,
>
> 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:
>
> <data-sources>
> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source"
> id="108">
> <property name="odaDriverClass">org.postgresql.Driver</
> property>
> <property name="odaURL">jdbc:postgresql://129.112.2.13:5432/
> myDb</property>
> <property name="odaUser">myUser</property>
> <encrypted-property name="odaPassword"
> encryptionID="base64">myPassword</encrypted-property>
> <property name="odaJndiName">java:comp/env/jdb/myConnection</
> property>
> </oda-data-source>
> </data-sources>
>
>
>
> 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?
>
>
> regards,
> Radek
|
|
|
Powered by
FUDForum. Page generated in 0.03287 seconds