Re: Grails anybody?

2008-04-01 Thread Darren Davison
On Tue, Apr 01, 2008 at 08:46:55AM -0700, tomasz brymora wrote: > Is anyone using iBatis with Grails? I'm not, but I do use both grails and iBATIS a lot on different projects. There should be no reason not to. Since pre-1.0 of grails, they removed the tight coupling to hibernate and you can now

Re: How to insert byte[] using iBatis into DB

2008-04-01 Thread Andrey Rogov
Kumar, I had idea to write the data byte [] in a field such as BLOB type, instead of CHARACTER (64). Try to write/read BLOB data without iBatis with the help IBM examples . It has no relation to iBatis email list, so write to me directly, please. 2008/4/1, Elangovan, Kumaravel <[EMAIL PROTECTED]

Re: Grails anybody?

2008-04-01 Thread Brandon Goodin
We actually do have a gBatis project started offsite of apache ( http://gbatis.silvermindsoftware.com/). It is extremely preliminary. The thought was to write a complete Groovy based implementation of iBATIS from ground up. I've put the project on hold for the immediate until the iB3 API comes out.

Re: Grails anybody?

2008-04-01 Thread Clinton Begin
I'm going to be totally honest If Java was Groovy, I never would have written iBATIS. The database APIs (especially the integration with GString -- despite a few limitations) is the smartest thing I've ever seen in database API design. Not only is it better than JDBC, it's better than Ruby's

Grails anybody?

2008-04-01 Thread tomasz brymora
Greetings! I just have a couple of quickie questions. Is anyone using iBatis with Grails? Are there any plans in the works for an iBatis plugin for Grails? I've been working on project using Grails and as much as I like the concept, it's integration with Hibernate is pretty much a deal breaker

Re: iBatis using Tomcat JNDI, Now DB unit Tests???

2008-04-01 Thread Christopher Lamey
I use Spring's SimpleNamingContextBuilder to create my own JNDI DataSources outside of a container. You might also want to look at DBUnit and hsqldb. On 4/1/08 9:09 AM, "Tom Henricksen" <[EMAIL PROTECTED]> wrote: > We have been using the Simple datasource in iBatis and had unit test > that would

Re: [Urgent] Problem retrieving self referencial table details IBATIS

2008-04-01 Thread Jeff Butler
Replying to the user list - this is not appropriate for the dev list. When you do a self join, you will need to rename some of the columns so they are unique. For example: select a.name, b.name as boss_name from employees a join employees b on a. boss_id = b.employee_id This will also mean that

iBatis using Tomcat JNDI, Now DB unit Tests???

2008-04-01 Thread Tom Henricksen
We have been using the Simple datasource in iBatis and had unit test that would tap into this for DB testing. Now we are moving to using the container for Datasource and I am unsure of how to do DB testing without starting up the container (tomcat on developer's machine). How do people do DB unit

RE: How to insert byte[] using iBatis into DB

2008-04-01 Thread Elangovan, Kumaravel
Hi Andrey, Yes, we have passed secKey object as parameter, but got the following error. com.ibm.db2.jcc.a.SqlException: No authorized routine named "PROCEDURE NAME" of type "PROCEDURE" having compatible arguments was found. The ibatis entry is as follows. The class SecKey is having the secKey

RE: How to insert byte[] using iBatis into DB

2008-04-01 Thread Elangovan, Kumaravel
Hi Andrey, Yes, we have passed secKey object as parameter, but got the following error. com.ibm.db2.jcc.a.SqlException: No authorized routine named "PROCEDURE NAME" of type "PROCEDURE" having compatible arguments was found. The ibatis entry is as follows. The class SecKey is having the secKey