Grow Up With Technologies...

Import SQL file using command line in MySQL

2017-03-10T14:21:00.001+05:30

Step-1: Open the MySQL command line

Step-2: Type the path of your mysql bin directory and press Enter (optional)

Step-3: Paste your SQL file inside the bin folder of mysql server

Step-4: Create a database in MySQL

Step-5: Use that particular database where you want to import the SQL file

Step-6: Type 'source file.sql' and Enter

Step-7: Your SQL file upload successfully

I prefer this one since it handles larger files with ease!

Regards

Ajay Singh

Info, Error, Success and Warning Message Box

2013-06-04T16:22:00.000+05:30

Message Box Demo

This is just a quick post to share something that I use all the time. These are handy to bring peoples attention to certain messages you want to get across and for things like form validation. In fact, I use these on almost every website I build, particularly those with contact forms and other important messages (regarding payment gateways etc).

As you can see with these examples you can put the class directly on a paragraph tag or on a div with multiple paragraphs or other elements inside it. You can also make use of strong tags to make a word or phrase really stand out.

The CSS code can be found below. It's worth noting that you may have to change the background position values depending on your preferred font size and line height settings for things to look right.

Results

This is an important information

The operation is succeessful.

Now this is a warning! please try once more.

Ooops, an error occurs, please try again?

With icons, as seen in the above picture, use this following CSS code:

