United States Argentina Australia Austria Belgium Canada Chile Colombia Costa Rica Dominican Republic France Germany Bangladesh/India Italy Kenya Mexico Netherlands Puerto Rico South Africa Sweden Switzerland Venezuela
BASIS International Ltd.
Home | Site Map | Contact Us | Partner Login  

 













BASIS Knowledge Base Article #01127

Title:

How to generate a result set to be retuned by a Stored Procedure using direct access to data files instead of SQL

Description:

How to generate a result set to be retuned by a Stored Procedure using direct access to data files instead of SQL



Resolution:

This should be possible creating your own Java implementation of the java.sql.ResultSet interface. Consult the Java API documentation for information on the interface and what the methods need to do. Implement the java.sql.ResultSetMetaData interface, this information about the ResultSet that will be required

Once this is done, put your classes into a JAR and add the JAR to the BBj classpath. Perform calls on your class from your stored procedure code.



Last Modified: 01/02/2007
Product: BBj
Operating System: All platforms