Master-Slave Replication in MySQL
Master-Slave Replication is a robust and widely used mechanism in MySQL database management systems that enhances data availability, scalability, and fault tolerance. This replication model involves two types of database servers: the Master, which holds the primary copy of the
Importance of Website for Business – Part 2
In our previous post in this series of articles explained the importance of having a website for your business. In this post we will cover some more benefits of websites and features your website can provide in case you want
Importance of Website for Business – Part 1
Changing times need change in business strategies. Today’s business strategies and processes are far different from the strategies which were used in past. Earlier people used to rely on newspapers classifieds or references but now huge mass types it into
Digital Signature using Zoho Creator
Digital signatures/online signatures, as we all know, play a very important role in online industry. The simple idea of using a digital signature results in reducing the paperwork and saves time. Zoho Creator has provided “signature” feature for online signing
YUI3 Panel background shading and position problems
By default YUI3 assigns yui3-widget-mask class for background shading. To override that we need to change its style properties. Similarly for position of the panel, it can be changed by specifying position property of .yui3-panel class. These are the methods
Eclipse – Stop auto jumping to the file in project explorer (disable link with editor)
When you switch among opened files in eclipse, project explorer moves to the currently active file (in left pane). This can be annoying several times. To disable this just make sure icon with double arrows in Project Explorer (top right
iFrames, Javascript events and IE problems
Several hours wasted while debugging this. We have a, HTML page and within this page is a hyperlink to open another page in iFrame. While iFrame page is loaded we display WAIT message overlay on parent page so as to
Connection Pool with Tomcat6 and Mysql
Inside $tomcat_home/conf/context.xml add this inside <Context> <Resource name=”jdbc/datasourcename” auth=”Container” type=”javax.sql.DataSource” maxActive=”100″ maxIdle=”30″ maxWait=”1000″ username=”dbuser” password=”dbpwd” driverClassName=”com.mysql.jdbc.Driver” url=”jdbc:mysql://localhost:3306/exodus”/> Now restart tomcat Inside you web.xml add this before </web-app>: <resource-ref> <description>My DB Connection</description> <res-ref-name>jdbc/datasourcename</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> Java code to connect: Context
ORA-28001: the password has expired
That’s the error you get for oracle user for whom password is expired. One Solution – Connect using sqlplus to set new password, you can even use the same password you had earlier. $ sqlplus SQL*Plus: Release 11.2.0.1.0 Production on
Oracle Privileges to Import/Export data into any tablespace
Generally we can have a single user with DBA rights to import/export (using imp/exp utilities) data into any tablespace instead of assigning these privileges to every user account. Suppose you have an oracle user appdba. Grant DBA role to appdba