| zeroCode now supports MS SQL
Server. |
|
| To create an
SQL-server-based site, you must ensure that
suitable entries have been included in the
zdeAdmin database: |
|
| 1. |
The Database_type table
must include an entry whose description field
contains the string 'MS SQL Server' (note that
this string is case-sensitive). |
|
|
| 2. |
An entry for an SQL server
database engine in the Database_engine table, and
this entry must have its type tied to the type
entry above. |
|
|
| You can then
use this database engine to create your site. |
| The site creation process
copies over the necessary JDBC driver into the
generated site. The driver you choose must be in
a jar file in your site's stdlib directory.
One such driver that you can make use of is the evaluation version of the
JDBC driver available on the site
www.jturbo.com. If you do not
wish to use this particular driver, it is up to
you to remove that jar file and use another one
instead. In general, the site creation process
copies JDBC drivers for all supported platforms
into the generated site's stdlib directory, so
that it is easy to re-target the site during the
site testing process. You can choose to
remove unnecessary drivers after completing the
testing. |
|
| The SQL optimizer depends
heavily on the choice of database type. It looks
at the value of the database type parameter in the
site's config file, and if it finds 'MS SQL
Server' as the value, it uses the ANSI outer join
syntax; otherwise it uses the Oracle syntax for
outer joins. So if you find syntax errors with
outer joins in the generated site, you know where
to look. |
|
| |
|
