[Opensource] Using Sybase ASE for Expresso Tables

[Malcolm Wise]

Hi,

I'm hitting problems trying to use Sybase ASE12 to hold Expresso's setup
tables.  Here's my <context> from expresso-config.xml:

  <context name="default">
    <description>Expresso</description>
    <jdbc
        driver="com.sybase.jdbc2.jdbc.SybDriver"
	url="jdbc:sybase:Tds:EXCALDEV01:5000/expresso"
	connectFormat="1"
	login="fred"
	password="bloggs"
	cache="y"
	useNullOnCreate="y"/>
    <type-mapping>
		<expresso-type>auto-inc</expresso-type>
		<db-type>NUMERIC(10,0) IDENTITY</db-type>
    </type-mapping>
    <type-mapping>
		<expresso-type>text</expresso-type>
		<db-type>TEXT</db-type>
    </type-mapping>
    <type-mapping>
		<expresso-type>char</expresso-type>
		<db-type>CHAR</db-type>
    </type-mapping>
    <type-mapping>
		<java-type>LONGVARCHAR</java-type>
		<db-type>TEXT</db-type>
    </type-mapping>
    <type-mapping>
		<java-type>VARCHAR</java-type>
		<db-type>VARCHAR</db-type>
    </type-mapping>
    <type-mapping>
		<java-type>DATE</java-type>
		<db-type>DATETIME</db-type>
    </type-mapping>
    <type-mapping>
		<java-type>TIME</java-type>
		<db-type>TIME</db-type>
    </type-mapping>
    <type-mapping>
	   <java-type>FLOAT</java-type>
	   <db-type>FLOAT</db-type>
    </type-mapping>
    <type-mapping>
	   <java-type>DECIMAL</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>

As you can see, I've added some <expresso-type> mappings, but these seem to
get completely ignored (is that because they already exist and I can only
define new ones?).  Also, at least one table (DOWNLOADFILES) specifies a BIT
column that allows nulls - unfortunately, Sybase doesn't!  I've used the
'useNullOnCreate' attribute because the default setup tries to insert a null
value into  the USERGROUP table later on down the line.
Has anyone managed to get Expresso set up on Sybase?  I'd be grateful for
any pointers!

TIA

Malcolm Wise
Technology Manager
Semiconductor & Devices Europe
Tel. +44(0)1256 388864
http://www.semiconductor.sony-europe.com



*************************************************************************
The information contained in this message or any of its
attachments may be privileged and confidential and intended 
for the exclusive use of the addressee. If you are not the
addressee any disclosure, reproduction, distribution or other
dissemination or use of this communication is strictly prohibited
*************************************************************************