Connection tempConn = DataSourceManager.getConnection();
String databaseType = tempConn.getMetaData().getDatabaseProductName();
DataSourceManager.releaseConnection(tempConn);

• Jakarta commons-logging (requires...)
  • Log4j (If using Log4j for logging)
• Shiftone OOC JNDI Context (requires...)
  • Shiftone Arbor XML Unmarshaller
  • c3p0 database connection pool

• Jakarta commons-logging - http://jakarta.apache.org/commons/logging/
• Shiftone OOC - http://oocjndi.sourceforge.net/
• Log4J - http://logging.apache.org/log4j
• Shiftone Arbor - http://xarbor.sourceforge.net/
• c3p0 - http://sourceforge.net/projects/c3p0

• commons-logging 1.1 - Required by BuzzSQL
• Log4j 1.2.14 - Required if using Log4J for logging
• Shiftone OOC 1.2 - Required if no JNDI naming context (J2SE environment)
• Shiftone Arbor 1.4 - Required by Shiftone OOC
• c3p0 0.9.1.2 - Required by Shiftone OOC if using c3p0 as the database connection pool
• MySQL Connector/J 5.0.6 - Required by c3p0 if using MySQL
• Oracle Thin Driver ojdbc14 - Required by c3p0 if using Oracle

• buzzsql-<version>.jar - The BuzzSQL classes
• commons-logging-1.1.jar - Jakarta commons-logging: Wrapper around a variety of logging APIs. Required by BuzzSQL and other libraries.
• log4j-1.2.14.jar - Log4j: Elegant logging system. Required by commons-logging if you are using Log4j as your logging system.
• shiftone-oocjndi.jar - Shiftone OOC: An in-memory JNDI service provider. Required by BuzzSQL if no JNDI naming context already exists, such as in a stand-alone J2SE application.
• shiftone-arbor.jar - Shiftone Arbor XML Unmarshaller: A library for reading XML files. Required by Shiftone OOC to load the XML resource configuration.
• c3p0-0.9.1.2.jar - c3p0: JDBC connection and statement pooling. Required by Shiftone OOC for database connection pooling if you are using c3p0 as your pool.

• rootNamespace
  • The root JNDI namespace to search for DataSources.
  • The stand-alone J2SE naming context will bind DataSources here, so you only need to specify this property if your J2EE application server binds the DataSource resources at a location different than the default.
  • Default: java:comp/env/jdbc
• dataSourceNames
  • Specific name(s) of DataSources for the library to use.
  • BuzzSQL normally performs an automatic DataSource discovery process by searching the full JNDI path under your rootNamespace for DataSource objects. If you specify this property, the search process will NOT occur and BuzzSQL will ONLY lookup the names listed here. All names are relative to the rootNamespace property.
  • You may list multiple DataSource names separated by commas.
  • Default: none
• defaultDataSourceName
  • The default dataSourceName to use when there are multiple DataSources available.
  • If you are using more than one DataSource, you must either provide the dataSourceName in your code to specify which DataSource you are referring to, or define this property.
  • If you define the dataSourceNames parameter but not this parameter also, the default will be the first DataSource listed. In any other case of multiple DataSources, the default is non-deterministic.
  • Default: none

• Non-existent DataSources named by dataSourceName properties in buzzsql.properties.
• A non-existent DataSource named by defaultDataSourceName property in buzzsql.properties.
• Multiple DataSources loaded without a defaultDataSourceName property set.
• No DataSources found.
• A NULL DataSource bound to a JDNI name; usually indicating failed JDBC driver initialization.

• Failure to load any JNDI initial naming context.
• Failure to lookup the JNDI root namespace.

• OOC and Arbor will write extensive logs to DEBUG level while processing the buzzsql-datasources.xml file.
• OOC will write JDNI context setup information to the INFO level during initialization.
• c3p0 will write extensive information to the DEBUG level during connection setup, and more terse status information to the INFO level.

• A zero argument constructor is provided for simplified operation with JavBeans, SOAP, and reflection scenarios where having such a constructor is necessary or convenient. At a minimum, you must call setSQL(String) before execution when using this constructor.
• A single argument constructor that accepts your SQL statement and uses the default DataSource.
• A dual argument constructor that accepts your SQL statement and the explicit name of a DataSource to use.
• A dual argument constructor that accepts your SQL statement and a java.sql.Connection object. This constructor provides a great deal of flexibility by allowing the use of "explicit" connections that are supplied by the user rather than being obtained automatically by BuzzSQL. Using a explicit connection also allows BuzzSQL to support database transactions.

