[Opensource] Type Mapping SQL Server 2000.

[Michael Rimov]

At 10:07 PM 6/6/2002 -0300, you wrote:
>Hi,
>I'm trying to figure out the type mapping for SQL Server 2000.
>I'm using the MS JDBC driver.

Dave, I've been sent this as the current MS-SQL database config file that 
people are successfully using.  Can you verify that it does or does not work?

Thanks,

                                                         -Mike
0-0-0-0-0-0--0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-

<context name="default">
<description>MSSQL-expresso-intro</description>
<jdbc
driver="sun.jdbc.odbc.JdbcOdbcDriver"
url="jdbc:odbc:expresso-intro"
connectFormat="1"
login="sa"
password=""
dateSelectFormat="dd-MM-yyyy"
dateUpdateFormat="dd-MM-yyyy"
dateTimeSelectFormat="yyyy-MM-dd HH:mm"
dateTimeUpdateFormat="yyyy-MM-dd HH:mm"
cache="y"
createTableIndicies="true">
<dbWildcard>%</dbWildcard>
<dbWildcard>*</dbWildcard>
</jdbc>
<type-mapping>
<java-type>DATE</java-type>
<db-type>datetime</db-type>
</type-mapping>
<type-mapping>
<java-type>DOUBLE</java-type>
<db-type>NUMERIC</db-type>
</type-mapping>
<type-mapping>
<java-type>LONGVARCHAR</java-type>
<db-type>VARCHAR(1024)</db-type>
</type-mapping>
<type-mapping>
<java-type>INTEGER</java-type>
<db-type>int</db-type>
</type-mapping>
<type-mapping>
<java-type>NUMERIC</java-type>
<db-type>NUMERIC</db-type>
</type-mapping>
<images>%context%/%expresso-dir%/images</images>
<startJobHandler>y</startJobHandler>
<showStackTrace>y</showStackTrace>
<mailDebug>n</mailDebug>
</context>