reverse-db and reversedb2
All, I noticed these targets in the build.xml file. Do these applications work in that I can select tables from my existing database and have it generate the initial XML config file for OJB? If so, which one is best? I have tried to play with them with no success. __ Daniel B. Brown | WELLS FARGO BANK MINNESOTA, N.A. | Software Architect | http://www.wellsfargo.com | MAC N2702-011 | 9062 Old Annapolis Road | Columbia | MD | 21045-1951 | p: 410.884.2034 | f: 410.715.2325 | [EMAIL PROTECTED] | - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: reverse-db and reversedb2
I could not get either reverse-db version working using our MSSqlServer 7 databases. But I did come across this an OJB tool for eclipse that looks promising (http://www.impart.ch/download.htm). It seems to generate the repository*.xml and java files that I need. I will be testing it today to see if the generated output works. Only problem is that I had to install eclipse to use it since it is a plugin and I don't know how to invoke it outside of the tool. But the investment time is only an hour or two verses 3 to 4 days for the suggested approach below. - Dan -Original Message- From: Danilo Tommasina [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 3:42 AM To: OJB Users List Subject: Re: reverse-db and reversedb2 Hi, All, I noticed these targets in the build.xml file. Do these applications work in that I can select tables from my existing database and have it generate the initial XML config file for OJB? If so, which one is best? I have tried to play with them with no success. We are also using reverse engineering, our db model is very large and complex and we have a good db-design tool, so we prefere to adopt this way... I got a look to reverse-db tools, however i have the impression they are still too 'young' and doesn't give me enough freedom on the model generation process. If you look into the build-torque.xml ant script, you will find targets for generating repository and model from a jdbc connection. However I started with RC3 and the velocity templates used for the repository/java code generation were still quite buggy (Maybe they are better now in RC4). I did several modification, so now we can generate the repository and the java code formatted as we want and with several useful features already added to the model classes. Drawback is that the templates we are using now are no longer globally usable :( but we spare lot of time, everytime there is a change in the database model. So if you have the possibility to invest 3 or 4 days, you can adapt the velocity templates (and maybe the ant script) to your application. In our case, for every db-table we have 2 classes, a base class that is always regenerated by the build script and only defines the setters/getters and a couple of constructors, the second class extends the base one and is only created once, in this class you can put some more code to simplify access to the data (conversions and other utility methods) hope i helped you bye danilo - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Antwort: reverse-db and reversedb2
Hello, I tried both tools. reverse-db can generate some xml data but has problems with combined foreign keys and doesn't generate any java code (the button seems not to work, at least nothing happens). reversedb2 is strange, it can read my tables from the database but it does nothing else than that... Lasse |-+- | | [EMAIL PROTECTED]| | | lsfargo.com | | | | | | 11.08.03 20:21| | | | |-+- ---| | | |An: [EMAIL PROTECTED] | |Kopie: | |Thema: reverse-db and reversedb2 | ---| Date: Mon, 11 Aug 2003 13:19:59 -0500 Subject: reverse-db and reversedb2 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] All, I noticed these targets in the build.xml file. Do these applications work in that I can select tables from my existing database and have it generate the initial XML config file for OJB? If so, which one is best? I have tried to play with them with no success. __ Daniel B. Brown | WELLS FARGO BANK MINNESOTA, N.A. | Software Architect | http://www.wellsfargo.com | MAC N2702-011 | 9062 Old Annapolis Road | Columbia | MD | 21045-1951 | p: 410.884.2034 | f: 410.715.2325 | [EMAIL PROTECTED] | - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: reverse-db and reversedb2
little remark :) I could not get either reverse-db version working using our MSSqlServer 7 databases. But I did come across this an OJB tool for eclipse that looks promising (http://www.impart.ch/download.htm). It seems to generate the repository*.xml and java files that I need. I will be testing it today to see if the generated output works. Only problem is that I had to install eclipse to use it since it is a plugin and I don't know how to invoke it outside of the tool. But the investment time is only an hour or two verses 3 to 4 days for the suggested approach below. yep, i actually employed 3-4 days because i wrote also several ant-script for multi-database / multi web-server support and added several customisations to the velocity templates :) however if the eclipse plugin creates good code (i didn't tried it) and you don't need special customisation, i suggest you get a look at the plugin, since the RC3 velocity templates were still quite buggy and you will still need at least one day to get them to work (if you already have experience with velocity) bye danilo - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: reverse-db and reversedb2
Hi, All, I noticed these targets in the build.xml file. Do these applications work in that I can select tables from my existing database and have it generate the initial XML config file for OJB? If so, which one is best? I have tried to play with them with no success. We are also using reverse engineering, our db model is very large and complex and we have a good db-design tool, so we prefere to adopt this way... I got a look to reverse-db tools, however i have the impression they are still too 'young' and doesn't give me enough freedom on the model generation process. If you look into the build-torque.xml ant script, you will find targets for generating repository and model from a jdbc connection. However I started with RC3 and the velocity templates used for the repository/java code generation were still quite buggy (Maybe they are better now in RC4). I did several modification, so now we can generate the repository and the java code formatted as we want and with several useful features already added to the model classes. Drawback is that the templates we are using now are no longer globally usable :( but we spare lot of time, everytime there is a change in the database model. So if you have the possibility to invest 3 or 4 days, you can adapt the velocity templates (and maybe the ant script) to your application. In our case, for every db-table we have 2 classes, a base class that is always regenerated by the build script and only defines the setters/getters and a couple of constructors, the second class extends the base one and is only created once, in this class you can put some more code to simplify access to the data (conversions and other utility methods) hope i helped you bye danilo - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
