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>