Monthly Archives: June 2010

Wayne 12:00 am on June 29, 2010
Tags:   

horizontal layout in html

<!DOCTYPE html>

<html>

<body>

<h1>My First Heading</h1>

<p>My first paragraph.</p>

Left Side Menu

 

Random Content

 

Right Side Menu

</div>

</body>

</html>
Wayne 12:00 am on June 28, 2010
Tags: Restful,   

Google RESTFUL WS services in ADF or JSF

My Notes  — for Java client to access google calendar, By W.ZH in 2010

Google RESTFUL WS API general

http://code.google.com/apis/gdata/articles/java_client_lib.html#samples

Calendar Services – Dev Guide by Google

http://code.google.com/apis/calendar/data/2.0/developers_guide_java.html

http://technology.amis.nl/blog/2747/accessing-google-calendar-from-oracle-adf-application-displaying-events-in-gantt-chart

IBM article for python access

http://www.ibm.com/developerworks/opensource/library/os-php-xpath/
Wayne 12:00 am on June 26, 2010
Tags: ,   

ORACLE SQL Usages


By W.ZH.



1. How to create a user by SQL Plus?

We suppose you do not have user in DB yet. or you can use :

drop user user_ABC cascade;

 then create spaces for new user:

create tablespace ts_user_ABC datafile ‘D:\DAPSDB\ts_user_ABC.dbf’ size 100M;

create temporary tablespace temp_user_ABC tempfile ‘D:\DAPSDB\user_ABC_temp01.dbf’ size 100M;

Create User:

create user user_ABC identified by user_ABC account unlock default tablespace ts_user_ABC temporary tablespace temp_user_ABC;

alter user user_ABC quota unlimited on ts_user_ABC;

Give user some basic permission and roles:

grant connect to user_ABC;

grant create table to user_ABC;

grant create view to user_ABC;

grant create procedure to user_ABC;

grant create sequence to user_ABC;

grant EXP_FULL_DATABASE to user_ABC;

grant IMP_FULL_DATABASE to user_ABC;


If you do these from EM console, you also need to do these steps to create a new user.

check DB connections

conn user_ABC/password;

conn sysman/password as sysdba;



2. How to export and import data for a user?


1. First, go the command console (not in SQLplus) of the DB to be backuped. backup the user DB by export a user:

exp username/userpass FIlE=abcuserdata.dmp OWNER=username


    or sth like this:

exp userid=system/manager file=c:exportsmysid.dmp log=c:exportsmysid.log full=y


      then you can copy the dmp data file to the target DB that you want to import.


2. Go to your target DB create a user  with table spaces and the roles/permission etc. then you can import user’s data from dmp file:


imp username/userpass FULL=y FIlE=abcuserdata.dmp


    or use this:

imp sysman/password  FROMUSER=username1 TOUSER=username2 FILE=abcuserdata.dmp


3. Then should be ok, you can use SQLDeveloper to get the data.

 

Wayne 12:00 am on June 26, 2010
Tags: ,   

Oracle DB Basic – Enterprise Manage database control

Oracle Enterprise Manager Database Control when you install the Oracle software. Enterprise Manager Database Control provides a Web-based interface that you can use to manage your Oracle instance and database.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14196/em_manage002.htm


emctl start dbconsole

emctl status dbconsole

emctl stop dbconsole

emca -repos drop

emca -repos create

emca -deconfig dbcontrol db

emca -config dbcontrol db

Normally you can access these URL to get EM control

http://<hostname&gt;:5500/em
https://<hostname&gt;:1158/em/

 

 
Wayne 12:00 am on June 10, 2010
Tags:   

How to return data from inside task flow to the parent page?

By W.ZH June 10 2010

1. You know there is method you can trig a parent action by call an activity in the taskflow. this means that a button in task flow is click, will do an action method in the parent page(its backbean).. and you can insert a data in the session etc when button is clicked and retrieve the data in the parent page’s method.. the parenet page can use this data is its page.