SqlContainer and Oracle

Hi !,

I am trying to develop a web based accounting system.
I have successfully setup the database connection with mysql and it show the content of tables.
But when I try with oracle it the connection get established but shows an empty table.
Why I cannot see the contents of my tables with ORACLE. It is driving me mad.

System.

I have added the ojdbc6.jar, sqlcontainer.jar, vaadin 6.7.jar
I use netbeans 7.1.1 with vaadin 6.1 plugin
ORacle 10g database.

Here is my code



/*
 * Fetch.java
 *
 * Created on March 17, 2012, 7:04 PM
 */
 
package com.example.vaadin;           

import com.vaadin.Application;
import com.vaadin.addon.sqlcontainer.SQLContainer;
import com.vaadin.addon.sqlcontainer.connection.SimpleJDBCConnectionPool;
import com.vaadin.addon.sqlcontainer.query.FreeformQuery;
import com.vaadin.data.Container;
import com.vaadin.ui.*;
import com.vaadin.ui.themes.Runo;
import java.sql.SQLException;
public class Fetch extends Application {
    private SimpleJDBCConnectionPool connectionPool;
    private SQLContainer productContainer;
    private TextField nameFilterField;
    private Button refreshButton;
    private Button editButton;
    private Button saveButton;
    private Button cancelButton;
    private Button addItemButton;
    private Button removeItemButton;
     Table table = new Table();

    @Override
    public void init() {
        setTheme("runo");
	 Window mainWindow = new Window("Complex query demo");
	        mainWindow.getContent().setSizeFull();
                VerticalLayout mainLayout = new VerticalLayout();
        mainLayout.setMargin(true);
        mainLayout.setSpacing(true);
        mainWindow.setContent(mainLayout);
        
        Panel filterPanel = new Panel();
        filterPanel.addStyleName(Runo.PANEL_LIGHT);
        HorizontalLayout filterLayout = new HorizontalLayout();
        filterLayout.setMargin(false);
        filterLayout.setSpacing(true);
        filterPanel.setContent(filterLayout);
        mainWindow.addComponent(filterPanel);

        Panel buttonPanel = new Panel();
        buttonPanel.addStyleName(Runo.PANEL_LIGHT);
        HorizontalLayout buttonLayout = new HorizontalLayout();
        buttonLayout.setMargin(false);
        buttonLayout.setSpacing(true);
        buttonPanel.setContent(buttonLayout);
        mainWindow.addComponent(buttonPanel);

        Panel buttonPanel2 = new Panel();
        buttonPanel2.addStyleName(Runo.PANEL_LIGHT);
        HorizontalLayout buttonLayout2 = new HorizontalLayout();
        buttonLayout2.setMargin(false);
        buttonLayout2.setSpacing(true);
        buttonPanel2.setContent(buttonLayout2);
        mainWindow.addComponent(buttonPanel2);

        nameFilterField = new TextField("Name");
        filterPanel.addComponent(nameFilterField);
        
        refreshButton = new Button("Refresh");
        //refreshButton.addListener(this);
        buttonPanel.addComponent(refreshButton);

        editButton = new Button("Edit");
        //editButton.addListener(this);
        buttonPanel.addComponent(editButton);

        saveButton = new Button("Save");
        //saveButton.addListener(this);
        saveButton.setEnabled(false);
        buttonPanel2.addComponent(saveButton);

        cancelButton = new Button("Cancel");
       // cancelButton.addListener(this);
        cancelButton.setEnabled(false);
        buttonPanel2.addComponent(cancelButton);

        addItemButton = new Button("Add Row");
        //addItemButton.addListener(this);
        addItemButton.setEnabled(false);
        buttonPanel2.addComponent(addItemButton);

        removeItemButton = new Button("Remove Row");
        //removeItemButton.addListener(this);
        removeItemButton.setEnabled(false);
        buttonPanel2.addComponent(removeItemButton);
	        try {
	            mainWindow.addComponent(buildTableWithContainer());
	        } catch (SQLException e) {
	            // TODO Auto-generated catch block
	            e.printStackTrace();
	        }
                mainWindow.addComponent(buttonPanel2);
	        setMainWindow(mainWindow);
    }
    
     private Table buildTableWithContainer() throws SQLException {
	       
	        table.setContainerDataSource(buildContainer());
                table.setEditable(false);
                table.setMultiSelect(true);
                table.setMultiSelectMode(AbstractSelect.MultiSelectMode.DEFAULT);
                table.setSelectable(true);
                table.setWriteThrough(true);
	        table.setSizeFull();
	        return table;
	    }
	
	    private Container buildContainer() throws SQLException {
	        /*SimpleJDBCConnectionPool connectionPool = new SimpleJDBCConnectionPool(
	                "org.hsqldb.jdbc.JDBCDriver", "jdbc:hsqldb:mem:sqlcontainer",
	                "SA", "", 2, 5); */
	      
         //MYSQL CONNECTION OK
                /*   SimpleJDBCConnectionPool connectionPool = new
	         *  SimpleJDBCConnectionPool(
	         *  "com.mysql.jdbc.Driver", "jdbc:mysql://localhost:3306/inventory",
	         *  "root", "root", 2, 5); 
                */

      //ORACLE CONNECTION 

                SimpleJDBCConnectionPool connectionPool = new
	        SimpleJDBCConnectionPool(
	         "oracle.jdbc.OracleDriver", "jdbc:oracle:thin:@20.20.20.120:1521/sid",
	         "root", "root",2,5);
	
	        
	        SQLContainer container = new SQLContainer(new FreeformQuery("SELECT * FROM SCOTT.EMP",connectionPool));
	        return container;
	    }
            
            
             private void setEditMode(boolean editMode) {
        if (editMode) {
            table.setEditable(true);
            table.setSortDisabled(true);
            refreshButton.setEnabled(false);
            editButton.setEnabled(false);
            saveButton.setEnabled(true);
            cancelButton.setEnabled(true);
            addItemButton.setEnabled(true);
            removeItemButton.setEnabled(true);
            nameFilterField.setEnabled(false);
        } else {
            table.setEditable(false);
            table.setSortDisabled(false);
            refreshButton.setEnabled(true);
            editButton.setEnabled(true);
            saveButton.setEnabled(false);
            cancelButton.setEnabled(false);
            addItemButton.setEnabled(false);
            removeItemButton.setEnabled(false);
            nameFilterField.setEnabled(true);
        }
    }
}

thanks.