bs:dataresource-master-setサンプル
共通化されたリソース定義ファイルのサンプルです。
bs:dataresource-master-setサンプル
(『<biz-Stream_home>/sample/xml/datasource-master/datasource-masterSample1-doc.xml
』)
<?xml version="1.0" encoding="UTF-8"?>
<!-- XML file created by biz-Stream Designer -->
<!-- biz-Stream Copyright BrainSellers.com Corp. -->
<fo:root xmlns:fo="http://www.w3.org/1999/XSL/Format" xmlns:pdf="http://www.brainsellers.com/schema" xmlns:svg="http://www.brainsellers.com/schema" xmlns:bs="http://www.brainsellers.com/schema" xmlns:form="http://www.brainsellers.com/schema" version="5.0.0">
<bs:datasource-master-set>
<bs:datasource-master master-name="DataSource" position="inherit">
<bs:query-master-reference master-reference="SQL-DB2"/>
<bs:query-master-reference master-reference="SQL-Oracle"/>
</bs:datasource-master>
<bs:database-resource-master master-name="RDB-DB2" driver="com.ibm.db2.jcc.DB2Driver" url="jdbc:db2://brain_db:50000/SAMPLE" userid="administrator" password="ZGIyYWRtaW4= "/>
<bs:database-resource-master master-name="RDB-Oracle" driver="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@brain_db:1521:XE" userid="scott" password="dGlnZXI="/>
<bs:query-master master-name="SQL-DB2">
<bs:query-statement master-reference="RDB-DB2">select STAFF.ID,STAFF.NAME from STAFF where (STAFF.ID < 100) </bs:query-statement>
<bs:data-type column-name="ID" type="char"/>
<bs:data-type column-name="NAME" type="varchar"/>
<!-- TableName = STAFF AliasTableName = STAFF FieldName = ID TOTAL = SORT = ExtractionCnditions = orStr = < 100 type = char
TableName = STAFF AliasTableName = STAFF FieldName = NAME TOTAL = SORT = ExtractionCnditions = orStr = type = varchar
-->
</bs:query-master>
<bs:query-master master-name="SQL-Oracle">
<bs:query-statement master-reference="RDB-Oracle">select EMP.EMPNO,EMP.ENAME from EMP where (EMP.EMPNO >= 7800) </bs:query-statement>
<bs:data-type column-name="EMPNO" type="integer"/>
<bs:data-type column-name="ENAME" type="varchar"/>
<!-- TableName = EMP AliasTableName = EMP FieldName = EMPNO TOTAL = SORT = ExtractionCnditions = orStr = >= 7800 type = decimal
TableName = EMP AliasTableName = EMP FieldName = ENAME TOTAL = SORT = ExtractionCnditions = orStr = type = varchar
-->
</bs:query-master>
</bs:datasource-master-set>
<fo:layout-master-set>
<fo:simple-page-master master-name="A4" page-height="297mm" page-width="210mm">
<fo:region-body/>
</fo:simple-page-master>
</fo:layout-master-set>
<fo:page-sequence master-reference="A4" bs:local-page-control="none">
<fo:flow flow-name="xsl-region-body">
<bs:block-container>
<bs:include href="${base-dir}/sample/xml/datasource-master/datasource-masterSample1-page.xml"/>
</bs:block-container>
</fo:flow>
</fo:page-sequence>
</fo:root>
