Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v5.0
  HXTT DBF v7.1
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.0
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT ACCESS
SQL Syntax
Zhen Zhang
2006-11-14 01:46:32
���,

�ҹ�˾Intergraph Deutschland GmbH������˹�˾��ƷHXTT Access v2.0���Ҹ���д����ݿ�ij��򣬴���MS Access�õ��˹�˾��JDBC Driver��������֪��MS Access�õ���JET engine��Access�ĵ�д����SQL Syntax�͹�˾��Ʒ�ĵ�����Ĵ��ڲ��졣����Data Type���컹�ܴ�����IMAGE in Access vs OTHER(OLE)��Data Type���ҵij���Ĺؼ�֡���Ӧ�����ļҵ�SQL Syntax�أ�

Gruss Zhen
Re:SQL Syntax
HXTT Support
2006-11-14 02:12:19
����SQL Syntax���ɣ���ΪHXTT Access�õ��Ǵ�Java���棬��MS Accessû��ʲô��ϵ�����˸�ʽ�ϼ����⣬������Ͳμ�SQL Data Types for Create Table���ɣ�������������ʣ����Ƕ��ἰʱ֧�֣������޸���ش��룬���x������롣����HXTT Access��֧��JDBC��SQL��׼�ģ���д�Ĵ��뽫��������ֲ��
Re:Re:SQL Syntax
Zhen Zhang
2006-11-14 02:36:34
Could you show the mapping from jdbc type to database native type of your driver, for example ARRAY is mapped to which database native type?

Gruss Zhen
Re:Re:Re:SQL Syntax
HXTT Support
2006-11-14 02:42:43
��SQL Data Types for Create Table��SQL Type��������ֵ����4��java.sql.Types��ARRAY��û���г��ԭ������ΪMS Access��û�ж�Ӧ��������͡�
Re:Re:Re:Re:SQL Syntax
Zhen Zhang
2006-11-14 03:24:10
�е��Ϳ�ˣ�BLOB��MS Access��Ҳû�ж�Ӧ���ͣ���дSQL Query��ʱ����BLOB������OTHER(OLE)�أ��ҵij������Apache DdlUtils that you can access under http://db.apache.org/ddlutils/��
Re:Re:Re:Re:Re:SQL Syntax
HXTT Support
2006-11-14 03:43:07
>BLOB��MS Access��Ҳû�ж�Ӧ���ͣ���дSQL Query��ʱ����BLOB������OTHER(OLE)�أ�
����BLOB���Ա�ӳ�䵽OLE������ȥ��

>дSQL Query��ʱ����BLOB������OTHER(OLE)��
�<��㲻��ָ��ѯ������ָcreate table�ɣ��������ã�����ʹ��BLOB��������ֲ��}�߶��ᱻӳ�䵽OLE������ȥ

��˵��4����������ARRAYʵ�������MS Access�еõ�Ӧ�ã����ǿ��Գ���ʹ��JAVA_OBJECT����4����֧�֣���ʵҲ����ӳ�䵽OLE������ȥ�������������漰����serializeһ��Array������Ҫ��Array����а汾���?���ӵ㡣���ǿ���������Ŀ�������ṩ����֧�֡�

Re:Re:Re:Re:Re:Re:SQL Syntax
Zhen Zhang
2006-11-14 03:51:59
��������SQL Syntax�ǻ��ڱ�׼�ģ��Ҳ���Ҫ����ӳ���ˣ����ǵIJ�Ʒ����mapping BLOB to OLE�ء�������������

Gruss Zhen
Re:Re:Re:Re:Re:Re:Re:SQL Syntax
Zhen Zhang
2006-11-14 03:54:14
��ָ����create table, alter table and so on��Щddl��
Test Case
Zhen Zhang
2006-11-14 04:31:04
/**
* Tests the column types.
*/
public void testColumnTypes() throws Exception
{
assertEqualsIgnoringWhitespaces(
"DROP TABLE \"coltype\";\n"+
"CREATE TABLE \"coltype\"\n"+
"(\n"+
" \"COL_ARRAY\" JAVA_OBJECT,\n"+
" \"COL_BIGINT\" BIGINT,\n"+
" \"COL_BINARY\" BINARY(254),\n"+
" \"COL_BIT\" BIT,\n"+
" \"COL_BLOB\" BLOB,\n"+
" \"COL_BOOLEAN\" BOOLEAN,\n"+
" \"COL_CHAR\" CHAR(15),\n"+
" \"COL_CLOB\" CLOB,\n"+
" \"COL_DATALINK\" JAVA_OBJECT,\n"+
" \"COL_DATE\" DATE,\n"+
" \"COL_DECIMAL\" DECIMAL(15,3),\n"+
" \"COL_DECIMAL_NOSCALE\" DECIMAL(15,0),\n"+
" \"COL_DISTINCT\" JAVA_OBJECT,\n"+
" \"COL_DOUBLE\" DOUBLE,\n"+
" \"COL_FLOAT\" FLOAT,\n"+
" \"COL_INTEGER\" INT,\n"+
" \"COL_JAVA_OBJECT\" JAVA_OBJECT,\n"+
" \"COL_LONGVARBINARY\" LONGVARBINARY,\n"+
" \"COL_LONGVARCHAR\" LONGVARCHAR,\n"+
" \"COL_NULL\" JAVA_OBJECT,\n"+
" \"COL_NUMERIC\" NUMERIC(15,0),\n"+
" \"COL_OTHER\" OTHER(OLE),\n"+
" \"COL_REAL\" REAL,\n"+
" \"COL_REF\" JAVA_OBJECT,\n"+
" \"COL_SMALLINT\" SMALLINT,\n"+
" \"COL_STRUCT\" JAVA_OBJECT,\n"+
" \"COL_TIME\" TIME,\n"+
" \"COL_TIMESTAMP\" TIMESTAMP,\n"+
" \"COL_TINYINT\" TINYINT,\n"+
" \"COL_VARBINARY\" VARBINARY(15),\n"+
" \"COL_VARCHAR\" VARCHAR(15)\n"+
");\n",
createTestDatabase(COLUMN_TEST_SCHEMA));
}
Re:Re:Re:Re:Re:Re:Re:Re:SQL Syntax
HXTT Support
2006-11-14 17:30:38
>���ǵIJ�Ʒ����mapping BLOB to OLE�ء�������������
��

