Problems with Java Dictionary Tables

[Former Member]

Hi Experts,

I have some problems with the Java Dictionary tables that I have created for my

application. There are around 15 dictionary tables, each one of them having

several hundred records, added in due course.

As much as I understand these tables (created using the dictionary perspective)

are stored in the default schema of the J2EE engine where the dictionary project

is deployed and there is no direct way to insert records into these tables, we have

to separately write methods to insert, update and delete records.

I've already done this. Now the problem is that i have moved my project DC from

development to testing. Now here the tables are existing, but not the data that i

inserted during development.

NOW, the main question: IS THERE ANY WAY IN WHICH I CAN TRANSFER

THE CONTENTS OF THESE JAVA DICTIONARY TABLES??

I have tried solutions like creating a DBLINK between the databases, but it is

tedious, and unpredictable in behaviour. Also Please do not advise to first

download them to excel and then upload using jxlapi, etc.

Thanx in Advance.

Alka.

[Former Member]

Hey.. thanx Vito for the suggestion.

Still do not have an answer.

Others, Its an old thread.

[Former Member]

Hi Alka,

The dblink is a good solution, but just a bit slow. You can also use a SQL Loader, first export the data from the source table in a text file (i.e. using a tool like TOAD), then sql loader loads the data in the destination table. This is more fast.

Hope this help,

Vito