Main Menu

KB#01127-How to generate a result set to be retuned by a Stored Procedure

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

BASIS structures five components of their technology into the BBx Generations.

  Google+ View BASIS LinkedIN Profile Visit our Twitter Feed Check out our Facebook Public Profile Click to View the BASIS youTube channel