Skip to main content

Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.

Jump to: navigation, search

Difference between revisions of "Scout/Concepts/SqlStyle"

(New page: {{ScoutPage|cat=Concepts}} SqlStyle is a Scout concept used to have SQL code that is independent from the database engine. {{ScoutJavadoc|AbstractSqlStyle|C}} ==Description== {{Note|TOD...)
 
m (Category changed)
(One intermediate revision by one other user not shown)
Line 1: Line 1:
{{ScoutPage|cat=Concepts}}
+
{{ScoutPage|cat=Server}}
  
 
SqlStyle is a Scout concept used to have SQL code that is independent from the database engine.
 
SqlStyle is a Scout concept used to have SQL code that is independent from the database engine.
Line 7: Line 7:
 
==Description==
 
==Description==
 
{{Note|TODO|Add a description}}
 
{{Note|TODO|Add a description}}
 +
 +
=== Test connection ===
 +
Eclipse Scout needs to check if the database is available or not. There is no simple SQL statement that works on every database engine. That is the reason why this is delegated the SQL Style method <code>testConnection(Connection conn)</code>
 +
 +
For Derby:
 +
<source lang="SQL">
 +
SELECT 1 FROM SYSIBM.SYSDUMMY1
 +
</source>
 +
 +
For MySql, Oracle:
 +
<source lang="sql">
 +
SELECT 1 FROM DUAL
 +
</source>
 +
 +
For Microsoft :
 +
<source lang="sql">
 +
SELECT count(1) FROM dbo.sysobjects
 +
</source>
  
  
Line 19: Line 37:
 
== See also ==
 
== See also ==
 
* {{ScoutLink|Concepts|Server Plug-In|Server Plug-In}}
 
* {{ScoutLink|Concepts|Server Plug-In|Server Plug-In}}
* ...
+
* {{ScoutLink|HowTo|Write_a_jdbc_connection_bundle|How To write a JDBC connection bundle}}

Revision as of 12:14, 3 November 2011

The Scout documentation has been moved to https://eclipsescout.github.io/.

SqlStyle is a Scout concept used to have SQL code that is independent from the database engine.

The Scout documentation has been moved to https://eclipsescout.github.io/.

Description

Note.png
TODO
Add a description


Test connection

Eclipse Scout needs to check if the database is available or not. There is no simple SQL statement that works on every database engine. That is the reason why this is delegated the SQL Style method testConnection(Connection conn)

For Derby:

SELECT 1 FROM SYSIBM.SYSDUMMY1

For MySql, Oracle:

SELECT 1 FROM DUAL

For Microsoft :

SELECT COUNT(1) FROM dbo.sysobjects


Included SqlStyle

Eclipse Scout is shipped with some SqlStyles:

  • DB2SqlStyle
  • DerbySqlStyle
  • MSSQLSqlStyle
  • OracleSqlStyle


See also

Back to the top