Zhen Zhang | 2006-11-19 10:03:12.0 | |
��Ϊ��˾�������֧��alter table���������ҹ�˾Intergraph Deutschland GmbH��Ҫ��Ҫ���˸ò�Ʒ�� | ||
HXTT Support | 2006-11-19 15:40:14.0 | |
֮����û�м�ʱ��������thread����Ϊalter table�Ѿ���ʼ���ˣ��<�3�����ã����ģ��� | ||
Zhen Zhang | 2006-11-20 02:09:23.0 | |
�ڴ�绰֮ǰû�п����Ǹ��������Ϣ���������ϰ��ѹf��ʧȥ�����ģ��������½⡣
���ǵķ���ʵ����̫���ˡ������ǵĺ���Ϣ�� | ||
HXTT Support | 2006-11-22 07:54:58.0 | |
v2.0.041 supports fully ALTER TABLE sql.
v2.0.041 supports DROP INDEX sql. ���}Сʱ�����ܹ����ظð汾�� | ||
Zhen Zhang | 2006-11-27 03:11:01.0 | |
�°汾֧�ֵ�create or alter table��ʹ��default�� | ||
HXTT Support | 2006-11-27 03:39:36.0 | |
>��ʹ��default��
����ܹ�ʹ�ã����ǻᱻ���ԡ� | ||
Zhen Zhang | 2006-11-27 04:04:22.0 | |
���ܺ���default��all testcases��ͨ���� | ||
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) | ||
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) ) ; | ||
Zhen Zhang | 2006-11-27 23:50:16.0 | |
�������г���Ǿ�ʮ��test cases�е�һ����Ϊ�дֲ����õ���Default��������Default�Ļ�����Щ���Զ�ͨ������ô�����������أ������һЩֻ��Щ�ؼ������еĴ������⣬��Щ�ҿ����Լ���� | ||
Zhen Zhang | 2006-11-27 23:54:05.0 | |
������д�ҵ����ģ�ûȥ��˾�ϰ࣬ȥ�˹�˾���ܸ�����Default���ԵĴ�����Ϣ�� | ||
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����ˡ� ��˾�������Щ�����أ� | ||
HXTT Support | 2006-11-29 01:30:18.0 | |
Default֧��������Ӧ��24Сʱ����á�
>����Default��ɶ�Ӧ��avale����õ�������false����ص�ֵnull ����Ѿ����� >���֧���Ƿdz���Ҫ��һ��feature ���ÿ������һ���� | ||
Zhen Zhang | 2006-11-29 01:56:00.0 | |
��һ��ͻ�Ҫ��JDBC driver�ṩ�����DDL֧�֣����ǹ�˾�����е�һԱ�����ǹ�˾�ἰʱ��!���˾��Ʒ(HXTT ACCESS)�йص���Ϣ����ò�Ʒȱ����Щ��Ҫ�Ĺ��ܡ���˾�����ڸĽ��Լ��IJ�Ʒ��һ���������ҹ�˾����Ҫ����һ��������˲�Ʒ���µľ���f�����ǹ�˾���ص��Dz�Ʒ���ṩ�Ĺ��ܣ����繦�ܵ������Ժ��ȶ��ԣ��Լ��ۺ����۸�ֻ�Ǵ�Ҫ�ġ�˫Ӯ������}�ҹ�˾��ͬĿ�ꡣлл����һֱ��4��Ŭf��ġ� | ||
HXTT Support | 2006-11-29 02:01:45.0 | |
HXTT�Ѿ�Ŭf�ṩ��8�����ҵ�����ͻ�����ķ���лл��˾����⡢֧�ּ����顣 | ||
HXTT Support | 2006-11-29 22:55:51.0 | |
Default�Ѿ�֧�֣�}��Сʱ����ã��� | ||
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�ж���õ�����Ŀǰû��֧��������� | ||
Zhen Zhang | 2006-11-29 23:26:02.0 | |
ʲôʱ�����֧��������أ� | ||
HXTT Support | 2006-11-30 00:48:27.0 | |
>ʲôʱ�����֧��������أ�
�ȵò���Oracle,Mysql֮���������������Ҳ�����Ὠ����߷���Ȼ��Ż�ʵ�ָù��ܡ������µ�Access JDBC30���Ѿ����������ˡ� | ||
Zhen Zhang | 2006-11-30 02:42:17.0 | |
>�ȵò���Oracle,Mysql֮���������������Ҳ�����Ὠ����߷���
Ҳ������MS JET SQL���µ���������ݿ⳧��Ϊ�Լ�����һ����Ҫͳһ���ѵġ���ò���SQL92���ﶨ�µĹ��� ���֪��HXTT ACCESS�İ汾���أ� | ||
HXTT Support | 2006-11-30 07:57:00.0 | |
>���֪��HXTT ACCESS�İ汾���أ�
java -cp Access_JDBC30.jar com.hxtt.sql.access.AccessDriver ���⿴manifest.MF�ļ�Ҳ����֪�!� | ||
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 -- | ||
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*/ |