Connection Properties

The JD Edwards EnterpriseOne JDBC drivers recognize several connection properties that you can set when you establish a new connection. You specify these in the connection URL or in the java.util.Properties object that you pass to DriverManager.getConnection. If you specify the same property in both places, the value in the URL takes precedence.

If the property value contains one or more semicolons, you may need use parentheses to delimit the property value. Otherwise, parentheses are optional.

The following table shows the connection properties that the JD Edwards EnterpriseOne JDBC drivers recognize. The set of valid connection properties varies based on the connection mode. The JD Edwards EnterpriseOne JDBC drivers ignore any connection properties that are not listed in this table:

Connection Mode	Property Name	Property Value
enterpriseone	enterpriseone.role	The ERP role, if any. The default is *ALL. This property value applies only if you are accessing ERP 9 or later data.
enterpriseone	impersonate	The user name, which will be substituted for authorization purposes at runtime in a proxy authentication mode. This is discussed in the JDBC Security Considerations section.