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.<br>
<br><div class="gmail_quote">On Thu, Nov 26, 2009 at 12:12 AM, Marcus Smedman <span dir="ltr"><<a href="mailto:marcus@smedman.org">marcus@smedman.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="SV">
<div>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">Hi Arbi,</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">Not sure if this is what you where referring to, but I got it up
and running by doing this:</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">1. Create an Eclipse project and add the source from
seam-sql.zip</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">2. Download weld from <a href="http://seamframework.org/Download" target="_blank">http://seamframework.org/Download</a></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">3. Unpack and add the following libs to the project:</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> *
<weld-x.y.z>\artifacts\weld\weld-se.jar</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> *
<weld-x.y.z>\artifacts\weld\weld-servlet.jar</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">4. Add a hsql jdbc driver to the project (from
<a href="http://sourceforge.net/projects/hsqldb/files/" target="_blank">http://sourceforge.net/projects/hsqldb/files/</a> or <jboss-seam-x.y.z>\lib\hsqldb.jar)</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">5. Uncomment the eg.Main.main method and execute it. Generates
the following output:</span></p><div class="im">
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> create table users (name varchar not null, username
varchar not null primary key, password varchar not null)</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> insert into users (name, username, password) values
(?, ?, ?)</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> update users set name=?, password=? where
username=?</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> select <a href="http://u.name" target="_blank">u.name</a> as n from users as u where
(u.username=? and u.password=?)</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> Gavin King</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
</div><p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">I have an Eclipse proj packed up in a zip if you’d like it
(4MB).</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">Regards</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US">Marcus</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<div style="border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color blue; border-width: medium medium medium 1.5pt; padding: 0cm 0cm 0cm 4pt;">
<div>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0cm 0cm;">
<p class="MsoNormal"><b><span style="font-size: 10pt;" lang="EN-US">From:</span></b><span style="font-size: 10pt;" lang="EN-US"> <a href="mailto:weld-dev-bounces@lists.jboss.org" target="_blank">weld-dev-bounces@lists.jboss.org</a>
[mailto:<a href="mailto:weld-dev-bounces@lists.jboss.org" target="_blank">weld-dev-bounces@lists.jboss.org</a>] <b>On Behalf Of </b>Arbi Sookazian<br>
<b>Sent:</b> den 26 november 2009 08:41<br>
<b>To:</b> Gavin King<br>
<b>Cc:</b> Weld-Dev<br>
<b>Subject:</b> Re: [weld-dev] SQL framework proof of concept</span></p>
</div>
</div><div><div></div><div class="h5">
<p class="MsoNormal"> </p>
<p class="MsoNormal" style="margin-bottom: 12pt;">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.</p>
<div>
<p class="MsoNormal">On Wed, Nov 25, 2009 at 11:02 PM, Gavin King <<a href="mailto:gavin.king@gmail.com" target="_blank">gavin.king@gmail.com</a>> wrote:</p>
<p class="MsoNormal">Here's a proof-of concept for the typesafe SQL framework.
There's lots<br>
of stuff missing, but I can already do basic queries, inserts and<br>
updates. Anyone want to take over from here?<br>
<span style="color: rgb(136, 136, 136);"><br>
--<br>
Gavin King<br>
<a href="mailto:gavin.king@gmail.com" target="_blank">gavin.king@gmail.com</a><br>
<a href="http://in.relation.to/Bloggers/Gavin" target="_blank">http://in.relation.to/Bloggers/Gavin</a><br>
<a href="http://hibernate.org" target="_blank">http://hibernate.org</a><br>
<a href="http://seamframework.org" target="_blank">http://seamframework.org</a><br>
</span><br>
_______________________________________________<br>
weld-dev mailing list<br>
<a href="mailto:weld-dev@lists.jboss.org" target="_blank">weld-dev@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/weld-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/weld-dev</a></p>
</div>
<p class="MsoNormal"> </p>
</div></div></div>
</div>
</div>
</blockquote></div><br>