1, if the main method of Main.java :
...
for(int i = 0;i < argv.length;i++){
prop.clear();
prop.load(new FileInputStream(argv[i]));
...
then we can pass multi properties files via the build.xml to Main to generate multi packages at a time. I think that is helpful to code management.
2, currently I use sql server 2000 and the microsoft jdbc driver. I found when a table contains fields of "image" type , each column of ResultSet returned by driver "cannot be re-read"(it seems that you can call rs.getXXX only once), so I change the code from
pObject.setId(rs.getObject == null?(Integer)null:new Integer(rs.getInt(1)))
to
pObject.setId((Integer)rs.getObject(1))
, and when "select @@identity", the code should be:
pObject.setId(new Integer(rs.getInt(1)))
3, is there any plan for approximate query support? The loadUsingTemplate method is convenient but not powerful enough.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
1, if the main method of Main.java :
...
for(int i = 0;i < argv.length;i++){
prop.clear();
prop.load(new FileInputStream(argv[i]));
...
then we can pass multi properties files via the build.xml to Main to generate multi packages at a time. I think that is helpful to code management.
2, currently I use sql server 2000 and the microsoft jdbc driver. I found when a table contains fields of "image" type , each column of ResultSet returned by driver "cannot be re-read"(it seems that you can call rs.getXXX only once), so I change the code from
pObject.setId(rs.getObject == null?(Integer)null:new Integer(rs.getInt(1)))
to
pObject.setId((Integer)rs.getObject(1))
, and when "select @@identity", the code should be:
pObject.setId(new Integer(rs.getInt(1)))
3, is there any plan for approximate query support? The loadUsingTemplate method is convenient but not powerful enough.
Thanks for your feedbacks.
1. will take a look
2. was fixed in 2.4
3. could you be more precise and give an example of the generated code you would like to get?
I think that for point 3. ioly means allowing usage of "LIKE" in the loadUsingTemplate method. We had to do this on a project where we use SQL2Java.