HXTT ACCESS
��˾��DDL֧�ֲ�ȫ
Zhen Zhang
2006-11-19 10:03:12.0
��Ϊ��˾�������֧��alter table���޷������ҹ�˾Intergraph Deutschland GmbH��Ҫ��Ҫ���˸ò�Ʒ��
Re:��˾��DDL֧�ֲ�ȫ
HXTT Support
2006-11-19 15:40:14.0
֮����û�м�ʱ��������thread����Ϊalter table�Ѿ���ʼ���ˣ��<�3�����ã����ģ���
Good Service
Zhen Zhang
2006-11-20 02:09:23.0
�ڴ�绰֮ǰû�п����Ǹ��������Ϣ���������ϰ��ѹf��ʧȥ�����ģ��������½⡣
���ǵķ���ʵ����̫���ˡ������ǵĺ���Ϣ��
Re:Re:Re:��˾��DDL֧�ֲ�ȫ
HXTT Support
2006-11-22 07:54:58.0
v2.0.041 supports fully ALTER TABLE sql.
v2.0.041 supports DROP INDEX sql.
���}Сʱ�����ܹ����ظð汾��
Re:Re:Re:Re:��˾��DDL֧�ֲ�ȫ
Zhen Zhang
2006-11-27 03:11:01.0
�°汾֧�ֵ�create or alter table��ʹ��default��
Re:Re:Re:Re:Re:��˾��DDL֧�ֲ�ȫ
HXTT Support
2006-11-27 03:39:36.0
>��ʹ��default��
�﷨���ܹ�ʹ�ã����ǻᱻ���ԡ�
Re:Re:Re:Re:Re:Re:��˾��DDL֧�ֲ�ȫ
Zhen Zhang
2006-11-27 04:04:22.0
���ܺ���default��all testcases��ͨ����
Sample Error Message
Zhen Zhang
2006-11-27 04:06:21.0
testBitWithDefault(org.apache.ddlutils.io.TestDatatypes) Time elapsed: 0.203 sec <<< ERROR!
org.apache.ddlutils.DynaSqlException: org.apache.ddlutils.DynaSqlException: Error while executing SQL CREATE TABLE roundtrip
(
pk INTEGER NOT NULL,
avalue BIT DEFAULT FALSE NOT NULL,
PRIMARY KEY (pk)
)
at org.apache.ddlutils.TestDatabaseWriterBase.createDatabase(TestDatabaseWriterBase.java:237)
at org.apache.ddlutils.TestDatabaseWriterBase.createDatabase(TestDatabaseWriterBase.java:217)
at org.apache.ddlutils.io.TestDatatypes.performDataTypeTest(TestDatatypes.java:97)
at org.apache.ddlutils.io.TestDatatypes.performDataTypeTest(TestDatatypes.java:76)
at org.apache.ddlutils.io.TestDatatypes.testBitWithDefault(TestDatatypes.java:148)
Re:Re:Re:Re:Re:Re:Re:Re:��˾��DDL֧�ֲ�ȫ
HXTT Support
2006-11-27 05:17:36.0
At CREATE TABLE sql
constraint: [NULL| NOT NULL] [UNIQUE] [DEFAULT expression] [PRIMARY KEY]

The correct sql should be:
CREATE TABLE roundtrip ( pk INTEGER NOT NULL, avalue BIT NOT NULL DEFAULT FALSE , PRIMARY KEY (pk) ) ;


