[Opensource] Using Sybase ASE for Expresso Tables

[Diego Vargas]

Malcolm Wise escribió:
> 
> 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
> *************************************************************************
> _______________________________________________
> Opensource mailing list
> Opensource at jcorporate.com
> http://mail.jcorporate.com/mailman/listinfo/opensource
> Archives: http://mail.jcorporate.com/pipermail/opensource/
Dear Malcolm
Ive been working on setup Expresso with Sybase, the main trouble is that
Expresso has some DATA TYPES which are not supported by SYBASE, I
recommend to you generate the scripts of  TABLES CREATION (just which
has problems) manually.
Sybase supports sysname but just until sysname (30) so if u found a
sysname (40), u must to replace it by VARCHAR(40)
this is the main trouble
I wish you Success
Diego Vargas