Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reverse engineer sql inserts to enumerators

843859Feb 2 2007 — edited Feb 5 2007
Hello.

I'm working on an application that uses a number os tables to store qualifier information about certain entities. A person can, for example, be an "operator" or an "end-user".
These sets of qualifying data are static, an work as enumerators.
I have a SQL script containig a batch of insert statements which I world like to use to generate the corresponding java enumerator.

So, i I have the following lines in my script:

insert into PERSON_CATEGORY values(1, "operator");
insert into PERSON_CATEGORY values(2, "end-user");

a java enumerator file would be generated containing "operator" and "end-user" as the possible enumeration values.

Can anyone point me to a tool providing the mechanisms necessary to do this?

Thanks in advance,

Hugo Oliveira
hugom.oliveira@siemens.pt
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 5 2007
Added on Feb 2 2007
2 comments
139 views