You can’t know but default Android’s browser isn’t Chrome, only a implementation of Webkit.

Today(7), quietly, Google published the beta version of your browser in Android Market. But, only the ICS (Ice Cream Sandwich), or above, is able to run it. I hope the Google change it to a most “accessible” version.

The video below shows Chrome in action.

Android Market

Unfortunately I don’t have the Ice Cream Sandwich to write a review, but read complete description and comments of who already downloaded the brownser from Android Market.

If you uses Chrome, share your experience with us.

See ya!

I don’t known if is a bug or a feature, for me, it’s a big security fault.

If you has iPhone 3G or 4G locked with password and voice assistant enabled, try to press button Home for 5 seconds. Voice assistant will be run.

Tell any name contained in your phone book and the assistant will to call “normally”, also works with others commands.

This is your default behavior, used by most users. It’s can be disabled in device’s settings.

Avast, security company and anti-virus developer, owns in your website a report about more infected domains around the world, including Brazil.

This report shows you 10 domains virus and trojans dispensers.

10º futuroprofessor.com.br
09º canalkids.com.br
08º marmelada.com.br
07º explorando.com.br
06º bitscaverna.com.br
05º hd1.com.br
04º blogdocomputador.com.br
03º podcats.com.br
02º uol.com.br
01º dowload.net.br

You can see this report to other countries in http://www.avast.com/en-us/maps.

So, here’s a tip to compile several invalid packages, procedures and/or functions and fix this.

There is a command to compile all invalid objects under an user, the command is:

<pre class=”brush:sql”>exec dbms_ultility.compile_schema(&lt;USER&gt;);</pre>

Replace  &lt;USER&gt; for <i>user</i>, or for user name where invalid objects are.

This command is slow and not compiles objects invalidated by coding error. To find which are invalid you need runs the query below:

<pre class=”brush:sql”>
select object_name
from all_objects
where status = ‘INVALID’
</pre>

Invalid objects will be listed.

A few weeks ago Google released a beta version of Google Analytics’s reports in real time. It’s possible see number of people visiting your website, wich pages they are acessing, where they are from and how they got there.

But, not all accounts can have this option enabled.

To access the report, after the login and choose the profile, click on “Home” and click “Real-Time (beta)” in the left menu.

Recently released, the Motorola Droid Razr is the thinnest smartphone with 4G worldwide. With 7.1 mm thickness, it has a 4.3 inch Super AMOLED screen, 540 x 960 resolution and protected with Gorilla® Glass screen. Its 8MP camera, can record Full HD (1080p) videos, its front 1.3MP camera allow videos in HD resolution (720p).

More light and resistant, Motorola Razr is coated by Kevlar®, giving a more attractive finish.

Android Gingerbread (posteriorly Icecream Sandwich) is supported by your Dual-core processor 1.2 Ghz and 1GB RAM. Also can count with internal memory has 16 GB, more 16 GB (expansible to 32 GB) in MicroSD card that comes with it, EDGE, GPRS, 3G, Wi-FI and 4G, GPS and DLNA (Digital Living Network Alliance) protocol.

Talking about connectivity, the smartphone will comes with MotoCast pre-installed. This application allows you to share your files, videos and music between your device and your PC trough Wi-Fi, 3G or 4G, without USB cable.

As Motorola Atrix, Droid Razr also compatible with Webtop gadget.

The design of Motorola Droid Razr is based on his grandfather, Motorola Razr V3, wich sold 110 million units worldwide.

Motorola Razr V3x

Motorola Droid Razr

The release was on november 16, but still is not possible find the device in Brazil, where the suggested price for Motorola is R$ 1999.00 (US$ 1110.00).

This application, developed by Google, allows you to find podcasts and subscribe to it. Podcast that aren’t found by search, can be subscribed manually in “My subscriptions” options.

Here, with brazilian 3G quality, you will get a continuous audio (without buffer pauses) using the wi-fi connection or hearing tracks with 96kbps or less.

The Listen allows you download audios to listen it after, when you want and without internet connection.

Link: Listen
Price: Free
Advertisement: No
Rating*: 3,8/5

* Rating obtained until publication

ProxoId, free application available in Android Marketing, allows you to share connection from your Android  only using USB cable.

It needs a stand alone program and Android drivers running in your PC/laptop to work.

The driver and stand alone program can be found in a ZIP file for Windows 32 bits  here  and Windows 64 bits here. If you’ve already installed manufacturer driver (from CD), skip to Finding your smartphone section.

*Texts of images bellow are in Brazilian Portuguese

Installing drivers

Uncompress ZIP file and connect your Android to PC. The new hardware wizard will be shown.

Choose “No, not this time” and click in “Next”. In following screen, choose”Install from a list or specific location”. Click “Next”.

Enable the options “Search for the best driver in these locations” and “Include this location in the search”, then click in “Browse”.

Go to directory where you have uncompressed the ZIP file > “usb_driver” > “x86″, like image bellow.

Click in “OK”, “Next” and follow next steps until complete the installation.

Finding your smartphone

Make sure your Android is connected to computer. Open the directory “proxoid-adb” and run “check.bat”. A screen with number of your device, like this below, should be displayed.

If don’t, try to desconnect and connect your smartphone again or try to reinstall the drivers.

Configuring ProxoId

Configuration screen is opened when ProxoId runs:

“Start/Stop ProxoId” – Control service to share the connection;
“Port” – Port number to proxy
“User-Agent Filter” – Mask to User-Agent (Browser).

Configuring Browser

Internet Explorer and Google Chrome

Open “Start” menu > “Control Panel” and “Internet Options”. Click in tab “Connections” and in “LAN Settings”.

In “Address”, type “localhost” and, in “Port”,  type same value marked in application.

FireFox

Open Firefox, clique in menu “Options”. Choose tab “Advanced” > “Network” and click in button “Settings…”.

Enable “Manual proxy configuration” option.

In “HTTP”, type “localhost” and, in “Port”, type same value marked in application.

Sharring the connection

Enable “Start/Stop ProxoId” in your Android.

At computer, run “start-tunnel.bat” in “proxoid-adb” directory.

That’s it! While application is enabled and  ”start-tunnel.bat” is running, your computer will use your Android to connect at internet!

Requirement:

• Bluetooth adapter (if your PC/notebook don’t have it);
• PS3 USB cable;
• .NET Framework 4 – Can be downloaded from here;
• Operational System Windows XP, Vista or 7 (seven).

You need to download the custom driver from Motionin Joy’s site to
Windows XP, Windows Vista and Windows 7 (32 bits) or Windows XP, Windows Vista e Windows 7 (64 bits).

Extract ZIP file and run the “.exe”. Follow installation steps and run “DS3 Tool”, or click Start Menu > Programs > MotioninJoy > DS3 Tool.

Screen below will be shown:

Connect the joystick in to PC using USB cable. Click menu “Driver Manager”, select the device and click in button “Install all”.

After installation (may take 1 minute), click in menu “Profiles”.

