Ok, ran the Main client. Results:<br><br><div style="margin-left: 40px;"><font size="1">create table users (name varchar not null, username varchar not null primary key, password varchar not null)<br>insert into users (name, username, password) values (?, ?, ?)<br>
update users set name=?, password=? where username=?<br>select <a href="http://u.name">u.name</a> as n from users as u where (u.username=? and u.password=?)<br>Gavin King</font><br><br></div>The testQuery() is too long. Yes, it's typesafe and tool-friendly, but it's too busy. But obviously several lines (e.g. comments) can be eliminated off the bat.<br>
<br>Also, not 100% sure but it appears that hsqldb supports stored procs: <a href="http://hsqldb.sourceforge.net/web/hsqlFAQ.html#STORED">http://hsqldb.sourceforge.net/web/hsqlFAQ.html#STORED</a><br><br>I imagine that eventually this will need to be tested using mysql: <a href="http://dev.mysql.com/doc/refman/5.1/en/stored-routines.html">http://dev.mysql.com/doc/refman/5.1/en/stored-routines.html</a><br>
<br><br><div class="gmail_quote">On Wed, Nov 25, 2009 at 11:40 PM, Arbi Sookazian <span dir="ltr"><<a href="mailto:asookazian@gmail.com">asookazian@gmail.com</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;">
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.<br>
<br><div class="gmail_quote"><div><div></div><div class="h5">On Wed, Nov 25, 2009 at 11:02 PM, Gavin King <span dir="ltr"><<a href="mailto:gavin.king@gmail.com" target="_blank">gavin.king@gmail.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div class="h5">
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>
<font color="#888888"><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>
</font><br></div></div>_______________________________________________<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><br></blockquote></div><br>
</blockquote></div><br>