Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are JDBC Driver specific connection properties and how are they defined?

April 26, 2017connection defined driver JDBC properties

0

Posted

What are JDBC Driver specific connection properties and how are they defined?

1 Answer

0

Posted

can be applied to Sybase datasources. However, some issues arise when taking this approach. First, Sybase specific properties must have a of ‘String’, otherwise a failure will occur during deployment when properties are set in the Sybase datasource instance. Second, Sybase implementation of JNDI interface javax.naming.Referenceable for class com.sybase.jdbc2.SybConnectionPoolDataSource does not guarantee retention of Sybase specific property values in javax.naming.Reference objects of that class. A javax.naming.Reference is used during JNDI lookup of the Sybase datasource and represents a way of recording address information about objects which themselves are not directly bound to the naming system. A workaround for this second shortcoming is to specify the Sybase specific properties in the URL defined for a JDBC 1.x driver class in a JDBC 2.0 BES datasource. To set a property in the URL, append “?” to the URL definition and follow it with the property in the format name=va