birt report extracting data from oracle

[adir]

actually what i did was  a simple report which its data source is oracle with simple data set query.

if i press review in eclipse i see all datd i was expecting, but if i take it to

..\autodeploy\birt.war\report

within my glassfish, i get it to run but not showing the data.

any advices?

tnx

hi adir,


can you please say the procedure to connect to an oracle database.

which jdbc driver i have to use?

the syntax for 'Driver url'?

please help me out in this. im trying to connect to an oracle database

[adir]

1.new datasource ->jdbc datasource ->next
   1.1 jdbc driver class:  oracle.jdbc.OracleDriver
   1.2 jdbc driver url:  jdbc:oracle:thin:@<your ip>:1521:<service name>
   1.3 set  password and user name like in your oracle
2.create new dataset
   2.1 direct datasource combo box to datasource you config for oracle in bullet 1 ->next

This is the configuration section, next you can drag and drop any of the tables you got over the report.

is it clear?

karteek@lgs wrote:

hi adir,


can you please say the procedure to connect to an oracle database.

which jdbc driver i have to use?

the syntax for 'Driver url'?

please help me out in this. im trying to connect to an oracle database

hi adir,

          first of all thnks for your quick reply.
the procedure is very clear.

but in order to get that jdbc driver in the drop down we have to add the jdbc driver by clicking 'Manage drivers' button.

My question is which drivers i have to add there?
From where i can download those drivers?

im using oracle9i  and jave 1.5 for Eclipse BIRT.  i cant able to find the drivers which are compatible for the above requirement



1.new datasource ->jdbc datasource ->next
   1.1 jdbc driver class:  oracle.jdbc.OracleDriver
   1.2 jdbc driver url:  jdbc:oracle:thin:@<your ip>:1521:<service name>
   1.3 set  password and user name like in your oracle
2.create new dataset
   2.1 direct datasource combo box to datasource you config for oracle in bullet 1 ->next

This is the configuration section, next you can drag and drop any of the tables you got over the report.

is it clear?

karteek@lgs wrote:

hi adir,


can you please say the procedure to connect to an oracle database.

which jdbc driver i have to use?

the syntax for 'Driver url'?

please help me out in this. im trying to connect to an oracle database

[adir]

I am using a different configuration:

driver: ojdbc14.jar-10.2.jar   and jdk 1.6 , although it works also with jdk1.5

try oracle web site for the proper driver.

Adi


hi adir,

          first of all thnks for your quick reply.
the procedure is very clear.

but in order to get that jdbc driver in the drop down we have to add the jdbc driver by clicking 'Manage drivers' button.

My question is which drivers i have to add there?
From where i can download those drivers?

im using oracle9i  and jave 1.5 for Eclipse BIRT.  i cant able to find the drivers which are compatible for the above requirement

adir wrote:

1.new datasource ->jdbc datasource ->next
   1.1 jdbc driver class:  oracle.jdbc.OracleDriver
   1.2 jdbc driver url:  jdbc:oracle:thin:@<your ip>:1521:<service name>
   1.3 set  password and user name like in your oracle
2.create new dataset
   2.1 direct datasource combo box to datasource you config for oracle in bullet 1 ->next

This is the configuration section, next you can drag and drop any of the tables you got over the report.

is it clear?

karteek@lgs wrote:

hi adir,


can you please say the procedure to connect to an oracle database.

which jdbc driver i have to use?

the syntax for 'Driver url'?

please help me out in this. im trying to connect to an oracle database