clarify PLEASE – 5. Add the Necessary jQWidgets Scripts and Stylesheets to the P

[LiterateParticipant]

Can anyone PLEASE help clarify this instruction:

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.

[Peter StoevKeymaster]

Hi Literate,

Add the jQWidgets files to the project. This is what is means. Usually, copy the files you will use and paste them into your project.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[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]

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]

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, 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]

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]

3. Add Necessary Classes to the Java Build Path

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

[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.

[Peter StoevKeymaster]

I do not understand the purpose of opening multiple topics about the same question. An answer has already been provided by my colleague, Dimitar – http://www.jqwidgets.com/community/topic/is-this-forum-active/#post-89822. Please, continue the discussion there.

[Author]

Posts