transaction not connected on oracle and PowerBuilder 9

sometime we got message when develop login form use Powerbuilder 9 and oracle11g database:
At this issue: the PC installed Oracle11g & PB9 both.
open lgin form from PB is ok , but when open application file (exe file). Got message:

"Transaction not connected"

no detail information about it;
please check below:
(1) make sure that PB...90.DLL not double in that PC.
(2) if have double PB...90.DLL please going to control panel - system - environment - path
(3) then check the path only pointed to ONE LOCATION of PB...90. DLL

hope this help you

he he he

set monitor selalu on di ubuntu server 8.10

kadang kala kita ingin monitor display selalu on ( tidak save mode) untuk keperluan memonitor jaringan.
Berikut caranya:

pada terminal ketik:
# setterm -powersave off - blank 0

 Tapi , ketika server di shutdown, maka kembali ke kondisi semula ( auto save mode).
agar kondisi diatas bisa selalu on. maka script tadi harus di auto run tiap booting.
baca berikut caranya.

script auto run tiap booting di Ubuntu server 8.10

berikut cara membuat script agar otomatis jalan setiap booting;
(1). buka  # nano /etc/init.d
(2). buat scriptnya, misal script agar display monitor selalu on ( tidak save mode):
       setterm -powersave off - blank 0
(3)  simpan nama filenya: misal sebagai:  skrip.sh
(4) buat script tadi agar bisa di execusi:

# sudo chmod +x /etc/init.d/skrip.sh

(5) buat agar script tadi bisa di strat ketika boot up

            # sudo update-rc.d skrip.sh defaults
(6) selesai. dan coba shutdown
          # sudo shutdown -h now
(7)  untuk melihat isi semua file di direktory tersebut,:
         # ls /etc/init.d/

di sarikan dari berbagai sumber.

contact me for discussion & Support : y4y4ne@yahoo.co.id

Front end:

• PowerBuilder
• PHP
• Visual Basic
• Others

Back end

• Oracle
• MS Sql Server
• MySQL
• Sybase
• MS Access

system and application

• Barcode
• Production Management System
• Vendor Management System
• Warehouse Management System
• Human Resources
• Payroll
• SMS Gateway
• Disaster recovery system
• others

Firewall ,  Proxy

• checkpoint
• sonicwall
• Kerio Winroute
• IPTABLES - Squid (Ubuntu )
• Juniper
• Mikrotik

Server

• Active Directory
• Windows Server
• Mail server : Exchange , MDaemon
• data center
• backup system
• Antivirus server

Network

• LAN
• WAN
• Point to Point

location Indonesia:

• Jakarta
• west java
• east java
• merauke - papua

:: I am not the best in IT but I like IT ::

Forest Information System

Forest informatics is the combined science of Forestry and Informatics, with a special emphasis on collection, management, and processing of data, information and knowledge, and the incorporation of informatic concepts and theories specific to enrich forest management and forest science; it has a similar relationship to library science and information science. [wikipedia]

Forest Information System consist of:

• Land Use
• Land Clearing
• Planting
• Maintenance

melihat view di mysql

Berikut script untuk melihat view dan lainnya pada database MYSQL:
select TABLE_NAME from information_schema.VIEWS where TABLE_SCHEMA = 'mysql';

jika ingin melihat script lengkapnya, pakai berikut:

SHOW CREATE VIEW your_view_name

dan pilih print view di button bawah

buepe - merauke - papua

adalah nama suatu kampung di kabupaten merauke, propinsi papua wilayah Indonesia. Lokasinya kira kira 140 03' E; 7 54' S.

Wireless Point to Point

Alhamdulillah, project wireless Point to point sejauh 9,5 Km selesai. Dengan bantuan semua pihak bisa sukses. Adapun perangkat yang digunanakan sbb:

• 1 set Motorolla PTP300 ( Master & Slave) beserta accesoriesnya
• 2 unit Tower masing masing tinggi 40M berikut accesoriesnya
• Kabel LAN FTP CAT5E
• 1 set chain block dan accesories untuk naikin tower

delay antara 2 radio master dan slave adalah  rata rata 3 ms.
Buat yang Panjat tower, yang bikin tower dan yang dirikan tower serta lainnya. thank ya. nama anda akan terkenang di site.

