commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John E. Conlon" <jcon...@verticon.com>
Subject [sql] Sybase ddl problems
Date Sun, 02 Mar 2003 02:18:41 GMT
Having a couple of problems using sql to generate or execute Sybase ddl.  

1. The first is fairly easy.  Looks like a typo in
org.apache.commons.sql.builder.SybaseBuilder at line 96 is causing a line
to be created with erroneous syntax.  

println("IF EXISTS (SELECT 1 FROM sysobjects WHERE type ='RI' AND name=''"

at the end of the line name= should be followed by only one single quote
not two.

2. The second problem is that Sybase does not use a timestamp datatype.
This prevents one from using ddl like:

create table management
(
    time TIMESTAMP NOT NULL ,
    target VARCHAR NOT NULL ,
    status VARCHAR NOT NULL ,
    PRIMARY KEY (time, target)
);

and instead Sybase uses a datetime datatype so needs ddl like this:

create table management
(
    time datetime NOT NULL ,
    target VARCHAR NOT NULL ,
    status VARCHAR NOT NULL ,
    PRIMARY KEY (time, target)
);

Post generation editing of the ddl is really a kludge.  Any ideas?

thanks,
John
********************************************
John E. Conlon 
Verticon, Inc.
<mailto:jconlon@verticon.com>mailto:jconlon@verticon.com
<http://www.verticon.com/>http://www.verticon.com
tel: (608) 675-3865
cell: (608) 606-1292
********************************************



Mime
View raw message