dbTalk Databases Forums  

CA-Ingres II 2.6 SP2: JDBC EDBC Driver: DatabaseMetaData.getTables() method

comp.databases.ingres comp.databases.ingres


Discuss CA-Ingres II 2.6 SP2: JDBC EDBC Driver: DatabaseMetaData.getTables() method in the comp.databases.ingres forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
djtep
 
Posts: n/a

Default CA-Ingres II 2.6 SP2: JDBC EDBC Driver: DatabaseMetaData.getTables() method - 08-02-2005 , 06:42 AM







CA-Ingres II 2.6 SP2: JDBC EDBC Driver: DatabaseMetaData.getTables() method

----------------------------------------------------------------------------
----

Dear everyone.

We are experience abnormal behaviour with the CA-Ingres II 2.6 SP2: JDBC
EDBC Driver: DatabaseMetaData.getTables() method.

Our Environment:
· Solaris 8
· CA-Ingres II 2.6 SP2 DBMS
· Database with tables using LONG VARCHAR and LONG BYTE

The DatabaseMetaData.getTables() method includes the "iietab" tables thare
the DBMS uses to store LONG VARCHAR and LONG BYTE data.

We believe this is incorrect behaviour given that those tables are not
intended to be manipulated by applications or DBMS users. These tables are
for DBMS usage only.

Has anyone experienced this behaviour? Has anyone logged any support calls
with CA? If so, what is the outcome?

Does anyone have any immediate workarounds?

The issue is inconvenient, where we want to use the dbunit (www.dbunit.org)
tool to export data from one database and import to another database.

I am interested in any responses.

Kind Regards,


--
Jason Tepoorten
@HOME
+61 433 176 821 (mobile telephone)
jason (AT) tepoorten (DOT) com
8MP
Australia



Reply With Quote
  #2  
Old   
djtep
 
Posts: n/a

Default Re: CA-Ingres II 2.6 SP2: JDBC EDBC Driver: DatabaseMetaData.getTables() method - 08-02-2005 , 06:47 AM






I've posted this message on dbForums at URL:
http://www.dbforums.com/showthread.p...11#post4376111

--
Jason Tepoorten
@HOME
+61 433 176 821 (mobile telephone)
jason (AT) tepoorten (DOT) com
8MP
Australia

"djtep" <spare1 (AT) djtep (DOT) com> wrote

Quote:
CA-Ingres II 2.6 SP2: JDBC EDBC Driver: DatabaseMetaData.getTables()
method

--------------------------------------------------------------------------
--
----

Dear everyone.

We are experience abnormal behaviour with the CA-Ingres II 2.6 SP2: JDBC
EDBC Driver: DatabaseMetaData.getTables() method.

Our Environment:
7 Solaris 8
7 CA-Ingres II 2.6 SP2 DBMS
7 Database with tables using LONG VARCHAR and LONG BYTE

The DatabaseMetaData.getTables() method includes the "iietab" tables thare
the DBMS uses to store LONG VARCHAR and LONG BYTE data.

We believe this is incorrect behaviour given that those tables are not
intended to be manipulated by applications or DBMS users. These tables are
for DBMS usage only.

Has anyone experienced this behaviour? Has anyone logged any support calls
with CA? If so, what is the outcome?

Does anyone have any immediate workarounds?

The issue is inconvenient, where we want to use the dbunit
(www.dbunit.org)
tool to export data from one database and import to another database.

I am interested in any responses.

Kind Regards,


--
Jason Tepoorten
@HOME
+61 433 176 821 (mobile telephone)
jason (AT) tepoorten (DOT) com
8MP
Australia





Reply With Quote
  #3  
Old   
djtep
 
Posts: n/a

Default Re: CA-Ingres II 2.6 SP2: JDBC EDBC Driver: DatabaseMetaData.getTables() method - 08-06-2005 , 06:47 AM



A support call was raised with Computer Associates and they were able
to provide a patched EDBC.JAR.

--
Jason Tepoorten
@HOME
+61 433 176 821 (mobile telephone)
jason (AT) tepoorten (DOT) com
8MP
Australia

"djtep" <spare1 (AT) djtep (DOT) com> wrote

Quote:
I've posted this message on dbForums at URL:
http://www.dbforums.com/showthread.p...11#post4376111

--
Jason Tepoorten
@HOME
+61 433 176 821 (mobile telephone)
jason (AT) tepoorten (DOT) com
8MP
Australia

"djtep" <spare1 (AT) djtep (DOT) com> wrote


CA-Ingres II 2.6 SP2: JDBC EDBC Driver:
DatabaseMetaData.getTables()
method


--------------------------------------------------------------------
------
--
----

Dear everyone.

We are experience abnormal behaviour with the CA-Ingres II 2.6
SP2: JDBC
EDBC Driver: DatabaseMetaData.getTables() method.

Our Environment:
7 Solaris 8
7 CA-Ingres II 2.6 SP2 DBMS
7 Database with tables using LONG VARCHAR and LONG BYTE

The DatabaseMetaData.getTables() method includes the "iietab"
tables thare
the DBMS uses to store LONG VARCHAR and LONG BYTE data.

We believe this is incorrect behaviour given that those tables are
not
intended to be manipulated by applications or DBMS users. These
tables are
for DBMS usage only.

Has anyone experienced this behaviour? Has anyone logged any
support calls
with CA? If so, what is the outcome?

Does anyone have any immediate workarounds?

The issue is inconvenient, where we want to use the dbunit
(www.dbunit.org)
tool to export data from one database and import to another
database.

I am interested in any responses.

Kind Regards,


--
Jason Tepoorten
@HOME
+61 433 176 821 (mobile telephone)
jason (AT) tepoorten (DOT) com
8MP
Australia







Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.