Monday, August 30, 2010

Servlet Simple Tutorial

Today 31st August , from many days i was not paying much attention towards Servlet technology as i used to hate it , coz of its compilation and execution but finally today me and my sir was just trying to solve some problems related to this servlet and finally decided to write simple tutorial about executing servlet application!

Creating and executing a servlet is not at all a difficult task once you understand it !

View My Tutorial here

I hope you will get to know about compilation and execution of servlet from this little handy tutorial!
Let me know if am wrong somewhere ,

Thank You ,
Have a pleasant stay!

Sunday, August 29, 2010

Wednesday, August 18, 2010

10g say's Database not open . . .tackle ORA-01219


SQL> startup mount
ORACLE instance started.

Total System Global Area  126951228 bytes
Fixed Size                            454460 bytes
Variable Size                       109051904 bytes
Database Buffers               16777216 bytes
Redo Buffers                      667648 bytes
Database mounted.

SQL> select * from dba_users;
select * from dba_users
              *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only


Now what ? ? ? ? ? ? ?

To check the Database mode :

1) fire up : select open_mode from v$database
2) If its mounted then you need to fire up : alter database open
3) Thats it now you can fire any query you want . . . .

Enjoy 10g ,
Thank You

M.C.A (Pune University)

Dedicated to all M.C.A's of Pune University

  1. M.C.A. Syllabus Download
Will soon upload M.C.A study guide here on site.
Keep visiting,
Thank You,
: Girish . . .

Interview Questions

Hello friends , here you will get some good sites for interview preparation post me your fav sites  . . . .


  1. http://kyapoocha.com/

Monday, August 16, 2010

Mysql Basic

  1. Start mysql from start menu
  2. It will ask you password just enter whatever you specified while installing mysql.
  3. you get mysql> prompt
  4. To view available databases fire up : show databases;
  5. To select database fire up : use databasename;
  6. To show created tables in mysql fire up : show tables;
Very small introduction for connecting to mysql database! rest you can execute your own queries there on prompt...


My SQL Frequent commands :

Reset MySQL password

Some days back  i just forget this password for Mysql and there is very easy way to reset this password, simply follow below steps : (Windows XP)

  1. Go to control panel > administrative tasks > services
  2. Select mysql service from right pane
  3. right click on it and 'STOP' the service
  4. There is a way to start the server with special init file which you can create as follows :
UPDATE mysql.user SET Password=PASSWORD('girish') WHERE User='root';
FLUSH PRIVILEGES;

  • Copy above 2 lines and paste it in notepad and save this file as  : mysqlpwdreset.txt 
  • Now fire up : C:\mysql\bin\mysqld-nt --init-file=C:\\mysqlpwdreset.txt
For More Information Click here
Thats it! Now Fire up your mysql and enter this new password !
Thank You,

Thursday, August 5, 2010

My Typing 2010

Typing speed with perfection is very much import in our IT! I just practice online to improve my speed and am now very much closer to 60 words per minute . . . 


 I hope to increase my typo speed to more than 60 words per minutes.

Online Typo Speed Calculator




Happy Typing !