|
Change Request Number
|
Description
|
|
CR087241 CR216714
|
A JDBC application using XA calls and any Oracle driver was getting an ORA ORA-01002: fetch out of sequence error while fetching rows if a transaction was suspended and resumed.
The AddOracleFlagToXAResource flag has been added to fix this problem when the XA calls use the Oracle 10g thin driver. To avoid getting the ORA ORA-01002: fetch out of sequence error while using XA calls, you must use the Oracle 10g thin driver and turn on the JDBCConnectionPool flag.
|
|
CR136497
|
Calling the JTS connection getWarnings() method after a transaction is finished no longer results in a transaction over exception.
|
|
CR136713
|
The Administration Console now properly displays leaked connections for the JDBC connection pool.
|
|
CR136713 CR226682
|
Leaked connections for a JDBC connection pool are now properly displayed in the Administration Console when you click "View Leaked Connections.." in the pop-up menu for the JDBC connection pool.
|
|
CR17325
|
The Oracle thin driver only allows its property, SetBigStringTryClob, to be set through a non-JDBC-standard DataSource method. Because WebLogic Server only uses standard methods to set properties, SetBigStringTryClob was not sent successfully from the pool to the Oracle 10g driver.
Now, WebLogic Server determines whether the DataSource is an Oracle thin XA DataSource, and calls the nonstandard method to set the pool's driver properties. Thus, if the pool includes SetBigStringTryClob=true, this property, and any other Oracle-specific properties that need to be set that way, will be set.
|
|
CR189649
|
When the Sybase database is used with Container Managed Beans and the Sybase driver, and when both the method that contains transaction as Required and the method that contains transaction as NotSupported are called up in sequence from the client side, the following exception no longer appears in the JDBC Log file of the server:
com.sybase.jdbc2.jdbc.SybSQLException: SET CHAINED command not allowed within multi-statement transaction.
|
|
CR189956
|
Using ADMIN_JNDI_NAME with JDBCTxDataSource (using a JTS Driver) when performing a lookup on the Administration Server resulted in a javax.ejb.TransactionRolledbackLocalException being thrown if the Administration Server was down.
Now, for a JTS Driver, WebLogic Server does a LOCAL_JNDI_NAME lookup first and then does the ADMIN_LOOKUP only if datasource is not available locally. As a result, no exception is thrown if the lookup is made by calls within the Managed Server for JDBCTxDataSource.
|
|
CR195721
|
Previously, you could not use a semicolon as part of the JNDI DataSource name because the semicolon is the default character used to bind multiple JNDI names.
The semicolon is still the default character that binds multiple JNDI names. However, now you can use the JNDINameSeparator flag to define the character that binds JNDI names for JDBCDataSource and JDBCTxDataSource. If you choose a character other than a semicolon, you can then use the semicolon as part of the JNDI DataSource name.
|
|
CR197163
CR215627
|
The JDBC connection pool's testing of connections was consuming a lot of database resources because each test was creating a new plain statement which requires the DBMS to parse and plan the test SQL every time.
Now, pools will reuse a single prepared statement for a connection's test which results in improved performance. However, if any application DBMS tables or procedures are referred to in the test SQL and if they structurally change at runtime, such as an index being added, this may invalidate the test PreparedStatement's query plan. As a result, the subsequent test will fail and the connection and test statement will be replaced. The test SQL suggested by the Administration Console will typically not include any structurally changing table, so the problem of needlessly recycling a connection is now minimized.
|
|
CR199344
CR220931
|
When an anonymous user attempts to retrieve DataSource MBean, WebLogic Server no longer throws the following error message:
java.lang.SecurityException: User <anonymous> does not have access to the administrator port
|
|
CR199447
|
Now, when an XAER_RMERR exception is thrown, the JDBC Connection is returned to the pool.
|
|
CR202067
|
If CountOfRefreshFailuresTillDisable is set for the pool, it will disable itself if it cannot make new connections. Now the pool will correctly, periodically try to reconnect and will re-enable itself when it is able to reconnect.
|
|
CR203460
|
When XAConnectionFactory established a pool connection, it ignored the value of the seconds-to-trust property and instead used the default value.
This problem has been resolved.
|
|
CR205140
|
In WebLogic Server versions prior to 8.1, all pool self-tests were suspended when the pool was suspended. WebLogic Server 9.0 reinstates this functionality.
|
|
CR205179CR205771
|
JDBC DataSource now recognizes the Oracle RAC xid propagation delay and, during an RAC failure, reissues commit and rollback after the first commit and rollback fails.
|
|
CR205768
|
Oracle RAC exhibited a delay when replicating the state of pending (prepared) Xids from one RAC instance to another. This delay caused mixed transaction outcomes when the WebLogic Server Transaction Manager attempted to resolve global transactions that contained RAC participants.
Enhancements to the WebLogic Server Transaction Manager recovery service have resolved this problem.
|
|
CR206759
|
WebLogic Server now uses ShrinkFrequencySeconds instead of shrinkPeriod when setting attributes on JDBCConnectionPoolMBean through an Ant task. As a result, JDBC shrinkPeriodMins now sets Shrink Frequency in the Administration Console.
|
|
CR207293
|
When a WebLogic Server 8.1 instance performs a remote RMI JDBC connection to a WebLogic Server 6.1 instance, the connection no longer closes prematurely.
|
|
CR208550
|
The wlconfig Ant Task in WebLogic Server 8.1 Service Pack 2 and earlier produces an error message if a database connection pool is not configured properly. However, WebLogic Server 8.1 Service Packs 3 and 4 do not show an error if a database connection pool is not configured properly.
The error message is displayed properly in WebLogic Server 8.1 Service Pack 5.
|
|
CR208691
CR212597
|
The monitoring page for the JDBC pool in the Administration Console no longer indicates the presence of waiters when none exist.
|
|
CR209007
|
The method ResultSet.wasNull() now returns the correct information when the Weblogic Datasource is used.
|
|
CR210219
|
When WebLogic Server JDBC pools run their periodic test of idle connections, they reserve, test, and release one connection at a time. Temporary outages (ResourceExceptions) no longer occur when a new user load comes in.
|
|
CR210818
|
Pool resources are no longer reclaimed during shutdown. During WebLogic Server shutdown, WebLogic Server no longer makes getConnection calls while connections are being destroyed.
|
|
CR210859
|
Statement.getUpdateCount no longer returns -1 when a Sybase type 4 driver is used in a WebLogic Server pool.
|
|
CR211464
|
When InactiveConnectionTimeout is configured to an amount of time, truly inactive connections are now returned to the connection pool, and connections waiting for DBMS response are not returned.
|
|
CR211662
|
WebLogic Server provides the interface for Oracle thin driver Clobs and Blobs to give you access to certain Oracle-specific methods. This interface is no longer missing the trim() method and the truncate() method.
|
|
CR211812
|
The transaction coordinator was racing with the application to close or cancel a statement, which resulted in a java.lang.NullPointerException.
To avoid this race condition, WebLogic Server now ensures that the connection is viable before calling the underlying code. As a result, a java.lang.NullPointerException is no longer thrown when a statement is closed or cancelled.
|
|
CR212051
CR221756
|
The getAutoCommit() method always returned False, whether the connection was inside or outside a distributed transaction.
Now, getAutoCommit() returns True when the XAConnection object is outside a distributed transaction. Pooled connections present as the JDBC 3.0 specification mandates: autoCommit(true) outside a global transaction.
If you are using a Sybase driver, you must download and install the Sybase driver version that is later than the version shipped with WebLogic Server 8.1 Service Pack 4.
|
|
CR212779 CR205768
|
The JDBC configuration attributes, XARetryDurationSeconds and XARetryIntervalSeconds, were added to the JDBCConnectionPoolMBean. These attributes were also added to the Administration Console so that you can set them without manually editing the config.xml file.
|
|
CR213774
CR230719
|
WLCachedRowSet now returns the time portion (hour, minute, and second) from an Oracle database date column.
|
|
CR214267
|
JTA JDBC connections now keep track of statements so they can be cancelled at transaction timeout.
|
|
CR215076 CR222549
|
Now, even if CountOfRefreshFailuresTillDisable is greater than 1, the pool will disable itself after that many consecutive failures to refresh, as documented.
|
|
CR216078
|
Combo patch request of CR212674, CR186754, CR188329, and CR172353.
|
|
CR219411
|
Connection pool refresh is supposed to test all unused connections. It was testing one idle connection n number of times. Now it properly tests n number of idle connections one time each.
|
|
CR219822 CR212898
|
In the Examples domain that shipped with WebLogic Platform 8.1 Service Pack 3, if the thread ID that was logged as part of the statement profiling contained XML reserved characters, many XML errors occurred when getStatementProfiles() was called on the JDBCConnectionPoolRuntime MBean.
WebLogic Server now ensures that the pool profiling information no longer contains any XML reserved characters.
|
|
CR221966
|
WebLogic Server no longer makes more than the necessary number of transaction rollbacks in the Oracle database.
|
|
CR222454
|
The weblogic.jdbc.wrapper.XAConnection.resetTransactionIsolation() method no longer leaks transactions.
|
|
CR225187
|
The driver type was incorrect for the SQL/MX driver in the jdbcdrivers.xml file.
The driver entry for the SQL/MX driver was removed from the jdbcdrivers.xml file. As a result, you now must manually enter all driver and property information while defining a pool to use the SQL/MX driver.
|
|
CR227920
|
In some cases, redeploying an application on a Managed Server from the Administration Console, after having restarted the Administration Server, threw a java.rmi.ConnectException.
WebLogic Server no longer throws this exception.
|
|
CR228597
|
Now, CallableStatement contains the same processing that PreparedStatement contains. When you use CallableStatement, WebLogic Server supplies proxy processors for certain non-serializable arguments to JDBC calls such as Input streams.
As a result, using CallableStatement to call a stored procedure in the 10g database to insert a CLOB field no longer results in a java.rmi.MarshalException.
|
|
CR229318
|
While processing JMS messages, if the transaction times out, the database rows are no longer locked.
|
|
CR229477
|
If you reset the connection pool with TestFrequencySeconds using the Administration Console, WebLogic Server no longer throws the following exception:
java.sql.SQLException: Statement is closed
|
|
CR233641
|
The ResultSetRowCache class does not obtain the complete time stamp from the DATE column of an Oracle database.
To resolve the problem, contact BEA Customer Support for the latest patch.
|
|
CR233921
|
When closing an RMI JDBC statement, Weblogic Server no longer fails to close the result sets.
|
|
CR236171
|
Differences between the WebLogic Server 7.0 and 8.1 releases in the implementation of the JDBCConnectionPoolRuntimeMBean no longer result in migration problems.
|
|
CR236988
|
Lack of synchronization caused the JTAConnection object to throw a NullPointerException.
This problem has been fixed.
|
|
CR243411
|
A JDBC NullPointerException was thrown during a MultiPool failover using Oracle 10g RAC.
This problem has been resolved. Contact BEA Customer Support for the patch.
|