Creating and configuring a MySQL DataSource in GlassFish Application Server.

Creating and configuring a MySQL DataSource in GlassFish Application Server.

Follow the below steps for creating and configuring a MySQL DataSource in GlassFish application server.
1. Download MySQL JDBC driver from http://dev.mysql.com/downloads/connector/j/3.1.html
2. Extract the contents of the zip file
3. Copy mysql-connector-java-x.x.x-bin.jar to GLASS_FISH_INSTALL_DIR\lib folder.
3. Start your GlassFish Application server by issuing the command ‘asadmin.bat start-domain domain1′ from GLASS_FISH_INSTALL_DIR\bin directory.
4. Login to GlassFish admin console. The default url for GlassFish admin console will be http://localhost:4848/login.jsf. The default username and password for accessing the admin console will be admin and adminadmin respectively.
5. From Common Task menu expand Resources menu by clicking on Resources menu.
6. Expand JDBC under resources.
7. Click on ‘Connection Pools’ under JDBC menu. The Connection Pools page will be displayed.


8. Click on New.
9. Enter a name for your JDBC Connection pool. Select javax.sql.ConnectionPoolDataSource as your ‘Resource Type’ and select MySQL as your ‘Database vendor’.


10. Click on Next.
11. Fill the details according to your need. Minimum you need to fill the following fields.

