ALDSP 3.0/3.2 Release Notes

org.apache.xmlbeans.XmlException: Thread AWT-EventQueue-0: The 0th supplied input is not a schema document: its type is N=
	at org.apache.xmlbeans.impl.schema.SchemaTypeSystemCompiler.compile(SchemaTypeSystemCompiler.java:211)
	at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at org.apache.xmlbeans.XmlBeans.compileXmlBeans(XmlBeans.java:667)
	at org.apache.xmlbeans.XmlBeans.compileXsd(XmlBeans.java:553)

java.sql.ResultSetMetadata.getColumnName()
java.sql.ResultSetMetadata.getColumnLabel()

ALTER PROCEDURE [wireless].[SP_SMALLMONEY_OUT] (  @P_ID VARCHAR(10),  @P_SMALLMONEY SMALLMONEY OUT
)
AS
BEGIN
SELECT @P_SMALLMONEY = C_SMALLMONEY
FROM ALL_DATATYPES
WHERE C_ID = @P_ID
END

234

The link to this application has not been implemented yet. Check this out later!

'Some characters cannot be mapped'

'Exception Message: 'Some characters cannot be mapped   'MS932'

<license-group format='1.0' product='AquaLogic Data Services Platform' release='3.0'>
   <license
      component='Data Services Runtime'
      cpus='unvalued'
      expiration='2008-01-28'
      ip='any'
      licensee='BEA Evaluation Customer'
      signature='ZgOAWQ...'
      type='EVAL'
      units='5'
   />
   <license
      component='Data Services Runtime'
      cpus='unvalued'
      expiration='2008-06-04'
      ip='any'
      licensee='BEA Evaluation Customer'
      serial='616351266349-2343532799844'
      signature='MC4CFQ...'
      type='EVAL'
      units='unlimited'
   />
</license-group>

The name 'getCustomerByIdResult' specified in javax.jws.WebResult is different to the XmlBean name of 'CUSTOMER'

validate {
   xquery expression
}

java.sql.SQLException: Invalid stored procedure reference:
ReportingToolCertDataServices.Xtreme.'Read
	at
com.bea.dsp.jdbc.exceptions.DSPExceptionFactory.create(DSPExceptionFactory.java:148)
	at
com.bea.dsp.jdbc.driver.CallableDSPStatementImpl.updateWithNamedParameters(CallableDSPStatementImpl.java:2913)

javax.naming.LinkException.

This project needs to migrate WTP metadata

<SomeElement>{ data($db_row/VARCHAR_COLUMN)}</SomeElement>

<SomeElement?>{ data($db_row/VARCHAR_COLUMN)}</SomeElement>

declare function tns:test($id1 as xs:string, $id2 as xs:string ){
let $order1 := tes:getOrder($id1)/OrderDetail

let $order2 :=
  for $x in tes:getOrder($id2)/OrderDetail
  return
    <ORDER>
       <ORDER_ID>{fn:data($x/stns:orderID)}</ORDER_ID>
    </ORDER>

  for $o1 in $order1
   return
      <ORDER>
	<ORDER_ID>{fn:data($o1/stns:orderID)}</ORDER_ID>
        <ORDER_DATE>{fn:data($o1/stns:orderDate)}</ORDER_DATE>
        <TOTAL_ORDER_AMOUNT>
           { fn:data($o1/stns:totalOrderAmount) }</TOTAL_ORDER_AMOUNT>
	<STATUS>
           { $order2[$o1/stns:orderDate = $o1/stns:estimatedShipDate] }</STATUS>
      </ORDER>
};

<xsd:import namespace="urn:test"   schemaLocation="profileView.xsd"/>

