| Fixes |
| 1 | 6.1.0.4 | 100399 | JR35150 |
JDBC Adapter can only support using integer as the generated identity value.
|
| Symptom:
JDBC Adapter can only support using integer as the generated identity value. When the identity value is larger than the maxium value of integer (2147483647), java.sql.SQLException: Numeric Overflow will be generated.
|
| Resolution:
JDBC Adapter add enhance support to using number as the generated identity value.
|
|
| 2 | 6.1.0.4 | 100330 | JR35018 |
When configured a XA DataSource and the XA transaction enabled, if a delete operation failed, adapter may cause a problem related to database lock.
|
| Symptom:
When configured a XA DataSource and the XA transaction enabled, adapter will call the transaction API to ensure a delete operation will join to a global transaction. But in some special cases, for example the J2C managed connection shared by different transaction context, the transaction API will be called incorrectly. Sometimes it will suspend the current transaction and cause a problem related to database lock.
|
| Resolution:
Fixed. Adapter will ensure the transaction API be called correctly, no matter whether the managed connection is shared by different transaction context or not.
|
|
| 3 | 6.1.0.4 | 100288 | JR34949 |
JDBC Adapter returns empty resultsets when there are no records in database or no sample values in the process of stored procedure's validation during the external service discovery.
|
| Symptom:
JDBC Adapter returns empty resultsets when there are no records in database or no sample values in the process of stored procedure's validation during the external service discovery.
|
| Resolution:
Fixed.Even if there are no records in database or sample values in the process of stored procedure's validation during the external service discovery, JDBC Adapter could return resultsets successfully.
|
|
| 4 | 6.1.0.4 | 100313 | JR34869 | Adapter does not use connectionpool in the first pollcycle during "unordered" delivery. |
| Symptom: When using "unordered" delivery mode with "maximum connections" larger than 1, connection pool will not be used during the first poll cycle and NPE will be thrown.
|
| Resolution: A fix has been delivered to have the ActivationSpec for one specific endpoint to be configured before polling for the first cycle, thus enable connection pool be used for "unordered" mode.
|
|
| 5 | 6.1.0.4 | 93528 | JR34574 | When two different business objects have the same name but different namespaces, inbound/outbound operations may fail. |
| Symptom: In multiple applications, if some Business Objects have the same BO name but different BO namespaces, inbound or outbound operation may fail, e.g., retreive may report NullPointerException. This issue impacts both inbound and outbound.
|
| Resolution: Delivered a fix to not only use BO name but also namespace to differentiate BO during runtime.
|
|
| 6 | 6.1.0.4 | 99998 | | Make adapter 6.1 comply with the new WPS v7.0 SDO implementation. |
| Symptom: Currently the Adapter 6.1 version only supports EMF, and doesn't support XCI.
|
| Resolution: A fix has been delivered to make Adapter 6.1 comply with the new WPS v7.0 SDO implementation.
|
|
| 7 | 6.1.0.4 | 78477 | JR33782 |
ClassNotFound exception when they do not use the
ARM.
|
| Symptom:
When user did not use the ARM,they
encountered the "ClassNotFound" exception
because the ARM transaction factory was an
blank string.
|
| Resolution:
Adapter will judge the ARM transaction
factory name before use it to create the ARM
transaction factory instance.
|
|
| 8 | 6.1.0.4 | 77645 | JR33324 |
JDBC Adapter failed to throw
ObjectNotFoundException to fault business
object.
|
| Symptom:
Client gets an exception while trying to
update a table using a batchSQL business
object. He does not receive the expected
ObjectNotFound fault business object in JDBC
adapter so that he cannot catch the fault
business object in mediation flow.
|
| Resolution:
Fixed.JDBC Adapter succeeds throwing
ObjectNotFoundException to fault business
object.
|
|
| 9 | 6.1.0.4 | 77347 | JR33030 |
JDBC Adapter inbound service failed to use
"additional properties" to connect a database.
|
| Symptom:
During the enterprise discovery service, you
fill in some values in "additional
properties" for inbound service. While
running inbound service in runtime, these
values of "additional properties" could not
work.
|
| Resolution:
Fixed.JDBC Adapter inbound could use
"additional properties" to connect a
database.
|
|
| 10 | 6.1.0.4 | 77245 | JR32832 |
JDBC Adapter failed to return correct data while
running a complicated store procedure with Array
and Struct data type in Oracle database.
|
| Symptom:
JDBC Adapter failed to return correct data
while running a complicated store procedure
with Array and Struct data type in Oracle
database.
|
| Resolution:
Fixed.JDBC Adapter succeed to return correct
data while running a complicated store
procedure with Array and Struct data type in
Oracle database.
|
|
| 11 | 6.1.0.4 | 77247 | JR32739 |
JDBC Adapter always uses bind variables to
enhance database performance in inbound service.
|
| Symptom:
JDBC Adapter does not use bind variables and
lead to reducing database performance in
inbound service.
|
| Resolution:
Fixed.JDBC Adapter uses bind variables to
enhance database performance in inbound
service.
|
|
| 12 | 6.1.0.4 | 76903 | JR32553 |
JDBC Adapter could not deal with Null as a value
of a parameter with a collection type (TABLE,
VARRAY) or a OBJECT type(STRUCT) in Oracle
database.
|
| Symptom:
When passing Null parameter to a Collection
type(TABLE,VARRAY) or a OBJECT type(STRUCT)
in Oracle database,JDBC Adapter fails to
execute stored procedure business object.
|
| Resolution:
Fixed.JDBC Adapter supports to execute
stored procedure business object passing
Null parameter to a Collection
type(TABLE,VARRAY) or a OBJECT type(STRUCT)
in Oracle database.
|
|
| 13 | 6.1.0.4 | 77096 | JR32752 |
There are some Adapter Migration issues when
namespace has upper case letters.
|
| Symptom:
During generating the package name of
binding class, AFC convert all package name
to lower case.
|
| Resolution:
Fixed. AFC converts all package name to lower
case.
|
|
| 14 | 6.1.0.4 | 76676 | JR32259 |
After migrate the ICS project to JCA,one build
error will be promoted
|
| Symptom:
After migrate the ICS project to JCA,one
build error will be promoted which caused by
the Adapter Foundation Class just check the
QName which equals with "schema"
|
| Resolution:
Fixed. AFC add "xsd:schema" and "xs:xsd"
format during QName check
|
|
| 15 | 6.1.0.4 | 76176 | JR31305 |
JDBC adapter throws RecordNotFoundException
during RetrieveAll operation when no records are
found in the database.
|
| Symptom:
During retrieveAll operation, adapter throws
RecordNotFoundException when no records are
returned from the database. As part of this
fix, a new property called
ErrorOnEmptyResultset has been added on the
Managed Connection Factory. The default
value for this property is true and will
result in current behaviour, i.e. if no rows
are returned for the RetrieveAll operation,
a RecordNotFoundException is thrown. If you
want to override the behavior for
retrieveAll operation then you can change
the value for this property through admin
console and set it to false after deploying
the application. In this case, adapter will
not throw an exception and return an empty
container when no records are found after
processing the retrieveAll operation. This
property is not configurable through EMD in
this fix, and has to be changed in the Admin
Console.
|
| Resolution:
Fixed. See details above on how to use the
new property - ErrorOnEmptyResultset.
|
|
| 16 | 6.1.0.4 | 76301 | JR31631 |
JDBC Adatper failed to validate stored
procedures on DB2 iSeries during external
service discovery.
|
| Symptom:
While using external service discovery,JDBC
Adapter failed to validate stored procedures
on DB2 iSeries.
|
| Resolution:
Fixed.JDBC Adapter succeeds in validating
stored procedures on DB2 iSeries during
external service discovery.
|
|
| 17 | 6.1.0.3 | 93182 | |
English text over the Progress Monitor
Indicator.
|
| Symptom:
The progress monitor in the first screen of
the EMD has har coded english text.
|
| Resolution:
Modify some source files and also message
files to solve this issue.
|
|
| 18 | 6.1.0.3 | 93155 | |
TypeFactory is using ext classloader instead of
application classloader in WAS.
|
| Symptom:
forName method could not find the record and
throws bo not found exception.
|
| Resolution:
Change the source code tto make sure correct
classloader is used.
|
|
| 19 | 6.1.0.3 | 93148 | | Improve the adapter exception case. |
| Symptom:
crash or hang situation appears since Base
Class does not handle the exception.
|
| Resolution:
Fix it by catching the exception thrown by
logging and ignore it for making sure the
work completion status could be notified to
workcontroller.
|
|
| 20 | 6.1.0.3 | 93143 | JR30855 |
Infinite inbound loop when assuredOnceDelivery
is false.
|
| Symptom:
Infinite inbound loop when
assuredOnceDelivery is false.
|
| Resolution:
Change the source code to support the case
when assuredOnceDelivery is false.
|
|
| 21 | 6.1.0.3 | 93077 | |
"Method is deprecated messages" in the
log/console.
|
| Symptom:
A lot of warning messages appears in the
log/console when the websphere adapter is
running.
|
| Resolution: Remove this message from system out. |
|
| 22 | 6.1.0.3 | 75915 | | Null name space support in base class. |
| Symptom:
Base class doesn't support null namespace
using 6.1 adapter.
|
| Resolution:
One is adding the Head Alias "xsd:" to all
vocabulary scoped in w3c namespace. The
other is that cut off those alias with
declaration of null namespace from schema.
|
|
| 23 | 6.1.0.3 | 76053 | JR30832 |
JDBC Adapter failed to retrieveAll a view with a
child business object that has one child
business object itself.
|
| Symptom:
RetrieveAll a View with a child business
object that has one child business object
itself.There is no error message any more,
but the result of the query does not match
the data in the database. Only the first
level resultset is correct. All the other
resultsets are missing the second level
child business object .Only the first level
resultset includes the business object. The
other resultsets does not show this business
object.
|
| Resolution:
Fixed. JDBC Adapter succeeds in executing
retrieveAll a view with a child business
object that has one child business object
itself.
|
|
| 24 | 6.1.0.0_IF18 | 76469 | JR32091 |
The digital number is a invalid java package
name,so Adapter Foundation Classes will do the
validation check and add "_" as the prefix for
the digital number.
|
| Symptom:
The digital number is a invalid java package
name,so Adapter Foundation Classes will do
the validation check and add "_" as the
prefix for the digital number. For example,
if the namespace like this:
"http://www.ibm.com/j2c/2001/afc", the fresh
output package will be
"com.ibm.j2c._2001.afc".
|
| Resolution:
Fixed. Adapter Foundation Classes can
generate a valid package name when the
namespace contains digital number.
|
|
| 25 | 6.1.0.0_IF17 | 93332 | |
If ownership=true, empty set clause update SQL
generated when try to update FK value.
|
| Symptom:
One parent BO P with one single-card child
BO C. P own C. And Primary key of C C.pk is
a auto increase column. When try to update
parent BO p, set p.fkojb to a new C record
and unset p.fk. An update SQL with empty set
clause will be genereated. Thus SQL
exception thrown excution phase.
|
| Resolution:
Fixed. Copy FK value from child before
generate update SQL.
|
|
| 26 | 6.1.0.0_IF17 | 93235 | |
If ownership=false, RecordNotFoundException
thrown when try to update FK value.
|
| Symptom:
Parent BO P has single-card relationship
with child BO C (P.fk-->C.pk). When try to
update p1.fk to another valid value.
RecordNotFoundException thrown.
|
| Resolution:
Fixed. Remove FK condition from where
clause.
|
|
| 27 | 6.1.0.0_IF17 | 93234 | |
JDBC can not return corrent value for null
primitive type column.
|
| Symptom:
For primitive type, if column value is null,
the related property value returned by JDBC
Adapter will be 0 (for numeric type).
|
| Resolution:
Fixed. For any type, If column value in DB
is null, JDBC Adapter will return null.
|
|
| 28 | 6.1.0.0_IF17 | 93233 | |
JDBC Adapter can not tell unset/null input value
|
| Symptom:
In update operation, if user set one
property value to null in the test client.
Update will success, but the related column
has no change.
|
| Resolution:
Fixed. JDBC add judge statment to tell unset
and null input value.
|
|
| 29 | 6.1.0.0_IF17 | 76243 | JR31523 |
Retrieve BO with null FK value, JDBC throws
RecordNotFound Exception.
|
| Symptom:
One parent BO P with one or more single-card
children BOs. For retrieve operation, when
parent record in DB has one or more null FK
value, JDBC Adapter throws
RecordNotFoundException.
|
| Resolution:
Fixed. JDBC add null value judgement for
every FK separately.
|
|
| 30 | 6.1.0.0_IF16 | 76154 | JR31202 | NPE happened on JDBC_6.1.0.0_IF15. |
| Symptom:
Run some transactions against module
concurrently. NullPointerException will
occur while shutting down WPS adapters or
close JDBC connection when exception occured
during execute operations.
|
| Resolution:
Fixed. JDBC Adapter add null judgement in
clear connection operation.
|
|
| 31 | 6.1.0.0_IF15 | 93103 | JR30968 |
JDBC Adatper failed to use DB2 XA Type 4
DataSource connection.
|
| Symptom:
There is an application with JDBC Adapter
outbound which uses DB2 XA Type 4 DataSource
connection. But while deploying the
application to WPS server, it raises an
error like below.
com.ibm.db2.jcc.b.SqlException: Failure in
loading T2 native library db2jcct2, reason:
java.lang.UnsatisfiedLinkError: db2jcct2
(Not found in java.library.path).
|
| Resolution:
Fixed.JDBC Adapter succeeds in using DB2 XA
Type 4 Datasource connnection.
|
|
| 32 | 6.1.0.0_IF15 | 93101 | JR30971 |
JDBC Adapter EMD throws a null exception while
adding a stored procedure to a selected object
list.
|
| Symptom:
During discovery time, the client is able to
connect and see all database artifacts
including tables and stored procedures. The
problems start when they add a stored
procedure to the selected objects list, no
dialog displays showing how to configure the
stored procedure, its parameters, or
resultset. The stored procedure is just
added to a selected objects. They get a null
pointer exception when generation starts.
|
| Resolution:
Fixed.JDBC Adapter EMD can complete adding a
stored procedure to a selected object list
without any exception.
|
|
| 33 | 6.1.0.0_IF15 | 93090 | JR30215 |
JDBC Adapter returns a null exception message
while polling events due to connection failure.
|
| Symptom:
When JDBC Adapter encounters an Database
connection issue while polling events in
inbound operation,it returns a null
exception message.
|
| Resolution:
Fixed.JDBC Adapter can report detailed
database exception message while polling
events in inbound operation.
|
|
| 34 | 6.1.0.0_IF15 | 76071 | JR30954 |
EMD tool could not generate primaryKey ASI for
the BO based on a table without primarykey
definition.
|
| Symptom:
Working with some database such as SQL
Server. When user created a table without
primarykey defined on it. During discovery,
EMD tool can not generate primarykey ASI for
the BO, although the user has manually set
the primarykey in EMD wizard.
|
| Resolution:
Fixed.JDBC Adapter can generate primaryKey
ASI for the BO based on a table without
primarykey definition.
|
|
| 35 | 6.1.0.0_IF15 | 75922 | JR30463 |
For the non-primaryKey attributes with FixedChar
ASI set,there is null pointer exception occurred
when JDBC Adapter does the retrieveAll
operation.
|
| Symptom:
JDBC Adapter failed to deal with retrieveAll
operation for the non-primaryKey attributes
with FixedChar ASI set.
|
| Resolution:
Fixed.JDBC Adapter adds a support of
retrieveAll operation for non-primaryKey
attributes with FixedChar ASI set.
|
|
| 36 | 6.1.0.0_IF15 | 92815 | JR30663 |
WsException is thrown for multiple running JDBC
Adapter threads.
|
| Symptom:
When multiple JDBC Adapter threads are
running, a connection cleanup operation in a
thread could not be completed succesfully.
|
| Resolution:
Fixed.JDBC Adapter completes connection
cleanup operation in a thread succesfully.
|
|
| 37 | 6.1.0.2 | 92333 | |
Add support for dynamic returned resultset from
stored procedure.
|
| Symptom:
When the returned resultset number or order
is not the same with EMD generated , JDBC
adapter will lose some data or miss order
some data of the returned resultset from
stored procedure.
|
| Resolution:
JDBC adapter provide a choice for customer
to select which BO mode to handler returned
resultset. During EMD process , JDBC adapter
provide a check box for customer to enable
ResultSetBO mode or not. If user select
ResultSetBO mode , JDBC adapter will not
need user to input dummy value and run the
stored procedure with dummy value , but
replace with automated generate a set of BOs
named ResultSetBO to handle returned
resultset , without consideration with the
resultset structure or order.(There are 2
BOs will auto generated , cursorBO and
rowBO). During runtime , JDBC adapter will
return the data from resultset into cursorBO
and rowBO. This will solve the issue that
JDBC adapter do not support dynamic returned
resutlsets .
|
|
| 38 | 6.1.0.2 | 75867 | JR30398 |
NullPointerExceptin is thrown for parallel
operation calls
|
| Symptom:
JDBC adapter failed to support parallel
running operations .
|
| Resolution:
Fixed. Now users can call jdbc adapter in
parallel operations
|
|
| 39 | 6.1.0.2 | 75729 | JR30021 |
Add property performTrimOnObjectKeyValue to JDBC
inbound ActivationSpec.
|
| Symptom:
JDBC adapter always performs trimming on
object key value even users don't hope so.
|
| Resolution:
Fixed. Now users can configure property
performTrimOnObjectKeyValue to turn on/off
the trimming of object key
|
|
| 40 | 6.1.0.2 | 75639 | JR29817 |
JDBC Adapter truncates precision of Timestamps
upon retrival from the Database.
|
| Symptom:
When the JDBC adpater retrives a Timestamp
from the database it and creates a Data
object it looses the original presission of
the Timestamp. The timestamps string from
database has the following format:
yyyy-mm-dd hh:mm:ss.fffffffff. The string
format used to create the Date object is of
format yyyy-mm-dd:hh:mm:ss.
|
| Resolution:
Fixed. Adapter now can handle type of
Timestamp parameter with the same value
input from Database.
|
|
| 41 | 6.1.0.2 | 75642 | JR29816 |
JDBC Adapter throws a Null Pointer exception
when a SQL-TYPE *LOB field is Null.
|
| Symptom:
The JDBC adapter does not have adequate null
value protection when retriving a SQL-TYPE
*LOB field from the Database. This can cause
a resource exception to be thrown when the
*LOB is null. The following error message
will occur:
com.ibm.websphere.sca.ServiceRuntimeException:
ResourceExceptionthrown in
J2CMethodBindingImpl.invoke()
javax.resource.ResourceException:
javax.resource.ResourceException:
java.lang.NullPointerException
|
| Resolution:
Fixed. Adapter now can handle SQL-TYPE *LOB
parameters with null value input from
Database.
|
|
| 42 | 6.1.0.2 | 75640 | JR29815 |
JDBC Adapter throws invalid parameter exception
when query BO field is SQL-TYPE *LOB.
|
| Symptom:
The JDBC adapter fails to create the BO
based on the ResultSet returned for a query
BO with SQL-TYPE *LOB. The following error
message is returned from the database:
javax.resource.ResourceException:
[ibm][db2][jcc][10143][10845] Invalid
parameter 1: Parameter is not set nor
registered.,errorcode: -99999
|
| Resolution:
Fixed. Adapter now can handle SQL-TYPE *LOB
parameter in query BO fields.
|
|
| 43 | 6.1.0.2 | 75697 | JR29965 |
JDBC Adapter commit failed for Type CHAR BIT.
|
| Symptom:
The JDBC adapter fails to create the BO
based on the ResultSet returned for a query
BO with ByteArray type ASI. The following
error message is returned from the database:
javax.resource.ResourceException:
com.ibm.db2.jcc.b.SqlException:
[ibm][db2][jcc][10145][10897] Invalid
parameter 3: Parameter index is out of
range.
|
| Resolution:
Fixed. Adapter now can handle type of
ByteArray parameter with the same value
input from Database.
|
|
| 44 | 6.1.0.2 | 75560 | JR29818 |
Adapter throws StringIndexOutofBoundException
when used to discover COBOL stored procedures
having parameters without any names.
|
| Symptom:
The JDBC adapter External Service Discovery
Wizard does not display the parameters for
Cobol Stored procedures having parameters
with no names. During the "Configuration
Properties for 'sp_name'" step, the
parameters are not displayed so user cannot
enter sample values and hence the validation
of stored procedure fails. If the user
proceeds with the ESD they encounter a
StringIndexOutOfBounds exception. The
adapter is expecting valid parameter names
to be returned from the metadata call to the
database. In DB2, SQL stored procedures are
required to define parameter names when they
are added into the database. Parameter names
are optional in DB2 for stored procedures
written in various other languages including
Cobol. The issue arises when the target
stored procedure does not have a parameter
name specified in their DDL.
|
| Resolution:
Fixed. In the ESD, adapter now displays
dummy names for the parameters which don't
have name so that user can provide sample
values for the parameters and validate the
stored procedure before proceeding with ESD.
|
|
| 45 | 6.1.0.2 | 75536 | JR29677 |
Empty wrapper business object is generated for
no primary key table.
|
| Symptom:
For no primary key table, empty wrapper
business object is generated even user
selects some primary keys in external
service discovery.
|
| Resolution:
Fixed. External service discovery can
generate the wrapper business object for no
primary key table.
|
|
| 46 | 6.1.0.2 | 75532 | JR29641 |
Adapter failed to handle array type input
parameter in StoredProcedure type Business
Object.
|
| Symptom:
If user put several different values in the
array type input parameter, all the values
in the array are replaced by the last one.
|
| Resolution:
Fixed. Adapter now can handle array type
input parameter
|
|
| 47 | 6.1.0.2 | 75548 | JR29757 |
Adapter throws DataBindingException while
processing stored procedures with no parameters.
|
| Symptom:
The adapter throws DataBindingException -
"Failed to initialize curosr" when
processing stored procedure with no
parameters. This exeption may also be thrown
when the generated business object does not
contain any attributes.
|
| Resolution:
Fixed. Adapter now correctly processes
stored procedures with no parameters.
|
|
| 48 | 6.1.0.2 | 75538 | JR29679 |
Database vendor property on "Service generation
and deployment configuration" screen has wrong
value.
|
| Symptom:
The adapter Enterprise service discovery
does not retain the database vendor name
selected by user on the "Connection
information" screen. So the database vendor
property value on the "Service generation
and deployment configuration" screen is not
always correct.
|
| Resolution:
Fixed. Adapter now correctly sets the value
for database vendor property.
|
|
| 49 | 6.1.0.2 | 75537 | JR29680 |
NullPointerException when handling BLOB data.
|
| Symptom:
The adapter throws NullPointerException at
runtime while processing resultset
containing BLOB column returned from stored
procedure execution when the data for BLOB
column is null.
|
| Resolution:
Fixed. Adapter now correctly processes BLOB
datatypes.
|
|
| 50 | 6.1.0.2 | 75539 | JR29681 |
The adapter fails to execute stored procedure
with parameters of type decimal.
|
| Symptom:
During External service discovery, when user
selects a COBOL stored procedure having
parameter of type decimal, then on the
configuration properties screen, adapter
incorrectly sets the datatype for that
parameter as String. So the validation of
the stored procedure fails and the artifacts
may not be generated correctly on completion
of discovery wizard.
|
| Resolution:
Fixed. Adapter now correctly processes
decimal datatypes.
|
|
| 51 | 6.1.0.2 | 96402 | JR29391 |
The adapter does not discover stored procedure
schemas during external service discovery when
connected to DB2 on z/OS.
|
| Symptom:
When you run the external service discovery
wizard to connect to DB2 on z/OS and click
Run Query on Object Selection and Discovery
screen, adapter may not display the complete
list of schemas. Adapter invokes
getSchemas() api on the JDBC driver to get
the list of schemas but for DB2 on z/OS,
getSchemas() api does not return procedure
schemas. In order to retrieve procedure
schemas, you need to click Edit Query button
and then check the "Discover stored
procedures pertaining to stored procedure
schemas" property. Then click Run Query to
see the complete list of schemas.
|
| Resolution:
Fixed. Adapter now displays the complete
list of schemas.
|
|
| 52 | 6.1.0.2 | 96397 | JR29386 |
The adapter generates ClassCastException at
runtime while processing complex datatypes
returned from stored procedure execution
|
| Symptom:
While processing Oracle stored procedures
which return complex datatypes like STRUCT
and VARRAY, adapter generates
ClassCastException. This exeption is
generated when adapter is configured to use
datasource JNDI property set on the managed
connection factory instance.
|
| Resolution:
Fixed. Adapter now correctly processes
stored procedures which return complex
datatypes even when adapter is configured to
use datasource JNDI property.
|
|
| 53 | 6.1.0.1 | 95701 | JR28449 |
The adapter fails to execute stored procedures
which return resultsets containing unnamed
columns.
|
| Symptom:
While processing stored procedures which
return resultsets, adapter expects queries
for the resultset to contain names for all
the columns in the query. When the stored
procedure contains queries that do not have
column names - for example, SELECT COUNT(*)
FROM CUSTOMER - adapter would fail to
process these resultsets, and generate
NullPointerException.
|
| Resolution:
Fixed. Some databases such as Oracle return
dummy names for the unnamed columns in the
resultset query. In such case, adapter will
use the column name returned by the database
while generating business objects. When the
databases do not return a dummy name, the
adapter assigns dummy names like DCOL1,
DCOL2, and so on, which is used in
generation of the stored procedure business
object.
|
|
| 54 | 6.1.0.1 | 96203 | JR29104 |
JDBC adapter would fail the execution of SPs on
some instances of MSSQL 2005
|
| Symptom:
When queried from the adapter, some
instances of MSSQL2005 would not return a
RETURN_VALUE parameter with stored
procedures metadata.
|
| Resolution:
Fixed. The query from the adapter for
metadata has been modified in order that
stored procedures on any of the databases
return all parameters.
|
|
| 55 | 6.1.0.1 | 96054/96163 | JR29067 |
JDBC adapter throws invalid data conversion
error while executing a stored procedure which
returns a resultset
|
| Symptom:
When JDBC adapter is used to execute a
stored procedure which returns a resultset
containing columns of type int or Date, then
you could see NumberFormatException thrown
by the adapter. Also you could see
SQLException with the message invalid data
conversion: Wrong result column type for
requested conversion.
|
| Resolution:
Fixed. Adapter now correctly processes
stored procedures returning resultsets which
contain columns with different data types.
|
|
| 56 | 6.1.0.1 | 96166 | |
JDBC adapter throws invalid column index while
using stored procedure for custom event
processing.
|
| Symptom:
During inbound processing, when JDBC adapter
is configured to use stored procedure for
custom event processing then you may see
SQLException with a message "Invalid column
index" being thrown from the adapter.
|
| Resolution:
Fixed. Adapter now correctly processes
events when configured to use stored
procedure for custom event processing. For
Oracle database, the first parameter of the
stored procedure should be an output
parameter of type resultset containing the
event information and the second parameter
should be an input parameter of type
integer. At runtime, adapter will set the
poll quantity value on this parameter.
|
|
| 57 | 6.1.0.1 | 96179 | |
JDBC adapter throws NullPointerException while
processing a stored procedure associated with a
business object
|
| Symptom:
During inbound processing, when JDBC adapter
is configured to use associated stored
procedures with business objects, then while
processing the stored procedures, adapter
throws NullPointerException.
|
| Resolution:
Fixed. Adapter now correctly processes
associated stored procedures during inbound
processing.
|
|
| 58 | 6.1.0.1 | 88947 | JR26628 |
The JDBC adapter retrieves incorrect data for
child objects when a parent business object
contains two single cardinality children with
foreign keys referring to the same attribute.
|
| Symptom:
When a business object contains two child
objects of the same type representing
foreign keys to the same table, the adapter
retrieves two instances of the last child
object, rather than one of each.
|
| Resolution:
Fixed. The adapter correctly retrieves the
data for single cardinality children.
|
|
| 59 | 6.1.0.0_IF04 | 96205 | JR29126 |
Retrieve operation on the wrapper business
object does not return child objects .
|
| Symptom:
Retrieve operation on wrapper business
object does not recursively retrieves data
for child business objects. .
|
| Resolution:
The adapter correctly retrieves the data for
single cardinality children.
|
|