Reverse engineer sql inserts to enumerators
843859Feb 2 2007 — edited Feb 5 2007Hello.
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