I have problems creating a data source in #5321 (against a Oracle 188.8.131.52
When I test the connection i got "ORA-01000: Maximum open cursos exceeded"
after about 2-3 minutes.
It seems that Idea scans all tables and columns. Our DBA says that Idea
opens a new cursor for each table?
Our database contains 692 tables, and thus we got the above error?
This is the SQL that is executed for each table:
SELECT NULL AS pktable_cat, p.owner as pktable_schem,
p.table_name as pktable_name, pc.column_name as pkcol
umn_name, NULL as fktable_cat, f.owner as fktable_
schem, f.table_name as fktable_name, fc.column_nam
e as fkcolumn_name, fc.position as key_seq, NULL a
s update_rule, decode (f.delete_rule, 'CASCADE', 0, 'SET
NULL', 2, 1) as delete_rule, f.constraint_name as fk_name
, p.constraint_name as pk_name, decode(f.deferrabl
e, 'DEFERRABLE',5 ,'NOT DEFERRABLE',7 , 'DEFERRE
D', 6 ) deferrability FROM all_cons_columns pc, all_
constraints p, all_cons_columns fc, all_constraints f WHER
E 1 = 1 AND f.table_name = :1 AND f.owner = :2 AND f.const
raint_type = 'R' AND p.owner = f.r_owner AND p.constraint_na
me = f.r_constraint_name AND p.constraint_type = 'P' AND pc.
owner = p.owner AND pc.constraint_name = p.constraint_name A
ND pc.table_name = p.table_name AND fc.owner = f.owner AND f
c.constraint_name = f.constraint_name AND fc.table_name = f.ta
ble_name AND fc.position = pc.position ORDER BY pktable_schem,
So - any suggestions how I can create a data source to this datbase? Is it
possible to only get the table names
when open/testing the data source and then getting the detail information
later (when needed)?