Databases
StackOverflow2013
Postsdbo
POEmbedded SQL in OO languages like Java
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POEmbedded SQL in OO languages like Java
    primarykey
    data
    text
    <p>One of the things that annoys me working with SQL in OO languages is having to define SQL statements in strings.</p> <p>When I used to work on IBM mainframes, the languages used an SQL preprocessor to parse SQL statements out of the native code, so the statements could be written in cleartext SQL without the obfuscation of strings, for instance in Cobol there is a <em>EXEC SQL .... END-EXEC</em> syntax construct that allows <strong>pure SQL statements</strong> to be <strong>embedded</strong> in the Cobol code.</p> <pre><code>&lt;pure cobol code, including assignment of value to local variable HOSTVARIABLE&gt; EXEC SQL SELECT COL_A, COL_B, COL_C INTO :COLA, :COLB, :COLC FROM TAB_A WHERE COL_D = :HOSTVARIABLE END_EXEC &lt;more cobol code, variables COLA, COLB, COLC have been set&gt; </code></pre> <p>...this makes the SQL statement really easy to read &amp; check for errors. Between the <em>EXEC SQL .... END-EXEC</em> tokens there are no constraints on indentation, linebreaking etc., so you can format the SQL statement according to taste.</p> <p>Note that this example is for a single-row select, when a multiple-row resultset is expected, the coding is different (but still v. easy to read).</p> <p>So, taking Java as an example</p> <ol> <li><p>What made the <em>"old COBOL"</em> approach undesirable ? Not only SQL, but system calls could be made much more readable with that approach. Let's call it the <em>embedded foreign language preprocessor</em> approach. </p></li> <li><p>Would an <em>embedded foreign language preprocessor</em> for SQL be useful to implement ? Would you see a benefit in being able to write native SQL statements inside java code ?</p></li> </ol> <h2>Edit</h2> <p>I'm really asking if you think SQL in OO languages is a throwback, and if not then what could be done to make it better.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSteve De Caux
    1. USSteve De Caux
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POEmbedded SQL in OO languages like Java
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POEmbedded SQL in OO languages like Java
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POEmbedded SQL in OO languages like Java
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO+1 for mentioning COBOL =)
      singulars
      1. POEmbedded SQL in OO languages like Java
      1. USRubens Farias
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload