Problem:
- Product Name: VisiBroker for Java
- Product Version: 5.2.1
- Product Component: Naming Service
- Platform/OS Version: All
Is there a way to specify the schema name for the JDBC driver passed into the VisiBroker DB backing store code to use for its connection (other than configuring on the DB side)?
Resolution:
The answer is no. When the VisiNaming creates a connection to the DB using the login and password one provids, the VisiNaming is automatically logged in to the schema associate with this login and password name. And if the tables are not present, the VisiNaming automatically creates these tables with a predetermined naming convention.
If one thinks that by passing in a different schema, one can create different naming convention for the VisiNaming to use it is not going to work. Because next time when the VisiNaming logged back in and try to look up tables, it will search the tables with the pre-defined table naming convention. And if these tables that were created by your schema did not match the same name convention, the VisiNaming will create new tables conforming to its convention.
#VisiBroker
#Security
