Description Mike Norman 2011-09-27 15:21:09 EDT

Starting from the table below:
  CREATE TABLE SECONDARY (
    EMPNO NUMERIC(4),
    ENAME VARCHAR(10),
    JOB VARCHAR(9),
    MGR NUMERIC(4),
    HIREDATE DATE,
    SAL DECIMAL(7,2),
    COMM DECIMAL(7,2),
    DEPTNO NUMERIC(2),
    PRIMARY KEY (EMPNO) 
  )
build a CustomSQL operation with 'build' SQL:

<?xml version="1.0" encoding="UTF-8"?>
<dbws-builder xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <properties>
    <property name="projectName">@PROJECT@</property>
    <property name="logLevel">@LOG_LEVEL@</property>
    <property name="username">@DB_USER@</property>
    <property name="password">@DB_PASSWORD@</property>
    <property name="url">@DB_URL@</property>
    <property name="driver">@DB_DRIVER@</property>
    <property name="platformClassname">@DB_PLATFORM@</property>
    <property name="dataSource">@DATASOURCE@</property>
    <property name="wsdlLocationURI">@WSDL_LOCATION@</property>
  </properties>
  <sql
    name="allSecondary"
    isCollection="true"
    >
    <statement>select * from SECONDARY</statement>
    <build-statement>select * from SECONDARY where 0=1</build-statement>
</dbws-builder>

When DBWSBuilder get the JDBC metadata for the ResultSet of running
'select * from SECONDARY where 0=1', the jdbc type code for HIREDATE
is 93 (TIMESTAMP), not 91