>create table, alter table and so on��Щddl
alter tableĿǰֻ֧�ָ�ı�����ڱ�ṹ�޸IJ�֧��

>"DROP TABLE \"coltype\";\n"+
���ʹ��"DROP TABLE if exists \"coltype\";\n"+ ����Ļ��ܹ��ظ�����

>" \"COL_TINYINT\" TINYINT,\n"+
�ĵ�û��д�����ʵ����MS Access��֧��TINYINT(-127~128)����ȻMS Access����byte���ͣ�0~255)���ϰ汾���׳�TINYINT���Ͳ�֧�ֵ���ʾ�������ĵ��Ѿ��ij�Unavailing, map TINYINT into SMALLINT��ӳ�䵽short��ȥ�ˣ����������°汾HXTT Access���ɡ�

DDL
Zhen Zhang
2006-11-15 02:28:11
������alter table�޸ı�Ľṹ����ôʵ�ְ����ĵ����ᵽ��֧��DEFAULT��auto increment, foreign key, identity of the last inserted row and so on�ĵ��ж�û�б���
�����ҵ���Ŀ��DDL��DML��Ҫ�Ķడ���Ҹ���ô�찡��Ҫ���ϰ����ˡ�
DdlUtils֧�ֵ���ݿ����http://db.apache.org/ddlutils/database-support.html������������Ҫ�ġ�
лл�㡣
Re:Re:Re:Re:Re:Re:Re:Re:SQL Syntax
HXTT Support
2006-11-15 03:05:21
>������alter table�޸ı�Ľṹ����ôʵ�ְ���
һ��취��ʹ��Bulk Insert����һ���µı?Ȼ��ɾ��ɱ?���±����ɾɱ?�ɡ�

>�ĵ����ᵽ��֧��DEFAULT��
���֧�֡�

>auto increment, foreign key,
��֧����sql�д�����Щ���ԣ��������ʹ��MS Access�����ı�����Щ���ԣ�����insert/update/deleteʱ���Զ�ά������(cascading updates and cascading deletes����֧�ֵġ�

>identity of the last inserted row and so on�ĵ��ж�û�б���
�����֧�ֵģ��μ�JDBC��׼��Statement.executeUpdate(String sql, int autoGeneratedKeys)��Statement.getGeneratedKeys()���ɡ�

>DdlUtils֧�ֵ���ݿ����http://db.apache.org/ddlutils/database-support.html��
>����������Ҫ�ġ�
���ڿͻ����ǶԾ���MS Access��ݿ���в����û˭Ҫ��ʹ��alter tableƵ���޸���ݿ⣬��˸ù���û���ṩ�����ǻ��о�һ��DdlUtils�������ܷ��������Ŀ�����������Ҫ�ṩalter table֧�֣�Ҳ��Ҫ���ĵȵȣ�����������ʲô��Ŀ����



Re:Re:Re:Re:Re:Re:Re:Re:SQL Syntax
HXTT Support
2006-11-15 03:18:38
����ȥDdlUtils���Ǹ���Σ�lԴ��Ͷ����ư�û�з�������Ҫ��svn���ء�
DdlUtils
Zhen Zhang
2006-11-15 03:59:57
> ��������ʲô��Ŀ����
Metadata Database is a key part of our webmap application that is developed now. Meanwhile the stable release has been delivered to our clients. But the ongoing development makes database schema change very often, for example a new column of one table has been added. The old database schema muss be upgrade to obtain the same state as the new one, so clients can use add-on features of the new version.
The idea from DdlUtils indicates that metadata that are extract from a live database are used to feed the database domain model, then we can utilize the domain model to achieve our goals.
Re:Re:Re:Re:Re:Re:Re:Re:SQL Syntax
HXTT Support
2006-11-22 08:00:30
v2.0.041 supports fully ALTER TABLE sql.
v2.0.041 supports DROP INDEX sql.

You can download it after about 2 hours.

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Refund | Sitemap