FAQs about Tomcat and MySQL

Dataworks OA adopts Tomcat 6 and mysql5, related solutions for Tomcat startup, MySQL startup, MySQL Case sensitivity, MySQL encoding, and Java connection to MySQL.

 

1.Delete MySQL from the service

If you have installed different versions of MySQL, the old MySQL process exists in the service when the uninstallation is not clean, resulting in MySQL cannot be started normally. Enter: SC Delete MySQL can delete related services.

 

2.TomcatMySQL is automatically started at startup.

Add start mysqld.exe at the beginning of Tomcat startup. bat.

 

3.TomcatDetermine whether MySQL is started at startup

Add the following at the beginning of Tomcat startup. BAT:

Tasklist | find "mysqld.exe"

If errorlevel 1 (

Start mysqld.exe

Goto list

)

: List

 

4.MySQLCase sensitivity of tables

Add lower_case_table_names = 1 to MySQL. ini to indicate case insensitive, just like MSSQLServer.

 

5.MySQLEncoding and JavaConnect to MySQL

We use GBK encoding and add the following to MySQL. ini:

Default-character-set = GBK

Character_set_server = GBK

Use

JDBC: mysql: // localhost: 3306/sz_groupoa? Useunicode = true & characterencoding = GBK

This is consistent with MSSQLServer.

 

The above points are used in dataworks 294924968. For specific applications, you can download them at www.saas88.com. If you have any questions or suggestions about Tomcat and MySQL, contact QQ:. Email: soarwell@qq.com; Tel: 0755-25580288