Blog Contest | Winners Announced!

Hello all,

I would like to bring to your notice, that the results are out for Sun Student Views and Reviews blogging contest [1], which required the participants to review NetBeans 6.1 FCS and OpenSolaris 2008.05!

We have few winners[2] from NetBeans Community Docs Contributors as well. Lets congratulate, Jay Mahadeokar and Ritwik Goshal, as they have done some fabulous contributions in recent past. Jay and I, finished runner-up’s, as Ritwik won the Grand Prize in General Students category!


Woohooo ๐Ÿ˜‰

Submissions | Student Reviews Contest

Hello all,

I would like to thank Sun Microsystems, for giving students a chance to review their technologies, which might play a major role in their professional career in future.

Anyways, coming back to the point. Just a gentle reminder, on what all entries I have submitted during this contest,

  1. tAT | Passing Arguments Using IDE | 2
  2. dotNet – Installation – NetBeans
    I am back with yet another edition of Quest For Better IDE, this time I would discuss about everything related to installing Visual Studio andNetBeans.
  3. dotNet – Modularity – NetBeans
    Reviewing the Modularity of NetBeans as compared to dotNet
  4. First Look at OSol 2008.05!
    Review – OpenSolaris 2008.05 and xVM Virtual Box 1.6
  5. dotNet – Code Completion – NetBeans
    Discussing NetBeans Code Completion as compared to dotNET
  6. MySQL Admin and NetBeans
    Tryst with MySQL Server, Administrator and NetBeans IDE
  7. Update on Issue #136216
    Workaround for bug reported by me on MySQL Server Node in Database Explorer.

That’s all, I am glad to have participated in this contest. I will continue the dotNet-NetBeans blog series, as well as, come out with new Tips & Tricks. By the way, wish me luck, I might be a winner this time ๐Ÿ˜‰

sTay Tuned for More…

Add to Technorati Favorites

Update on Issue #136216


As I had mentioned in my previous blog entry about MySQL Admin and NetBeans. There, I had ended the post, with a note that I have filed an issue related to MySQL Server Node in Database Explorer.

After exchanging several mails and updating the bug report at Issuezilla. I told David, that I would be looking for a workaround, as he had set the TBD to 6.5 release. I can’t wait that long!

So, I had two options, either hack the code and fix it by myself, and use it. Else, I should look for a workaround.

I am glad that I could find a workaround for this issue. What I did, when I Stop Service using MySQL Admin Tool, run by clicking an option in the context-menu of the Server Node in Database Explorer. I should delete the Node from the Explorer, and then, Start Service using MySQL Admin Tool. Now, switch back to the IDE and click Connect in the context-menu of the Node. See, its that simple!

However, if you use it on a regular basis, it could really frustrate you. Anyways, if you can possibly hack into the code and fix it, do update the bug report, OR post a comment over here.

David has suggested another possible workaround, you could see in the Issuezilla, in my bug report. Also, this issue has now been given priority P2. Click on the link for more details.

Thanks for following! Hope you like the update from Issuezilla, as well as, from my previous blog.

Update 26th July-

Bug was fixed and I was notified long time back, though it was in trunk builds, and I don’t follow those. So, had to wait and meanwhile I forgot, until Patch 2 was applied and someone asked for verification last week, whether it works or not. I am glad it works!

Hope to see the same in NetCAT as well, will review soon!

eNjoy Technology…

This is being submitted for review to the blogging contest – Student Reviews NetBeans 6.1 and OpenSolaris!
Author – Varun Nischal, University – JIIT University

Add to Technorati Favorites

MySQL Admin and NetBeans


Few days back, I had blogged about Tryst with MySQL. Today, I shall move ahead and give an insight on database management with MySQL using NetBeans.

Its meant for Windows user only, rest can follow too, though just for the content and may try exploring these steps for their OS as well.

MySQL Tools –

Apart from being a popular open source database. It also has some amazing tools, which have been formed, due to years of users invaluable feedback, on their forums. Here’s what the website describes about MySQL Administrator;

MySQL Administrator is a powerful visual administration console that enables you to easily administer your MySQL environment and gain significantly better visibility into how your databases are operating

Lets understand in a simple, yet an interesting manner, how can we configure MySQL Server using it.

MySQL Community Server 5.0 –

Its free, thats why I used it! Also, its supported by NetBeans 6.0 and 6.1 FCS. Anyways, there are two methods of setting up the server, either by installing OR by not installing. Surprised! I was too, when I encountered this on their website.

So, you need to download the appropriate version and get started. if you go for installation, then just install it, by running the appropriate installer. By the way, its cross-platform, I guess you all might know this ๐Ÿ™‚

If you go for the other, that means you are a hard working soul, who likes getting deep into the technicalities of the stuff, and if its open source then why not? So, download it and then, you could follow a long series of steps to get started (Refer to this MySQL Documentation) OR you could go my way.

