I got tired of creating all these DAOs manually, so I started to look for a tool to generate it for me. Sql2Java seems to fit the bill just fine. However, I am at a loss of what to do after I downloaded the tool. I don't have hsqldb on my machine to try the example. I can point it to an Oracle database, but how? What do I need to do? Modify the build.xml?
Is it at all possible to point to a MS Access database?
Thanks for your help.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Last time I downloaded the package it had hsqldb.jar included. I think the version included is an older version though, because I can't get it to successfully connect to a server running on the newest hsql download...
You should have a look at the sql2java.properties file. It has stuff already in there, just commented out, for mysql and Oracle as well. The way I went about was by copying and modifying the sql2java.properties file for my application (basically changing the username, password, package and stuff like that, and then I copied the appropriate stuff from the build.xml file to my own build.xml file.
Hope it helps,
Charl
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I got tired of creating all these DAOs manually, so I started to look for a tool to generate it for me. Sql2Java seems to fit the bill just fine. However, I am at a loss of what to do after I downloaded the tool. I don't have hsqldb on my machine to try the example. I can point it to an Oracle database, but how? What do I need to do? Modify the build.xml?
Is it at all possible to point to a MS Access database?
Thanks for your help.
Hi,
Last time I downloaded the package it had hsqldb.jar included. I think the version included is an older version though, because I can't get it to successfully connect to a server running on the newest hsql download...
You should have a look at the sql2java.properties file. It has stuff already in there, just commented out, for mysql and Oracle as well. The way I went about was by copying and modifying the sql2java.properties file for my application (basically changing the username, password, package and stuff like that, and then I copied the appropriate stuff from the build.xml file to my own build.xml file.
Hope it helps,
Charl