Tipworld -> SQL
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.