I had tried the later one and it took 1-2 hours, to get things running smoothly. Now, I am going to make your life simple and easy. So, lets get rolling;

  • Download the archive, if you still have not done it.
  • Extract it and store it where ever you feel, but I would recommend storing it in C:/ if you are a Windows user, under a MySQL folder.
  • Now, download the MySQL Admin tool, and install it.
  • After installing, create a short-cut for MySQLAdministrator.exe (on the Desktop), stored under this kind of folder, C:/Program Files/MySQL/MySQL Tools for version/
  • Run this application, it will prompt you for a connection host, port username and password.
  • Just press Ctrl, don’t release it and click on Skip button, which is initially the Cancel button.
  • Click on Service Control, in the left panel and then, click on Configure Service Tab. Here, you would see a button at the bottom the UI, click on Install new Service. Name it as MySQL.
  • OR, you can right-click inside the Installed Services section, in left panel. A context-menu pops-up with 3 options. Select Install new Service. Name it as MySQL.
  • Now, do the following entries; what I did I just made two changes there. In the Config Filename text-field, enter the path of the my.ini, its the option file.
    1. You may either create option file on your own, OR you may copy some pre-defined option files, stored in MySQL Server extracted folder.
    2. Copy any one of the files having my- as prefix and copy, paste it into the data folder in that directory, rename it to my.ini

  • Now, back to the Admin, in the Path to binary field, browse to the bin folder inside the MySQL Server extracted folder.
  • Then, click button – Apply Changes. Switch over to the Startup Variable Tab. Click button – Choose Option File and browse to the directory, where we had created the my.ini file.
  • Check the following checkboxes –
    1. TCP Port: 3306
    2. Base Directory: C:/Program Files/MySQL/mysql-5.0.51a-win32
    3. Data Directory: C:/Program Files/MySQL/mysql-5.0.51a-win32/data
    4. Default Storage – that’s upto you, I selected InnoDB.
  • Apply changes and switch to Service Control and then, Start/Stop Service. Now, press Start Service.
  • You are ready to use MySQL Server. Click on File Menu and select New Instance Connection…
  • Again, you would see the prompt which you had earlier came across, this time, don’t alter default values, just click OK.
  • Now, it would show the Administrator with all the options, which the user must access to administer database, manage connections, add/delete users and grant/revoke privileges.

MySQL and NetBeans –

So, you want to use MySQL with NetBeans, I guess Java is your language of choice for development in NetBeans, as it provides such a fabulous Java Editor since 6.0 FCS and now, its really amazing in 6.1 FCS. You could try making a database application using Swing Application Framework, which lets you create a CRUD application.

Firstly, you need a JDBC driver, as we are using Java to connect to MySQL databases, then you have to go for Connector/J (IV Type Driver), there are some more available for other languages too.

Here is a fantastic tutorial, which would enable you to get started with MySQL database management using NetBeans.

Connecting to a MySQL database

Today, I tried all this and started working with MySQL, it was good, everything worked smoothly, until the following happened.

I had an issue while trying to disconnect database using the Admin tool, ran by NetBeans Database Explorer. So, I have filed a bug report, just click that link, to see more details and an attached image too, justifying my point.

eNjoy Technology…

This is being submitted for review to the blogging contest – Student Reviews NetBeans 6.1 and OpenSolaris!
Author – Varun Nischal, University – JIIT University

Add to Technorati Favorites

dotNet – Code Completion – NetBeans

Code Completion, Intellisense…

These are some jargons which I came across, when I started working on C# using Visual Studio 2003 .NET! It was then I got familiarize with Intellisense.

At that time, it looked like the coolest thing which a developer could have ever dreamt of. I was adept at using Turbo C/C++ Borland IDE, before switching over to .NET temporarily.

I would never ever thought in my wildest of dreams, that I would come across such brilliance. During that time, I came across another IDE, NetBeans 5.5, as I was not happy to use J# supported by .NET, it was really disappointing! So, I tried various softwares before finalizing NetBeans for my 1st ever Java-based project.

I tried JCreator and Eclipse before trying out NetBeans. The reason why I not choose Eclipse isn’t relevant to discuss here. If you have interest in reading about it, refer to my NetBeans Testimonial (see Varun Nischal).

dotNet –

Till date, I have never regretted using Intellisense, which is beautifully supported by .NET Framework, its really excellent tool to use, sometimes I make switch to dotNet, just to use this feature, which really helps me code fast and intelligently.

NetBeans –

They named it Code Completion, I used to regret using it and it was so slow too, while Intellisense was quick! Over the past 1 year, with the release of NetBeans 6.0 and 6.1, there has been tremendous improvement, esp. 6.1 which has really improved a lot! Latest performance enhancements have lead to smarter parsing, which enables faster code completion. So, they are moving in the right direction.

Current Status –

I recently used dotNet 2008, I was really surprised that they too have improved speed of the Intellisense, its fast and furious…
Even though, NetBeans have shown improvement in that context, still there’s some distance left to cover, before they can give competition to Intellisense.

Note –
These are my views, as programmer and its upto you to take it seriously or not, but during this series of blogs, I wonโ€™t be bias, yet would be fair to both. Its not meant to degrade certain IDEโ€™s image.

eNjoy Technology…

This is being submitted for review to the blogging contest – Student Reviews NetBeans 6.1 and OpenSolaris!
Author – Varun Nischal, University – JIIT University

Add to Technorati Favorites