Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.databases > #688

Is there a tool like this? SQLStomp.

Show all headers | View raw

Writing SQL code is pretty tedious.  I thought someone might have
invented a simple tool that works like this.

You define a Java class.

You feed the source (or perhaps the class file) to a utility.

In then spits out:

(1) some SQL to define a corresponding table.

(2) Some Java/JDBC code to read a single record of the table into the
Java variables.

(3) Some Java/JDBC code to insert a new single record into the table,
taking its values from the Java variables.

This code would not need not be 100% correct, just handle the bull
work. You would then tweak it.  You could then be sure the details
were all correct without careful proofreading. Alternatively you might
bury some hints in the comments or use magic names to indicate the
keys.

Such a tool could mask much of the difference between SQL
implementations.
-- 
Roedy Green Canadian Mind Products http://mindprod.com
Errors using inadequate data are much less than those using no data at all. 
~ Charles Babbage (born: 1791-12-26 died: 1871-10-18 at age: 79)

Back to comp.lang.java.databases | Previous | Next — Next in thread | Find similar

Thread

Is there a tool like this? SQLStomp. Roedy Green <see_website@mindprod.com.invalid> - 2014-09-03 07:38 -0700
  Re: Is there a tool like this? SQLStomp. Arne Vajhøj <arne@vajhoej.dk> - 2014-09-04 18:49 -0400
  Re: Is there a tool like this? SQLStomp. Silvio <silvio@internet.com> - 2014-09-05 15:09 +0200
    Re: Is there a tool like this? SQLStomp. Roedy Green <see_website@mindprod.com.invalid> - 2014-09-05 10:49 -0700
      Re: Is there a tool like this? SQLStomp. Arne Vajhøj <arne@vajhoej.dk> - 2014-09-07 17:58 -0400

csiph-web