Correct way to handle JDBC connections

Find out through the following url: http://mobidev.afrigis.co.za/?q=node/81

Java Vs Javascript

The JavaScript programming language, developed by Netscape, Inc., is not part of the Java platform. The JavaScript programming language shares some attributes with the Java programming language, but it was developed separately.

For additional information about JavaScript, refer to the mozilla.org page titled What is JavaScript?

Differences among JDK, JRE & JVM

The Java Virtual Machine (JVM) is not a standalone program. The JVM is part of the Sun Java 2 Runtime Environment, Standard Edition (JRE). Like a car needs an engine to run, the Sun JRE needs a virtual machine. You must download the entire JRE.

JDK includes JRE and other stand alone programs.

Configuring the Application Server

Visit the following url:

http://docs.sun.com/app/docs/doc/819-3658/6n5s5nklb?a=view

Executing SQL Statements from a Sql File

Use the follwoing command:

mysql> source file_name
or
mysql> \. exact_path_file_name

for an example:

mysql> \. /tmp/Marbil/marbil.sql

for further reading go to :
http://dev.mysql.com/doc/refman/5.0/en/batch-commands.html

How to check java version in your machine?

in command prompt type
java -version

sjsas 9.0.1 installation in solaris spark 10 machine (64 bit)

first uninstall previous version

1. go to the installtion directory (i installed in /opt/SUNWappserver )

use the following command:
./uninstall -console

installation:

1. download to a directory like /tmp/sjsas-9_1_01-solaris-sparc.bin

2. change the mode to the executable using the command:

chmod +x sjsas-9_1_01-solaris-sparc.bin

3. install in console mode

./sjsas-9_1_01-solaris-sparc.bin -console

mysql 5.1.23 installation in solaris spark 10 machine (64 bit)

uninstallation:

check the package using the command:
pkginfo | grep mysql

previous installation using
pkgrm mysql

installation:

just follow the instruction : http://instmysql5sol10.blogspot.com/
(must create user and group)


post installation works have to be done by follwoing the website.

some mysql commands

1. show databases;
2. use mysql;
show tables;

Problems:
Root password have not set yet.

jdk 1.6 installation in solaris spark 10 machine (64 bit)

remove all previous installation of jdk

## find out the all pkg of jdk using :
pkginfo | grep JDK

##then remove all listed.
using the command:
pkgrm SUNWj6rt SUNWj6dev SUNWj6cfg SUNWj6man SUNWj6dmo


Installation:

http://java.sun.com/javase/6/webnotes/install/jdk/install-solaris.html

unzip using the command:
zcat jdk-1_6_0-solaris-sparc.tar.Z | tar -xf -

1. first install 32 bit version jdk1.6
pkgadd -d . SUNWj6rt SUNWj6dev SUNWj6cfg SUNWj6man SUNWj6dmo

2. then install 64 bit version
pkgadd -d . SUNWj6rtx SUNWj6dvx SUNWj6dmx


also see the following url:
http://www.java.com/en/download/help/5000010700.xml