Login or Register to Ask a Question and Join Our Community


Software Releases - RSS News

SPWrapper 0.9 (Default branch)

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Special Forums News, Links, Events and Announcements Software Releases - RSS News SPWrapper 0.9 (Default branch)
# 1  
Old 03-07-2008
SPWrapper 0.9 (Default branch)
SPWrapper is a source code generator whose input is an SQL statement, or with some limitations the name of a stored procedure. Each SQL statement become a Java class, iterable to fetch results if the statement is a SELECT. It is possible to generate Python classes for the cx_Oracle module. SPWrapper is designed to require little configuration: it tries to automatically guess input parameters form SQL code, and output parameters from the SQL result set fetched. All the SQL statements can be translated to source code, even those with proprietary syntax. It currently supports 4 databases for Java (Oracle, PostgreSQL, MySQL and SQL Server) and Oracle with Python. A Netbeans plugin is also available (for stored procedures only).License: GNU Lesser General Public License (LGPL)Changes:
With this release, it is also possible to generate Python classes for the cx_Oracle module. The core of the project has been refactored to make it simple to support new programming languages. Writing a Java class and a configuration file is enough to support a new database or a new language.Image

More...
Login or Register to Ask a Question

Previous Thread | Next Thread
Login or Register to Ask a Question

LEARN ABOUT PHP

fbsql_next_result

FBSQL_NEXT_RESULT(3)							 1						      FBSQL_NEXT_RESULT(3)

fbsql_next_result - Move the internal result pointer to the next result

SYNOPSIS

       bool fbsql_next_result (resource  $result)

DESCRIPTION

	When  sending  more  than  one	SQL statement to the server or executing a stored procedure with multiple results will cause the server to
       return multiple result sets. This function will test for additional results available form the server. If an additional result  set  exists
       it will free the existing result set and prepare to fetch the words from the new result set.

PARAMETERS

	      o $
		result -A result identifier returned by fbsql_query(3) or fbsql_db_query(3).

RETURN VALUES

	Returns TRUE if an additional result set was available or FALSE otherwise.

EXAMPLES

       Example #1

	      fbsql_next_result(3) example

	      <?php
	      $link = fbsql_connect("localhost", "_SYSTEM", "secret");
	      fbsql_select_db("MyDB", $link);
	      $SQL = "Select * from table1; select * from table2;";
	      $rs = fbsql_query($SQL, $link);
	      do {
		  while ($row = fbsql_fetch_row($rs)) {
		  }
	      } while (fbsql_next_result($rs));
	      fbsql_free_result($rs);
	      fbsql_close($link);
	      ?>

PHP Documentation Group 												      FBSQL_NEXT_RESULT(3)