WSO2 Application Server configuration and MySQL Data Service deployment in windows

[Come, Chi]

 

1. Download wso2 Application Server

Http://wso2.org/downloads/appserver/, download binary. It is recommended that the documentation is also a piece of work, it will be helpful for future deployment.

 

2. Configure java_home

The JDK version is preferably 1.6. There is a color pen saying that his JDK is 1.7, and there is a problem with the configuration, so he ran to Ubuntu... Blind.

In addition, based on the experiences of Su Shen and others,
Java_home must be set to system variables,
Do not set user variables. Otherwise, the service cannot be accessed and cannot be started.

 

 

3. Extract the wso2as-4.1.2.zip to a directory

4.Run install. bat in the bin directory to install

Note:

1. Run the command as administrator in win7

2. some people reported that the page was too large during installation. you can run install. bat. Check the installation result. the following interface should be displayed if the installation is successful. (the horrible run Feng did not know how to use the Administrator permission to open cmd. The method is:
Win-> Enter cmd-> right-click-> Run as administrator)

 

5. Start the wso2 carbon Service

Check whether the wso2 carbon service has been started. If it is not started, start it.

 

 

6. Start Configuration

Enter: https: // localhost: 9443 in the browser to enter the login interface (
May not enter, because the port is blacklisted by the firewall, the simplest way is to close the firewall, you can also change the firewall port settings, add Port 9443, see: http://support.microsoft.com/kb/308127/zh-cn)

Both Username and Password are admin

 

Click the vertical Main tag on the left to view various services.

 

 

Next we will try to configure a MySQL Data Service

 

1. First, install MySQL on the machine and use the default configuration. It is best to use mysql-noinstall for ease of unloading. Normal installation is fine.

(Terror run Feng don't know how to do ...... reference: http://blog.csdn.net/xiaoanian/article/details/7061787)

 

2. Download the MySQL JDBC driver

Here, it's a ZIP file http://dev.mysql.com/downloads/connector/j/.

 

3. Configure the driver

Decompress the ZIP file and put the. jar file in the following path. Do not make any mistakes !!!

In addition, you need to restart the WSO2 Carbon service. The method can be as shown above, or you can enter: net stop wso2carbon (Press ENTER) or net start wso2carbon (Press ENTER) in cmd ).

 

4. Configure MySQL Data Service

Click DataService-> Create on the left side to enter some information.

Click Next.

Click Add New Data Source.

Write a DataSource ID. Select DataSource Type.RDBMS, Click Save

Fill in some configurations,Where

A. Enter the database name for "jdbc url" based on your own. The name here is test.

B. If it is a newly installed MySQL, the default user name is root, and the password is blank (not filled). (Of course, you can also create a user in MySQL first, without the default root)

ClickTest ConnectionYou can see whether it can be connected (start firstMySQLService: the startup method is input in cmdNet start mysql)

If the operation is successful, click Save. You can see that the operation has been successfully created.

 

 

Click Next

Add New Query. You can Add many statements ....

Then go down step by step... Do it yourself. It's quite simple...

For specific usage of Data Service, refer to: http://wso2.org/blog/sumedha/2573

 

You can also deploy a jar file
Jar Service, very simple.

 

No.

 

[Come, chi]