Re:Re:Re:Re:Re:Re:Re:Re:��˾��DDL֧�ֲ�ȫ
Zhen Zhang
2006-11-27 23:50:16.0
�������г���Ǿ�ʮ��test cases�е�һ����Ϊ�д󲿷ֲ����õ���Default��������Default�Ļ�����Щ���Զ�ͨ������ô�����������أ������һЩֻ��Щ�ؼ������еĴ������⣬��Щ�ҿ����Լ����
Re:Re:Re:Re:Re:Re:Re:Re:��˾��DDL֧�ֲ�ȫ
Zhen Zhang
2006-11-27 23:54:05.0
������д�ҵ����ģ�ûȥ��˾�ϰ࣬ȥ�˹�˾���ܸ�����Default���ԵĴ�����Ϣ��
Re:Re:Re:Re:Re:Re:Re:Re:��˾��DDL֧�ֲ�ȫ
Zhen Zhang
2006-11-29 00:22:24.0
�Ҳ鿴��һ�¹�˾�ṩ�ļ����ĵ�������δ�ᵽ�������(foreign key)֧�֡����֧���Ƿdz���Ҫ��һ��feature��������ҵJDBC driver������ȫ֧��DDL�������Ҫ������˾�IJ�Ʒ������ȫ֧��DDL(Database Defintion Language)�����ǹ�˾���м���������
Apache DdlUtils�IJ����ļ�TestDatatypes.java�ܹ��о�ʮ��test cases��������һ�²��ԣ������û��һ����ͨ��ġ�Ȼ��˼����ɴ����ԭ������Ļظ���ָ��ģ�����һ���ִ���4������д�Ĵ��룬������һ������4���ڹ�˾�IJ�Ʒ�����磬CREATE TABLE roundtrip ( pk INTEGER NOT NULL, avalue BIT NOT NULL DEFAULT FALSE , PRIMARY KEY (pk) )���һ�ű?INSERT...INTO...����һ���С�����Default��ɶ�Ӧ��avale����õ�������false����ص�ֵnull������testBitWithDefault�޷�ͨ��ͬ�����NOT NULLҲ�Dz��Բ�ͨ���ԭ��֮һ��
��ĿǰΪֹ�Ҳ������˾�IJ�Ʒ��������Щʲô��Ҫfeatures��ֻ����test cases4����ˡ�
��˾�������Щ�����أ�
Re:Re:Re:Re:Re:Re:Re:Re:��˾��DDL֧�ֲ�ȫ
HXTT Support
2006-11-29 01:30:18.0
Default֧��������Ӧ��24Сʱ����á�

>����Default��ɶ�Ӧ��avale����õ�������false����ص�ֵnull
����Ѿ�����

>���֧���Ƿdz���Ҫ��һ��feature
���ÿ������һ����
Re:Re:Re:Re:Re:Re:Re:Re:��˾��DDL֧�ֲ�ȫ
Zhen Zhang
2006-11-29 01:56:00.0
��һ��ͻ�Ҫ��JDBC driver�ṩ�����DDL֧�֣����ǹ�˾�����е�һԱ�����ǹ�˾�ἰʱ��!���˾��Ʒ(HXTT ACCESS)�йص���Ϣ����ò�Ʒȱ����Щ��Ҫ�Ĺ��ܡ���˾�����ڸĽ��Լ��IJ�Ʒ��һ���������ҹ�˾����Ҫ����һ��������˲�Ʒ���µľ���f�����ǹ�˾���ص��Dz�Ʒ���ṩ�Ĺ��ܣ����繦�ܵ������Ժ��ȶ��ԣ��Լ��ۺ���񣬶�۸�ֻ�Ǵ�Ҫ�ġ�˫Ӯ������}�ҹ�˾��ͬĿ�ꡣлл����һֱ��4��Ŭf��ġ�
Re:Re:Re:Re:Re:Re:Re:Re:��˾��DDL֧�ֲ�ȫ
HXTT Support
2006-11-29 02:01:45.0
HXTT�Ѿ�Ŭf�ṩ��8�����ҵ�����ͻ�����ķ���лл��˾����⡢֧�ּ����顣
Re:Re:Re:Re:Re:Re:Re:Re:��˾��DDL֧�ֲ�ȫ
HXTT Support
2006-11-29 22:55:51.0
Default�Ѿ�֧�֣�}��Сʱ����ã���
Re:Re:Re:Re:Re:Re:Re:Re:��˾��DDL֧�ֲ�ȫ
HXTT Support
2006-11-29 22:59:48.0
>���֧���Ƿdz���Ҫ��һ��feature
��v2.0.035���supports cascading updates and cascading deletes of MS Access.
getImportKeys��getExportedKeysҲ������4�����MS Access�ж���õ�����Ŀǰû��֧�������﷨��
Re:Re:Re:Re:Re:Re:Re:Re:��˾��DDL֧�ֲ�ȫ
Zhen Zhang
2006-11-29 23:26:02.0
ʲôʱ�����֧�������﷨�أ�
Re:Re:Re:Re:Re:Re:Re:Re:��˾��DDL֧�ֲ�ȫ
HXTT Support
2006-11-30 00:48:27.0
>ʲôʱ�����֧�������﷨�أ�
�ȵò���Oracle,Mysql֮����﷨�����﷨������Ҳ�����Ὠ����߷���Ȼ��Ż�ʵ�ָù��ܡ������µ�Access JDBC30���Ѿ����������ˡ�
Re:Re:Re:Re:Re:Re:Re:Re:��˾��DDL֧�ֲ�ȫ
Zhen Zhang
2006-11-30 02:42:17.0
>�ȵò���Oracle,Mysql֮����﷨�����﷨������Ҳ�����Ὠ����߷���
Ҳ������MS JET SQL���µ��﷨�������ݿ⳧��Ϊ�Լ�����һ�׹���Ҫͳһ���ѵġ���ò���SQL92��׼�ﶨ�µĹ���

