Search found 3 matches
- 16 Oct 2009, 00:09
- Forum: Essential Open Source - Platform
- Topic: jdbc table create DB1
- Replies: 6
- Views: 5167
Re: jdbc table create DB1
We are using Protege 3.4.1 "DB2 v8.1.0.128", "s061108", "U810099", and FixPak "14" Here is the exception: WARNING: Failed to create table on database DB2/SUN with command 'CREATE TABLE essentialbaseline (frame VARCHAR NOT NULL, frame_type SMALLINT NOT NULL, sl...
- 15 Oct 2009, 22:51
- Forum: Essential Open Source - Platform
- Topic: jdbc table create DB1
- Replies: 6
- Views: 5167
Re: jdbc table create DB1
This is very easy to fix as mySQL sets default length if VARCHAR(length) not specified as it's in Essential code. Can I have the source of the create table? This is the DB Dictionary from mySQL: Field Type Null Default Comments frame var(500) No frame_type smallint(6) No slot var(500) No facet var(5...
- 15 Oct 2009, 21:10
- Forum: Essential Open Source - Platform
- Topic: jdbc table create DB1
- Replies: 6
- Views: 5167
jdbc table create DB1
Hi, Im trying to convert a file repo to use DB2 database. When Protege is creating the table the SQL doesn't conform with DB2 (probably not oracle either). When VARCHAR is use a length need to be specified. Where in the Code is the SQL for creating the schema(tables)? This is the SQL that the GUI pr...