A Tangled Web

Database BC to replace SQL SE and JDBC BC

Introducing the new Database BC
A new Open ESB component, the Database BC, will soon replace two existing components, the SQL SE and the JDBC BC. Until now, database access in Open ESB was accomplished through the use of both the SQL SE and the JDBC BC. The JDBC BC was used for simple select and insert operations on database tables. The SQL SE was used for more advanced database  manipulations through the SQL language.

Why make this change?
Through various user feedback, it became evident that having two different database access components confused many users. In order to alleviate the confusion, we decided to combine the features of both into a new Database BC. Both the SQL SE and the JDBC BC will be deprecated in November  2008.

What are some of the features in the Database BC?
The Database BC will have all the features of both the JDBC BC and the SQL SE. The full feature list will be published to the Database BC Wiki Page.

What about existing applications using SQL SE and JDBC BC?
We will be introducing a procedure to convert existing SQL SE projects to the new Database BC. This procedure will be a well-defined set of steps to migrate SQL SE artifacts to Database BC artifacts. The JDBC BC artifacts are functionally equivalent, so any projects using WSDL with JDBC  extensions will work without any changes.

When will the Database BC be available?
A community version of the Database BC is available now from Project Open ESB. It will be officially released as part of GlassFish ESB in November 2008 and made available to customers of CAPS R6, ESB Suite R6 and MDM Suite R6 at the same time.

How is the Database BC packaged?
The runtime component is available as sun-database-binding.  The design-time components still use the org-netbeans-modules-wsdlextensions-jdbc.nbm and org-netbeans-modules-sql-wizard.nbm NetBeans modules to create artifacts for the Database BC. Artifacts generated by the new versions of these design-time components will now be deployed to the Database BC instead of the JDBC BC or the SQL SE.

Posted at 11:28AM Sep 09, 2008 by mwhite in Open ESB  |