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 the benefits of migrating from a JDBC 1.x Datasource to JDBC 2.0 DataSource?

April 26, 2017Benefits DataSource JDBC migrating

0

10 Posted

What are the benefits of migrating from a JDBC 1.x Datasource to JDBC 2.0 DataSource?

1 Answer

0

10 Posted

Migrating from a JDBC 1.x datasource to a JDBC 2.0 datasource allows for greater selection of connection pool configuration options. JDBC 1.x datasources involve a JDBC 1.x driver class and are defined in EJB deployment descriptors. With JDBC 2.0 BES datasources, you have to choice to retain the JDBC 1.x driver class or introduce a JDBC 2.0 driver class. In either case, common updates are required to EJB deployment descriptor ejb-borland.xml: • In sections, the value for a JDBC 1.x datasource should be prefixed with the value ‘serial://’. • Remove each JDBC 1.x entry for JDBC 1.x datasource from section. The screen shots below illustrate updates required. From BES EJB ‘data’ example, output module data_beans.jar is converted to use a JDBC 2.0 JDataStore datasource defined in a partitions default DAR module default-resources.dar. Following is how ejb-borland.xml file originally appears. Highlighted is the JDBC 1.x datasour