Sunday, April 26, 2009

Database Lesson 2 - Additional Setup (System Variables)

Apologies for the delay; was quite busy lately. Anyway, tuloy na natin ang tutorial! :)

May kulang pa pala tayo sa environment, di pa naka configure yung Apache Derby na system variable at yung 'Path' na system variable din ay i-e-edit natin. Bale ganto ang gagawin:

1. Go to Control Panel -> System -> Advanced Tab -> Environment Variables.
2. Under 'System Variables', click 'New'
3. Sa 'Variable name:' type in 'DERBY_HOME' at sa 'Variable value:' yung path kung san mo inextract yung apache derby.
4. Click 'Ok'

Bale, magiging ganto ang hitsura:

Now, para ma-edit yung 'Path' na system variable:

5. Sa 'System Variable', hanapin nyo yung 'Path' then click 'Edit'
6. Sa dulo nung 'Variable value:' lagay nyo ';%DERBY_HOME%\bin\'
7. Click 'Ok' hanggang mawala lahat nung mga windows.

Parang ganto yung magiging hitsura ng 'Path' na 'System Variable':


8. Restart your PC. Sa ibang PC kasi minsan ok lang walang restart, minsan kelangan. Better irestart na lang natin.
9. Para maverify kung ok na ang installation, go to command promt (Start -> Run -> cmd) and type 'sysinfo'. Dapat lalabas yung 'Java Information', 'Derby Information' and 'Locale Information'.

Ok, alis lang muna ulit ako, pag uwi ko miya saka natin itutuloy. Let me know pag may hindi nakasunod. :)
Posted by at
Labels:

5 comments:

  1. The God Delusion - Richard DawkinsApril 27, 2009 at 4:16 PM

    sir, may problema ako dito. walang lumabas na 'Java Information', 'Derby Information' and 'Locale Information'. sa command promt.

    eto po yung lumabas.
    'sysinfo' is not recognized as an internal or external command,
    operable program or batch file.    mali po ba yung variable value ko?
    D:\APPS\db-derby-10.4.2.0-bin;%DERBY_INSTALL%\bin\ 'yan yung variable value ko.

    ReplyDelete
  2. The God Delusion - Richard DawkinsApril 27, 2009 at 4:22 PM

    sir, 'di kaya dahil vista home basic OS ko?

    ReplyDelete
  3. ¯\_(ツ)_/¯April 28, 2009 at 1:17 AM

    sir, maraming salamat sa comment. Binasa ko uli yung post ko at mukhang hindi clear yung instructions ko kaya inedit ko ngayon.

    Bale dalawa kasi yung gagawin natin sa 'Environment Variables': create ng 'DERBY_HOME' at edit yung 'Path'.

    Kindly note na 'DERBY_HOME' dapat at hindi 'DERBY_INSTALL'. Nagkamali kasi ko, ang napost ko dati ay 'DERBY_HOME'. Gagana din pero magkakaproblema sa mga future nating gagawin kaya paki gawang 'DERBY_HOME' yung 'DERBY_INSTALL'.

    Bale medyo tama na yung 'DERBY_HOME' mo na variable. tanggalin mo na lang tong part na to:

    ;%DERBY_INSTALL%\bin\

    Kaya ang value ng 'DERBY_HOME' mo ay magiging:

    D:\APPS\db-derby-10.4.2.0-bin

    tapos click mo ok para maclose yung 'New System Variable' na dialog box. Sa 'System Variable' pa din, hanapin mo yung 'Path' and click edit. Sa dulo nun, dun mo idagdag to:

    ;%DERBY_INSTALL%\bin\

    click ok, hanggan mawala yung mga window tapos restart mo. that should do it. if di pa din, let me know lang. :)

    ReplyDelete
  4. The God Delusion - Richard DawkinsApril 28, 2009 at 1:03 PM

    okay nakuha ko na po.
    eh paano po sir kung may naka path na sa variable value ng 'path'? pwede paba ilagay yung ;%DERBY_INSTALL%\bin\?

    ganito kasi yung sakin sir,
    nakalagay yung path nung SQL sever bin.

    %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;

    ReplyDelete
  5. ¯\_(ツ)_/¯April 29, 2009 at 12:19 AM

    Sir bale idu-duktong lang sa dulo ng 'Path' ito:

    ;%DERBY_INSTALL%\bin\

    Kaya ang magiging value ng 'Path' mo ngayon ay:

    %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;%DERBY_INSTALL%\bin\

    ReplyDelete

Subscribe to: Post Comments (Atom)