Jump to content
Changes to the Jaspersoft community edition download ×

JDBC Data Source – How to set parameters in URL


padacek

Recommended Posts

Hello all,

I am running an installation of JasperServer 3.0 and using Oracle 10g as a JDBC Datasource target.

I need to set up one parameter in connection URL but it seems there is no input field nor possible to write it directly into JDBC URL – connection fails then.

Is there any way to do such setup?

Thanky you in advance for any suggestion. 



Post Edited by padacek at 11/10/2009 16:46
Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

you might want to try to configure ur datasource first in ur server.

1. copy ojdbc14.jar \jasperserver-3.5.0\apache-tomcat\common\lib

2. edit context.xml in \jasperserver-3.5.0\apache-tomcat\webapps\jasperserver\META-INF and add oracle config with the additional parameter on the <url>

    <Resource name="jdbc/oracleDS" auth="Container"
              type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"
              url="jdbc:oracle:thin:@127.0.0.1:1521:xe"
              username="wtf" password="wtf" maxActive="20" maxIdle="10"
              maxWait="-1"/>

3. edit web.xml in \jasperserver-3.5.0\apache-tomcat\webapps\jasperserver\WEB-INF and add config below

<resource-ref>
     <description>Oracle Datasource example</description>
     <res-ref-name>jdbc/oracleDS</res-ref-name>
     <res-type>javax.sql.DataSource</res-type>
     <res-auth>Container</res-auth>
    </resource-ref>

4. configure a new jndi in the jasper server data source page.

select "jndi"

specify the name....

specify "jdbc/oracleDS"

5. now you can reference this datasource in ur reports.

hth

 

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...