padacek Posted November 10, 2009 Share Posted November 10, 2009 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 More sharing options...
aalmero Posted November 11, 2009 Share Posted November 11, 2009 you might want to try to configure ur datasource first in ur server.1. copy ojdbc14.jar \jasperserver-3.5.0\apache-tomcat\common\lib2. 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now