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.
Difference between revisions of "Scout/Concepts/SqlStyle"
(add Test connection statements + link to Write_a_jdbc_connection_bundle) |
m (Category changed) |
||
Line 1: | Line 1: | ||
− | {{ScoutPage|cat= | + | {{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. |
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
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
- The Scout documentation has been moved to https://eclipsescout.github.io/.
- The Scout documentation has been moved to https://eclipsescout.github.io/.