script to create date range in MySQL

below quer to create date range in mysql.

usually used for create working calender for employee attendance

DROP PROCEDURE IF EXISTS datespopulate;

DELIMITER |

CREATE PROCEDURE datespopulate(dateStart DATE, dateEnd DATE)

BEGIN

  WHILE dateStart <= dateEnd DO

    INSERT INTO datetable (d) VALUES (dateStart);

    SET dateStart = date_add(dateStart, INTERVAL 1 DAY);

  END WHILE;

END;

|

DELIMITER ;

CALL datespopulate('2010-11-01','2015-01-01');

Note I named my table "datetable" and the column is named "d", but feel free to change this. Works fine on my end, let me know if you run in to an issue.

 source from : http://stackoverflow.com/questions/4736690/create-mysql-date-range

timezone mysql & PHP not correct

To see what timezone your MySQL session is using, just execute this:
SELECT @@global.time_zone, @@session.time_zone;

to changes timezone, run below script: use super previlage

mysql> SET GLOBAL time_zone = 'America/New_York';

 or 

mysql> SET GLOBAL time_zone = 'Asia/Krasnoyarsk'; 

to check your date correct, use this:

select date(now());

or 

select curdate();

for php, please go to php.ini then edit below:

[Date]
; Defines the default timezone used by the date functions
; http://php.net/date.timezone
date.timezone = "America/Los_Angeles"

; http://php.net/date.default-latitude
;date.default_latitude = 31.7667 

changes : America/Los_Angeles --> Asia/Seoul 

backup Mysql through command line

below script to backup mysql database use mysqldump:

c:\xampp\mysql\bin>mysqldump -u root -ppasssword databasename >filename.sql


the filenamesql will store at c:\xampp\mysql\bin folder

expired password on Oracle 11g

please login as system or dba

to show status account :
select username, account_status, expiry_date, lock_date from dba_users;

to set password un expired:
alter profile default limit password_life_time unlimited;

if the password exired then the user locked:
alter user scott account unlock;

ping, netstat, nslookup, telnet, and others. is not recognized as an internal or external command, operable program or batch file

Jika mengalami masalah dan muncul error seperti diatas. Biasa karena path untuk command ping, netstat, nslookup, telnet dan lain sebagainya diatas tidak benar lokasinya.

berikut langkah memperbaikinya :

• Klik kanan di My Computer pilih Properties kemudian klik Advance
• Kemudian klik Environment Variables
• Pada bagian System variables, cari Path
• Double klik Path, kemudian pada Variable value isikan %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem
• Klik OK, kemudian klik Ok lagi.
• Ketik ping blabla di command prompt dan berhasil

enable TELNET on windows 7

you can quickly re-enable Telnet by following these steps:

1. Start
2. Control Panel
3. Programs And Features
4. Turn Windows features on or off
5. Check Telnet Client
6. Hit OK

After that you can start Telnet via Command Prompt.

example: telnet 127.0.0.1 21

Telnet merupakan protokol standar dengan STD nomer 8. Dijelaskan pada RFC 854 – TELNET protocol spesification dan RFC 855 – TELNET options Spesifications.

TELNET memberikan interface pada suatu program di salah satu host (TELNET client) untuk mengakses sumber daya yang berada pada host yang lainnya (TELNET server) sehingga client akan merasakan melakukan kegiatan seperti pada hostnya sendiri.

java: object oriented programming

di sarikan dari berbagai sumber:

Pemrograman Berorientasi Objek

Pemrograman yang menjadikan objek sebagai komponen utama dalam sistem. Objek adalah gabungan data dan fungsi, dimana sebuah objek dibuat dari sebuah kelas

Konsep OOP (Object Oriented Programming)

Kelas : mendefinisikan kerangka dari objek, yang mana objek itu diinstansiasi dari kelas
Objek : dibuat dari kelas yang mana objek memiliki data dan method
Method : Perilaku dari objek atau sebuah fungsi untuk mengerjakan tugas-tugas tertentu

Objek
Objek merupakan hasil dari sebuah kelas, diibaratkan kelas merupakan resep kue dan objek merupakan kue, Maka suatu resep kue dapat membuat beberapa kue.
Pembuatan objek dalam java adalah dengan menggunakan new ,pembuatannya sama dengan pembuatan variable.