.info, .success, .warning, .error, .validation { outline: 0 none; border: 1px solid; margin: 10px 0px; padding: 20px 10px 20px 60px; background-repeat: no-repeat; background-position: 10px center; box-shadow: 0 0 8px rgba(0, 0, 0, 0.1); font: 12px/100% Verdana,Tahoma,sans-serif; background: -moz-linear-gradient(center top , #FFFFFF, #EEEEEE 1px, #FFFFFF 25px) repeat scroll 0 0 transparent; }

.info {color: #00529B;background-color: #BDE5F8;background-image: url('info.png');}

.success {color: #4F8A10;background-color: #DFF2BF;background-image:url('success.png');}

.warning {color: #9F6000;background-color: #FEEFB3;background-image: url('warning.png');}

.error {color: #D8000C;background-color: #FFBABA;background-image: url('error.png');}

Download Images

Hopefully someone will find this little snippets useful, I know I do!

Pen Drive and Window XP

2013-01-31T08:50:00.001+05:30

Repair pen drive's all folder become shortcut...
Some time when you connect your pen drive in infected computer or in any cyber cafe, unfortunately all his data in the pen drive corrupted or all folder become short cut. If you are facing the same problem, do not panic because your entire file still exists but only hidden by virus. Follow instructions below:
1. Click Start
2. Go to run
3. Type cmd
4. Type your pen drive path (like G drive)
5. Run the following command
a. attrib -h -r -s /s /d g:\*.* (then press enter)
8. Reboot your computer.
9. You can now access your drive now

Delete Autorun.inf from your pen drive...
If you cannot open your pen drive, your Pen Drive might infect with autorun.inf. Follow instructions below:
1. Click Start
2. Go to run
3. Type cmd
4. Type your pen drive path (like G drive)
5. Run the following command one by one:
a. attrib –h –r –s autorun.inf (then press enter)
b. del autorun.inf (then press enter)
c. mkdir autorun.inf (then press enter)
8. Reboot your computer.
9. You can now access your drive now

Hope above method will help you to solve your problem.

thanks
ajay singh

Window 7 - Enable/Disable Task-bar Thumbnail Preview

2012-12-11T14:11:00.002+05:30

The process to Enable/Disable Taskbar Thumbnail Preview in Windows 7

1. Click on Start button, select Run and type GPEdit.msc in box, then hit to Enter button.
2. Select User Configuration and double click on Administrative Templates. Click on Start Menu and Task-bar in left pane of Local Group Policy Editor.
3. Locate and double click on "Turn off taskbar thumbnails" in right pane of Local Group Policy editor.
4. Select Enabled radion button.
5. Click OK to make the change effective.
6. Logoff and logon again or restart computer if needed.
7. To re-enable Taskbar preview feature in Windows 7, just set the value to Disabled or Not Configured.

Thanks
Ajay singh

Unable to open the Tomcat Service

2012-09-05T08:37:00.001+05:30

After installing tomcat (any version) on windows 7, you will see this error when you restart the your system .

1. Application System Error
2. Access is Denied
3. Unable to open the service 'Tomcat6'

This error is confusing at first because it says "service".

Users will think there is some problem with the tomcat service. But this error is related to the Tomcat Monitor (tomcat7w.exe) and User Account Control (UAC) in windows.

There is an easy and better approach to fix this problem, in this we are allowing the program to run as administrator always...

1. Go to the %CATALINA_HOME%\bin directory.
2. Right click on tomcat6w.exe
3. Select Properties
4. Go on Compatibility tab.
5. Under Privilege Level, select Run this program as an administrator,
6. Click OK.

Hope, it will help to solve your problem.

Thanks
Ajay Singh

About Domain and Hosting

2012-01-04T09:38:00.000+05:30

What is web hosting?

Web hosting is a service that enables us to showcase our website on the internet. Through the web hosting service provider we can rent a space on the Internet servers where we can store your website's content.

Why get a domain?

A domain name is the address that helps people find our website online. It is what you usually type in your browser's address bar to visit a specific website or location on the Internet. Just as homes and offices have addresses, all websites have a unique domain name. We need a domain name to ensure our website has its own special address on the web.

How to choose a domain?

Choosing a good domain name is very important for your business. Choose a domain name that -

Reflects our business name or the topic of our site.
Is unique and short - one that is easy to say, remember and spell.
Has letters, numbers, and hyphens. Spaces or other symbols are not allowed.

Remove Windows XP Service Pack 3 from your computer

2011-09-12T10:48:00.001+05:30

Dear all,

Here is some simple process where you can uninsulated your window xp service pace 3, the method are like this...

Method 1: Use the "Add or Remove Programs" item in Control Panel..
1. Click Start, and then click Run.
2. Copy and then paste the following command in the Open box, and then press ENTER: appwiz.cpl
3. Click to select the Show Updates check box.
4. Click Windows XP Service Pack 3, and then click Remove.
5 Click Finish to restart the computer after the removal process is complete.

Method 2: Use the hidden $NtServicePackUninstall$ folder (easy process)
1. Click Start, click Run, type c:\windows\$NtServicePackUninstall$\spuninst\spuninst.exe in the Openbox, and then click OK.
2. When the Windows XP Service Pack 3 Removal Wizard starts, click Next.
3. Follow the instructions on the screen to remove Windows XP SP3.

Method 3: Use the System Restore process
Note Before you use System Restore, make sure that you have restarted the computer at least one time after you installed Windows XP SP3. By restarting the computer, you allow for any remaining servicing processes to finish.
1. Click Start, and then click Run.
2. Copy and then paste the following command in the Open box, and then press ENTER:
%systemroot%\System32\restore\rstrui.exe
3. Click Restore my computer to an earlier time, and then click Next.
4. Click the date on which you installed Windows XP SP3, and then click Installed Window XP Service Pack 3 in the Restore Point box.
5. Click Next, and then follow the instructions on the screen to remove Windows XP SP3.

Source: http://support.microsoft.com/kb/950249

Thanks
Ajay singh

Remove window genuine advantage notification

2011-04-04T23:48:00.001+05:30

Hi,

When your window XP operating system is not genuine, you will see always an error like this....

There are a lot of method to remove this type of error and one of them i am going to do here. I am going to write here some step which one is useful to permanently remove the window genuine advantage notification from the Window XP Operating System.I have test it on my own system and it works fine in the first steps...So follow this step one by one...
1. Open a Command Prompt window by clicking on 'Start' and then 'Run'
2. Type 'system32' and press OK.
3. Or Other method is type 'cd \windows\system32'
3. In 'system32' directory go to 'Tools > Folder options', click on the tab 'View', and uncheck 'Hide extensions for known file types' if it is not already.
4. Find 'WgaLogon.dll' file.
5. Rename this file some other name like 'WgaLogon.dll.bak.
6. Create an empty new text file and name it as WgaLogon.dll' (see the process below).
a. Right click on a blank space in 'system32' and select 'New > Text Document'.
b. Leave the text document empty and label it 'WgaLogon.dll'. Press Enter (from your keyboard).
c. Here you may get a warning from the above step that says, 'If you change a file name extension, the file may become unusable. Are you sure you want to change it?'. Click 'Yes' on this warning.
7. Open Task Manager by the following one method....
a. Press the 'Ctrl+Shift+Esc' keys simultaneously.
b. Or press the 'Ctrl+Alt+Delete' keys simultaneously.
c. Or Right click the Taskbar and selecting 'Task Manager'.
8. Click on the 'Process' tab.
9. Find the 'WgaTray.exe' here.
10. Go to the 'system32' directory and Find 'WgaTray.exe'.
11. Select this 'WgaTray.exe' and press 'delete' button.
12. It will ask for confirmation to delete but do not confirm for delete?
13. Go to the 'Task manager > Process' tab, then select 'WgaTray.exe' and click on the 'End Process'. Go for the confirmation to end the process.
14. Quickly go to the confirmation when you delete the 'WgaTray.exe' fro the 'system32' directory.
15. For the step 11 and step 13, you have less than 5 second to complete both of the task.
16. To remove the notifications after this, do the following steps
a. Return to 'system32'.
b. Find the two files 'WgaLogon.dll.bak' and an Application Extension (0KB) called 'WgaLogon.dll'.
c. Delete Application Extension
d. Rename 'WgaLogon.dll.bak'. to 'WgaLogon.dll'
e. Repeat the steps from the fifth one onwards at a greater speed?
17. Restart your computer once you have finished.

I am sure that it will help you to solve the solution,

Thanks
Ajay Singh

Speed up your PC - Disk Cleanup to run automatically

2011-03-21T09:47:00.000+05:30

Hi,

Here is the process that how to set up Disk Cleanup to run automatically for the windows...

1. Windows 7

a. Open Task Scheduler: Click the Start button, click Control Panel, click Administrative Tools, and then double-click Task Scheduler. If you're prompted for an administrator password or confirmation, type the password or provide confirmation.
b. Click the Action menu, and then click Create Basic Task. This opens the Create Basic Task Wizard.
c. Type a name for the task and an optional description, and then click Next.
d. To select a schedule based on the calendar, click Daily, Weekly, Monthly, or One time, and then click Next.
e. Specify the schedule you want to use, and then click Next.
f. Click Start a program, and then click Next.
g. Click Browse, and, in the File name box, type cleanmgr.exe, click Open, and then click Next.
h. Click Finish.

2. Windows Vista
a. Open Task Scheduler: Click the Start button, click Administrative Tools, and then click Task Scheduler. If you are prompted for an administrator password or confirmation, type the password or provide confirmation.
b. Click the Action menu, and then click Create Basic Task.
c. Type a name for the task and an optional description, and then click Next.
d. To select a schedule based on the calendar, click Daily, Weekly, Monthly, or One time, and then click Next.
e. Specify the schedule you want to use, and then click Next.
f. Click Start a program, and then click Next.
g. Click Browse, and, in the File name box, type cleanmgr.exe, click Open, and then click Next.
h. Click Finish.

3. Windows XP
a. Click Start, and then click Control Panel.
b. Click Performance and Maintenance.
c. Under or pick a Control Panel icon, click Scheduled Tasks.
d. In the Scheduled Tasks window, double-click Add Scheduled Task.
e. In the Scheduled Task Wizard, click Next.
f. Scroll down to Disk Cleanup in the list of Applications, click it (to highlight it), and then click Next.
g. Under Perform this task, click Weekly, and then click Next.
h. Set the time and day of the week you would like to run Disk Cleanup. For best results, choose a time
when you're typically at your computer so you can provide any required input. Click Next.
i. Type your password in both the Enter the password and Confirm password boxes, and then click Next.
j. Click Finish.

Thanks
Ajay Singh

Speed up your PC - Disk Defragmenter to run automatically

2011-03-21T09:40:00.000+05:30

Hi,

Here is the process that how to set up Disk Defragmenter to run automatically for the windows...

1. Windows 7

a. Open Disk Defragmenter: Click the Start button, click All Programs, click Accessories, click System Tools, and then click Disk Defragmenter. If you are prompted for an administrator password or confirmation, type the password or provide confirmation.
b. Click Configure schedule....
c. In the Disk Defragmenter: Modify Schedule dialog box, choose how often, which day, what time of the day you want defragmentation to occur, and which drives, and then click OK.
d. Click OK again.

2. Windows Vista

a. Open Disk Defragmenter: Click the Start button, click All Programs, click Accessories, click System Tools, and then click Disk Defragmenter. If you are prompted for an administrator password or confirmation, type the password or provide confirmation.
b. Click Modify schedule....
c. In the Disk Defragmenter: Modify Schedule dialog box, choose how often, which day, and at what time of the day you want defragmentation to occur, and then click OK.
d. Click OK again.

3. Windows XP

a. Click Start, and then click Control Panel.
b. Click Performance and Maintenance.
c. Under or pick a Control Panel icon, click Scheduled Tasks.
d. In the Scheduled Tasks window, double-click Add Scheduled Task.
e. In the Scheduled Task Wizard, click Next.
f. Click Browse.
g. In the File name box, type %systemroot%\system32\defrag.exe, and then click Open.
h. Under Perform this task, click Weekly, and then click Next.
i. Set the time and day of the week you would like to defragment your hard drive. For best results, choose a time when your computer will be on but you will be away from it, and then click Next.
j. Type your password in both the Enter the password and Confirm password boxes, and then click Next.
k. Select the Open advanced properties for this task when I click Finish check box, and then click Finish.
l. In the Run box, add C: to the existing command. Make sure you include a space before the “C:”. Then, click OK.
m. In the Set Account Information dialog box, type your password in both the Password and Confirm password boxes, and then click OK.

Thanks
Ajay Singh

Find Your JDK installed directory

2011-02-18T16:48:00.000+05:30

Hi,

This is a simple steps, that show how to find our JDK install directory. To Find your JDK directory, Use the Following steps...

1. Click on Start Menu
2. Click on Search
3. Click on For Files or Folders
4. In the Left hand Side, select All Files and Folders.
5. Type in jdk* in the textbox under All or part of the file name:
6. Click Search
7. Look for yellow icon that looks like a folder
8. Double Clikc on the folder to open the jdk folder

This folder indicate the JDK installed directory.

Thanks
Ajay Singh

Fixing Network & Internet connection problems in Windows

2010-10-09T20:41:00.000+05:30

Hi,

Here is the process that, how to fix Network & Internet connection problems in Windows.....

If you find that your internet connection, in Windows 7 or Vista, has suddenly stopped working or that you are facing certain Network problems, here are a few trouble-shooting steps you may want to try:

Solving it by IPConfig:
1. IPConfig is a tool built into Windows,that displays all current TCP/IP network configuration values. You can access this tool via the command line.

2. Type 'cmd' in start search and press Ctrl-Shift-Enter. If you wish, you type ipconfig and hit Enter, to view the status of the computer’s Internet Protocol or IP address.

3. Type ipconfig /release to let go of the current IP address.

4. Next type ipconfig /renew to obtain a new IP address.

5. If you get an error Message When You Run the “Ipconfig /Renew” Command.

If you recurrently face this problem, then you can have it renewed on every start-up, by creating the following iprenew.bat file and placing it in your startup folder.

Open your notepad and type the following command:

ipconfig /release
ipconfig /renew

Save it as, say, iprenew.bat file.

Solving it by DNS:
Frequently, internet connection problems can also be traced to a corrupted DNS cache. Resetting or Flushing this cache is an easy fix to many of these problems. This is how to clear the DNS cache in Windows 7 or Vista.

1. Start > All Programs > Accessories > Command Prompt. Right click on it and ‘Run As Administrator’. Type the following and hit enter: "ipconfig /flushdns"

You should be able to see a confirmation dialog window: "Windows IP Configuration. Successfully flushed the DNS Resolver Cache".

2. Next type "ipconfig /registerdns" and hit Enter. This registers any DNS records that you or some programs may have recorded in your Hosts file.

Diagnostic & Repair Tool: The Network & Internet Diagnostic & Repair Tool in Windows 7 & Vista will help you identify the potential issues preventing network connectivity, and it automatically takes appropriate steps toward correcting them. If a computer on the network loses Internet connectivity, you can graphically see which connection is down and then use Network Diagnostics to help determine the cause of the problem and find possible solutions.

To access it, open Control Panel > Network & Sharing Center. In the lower part, click on Troubleshoot Problems. From the windows which opens, you can select Internet Connections or any other issue you want to troubleshoot and repair.

Thanks
Ajay Singh

Unable to open drive using double click?

2010-10-08T08:56:00.000+05:30

Hi,

Some time it happens that if you will double click on any of you drives, it will unable to open, this happen due to some virus.Here is the process that will help to solve this problem, please follow the process...

Note: This below process is for C drive. Please check this same process where you are getting this problem.

1. C:\> attrib -r -s -h autorun.inf
2. C:\> del autorun.inf

Reboot your PC.

And here's the best and easiest suggestion.........

1. Open Start >> Run and type "regsvr32 /i shell32.dll"
2. Press Enter key
3. You will see a message "DllRegisterServer and DllInstall in shell32.dll succeeded" that it.
4. If possible then reboot your PC and check the effect.

Thanks
Ajay Singh

Folder options disabled by Virus/Trojan

2010-10-07T15:28:00.001+05:30

Hi,

Some time folder option are not able to seen File Menu > Tools in Windows Explorer on your Windows XP? This problem of hidden or disabled folder options occur normally due to malicious virus activity. The virus creates an entry in registry to disable “Folder Options” in Windows explorer.

There is number of method to solve the problem, let us see how we can fix it.

Method first:
In most of the cases, even if the virus is been already removed by your anti-virus program, it doesn’t restore the registry back to the original state. Also anti-virus usually does not delete the registry entry created by the virus.

For restoring the registry settings,follow the steps given below

Enable your folder options in explorer.

1. Go to Start > RUN
2. Type regedit and press enter.
3. Go to HKEY_CURRENT_USER > Software > Microsoft > Windows > CurrentVersion > Policies > Explorer
Please see this below image for the help.....

4. On the right side of the screen, you can see some registry entry names, out of them, right-click on NoFolderOptions and click Modify option.
5.A new small screen pops up, on this screen, sen the value data field as 0 (zero).
6. Press OK.
7. That’s it but it requires reboot. Trouble Fixed.

Method Two:
1. Login as Administrator
2. Click Start > Run and type: regsvr32 /i shell32.dll
3. Close and re-open Folder Options.

Method Three:
The hidden files and folders in Windows Explorer may not be displayed even though you enable the Show hidden files and folders option in the Folder Options.

Also, when you go to open the Tools > Folder Options > View tab, both the radio buttons Do not show hidden files and folders and Show hidden files and folders may be enabled.

The above symptoms occur if the system is infected by Malware, which modifies the CheckedValue registry value in these branches:

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows \ CurrentVersion \ Explorer \ Advanced \ Folder \ Hidden \ NOHIDDEN
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows \ CurrentVersion \ Explorer \ Advanced \ Folder \ Hidden \ SHOWALL

This ploy is used by many Viruses, so that the hidden file (malicious executable or script) won’t be displayed in Explorer.

Also note that some Viruses remove the above option altogether from the View tab of Folder Options applet.

To fix the above setting, download foldersettings.reg and save to Desktop. Right-click on the file and choose Merge. This fix can be applied in Windows XP as well as in Windows Vista systems.

Thanks
Ajay Singh

Java Decompiler

2010-10-05T22:10:00.006+05:30

Hello,

Here is the process that how to Decompile all of the *.class file on local computer. I test it from http://java.decompiler.free.fr and now i paste it here. Follow the steps one by one....

1. Download: Open the URL http://java.decompiler.free.fr

2. Click on the menu "JD-GUI".

3. Scroll the page and go to the Downloads.

4. Download the file according to your operating system (like for window it will be jd-gui-0.3.3.windows.zip. Note: Your file name may be changed).

5. How to use JD-GUI: Suppose u want to decompile a file "Abcd.class", you can:
    a - execute the following command line : "jd-gui.exe Abcd.class".
    b - select "Open File ..." in "File" menu and browse to "Abcd.class".
    c - drag and drop "Abcd.class" onto "jd-gui".

6. Uninstallation
    a - Windows: Delete "jd-gui.exe" and "jd-gui.cfg".
    b - Linux: Delete "jd-gui" application file and "jd-gui.cfg".
    c - OSX: Drag and drop "JD-GUI" application to the trash.

7. Description: JD-GUI is a standalone graphical utility that displays Java source codes of ".class" files. You can browse the reconstructed source code with the JD-GUI for instant access to methods and fields.

JD-GUI is free for non-commercial use. This means that JD-GUI shall not be included or embedded into commercial software products. Nevertheless, JD-GUI may be freely used for personal needs in a commercial or non-commercial environments.

8. Disclaimer: This material is Copyright @ 2008-2010 Emmanuel Dupuy on http://java.decompiler.free.fr.

9. A simple screen shot and example is in the below image, please see the below image...

Thanks
Ajay Singh

Java Decompilation

2010-10-05T22:10:00.001+05:30

Hello,

Here is the process that how to Decompiler all of the *.class file on local computer. I test it from http://java.decompiler.free.fr and now i past this topic here. Follow the steps one by one....

1. Download: Open the URL http://java.decompiler.free.fr

2. Click on the menu "JD-GUI".

3. Scroll the page and go to the Downloads.

4. Download the file according to your operating system (like for window it will be jd-gui-0.3.3.windows.zip. Note: Your file name may be changed).

5. How to use JD-GUI: Suppose u want to decompile a file "Abcd.class", you can:
    a - execute the following command line : "jd-gui.exe Abcd.class".
    b - select "Open File ..." in "File" menu and browse to "Abcd.class".
    c - drag and drop "Abcd.class" onto "jd-gui".

6. Uninstallation
    a - Windows: Delete "jd-gui.exe" and "jd-gui.cfg".
    b - Linux: Delete "jd-gui" application file and "jd-gui.cfg".
    c - OSX: Drag and drop "JD-GUI" application to the trash.

7. Description: JD-GUI is a standalone graphical utility that displays Java source codes of ".class" files. You can browse the reconstructed source code with the JD-GUI for instant access to methods and fields.

JD-GUI is free for non-commercial use. This means that JD-GUI shall not be included or embedded into commercial software products. Nevertheless, JD-GUI may be freely used for personal needs in a commercial or non-commercial environments.

8. Disclaimer: This material is Copyright @ 2008-2010 Emmanuel Dupuy on http://java.decompiler.free.fr.

9. A simple screen shot and example is in the below image, please see the below image...

Thanks
Ajay Singh

Tell if i am running in 32/64 bit JVM?

2010-09-20T10:31:00.001+05:30

Hi,

Here is a simple java program that tells our JVM contain 32 bit or 64 bits?

Open a text file, write this below code on text file...

public class JVMBitness {

    public static void main(String[] args) {

         System.out.println("JVM is " + System.getProperty("sun.arch.data.model")+ " bits.");
   }
}

save this file by name JVMBitness.java, and then open command prompt, compile and run this java program, out put will be like this....

JVM is 32 bits.

Note: Answer may vary, depends upon JVM.

Thanks
Ajay Singh

Restore Missing/Disappeared Internet Explorer Icon

2010-07-10T20:21:00.002+05:30

Hi .....

Users always re-create a normal shortcut to Internet Explorer browser to place on desktop. But as mentioned, the shortcut created will be the normal type with an arrow on the bottom left corner, has plenty more right click context menu items, and when select “Properties”, it’s shortcut properties that is been opened, and not Internet Options in the case of IE desktop icon.

This process prefer to resolve the issue manually, and test have been done with the window XP SP3. There are diffrent method for showing start menu, that is Start Menu & Classic start Menu. To solvet the problem perform the following action:

1. Click Start, Run.

2. Type regedit.

3. Navigate to the following registry key:

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\NewStartPanel

Note: If HideDesktopIcons and NewStartPanel do not exist, create new registry keys for them.

4. In the right hand pane, double-click {20D04FE0-3AEA-1069-A2D8-08002B30309D} key (may be diffrent in your system).

If the registry value name does not exist, create a new DWORD value and name it as {20D04FE0-3AEA-1069-A2D8-08002B30309D}.

5. Enter the word value data as 0 to enable the Internet Explorer icon on the Desktop.

For user who’re using Classic Start Menu, replace NewStartPanel with ClassicStartMenu instead so that the registry key location is as follow:

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\ClassicStartMenu

Other steps are exactly the same with the above. Refresh/Restart the Computer and then see the change.

Important Notes:

In the [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\NewStartPanel] there are several GUIDs, one for each of the icons. A value of 0x0 will show the icon, 0x1 will hide it.

Network Places: {208D2C60-3AEA-1069-A2D7-08002B30309D}

My Computer: {20D04FE0-3AEA-1069-A2D8-08002B30309D}

My Documents: {450D8FBA-AD25-11D0-98A8-0800361B1103}

Internet Explorer: {871C5380-42A0-1069-A2EA-08002B30309D}

Recycle Bin: {645FF040-5081-101B-9F08-00AA002F954E}

Those values will be the same on all XP machines. Feel free to throw Ajay singh, some credit if you decide to update your system...........

Thanks

Ajay singh

Reading XML file using Java

2010-06-14T23:36:00.000+05:30

Step 1: Open a text editor and copy the below things..

<?xml version="1.0"?>
<company>
   <employee>
       <firstname>Ajay</firstname>
       <lastname>Singh</lastname>
   </employee>
   <employee>
       <firstname>Suresh </firstname>
       <lastname>Pal</lastname>
   </employee>
   <employee>
       <firstname>Gyanendra</firstname>
       <lastname>Singh</lastname>
   </employee>
</company>

save the file as 'test.xml'.

Step 2: Open the text editer paste the below code..

import java.io.File;
import javax.xml.parsers.DocumentBuilder;

import javax.xml.parsers.DocumentBuilderFactory;

import org.w3c.dom.Document;

import org.w3c.dom.Element;

import org.w3c.dom.Node;
import org.w3c.dom.NodeList;

public class XMLReaderClass {
public static void main(String argv[]) {
try {
File file = new File("test.xml");
DocumentBuilderFactory dbf = DocumentBuilderFactory.newInstance();
DocumentBuilder db = dbf.newDocumentBuilder();
Document doc = db.parse(file);
doc.getDocumentElement().normalize();
System.out.println("Root element: "+ doc.getDocumentElement().getNodeName());
NodeList nodeLst = doc.getElementsByTagName("employee");

for (int s = 0; s < nodeLst.getLength(); s++) {
Node fstNode = nodeLst.item(s);
if (fstNode.getNodeType() == Node.ELEMENT_NODE) {
Element fstElmnt = (Element) fstNode;
NodeList fstNmElmntLst = fstElmnt.getElementsByTagName("firstname");
Element fstNmElmnt = (Element) fstNmElmntLst.item(0);
NodeList fstNm = fstNmElmnt.getChildNodes();
System.out.print("Name : "+ ((Node) fstNm.item(0)).getNodeValue());
NodeList lstNmElmntLst = fstElmnt.getElementsByTagName("lastname");
Element lstNmElmnt = (Element) lstNmElmntLst.item(0);
NodeList lstNm = lstNmElmnt.getChildNodes();
System.out.println(" "+ ((Node) lstNm.item(0)).getNodeValue());
}

}

} catch (Exception e) {
e.printStackTrace();
}

}

}

save the file as 'XMLReaderClass.java'.

Note: keep both of the file in the same directory

Step 3: Compile the java file using command
javac XMLReaderClass.java

Step 4: now run this java file using command
java XMLReaderClass

the output is like this............

Root element: company
Name : Ajay Singh
Name : Suresh Pal
Name : Gyanendra Singh

Thanks
Ajay Singh

Eclipse Plugins

2010-05-24T11:46:00.000+05:30

Hi,

Here is a process to add diffrent plugins into the Eclipse (These plugins are valid for version 3.X):

1. Java Decompiler Eclipse plugins
Source from: http://java.decompiler.free.fr/

2. MySql database access plug-in for the Eclipse Development Platform
Source From: http://quantum.sourceforge.net/index.html

3. GEF Eclipse plugins
Source From: http://www.eclipse.org/gef/

4. Tomcat Plugins for Eclipse
Source From: http://www.eclipsetotale.com/tomcatPlugin.html

Explaination will come very soon...

Thanks
Ajay Singh

Handling Epoch timestamp in Java

2010-05-11T14:15:00.000+05:30

What is epoch time?

The Unix epoch is the number of seconds that have elapsed since January 1, 1970 (midnight UTC/GMT).

How to Handling the epoch in java?

Steps:

1. Get the current epoch time
long epoch = System.currentTimeMillis()/1000;

2. Convert from epoch to human readable date
String format = "dd/MM/yyyy HH:mm:ss";
String format = "11/05/2010 15:45:21;
String currenttime = new java.text.SimpleDateFormat(format).format(new java.util.Date (epoch*1000));

3. Now convert this beforDate into epoch time
String format = "dd/MM/yyyy HH:mm:ss";
String format = "11/05/2010 15:45:21;
Date dt = new java.text.SimpleDateFormat(format).parse(beforDate);
long epoFinal = dt.getTime()/1000;

4. A Java Example is here, this example also calculate the current epoch time and one month back time in epoch...

package com.epoch.epochConversion;

import java.util.Date;
import java.text.ParseException;
import java.text.SimpleDateFormat;

public class DeleteEventDataRows {

public static String format = "dd/MM/yyyy HH:mm:ss";
public static long epoFinal = 0;

public static void main(String[] args) {
// ==================================================================================
/* Get the current epoch time */
long epoch = System.currentTimeMillis()/1000;

// ==================================================================================
/* Convert from epoch to human readable date */
String currenttime = new java.text.SimpleDateFormat(format).format(new java.util.Date (epoch*1000));

// ==================================================================================
/* Substract 30.44 ddays from current human readable Date */
SimpleDateFormat sdf = new SimpleDateFormat(format);
DeleteEventDataRows de = new DeleteEventDataRows();
Date date = de.formatDate(currenttime, sdf);
String beforDate = de.substractTimeWithFormat(date, 30.44*24, sdf);

// ==================================================================================
/* Now convert this beforDate into epoch time */
try {
Date dt = new java.text.SimpleDateFormat(format).parse(beforDate);
epoFinal = dt.getTime()/1000;

} catch (ParseException e) {
e.printStackTrace();
}

}

public Date formatDate(String dateStr, SimpleDateFormat sdf) {
Date date = null;
try {
date = sdf.parse(dateStr);
} catch (ParseException e) {
e.printStackTrace();
}
return date;
}

public String substractTimeWithFormat(Date date, double time, SimpleDateFormat sdf) {
long milliSeconds = (long) (time * 60 * 60 * 1000);
long resultTime = date.getTime() - milliSeconds;
date = new Date(resultTime);
return sdf.format(date);
}

}

For any query feel free to write me...

Thanks

MySQL: Too many connection errors

2010-04-07T13:11:00.000+05:30

Hi All,

I was trying to connect to a MySQL server at work and I got connection fail “Too many connections".

The most common problem is because MySQL has too many open client being connected to it at the same time. MySQL has a system variable called max_connections. If you have it set up at 100, MySQL will have 101 connections. The last one is reserved for super user. That makes sense because you’ll need to connect as super user to do maintenance on these kinds of problems.

Here’s how to find out what’s max_connections variable is set to and how to see connected clients. Off course, you have to login as super user first.

-- This command will return you the value of max_connections variable
mysql> SHOW VARIABLES LIKE '%max_connections%';

-- This command will show you all processes and connections.
mysql> SHOW FULL PROCESSLIST;

So if you run the first command and it returned you 100, then you run this 2nd command and it returns 100 rows, then you really got some problems. There are 2 ways to solve this problem...

1. Increase max_connections variable to like 200 or some other number higher than 100. However, I like to use this as last resource. I would re-asses my usage and see if I really need more than 100 connections. If I do, then there’s no other ways around it. Increase the number and perhaps add more power to your hardware as well.
2. Rework your application. Try to use connection pooling. Or maybe caching is a solution to lessen the load on database.

Lastly, if you really need to increase your maximum connections, you can execute the following command while logged in as super user.
-- Change 200 to some other number you desire.
mysql> SET GLOBAL max_connections = 200;

Another option is to add the following line in your my.cnf configuration file under [mysqld] section.
max_connections = 200

This max_connections = 200 value can be changed up to your need.

I hope this article helps you.

Thanks
Ajay Singh

Mysql: Table Maximum size

2010-04-03T16:46:00.000+05:30

When a MyISAM table grows large enough, you'll encounter the dreaded "The table is full" error. Now I could simply point at that page and leave this subject alone, but there's more to this story.

To protect yourself in the future, use the MAX_ROWS and AVG_ROW_LENGTH options at CREATE TABLE time if the table is likely to get big.

Where does this limit come from?

In a MyISAM table with dynamic (variable length) rows, the index file for the table (tablename.MYI) stores row locations using 32-bit pointers into the data file (tablename.MYD).

An Example: Here's a table that you might use to store 'EventData' data:

Open your mysql client application, u will see like this.......

Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 5.0.13-rc-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use gts;
Database changed
mysql> show table status like 'EventData' \G
*************************** 1. row ***************************
Name: eventdata
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 90756
Avg_row_length: 162
Data_length: 14758888
Max_data_length: 281474976710655
Index_length: 2342912
Data_free: 0
Auto_increment: NULL
Create_time: 2010-04-03 10:17:49
Update_time: 2010-04-03 10:17:49
Check_time: NULL
Collation: latin1_swedish_ci
Checksum: NULL
Create_options:
Comment:
1 row in set (0.00 sec)

mysql> show table status like 'User' \G
*************************** 1. row ***************************
Name: user
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 3
Avg_row_length: 109
Data_length: 328
Max_data_length: 281474976710655
Index_length: 4096
Data_free: 0
Auto_increment: NULL
Create_time: 2010-04-03 10:19:43
Update_time: 2010-04-03 10:19:47
Check_time: NULL
Collation: latin1_swedish_ci
Checksum: NULL
Create_options:
Comment:
1 row in set (0.00 sec)

mysql>

There it is. Notice that Max_data_length is (((281474976710655/1024)/1024)/1024) = 262144GB. Let's change it

mysql> alter table EventData max_rows = 98281474976710655 avg_row_length = 1000000000;
Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0

Note:

===============================================
Operating System File-size Limit
===============================================
Win32 w/ FAT/FAT32 2GB/4GB
Win32 w/ NTFS 2TB (possibly larger)
Linux 2.2-Intel 32-bit 2GB (LFS: 4GB)

Windows users, please note that FAT and VFAT (FAT32) are not considered suitable for production use with MySQL. Use NTFS instead.

Java Program: Date time Substraction

2010-04-03T00:47:00.000+05:30

package com.suresh.date;

import java.util.Date;
import java.text.ParseException;
import java.text.SimpleDateFormat;

public class DateExample {

public static void main(String [] args) {
String format = "dd/MM/yyyy HH:mm:ss"; //"01/03/2010 16:12:55"
SimpleDateFormat sdf = new SimpleDateFormat(format);
DateExample de = new DateExample();
Date date = de.formatDate("01/03/2010 16:12:55", sdf);
System.out.println(de.substractTimeWithFormat(date, 5.50, sdf));
}

public Date formatDate(String dateStr, SimpleDateFormat sdf) {
Date date = null;
try {
date = sdf.parse(dateStr);
} catch (ParseException e) {
e.printStackTrace();
}
return date;
}

public String substractTimeWithFormat(Date date, double time, SimpleDateFormat sdf) {
long milliSeconds = (long) (time * 60 * 60 * 1000); // change this time into milisecond
long resultTime = date.getTime() - milliSeconds; // substract this time interval
date = new Date(resultTime); // change this inot the format
return sdf.format(date); // return this date
}
}

Special thanks to my dear friend Suresh Chandra

Thanks & Regards
Ajay Singh

Windows cannot start the Windows Firewall/ICS service

2010-03-25T11:42:00.000+05:30

To install Windows Firewall call the "Setup API InstallHinfSection" function

1. Click Start, click Run, type cmd, and then click OK.
2. At the command prompt, type the following command line, and then press ENTER:

Rundll32 setupapi,InstallHinfSection Ndi-Steelhead 132 %windir%\inf\netrass.inf

3. Restart Windows,
4. Click Start, click Run, type cmd, and then click OK.
5. At the command prompt, type the following command, and then press ENTER:
Netsh firewall reset

6.Click Start, click Run, type firewall.cpl, and then press ENTER. In the Windows Firewall dialog box, click On (recommended), and then click OK.

To verify that the Windows Firewall service is started, follow these steps:
1. Click Start, click Run, type services.msc, and then click OK.
2. In the list of services, locate Windows Firewall/Internet Connection Sharing (ICS). Notice that the status of the service is Started.

Note: This problem is caused by a missing or corrupted "SharedAccess.reg" file. The SharedAccess.reg file represents the Windows Firewall service.

Thanks & Regards