« So Struts is Dead,... | Main | Monitoring Tomcat... »
20050202 Wednesday February 02, 2005

Generate your iBATIS mapping files with sql2iBatis From the iBATIS mailing list: 

Hi everyone, 

I just wanted to remind everyone of Alex Egorov's sql2iBatis tool. 
I've recently had the chance to try it.  If you have a database that's
already created, this will save you a lot of time.  It will kickstart
your project.

Given DDL, it generates the SQL Mapping files and the JavaBeans.  It's
super simple and extremely fast.  You may want to tweak the Perl to
generate bean field naming conventions to your liking, or just
refactor it afterwards.   You might also want to run the source
through Jalopy or your favorite IDE formatter to achieve the
formatting you want.

However you cut it, this tool will save you tons of time (even if you
don't use everything it generates...deleting is faster than writing).

http://alxeg.narod.ru/ibatis/index.html

Cheers,
Clinton

Too bad it's a perl script. It would be nice to add something like this to AppFuse so you could get the same generate-mapping-files thing like Hibernate has with XDoclet. Posted in Java at Feb 02 2005, 07:10:11 AM MST 5 Comments

Comments:

Too bad it's a perl script. [snip]

Okay, I'll bite.

This is exactly the kind of thing perl excels at. Dismising it just because it's not written in java is rather short sighted of you I think. There is a best tool for each job and that tool is not always java.

Of course I may have missed your point all together.

Posted by Ian Joyce on February 02, 2005 at 08:29 AM MST #

I don't mean to diss on perl at all. It would merely be more convenient if it was Java-based with an Ant task - then I could just include it with AppFuse. Since it's perl, I'd have to include instructions on how to download/setup perl. Granted, it's not that hard, but for some folks it is. ;0)

Posted by Matt Raible on February 02, 2005 at 08:35 AM MST #

[Trackback] Matt greeve about sql2iBatis script being Perl based and I wanted to remind him that there is an evolving generator tool we have for ages. Middlegen already has plugins that can generate code for different persistence layer types and it could be c...

Posted by Euxx on February 02, 2005 at 09:25 AM MST #

I believe not having perl is only an issue for Windows users. ;) Regardless, you're right, an Ant task would make sense given the project.

Posted by Ian Joyce on February 02, 2005 at 09:26 AM MST #

Or you could use the wonderful middlegen(http://boss.bekk.no/boss/middlegen/) tool to generate output in many formats. Written in Java, comes with ant task and doesn't require perl(not that there's anything wrong with that). Ben

Posted by Ben Litchfield on February 02, 2005 at 12:52 PM MST #

Post a Comment:
  • HTML Syntax: Allowed
Click me to subscribe
Matt Raible is a Web Architect who enjoys developing applications with open source technologies. Contact me for rates.
« January 2009
SunMonTueWedThuFriSat
    
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
       
Today

Recent Entries

Tag Cloud

abbie acegi appfuse denver grails gwt hibernate jack java jsf linkedin maven myfaces oscon rails skiing spring springmvc stripes struts struts2 tapestry travel webframeworks wicket