| datatools (cvs before 2 days), oracle , database explorer [message #2086] |
Thu, 20 October 2005 19:51  |
Eclipse User |
|
|
|
i have tried datatools cvs and it claim that support oracle
(have oracle 10,9 etc)
There are no one table properties except columns (contsraints,triggers,
procedure nothing) - it don't recognize VARCHAR2 ever.
This is generic driver and it is better call it generic
and then I can use postgresql , too
When you make oracle specific features then it be oracle
Database explorer is very slow (it search constraints one minutes and don't
find nothing) - myeclipse (sqlexplorer plugin) work much quicker and return
value.I get out of memory quick (I know for vm arguments, but I don't
OutOfMemory in runtime workbench for another plugins)
Peco
|
|
|
| Re: datatools (cvs before 2 days), oracle , database explorer [message #3103 is a reply to message #2086] |
Thu, 20 October 2005 22:44  |
| Eclipse User |
|
|
|
Haris Peco wrote:
> There are no one table properties except columns (contsraints,triggers,
> procedure nothing) - it don't recognize VARCHAR2 ever.
I use DB2 driver , probably - i define new connection (oracle 9) and when i
expand tables I get next error :
Exception caught while loading database vendor definition document:
org.eclipse.emf.ecore.resource.Resource$IOWrappedException: Feature
'orderingSupported' not found. (Oracle_9.xmi, 128, 150)Could not acquire
children from extension: class
org.eclipse.wst.common.navigator.internal.views.extensions.N avigatorContentProvider
Reason:
Could not acquire children from extension: class
org.eclipse.wst.common.navigator.internal.views.extensions.N avigatorContentProvider
i remove orderingSupported (and groupingSupported) in line 128 in
Oracle_9.xmi and expand tables work
I have problem with constraints - for one my tables 2 constraints are shown
(primary key on 1 foreign key) and 2 (foregn key) don't.
This is problem :
scenario :
table A have foreign key to table B,C,D
if i expand table A (and don't expand B,C and D) then I get primary key of A
only
now, i close and reconnect (there are 2 connections but it is minor problem)
and expand table B (and constraints of table B) and then A (no expand table
C and D)
I get primary key for A and foreign key A->B (but no A->C, A->D)
I hope that you understand (sorry for my english)
The problem is simple :
method JDBCTable#loadForeignKey call method
DatabaseMetadata#getExportedKeys and seek tables with primary key in this
tables.You have to call
DatabaseMetadat#getImportedKeys and seek foreign key for this table (we want
this).I think that lazy loading for constraints (constraints Loaded) isn't
very important then (we have seek imported key every times - no one tables
haven't too much imported keys and you can add primary key for foreign key
table only)
Peco
|
|
|
| Re: datatools (cvs before 2 days), oracle , database explorer [message #567135 is a reply to message #2086] |
Thu, 20 October 2005 22:44 |
| Eclipse User |
|
|
|
Haris Peco wrote:
> There are no one table properties except columns (contsraints,triggers,
> procedure nothing) - it don't recognize VARCHAR2 ever.
I use DB2 driver , probably - i define new connection (oracle 9) and when i
expand tables I get next error :
Exception caught while loading database vendor definition document:
org.eclipse.emf.ecore.resource.Resource$IOWrappedException: Feature
'orderingSupported' not found. (Oracle_9.xmi, 128, 150)Could not acquire
children from extension: class
org.eclipse.wst.common.navigator.internal.views.extensions.N avigatorContentProvider
Reason:
Could not acquire children from extension: class
org.eclipse.wst.common.navigator.internal.views.extensions.N avigatorContentProvider
i remove orderingSupported (and groupingSupported) in line 128 in
Oracle_9.xmi and expand tables work
I have problem with constraints - for one my tables 2 constraints are shown
(primary key on 1 foreign key) and 2 (foregn key) don't.
This is problem :
scenario :
table A have foreign key to table B,C,D
if i expand table A (and don't expand B,C and D) then I get primary key of A
only
now, i close and reconnect (there are 2 connections but it is minor problem)
and expand table B (and constraints of table B) and then A (no expand table
C and D)
I get primary key for A and foreign key A->B (but no A->C, A->D)
I hope that you understand (sorry for my english)
The problem is simple :
method JDBCTable#loadForeignKey call method
DatabaseMetadata#getExportedKeys and seek tables with primary key in this
tables.You have to call
DatabaseMetadat#getImportedKeys and seek foreign key for this table (we want
this).I think that lazy loading for constraints (constraints Loaded) isn't
very important then (we have seek imported key every times - no one tables
haven't too much imported keys and you can add primary key for foreign key
table only)
Peco
|
|
|
Powered by
FUDForum. Page generated in 0.04013 seconds
Home