Kelas objek = new Kelas();

Jika dalam kelas yang dibuat objek terdapat atribut/variable maka dapat dipanggil dengan cara berikut :
objek.atribut = value;

Kelas
Dalam java, kelas didefinisikan dengan kata kunci class. Contoh kelas sederhana sebagai berikut :

Code:

class Manusia{
String nama,umur;
}

Pada kode diatas kita telah membuat kelas manusia dengan atibut/variable nama dan umur.
Kita akan mencoba membuat objek dari kelas tersebut

Manusia MNS = new Manusa(); //MNS merupakan nama objek pada kelas Manusia

//mengubah nama dan umur pada kelas Manusia yang defaultnya adalah kosong menjadi ada isi nya

Code:

MNS.nama = "Kiki Oktarizky";
MNS.umur = "21 tahun";

Metode (Method)

Dalam java terdapat 2 method :
1. Fungsi : metode yang memiliki nilai kembalian jika metode tersebut dipanggil. Cara pembuatan fungsi adalah dengan menentukan nilai kembaliannya dulu lalu membuat nama method nya.
2. Prosedur : metode yang tidak memiliki nilai kembalian. Cara pembuatan nya sama dengan fungsi, namun nilai kembaliannya menggunakan kata kunci void.

Contoh :

Code:

class Dosen{
String nama;
String ambilNama(){
return nama;
}
void hapusNama(){
nama = " ";
}
}

Pada kode diatas terdapat satu buah fungsi bernama ambilNama() dan prosedur bernama hapusNama(). Untuk mengembalikan suatu fungsi harus menggunakan kata kunci return diikuti nilai yang akan dikembalikannya. Untuk mengambil nilai kembaliannya terdapat seperti kode dibawah :

Code:

Dosen DSN = new Dosen();
DSN.nama = "Bambang Siswoyo";
String nama = DSN.ambilNama();


Contoh Prosedur :

Code:

public class Rumah{
public static void meja(){
System.out.println("Ada Meja");
}
void jamDinding(){
System.out.println("Ada jam dinding");
}
}
class IsiRumah{
public static void main(String[] args){
Rumah.meja();
Rumah panggil = new Rumah();
panggil.jamDinding();
}
}

pada program diatas terdapat 2 buah prosedur bernama meja() dan jamDinding(). method meja bisa dipanggil secara langsung tanpa menggunakan objek pada class isiRumah karena ada keyword static, sedangkan method jamDinding harus dipanggil melalui objek.
Output dari program di atas adalah :

Code:

Ada Meja
Ada jam dinding

Inheritance
Inheritance merupakan kemampuan suatu kelas untuk mewariskan data dan method yang dimilikinya ke kelas lain
analogi nya bisa kita lihat dalam kehidupan sehari-hari seperti seorang anak yang mempunyai sifat yang diwarisi oleh ayah nya, dalam java kelas ayah tersebut (kelas parent) biasa disebut super class dan kelas dari yang mewarisinya disebut sub class.

Code:

//file Pegawai.java
public class Pegawai {
public long hitungGajiTotal(){
return 0;
}
}

Code:

//file Dosen.java
class Dosen extends Pegawai {
private String nip,nidn,gol,j_Struktural,j_Fungsional;
private long t_Struktural,gajiPokok,t_Fungsional,honorMengajar;
int jamMengajar;
Dosen(String nip,String nidn,String gol,String j_Struktural,String j_Fungsional,int jamMengajar
,long honorMengajar){
this.nip = nip;
this.nidn = nidn;
this.gol = gol;
this.j_Struktural = j_Struktural;
this.j_Fungsional = j_Fungsional;
this.jamMengajar = jamMengajar;
this.honorMengajar = honorMengajar;
}
public String getNip(){
return nip;
}
public String getNidn(){
return nidn;
}
public String getGol(){
return gol;
}
public long getGajiPokok(){
if(gol=="IIIA")
gajiPokok = 2000000;
else if(gol=="IIIB")
gajiPokok = 2500000;
else if(gol=="IIIC")
gajiPokok = 3000000;
else
gajiPokok = 0;
return gajiPokok;
}
public String getJ_Struktural(){
return j_Struktural;
}
public long getT_Struktural(){
if(j_Struktural=="Rektor")
t_Struktural = 10000000;
else if(j_Struktural=="Dekan")
t_Struktural = 5000000;
else if(j_Struktural=="Kaprodi")
t_Struktural = 2000000;
else
t_Struktural = 0;
return t_Struktural;
}
public String getJ_Fungsional(){
return j_Fungsional;
}
public long getT_Fungsional(){
if(j_Fungsional=="Lektor")
t_Fungsional = 1000000;
else if(j_Fungsional=="Asisten Ahli")
t_Fungsional = 700000;
else
t_Fungsional = 0;
return t_Fungsional;
}
public int getJamMengajar(){
return jamMengajar;
}
public long getHonorMengajar(){
return honorMengajar;
}
public long hitungGajiTotal(){
long gajiTotal = gajiPokok+t_Struktural+t_Fungsional+honorMengajar;
return gajiTotal;
}
}

