Been trying to get SQL2Java to work with the latest version of HSQLDB. Granted, I'm not realy familiar with HSQL, but I've used SQL2Java several times with MySQL with no problems.
I modified the properties file to point it at my HSQL Server, started the server, and ran ant generate. Which just hangs, I get a % sign for the loading status and it just sits there and generate no code, but I don't get any error messages.
If I replace the hsqldb.jar in the sql2Java directory with the newest hsqldb.jar, I get a nasty error. So I don't know if I have something configed wrong or SQL2Java isn't working with 1.8
Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
"According to the Javadoc "null" should be used if the critera should not be used to narrow the search.
As far as i can see, this is why "%" is used, but hsql do not match null columns against this filter."
Been trying to get SQL2Java to work with the latest version of HSQLDB. Granted, I'm not realy familiar with HSQL, but I've used SQL2Java several times with MySQL with no problems.
I modified the properties file to point it at my HSQL Server, started the server, and ran ant generate. Which just hangs, I get a % sign for the loading status and it just sits there and generate no code, but I don't get any error messages.
If I replace the hsqldb.jar in the sql2Java directory with the newest hsqldb.jar, I get a nasty error. So I don't know if I have something configed wrong or SQL2Java isn't working with 1.8
Thanks
Hi,
I am having the same problem here, the first that finds the solutions gives a hint to the other one ;)
enjoy your day
Florent
Ok found a solution here http://opensource2.atlassian.com/projects/hibernate/browse/HB-649
stating that
"According to the Javadoc "null" should be used if the critera should not be used to narrow the search.
As far as i can see, this is why "%" is used, but hsql do not match null columns against this filter."
Here are my patches :
http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/sql2java/sql2java/src/config/sql2java.properties.diff?r1=1.19&r2=1.20
http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/sql2java/sql2java/src/java/com/netkernel/sql2java/Database.java.diff?r1=1.20&r2=1.21
Enjoy your day
Florent