NetBeans Support Weblog

The Solaris Express Developer Edition 1/08 (SXDE 01/08) comes with NetBeans 6.0  IDE . Also, since SXDE 01/08 also offers the Web Stack as part of the install it is more inviting for developers to consider it their platform of choice. The Web Stack is compromised of  the AMP (Apache, MySQL, and PHP) a collection of open source software to build and deploy web applications on Solaris. You do not need to download these separately.  Now you can use NetBeans6.0 with the Web Stack .  The neat feature is you can access all the applications from the Launch menu, including  NetBeans.  

Below I am describing how to develop a Web Application using the Web Stack with NetBeans 6.0 .  To keep it simple, I am using the NetBeans tutorial Creating a Simple Web Application in NetBeans Using MySQL .  The following software is required for this tutorial. Since you are working on SXDE 01/08, you do not need to install any of it. The beauty of  SXDE 01/08 is that it all comes with it.

• NetBeans IDE 6.0 (Part of SXDE 01/08)
  
• Java SE Development Kit (JDK™) version 6.0
• MySQL database (Part of the Web Stack)
  
• JDBC Driver for MySQL (Part of  NetBeans 6.0)
  
• Tomcat 6.0 (Part the Web Stack)

Before you get started , you need to create a local user on your system. This will not work with a remote user login. Once you have the SXDE 01/08 installed and a local user created, you can login as the local user. Below are the steps required to make the tutorial work with the Web Stack.

Initialize the Development Environment
For this you need the root password, so be prepared with the password information.  To Initialize your Web Application Development environment, click on the Launch menu, and select All Applications > Developer Tools > Web Stack Admin > Initialize. Once you have initialized the development Environment, now you can view the complete Web Stack menu.

Start the Apache2/MySQLservers
To do this click on the Launch menu, and select All Applications > Developer Tools > Web Stack Admin > Start Apache2/MySQL Servers.

Registering the Web Stack Tomcat Server with the IDE
To do this, in the IDE, go to Services Tab -> Servers. Right click and choose Add Server . From the server list choose Tomcat 6.0 .  Make sure to enter the path to the tomcat server. See the screen shot below for all the fields.

Preparing the Database in NetBeans IDE: For this section of the tutorial, follow steps as per below.

# /usr/mysql/5.0/bin/mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.45 Source distribution

mysql> create database MyNewDatabase;
Query OK, 1 row affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| MyNewDatabase      |
| mysql              |
| test               |
+--------------------+
4 rows in set (0.00 sec)

2) Connecting to MySQL database in the NetBeans IDE. Go to the Services tab. Right click on DataBases node , and select New Connection. In the New Connection window enter the parameters as shown in the screen shot below:

3) Create the tables.  I used the SQL editor in NetBeans to create the tables. To do this in the Database explorer, right-click the Tables node beneath the MyNewDatabase connection node and choose Execute Command. A blank canvas opens in the SQL Editor in the main window.In the SQL Editor, just copy and paste the code from ifpwafcad.sql. file (this is in the original tutorial). Then run the query from the SQL Editor menu. Refresh the MyNewDatabase connection and you can now view the tables by expanding the tables node.

Setting up a JDBC Connection Pool: In this step, if you do not have the Tomcat administration tool installed you can edit the Tomcat's server.xml file. You can access this file from within the IDE from the Services tab. Expand the Servers -> Tomcat6.0 and right click and choose Edit server.xml. Add the following to the server.xml:

<Context path="/IFPWAFCAD" docBase="IFPWAFCAD" debug="5"
reloadable="true" crossContext="true">

<Resource name="jdbc/connectionPool" auth="Container"
   type="javax.sql.DataSource" removeAbandoned="true"
   removeAbandonedTimeout="30" maxActive="4"
   maxIdle="2" maxWait="5000" username="root"
   password=""
   driverClassName="com.mysql.jdbc.Driver"
   url="jdbc:mysql://localhost:3306/MyNewDatabase"/>

</Context>

That's it ! Now simply follow the tutorial as is.  Below are some links to Solaris Express Developer Edition.

Solaris Express Developer Edition Home Page

Community