Code:

//file PegawaiInheritance.java
public class PegawaiInheritance {
public static void main(String[] args){
Dosen dsn = new Dosen("001","NIDN001","IIIA","Rektor","Lektor",1,50000);
System.out.println("PROGRAM HITUNG GAJI\n");
System.out.println("-----------------------------------");
System.out.println("DOSEN\n");
System.out.println("Nip = "+dsn.getNip());
System.out.println("Nidn = "+dsn.getNidn());
System.out.println("Golongan = "+dsn.getGol());
System.out.println("Gaji Pokok = "+dsn.getGajiPokok());
System.out.println("Jabatan Struktural = "+dsn.getJ_Struktural());
System.out.println("Tunjangan Struktural = "+dsn.getT_Struktural());
System.out.println("Jabatan Fungsional = "+dsn.getJ_Fungsional());
System.out.println("Tunjangan Fungsional = "+dsn.getT_Fungsional());
System.out.println("Jam Mengajar = "+dsn.getJamMengajar());
System.out.println("Honor Mengajar = "+dsn.getHonorMengajar());
System.out.println("Gaji Total = "+dsn.hitungGajiTotal());
System.out.println("-----------------------------------");
}
}

Pada program diatas terdapat satu super class bernama Pegawai dan satu sub class atau kelas turunannya bernama Dosen. Disini kelas Dosen memiliki method-method beserta variable nya tersendiri beserta access modifier masing-masing dan kelas Pegawai hanya mewariskan method yang dimiliki nya yaitu hitungGajiTotal().


Information Hiding dan Encapsulation

• Information Hiding adalah
menyembunyikan attribute dan method
suatu objek dari objek lain.
• Encapsulation adalah menyembunyikan
attribute suatu objek dari objek lain.
• Attribute maupun method disembunyikan
dengan cara memberikan modifier private.

Overrriding Attribute dan Method
• Overriding adalah kemampuan suatu
subkelas untuk memodifikasi attribute dan
method milik kelas supernya (bukan private
atau final).
• Modifikasi : jumlah parameter, tipe
parameter, tipe return value, ataupun
lingkungan pemrosesan datanya

Polymorphism
• artinya bersifat poly morphy (memiliki
banyak bentuk)
• Method‐method overloading dalam kelas
yang sama
• Method‐method overloading dalam kelas
yang berbeda (kelas turunannya)

beda MyISAM dan INNODB di MySQL

MyISAM:
Format tabel MyISAM merupakan pengembangan dan penyempurnaan dari format tabel ISAM, dan merupakan format tabel default pada MySQL. Pada MyISAM file indeks disimpan dengan nama akhiran .MYI dan file data disimpan dengan nama akhiran .MYD

InnoDB:

Tipe tabel InnoDB merupakan tipe tabel MySQL yang mendukung proses transaksi. Tipe ini memiliki beberapa keunggulan, antara lain:
Format Tabel InnoDB mendukung proses transaksi dengan adanya fasilitas rollback dan commit, dan juga kemampuan untuk memulihkan tabel bila terjadi kerusakan pada tabel tersebut. Mampu melakukan penguncian (locking) pada tingkatan record dan juga mampu membaca pada perintah SELECT yang tidak dikunci (mirip dengan kemampuan Oracle).

How to turn off error reporting in php

