Example "Context" for Microsoft SQL Server 2000

The following "context" sections can be used to define a connection to Microsoft SQL Server database:

Using Microsoft JDBC Driver

	<context name="SQLServer">
		<description>MS-SQL Server</description>
		<hasSetupTables>true</hasSetupTables>
		<jdbc driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" 
			url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=[DatabaseName];SelectMethod=cursor" 
			connectFormat="1" login="login" password="password" 
			dateSelectFormat="dd-MM-yyyy" dateUpdateFormat="dd-MM-yyyy" 
			dateTimeSelectFormat="yyyy-MM-dd HH:mm:ss" dateTimeUpdateFormat="yyyy-MM-dd HH:mm:ss" 
			cache="y" createTableIndicies="true" limitationPosition="" 
			skipText="true"
			 escapeHandler="com.jcorporate.expresso.core.db.DoubleQuoteEscapeHandler">
			<dbWildcard>%</dbWildcard>
			<dbWildcard>*</dbWildcard>
		</jdbc>
		<type-mapping>
			<java-type>LONGVARCHAR</java-type>
			<expresso-type>text</expresso-type>
			<db-type>text</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>DATE</java-type>
			<db-type>datetime</db-type>
		</type-mapping>
		<type-mapping>
			<java-type>datetime</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>
		<type-mapping>
			<java-type>TIMESTAMP</java-type>
			<db-type>datetime</db-type>
		</type-mapping>
		<images>%context%/%expresso-dir%/images</images>
		<startJobHandler>y</startJobHandler>
		<showStackTrace>y</showStackTrace>
		<mailDebug>n</mailDebug>
	</context>

Using TDS Driver Configuration:

<context name="default">

    <description>MS SQL Server 2000</description>

    <jdbc

 driver="com.thinweb.tds.Driver"

 url="jdbc:twtds:sqlserver://<host>:1433/EXPRESSO"

 connectFormat="1"

 login="expresso"

 password="expresso"

 dateSelectFormat="dd-MM-yyyy"

 dateUpdateFormat="dd-MM-yyyy"

 dateTimeSelectFormat="yyyy-MM-dd"

 dateTimeUpdateFormat="yyyy-MM-dd"

 cache="y">



 <dbWildcard>%</dbWildcard>

 <dbWildcard>*</dbWildcard>

    </jdbc>

    <type-mapping>

 <java-type>LONGVARCHAR</java-type>

 <expresso-type>text</expresso-type>

 <db-type>text</db-type>

    </type-mapping>

    <images>%context%/%expresso-dir%/images</images>

    <startJobHandler>y</startJobHandler>

    <showStackTrace>y</showStackTrace>

    <mailDebug>n</mailDebug>

  </context>