The database is changed from HSQL to MS SQL Server

xiaoxiao2021-03-14  213

Workflow Shark study notes -

Change the data by HSQL to MS SQL Server

Step 1: Modify configure.properties file

DB_Loader_Job = MSQL

# User Credentials for DB Access

DB_USER = SA

DB_PASSWD = AS

# Directory Containing JDBC Driver JAR / ZIP Files

DB_EXT_DIRS = C: /SHARK-1.0/LIB

# Note that the path here uses a backslash, otherwise the characters in Java are transfer characters.

# Msql

MSQL_JDBCDRIVER = com.microsoft.jdbc.sqlserver.sqlserdriver

MSQL_CONNECTION_URL = JDBC: Microsoft: SQLServer: // localhost: 1433; DatabaseName = Shark; SelectMethod = Cursor

# If it is a local database, you can create a new Shark database.

Step 2: Create a database

Execute the configure.bat file, it performs the relevant operation according to the change of the configuration file, where the database changes, it will connect the database to create tables and initialization data.

Compile JSPTEST example

I am used to using JBuiler, so I move the relevant procedures to the JBuilder project, the steps are as follows:

Step 1: New JBuilder Engineering

Set the relevant path, you need to establish an SRC, LIB path

Step 2: Establish WebModule

After the establishment, the content of the file is changed to the content of index.jsp in the example of Shark.

Step 3: Copy JSPClientUtilities.java to the src directory

Open the WAR file in the jspclient example after Shark installation, extract the files in the lib directory to the LIB directory of the current project, a total of 59 JAR files.

Step 4: Modify Shark.conf file

Because I changed the database in front, I also changed here. See how to change, drive, URL, user password, etc.

Step 5: Compile operation

If it is wrong, refer to http://shark.objectWeb.org/doc/1.0/howto/how_to.html

转载请注明原文地址:https://www.9cbs.com/read-129248.html

New Post(0)