xquery version "1.0" encoding "WINDOWS-1252";
(::pragma xds <x:xds xmlns:x="urn:annotations.ld.bea.com" targetType="t:sqlQuery"
xmlns:t="ld:SY/datasource/TC_SQLWhereWithConstant/sqlQuery">
<creationDate>yyyy-mm-ddThh:mm:ss</creationDate>
<relationalDB name="datasource" providerId="Sybase-12.5.2"/>
<field xpath="FIRST_NAME" type="xs:string">
   <extension nativeXpath="FIRST_NAME" nativeType="varchar" nativeTypeCode="12" nativeSize="0"
      nativeFractionalDigits="0"/>\\
   <properties nullable="false"/>
</field>
<field xpath="LAST_NAME" type="xs:string">
   <extension nativeXpath="LAST_NAME" nativeType="varchar" nativeTypeCode="12" nativeSize="0"
      nativeFractionalDigits="0"/>\\
   <properties nullable="false"/>
</field>

SELECT t1.PRODUCT_ID, sum(t2.QUANTITY)
FROM PRODUCT t1 JOIN CUST_ORDER_LINE_ITEM_APPL t2 on (t1.PRODUCT_ID = t2.PRODUCT_ID)
GROUP by t1.PRODUCT_ID

SELECT t1.PRODUCT_ID as PRODUCT_ID, sum(t2.QUANTITY) as QUANTITY
FROM PRODUCT t1 JOIN CUST_ORDER_LINE_ITEM_APPL t2 on (t1.PRODUCT_ID = t2.PRODUCT_ID)
GROUP by t1.PRODUCT_ID

CREATE OR REPLACE PROCEDURE
MYPROCEDURE1(P_CHAR_OUT OUT CHAR)
...<procedure_body>...

java.lang.IllegalArgumentException: A type with this name
'ADDRESS_TYPE@urn:schemas-bea-com:ld-addr' already exists in this type system.
<ComponentHandler.handleRequest:115>
java.lang.IllegalArgumentException: A type with this name
'ADDRESS_TYPE@urn:schemas-bea-com:ld-addr' already exists in this type system.

org.apache.xmlbeans.XmlException: D:\Eclipse
Workspaces\DSPDemo\NEIM\Schema\lexs\lexs.xsd:54:5: error: Problem parsing referenced XML resource - D:\Eclipse
Workspaces\DSPDemo\NEIM\Schema\lexs\lexs-digest.xsd:689:1: error: Unexpected element: CDATA
at org.apache.xmlbeans.impl.schema.SchemaTypeSystemCompiler.compile(SchemaTypeSystemCompiler.java:225)

Exception in thread "main" java.lang.IncompatibleClassChangeError:
Implementing class
        at java.lang.ClassLoader.defineClass0(Native Method)
        at java.lang.ClassLoader.defineClass(ClassLoader.java:539)
        at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:123)

<result>
{
for $i in f1:DATA_TIMESTAMP_ZONE()
return
   <row>
      {$i/C_ID}
      {
      if (fn:data($i/C_TIMESTAMP_ZONE_3) instance of xs:dateTime) then
         <C_TIMESTAMP_ZONE_3>
            <type>TIMESTAMP_ZONE</type>
            <xmltype>xs:dateTime</xmltype>
            <data>{fn:data($i/C_TIMESTAMP_ZONE_3)}</data>
         </C_TIMESTAMP_ZONE_3>
      else
         <C_TIMESTAMP_ZONE_3></C_TIMESTAMP_ZONE_3>
      }
   </row>
}
</result>

<C_TIMESTAMP_ZONE_3>
   <type>TIMESTAMP_ZONE</type>
   <xmltype>xs:dateTime</xmltype>
   <data>1999-04-15T08:00:00-07:00</data>
</C_TIMESTAMP_ZONE_3>

<C_TIMESTAMP_ZONE_3>
   <type>TIMESTAMP_ZONE</type>
   <xmltype>xs:dateTime</xmltype>
   <data>1999-04-09T17:20:00+09:00</data>
</C_TIMESTAMP_ZONE_3>

declare namespace ns = "ld:test/RDBMS/OR-CR/DATA_NUMBER";
declare namespace ns1 = "ld:test/RDBMS/OR-CR/DATA_FLOAT";
declare namespace ns2 = "ld:test/RDBMS/OR-CR/DATA_NUMBER_N_S";
declare namespace ns3 = "ld:test/RDBMS/OR-CR/DATA_NUMBER_N";
declare variable $ext as xs:decimal external;

