<?xml version="1.0" encoding="UTF-8" ?>

<JDBrowser>
<Setup
	Height="400" Width="800" X="30" Y="10"
	rowset="com.sun.rowset.CachedRowSetImpl">
	<Font name="Monospaced" size="12" style="PLAIN"/>
</Setup>
<Java
	package="jp.co.sds_corp.foo"
	util_package="jp.co.sds_corp.util">
	<audit_column column="update_date"/>
</Java>
<CSV
	columnSeparator="\t"
	rowSeparator="\n" />
<Document
	type="Excel"
	template="table.xls"
	sheet="Sheet1">>
	<Script language="JavaScript"
		debug="true">
var now = new java.util.Date();
var fmt = new java.text.SimpleDateFormat( "yyyy/MM/dd" );
Report.setCell( "F2", fmt.format( now ));
Report.setCell( "E4", bean.table );

for ( i = 0; i &lt; bean.list.size(); i++ ) {
	var data = bean.list.get( i );
	Report.addRow( 6+i, 6 );

	Report.setCell( 1, 6+i, i+1 );
	Report.setCell( 2, 6+i, data.remarks );
	Report.setCell( 3, 6+i, data.name );
	Report.setCell( 4, 6+i, data.type );
	if ( data.needPrecision()) {
		Report.setCell( 5, 6+i, data.precision );
		if ( data.needScale()) {
			Report.setCell( 6, 6+i, data.scale );
		} else {
			Report.setCell( 6, 6+i, "" );
		}
	} else {
		Report.setCell( 5, 6+i, "" );
		Report.setCell( 6, 6+i, "" );
	}
	if ( data.isKey()) {
		Report.setCell( 7, 6+i, "○" );
	} else {
		Report.setCell( 7, 6+i, "" );
	}
	Report.setCell( 8, 6+i, " " );
	if (( i % 5 ) == 4 ) {
		Report.endPage();
	}
}
	</Script>
</Document>

<Connection>
<!-- Jdbc-Odbc Bridge -->
<db name="odbc">
	<driver>sun.jdbc.odbc.JdbcOdbcDriver</driver>
	<url>jdbc:odbc:DataSourceName</url>
	<user>user</user>
	<password>password</password>
</db>

<!-- Sybase -->
<db name="sybase">
	<jar>../jdbc/jconn2.jar</jar>
	<driver>com.sybase.jdbc2.jdbc.SybDriver</driver>
	<url>jdbc:sybase:Tds:192.168.0.1:4100/DB</url>
	<user>user</user>
	<password>password</password>
	<system_date>getdate()</system_date>
</db>

<!-- Oracle -->
<db name="oracle">
	<jar>../jdbc/ojdbc14.jar</jar>
	<driver>oracle.jdbc.driver.OracleDriver</driver>
	<url>jdbc:oracle:thin:@192.168.0.1:1521:SID</url>
	<user>user</user>
	<password>password</password>
	<schema>DB</schema>
	<system_date>sysdate</system_date>
	<rowset>oracle.jdbc.rowset.OracleCachedRowSet</rowset>
	<selectcomment>SELECT COMMENTS FROM USER_COL_COMMENTS WHERE TABLE_NAME='$TABLE' AND COLUMN_NAME='$COLUMN'</selectcomment>
	<updatecomment type="update">COMMENT ON COLUMN $TABLE.$COLUMN IS '$COMMENT'</updatecomment>
</db>

<!-- Postgres -->
<db name="postgres">
	<jar>../jdbc/postgresql-8.2-507.jdbc3.jar</jar>
	<driver>org.postgresql.Driver</driver>
	<url>jdbc:postgresql://192.168.0.1:5432/DB</url>
	<user>user</user>
	<password>pasword</password>
	<schema>DB</schema>
	<system_date>currentTimestamp</system_date>
	<updatecomment type="update">COMMENT ON COLUMN $TABLE.$COLUMN IS '$COMMENT'</updatecomment>
</db>

<!-- MySQL -->
<db name="mysql">
	<jar>../jdbc/mysql-connector-java-5.1.5-bin.jar</jar>
	<driver>com.mysql.jdbc.Driver</driver>
	<url>jdbc:mysql://192.168.0.1:3306/DB</url>
	<user>user</user>
	<password>pasword</password>
	<catalog>CATALOG</catalog>
	<schema>DB</schema>
	<system_date>now()</system_date>
	<updatecomment type="create">COMMENT '$COMMENT'</updatecomment>
</db>

<!-- HSQLDB -->
<db name="hsql">
	<jar>${user.home}/lib//hsqldb.jar</jar>
	<driver>org.hsqldb.jdbcDriver</driver>
	<url>jdbc:hsqldb:file:hsql.db</url>
	<user>sa</user>
	<password></password>
	<system_date>CURRENT_TIMESTAMP</system_date>
</db>

</Connection>

</JDBrowser>