���֪��HXTT ACCESS�İ汾���أ�
Re:Re:Re:Re:Re:Re:Re:Re:��˾��DDL֧�ֲ�ȫ
HXTT Support
2006-11-30 07:57:00.0
>���֪��HXTT ACCESS�İ汾���أ�
java -cp Access_JDBC30.jar com.hxtt.sql.access.AccessDriver

���⿴manifest.MF�ļ�Ҳ����֪�!�
Re:Re:Re:Re:Re:Re:Re:Re:��˾��DDL֧�ֲ�ȫ
Zhen Zhang
2006-12-01 02:50:16.0
�������ű���DdlUtils��SQL Server��������п��ܵĻ�������HXTT ACCESS������
DdlUtils can create a database via JDBC: no
DdlUtils can drop a database via JDBC: no
The database requires NULL when no default value is specified: no
The database supports default values for LONG types: yes
Primary key definitions are embedded in the table definition: yes
Foreign key definitions are embedded in the table definition: no
Index definitions are embedded in the table definition: no
The database supports non-unique indices: yes
IDENTITY specification: IDENTITY (1,1)
The IDENTITY (auto-increment) specification is supported for non-primary key columns: yes
SQL comments are supported: yes
Delimited identifiers are supported: yes
Maximum identifier length: 128
Delimiter token: Double quote char "
Quote character: Single quote char '
Comment format: Single line starting with --
Re:Re:Re:Re:Re:Re:Re:Re:��˾��DDL֧�ֲ�ȫ
HXTT Support
2006-12-01 03:14:07.0
DdlUtils can create a database via JDBC: yes
DdlUtils can drop a database via JDBC: no
The database requires NULL when no default value is specified: no
The database supports default values for LONG types: yes
Primary key definitions are embedded in the table definition: yes
Foreign key definitions are embedded in the table definition: no
Index definitions are embedded in the table definition: yes
The database supports non-unique indices: yes
IDENTITY specification: INT IDENTITY
The IDENTITY (auto-increment) specification is supported for non-primary key columns: yes
SQL comments are supported: yes
Delimited identifiers are supported: yes
Maximum identifier length: 64
Delimiter token: Double quote char "
Quote character: Single quote char '
Comment format: 1. Single line starting with -- 2. #one-line comment 3. /*multiline comment*/


Google