Share

SQL to Java Code Generator

Code

Programming Languages: Java

License: GNU Library or Lesser General Public License (LGPL)

Repositories

browse code, statistics, last commit on 2008-10-16 svn co https://sql2java.svn.sourceforge.net/svnroot/sql2java sql2java

browse code, statistics, last commit on 2008-11-17 cvs -d:pserver:anonymous@sql2java.cvs.sourceforge.net:/cvsroot/sql2java login

cvs -z3 -d:pserver:anonymous@sql2java.cvs.sourceforge.net:/cvsroot/sql2java co -P modulename

Show:

What's happening?

  • Join methods not created.

    In my xxManager classes I don't get any methods like: loadXXViaYY(bean) type methods even though there are table junction tables. I can see the method template in manager.java.vm but I'm not sure why those methods aren't being created. Any help would be appreciated. Thanks.

    2009-11-05 06:19:42 UTC by victorewert

  • what's available in the jdbc2java types

    In sql2java.properties file section 7/8 there are mappings like jdbc2java.date=java.util.Date. I need to make sure that the DECIMAL type in my db (DB2) is converted to something other than BigDecimal, as it is now. Is there a list somewhere of what's available in jdbc2java. types? Can I use something like jdbc2java.decimal=double?.

    2009-10-23 19:43:50 UTC by Val

  • MySQL 2 PHP templates

    I've used sql2java for java applications. But recently I needed something similar for PHP and used sql2java to generate, from a MySQL database. Here's the sources of the templates I've used. Use it as you want.

    2009-09-05 15:37:47 UTC by paulor0

  • Some improvements...

    Hi there, I'm starting to use sql2java for a new product (yes the KISS principle keeps me away from Hibernate and the like) I have made some tweaks to the java templates. Some of the are too large to be copied directly here, so I'm posting the list and if someone is interested in my code, feel free to contact me : -perschema/manager.java.vm Seems like there was some problems with...

    2009-08-07 13:47:44 UTC by qstone

  • Followup: RE: Broken Example Page

    I would want to fix the site but to be honest, I really don't understand where the site sources are. We used to be able to login on the sourceforge shell server and modify the sources, but when I look at it now, I can't seem to find the site anywhere, which is quite strange imho. But you may have a look at the sql2java download. It also contains the examples mentioned on the site. The ant...

    2009-05-05 18:27:16 UTC by calmera

  • Broken Example Page

    http://sql2java.sourceforge.net/xref/org/acme/Main.html Anyone like to post some examples here ?.

    2009-05-05 12:09:49 UTC by daslicht

  • Followup: RE: Change the mapping of datatypes for oracle db

    As far as the mapping of the NUMBER(10,0) to Long is concerned, I think the current code would do it, as long as your driver is returning a NUMERIC or DECIMAL as type for the column. Please try to get rid of the classes12.jar in the sql2java classpath and drop there your own driver for your version (not described in your post). The classes12.jar was the driver for Oracle 9i. Regards...

    2009-02-17 16:05:55 UTC by kameleono

  • Followup: RE: Change the mapping of datatypes for oracle db

    The mappings between SQL types and Java types are defined in the code of class Column where in internal (sql2java specific) mapping type is used. sql2java/src/java/net/sourceforge/sql2java/Column.java My guess is that the whole mapping depends on the Java type returned by your driver. Did you try with the driver provided with your Oracle version? It seems to me that the classes12.jar...

    2009-02-17 15:54:27 UTC by kameleono

  • Followup: RE: blank dao files

    The DAO classes and interfaces are generated based on the procedures found in the database. This was an experimental set of functionnalities but the association of procedures to tables was not quite clear. Just erase the spdao (Stored Procedures Data Access Objects) template from your list of generated folders. Regards, Alain.

    2009-02-17 15:45:00 UTC by kameleono

  • Followup: RE: Defect #2464285

    The DAOException is defined in the template sql2java/src/templates/velocity/java/perschema/exception/dao.exception.java.vm where you can make the change. Regards, Alain.

    2009-02-17 15:39:00 UTC by kameleono

Our Numbers