jsp + jasper report + (mysql or oracle)

[2005 IR Help]

By: pjsebastian - pjsebastian

jsp + jasper report + (mysql or oracle)

2004-06-21 01:14

Sorry for my English

 

I try to show a report in a webapplication in which mysql or oracle is its database but I don´t know how I can do it

 

The example which comes with the jasper report I can see but now I want to use another database like (mysql or oracle) and I don´t know to change to show data of this databases

 

Anybody can I help me with details, please?

 

Thanks

 

 

 

 

By: GTI - gtigti

RE: jsp + jasper report + (mysql or oracle)

2004-06-21 02:31

use :

 

jasperPrint =

JasperFillManager.fillReport(

jasperReport,

parameters,

conn

);

 

while conn is your connection object

 

 

 

 

 

 

By: sunnf - sunnf

RE: jsp + jasper report + (mysql or oracle)

2004-06-21 21:54

//Change these settings according to your local configuration

String driver = "oracle.jdbc.driver.OracleDriver";

String connectString = "jdbc:oracle:thin:@192.168.110.192:1521:test";

String user = "codb1";

String password = "codb1";

 

Class.forName(driver);

Connection conn = DriverManager.getConnection(connectString, user, password);

 

copy ojdbc14.jar to your lib