I've just downloaded sql2java and I'm trying it against a slightly modified copy of the Northwind sample database which comes with SQL Server 2000.
I've found some problems at first, mainly due to wrong classpath and environment variable setting (ANT_HOME, JAVA_HOME and the path to the jTDS driver in the build.xml file). They were not a fault of sql2java anyway.
After that, I've found just two minor errors in the generation process, due to the IMAGE SQL Server datatype. I think it could be mapped to a Blob java datatype.
Hope this helps as a kind of bug report, this tool is wonderful, I don't understand why all that buzz about persistence frameworks.
Now I'll look at changing the template files to generate stored procedure calls instead of SQL. I believe this could be a nice addition for this tool in the future.
Thanks for this wonderful tool !!!!!
Daniel
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi !!
I've just downloaded sql2java and I'm trying it against a slightly modified copy of the Northwind sample database which comes with SQL Server 2000.
I've found some problems at first, mainly due to wrong classpath and environment variable setting (ANT_HOME, JAVA_HOME and the path to the jTDS driver in the build.xml file). They were not a fault of sql2java anyway.
After that, I've found just two minor errors in the generation process, due to the IMAGE SQL Server datatype. I think it could be mapped to a Blob java datatype.
Hope this helps as a kind of bug report, this tool is wonderful, I don't understand why all that buzz about persistence frameworks.
Now I'll look at changing the template files to generate stored procedure calls instead of SQL. I believe this could be a nice addition for this tool in the future.
Thanks for this wonderful tool !!!!!
Daniel