Archive for the ‘Database’ Category
Configuring MySQL without Password on Ubuntu
Posted by: Chyne on: November 3, 2009
Everytime when I access to mysql database that is installed in my laptop, I need to perform the following command in order to get the access:
sudo mysql -hlocalhost -ppassword
I feel frustrated and tedious to do that everytime when I need to access to the database. If I try it with the command ‘mysql’, I will [...]
How to Reset Postgres Forgotten Password?
Posted by: Chyne on: September 28, 2009
Today, I was being asked whether I know any methods on how to retrieve or reset Postgres password. Although we had done some research but the provided solutions are quite confusing and not giving detailed explanations. We just left the research aside and continue with our work but I still feel this is doable. The [...]
“No suitable driver” for PostgreSQL
Posted by: Chyne on: September 6, 2009
Error message when performing a connection the postgreSQL database:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.asip.servlet.ProcLogin.doPost(ProcLogin.java:73) // source code line that throws this error
Possible Root Causes & Solutions
The jdbc jar file is not yet added into the project.
Right click the project
Properties > Libraries > Add External JARs (Applicable for Eclipse)
Add the jar file (postgresql-x.x-xxx.xxx.jar)
Restart [...]
Day 8 – Database
Posted by: Chyne on: August 31, 2009
Overview
- Structured collections of records or data.
Database Models
• Flat model – spreadsheet
• Hierarchical model – XML
• Relational model
Views
- Virtual or logical table
- Subset the data contained in a table
- Security purpose (limit expose)
Database Indexing
- Improves the speed of operations in a table
Transaction and Concurrency
- Interaction with a database management system.
- Series of commands (can consist of multiple SELECTs)
ACID
• Atomicity – Either the transaction must be completed [...]
Installation of Bugzilla in Ubuntu Environment
Posted by: Chyne on: August 4, 2009
- In: Linux| MySQL| Others
- Leave a Comment
I’ve been playing around with the Bugzilla in order to understand how it works together with the system. I was being provided with the information about the flow of how to migrate the bug issues to the system but there are no detailed instructions on how to install Bugzilla. Although the main point is not [...]
Search
- The BASEDIR environment variable is not defined correctly. This environment variable is needed to run this program
- The Reason behind Oracle 11g: SEVERE: Error while registering Oracle JDBC Diagnosability MBean
- Why Windows Subsystem Process Terminated Unexpectedly?
- java.io.FileNotFoundException with (Permission Denied)
- Installation of Subversion 1.6.5 on Ubuntu 8.10
- Installation of Bugzilla in Ubuntu Environment
- 'Interface was expected' for JPEGImageEncoder
- SSL Certificate is not imported properly - 'unable to find valid certification path to requested target'
- How to Install Mantis in Ubuntu?
- Firefox ASSERT: *** Search: _installLocation: engine has no file!
- Polprav: Hello from Russia! Can I quote a post in your blog with the link to you?
- Alex: Huge Thanks! This bug has annoyed me for a long time.
- Donnieboy: Just wanted to drop you a line to say, I enjoy reading your site. I thought about starting a blog myself but don't have the time. Oh well maybe one
RSS - Posts