• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

seek API to for constructing SQL strings

 
Frank Silbermann
Ranch Hand
Posts: 1405
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The SQL language has a syntax that is human-oriented, rather than user-oriented -- designed for entering statements into an SQL client and reading the results. Database programs whose SQL statements are determined at runtime generate SQL statements by concatenating substrings. I find this approach ugly, clumsy and error-prone.

Of course, I could write my own wrapper around the SQL string generation process, but that would take work. Are there any freely available APIs for building SQL command strings programmatically?

Since the relational database already exists, I'd prefer something lightweight, rather than, say, a comprehensive persistence framework such as container-managed EJBs or Hibernate.
 
Jeff Albertson
Ranch Hand
Posts: 1780
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
iBatis?
 
Frank Silbermann
Ranch Hand
Posts: 1405
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Jeff Albertson:
iBatis?
A quick glance suggests to me that this is another framework for getting Java objects instead of result sets OUT of a database.

I'm not looking to wrap database results. I just want a programmable API to a SQL query builder.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic