This is why CMP was invented. You are recreating the wheel.
-dain
Dimitri PISSARENKO wrote:
> Hello!
>
> In my application I have a lot of SQL queries to the database. I want
> to implement them in a way, which in future should allow an easy
> migration to another database (I'm using bean-managed-persistence).
>
> One of the problems of database migration are slight differences in
> the syntax of SQL queries at different DBMS.
>
> Now I have a special class for each query, so instead of writing
>
>
>
> Statement statement = conn.createStatement();
> statement.executeUpdate("DELETE FROM tbl_project WHERE ID=" + 1);
>
>
> I write
>
> Statement statement = conn.createStatement();
> ProjectDeletionQuery query = new ProjectDeletionQuery(1);
> statement.executeUpdate(query.toString());
>
>
>
> where ProjectDeletionQuery is defined as
>
>
>
> public class ProjectDeletionQuery
> {
> public ProjectDeletionQuery(int pk)
> {
> this.primaryKey = pk;
> }
> public String toString()
> {
> return "DELETE FROM tbl_project WHERE ID=" + this.primaryKey;
> }
>
> private int primaryKey;
> }
>
>
>
> I would like to know whether there are more elegant ways to separate
> SQL query syntax from the code (perhaps a special Java library or a
> tool).
>
> Thanks in advance
>
> Dimitri Pissarenko
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
--
xxxxxxxxxxxxxxxxxxxxxxxx
Dain Sundstrom
Chief Architect JBossCMP
JBoss Group, LLC
xxxxxxxxxxxxxxxxxxxxxxxx
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
