db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <nico.ups...@free.fr>
Subject Derby-style table function with java argument
Date Sat, 26 Apr 2008 07:25:22 GMT

 Hi,
 I would like to pass an argument to my java method such as a String
to point to a specific resultset to return.
 By example, my method is :
 public static ResultSet read(String resultSetIDToReturn){ ...}
 how do i have to change this example to make it works ? :
 CREATE FUNCTION externalEmployees
 ()
 RETURNS TABLE
 (
 employeeId INT,
 lastName VARCHAR( 50 ),
 firstName VARCHAR( 50 ),
 birthday DATE
 )
 LANGUAGE JAVA
 PARAMETER STYLE DERBY_JDBC_RESULT_SET
 NO SQL
 EXTERNAL NAME 'com.acme.hrSchema.EmployeeTable.read'
 Any help would be very appreciate,
 Nico
 
Mime
View raw message