php-java-bridge-users

Re: [Php-java-bridge-users] Abstract classes

[Jost B. <jos...@ya...>]

Hi,

I get a "class not found" in 1.0.6 when I try to
access the write.Workbook.  Since we want to write a
workbook we need write.WriteableWorkbook.

I don't know why you get a null pointer instead of a
"class not found" exception. Which version of the
bridge and which version of jxl.jar do you use?

I have tested with 1.0.6a and the jxl and code below:

<?php
java_set_library_path("http://www.jspwiki.org/attach?page=ExcelToHTMLPlugin%2Fjxl.jar");

$fname1 = tempnam("/tmp", "demo.xls");
$file =  new java("java.io.File", $fname1);
$wbClass=new java("jxl.write.WritableWorkbook");
$workbook=$wbClass->createWorkbook($file);

?>

That worked as well as reading a workbook:

$file =  new java("java.io.File", "test.xls");
$wbClass=new java("jxl.Workbook");
$wbClass->getWorkbook($file);
...
$row=$sheet->getRow(1);
$stringClass = new java("java.lang.String");
foreach ($row as $key => $value) {
  print $key . " -> ";
  print $stringClass->ValueOf($value) . "\n";
}


Jost





	

	
		
___________________________________________________________
Gesendet von Yahoo! Mail - Jetzt mit 100MB Speicher kostenlos - Hier anmelden: http://mail.yahoo.de

Re: [Php-java-bridge-users] Abstract classes

[Jost B. <jos...@ya...>]

My fault, sorry.  The jxl documentation states that the createWorkbook()
method is in jxl.Workbook, not in jxl.write.Workbook or
jxl.write.WritableWorkbook which I have inferred from its name.

Attached is a testjxl.php which will work.


Regarding the null pointer exception, please read that as a "class not
found exception".  It's actually a bug in the bridge 1.0.6a private
classloader which is trying to access a null java_library_path.  I will
change that null pointer to a proper "class not found exception" in the
upcoming version 1.0.7.  Thank you for reporting this problem.  Here's
the relevant log from /var/log/php-java-bridge.log:

try to load class jxl.write.WritableWorkbook from
jar:file:/usr/share/java/jdom.jar!/
java.lang.NullPointerException
        at JavaBridge$1.findClass(JavaBridge.java:123)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:562)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:494)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:256)
        at JavaBridge.CreateObject(JavaBridge.java:356)
        at JavaBridge.handleRequests(Native Method)
        at JavaBridge.run(JavaBridge.java:158)
        at java.lang.Thread.run(Thread.java:568)


BTW: The new PHP 5 engine allows introspection, so when the bridge
supports PHP 5, it will be possible to look inside a class and to
interactively pick a certain method or property of a class.


Jost