SQL Server
With SQL Server we have to decide if we are going to use the sqlserver17
or the default older one.
sqlserver17
To setup to use sqlserver17 we should set the databasePlatformName
to sqlserver17 at either the
ebean.databasePlatformName
> level or at ebean.test.sqlserver.databasePlatformName
> level.
ebean:
databasePlatformName: sqlserver17 ## only using sql server
test:
platform: sqlserver # h2, postgres, mysql, oracle, sqlserver
ddlMode: dropCreate # none | dropCreate | migrations
dbName: test
sqlserver:
#collation: SQL_Latin1_General_CP1_CS_AS ## use an explicit collation
#collation: default ## use the sql server default
When testing against multiple database platforms put databasePlatformName: sqlserver17
under sqlserver
like the example below:
ebean:
test:
platform: sqlserver # h2, postgres, mysql, oracle, sqlserver
ddlMode: dropCreate # none | dropCreate | migrations | create
dbName: test
sqlserver:
databasePlatformName: sqlserver17 ## put here when testing multiple platforms
#collation: SQL_Latin1_General_CP1_CS_AS ## use an explicit collation
#collation: default ## use the sql server default
The above will use the following defaults:
username: | {databaseName} |
---|---|
password: | SqlS3rv#r |
port: | 1433 |
url: | jdbc:sqlserver://localhost:{port};databaseName={databaseName} |
driver: | com.microsoft.sqlserver.jdbc.SQLServerDriver |
image: | microsoft/mssql-server-linux:{version} |