The joystick should appear in list (circle). Select the option “Playstation 2 (POV, Joysticks, Analog Trigger)”, “Custom” and number of joystick (for us “1″).

To finish, click menu “Bluetooth Pair”, select the joystick in list “Dual Shock 3″ and click in button “Pair Now”.

It’s done! When MAC address apear where is “Have Paired to” you can disconnect USB and use joystick normally through Bluetooth.

Enjoy!

At Android 2.2 there is a possibility migrate the apps to SD card after instalation, but some applications not allow to do this.

Looking for a fix to solve this problem in my Motorola Droid, I found a way to install apps directly in SD card, like show in Mundo Zoom, and not need root.

Download ZIP file from Android SDK and extract. Browse to folder “android-sdk-windows\platform-tools“.

Set your Android to debug mode. Don’t you know? “Settings” > “Applications” > “Development” and enable “USB debugging” option.

Connect your smartphone in USB and enable “Charge Only” on USB Connection Management.

Click in Start Menu, Run. Type “cmd” e press Enter to open command prompt.

With command prompt and Windows Explorer opened, click and drag file “adb.exe” to prompt window, after, insert a space and type “shell”. Press Enter.

The “$” simbol and cursor should appear. Now type “pm setInstallLocation 2” and press Enter

This command sets partition “2″ (SD Card) as default to install applications.