<result>
{
   <column>
   {
      let $x := for $y in ns:DATA_NUMBER()
      where ($y/C_ID  mod 2) ne 0
      return $y/C_NUMBER mod $y/C_ID
         return(
            <all>
               <test1>{$x}</test1>
               <sql>{fn-bea:get-sql($x)}</sql>
            </all>
         )
      }
   </column>
}
{
   <const>
   {
      let $x := for $y in ns1:DATA_FLOAT()
      where $y/C_ID gt ($y/C_FLOAT mod 2)
      return fn:concat( xs:string($y/C_ID), xs:string( 5 mod 4))
         return(
            <all>
               <test2>{$x}</test2>
               <sql>{fn-bea:get-sql($x)}</sql>
            </all>
         )
      }
   </const>
}
{
   <func>
   {
      let $x := for $y in ns2:DATA_NUMBER_N_S()
      where fn:string-length(xs:string($y/C_ID)) eq fn:abs( -5 mod 4)
      return fn:concat( xs:string($y/C_NUMBER_38_38 ), xs:string(4 mod 5))
         return(
            <all>
               <test3>{$x}</test3>
               <sql>{fn-bea:get-sql($x)}</sql>
            </all>
         )
      }
   </func>
}
{
   <join>
   {
      let $x:= for $y in ns:DATA_NUMBER()
      for $z in ns2:DATA_NUMBER_N_S()
      where $y/C_ID eq $z/C_ID
      return $y/C_NUMBER mod $z/C_NUMBER_38_38
         return(
            <all>
               <test1>{$x}</test1>
               <sql>{fn-bea:get-sql($x)}</sql>
            </all>
         )
   }
   </join>

}
{
   <orderby>
   {
      let $x:= for $y in ns:DATA_NUMBER()
      where true()
      order by $y/C_ID mod $y/C_NUMBER
      return $y/C_ID mod $y/C_NUMBER
         return(
            <all>
               <test1>{$x}</test1>
               <sql>{fn-bea:get-sql($x)}</sql>
            </all>
         )
      }
   </orderby>
}
</result>

<result><column><all><test1>1.1E-130 2.33</test1><sql>SELECT
MOD(t1.'C_NUMBER',CAST(t1.'C_ID' AS NUMBER)) AS c1
FROM 'CRM'.'DATA_NUMBER' t1
WHERE (MOD(t1.'C_ID',2) != 0)</sql></all></column><const><all><test2>11 21
31</test2><sql>SELECT (TO_CHAR(t1.'C_ID') || '1') AS c1
FROM 'CRM'.'DATA_FLOAT' t1
WHERE (CAST(t1.'C_ID' AS NUMBER) &gt;
MOD(t1.'C_FLOAT',2.0))</sql></all></const><func><all><test3>.123456789012345678901234567890123456784
.1234 .14</test3><sql>SELECT (TO_CHAR(t1.'C_NUMBER_38_38') || '4') AS c1
FROM 'CRM'.'DATA_NUMBER_N_S' t1
WHERE (NVL(LENGTH(TO_CHAR(t1.'C_ID')),0) =
1)</sql></all></func><join><all><test1>1.1E-130 -1.1E-30
0.03</test1><sql>SELECT MOD(t1.'C_NUMBER',CAST(t2.'C_NUMBER_38_38' AS
NUMBER)) AS c1
FROM 'CRM'.'DATA_NUMBER' t1
JOIN 'CRM'.'DATA_NUMBER_N_S' t2
ON (t1.'C_ID' = t2.'C_ID')</sql></all></join><orderby><all><test1>-INF
9.0E-31 0.67</test1><sql>SELECT MOD(CAST(t1.'C_ID' AS NUMBER),t1.'C_NUMBER')
AS c1
FROM 'CRM'.'DATA_NUMBER' t1
ORDER BY MOD(CAST(t1.'C_ID' AS NUMBER),t1.'C_NUMBER')
ASC</sql></all></orderby></result>

