Fatal Error: Java class not found using java_autoload()

Please go to the status report page (admin/reports/status). What are the values for "Apache POI", "PHP/Java Bridge extension", "PHP/Java Bridge include files" ?

In case the PHP/Java Bridge entries are fine but Apache POI isn't, please make sure the Sheetnode XLS settings (admin/settings/xls) is configured to point to a folder where you extracted the Apache POI 3.5-FINAL package. check the status report page again.

> The PHP/Java Bridge files a sym'd to my tomcat folder, but that shouldn't matter, should it?
Not that I know of, and besides the fact that the status report shows the POI version number (it does show it, doesn't it?) means that the module is able to call the POI jar file and get a reply.

What are you PHP/Java Extension settings (in php.ini)? Mine are:

extension = java.so
java.log_level = 3
java.log_file = /var/log/php-java-bridge.log
java.security_policy = Off

Please examine the error log above to see if anything's reported.

Debugging PHP/Java Bridge issues can be a pain. Thanks for your patience.

Please try the following code, outside of Drupal: http://php-java-bridge.sourceforge.net/pjb/examples/source.php?source=ex.... You will need to make POI available in some shared JAR folder on Tomcat. Does this code generate a file?

When this code works, please replace the line in sheetnode_xls.export.inc

$workbook = $type == 'xls' ? new org_apache_poi_hssf_usermodel_HSSFWorkbook() : new org_apache_poi_xssf_usermodel_XSSFWorkbook();

with

$workbook = $type == 'xls' ? new java("org.apache.poi.hssf.usermodel.HSSFWorkbook") : new java("org.apache.poi.xssf.usermodel.XSSFWorkbook");

Does this line still give you an error?

> The sample in Tomcat worked, I downloaded an excel file that looks exactly like the one on the JavaBridge examples page - is this correct?
Yes I wanted to make sure that the standard examples do work.

> When replace the code in sheetnode_xls.export.inc, I no longer get the error but nothing downloads - it's just a blank page - the URL is the node path assigned to the feed.
That's expected. I was trying to confirm the source of the problem, but it's not solved yet.

The PHP class "org_apache_poi_hssf_usermodel_HSSFWorkbook" is supposed to be auto-created by the bridge along with all other classes contained in the jars specified in java_autoload() - used in sheetnode_xls.export.inc line 7. That's the class that's not found, whereas the Java class itself, when accessed via java("org.apache.poi.hssf.usermodel.HSSFWorkbook"), is found.

To determine whether this is a missing setting in the Sheetnode module or something global to your PHP/Java Bridge installation, please try the following code, outside of Drupal:

<?php require_once("java/Java.inc");
java_autoload("<full path of each jar in POI folders separated by semicolon>");

header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=downloaded.xls");

// create a 50x40 excel sheet and return it to the client
$workbook = new org_apache_poi_hssf_usermodel_HSSFWorkbook();
$sheet = $workbook->createSheet("new sheet");

for($y=0; $y<40; $y++) {
  $row = $sheet->createRow($y);
  for($x=0; $x<50; $x++) {
    $cell = $row->createCell($x);
    $cell->setCellValue("cell $x/$y");
  }
}

// create and return the excel sheet to the client
$memoryStream = new java_io_ByteArrayOutputStream();
$workbook->write($memoryStream);
$memoryStream->close();
echo java_values($memoryStream->toByteArray());
?>

The only changes are the java_autoload() call and different class names. Are you able to run this?

Sorry, I should have been more explicit: the string "<full path of each jar in POI folders separated by semicolon>" in the code snippet needs to be replaced with something like:

"/var/www/d6/sites/all/modules/sheetnode/poi-3.5-FINAL/lib/commons-logging-1.1.jar;/var/www/d6/sites/all/modules/sheetnode/poi-3.5-FINAL/lib/junit-3.8.1.jar;/var/www/d6/sites/all/modules/sheetnode/poi-3.5-FINAL/lib/log4j-1.2.13.jar;/var/www/d6/sites/all/modules/sheetnode/poi-3.5-FINAL/ooxml-lib/ooxml-schemas-1.0.jar;/var/www/d6/sites/all/modules/sheetnode/poi-3.5-FINAL/ooxml-lib/dom4j-1.6.1.jar;/var/www/d6/sites/all/modules/sheetnode/poi-3.5-FINAL/ooxml-lib/xmlbeans-2.3.0.jar;/var/www/d6/sites/all/modules/sheetnode/poi-3.5-FINAL/ooxml-lib/geronimo-stax-api_1.0_spec-1.0.jar;/var/www/d6/sites/all/modules/sheetnode/poi-3.5-FINAL/poi-contrib-3.5-FINAL-20090928.jar;/var/www/d6/sites/all/modules/sheetnode/poi-3.5-FINAL/poi-scratchpad-3.5-FINAL-20090928.jar;/var/www/d6/sites/all/modules/sheetnode/poi-3.5-FINAL/poi-ooxml-3.5-FINAL-20090928.jar;/var/www/d6/sites/all/modules/sheetnode/poi-3.5-FINAL/poi-3.5-FINAL-20090928.jar"

which is the full path of *each* jar file inside the POI folder. Just replace the path here with your own.

Given a path, it checks if the file [path]/java/Java.inc exists. Was this running correctly on Tomcat 6?

Also, did you try my last suggestion on Tomcat 6 before switching to 5.5 ?

That is good news: your PHP/Java Bridge installation works well, and the bug is somewhere in Sheetnode ;-)

Can you please find the value of the Drupal variables called "sheetnode_xls_jar" and "sheetnode_xls_jar_path" ? You can find them in the database, table "variable", and search for records where field "name" LIKE "%sheetnode%".