If you want to turn off any errors and warning from displaying in the web page, The easiest way is to modify the php.ini file. But what if you want to turn off error reporting in php using your php code? you can accomplish this easily using php built in function error_reporting()

<?php
error_reporting(0); // Turn off all error reporting
?>

or

ini_set('display_errors', 1);
ini_set('error_reporting', E_ALL);


or

error_reporting (E_ALL ^ E_NOTICE);


or at php ini, un remark below script
error_reporting = E_ALL & ~E_NOTICE & ~E_DEPRECATED

JAVA: Connection to MySQL

have 2 files:
- KoneksiMysql.java
- and menu.java

database: akademik
tabel : mahasiswa (field: nim,nama )

====================================
name: KoneksiMysql.java

//package koneksi.mysql;
import java.sql.*;

public class KoneksiMysql {
String url, usr, pwd, dbn;
public KoneksiMysql (String dbn) {
this.url = "jdbc:mysql://localhost/" + dbn;
this.usr = "root";
this.pwd = "";
}

public KoneksiMysql (String host, String user, String pass, String dbn) {
this.url = "jdbc:mysql://" + host + "/" + dbn;
this.usr = user;
this.pwd = pass;
}

public Connection getConnection() {
Connection con = null;
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection(this.url, this.usr, this.pwd);
} catch (ClassNotFoundException e) {
System.out.println ("Error #1 : " + e.getMessage());
System.exit(0);
} catch (SQLException e) {
System.out.println ("Error #2 : " + e.getMessage());
System.exit(0);
}
return con;
}
/*
public static void main (String args[]) {
KoneksiMysql kon = new KoneksiMysql ("akademik");
Connection c = kon.getConnection();
}
*/
}


=================================

name: menu.java



import java.sql.*;
import java.io.*;

class menu {
public static void main(String args[]) throws IOException{
BufferedReader stdin=new
BufferedReader(new InputStreamReader(System.in));

String buff;
int pilih;

try {
KoneksiMysql kon = new KoneksiMysql ("akademik");
Connection c = kon.getConnection();
pilih=0;
while(pilih<5) {
System.out.println(" Menu : ");
System.out.println(" 1. Lihat Data ");
System.out.println(" 2. Tambah Data ");
System.out.println(" 3. Hapus Data ");
System.out.println(" 4. Update Data ");
System.out.println(" 5. Exit ");
System.out.print(" Pilih nomor : ");
buff = stdin.readLine();
pilih=Integer.parseInt(buff);
ResultSet hasilQuery = null;
Statement stm = c.createStatement();

switch(pilih){
case 1:
{
hasilQuery = stm.executeQuery("SELECT * FROM mahasiswa");

while (hasilQuery.next()) {
String nim_mahasiswa = hasilQuery.getString("nim");
String nama_mahasiswa = hasilQuery.getString("nama");
System.out.println(nim_mahasiswa+" -> " + nama_mahasiswa); }

break;
}
case 2:
{
String nim_t, nama_t;
System.out.print("nim : ");
nim_t = stdin.readLine();
System.out.print("nama : ");
nama_t = stdin.readLine();
String sql="INSERT into mahasiswa values('"+nim_t+"','"+nama_t+"')";
stm.executeUpdate(sql);
break;
}
case 3:
{
String nim_h;
System.out.print("nim : ");
nim_h = stdin.readLine();
String sqlh="DELETE from mahasiswa where nim = '"+nim_h+"'";
stm.executeUpdate(sqlh);
break;
}
case 4:
{
String nim_u,nama_u;
System.out.print("nim : ");
nim_u = stdin.readLine();
hasilQuery = stm.executeQuery("SELECT * FROM mahasiswa where nim = '" + nim_u + "'");
while (hasilQuery.next()) {
String nm_mahasiswa = hasilQuery.getString("nama");
System.out.println("Nama : " + nm_mahasiswa);
}

System.out.print("Nama Baru : ");
nama_u = stdin.readLine();

String sqlu="UPDATE mahasiswa set nama='" + nama_u + "' where nim = '" + nim_u + "'";
stm.executeUpdate(sqlu);
break;
}
default:
{
System.out.println("Bye");
break; }

}
}
c.close();

}
catch (Exception e) {
System.out.println("Error : "+e);
}
}
}

JAVA: capture camera using JMF

