[eluser]Unknown[/eluser]
[quote author="mmax" date="1278366007"]Hi,
I'm new to codeigniter and need to generate Jasperreports within the CI Framework. To access Java from PHP i installed php-java-bridge which ich working from a pure php site. But i can't generate reports from CI.
This is how my controller function looks like:
Code:
public function submit() {
if( $this->checkJavaExtension() ) {
// Java Extension loaded
try {
// Load Mysql driver and connect to database
java("java.lang.Class")->forName("com.mysql.jdbc.Driver");
$driverManager = new JavaClass("java.sql.DriverManager");
$dbConnection = $driverManager->getConnection("jdbc:mysql://HOST/DATABASE","USER","PASSWORD");
try {
$inputFile = "path/to/file.jrxml";
$outputFile = "path/to/file.pdf";
// Open jasper report
$compileManager = new JavaClass("net.sf.jasperreports.engine.JasperCompileManager");
$report = $compileManager->compileReport($inputFile);
// Set report parameters
$params = new Java("java.util.HashMap");
// Fill report
$fillManager = new JavaClass("net.sf.jasperreports.engine.JasperFillManager");
$jasperPrint = $fillManager->fillReport($report, $params, $dbConnection);
// Export report to PDF
$exportManager = new JavaClass("net.sf.jasperreports.engine.JasperExportManager");
$exportManager->exportReportToPdfFile($jasperPrint, $outputFile);
echo "Report generated";
} catch(JavaException $ex) {
// ERROR generating Report
echo "ERROR generating Report: ".$ex->getCause();
}
} catch(JavaException $ex) {
// ERROR connecting to Database
echo "ERROR connecting to Database: ".$ex->getCause();
}
} else {
// ERROR loading Java Extension
echo "ERROR loading Java Extension";
}
}
}
But the the page keeps blank and i don't get any errors in th apache/tomcat logfile. If i run this code in a simple php script, it works's. I also tried to put the code into a library but it's still the same problem. Btw ... the function checkJavaExtension() returns true. Any Ideas?
Thanks,
Max[/quote]
hello mmax, according what you mention above, i would ask about how to integrate CI with PHP/Java Bridge.Last day i've try that but i still got no result...
could you help me...
sorry for my bad english
regards,
pinkpanther