Jump to: navigation, search

Scout/Concepts/SqlStyle


Scout
Wiki Home
Website
DownloadGit
Community
ForumsBlogTwitter
Bugzilla
Bugzilla


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

C obj.pngAbstractSqlStyle

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