Jump to content
Changes to the Jaspersoft community edition download ×

jsp + jasper report + (mysql or oracle)


2005 IR Help

Recommended Posts

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

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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...