• byte, short, int, long if the database type is numeric
• float, double if the database type is numeric with precision
• String, char if the database type is varchar based
• java.util.Date, java.util.Calendar if the database type is a date/time based
• com.buzzsurf.sql.OutParameter, com.buzzsurf.sql.InOutParameter if the database type is a stored procedure OUT or INOUT parameter. See Stored Procedure for more information.

Update myUpdate = null;
try
{
 myUpdate = new Update(sql);
 myUpdate.setArgs(args);
 myUpdate.execute();
}
catch(Exception e)
{
 // handle the exception
}
finally
{
 if(myUpdate != null)
  myUpdate.close()
}

• java.sql.Connection
• java.sql.PreparedStatement
• java.sql.ResultSet
• java.sql.ResultSetMetaData

Select select = new Select();
select.setSQL("select col_pk, col_str, col_int from example.table_example1");
select.execute();
while (select.next())
 System.out.println(select.getLine());
select.close();

• java.sql.Connection
• java.sql.PreparedStatement

Update update = new Update();
update.setSQL("update example.table_example1 set col_str = ? where col_pk = ?");
update.setArgs("asdf",1);
update.execute();
int updateCount = update.getUpdateCount();
update.close();

• java.sql.Connection
• java.sql.PreparedStatement

Insert insert = new Insert("insert into example.table_example1(col_str, col_int) values (?,?)")
insert.setArgs("asdf", 123);
insert.execute();
int pk = insert.getGeneratedKey();
System.out.println(pk);
insert.close();

• java.sql.Connection
• java.sql.PreparedStatement

Delete delete = new Delete();
delete.setSQL("delete from example.table_example1 where col_int = ?");
delete.setArgs(123);
delete.execute();
int deleteCount = update.getDeleteCount();
delete.close();

• java.sql.Connection
• java.sql.PreparedStatement
• java.sql.ResultSet
• java.sql.ResultSetMetaData

OutParameter outParam = new OutParameter(java.sql.Types.VARCHAR);
InOutParameter inOutParam = new InOutParameter(java.sql.Types.INTEGER, 10);
StoredProcedure storedProc = new StoredProcedure("call test.storedproc_test(?, ?, ?)");
storedProc.setArgs("asdf", outParam, inOutParam);
storedProc.execute();
if (storedProc.hasResultSet())
{
 while (storedProc.next())
  System.out.println(storedProc.getLine());
}
System.out.println(outParam.getString());
System.out.println(inOutParam.getInt());
storedProc.close();

• java.sql.Types.DATE
• java.sql.Types.INTEGER
• java.sql.Types.DECIMAL
• java.sql.Types.VARCHAR

// DataSource bound in JNDI at java:comp/env/jdbc/testDB
Select select = new Select(sql, "testDB");

// DataSource bound in JNDI at java:comp/env/jdbc/testDB
Select select = new Select(sql);
select.setDataSourceName("testDB");

Connection con = DataSourceManager.getConnection();
con.setAutoCommit(false);

Update update3 = null;
Update update4 = null;
boolean tranSuccess = true;

try
{
 update3 = new Update("update example1.table_example1 set col_str = ? where col_int = ?", con);
 update3.setArgs("tran", 234);
 update3.execute();

 update4 = new Update("update example1.table_example1 set col_str = ? where col_int = ?", con);
 update4.setArgs("tran", 234);
 update4.execute();
}
catch(Exception e)
{
 tranSuccess = false;
 e.printStackTrace();
}
finally
{
 if(update3 != null)
   update3.close();

 if(update4 != null)
  update4.close();

 try
 {
  if(tranSuccess)
   con.commit();
  else
   con.rollback();
 }
 catch(Exception e2)
 {
  e2.printStackTrace();
 }

 con.setAutoCommit(true);
 DataSourceManager.releaseConnection(con);
}

Update update = new Update(sqlStr);
update2.setArgs(s,i);
update2.execute();
update2.close();

Update update = new Update(sqlStr).setArgs(s,i).execute().close();

new Update(sqlStr).setArgs(s,i).execute().close();

ReleaseInfo releaseInfo = BuzzSQL.getReleaseInfo();
System.out.println(releaseInfo.getWelcome());
System.out.println(releaseInfo.getVersionString());
System.out.println(releaseInfo.getProductName());
System.out.println(releaseInfo.getLicenseInfo());
System.out.println(releaseInfo.getReleaseDate());
System.out.println(releaseInfo.getWebsiteString());
System.out.println(releaseInfo.getMajorVersion());
System.out.println(releaseInfo.getMinorVersion());
System.out.println(releaseInfo.getBuildNumber());

• Web: http://www.buzzsurf.com/sql
• Email: pwc21@yahoo.com
• AIM: umakemyheadhurt

• 1.3.8 - 11/04/2007
  
  • Initial Release