use below script to capture camera on notebook or
Logitech USB Video Camera use JMF

name: SwingCapture.java

import java.awt.BorderLayout;
import java.awt.Component;
import java.awt.Dimension;
import java.awt.Frame;
import java.awt.Graphics;
import java.awt.Graphics2D;
import java.awt.Image;
import java.awt.Panel;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.awt.image.BufferedImage;
import java.io.FileOutputStream;
import javax.media.Buffer;
import javax.media.CaptureDeviceInfo;
import javax.media.CaptureDeviceManager;
import javax.media.Manager;
import javax.media.MediaLocator;
import javax.media.Player;
import javax.media.control.FrameGrabbingControl;
import javax.media.format.VideoFormat;
import javax.media.util.BufferToImage;
import javax.swing.JButton;
import javax.swing.JComponent;
//import com.sun.image.codec.jpeg.JPEGCodec;
//import com.sun.image.codec.jpeg.JPEGEncodeParam;
//import com.sun.image.codec.jpeg.JPEGImageEncoder;
public class SwingCapture extends Panel implements ActionListener
{public static Player player = null;

public CaptureDeviceInfo di = null;
public MediaLocator ml = null;
public JButton capture = null;
public Buffer buf = null;
public Image img = null;
public VideoFormat vf = null;
public BufferToImage btoi = null;
public ImagePanel imgpanel = null;
public SwingCapture()
{setLayout(new BorderLayout());

setSize(320,550);
imgpanel = new ImagePanel();
capture = new JButton("Capture");
capture.addActionListener(this);
String str1 = "vfw:Logitech USB Video Camera:0";
String str2 = "vfw:Microsoft WDM Image Capture (Win32):0";
di = CaptureDeviceManager.getDevice(str2);
//Getting Camera Device Information
ml = di.getLocator();
//MediaLocator for Camera
try
{player = Manager.createRealizedPlayer(ml);//Creating Player
player.start();
//Start Camera Player
Component comp;
//for Getting Visual Player Component of Camera
if ((comp = player.getVisualComponent()) != null)
{
add(comp,BorderLayout.NORTH); //Add Camera to North

}
add(capture,BorderLayout.CENTER); //Add Capture Button in Between
add(imgpanel,BorderLayout.SOUTH); //Add Captured image
}
catch (Exception e)
{e.printStackTrace();
}
}
public static void main(String[] args)
{Frame f = new Frame("SwingCapture");
//Creating New Frame
SwingCapture cf = new SwingCapture();
//Main Object Create
f.addWindowListener(new WindowAdapter() //Window Closing
{public void windowClosing(WindowEvent e)
{playerclose();

//Closing Player
System.exit(0);
}
});
f.add("Center",cf);
//Adding Main Object to Frame
f.pack();

//Packing Frame
f.setSize(new Dimension(320,550));
f.setVisible(true);
}
public static void playerclose()//Function While Closing Player
{player.close();
player.deallocate();
}
public void actionPerformed(ActionEvent e)
{JComponent c = (JComponent) e.getSource();//Getting Source of Event
if (c == capture)//Capture Button Event
{FrameGrabbingControl fgc = (FrameGrabbingControl)
player.getControl("javax.media.control.FrameGrabbingControl");
buf = fgc.grabFrame();
// Grabbing a frame
btoi = new BufferToImage((VideoFormat)buf.getFormat());// Convert it to an image Buffer
img = btoi.createImage(buf); //Creating Image from Buffer
imgpanel.setImage(img);

// show the image
saveJPG(img,"c:\\test.jpg"); // save image Function
}
}
class ImagePanel extends Panel
//Panel for Displaying Cptured Image
{public Image myimg = null;
public ImagePanel()
{setLayout(null);
setSize(320,240);
}
public void setImage(Image img)
{this.myimg = img;
repaint();
}
public void paint(Graphics g)

{if (myimg != null)
{g.drawImage(myimg, 0, 0, this);
}
}
}
public static void saveJPG(Image img, String s)
{BufferedImage bi = new BufferedImage(img.getWidth(null),

img.getHeight(null), BufferedImage.TYPE_INT_RGB);
Graphics2D g2 = bi.createGraphics();
g2.drawImage(img, null, null);
FileOutputStream out = null;
try
{out = new FileOutputStream(s);
}
catch (java.io.FileNotFoundException io)
{System.out.println("File Not Found");

}
//JPEGImageEncoder encoder = JPEGCodec.createJPEGEncoder(out);
//JPEGEncodeParam param = encoder.getDefaultJPEGEncodeParam(bi);
//param.setQuality(0.5f,false);
//encoder.setJPEGEncodeParam(param);
try
{//encoder.encode(bi);
out.close();
}
catch (java.io.IOException io)
{System.out.println("IOException");
}
}
}