a. DatabaseName
b. Password
c. URL (The format will be jdbc:mysql://localhost:3306/test. Where test is your database name.)
d. Url (The format will be jdbc:mysql://localhost:3306/test. Where test is your database name.)
e. ServerName
f. User
12. Click on Finish. You will be taken back to the Connection Pools page.
13. Click on the Connection Pool you created. You will be taken to ‘Edit Connection Pool’ page.
14. Click on Ping. If your connection pool is setup correctly you will get a Ping Succeeded message.


15. Now click on JDBC Resorces under JDBC menu.
16. Click on New.
17. Enter a JNDI Name for your data source. Select the pool you created by following the above steps as your ‘Pool Name’.


18. Click on OK. You are done.To obtain a connection using the above DataSource, use the following code.

Source: http://www.albeesonline.com
http://www.albeesonline.com/blog/2008/08/06/creating-and-configuring-a-mysql-datasource-in-glassfish-application-server/

What is ISO8583

What is ISO8583? Of course we are familiar with the name of the ISO, which is an international organization dealing with the standardization of products. Well, related to ISO8583, is a messaging standard relating to financial data. Usually my friends working in the field of financial transactions, such as in areas of banking, data switching, ATM, EDC is no stranger to being on this one. I, incidentally, including those unfamiliar with this ISO8583. I first saw her message is full of examples of alpha-numeric characters long and can not be read as. Finally after reading some of the references, data contained on a row of characters.

ISO8583 structure

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

ISO8586 structure consists of three parts:

MTI (Message Type Indicator)

MTI explain what kind of message he sends, a message transaction or inquiry message (non transactional). MTI is composed of 4 digits.

- Digit 1: show version

- Figure 2: shows the message class

- Digit 3: The message sub class

BIT MAP

A bit map is an indexing technique in ISO 8583 are used to identify whether a data element at the specified index position there or not. There are two kinds of bit map,



The first primary and secondary bitmap bitmap. Primary bitmap memilikin indexs 1-64,

both secondary bitmap 65-128. If the secondary bitmap appears, then bit one must be active.

Data Element

The data elements indicate the data that will be sent in a transaction in the body of ISO 8583. Eg the example bit:

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4


Bit 2 contains information atm card number.
Bit 4 contains information the transaction amount.
Bit 32 contains the code bank.
Bit 18 contains the type of channel (sms / EDC / atm).
Etc ... .. up to 128.

Installation Modem Smartlink with Ubuntu 9.10

You are using Ubuntu 9.10 - the Karmic Koala - released in October 2009 and supported until April 2011. This section is an introduction how to install modem smartlink with Ubuntu 9.10
The kernel is "Linux xxx-desktop 2.6.31-14-generic #48-Ubuntu SMP Fri Oct 16 14:04:26 UTC 2009 i686 GNU/Linux"

#!/bin/bash
zz@zz-desktop:~$ lspci

03:01.0 Modem: Smart Link Ltd. LM-I56N (rev 02)

(launcher script)

#!/bin/bash

sudo slmodemd -c INDONESIA /dev/slamr0 & sudo wvdial ; sudo killall slmodemd ;

(wvdial script)

[Dialer Defaults]

Init1 = ATZ

Init2 = ATQ0 V1 E1 S0=0 &C1 &D2 +FCLASS=0

Modem Type = Analog Modem

ISDN = 0

Phone = 99999999999

New PPPD = yes

Modem = /dev/ttySL0

Username = userid

Password = password

Baud = 460800

Carrier Check = no

Upgrade Nexian journet A890 to Froyo

About 2 months ago I bought nexian journey base on android ,this is our experience about installing android froyo,The first Cyanogen Mod build for Nexian Journey is quite the rush. By default, the CPU is forced to run at 800 MHz, that’s more than the 600 MHz capability of the phone. Luckily, the next build now defaults to 600 MHz and that’s the build I’m upgrading my phone with.

The requirements to upgrade is the following:

1. Upgrade your phone to Eclair if you’re not already in Eclair. Steps to do so after the break. Download CMLMod 1.3 here for some Eclair love.
2. You will need Clockwork recovery image after flashing CMLMod 1.3, download here.
3. This is the best part, Cyanogen Mod 6.1 Build 7 for your Journey, download here. [UPDATE] Stable Release 6.1.1 .
4. Google Apps – MDPI here.
5. A decent laptop/pc or a Mac with Parallels and Windows XP will do.
6. Android Rom Upgrade Tools (RUT) and Drivers for 32 bit windows here, 64 bits windows here or both here.
7. Fastboot windows, you can download with google.

Nowadays, rooting is a very easy task. It’s already built into the recovery image, what else can you ask?

for this i give u the picture and so here are the steps:

1. Skip to step 7 if you’re already in eclair. If not, backup everything precious located on your phone’s memory and let’s begin.
2. *UPDATE* Before plugging in to RUT, power off your phone and press HANG UP soft button, VOLUME UP and POWER to enter Download mode. Fire up the RUT you downloaded earlier above, click on NEXT until you find the dialog asking you to specify the ROM you’re gonna flash. Point it to your CMLMod 1.3 .nb0 file.
3. Power off your Journey and power it back on by pressing CAMERA, VOLUME UP and POWER. Now plug the USB cable in and RUT will detect your phone. Point it to the drivers you’ve downloaded before.
4. Follow all the steps until your phone finally boots to CMLEclair 1.3.
5. When you’re in, power the phone off again. Bring it back on by pressing CAMERA, VOLUME UP and POWER to reenter recovery mode. Now look for the option to ENABLE ROOT. Scroll with your trackball, select by pressing the trackball and confirm by pressing the HOME soft-button.
6. When you’re done rooting, turn it off again.
7. Power on the phone by pressing RED/HANG UP, VOLUME DOWN and POWER to enter Fastboot mode.
8. Windows will ask for drivers and point it to the android drivers you downloaded earlier.
9. Open up a command prompt and go to the folder where you downloaded fastboot. To keep it simple, I put fastboot and Clockwork recovery image on C:\

cd \
fastboot-windows flash recovery clockwork-z71.img
fastboot-windows reboot

10. Your phone will reboot. Once you’re in, copy the Cyanogen Mod ROM file and Google Apps to your SD Card then power off your phone again and bring it back on by pressing CAMERA, VOLUME UP and POWER.
11. Once you’re in RECOVERY MODE, scroll to INSTALL ZIP FROM SDCARD by using the VOLUME UP or VOLUME DOWN button. Please note that when you press and release the volume buttons, it’ll be counted as 2 scrolls. Press the trackball to make your choice.
12. Select the Cyanogen Mod zip file and confirm flashing.
13. Select Google Apps zip and confirm flashing.
14. Use the BACK soft-button to go back to where you started, select WIPE DATA/FACTORY RESET and confirm.
15. Select WIPE CACHE PARTITION.
16. Select ADVANCED >> FIX PERMISSIONS
17. Back to the beginning, select ENABLE ROOT to live on the edge ;)
18. REBOOT!

Source : www.bango29.com

After Install Ubuntu 9.10 ( Carmic)

Ubuntu 9.10 ( Carmic) presents really cool view of dark color. A lot of improvement there , more faster, more responsiveness, but a lot of things you should do after installing Ubuntu 9.10.

Install VGA Driver
Install the VGA driver is needed for users compiz fusion to create the look interesting. To install it go to Applications -> Ubuntu Software Center looking for "NVidia Drivers" (if you use NVidia VGA). After installing VGA restart the computer and the VGA driver is active.

Install Multimedia
DVD, Divs, Xvid, MP3, WMA, MOV, etc.
Applications -> Ubuntu Software Center and search Gstreamer plugins

Install package rar
Files. rar is much scattered on the internet, ranging from ebooks, music, movies and others. to install the rar package Application -> Terminal
sudo apt-get install rar unrar

Mount hardisk
sudo apt-get install pysdm

Install Adobe Flash Plugin
Applications -> Ubuntu Software Center and search Adobe Flash Plugin

Update new package
Sudo apt-get update

Setting the download package ubuntu
System -> Administrasion -> Software Sources -> Ubuntu Software check the source code instead of downloading from a server for Indonesia

Instal JVM (Java Virtual Machine)
Application -> Ubuntu Software Center search Java
install Sun Java Runtime

Change your wallpaper
Klik right on mouse and Change dekstop background and then choose wallpaper that you like

Wasteful Battery on Nexian Journey (Android)

If you users nexian journey android one of the major constraints is the problem of wasteful battery. There are several ways to save on battery usage on nexian journey

WIFI (OFF)
Mobile Network Data Enabled (OFF)
Use GPS Satellites OFF
Bluetooth OFF
Network Mode WCDMA GSM Auto (atau GSM Only)
Brightness less than 50%
wallpaper offline mode
Performance setting in CML are set On-demand or Economic

On Demand and Economic Differences:

If On Demand processor will automatically increase the speed if required (eg run a specific program) and will automatically come down to the lowest speed if no program-run / is idle (19.2 not like writing CMLMod 120Mhz)

If Economic almost the same as on demand, the difference between the highest processor speed only a maximum of 320Mhz

when it all but still want to run more efficient, in fact there is one thing which does can do is auto power off before we can use sleep aplication TimingOff aplication (can be taken for free at the Market), there schedulenya android every hour how we will die (usually at 12 am )

Upgrade Nexian Journey A890-2.1 Eclair w/CMLMod

WARNING

• Jika Anda melakukan upgrade atau menginstall ROM sendiri tidak melalui service center mungkin akan menghanguskan garansi HP anda

• Dimungkinkan HP anda menjadi rusak jika dalam proses upgrade tersebut tidak berhasil

• Seluruh data yang ada di HP anda kemungkinan akan hilang

Requirements:

• PC minimal Windows XP sp3 ( not for Win Vista/7 64 bit)

• Kabel USB

• Batre HP Mencukupi

File

• ROM Apanda 1.6.2 (Donut)

• CMLEclair1.3

• Driver PC

Part 1 (Install Apanda 1.6.2)

• Download dan eksrak driver dan pastikan lokasinya telah anda ketahui

• intall RUT_V1_2_2 yang ada dalam CMLEclair1.3.rar

• Ektrak firmware 1.6.2 dari archive Hipi1_6_2.rar isinya file dengan ekstenti .nb0

• Jalankan RUT (ada shortcut di desktop anda).

• Setelah RUT jalan, klik next 2 kali, kemudian cari dan pilih file yang berekstensi .nb0

• Ikuti instruksi – Cabut HP dari PC dan Cabut Batre HP anda

• Tekan dan tahan tombol kamera dan tombol volume secara bersamaan dan tekan tombol power untuk memasuki menu recovery

• Setelah masuk ke menu recovery, sambungkan HP anda ke PC

• Installer akan mendeteksi HP anda

• Mulai dan ikuti petunjuk di layar dan tunggu, butuh waktu beberapa lama sampai proses update selesai

• Hp akan restart secara otomatis

Sekarang Nexian Journey anda sudah terisi ROM Donut punyanya Apanda

Part 2 ( Install CMLEclair1.3)

• Ekstrak CMLEclair1.3.rar

• Jalankan lagi program RUT dan pilih CMLEclair1.3.nb0 yang telah di ekstrak dari file diatas

• Cabut Batre dan restart hp

Part 3 (Aktifasi App2sd)

• Setelah HP anda dalam posisi on masuk ke main menu dan kemudian cari icon CMLMod

• Pilih Configurasi App2sd

• Pilih Partionar SD

• HP Anda akan restart ke recovery mode

• Sekarang pilih partition sdcard, partition SD dan konfirmasi tombol Home key set swap=0, ext2=512 dan konfirmasi lagi

• tekan tombol back dan pilih Enable APP2SD

Sekarang setiap aplikasi yang terinstall akan masuk ke Sdcard anda.

Switch Database on Login Page with PowerBuilder

Many ways to connect in mysql database in PowerBuilder.To perform database selection directly on the login page using PowerBuilder application and database mysql we can use this script that can be placed on the login button.
Put your drop down list box on login page as a swicth control to database (ls_db). For exp we can say production_db for real operation and UAT_db for testing application. this is
pretty easy ok

//=== variable ==
String ls_db Integer li_install, li_count


ls_db = ddlb_0.text

////***** Profile database******for mysql****
SQLCA.DBMS = ProfileString(gs_path + "\proto.INI",ls_db,"DBMS", " ")
SQLCA.AutoCommit = false
SQLCA.DBParm= ProfileString(gs_path + "\proto.INI",ls_db,"DbParm", " ") + ";UID=root;PWD=mounxxxx;OPTION=135168',DisableBind=1,StaticBind=0,PBUseProcOwner=NO"

connect using sqlca;

if isnull(sqlca.sqlcode) or sqlca.sqlcode <> 0 then
messagebox("Database Not Connect ",string(sqlca.sqlcode)+sqlca.sqlerrtext)
return
else

//…open the application

End if

Windows Aplication Running on Ubuntu

This story is continued from the previous story about how windows connection with database application MYSQL on Ubuntu Linux Operating System. I have the application built with PowerBuilder 7 and I try to run on the OS. The result was encouraging that applications can run well and have a fairly good performance. Berikut ini adalah langkah-langkah yang saya lakukan untuk instalasi tersebut:

Install The Application


Chosing application folder
Chosing Platform Aplication ( when we running on UBUNTU WINE then we chose windows platform when install it )
IP dan Port Database
Chose Library to connecting MYSQL Database

• ODBC32
• ODBCCP32
• Ole32
• Msvclrt
  

Installing MDAC 2.8


No need reboot and aplication run very well

Connection ODBC with WINE on UBUNTU

This story met when i want to running windows aplication on ubuntu (wine), the aplication using Powerbuilder 7 and MYSQL database for backend and then i'm follow below the instruction and tadaaaaaa the aplication was running very well

Install windows compunent with winetricks

Winetricks script using for download windows component . that Script can be download from http://winezeug.googlecode.com/svn/trunk/winetricks. follow the step below:


$ sudo apt-get install cabextract
$ wget -c http://winezeug.googlecode.com/svn/trunk/winetricks
$ chmod 755 winetricks
$ ./winetricks


graphical Interface winetricks down below:


Mark the package-package jet40, mdac28 and mfc42 than clik OK.
Winetricks will be download that package-package and running istallation to wine.
Follow the step installation for each package.