[LiterateParticipant]

Yes, you are the best Dimitar. Please say Hi to Peter.

Shall continue the detailed review using email, THANK YOU!

Am very excited that your wonderful components shall work.

Jon

[LiterateParticipant]

I am putting the three jar files in
WebContent | WEB-INF | lib
3. Add Necessary Classes to the Java Build Path

Several Java class packages (.jar files) are necessary for the jQWidgets examples and have to be included in the Java build path. These are:

java-rt-jar-stubs-1.5.0.jar – contains all of the compiled class files for the base Java Runtime Environment.
mysql-connector-java-5.1.34-bin.jar – MySQL Connector/J is the official JDBC driver for MySQL. It is necessary for the connection to the MySQL database.
gson-2.3.1.jar – Gson is a Java library that can be used to convert Java Objects into their JSON representation.

QUESTION: Should I use these versions? or the updated versions?

This is a conflict, because in the original the first step was to create a MAVEN Project, which then has the link to the current tutorial which does not use maven

tells you to go to

the two do not match in the instructions, beginning with either putting the jars into the lib and adding the class path OR using Maven.

Anyway, this is the first confusion — shall locate current versions and convert Project to Maven to gather latest versions, shall post the version numbers here, as this may result in the tutorial NOT functioning.

[LiterateParticipant]

3. Add Necessary Classes to the Java Build Path

Why don’t you use Maven in this beginning example?

[LiterateParticipant]

OK, Excellent. In Setting up the database. I was able to use MySQL Workbench to:

Create a new schema on AWS using the northwind SQL script you provided.

How refreshing to see something actually work.

Onward to 2. Create a New Project in Eclipse

Thank you.

[LiterateParticipant]

Peter, I am going to go through each step of Bind jqxGrid to MySQL Database Using JSF (JavaServer Faces)

It should work, right? If I follow exactly as shown, ok.

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.

Shall try now, and report back success.

[LiterateParticipant]

How can I place images here without a url, is it possible to upload the image or do I need to put the image on the web and include a URL ?

[LiterateParticipant]

Peter, if you can show me how to get the grid and the scheduler to work, you have a customer.

All I want, is to see my data populate in your components.

I am interested in hierarchy to display a master-detail – row within a row

[LiterateParticipant]

Hello, Peter. Yes, I have the instructions on my screen right now.

I am trying the

First, I do not have a local copy of the northwind database.

I located a script on the web but I cannot get it to run the SQL script.

I tried to modify the current controller and xhtml files but it is still not running.

Any ideas on how to use everything in the example, as how to use the northwind database ?

[LiterateParticipant]

Found it…

[LiterateParticipant]

did not work
first error is something that has to do with Access denied for user ‘root’@localhost’ (using password: YES)

HAS ANYONE GOTTEN the tutorial to work?

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

I am going to try this tutorial OVER HERE to see if I can resolve a JSON STRING data binding to jqxGrid, jqxCalendar, jqxSchedule.

If anyone is interested in how I may or may not have succeeded, that is if you also have interest in data binding, please place a note here.

Off to find a solution that will work, as the posted tutorial does not seem to work.

http://www.programming-free.com/2013/03/ajax-fetch-data-from-database-in-jsp.html

[LiterateParticipant]

6. Create the View
NOTE, the “controller” does not have the usual Model and uses a managed bean for both the data connection and the model without any getters or setters?

The View is where the jqxGrid with the employee data will be displayed. Create a new XHTML Page in src\main\webapp\WEB-INF and name it grid.xhtml. This page will serve as the View. Here is its content:

copied the exact code as is in the tutorial

shall attempt to run grid.xhtml

[LiterateParticipant]

Go to File → New → Maven Project.

DO NOT CREATE NEW PROJECT… as we are using our current JSP project that must made into a JSF project (not included in the tutorial)

jumping to step 4
4. Create the Managed Bean
Package name: com.jqwidgets
Java Class name: EmployeeController

copied the exact code in the tutorial and pasted into EmployeeController.java

Create a new class, EmployeeController in the package com.jqwidgets with the following content:

DONE

NOTE: 4 errors I think may be due to FACES not included
including JavaServer Faces in Project Facets now

EXCELLENT… all 4 errors went away!

continuing…

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

Create a resources folder in src\main\webapp and in it add two more folders – 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.

ALREADY COMPLETED PRIOR IN THE ABOVE POSTS

[LiterateParticipant]

NOTE, THIS specific tutorial is difficult to find:
http://www.jqwidgets.com/jquery-widgets-documentation/documentation/java-integration/bind-jquery-grid-to-mysql-database-using-jsf.htm?search=
Bind jqxGrid to MySQL Database Using JSF (JavaServer Faces)

I found it by google and NOT by any link on the http://www.jqwidgets.com website

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.

DONE ALREADY and confirmed using

tested using SHOW DATABASES;
to confirm

[LiterateParticipant]

Ran a validate on jQWidgetsJSP

got 3 warnings:

Runtime ClassNotFoundException may result

on all three jars:

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

am going to try to copy and paste the same three files into the WEB-INF/lib folder
to see if the same validation errors occur

same three validation errors

shall change class path to match those within the lib as INTERNAL jars not EXTERNAL

EXCELLENT, no more validation errors…

ok, now on to the next tutorial to get the web app up and running

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

[LiterateParticipant]

6. Start the Server and Configure Its Classpath

In the bottom panel of Eclipse, select the Servers tab.
Right-click on Tomcat v8.0 Server at localhost and click Start

DONE

Go to Run → Run Configurations…
In the pop-up window, select Apache Tomcat → Tomcat v8.0 Server at localhost on the left and then the Classpath tab. Add the external JARs mysql-connector-java-5.1.34-bin.jar and gson-2.3.1.jar:

note — there is NO POP UP WINDOW

I right clicked on the Project and selected Run As / Run Configurations…
and completed the above SAME instructions

select Apache Tomcat → Tomcat v8.0 Server at localhost on the left and then the Classpath tab. Add the external JARs mysql-connector-java-5.1.34-bin.jar and gson-2.3.1.jar:

Apply the settings and click Close.
Your project is now set up and you can proceed with any of the following tutorials showcasing jQWidgets components loaded through JSP:

DONE

NOTE: THIS IS THE jQWidgetsJSP Project that has been created.

Moving on to

Bind jqxGrid to MySQL Database Using JSF (JavaServer Faces)
http://www.jqwidgets.com/jquery-widgets-documentation/documentation/java-integration/bind-jquery-grid-to-mysql-database-using-jsf.htm?search=

which is NOT a JSP project, but a JSF project

[Author]

Posts