The Basic Steps to Connect Oracle and Java Program

http://www.dbapool.com/articles/011706.html

The Basic Steps to Connect Oracle and Java Program Here, I will show you what the steps to make a connection between Oracle database and your Java program. To do this work, you need the JDBC (Java DataBase Connectivity) driver. The file name of Oracle's JDBC driver is classes12.zip or classes12.jar. By default, Oracle have included this driver at the software installation process. Its location is in the ORACLE_HOME\jdbc\lib directory. For example, if our ORACLE_HOME is C:\Oracle\Ora90 then the JDBC driver will be placed in C:\Oracle\Ora90\jdbc\lib directory. Make sure to set the Java CLASSPATH correctly. Here is the command line to do it. (Note: Assume the ORACLE_HOME is C:\Oracle\Ora90) set CLASSPATH=.;C:\Oracle\Ora90\jdbc\lib\classes12.jar or set CLASSPATH=.;C:\Oracle\Ora90\jdbc\lib\classes12.zip In addition, you can also set the CLASSPATH in your autoexec.bat file on your Windows operating system. Now, just follow these steps: STEP 1. Import the java.sql package into your program. ------------------------------------------------------ import java.sql.*; The syntax above will import all classes in the java.sql package. If you want to import a few of them, you can write the syntax like this import java.sql.Driver; import java.sql.DriverManager; import java.sql.Connection; It only imports the Driver, DriverManager, and Connection class into your Java program. STEP 2. Load the Oracle's JDBC driver. -------------------------------------- There are two ways to load your JDBC driver. The first, use the forName() method of java.lang.Class class. Class.forName("oracle.jdbc.driver.OracleDriver"); And the second way is use the registerDriver() method of DriverManager class. DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); STEP 3. Create a Connection object. ----------------------------------- To create a Connection object, use the getConnection() method of DriverManager class. This method takes three parameters: URL, username, and password. Connection conn = DriverManager.getConnection( "jdbc:oracle:thin:@mylaptop:1521:ORADB", // URL "budi", // username "Bandung" // password ); STEP 4. Create a Statement object. ---------------------------------- The Statement object can be created by call the createStatement() method of Connection object that you made before. So, you can write the following code Statement mystat = conn.createStatement(); STEP 5. Execute your SQL statement. ----------------------------------- After you create a Statement object successfully, you can execute a query (SELECT statement) from your Java program using the executeQuery() method of Statement class. The result of execution process will be stored in ResultSet object, so you need to declare an object of ResultSet first. Here is the code. ResultSet rs = mystat.executeQuery("select custno, custname from customer"); STEP 6. Display your data. -------------------------- The next step is display your data using the looping control. while (rs.next()) { System.out.println( rs.getInt(1) + // first column "\t" + // the horizontal tab rs.getString(2) // second column ); } STEP 7. Close your statement and connection. -------------------------------------------- mystat.close(); conn.close(); Here is the complete code. /********************************************************************* * File name : SimpleOraJava.java *********************************************************************/ import java.sql.*; class SimpleOraJava { public static void main(String args[]) throws SQLException { DriverManager.registerDriver( new oracle.jdbc.driver.OracleDriver() ); String serverName = "mylaptop"; int port = 1521; String user = "budi"; String password = "password"; String SID = "ORADB"; String URL = "jdbc:oracle:thin:@" + serverName + ":" + port + ":" + SID; Connection conn = DriverManager.getConnection(URL, user, password); String SQL = "SELECT CUSTNO, CUSTNAME FROM CUSTOMER"; Statement stat = conn.createStatement(); ResultSet rs = stat.executeQuery(SQL); while (rs.next()) { System.out.println( rs.getInt(1) + "\t" + rs.getString(2) ); } stat.close(); conn.close(); } }