JAVA Environment setup
Install MySQL (Localhost client)
[Link]
[Link]
Install Navicat (To access Maria DB)
navicat8lite_mysql_en.exe
Install Net Beans (IDE to access code)
Select Tomcat when the option appears in installer
[Link]
Download JXP code from link below,
[Link]
Creating localhost Environment
Installation of MySQL will create localhost environment.
Next step is to create make a db structure of JXP in localhost connection from Navicat
Open Navicat
Click on connections
A window for adding connection details will appear
Initially add Sandbox server details and connect
IP = [Link]
Port = 3306
Database Name = sandbox_cms_jxprodb
User = sbjxprodbuser
Password = cLswI8hesw
Once connected, all db schema and data will be accessible
Create dump SQL of sandbox. Right click on db and option will be there as, “Dump SQL File”. This is backup
of database.
Now we will be creating local environment using this dump file.
Add new connection for local now and add localhost details
Test the connection
If connections give error of authentication please follow steps below,
Log in to your MySQL server using a command-line
Run the following SQL command to update the user's password and set it to use the older authentication
method:
ALTER USER 'your_username'@'localhost' IDENTIFIED WITH mysql_native_password BY
'your_password';
Restart MySQL from services
Test the connection again.
After successful connection, Right click on Connection name and select option “Execute Batch file”
A window will appear, select path of SQL dump file and start the execution.
After successful execution, same database will get crested along with table data in localhost as well.
Running Project from Net Beans
Unzip the code and open it from Net Beans
Paste it and access from Net Beans
From Project structure, edit db connection strings in database properties string to localhost
Find [Link] in project structure
JourneyXPro_Project>jxp>src>java>[Link]
Add localhost details in database properties as,
LOCAL &useSSL=true&requireSSL=true
DriverClassName=[Link]
dburl=jdbc:mysql://localhost/sandbox_cms_jxprodb?characterSetResults=UTF-
8&characterEncoding=UTF-8&useUnicode=yes&autoReconnect=true
dbusername=root
dbpassword=12345
recordsperpage=25
recordsperonline=5
Use correct localhost credentials
Change Global properties to change file path in Local
From Project structure, edit paths in globals
Find [Link] in project structure
JourneyXPro_Project>jxp>src>java> [Link]
C:/Users/sharad/ to project path in system
Save changes
Clean build and run project