Vendor-specific
JavaSQL
In
our previous tip, we discussed how DBMS vendors are adopting and implementing
portable Java code with SQLJ. We discussed how we can use some standard, common
features of multiple databases to increase portability across those databases
with our application Java and SQLJ code. Proprietary features can also be included,
using a feature called SQLJ Profiles. A Java binary can contain profiles that
describe a vendor's customizations. You can also implement multiple profiles
for multiple vendors. Using this feature, a binary that uses proprietary vendor-specific
customizations can be created to run in multiple environments. This leads to
increased portability across environments.