Kbase P17712: How to set a default schema for a specific owner within a JDBC client?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/02/2010 |
|
Status: Verified
GOAL:
Is there a way to avoid the use of the prefix 'PUB' within a Java Application ?
GOAL:
How to set a default schema for a specific owner within a JDBC client?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.1x
OpenEdge 10.x
FIX:
Option #1
Use the 'set schema' SQL query:
Example: Set schema 'pub';
Option #2
Add the "defaultSchema=pub" parameter to the URL:
jdbc:datadirect:openedge//myhost:9999;databaseName=sports2000;defaultSchema= pub