JasperSever Connection to Oracle

[ssr1251983]

Dear Team

I am new user to Jasper server trying to evaluate this for the research work. I would lilke to know if any one can help me to connect the jasper server to oracle database.

I have oracle 9i client installed in my desktop. the input is asking for Driver and URL details. By default, it is showing for MYSQL. Where can i get these details for oracle. This sounds to be very simple question, but i am a entry level programer and this information will be handy to me

 

Thanks & Regards

Sreekanth Reddy

[ibrahimhamza]

 

Dear ssr1251983

If you want to make reports for oracle using the default installation

you should have jdbc  for oracle database

from choose your database

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

download the jar file and put it into

apache-tomcatcommonlib

make new datasource

then choose Data Source Type as  JDBC Data Source

Driver oracle.jdbc.driver.OracleDriver

URL jdbc:oracle:thin:@localhost:1521:xe

Use ireport to make reports and upload it to server

[ssr1251983]

Hi

Thanks for the help...

Still i am getting the error as test connection failed.

I gave the URL   as  jdbc:oracle:thin:@localhost:1521:databasename

where databasename is my database

...As per my readings, is that i need to change the context file and other details to make the connection of jasper to oracle.

 

Here is th broader outline of my problem

I have a oracle server and have oracle client installed in my desktop. I need to use jasper to generate simple two dimensional report

 

Thanks

Sreekanth

[ibrahimhamza]

Dear Sreekanth

Could you give more details?

exception if found

can you connect to the server using ireport or not ?

[anandharaj]

ssr1251983, if you JasperServer metadata database is Oracle, then you need to edit the META-INF/Context.xml file

[ibrahimhamza]

Dear ssr1251983

if you want to install jasperserver in  oracle

follow the steps in

http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=54994

if you wish only to make new report that make connection to oracle

make sure to put the oracle jdbc driver and make the right connection string

[baggypants]

ssr1251983
Wrote:

Hi Thanks for the help... Still i am getting the error as test connection failed. I gave the URL   as  jdbc:oracle:thin:@localhost:1521:databasename where databasename is my database ...As per my readings, is that i need to change the context file and other details to make the connection of jasper to oracle.   Here is th broader outline of my problem I have a oracle server and have oracle client installed in my desktop. I need to use jasper to generate simple two dimensional report   Thanks Sreekanth

I have this setup and the info looks ok for me, although I'm using 10g. check you're using ojdbc14.jar.for the driver. Also check the database name, you can find this in tnsnames.ora, its not necessarily the same as the tablespace name and is generally ORCL in my experience.

 

Post Edited by Leon Robinson at 04/10/09 18:48

[b09715]

Hi,

>> I gave the URL   as  jdbc:oracle:thin:@localhost:1521:databasename

I think you are trying to connect to a remote DB.. so your URL should be

jdbc:oracle:thin:@<host>:<dbport>:databasename

Thanks,
Sathish

 

[yaya99]

reports work OK  with Ireport with oracle database JDBC connection

but    with jasperserver  problem  connecting to same oracle database

[yaya99]

how come the connection to my oracle database is OK with iReport   but not with jasperserver (REPORTS) ??

please Help me

 

 

[gtipton]

These instructions are out o date, there is no common folder in the apache-tomcat jasper installation.

[mr.biswas]

Hi,

 I gave the URL   as  jdbc:oracle:thin:@localhost:1521:databasename

I think you are trying to connect to a remote DB.. so your URL should be

jdbc:oracle:thin:@<host>:<dbport>:databasename [where host should be like 192.168....]

Thanks,
Jeet