CODEWITHSUNDEEP
javasqldatabasespringscripting
javamonkey79
javamonkey79

Reputation: 17795

Spring SP Class generation with or without Eclipse

With Hibernate+Eclipse you can generate POJO classes that represent the tables. You can then wire it all together pretty easily with Spring. However, if you have to interact with stored procedures you have to wrap each one in it's own class(es) -- although this is definitely preferred to standard JDBC it is still a bit cumbersome at times.

Does anyone out there know of a script, application, Eclipse Plug-in or anything that generates Spring stored procedure classes?

Thanks in advance.

Upvotes: 0

Views: 231

Answers (1)

duffymo
duffymo

Reputation: 309008

You can subclass Spring's StoredProcedure to call stored procs, but there's another way if you're using Spring 2.5. The SimpleJdbcCall class makes this easy.

I don't know about Eclipse plug-ins or anything else to do it for you. If you have a lot of them to do at once, it seems to me to be a perfect spot for a Velocity template, a flat file with the names and I/O parameters for each one, and a quick Java app to marry them together.

[rant] Geez, you've got the framework. Is it too much to ask that we write a little code? If it's all wizards and plug-ins, what's a developer for? [/rant]

Upvotes: 2

Related Questions