Database Connection by using jsp page . The URL based mysql connection is ================================= jdbc:mysql://serverip address/DATABASENAME?user=USERNAME&password=PASSWORD ================================= OR ================================= <!-- Database connection settings --> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="connection.url">jdbc:mysql://localhost/database_name</property> <property name="connection.username">databses_user</property> <property name="connection.password">password</property> <!-- configuration pool via c3p0--> ================================= OR =================================...
Category: mysql
mysql
Letter case error in Mysql
If anyone has run into a situation where sql queries from your java app were erroring out because of letter case in tables and column names in MySQL database, I have a quick solution for you. First, what you should...
Linux Commands, mysql
Mysql Commands
To login (from unix shell) use -h only if needed. # mysql -u username -p Create a database on the sql server. mysql> create database ; List all databases on the sql server. mysql> show databases; Switch to a database....
mysql
why mysql_pconnect is disabled on shared server
mysql_pconnect() will maintain a persistent connection to the database. Whenever your script calls the connect to database function, it first searches already existing connections to the database and if exists it will use the same connection to connect to the...