First you need to install docker on you local machine.
Then run following to install mssql docker image in your local machine. You can follow this article[https://hub.docker.com/r/microsoft/mssql-server-linux/ ] for more information.
Download and copy the sqljdbc4 Microsoft SQL JDBC driver file to the WSO2 product's/repository/components/lib/ directory
Edit the default datasource configuration in the/repository/conf/datasources/m aster-datasources.xml file as shown below.
<name>WSO2AM_DB</name>
<description>The datasource used for API Manager database</description>
<jndiConfig>
<name>jdbc/WSO2AM_DB</name>
</jndiConfig>
<definition type="RDBMS">
<configuration>
<url>jdbc:sqlserver://0.0.0.0:1433;databaseName=TestDB</url>
<username>sa</username>
<password>Password#123</password>
<driverClassName>com.microsoft.sqlserver.jdbc.SQLServerDriver</driverClassName>
<maxActive>80</maxActive>
<maxWait>60000</maxWait>
<testOnBorrow>true</testOnBorrow>
<validationQuery>SELECT 1</validationQuery>
<validationInterval>30000</validationInterval>
<defaultAutoCommit>false</defaultAutoCommit>
</configuration>
</definition>
</datasource>
Then run following to install mssql docker image in your local machine. You can follow this article[https://hub.docker.com/r/microsoft/mssql-server-linux/ ] for more information.
docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=Password#123' -p 1433:1433 -d microsoft/mssql-server-linux
Then type following and verify your instance is up and running>>docker psCONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES03ebf2498a20 microsoft/mssql-server-linux "/bin/sh -c /opt/mssq" 23 minutes ago Up 23 minutes 0.0.0.0:1433->1433/tcp
docker exec -it /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P
Password#123Download and copy the sqljdbc4 Microsoft SQL JDBC driver file to the WSO2 product's
Edit the default datasource configuration in the
<datasource>
<name>WSO2AM_DB</name>
<description>The datasource used for API Manager database</description>
<jndiConfig>
<name>jdbc/WSO2AM_DB</name>
</jndiConfig>
<definition type="RDBMS">
<configuration>
<url>jdbc:sqlserver://0.0.0.0:1433;databaseName=TestDB</url>
<username>sa</username>
<password>Password#123</password>
<driverClassName>com.microsoft.sqlserver.jdbc.SQLServerDriver</driverClassName>
<maxActive>80</maxActive>
<maxWait>60000</maxWait>
<testOnBorrow>true</testOnBorrow>
<validationQuery>SELECT 1</validationQuery>
<validationInterval>30000</validationInterval>
<defaultAutoCommit>false</defaultAutoCommit>
</configuration>
</definition>
</datasource>
sh wso2server.sh -Dsetup
No comments:
Post a Comment