=======================================================
1 CHECK JAR FILE IS THERE OR NOT ?
=======================================================
Payara_Server -> glassfish -> lib -> here place all jar file in this repo
Payara_Server -> glassfish -> domain -> domain1 -> lib -> here place all jar file in this repo
=======================================================
2) Creation Of Pull Connection
=======================================================
http://localhost:4848/common/index.jsf
from sidebar in Resources -> JDBC -> JDBC Connection Pools -> New
Pool Name : exam Resource Type : javax.sql.DataSource Database Driver Vendor : MySql
press Next
in Additional Properties section
Add this two Proerties
driver : com.mysql.jdbc.Driver
driverClass : com.mysql.jdbc.Driver
find this properties
User : PhpMyAdmin_Username
Password : PhpMyAdmin_Password
ServerName : localhost
DatabaseName : your_datbase_name
URL : jdbc:mysql://localhost:3306/your_datbase_name
URL : jdbc:mysql://localhost:3306/your_datbase_name
press Finish
=======================================================
3) Creating JNDI Connection
=======================================================
http://localhost:4848/common/index.jsf
**from sidebar **
in Resources -> JDBC -> JDBC Resources -> New
JNDI Name : jdbc/exam // exam is pool name
Pool Name : exam
press OK
=======================================================
4) Ping Connection
=======================================================
http://localhost:4848/common/index.jsf
**
from sidebar **
in Resources -> JDBC -> JDBC Connection Pools
select exam pool
press Ping
=======================================================
ANACONDA 3 ENV SETUP COMMANDS
=======================================================
NUMPY = pip uninstall -y numpy
PANDAS = pip uninstall -y pandas
UNINSTALL = pip uninstall -y setuptools
INSTALL = conda install setuptools
LIB = conda install numpy
conda install pandas
conda install matlotlib
=======================================================
SPYDER START USING CMD
=======================================================
conda create -n spyder-env -c conda-forge spyder python=3.8
conda activate spyder-env
spyder
spyder --new-instance
=======================================================
ORECL STOP COMMAND
=======================================================
/etc/init.d/oracle-xe stop