[LiterateParticipant]

5. Configure the Apache Tomcat Server

my Tomcat and AWS Elastic Beanstalk is already set up

BUT, SHALL FOLLOW tutorial — deleting existing tomcat installation and redoing according to the tutorial

downloaded current version 8.5 tomcat

In Eclipse, go to Window → Preferences. Choose Server → Runtime Environments on the left
Click Add. In the window that appears, choose Apache Tomcat v8.0 and check Create a new local server
Click Next, browse for the Tomcat installation directory, then click Finish and OK in the previous window

ABOVE ALL DONE
NEXT…
Right-click the project and choose Properties. In the Properties window, select Project Facets on the left and then the tab Runtimes on the right. Check Apache Tomcat v8.0. Finally, click Apply and OK.

note, JavaServer Faces IS NOT SELECTED as a Project Facet

DONE

[LiterateParticipant]

4. Add the Necessary jQWidgets Scripts and Stylesheets to the Project

Create two folders in the project folder WebContent – js and css.

Include in them all (or only the necessary) jQWidgets files – the scripts (including jqxcore.js and the specific widget files) in js and the stylesheets (jqx.base.css and any themes and associated images) in css. Remember to include a version of jQuery in js, too.

downloaded jqwidgets-ver4.4.0
in folder jqwidgets selected ALL ninety (90) FILES with js extension
copied and pasted into WebContent/js folder

and the stylesheets (jqx.base.css and any themes and associated images) in css
THIS part is not clear – I copied the jqwidgets/styles/jqx.base.css
and pasted it into WebContent/css folder

Remember to include a version of jQuery in js, too.
downloaded current version jquery-3.1.1.min.js
copied and pasted into WebContent/js folder

DONE

DONE

[LiterateParticipant]

3. Add Necessary Classes to the Java Build Path

Downloaded:

java-rt-jar-stubs-1.5.0.jar
mysql-connector-java-5.1.40-bin.jar
gson-2.8.0.jar

Then followed: Here is how to add these to the Eclipse project:

(even though I normally put these in the lib folder under WEB-INF, shall follow this tutorial as given)

1. The above jar files are NOT already present in JRE System Library.

Next is the first DISCREPANCY —

The added JARs should appear in Java Resources\Libraries and be ready for use:
NOPE, they do not appear there…

step-by-step:
1. Select jQWidgets JSP in Project Explorer
2. Right-click on the project and click Properties
3. Select Java Build Path on the left and then the Libraries tab
4. Click Add External JARs… and browse for the aforementioned files.
5. The added JARs should appear in Java Resources\Libraries and be ready for use

NOPE, they appear in a new folder called Referenced Libraries (this may impact the run as it may or may not know where to find the jars)

Shall find out as we continue the tutorial
http://www.jqwidgets.com/jquery-widgets-documentation/documentation/java-integration/configure-mysql-eclipse-tomcat.htm#Step1

[LiterateParticipant]

2. Create a New Project in Eclipse

NOTE:
Dynamic Web Project. In the window that appears, type the project’s name (we will name it “jQWidgetsJSP”) and click Finish.

The second part is a JSF web application: Bind jqxGrid to MySQL Database Using JSF (JavaServer Faces)

2. Create a New Project in Eclipse – DONE

In this tutorial, we will be using Eclipse IDE for Java EE Developers, version Luna. You can get it from here: https://www.eclipse.org/downloads/packages/eclipse-ide-java-ee-developers/lunasr2. Run Eclipse and go to File → New → Dynamic Web Project. In the window that appears, type the project’s name (we will name it “jQWidgetsJSP”) and click Finish.

[LiterateParticipant]

beginning with:

http://www.jqwidgets.com/jquery-widgets-documentation/documentation/java-integration/configure-mysql-eclipse-tomcat.htm#Step1

1. Set Up a Database – DONE

completed using MySQL WorkBench following this additional tutorial:
http://www.inoreader.com/article/3a9c6e7fdc3fe2ac-creating-a-mysql-database-via-the-command-line

tested using SHOW DATABASES;
to confirm

[LiterateParticipant]

The linked instructions DO NOT WORK…
I am going to go through it STEP-BY-STEP and share what does not work…

http://www.jqwidgets.com/jquery-widgets-documentation/documentation/java-integration/bind-jquery-grid-to-mysql-database-using-jsf.htm?search=

This initial tutorial begins with stating:

1. Set Up a Database

Our goal is to populate a jqxGrid from a MySQL database. In the example presented here, we will be using the Northwind database. To learn how to set it up, please follow Step 1 from the help topic Configure MySQL, Eclipse and Tomcat for Use with jQWidgets.

which will not CONNECT to the current tutorial at

http://www.jqwidgets.com/jquery-widgets-documentation/documentation/java-integration/bind-jquery-grid-to-mysql-database-using-jsf.htm?search=

because:

1. The file directory structure is NOT created the same.
To explore in detail, step-by-step:

[Author]

Posts