Technical data

36 BEA WebLogic Integration Release Notes
26 CR064564
Problem
The organization view in the WebLogic Integration Worklist is not updated when you
add a new organization through the following procedure:
Log in to the Studio and the Worklist with the same user account (such as
joe).
In the Studio, add an organization.
Select the new organization from the Organization drop-down list.
Add yourself (
joe) as a user to the new organization.
In the Worklist, look for the new organization in the drop-down list.
The problem is that the new organization is not listed. Even if you refresh the Worklist
(by choosing View
→Refresh), the organization is still not listed.
Platforms
All
Workaround
Log off from the Worklist and then log on again.
27 CR064716
Problem
The WebLogic Integration source code checks the PRODUCTNAME column of the
master.dbo.spt_mda table, and it relies on finding the following string: Sybase SQL
Server. If, instead of this string, the source code finds a variable, @@version, which is
set to Adaptive Server Enterprise, then users get the following
com.sybase.jdbc.SybSQLException:
SET CHAINED command not allowed within multi-statement
transaction.
Platforms
Sybase 11.9.2
Workaround
jConnect implements the JDBC method getDatabaseProductName by calling the
sp_mda stored procedure that is set up by the installjconnect script. This script
populates the
master..spt_mda table with information to be returned by metadata
access methods.
If the
PRODUCTNAME column of the master.dbo.spt_mda table contains the
@@version variable, then you must change the variable to Sybase SQL Server by
running the following SQL statements:
update master.dbo.spt_mda set query = 'Sybase SQL Server’
where mdinfo = ‘PRODUCTNAME’ querytype = 6
update master.dbo.spt_mad set query = 'select ''Sybase SQL
Server''' where mdinfo = ‘PRODUCTNAME’ querytype = 2