netbeans.apache.org/src/content/kb/docs/javaee/ecommerce/setup.asciidoc - netbeans-website - Git at Google

 //
 //     Licensed to the Apache Software Foundation (ASF) under one
 //     or more contributor license agreements.  See the NOTICE file
 //     distributed with this work for additional information
 //     regarding copyright ownership.  The ASF licenses this file
 //     to you under the Apache License, Version 2.0 (the
 //     "License"); you may not use this file except in compliance
 //     with the License.  You may obtain a copy of the License at
 //
 //       http://www.apache.org/licenses/LICENSE-2.0
 //
 //     Unless required by applicable law or agreed to in writing,
 //     software distributed under the License is distributed on an
 //     "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 //     KIND, either express or implied.  See the License for the
 //     specific language governing permissions and limitations
 //     under the License.
 //

 = The NetBeans E-commerce Tutorial - Setup Instructions
 :jbake-type: tutorial
 :jbake-tags: tutorials
 :jbake-status: published
 :icons: font
 :syntax: true
 :source-highlighter: pygments
 :toc: left
 :toc-title:
 :description: The NetBeans E-commerce Tutorial - Setup Instructions - Apache NetBeans
 :keywords: Apache NetBeans, Tutorials, The NetBeans E-commerce Tutorial - Setup Instructions


 == Tutorial Contents

 1. link:intro.html[+Introduction+]
 2. link:design.html[+Designing the Application+]
 3. link:setup-dev-environ.html[+Setting up the Development Environment+]
 4. link:data-model.html[+Designing the Data Model+]
 5. link:page-views-controller.html[+Preparing the Page Views and Controller Servlet+]
 6. link:connect-db.html[+Connecting the Application to the Database+]
 7. link:entity-session.html[+Adding Entity Classes and Session Beans+]
 8. link:manage-sessions.html[+Managing Sessions+]
 9. link:transaction.html[+Integrating Transactional Business Logic+]
 10. link:language.html[+Adding Language Support+]
 11. link:security.html[+Securing the Application+]
 12. link:test-profile.html[+Testing and Profiling+]
 13. link:conclusion.html[+Conclusion+]

 image::../../../../images_www/articles/68/netbeans-stamp-68-69.png[title="Content on this page applies to NetBeans IDE, versions 6.8 and 6.9"]

 If you want to follow a tutorial unit without having completed previous units, you need to perform some preliminary steps in order to set up your development environment.

 1. *Set up your MySQL database server.* Follow the steps outlined in: link:setup-dev-environ.html#communicate[+Communicating with the Database Server+].
 2. *Create the `affablebean` schema on the database server, and populate the database with sample data:*
 .. Click on link:https://netbeans.org/projects/samples/downloads/download/Samples%252FJavaEE%252Fecommerce%252Faffablebean.sql[+affablebean.sql+] and copy (Ctrl-C; ⌘-C on Mac) the entire contents of the file.
 .. Open the IDE's SQL editor. In the Services window (Ctrl-5; ⌘-5 on Mac), right-click the `affablebean` database connection ( image::images/db-connection-node.png[] ) node and choose Execute Command.
 image::images/execute-command.png[title="Choose Execute Command from a connection node to open the IDE's SQL editor"]
 The IDE's SQL editor opens.

 [start=3]
 . Paste (Ctrl-V; ⌘-V on Mac) the entire contents of the `affablebean.sql` file into the editor.

 [start=4]
 . Click the Run SQL ( image::images/run-sql-btn.png[] ) button in the editor's toolbar. The script runs on your MySQL server. Tables are generated for the database, and sample data is added to the `product` and `category` tables.

 [start=3]
 . *Create a connection pool and JDBC resource on GlassFish.*
 1. In the Services window (Ctrl-5; ⌘-5 on Mac), expand the Servers > GlassFish Server 3 node and choose Properties. In the Servers window that displays, make sure the 'Enable JDBC Driver Deployment' option is selected. If your project requires the MySQL link:http://www.mysql.com/downloads/connector/j/[+Connector/J+] driver, this option will ensure that the driver is deployed to GlassFish when your project is deployed. (If the server is already running, you'll need to restart the server.)
 2. In the Services window, right-click the GlassFish Server 3 node and choose Start.
 3. Once the server is running, right-click the GlassFish Server 3 node and choose View Admin Console.
 4. Log into the console (default username/password is: `admin/adminadmin`).
 5. In the Admin Console, in the Tree on the left, expand the Resources > JDBC node, then click the Connection Pools node.
 6. In the Connection Pools interface, click the New button, and enter the following details:
 * *Name:* `AffableBeanPool`
 * *Resource Type:* `javax.sql.ConnectionPoolDataSource`
 * *Database Vendor:* `MySql`
 image::images/connection-pool.png[title="Specify settings to create a connection pool that connects with a MySQL database"]

 [start=7]
 . Click Next. Accept all defaults and click Finish.

 [start=8]
 . In the Connection Pools interface, click on your newly created `AffableBeanConnectionPool` to make the following change under the General tab:
 * *Datasource Classname:* `com.mysql.jdbc.jdbc2.optional.MysqlDataSource`
 image::images/datasource-classname.png[title="Set the datasource classname for the connection pool"]

 [start=9]
 . Click Save.

 [start=10]
 . Click the Additional Properties tab and ensure that the following three properties have been set. (There may be other properties listed - these are default settings, however the following three must be set manually.)
 * *User:* `root`
 * *Password:* `nbuser`
 * *URL:* `jdbc:mysql://localhost:3306/affablebean`
 image::images/additional-properties.png[title="Set username, password and url to the database"]

 [start=11]
 . Click Save.

 [start=12]
 . Click the General tab, then click Ping. You should see a message indicating that the ping succeeded. The `AffableBeanPool` connection pool can now connect to your MySQL database server.
 image::images/ping-succeeded.png[title="Ping the MySQL server to determine whether the connection pool can connect"]

 [start=13]
 . In the Admin Console's Tree in the left column, click the Resources > JDBC > JDBC Resources node. The JDBC Resources interface opens in the main window.

 [start=14]
 . Click the New button to create a new JDBC resource, then enter the following details:
 * *JNDI Name:* `jdbc/affablebean`
 * *Connection Pool:* `AffableBeanPool`
 image::images/jdbc-resource.png[title="Specify JNDI name and connection pool to create the JDBC resource"]

 [start=15]
 . Click OK.

 You have set up the MySQL server and can connect to it from the IDE's Services window. You created a database named `affablebean`, and populated the database's `product` and `category` tables with sample data. You then started the GlassFish server, and created a connection pool that enables the server to connect to the `affablebean` database. Finally, you created a JDBC resource which your application can use to reference the server's connection pool.

 You can now open and run any of the project snapshots provided for you in the tutorial units.

 link:/about/contact_form.html?to=3&subject=Feedback: NetBeans E-commerce Tutorial - Setup Instructions[+Send Us Your Feedback+]
	//
	// Licensed to the Apache Software Foundation (ASF) under one
	// or more contributor license agreements. See the NOTICE file
	// distributed with this work for additional information
	// regarding copyright ownership. The ASF licenses this file
	// to you under the Apache License, Version 2.0 (the
	// "License"); you may not use this file except in compliance
	// with the License. You may obtain a copy of the License at
	//
	// http://www.apache.org/licenses/LICENSE-2.0
	//
	// Unless required by applicable law or agreed to in writing,
	// software distributed under the License is distributed on an
	// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
	// KIND, either express or implied. See the License for the
	// specific language governing permissions and limitations
	// under the License.
	//

	= The NetBeans E-commerce Tutorial - Setup Instructions
	:jbake-type: tutorial
	:jbake-tags: tutorials
	:jbake-status: published
	:icons: font
	:syntax: true
	:source-highlighter: pygments
	:toc: left
	:toc-title:
	:description: The NetBeans E-commerce Tutorial - Setup Instructions - Apache NetBeans
	:keywords: Apache NetBeans, Tutorials, The NetBeans E-commerce Tutorial - Setup Instructions


	== Tutorial Contents

	1. link:intro.html[+Introduction+]
	2. link:design.html[+Designing the Application+]
	3. link:setup-dev-environ.html[+Setting up the Development Environment+]
	4. link:data-model.html[+Designing the Data Model+]
	5. link:page-views-controller.html[+Preparing the Page Views and Controller Servlet+]
	6. link:connect-db.html[+Connecting the Application to the Database+]
	7. link:entity-session.html[+Adding Entity Classes and Session Beans+]
	8. link:manage-sessions.html[+Managing Sessions+]
	9. link:transaction.html[+Integrating Transactional Business Logic+]
	10. link:language.html[+Adding Language Support+]
	11. link:security.html[+Securing the Application+]
	12. link:test-profile.html[+Testing and Profiling+]
	13. link:conclusion.html[+Conclusion+]

	image::../../../../images_www/articles/68/netbeans-stamp-68-69.png[title="Content on this page applies to NetBeans IDE, versions 6.8 and 6.9"]

	If you want to follow a tutorial unit without having completed previous units, you need to perform some preliminary steps in order to set up your development environment.

	1. Set up your MySQL database server. Follow the steps outlined in: link:setup-dev-environ.html#communicate[+Communicating with the Database Server+].
	2. Create the `affablebean` schema on the database server, and populate the database with sample data:
	.. Click on link:https://netbeans.org/projects/samples/downloads/download/Samples%252FJavaEE%252Fecommerce%252Faffablebean.sql[+affablebean.sql+] and copy (Ctrl-C; ⌘-C on Mac) the entire contents of the file.
	.. Open the IDE's SQL editor. In the Services window (Ctrl-5; ⌘-5 on Mac), right-click the `affablebean` database connection ( image::images/db-connection-node.png[] ) node and choose Execute Command.
	image::images/execute-command.png[title="Choose Execute Command from a connection node to open the IDE's SQL editor"]
	The IDE's SQL editor opens.

	[start=3]
	. Paste (Ctrl-V; ⌘-V on Mac) the entire contents of the `affablebean.sql` file into the editor.

	[start=4]
	. Click the Run SQL ( image::images/run-sql-btn.png[] ) button in the editor's toolbar. The script runs on your MySQL server. Tables are generated for the database, and sample data is added to the `product` and `category` tables.

	[start=3]
	. Create a connection pool and JDBC resource on GlassFish.
	1. In the Services window (Ctrl-5; ⌘-5 on Mac), expand the Servers > GlassFish Server 3 node and choose Properties. In the Servers window that displays, make sure the 'Enable JDBC Driver Deployment' option is selected. If your project requires the MySQL link:http://www.mysql.com/downloads/connector/j/[+Connector/J+] driver, this option will ensure that the driver is deployed to GlassFish when your project is deployed. (If the server is already running, you'll need to restart the server.)
	2. In the Services window, right-click the GlassFish Server 3 node and choose Start.
	3. Once the server is running, right-click the GlassFish Server 3 node and choose View Admin Console.
	4. Log into the console (default username/password is: `admin/adminadmin`).
	5. In the Admin Console, in the Tree on the left, expand the Resources > JDBC node, then click the Connection Pools node.
	6. In the Connection Pools interface, click the New button, and enter the following details:
	* Name: `AffableBeanPool`
	* Resource Type: `javax.sql.ConnectionPoolDataSource`
	* Database Vendor: `MySql`
	image::images/connection-pool.png[title="Specify settings to create a connection pool that connects with a MySQL database"]

	[start=7]
	. Click Next. Accept all defaults and click Finish.

	[start=8]
	. In the Connection Pools interface, click on your newly created `AffableBeanConnectionPool` to make the following change under the General tab:
	* Datasource Classname: `com.mysql.jdbc.jdbc2.optional.MysqlDataSource`
	image::images/datasource-classname.png[title="Set the datasource classname for the connection pool"]

	[start=9]
	. Click Save.

	[start=10]
	. Click the Additional Properties tab and ensure that the following three properties have been set. (There may be other properties listed - these are default settings, however the following three must be set manually.)
	* User: `root`
	* Password: `nbuser`
	* URL: `jdbc:mysql://localhost:3306/affablebean`
	image::images/additional-properties.png[title="Set username, password and url to the database"]

	[start=11]
	. Click Save.

	[start=12]
	. Click the General tab, then click Ping. You should see a message indicating that the ping succeeded. The `AffableBeanPool` connection pool can now connect to your MySQL database server.
	image::images/ping-succeeded.png[title="Ping the MySQL server to determine whether the connection pool can connect"]

	[start=13]
	. In the Admin Console's Tree in the left column, click the Resources > JDBC > JDBC Resources node. The JDBC Resources interface opens in the main window.

	[start=14]
	. Click the New button to create a new JDBC resource, then enter the following details:
	* JNDI Name: `jdbc/affablebean`
	* Connection Pool: `AffableBeanPool`
	image::images/jdbc-resource.png[title="Specify JNDI name and connection pool to create the JDBC resource"]

	[start=15]
	. Click OK.

	You have set up the MySQL server and can connect to it from the IDE's Services window. You created a database named `affablebean`, and populated the database's `product` and `category` tables with sample data. You then started the GlassFish server, and created a connection pool that enables the server to connect to the `affablebean` database. Finally, you created a JDBC resource which your application can use to reference the server's connection pool.

	You can now open and run any of the project snapshots provided for you in the tutorial units.

	link:/about/contact_form.html?to=3&subject=Feedback: NetBeans E-commerce Tutorial - Setup Instructions[+Send Us Your Feedback+]