Friday, April 17, 2009

Database Lesson 1 - Applications and Installation Steps

I'm suppose to write about the next Java basics tutorial but decided to make a quick and dirty tutorial on making database work on java. This is because quite a number of people are asking me for this.

For our setup, we'll be using the following:

1. Eclipse - our usual IDE of choice. Of course you can use Netbeans or any other IDE but I prefer eclipse for a number of reason I stated on my previous posts.
2. Apache Derby - I can hear chatters asking why apache derby and not mysql or some other high profile DB application. Well, you can also use yung ibang database apps pero for this tutorial, apache derby na lang muna tayo since madaling mag setup ng apache derby. Isa pa, kung small scale lang naman na mga applications, apache derby is more than sufficient. Maliit lang pati kumain ng memory ang apache derby (around 2MB lang foot print nya) which makes it great and perfect fit for small applications.
3. Apache Derby Plug-in - eclipse plugin para maging mas madali ang pag develop.

Installation:
1. Download and extract eclipse as usual.
2. On the apache derby download page, download db-derby-10.4.2.0-bin.zip and extract it to a folder.
3. To install the apache derby plugins, from the apache derby download page just download derby_core_plugin_10.4.2.zip and derby_ui_plugin_1.1.2.zip. Make sure eclipse isn't running and extract the folders from the two zip files to the plugins folder of eclipse.

Now our environment is ready. I'm a little sleepy right now so I'll just post the next steps tomorrow. :)

8 comments:

  1. sir, mukhang wala pa yung next step ah..mukhang busy ka ah.. hehe sige sir take your time. hintayin ko nalang yung next step.

    ReplyDelete
  2. Sir, ang galing talaga ng blog na to.. salamat sir...

    tips naman po sir... Galing po kasi ako ng Visual Basic 6.0.. Gusto ko po mg Java na.. Bale ang ginagawa ko po kino-Compare ko po ung Coding ng VB sa Java, alam nyo po result??? BUANG NA KO!! HAHAHAA...

    Salamat po sa pag share ng blessings nyo sir.. :D

    wait po namin ung Database Tutorial..

    ReplyDelete
  3. Sir thanks s blog nu.mdmi k0ng natutuhan.sna po msundan n kc inaabang abangan ko.hehe.ΓΌ

    ReplyDelete
  4. Thanks sa mga comments nyo! :)

    Meron akong slight update, kakapost ko palang. then yung kadugtong nung itutuloy ko na lang miya.

    Again, thanks for the comments! :)

    @Jholand, glad to hear you already know VB and youre trying to learn java. Medyo nakakalito lang sa simula pero oks lang yan. Lahat naman nahihirapan sa simula. Eventually, makukuha mo din yan. Aralin mo lang mabuti at for sure marami kang magagawang magagandang system kasi wide na yung array ng technology mo since may alam ka sa iba pang languages. :)

    ReplyDelete
  5. elow po sir mau! just want to say thanks for sharing your java knowledge in a way na madaling intindihin :) pwede po magrequest? tutorial po sana sa jdbc. thanks and keep up the good work!

    ReplyDelete
  6. you're welcome po. :) try nyo po muna tong database using ibatis na tutorial kasi para sa connectivity din ito sa database pero mas madali kung marami kayong connection na gagawin. pati to din ang isa sa mga ginagamit sa industry kaya masasanay ka na. :)

    ReplyDelete
  7. Hello Sir Mau Napadpad lng Meron kaba sir bagong pwde na ma share ng Java tutorial. haha na discover ko lng 5 years ago na pala ito =D.

    ReplyDelete
  8. almost 9 years na pala Wow.

    ReplyDelete