You can develop your application using an Oracle8i database and expect it to work with other databases as long as the schemas match exactly. You must be aware of certain limitations when using databases other than Oracle8i. See Limitations of Developing for Foreign Datasources for more information.
When you have finished developing your Business Components for Java project and want to begin runtime testing, you need to make several small changes in order to run against the foreign database. You do not need to regenerate Business Components or modify SQL strings.