The "sheetnode_xls_jar" variable should contain the same string that you entered manually to replace "<full path of each jar in POI folders separated by semicolon>". Are they the same?

I'm running out of ideas...

What is the error you now get? Anything in the PHP/Java Bridge log file or Drupal status report? Which POI version are you using?

If you'd like me to check your installation, I can do that.

It seems that java_autoload fails to find the Java class. Here are some more tests:

* What's your PHP version?

* In sheetnode_xls.export.inc, please replace

require_once("$JAVA_BASE/java/Java.inc");

with

require_once("java/Java.inc");

Any difference?

* Edit your java/Java.inc, function java_autoload_function5, by replacing:

if(!($client->invokeMethod(0, "typeExists", array($str)))) return false;

with

//if(!($client->invokeMethod(0, "typeExists", array($str)))) return false;

i.e., commenting it out. What happens now?

2 things are inconsistent still:

* The code require_once("java/Java.inc"); works in the non-Drupal examples above, but not in the Sheetnode module.

* The autoloaded class org_apache_poi_hssf_usermodel_HSSFWorkbook is found in the non-Drupal example, while it's not found in the Sheetnode module.

If we can resolve those inconsistencies we'll solve this problem :-)

> This question might be unrelated but - when creating the feed view it asks for a path - when I assign the path 'casetracker' I do not get an error, but I also don't get a xls file. If I assign a path of xls_export (one that doesn't already exist) I do get the error. Is this correct?

I would think so. If the path already exists then it's probably picking up the other definition and thus the XLS exporting code is never called.

The exception report you sent does not contain the class name. Specifically, the line

#0 /opt/tomcat/webapps/JavaBridge/java/Java.inc(128): java_ThrowExceptionProxyFactory->getProxy(28, 'org.apache.poi....', 'T', false)

should contain the class name, but it's shortened. Can you find the full version?

Also, you can send your modified file here for me to look at it. I might spot obvious defects.

Your translation of

org_apache_poi_hssf_usermodel_HSSFWorkbook

to

org.apache.poi.xssf.usermodel.HSSFWorkbook

is incorrect. Instead, you need to change

org_apache_poi_hssf_usermodel_HSSFWorkbook

to

java("org.apache.poi.xssf.usermodel.HSSFWorkbook")

Can I access your site and/or server to see for myself? I might find something obvious...

I meant all instances of such classes. I will send you a file within a few hours with the proper changes.

Attached is a version of sheetnode_xls.export.inc that I tested successfully. Please let me know if it works for you.

Try this one please :-)

Phew! I changed every Java class occurrence from the form x_y_z_ClassName (that relied on java_autoload() working correctly) to java('x.y.z.ClassName').

I don't want to close this issue though, because java_autoload *should* be working correctly. I will post a message on the PHP/Java Bridge mailing list to ask about cases where java_autoload might fail. Otherwise, all other Java-related files (XLS import, ODS export) would need the same treatment :-(

Thanks a lot for your patience with this issue.

I see you contacted PJB already! I just subscribed to this mailing list, so can you please reply to your own message so that I can join that thread (instead of starting a new one)?

To summarize the response made on the PJB mailing list: it seems you're using PJB 5.5.4 where they removed support for classes declared as x_y_z_ClassName. They will revert that change in the next release 5.5.4.1. I suggest that we resume this thread once this new version is released.

On my side, I will make sure that my module no longer depends on the presence of the java.so extension, or php.ini settings.

Subscribing.
Does the new version not rely on java.so or java_dll extension? PHP/Javabridge site points out that servlet model is better than using java.so or java_dll part.

@ranvir: I haven't yet updated the module to not depend on java.so/dll. I will make a new release once this is implemented and tested. In the meantime, you can modify the code in php_java_bridge.install, function php_java_bridge_requirements, by replacing the line

$extension = extension_loaded('java');

with

$extension = TRUE;

All remaining settings should be the same as described on the module page.

Hi All,

I'm the person that posted the thread on PJB. I listened to Peter's suggestion, which is what Kratrib has passed along here:

// $extension = extension_loaded('java');
$extension = TRUE;

This really helped, and I was able to install the php-java-bridge module and then the xls sheetnode module. Now, however, I'm running into some errors when trying to import an xls file:

"java.lang.Exception: Invoke failed: [[c:WorkbookFactory]]->create((o:InputStream)[o:FileInputStream]). Cause: java.lang.NoSuchMethodError: org.apache.poi.poifs.filesystem.POIFSFileSystem.hasPOIFSHeader(Ljava/io/InputStream;)Z VM: 1.6.0_16@http://java.sun.com/" at: #-10 org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:59)

I'm thinking that this may be related to this thread, so I tried this:

// $workbook = org_apache_poi_ss_usermodel_WorkbookFactory::type()->create($inp);

$WbClass = new java_class('org.apache.poi.ss.usermodel.WorkbookFactory');
$workbook = $WbClass->create($inp);

Didn't seem to make a difference... however I did not change how $inp was getting initialized (I don't see an error associated with it). Not sure how to pass in a param w/ single quotes using that syntax.

Also, it may be worth noting that I cannot get the php and jsp samples for PhpJavaBridge to work at the same time. I have an Apache-Tomcat connector, and when I enable this for JavaBridge, the jsp examples work, but the php examples do not. If I have it disabled, the php examples work, but jsp examples don't. Is that normal? Will the JavaBridge still function/function well enough for sheetnode to work? (Sorry if that's more of a PhpJavaBridge question)

Any help would be appreciated. Thanks!

@nsoules1, please open a separate issue because this seems to have nothing to do with the extension problem.

Kratib - ok, opened a new one.

The latest 1.5-beta3 version has removed the Java dependencies and replaced them with PHPExcel library. Please delete your sheetnode folder and install the latest version as per the instructions on the module page.