Marcus, yep, this is basically exactly what I did.  Now I need to spend some more time with the API and testing, etc.  And unfortunately, today is not a good day...  So thx for the zip offer but I don't think I'll need it for now.  Eventually I'd like to run some load tests to compare performance vs. iBATIS and Spring JDBC equivalents.  I'll need to come up with a plan/roadmap for this sub-project first and then I'll post that on this list.

On Thu, Nov 26, 2009 at 12:12 AM, Marcus Smedman <marcus@smedman.org> wrote:

Hi Arbi,

 

Not sure if this is what you where referring to, but I got it up and running by doing this:

 

1. Create an Eclipse project and add the source from seam-sql.zip

2. Download weld from http://seamframework.org/Download

3. Unpack and add the following libs to the project:

                             * <weld-x.y.z>\artifacts\weld\weld-se.jar

                             * <weld-x.y.z>\artifacts\weld\weld-servlet.jar

4. Add a hsql jdbc driver to the project (from http://sourceforge.net/projects/hsqldb/files/ or <jboss-seam-x.y.z>\lib\hsqldb.jar)

5. Uncomment the eg.Main.main method and execute it. Generates the following output:

 

   create table users (name varchar not null, username varchar not null primary key, password varchar not null)

   insert into users (name, username, password) values (?, ?, ?)

   update users set name=?, password=? where username=?

   select u.name as n from users as u where (u.username=? and u.password=?)

   Gavin King

 

I have an Eclipse proj packed up in a zip if you’d like it (4MB).

 

Regards

Marcus

 

 

 

From: weld-dev-bounces@lists.jboss.org [mailto:weld-dev-bounces@lists.jboss.org] On Behalf Of Arbi Sookazian
Sent: den 26 november 2009 08:41
To: Gavin King
Cc: Weld-Dev
Subject: Re: [weld-dev] SQL framework proof of concept

 

I'm interested.  Plz provide instructions on how to build/deploy so I can test it out (it's getting late so I haven't even opened the project in Eclipse yet).  I noticed that the public static void main() in Main class is commented out.  Is it safe to assume that this is basically a Weld SE app (or soon to be Seam3) to test with? thx.

On Wed, Nov 25, 2009 at 11:02 PM, Gavin King <gavin.king@gmail.com> wrote:

Here's a proof-of concept for the typesafe SQL framework. There's lots
of stuff missing, but I can already do basic queries, inserts and
updates. Anyone want to take over from here?

--
Gavin King
gavin.king@gmail.com
http://in.relation.to/Bloggers/Gavin
http://hibernate.org
http://seamframework.org

_______________________________________________
weld-dev mailing list
weld-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/weld-dev