Publish quizzes, exams, tests of any type (IT Certifications, SAT…).

Score Result is immediate for test takers: questions are listed with users answers marked if correct or not. An explanation is shown if provided. Each score has its unique URL for access. Registred users can see all their scores by simply clicking on “My passes” (top right). The test page lists recent scores.

You can protect a test with a password so only people with it, can access it. A Future update to Derbyware will add the capability to approve users for access to your exams, instead of passwords.

Start working on a quiz, come back later, pick from where you left (By clicking on "Drafts" Button on the upper left corner). When you finish and ready to publish click “Done”.

Embed your tests in your website (like a youtube video) by scrolling down until you see the “embed” button on the test page. Click it. Copy and paste the code in your website.

Features include: Users voting on Tests, Comments.

• Screen Candidates using 'Generate One Time Link' for your tests
• Score Result is immediate
• You can also protect a test with a password so that only people who has it, have access to it.
• Start working on a quiz, come back later, pick from where you left (By clicking on "Drafts" Button on the upper left corner). When you finish click the button “Done” to publish
• Embed your tests in your website (like a youtube video) by scrolling down until you see the “embed” button on the test page. Click it. Copy and paste the code in your website.

• ·        JDK 8.0_141 or later up to 8.0_241 . does not support Java 9 or later
• ·        Glassfish 5.1 or Payara 5.194 or later
• ·        MySQL 8
• ·        Maven
• ·        IDE of your choice.

A Docx with images is included in zip file. this is text only

Note : this application uses Metronic Theme v5. You must buy a license from metronic developers.

2. Setup MySQL Database

Open MySQL workbench (on Windows MySQL service must be running)

Create Database named ‘sampledb.

Save database username, password, host, port you will need them to connect the application to the database later.

3. Staring the Server

Copy “mysql-connector-java-8.0.19” under “locationofserver\payara201\glassfish\domains\domain1\lib”

Payara201 is the name of the folder your server is at. It could be any name.

Start Glassfish/Payara. (make sure your path environment variable is set to JDK 8.)

Go to http://localhost:4848/

Creating JDBC Connection Pool:

Got to Resources/JDBC/JDBC Connection Pools

Click Button.

Fill in the fields like the followling image

Click Button.

Scroll down to Additional Properties.

Select and remove all properties and enter these ones:

Don’t forget to change user and password values.

Click Finish.

Go to Resources/JDBC/JDBC Resources

Enter JNDI Name and pool name:

Click OK

Setting up Security Realm:

Go to Configurations/server-config/Security/Realms

Click New

Enter:

Name: QTubeRealm

JAAS Context: jdbcRealm

JNDI: jdbc/qtube

User Table: sampledb.user

User Name Column: EMAIL

Password Column: PASSWORD

Group Table: sampledb.user_group_join

Group Table User Name Column: USER_ID