Done! That`s all you need for apps to be installed directly in your SD card

These methods are useful for programmer that do not knows wich characters represents file separator and path separator at OS that supports your application.

Linux/Unix, the methods File.separator and File.pathSeparator returns “/” and “.”, while in Windows, these methods returns “\” (or “\\” – escape) and “;”.

In recent case, the code below threw exception FileNotFoundException running over Linux, but not running over Windows:

String appPath = ctx.getRealPath();
String filePath = appPath + "\\" + "WEB-INF/classes/my/application/packages/";

File file = new File(filePath, "report.pdf");
OutputStream out = new FileOutputStream(file);
...

Worked in both systems after to replace “\\” by File.separator in line 2:

String appPath = ctx.getRealPath();
String filePath = appPath + File.separator + "WEB-INF/classes/my/application/packages/";

File file = new File(filePath, "report.pdf");
OutputStream out = new FileOutputStream(file);
...

Utilization of these methods, besides a good practice, is very usefull when same version of an application is running over differents operacional systems.

I’ll start with RemoteControl for Earphones. It just cancel a vantage of iPhone over Android: to control media players using the earphones’s button.

The button’s behavior is to pause and start music. RemoteControl for Earphones allow you runs almost all commands of a media player. To play or pause, press button once, to skip forward, press button twice, to skip rewind, press four times…

App screen (Android Market)

This application is for free and don’t have advertisement.

Most players are incompatible, but it work very well in Morotola Droid’s player, Songbird, but not work in Winamp and players of Samsung Galaxy S and Motorola Atrix.

Link:  RemoteControl for Earphones
Price: Free
Advertisement: No

Luis’s tutorial explain how to install on Ubuntu 9.10, so some steps are not necessary. I’ll show necessary steps to install on Ubuntu 10.04.

You need to download drivers from Avasys site. Go to this link, scroll down the page, choose “Epson Stylus CX4300/CX4400/CX4450/CX5500/CX5600/DX4400/DX4450“, “Ubuntu” and version “10.04“, click “Next”.

Now, download “iscan-data_1.9.0-1_all.deb“, “iscan_2.26.4-2.ltdl7_i386.deb” and “iscan-plugin-cx4400_2.1.3-1_i386.deb“. After, run commands:

sudo dpkg -i iscan-data_1.9.0-1_all.deb
sudo dpkg -i iscan_2.26.4-2.ltdl7_i386.deb
sudo dpkg -i iscan-plugin-cx4400_2.1.3-1_i386.deb

Make sure the scanner is connected and turned on and run command

lsusb

Should appear a list of devices connected to the USB ports, like this:

Bus 003 Device 004: ID 04b8:083f Seiko Epson Corp. Stylus DX4450
Bus 003 Device 003: ID 04fc:05d8 Sunplus Technology Co., Ltd
Bus 003 Device 002: ID 04f3:0216 Elan Microelectronics Corp.
Bus 003 Device 001: ID 1d6b:0001 Linux Foundation 1.1 root hub
Bus 002 Device 001: ID 1d6b:0001 Linux Foundation 1.1 root hub
Bus 001 Device 003: ID 18e3:9101 Fitipower Integrated Technology Inc
Bus 001 Device 001: ID 1d6b:0002 Linux Foundation 2.0 root hub

The first line (“Bus 003 Device 004: ID 04b8:083f Seiko Epson Corp. Stylus DX4450“) means the scanner was detected on address 003:004.

These steps are enough for the scanner be detected for XSane, but only root can to use.

To fix this “little” problem, edit file /lib/udev/rules.d/40-libsane.rules and add the following lines:

# Epson CX5600
ATTRS{idVendor}=="04b8", ATTRS{idProduct}=="083f", MODE="0664", GROUP="saned", ENV{libsane_matched}="yes"

Turn off and turn on your scanner. To see if the problem was fixed, run command lsusb again. The output should be like this:

Bus 003 Device 004: ID 04b8:083f Seiko Epson Corp. Stylus DX4450

Note the number of “Bus” and “Device”, with them run command

ls -l /dev/bus/usb/<BUS>/<DEVICE>

Replace <BUS> and <DEVICE> by respective numbers:

ls -l /dev/bus/usb/003/004

You will see something like

crw-rw-r--+ 1 root saned 189, 129 2011-07-01 14:01 /dev/bus/usb/003/004

Now you can to use your scanner with any user owned to group saned.

To know if it your problem too, edit file error_log in wp-admin directory and and take a look at last rows.

The following process fixed this for me, but your host server should allow sizing PHP memory at runtime.

Open and edit file wp-settings.php at root of WordPress directory and put the row bellow after “<?php”:

define('WP_MEMORY_LIMIT', '64M');

Here I’ve set up to 64MB to PHP, but how to know amount of MB to set up?

In error message, the long number means amount of bytes allocated to PHP: “Fatal error: Allowed memory size of 33554432…”. This number represents 32MB (do this calculation to converts byte in megabytes 33554432 / (1024^2) = 32).

Just set a number greater than the result in line above.

The fight between Firefox and Internet Explorer is old and, little time ago, Microsoft’s browser lost first position to Firefox. Now, with Google Chrome more stable and accessible, the three firsts position may be changed again.

In one year of interval, this blog had 35,738 visits, where the Firefox was most usable browser, responsible for 14,705 (41.75%) of access, distantly followed by Internet Explorer (10,542 access, or 29.5%) and Google Chrome (8,679 access, or 24.29%). Opera came in 4th and Safari came in 5th.

Below the chart generated by Google Analytics with complete list of browsers and amount of access:

Chart generated by Google Analytics between 06/07/2010 and 06/07/2011 (click to zoom)

Will be a matter of time to Internet Explorer to leave second position to Google Chrome

At MySQL, for example, this field is called MEMO.

Writing CLOB field

The method setAsciiStream of PreparedStatement allow to pass data to a CLOB.

ps.setAsciiStream(bindPosition, inputStream, textLength);

bindPosition – Position in PreparedStatment’s CLOB field.
inputStream – Used to pass data.
textLength – Data (text) length.

Full code:

String sql = "INSERT INTO TABLE (text) VALUES(?)";
		try{
			String txt = readTxtFile();
			ByteArrayInputStream bais = new ByteArrayInputStream(txt.getBytes());

			PreparedStatement ps = conexao.prepareStatement(sql);
			//CLOB is '?' at first position
			ps.setAsciiStream(1, bais, txt.length());

			ps.execute();

			ps.close();
		}catch (Exception e) {
			e.printStackTrace();
		}

Retrieving CLOB data

We’re using SELECT clause, this clause returns a ResultSet to fetch data and, calling getClob method, passing column name or your position in the query, it give to you a Clob object.

rs.getClob("xml");

Full code:

String sql = "SELECT xml FROM TEST";
		try{
			PreparedStatement ps = conexao.prepareStatement(sql);
			ResultSet rs = ps.executeQuery();

			while(rs.next()){
				Clob clob = rs.getClob("xml");
				BufferedReader reader = new BufferedReader(clob.getCharacterStream());
				StringBuffer strBuf = new StringBuffer();

				String linha = null;
				while((linha = reader.readLine()) != null){
					strBuf.append(linha);
//Character.LINE_SEPARATOR insert break line
					strBuf.append((char)Character.LINE_SEPARATOR);
				}

				System.out.println("=========== CLOB ===========");
				System.out.println(strBuf.toString());
			}

			rs.close();
			ps.close();
		}catch (Exception e) {
			e.printStackTrace();
		}

That’s it! Easy and painless

Download full code here

To write a BLOB see this tutorial.

In directories of SDK, commonly in platform-tools, there is an executable called adb, with it we’ll to install third-part applications.

You will need an application (.apk). Browse internet or copy from your Android smartphone using applications like AppSaver.

- Run the emulator, you can use SDK Manager or Eclipse plugins.

- Using DOS Command (Windows) or terminal (Linux), open directory platform-tools and run commando line below:

$ adb install <.apk path>

This message will be displayed

$ adb install Application.apk
125 KB/s (1091937 bytes in 8.474s)
        pkg: /data/local/tmp/Application.apk
Success

Now, the third-part application is available at emulator menu, like have installed in your smartphone.

Agora o aplicativo estará disponível no menu do emulador.

The .REG file are available here .

Before run file, open it with notepad and change path “C:\\Program Files\\Java\\jdk1.6.0_23″ to your JDK directory, and the path “C:\\Program Files\\Java\\jre6″ to your JRE directory.

This fix has worked for me.

Few persons knows, but there are three forms to realize factory reset at Motorola Milestone, for Milestone that come with Android 2.0, another to Android 2.1 and that works at both.

Before, damages occured with your phone following the tutorial will be only your responsability. I will not responsible by eventual damages caused by tutorial bellow.

If you agreed, go to work!

Milestone with Android 2.0

• Turn the phone off.
• With your phone off, press the cam button and On/Off at same time and not release them.
• When Motorola’s logo appear, release On/Off button but keep cam button pressed.
• After 10 or 15 seconds, a triangle with exclamation point will be appear:



• Then, release cam button and press + volume button and cam button again, at same time.
• Use directional pad to select “Format options” option and click at “Wipe data/factory reset”.
• Select the slot with your data and go ahead!

Milestone with Android 2.1

• Turn the phone off.
• With your phone off, press “X” key at keyboard and On/Off at same time and not release them.
• When Motorola’s logo appear, release On/Off button but keep cam button pressed.
• After 10 or 15 seconds, a triangle with exclamation point will be appear:



• Then, release “X” key and press + volume button and cam button again, at same time.
• Use directional pad to select “Wipe data/factory reset”.
• Select the slot with your data and go ahead!

Both

• At main screen, click menu and select “Settings”.
• Select “Privacy” option and click at “Factory data reset” option.
• A text explain about this procedure, click “Reset Phone” button.

After any procedures above, your Milestone will reset any configuration and data, like when you used at first time.

While here, in Brazil, the most fast connection is 100Mbps, the japanese are testing 1Gbps connection speed. Realy, 1Gbps!!

I live in São Paulo and in my house there isn’t a quality connection, my 1Mpbs connection rarely reaches 600Kbps.

Youtube provides a comparative chart between your ISP connection, national and world connection average.

The yellow bar is my ISP, blue bar is the city from connection, green bar is state from connection, pink bar is the country and gray bar is world average.

This chart tells how our broadband are deprecated.

If you want to compare you broadband connection too, you can use this link http://www.testesuavelocidade.com.br. Has others tools to meter you speed connection in Internet.

Who live in Brazil and access the services through .com.br can not enjoy the new interface. The imagens aren’t disposed in tabular format, now them are “unorganized”, to provide an easy visual identification and to fit in all user screen.

Click to zoom

The image is highlighted when the mouse is over, showing source and your dimensions. There is no paging. The images are loaded when user scroll the page down.

The image clicked is exibhited in your page source and hightlighted in a modal window and with contained information about it in a side bar, without frames.

Click to zoom

Check in http://www.google.com/imghp. Enjoy!

Now with Steam being supported by Macs, some games was migrated and with improvements. These improvements was replicated in copies for Windows too.

Half-Life 2 and Half-Life 2: Episode 1 are games that have been affected. The achievements, that were previously exclusive for Half-Life 2: Episode 2, are available in HL2 and HL2: Episode 1 too. Are 46 achievements in total, 33 to HL 2 and more 13 to HL 2: Episode 1.

I’m willing to finish the game again!

Multi-language support is native in Windows 7 Enterprise and Ultimate editions, but, following this tutorial you be able to alternate entire many languages in Professional and Home Premium editions.

First you’ll need of Vistalizator. This application enable to install muti-language support in all Windows 7 editions and, how it’s portable, you don’t need install it. Download it clicking here.

After, download the languages for architecture x64 (64 bits) or x86 (32 bits).

Now run the Vistalizator and click in “Add languages”.

Browse for language file that you desire and click in “Open”.

Will be show the message below, then click in OK to proceed

A new window will be open with language data and your description, then click in “Install Language”.

Wait the installation process be done.

Now, the Vistalizator will show for you the languages installed in your machine and there will be the recently installed language.

Reboot Windows and voilá.

Now you have Windows 7 Professional/Home Premium with multi-language support.

The only bad thing that I noticed was: all time that you want to change the language, you must to use the Vistalizator, because the Windows 7 Professional and Home Premium doesn’t support this feature natively.

After checked Windows settings, process and services, I noticed that the problem was in service “Windows Media Player Network Sharing Service”, forcing me to stop it before remove the device.

But still, this solution not is right, then I found the most right:

The service “Windows Media Player Network Sharing Service” is responsible to share your media files (musics and videos) in your network or in the internet (like your name sounded. ). This is default setting in Windows 7, to disable it…

Click in Start menu, type “Network and sharing center” and select the application. Like show in the image

Click “Choose homegroup and sharing options”

Clique na opção “Escolher opções de grupo doméstico e de compartilhamento”

Now click on “Choose media streaming options…”

Change option of item “Media programs on this PC and remote conections…” to “Blocked”.

Finish! From now you can remove your external hard drive or other removable storage devices without problems.

1. You will need of a dll called wmpband.dll, that come with Windows Vista. If you not own it, download here (556) (this ZIP contains 32 and 64 bits versions);

2. Copy the file (32 or 64 bits, depends your Windows) to Windows Media Players installation directory, in my case “C:\Program Files\Windows Media Player“;

3. Now check if “Windows Media Player Network Sharing Service“ service is stopped. To do this, click in Start and, in the search box, type “Services” and click in the respective list item. Look for service and stop it, if running.

4. Open the Command Prompt with administrator privileges. Star > All Programs > Accessories > right click in “Command Prompt” and click “Run as Administrator”.

5. Type command regsvr32 “C:\Program Files\Windows Media Player\wmpband.dll“, replace the path of the directory where the dll is.

6. Open Windows Media Player and minimize it. Then right click in the taskbar > Toolbars > select Windows Media Player.

6. Abra o Windows Media Player e então o minimize-o. Depois clique com o botão direito na barra de tarefas > Barra de Ferramentas > Windows Media Player.

7. And voilá.

Microsoft should have kept this feature natively, I know people who use this resource, I inclusive.

After some tries I found two solutions to solve my access problem: first was pass as Java parameters the proxy’s configurations.

$ java -Dhttp.proxyHost=serv -Dhttp.proxyPort=port -Dhttp.proxyUser=user -Dhttp.proxyPassword=pass  ClassJava

-Dhttp.proxyHost = IP or host name of server proxy
-Dhttp.proxyPort = Proxy port
-Dhttp.proxyUser = User
-Dhttp.proxyPassword = Password

This way the class ClassJava will have access to internet through proxy server.

Another way, was insert the settings in own class:

public static void main(String[] args){
...
System.getProperties().put("proxySet", "true");
System.getProperties().put("http.proxyHost", "serv");
System.getProperties().put("http.proxyPort", "port");
System.getProperties().put("http.proxyUser", "user");
System.getProperties().put("http.proxyPassword", "password");
...
}

proxySet = Connect, or not, through proxy server
http.proxyHost = IP or host name of server proxy
http.proxyPortt = Proxy port
http.proxyUse = User
http.proxyPassword = Password

Using this resource you can set your application to access the internet through proxy server.

I hope help you.  Bye!

To resolve this: Close Amarok, delete the file ~/.kde/share/apps/amarok/current.xspf and then restart Amarok.

Least worked to me and I hope that works for you too!

Until next!!

Building a transparent window

To make a Window (JFrame, JDialog …) with alpha effect, you should invoke the method AWTUtilities.setWindowOpacity. This method parameters are: the window to apply transparency and transparency degree, that can be between 0 (zero) and 1, being 0 invisible and 1 totally visible.

JFrame  window = new JFrame("My Window");

//70% of transparency
AWTUtilities.setWindowOpacity(window, .7f);
window.setSize(800,600);
window.setVisible(true);

The result will be:

Changing window shape

To change the window shape you should use the method AWTUtilities.setWindowShape. This method parameters are: window that will be changed and the new shape (java.awt.Shape) of the window.

The most efficiently form to use is to implement the method componentResized(), cause you may recompute the window and components size

Here I’ll use a triangle with 70% of transparency.

final JFrame  window = new JFrame("My Window");

try {
	//Add the ComponentListener to implement componentResized method
	window.addComponentListener(new ComponentAdapter(){
		@Override
		//building componentResized
		public void componentResized(ComponentEvent e) {
			int[] x = {0,400,800}; //Pontos X do polígono
			int[] y = {600,0,600}; //Pontos Y do polígono

			//Triangle with 800 w x 600 h
			Shape shape = new Polygon(x, y, 3);

			AWTUtilities.setWindowShape(window, shape);

			//70% of transparency
			AWTUtilities.setWindowOpacity(window, 0.7f);
		}
	});
} catch (SecurityException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
} catch (IllegalArgumentException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
}

window.setUndecorated(true); //removing title bar
window.setSize(800,600);
window.setVisible(true);

Notice that the method setUndecorated( ) was invoked with true as value. This method are responsible by hide the title bar (one with icon and the maximize, minimize and close buttons). This is really necessary, because with title bar visible the window are not be shaped.

The result:

I hope you enjoy…

PreparedStatemente.setBinaryStream(int index, Inputstream is, int length);

In sample, we set a table called FILEthat contains BLOB column called BIN.

//Normal connection, as any JDBC connection
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@<IP>:<PORT>:<SID>","<USER>","<PASSWORD>");

//Reading the file and retrieving an InputStream
File file= new File("<COMPLETE_FILE_PATH>");
FileInputStream fis = new FileInputStream(file);

//Preparing statement
PreparedStatement ps = conn.prepareStatement("INSERT INTO FILE(bin) VALUES(?)");

//Passing InputStream and file length
ps.setBinaryStream(1, fis, (int)file.length());

ps.execute();

ps.close();
conn.close();

I used Oracle 8i to execute this sample. I haven’t a MySQL/PostgreSQL/MS SQL Server in my dispose, then you’ll responsible for testing in this data bases and send me the results, OK

Thanks! Until next time!

To retrieve the cursor you should declare him how a REF CURSOR in Package spec.

  --Creating the REF CURSOR type
  type g_cursor is ref cursor;

In both, spec and body, you need declare an out REF CURSOR variable in procedure signature, how cited above.

  procedure PRO_RETURN_CARS(
    i_id     in     tbl_car.car_id%type,
    o_cursor in out g_cursor);

The cursor must be opened in procedure’s body to return, this way:

open o_cursor for
          select car_id, company, model, color, hp, price
          from tbl_car
          where car_id = i_id;

The complete Package:

create or replace package PAC_CURSOR is
  --Creating REF CURSOR type
  type g_cursor is ref cursor;

  --Procedure that return the cursor
  procedure PRO_RETURN_CARS(
    i_id     in     tbl_car.car_id%type,
    o_cursor in out g_cursor); -- Our cursor

end PAC_CURSOR;
/

create or replace package body PAC_CURSOR is
  procedure PRO_RETURN_CARS(
    i_id     in     tbl_car.car_id%type,
    o_cursor in out g_cursor) is

       begin
        --Opening the cursor to return matched rows
        open o_cursor for
          select car_id, company, model, color, hp, price
          from tbl_car
          where car_id = i_id;

  end PRO_RETURN_CARS;

end PAC_CURSOR;

We have Oracle side ready, now we need create Java call

How the cursors are being returned by a procedure, we’ll used a java.sql.CallableStatement instance.

CallableStatement cs = conn.prepareCall("{call PAC_CURSOR.PRO_RETURN_CARS(?,?)}");

The registerOutParameter will obtain oracle.jdbc.OracleTypes.CURSOR type and return a java.sql.ResultSet instance. We can iterate the ResultSet like a common Iterator.
Each row column returned by SELECT will be represented how a map, using correspondent getter. For example, we will call getString(<column name>) method when value of column is a varchar, getDate(<column name>) when is a date and etc.

The complete code will be like this:

//Calling Oracle procedure
CallableStatement cs = conn.prepareCall("{call PAC_CURSOR.PRO_RETURN_CARS(?,?)}");

//Defining type of return
cs.registerOutParameter("o_cursor", OracleTypes.CURSOR);
cs.setLong("i_id", id);

cs.execute();//Running the call

//Retrieving the cursor as ResultSet
ResultSet rs = (ResultSet)cs.getObject("o_cursor");

//Iterating the returned rows
while(rs.next()){
	//Getting column values
	System.out.println("ID: " + rs.getLong("car_id"));
	System.out.println("Manufacturer: " + rs.getString("company"));
	System.out.println("Model: " + rs.getString("model"));
	System.out.println("Color: " + rs.getString("color"));
	System.out.println("HP: " + rs.getString("hp"));
	System.out.println("Price: " + rs.getFloat("price"));
}

In the end you will get any value returned in a SELECT clause.

See ya!

To enable them, open Control Panel > Programs and Features > click Turn Windows features on or off in left side > enable Client Telnet  and  Client TFTP then click in OK.

I not tested in Windows Vista yet, but the process can be same.

See you soon!

Looking in internet for an alternative Win32 to command tail, I found UnixUtils. A compilation for Windows of most used commands in Linux/Unix.

You can download the ZIP file in SourceForge clicking here.

Bye!

I’ve been there too, then I found a easy and with many resources solution: JSmooth

This software allow you “transform” your JAR file in an executable (EXE), but, of course, will need the JVM already installed and running.

Here I only have mentioned the settings that I consider important, then let’s go!

After install (or unzip, this depends of file that you have downloaded) run him;

In the side menu, click in “Skeleton”;

In the “Skeleton Selection” screen you need define how application will be run, select “Window Wrapper”.

In “Skeleton Properties”, you need define a message when user have no JVM installed (“Message” field) and where can be downloaded (“URL” field).

The “Launch java app in the exe process” field define if JAR file will be executed in same process of EXE (only the executable process will be displayed in Windows Task Manager), otherwise the javaw.exe will be displayed too.

The “Single Instance” field define if more than one instance can be opened.

“Debug Console” open the EXE from prompt window, displaying possibles outputs.

Now click in “Executable”

In “Executable Setting” you inform where EXE will be builded (“Executable Binary” field), the EXE’s icon (“Executable Icon” filed) and what will be the application execution directory.

Click in “Application”

First, click in the icon and select JAR that contains the main class.

After, select the main class in the field “Main Class” clicking in button .

In the field “Application arguments” you can inform necessaries parameters for your main class.

“Embedded JAR” field allows you to aggregate your JAR file in EXE file, in other words, only EXE file will be necessarie, because the JAR will be uncompressed by EXE in each execution.

Now click in “JVM Selection”.

Here you can define the minimum and maximum version of JVM that your application support.

The “JVM Serach Sequence” inform the seek order of javaw.exe file, in this case, he search in resgistry first, after in JAVA_HOME enviroment and so.

Click in “JVM Configuration”.

Here the maximum and minimum memory available for your application can be configured, as the options that can passed to JVM.

Until here we only have configured the JSmooth. To build the EXE file click in button . If you don’t have saved the project, a new window will open to choose the place to save. Done it, the EXE file will be create in directory mentioned in “Executable Binary” field of “Executable” screen.

Now just execute the EXE file and your application will be run!

To more information visit http://jsmooth.sourceforge.net/

I hope you enjoyed, feel free to comment!

Until next!

For this tutorial, we’ll need create the table TBL_CLASS and add your primary key as foreign key in TBL_USER table.

--num class is PK and desc_class description
create table TBL_CLASS (num_class number, desc_class varchar(100));
alter table TBL_CLASS add primary key(num_class);

alter table TBL_USER add num_class number;
alter table TBL_USER add constraint FK_CLASS foreign key(num_class) references tbl_class(num_class);

Now we need to include the new types:

create or replace type class_type as object (num_class number, desc_class varchar2(100), users arr_users);
/
create or replace type arr_class as table of class_type;
/

The class_type type will be the Java Object. Notice that in your signature was included the arr_users type, that will be our collection of user_type (read previous post for more information), the arr_class type will be the class_type collection.

Now we’ll include the procedure that returns our class_type collection.

procedure pro_select_class(clas in class_type, class_return in out arr_class)is
  class_ref_cur ref_cur;
  --class_type array
  classes arr_class := arr_class();

  begin
    open class_ref_cur for
      select cast(
                multiset(
                  select num_class,
                         desc_class,
                         (select cast(
                                  multiset(
                                    select user_name,
                                           height,
                                           b_date
                                    from tbl_user
                                    --JOIN with TBL_USER
                                    where tbl_user.num_class = tbl_class.num_class
                                  ) as arr_users)
                          from dual) users
                  from tbl_class
                  --Using num_class attribute of in parameter
                  where num_class = clas.num_class) as arr_class
      ) classes
    from dual;

    --including the return in array
    fetch class_ref_cur into classes;
    --transferring arrar to variable out
    class_return := classes;
end pro_select_class;

Notice that procedure receive class_type as parameter in and returns arr_class type.

Separating code charge back and set up our objects, we have:

--Mount return
select cast(
        multiset(

          --Will returns the objects class_type and your attributes
          select num_class,
                 desc_class,

                 --Populate user_type collection
                 (select cast(
                          multiset(
                            select user_name,
                                   height,
                                   b_date
                            from tbl_user
                            where tbl_user.num_class = tbl_class.num_class
                          ) as arr_users)

                  from dual) users

          from tbl_class
          where num_class = clas.num_class) as arr_class
) classes
from dual;

Oracle objects done, now the Java code!

We’ll create the object that will be interpreted by the Oracle. Called TypeClass:

public class TypeClass implements SQLData{
	public static final String ORACLE_OBJECT_NAME = "CLASS_TYPE"; //Type name in Oracle
	public static final String ORACLE_CLASS_ARRAY_NAME = "ARR_CLASS"; //Array name in Oracle

        //Attibutes of TBL_CLASS table
	private Long number;
	private String desc;
	private Array users; //This will be user_type collection (or TypeUser in Java)

	public String getSQLTypeName() throws SQLException {
		return ORACLE_OBJECT_NAME;
	}

	public void readSQL(SQLInput stream, String typeName) throws SQLException {
		setNumber(stream.readLong());
		setDesc(stream.readString());
		setUsers(stream.readArray());//Used by JDBC driver to read the collection
	}

	public void writeSQL(SQLOutput stream) throws SQLException {
		stream.writeLong(getNumber());
		stream.writeString(getDesc());
		stream.writeArray(getUsers());//Used by JDBC driver to write the collection
	}
	//Getters and setters omitted
}

We need to map types interpreted in request, this way:

Map> typeMaps = connection.getTypeMap();
typeMaps.put(TypeUser.ORACLE_OBJECT_NAME, TypeUser.class);
typeMaps.put(TypeClass.ORACLE_OBJECT_NAME, TypeClass.class);

We need to map the arrays too:

typeMaps.put(TypeClass.ORACLE_CLASS_ARRAY_NAME, TypeClass[].class);//returned by procedure
typeMaps.put(TypeUser.ORACLE_USER_ARRAY_NAME, TypeUser[].class);//returned by class_type collection

For request, we do:

cs = conn.prepareCall("{call PAC_BEAN.PRO_SELECT_CLASS(?,?)}");
//registering out type, that will be a TypeClass array
cs.registerOutParameter("class_return", OracleTypes.ARRAY, TypeClass.ORACLE_CLASS_ARRAY_NAME);

//passing parameter object
cs.setObject("clas", classQry);

cs.execute();
//retrieving and looping the TypeClass array
Object[] array = (Object[])cs.getArray("class_return").getArray();

for(Object obj : array){
	TypeClass objClass = ((TypeClass)obj);

	System.out.println("Description: "+objClass.getDesc());

        //Here we obtains user_type(TypeUser) array returned by query.
	Object[] userArray = (Object[])objClass.getUsers().getArray();
	for(Object user : userArray){
		System.out.println("\tName: " + ((TypeUser)user).getName());
		System.out.println("\tHeight: " + ((TypeUser)user).getHeight());
		System.out.println("\tBirth: " + sdf.format(((TypeUser)user).getBirth())+ "\r\n");
	}
}

In the end you’ll have a java.sql.Array of TypeUser in getUsers() attribute of TypeClass.

Here I fulfilled my promise. Download the source code of this sample (with previous post sample too) here.

Until next time!

I thinking about the complexity of a class that takes screen shots and store the files in hard disk and, asking to “uncle G”, I fonded the class Robot, that provide createScreenCapture method.

Now I’ll show how to implement this functionality:

Robot robot = new Robot();
//Setting the rectangle that mark capture area. In this case, will be all screen..
Rectangle rect = new Rectangle(Toolkit.getDefaultToolkit().getScreenSize());

BufferedImage img = robot.createScreenCapture(rect);

Here we defined capture area and obtained a BufferedImage, our image. Now, we needed to persist in hard disk.

//Capturing the ImageWriter and ImageWriterParam
ImageWriter writer = ImageIO.getImageWritersByFormatName("jpeg").next();
ImageWriteParam iwp = writer.getDefaultWriteParam();

//Setting compression mode and the image quality
iwp.setCompressionMode(ImageWriteParam.MODE_EXPLICIT);
iwp.setCompressionQuality(1);

//Persisting the image
writer.setOutput(new FileImageOutputStream(arquivo));

IIOImage iioimage = new IIOImage(img, null, null);

writer.write(null, iioimage, iwp);
writer.dispose();

We captured the ImageWriter and ImageWriterParam to set the compression method and the image quality.

In line 07 we defined the image quality as 1, where the value can be between 0 (zero), more compression and less quality and 1 (one), less compression and more quality. Then we have kept the file in HD.

We’ve done! Simple, isn’t?

Download this sample here.

See ya!

public class MaxLengthTextDocument extends PlainDocument {
	//Store maximum characters permitted
	private int maxChars;

	@Override
	public void insertString(int offs, String str, AttributeSet a)
			throws BadLocationException {
		if(str != null && (getLength() + str.length() < maxChars)){
			super.insertString(offs, str, a);
		}
	}

	//getter e setter omitted
}

Here we defined one class called MaxLengthTextDocument that extends PlainDocument. In insertString attribute, we checked if quantity of characters minor than maxChars attribute, inserting in String if true.

After this, only insert our implementation in JTextField, this way:

	...
	MaxLengthTextDocument maxLength = new MaxLengthTextDocument();
	maxLength.setMaxChars(50);//50 is a maximum number of character 

	jTextField.setDocument(maxLength);
	...

And voilà!

See ya!

...
JLabel jLabel = new JLabel("My JLabel");
//Border used as padding
Border paddingBorder = BorderFactory.createEmptyBorder(10,10,10,10);

jLabel.setBorder(BorderFactory.createCompoundBorder(border,paddingBorder));
...

Here, the JLabel contains a padding with 10 pixels in top, right, bottom and left, respectively.

If you want to put border around the JLabel, you can use a CompoundBorder, setting Border and EmptyBorder (padding):

...
JLabel jLabel = new JLabel("Meu JLabel");
//Border used as padding
Border paddingBorder = BorderFactory.createEmptyBorder(10,10,10,10);
//JLabel will be involved for this border
Border border = BorderFactory.createLineBorder(Color.BLUE);

jLabel.setBorder(BorderFactory.createCompoundBorder(border,paddingBorder));
...

Download the source code of this sample here.

Setting iBatis

Unlike another frameworks, to configure iBatis you need only one XML file, called SqlMapConfig.

The mains sections of XML are:

<properties resource="tuto/ibatis/config/SqlMap.properties"/>

This code is optional and specifies the .properties file that’ll be used to declare variables used in configuration.

<typeAlias alias="car" type="tuto.ibatis.beans.Car"/>

Defines the JavaBean used and your alias. You can set much lines, depending of modeling complexity.
In example, we’ll Car bean below:

public class Car {
	private Long carId;
	private String company;
	private String model;
	private String color;
	private Integer	hp;
	private Float price;

	//Setters and getters omitted
}

<transactionManager type="JDBC">
    <dataSource type="SIMPLE">
        <property name="JDBC.Driver" value="${driver}"/>
        <property name="JDBC.ConnectionURL" value="${url}"/>
        <property name="JDBC.Username" value="${username}"/>
        <property name="JDBC.Password" value="${password}"/>
    </dataSource>
</transactionManager>

Parameters used in database connection. The variables ${driver}, ${url}, ${username} and ${password} are defined in .properties file in section properties. If you prefer, can put the values directly in fields.

See the complete file:

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
        "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

<sqlMapConfig>
    <properties resource="tuto/ibatis/config/SqlMap.properties"/>

    <settings
        cacheModelsEnabled="true"
        enhancementEnabled="true"
        lazyLoadingEnabled="true"
        maxRequests="32"
        maxSessions="10"
        maxTransactions="5"
        useStatementNamespaces="false" />

    <typeAlias alias="car" type="tuto.ibatis.beans.Car"/>

    <transactionManager type="JDBC">
        <dataSource type="SIMPLE">
            <property name="JDBC.Driver" value="${driver}"/>
            <property name="JDBC.ConnectionURL" value="${url}"/>
            <property name="JDBC.Username" value="${username}"/>
            <property name="JDBC.Password" value="${password}"/>
        </dataSource>
    </transactionManager>

    <sqlMap resource="tuto/ibatis/sqlmaps/CarSqlMap.xml"/>
</sqlMapConfig>

The properties have this content:

driver=oracle.jdbc.OracleDriver
url=jdbc:oracle:thin:@<host>:<porta>:<sid>
username=<login>
password=<senha>

Next you need to configure the SqlMap. This XML contains the querys used in application and your name need be equals described in sqlMap section of SqlMapConfig, in our case will be CarSqlMap.xml

In example only we will see utilization of tags select, insert, update and delete.

<select id="getCars" resultClass="tuto.ibatis.beans.Car"
	parameterClass="java.lang.Long">
    SELECT COMPANY  as company,
           MODEL    as model,
           COLOR    as color,
           HP       as hp,
           PRICE    as price
    FROM TBL_CAR
    WHERE CAR_ID = #var#
</select>

Execute the select statement can return a single object or one collection of objects, the type is same of resultClass attribute, o parameterClass is the type sent to execute the query and the id is the query identification call.

We will use the SqlMap below:

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
	"http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap namespace="Car">
    <select id="getCars" resultClass="tuto.ibatis.beans.Car"
    parameterClass="java.lang.Long">
        SELECT COMPANY  as company,
               MODEL    as model,
               COLOR    as color,
               HP       as hp,
               PRICE    as price
        FROM TBL_CAR
        WHERE CAR_ID = #var#
    </select>

    <insert id="addCar" parameterClass="tuto.ibatis.beans.Car">
        INSERT INTO TBL_CAR (CAR_ID, COMPANY, MODEL, COLOR, HP, PRICE)
        VALUES (#carId#, #company#, #model#, #color#, #hp#, #price#)
    </insert>

    <delete id="delCar" parameterClass="java.lang.Long">
        DELETE FROM TBL_CAR WHERE CAR_ID = #var#
    </delete>

    <update id="updCar" parameterClass="tuto.ibatis.beans.Car">
        UPDATE TBL_CAR
          SET COMPANY = #company#,
              MODEL = #model#,
              COLOR = #color#,
              HP = #hp#,
              PRICE = #price#
        WHERE CAR_ID = #carId#
    </update>
</sqlMap>

Data base connection configured, now we will implements the singleton class the will used as SqlMapClient, called OracleMapConfig.

package tuto.ibatis.connection;

import java.io.Reader;

import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;

public class OracleMapConfig {
	private static final SqlMapClient sqlMapClient;

	static{
		try{
			//Defining path of SqlMapConfig and creating reader
			String res = "tuto/ibatis/config/SqlMapConfig.xml";
			Reader reader = Resources.getResourceAsReader(res);

			//Retrieving the client to SqlMap
			sqlMapClient = SqlMapClientBuilder.buildSqlMapClient(reader);
		} catch(Exception e){
			e.printStackTrace();
			throw new RuntimeException(e);
		}
	}

	//Method used to retrieve the client
	public static SqlMapClient getSqlMapClient(){
		return sqlMapClient;
	}
}

The client is responsible for execute the querys configured in SqlMap and return the results.

Executing Querys and treating the return

To call any query is too simple, only execute the correspondent method of client class.

The select can be called this way:

OracleMapConfig.getSqlMapClient().queryForObject("<id>", <parâmetro>);

Theid need be equals of id specified in SqlMap

Only one line is return in code above, to get all lines change to queryForList, this way:

OracleMapConfig.getSqlMapClient().queryForList("<id>", <parâmetro>);

Will be returned a Collection containing the objects;

Select

try{
	Car car = (Car)OracleMapConfig.getSqlMapClient().queryForObject("getCars",
		new Long(readKeyboard()));

	System.out.println("Company: "+car.getCompany());
	System.out.println("Model: "+car.getModel());
	System.out.println("Color: "+car.getColor());
	System.out.println("HP: "+car.getHp());
	System.out.println("Price: "+car.getPrice());
}catch (Exception e) {
	e.printStackTrace();
}

The id “getCars” are defined in select attributes of SqlMap, providing one Long type and retrieving a Car type, both defined in line <select id=”getCars” resultClass=”tuto.ibatis.beans.Car” parameterClass=”java.lang.Long“>.

Insert

try{
	OracleMapConfig.getSqlMapClient().insert("addCar", newCar);
}catch (Exception e) {
	e.printStackTrace();
}

Now we will provide as parameter a Car type, <insert id=”addCar” parameterClass=”tuto.ibatis.beans.Car“>, and call the methods using sharp (#), this way:

INSERT INTO TBL_CAR (CAR_ID, COMPANY, MODEL, COLOR, HP, PRICE)
VALUES (#carId#, #company#, #model#, #color#, #hp#, #price#)

Delete

try{
	int lines = OracleMapConfig.getSqlMapClient().delete("delCar",
		new Long(readKeyboard()));

	System.out.println(lines + " lines deleted");
}catch (Exception e) {
	e.printStackTrace();
}

The method delete of client return a type int, this represents the number of rows deleted.

Update

try{
	int lines = OracleMapConfig.getSqlMapClient().update("updCar", car);

	System.out.println(lines + " cars updated");
}catch (Exception e) {
	e.printStackTrace();
}

Update return a type int, this represents the number of rows affected by update.

How you see, with only three XML and three classes we built a simple storage management and price consulting system.

You can download the source code of this tutorial clicking here.

Until next post!

See ya!

This tutorial only work with Oracle9i , or above, and using the JDBC driver ojdbc14g, or above.

First, we create the tables, objects and procedures. Remember: the types tbl_users and user_type must be declared out of packages, as global types:

-- Creating table
create table tbl_user(user_name varchar2(100), height number, b_date date);
/
--Creating type user_type (own bean)
create or replace type user_type as object (user_name varchar2(100), height number, birth_date date);
/
--Creating type arr_users, table of user_type (array of user_type)
create or replace type arr_users as table of user_type;
/

Creating specification and body of package.

--Spec
create or replace package PAC_BEAN is
  type ref_cur is ref cursor;

  -- Procedure used to insert values
  procedure pro_insert_user(usu in user_type);

  -- Procedure used to select
  procedure pro_select_user(usu in user_type, user_return in out arr_users);
end PAC_BEAN;
/

--Body
create or replace package body PAC_BEAN is
  --The insert procedure will receive user_type and put him into table tbl_user.
  procedure pro_insert_user(usu in user_type) is
    begin
      insert into tbl_user (user_name, height, b_date)
      values (usu.user_name, usu.height, usu.birth_date);

      commit;
    exception
      when others then
        rollback;
  end pro_insert_user;

  --The procedure used for select will receive a user_type (where clause) and will return the array arr_users
  procedure pro_select_user(usu in user_type, user_return in out arr_users)is
    user_ref_cur ref_cur;

    --Instancing the array
    users arr_users := arr_users();

    begin
      --Opening the cursor that will return the array
      open user_ref_cur for
        select cast(
                 multiset(
                   select user_name,
                          height,
                          b_date
                   from tbl_user
                   where user_name like '%'||usu.user_name||'%'
                 ) as arr_users
              ) arr
        from dual;

      --Putting the cursor into arr_users instance.
      fetch user_ref_cur into users;

      --Returning the instance through OUT variable
      user_return := users;
  end pro_select_user;
end PAC_BEAN;
/

See CAST and MULTISET about how they work.

Built database objects, we need prepare the JavaBean. It’ll an implementation of java.sql.SQLData, because it will be necessary to implement the methods:

getSQLTypeName() – Getter used to obtain the name of type.

readSQL(SQLInput, String) – Used to convert an object in Java object.

writeSQL(SQLOutput stream) – Used to mount a SQL object, used byJDBC Driver.

public class TypeUser implements SQLData{
	//Name declared in Oracle
	public static final String ORACLE_OBJECT_NAME = "USER_TYPE";
	//Array name declared in Oracle
	public static final String ORACLE_USER_ARRAY_NAME = "ARR_USERS";

	//The attributes
	private String name;
	private Float height;
	private Date birth;

	public TypeUser() {
		height = 0F;
	}

	public String getSQLTypeName() throws SQLException {
		return ORACLE_OBJECT_NAME;
	}

	public void readSQL(SQLInput stream, String typeName) throws SQLException {
		setName(stream.readString());
		setHeight(stream.readFloat());
		setBirth(stream.readDate());
	}

	public void writeSQL(SQLOutput stream) throws SQLException {
		stream.writeString(getName());
		stream.writeFloat(getHeight());
		stream.writeDate(getBirth() != null ?
				new java.sql.Date(getBirth().getTime()) : null);
	}

        //getters and setters omitted
}

To define a type that can will be send to procedure be necessary add him  into type map through Connection.getTypeMap(). This method return the Map<String,Class<?>>, where type name is the key and class of SQLData implementation is the value, in own case the type TypeUser. Sample:

Map<String,Class<?>> typeMaps = connection.getTypeMap();
typeMaps.put(TypeUser.ORACLE_OBJECT_NAME, TypeUser.class);

Then the connection will be:

//Making connection
Class.forName("oracle.jdbc.driver.OracleDriver");
connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:<host>:<port>:<db>","<user>","<pass>");

//Mapping necessary tipes
Map<String,Class<?>> typeMaps = connection.getTypeMap();
typeMaps.put(TypeUser.ORACLE_OBJECT_NAME, TypeUser.class);

Now, we create the insert method, it receive an instance of TypeUser and Connection:

CallableStatement cs = null;
try {
	//call the procedure
	cs = conn.prepareCall("{call PAC_BEAN.PRO_INSERT_USER(?)}");

	//defining the instance of TypeUser as variable IN "usu"
	cs.setObject("usu", typeUser);

	cs.execute();
} catch (SQLException e) {
	e.printStackTrace();
}

Now, the select method. This method return a object array, then be necessary insert the type of array in Connection TypeMap. The name passed as key should be equals of Oracle’s array name and the values will be the array class, like this:

connection.getTypeMap().put(TypeUser.ORACLE_USER_ARRAY_NAME, TypeUser[].class);

To call procedure and registerOutParameter:

cs = conn.prepareCall("{call PAC_BEAN.PRO_SELECT_USER(?,?)}");
cs.registerOutParameter("user_return", OracleTypes.ARRAY, TypeUser.ORACLE_USER_ARRAY_NAME);
cs.setObject("usu", typeUserQry);

cs.execute();

To obtain the array, do it:

//user_return is the OUT variable name
Object[] array = (Object[])cs.getArray("user_return").getArray();

If until here is alright, smile, to obtain array values just iterate him and cast each index to Type User.

for(Object obj : array){
	System.out.println("Nome: " + ((TypeUser)obj).getName());
	System.out.println("Altura: " + ((TypeUser)obj).getHeight());
	System.out.println("Data de Nascimento: " + sdf.format(((TypeUser)obj).getBirth()));
}

So we can pass and retrieve simple Java objects of a Oracle procedure or function. The next step, Retrieving objects collection from Oracle procedure.

See ya!

Download the source code of this tutorial here.

<host>:<porta>:<bd>","<usuario>","<senha>"

The solution founded to solve this problem was:

In the Programs Files\VoiceAge folder you’il see many files, between them, four specifics dlls called SPOTCorePlayer_51.dll, SPOTxdePlayerDLL.dll, VaAce.dll and VaMp_50.dll.

Copy this files to SonyEricsson\JavaME_SDK_CLDC\PC_Emulation\WTK2\bin folder.

Try to start the emulator again.

ArrayList
The ArrayList Collection allow to store objects and null values, but your access is unordered, the first object inserted, can be a last to retrieve.

LinkedList
This implementation of Collection is like ArrayList, but the difference is in access to objects stored, where each object is returned in your inserted order.

TreeSet
If you want retrieve the objects of your Collection in specified order, this Collection can do the work! Insert values in TreeSet is equal previously classes, but your return depends of Comparable implemented in values. It sort your object values using result of compareTo method, inherited of Comparable Interface.

For more information, visits Collection Javadoc.

Now I’ll show how to disable this key in Windows Vista.

Go to Control Panel, double click in Power Options:

Then click in “Choose what the power buttons do”:

Next and last step, in “When I press the sleep button” choose “Do nothing”, save and apply!

After this tutorial you can press this key in any time.

Thanks for Roberto Furutani!

Enjoy!

To obtain the hard drives or removable devices, use File.listRoots(). This code return a File array, where each index of array is a removable device or hard disk unit.

Follow this sample:

File[] units = File.listRoots();

for(File unit : units){
    System.out.println(unit.getAbsolutePath());
}

The code below will show you how to get any information of MP3 file:

try {
    MP3File mp3 = new MP3File("D:\\Musics\\MP3\\ACDC\\ACDC - Back In Black.mp3");
    System.out.println("Album:" + mp3.getID3v2Tag().getAlbumTitle());
    System.out.println("Band:" + mp3.getID3v2Tag().getLeadArtist());
    System.out.println("Composer:" + mp3.getID3v2Tag().getAuthorComposer());
    System.out.println("Year:" + mp3.getID3v2Tag().getYearReleased());
} catch (Exception e) {
	e.printStackTrace();
}

The result:

Album: Back in Black
Band: AC/DC
Composer: Angus Young/Brian Johnson/Malcolm Young
Year:

To change any information of any ID3 tags, try the code bellow:

mp3.getID3v2Tag().setYearReleased("1980");
mp3.save();

This library has many methods that help you to customize any MP3 file.