<result><column><all><test1>1.1E-130 2.33</test1><sql>SELECT
MOD(t1.'C_NUMBER',CAST(t1.'C_ID' AS NUMBER)) AS c1
FROM 'CRM'.'DATA_NUMBER' t1
WHERE (MOD(t1.'C_ID',2) != 0)</sql></all></column><const><all><test2>11 21
31</test2><sql>SELECT (TO_CHAR(t1.'C_ID') || '1') AS c1
FROM 'CRM'.'DATA_FLOAT' t1
WHERE (CAST(t1.'C_ID' AS NUMBER) &gt;
MOD(t1.'C_FLOAT',2.0))</sql></all></const><func><all><test3>.123456789012345678901234567890123456784
.1234 .14</test3><sql>SELECT (TO_CHAR(t1.'C_NUMBER_38_38') || '4') AS c1
FROM 'CRM'.'DATA_NUMBER_N_S' t1
WHERE (NVL(LENGTH(TO_CHAR(t1.'C_ID')),0) =
1)</sql></all></func><join><all><test1>1.1E-130 -1.1E-30
0.03</test1><sql>SELECT MOD(t1.'C_NUMBER',CAST(t2.'C_NUMBER_38_38' AS
NUMBER)) AS c1
FROM 'CRM'.'DATA_NUMBER' t1
JOIN 'CRM'.'DATA_NUMBER_N_S' t2
ON (t1.'C_ID' = t2.'C_ID')</sql></all></join><orderby><all><test1>0.0 9.0E-31
0.67</test1><sql>SELECT MOD(CAST(t1.'C_ID' AS NUMBER),t1.'C_NUMBER') AS c1
FROM 'CRM'.'DATA_NUMBER' t1
ORDER BY MOD(CAST(t1.'C_ID' AS NUMBER),t1.'C_NUMBER')
ASC</sql></all></orderby></result>

Caused by: weblogic.xml.query.exceptions.XQueryTypeException: [ad-hoc], line 3, column 39:
{err}XP0004: Invalid static type: {http://www.w3.org/2001/XMLSchema}hexBinary
   at
weblogic.xml.query.compiler.TypeMatchExpression.typeCheckNoCache(TypeMatchExpression.java:124)
   at weblogic.xml.query.compiler.Expression.typeCheck(Expression.java:308)

Custom tool error: Unable to import WebService/Schema.
Unable to import binding 'librarySoapBinding' from namespace 'ld:Logical/library_ws'.
Unable to import operation 'XqueryNoInputOutput'.
The element, XqueryNoInputOutputResponse, from namespace,
ld:Logical/library_ws, was imported in two different contexts: (StructMapping, MembersMapping).

ERROR: ld:JoinPattern/Logical/CustAddrCredit_1toM_1toM_Inner_Join.ds, line 9,
column 125: {err}XQ0046:
'ld:JoinPattern/Logical/schemas/ CUSTOMER_ADDRESS_CREDIT_INNER_JOIN.xsd':
illegal URI UpdatePattern/JoinPattern/Logical
CustAddrCredit_1toM_1toM_Inner_Join.ds	line 9	1188433233135	3403

EAR activation for dataspace '<name>' failed. Cause(s): - [Deployer:149156]
Illegal state for operation start: 'STATE_ACTIVE'

Caused by: com.bea.ld.wrappers.rdb.exceptions.RDBWrapperException: [ad-hoc],
line 10, column 1: {bea-err}RDBW0004: [ifrtl20ds]: [SELECT DISTINCT
t1.cc_type AS c1
FROM rtlall_20:informix.credit_card t1, rtlall_20:informix.address t2
WHERE ((t1.customer_id = t2.customer_id) AND (t1.exp_date >= {ts '2007-01-01
00:00:00'}) AND (t2.city = 'San Jose'))]:
Error executing SQL query: Extra characters at the end of a datetime or interval.
	at
com.bea.ld.wrappers.rdb.exceptions.RDBWrapperException.create(RDBWrapperException.java:81)