<context-param><param-name>javax.faces.PROJECT_STAGE</param-name><param-value>Development</param-value></context-param>
<servlet-mapping><servlet-name>Faces Servlet</servlet-name><url-pattern>*.jsf</url-pattern></servlet-mapping>
/** copyright 2010*/package cc.nuboat.easyjsf.managedbean;import javax.faces.bean.ManagedBean;/**** @author nuboat*/@ManagedBeanpublic class IndexManagedBean {private String hellostr;public IndexManagedBean() {hellostr = "Hello from Facelets";}public String getHellostr() {return hellostr;}public void setHellostr(String hellostr) {this.hellostr = hellostr;}}
<h:body>#{indexManagedBean.hellostr}</h:body>
public IndexManagedBean() {hellostr = "Hello from IndexManagedBean";}
<?xml version='1.0' encoding='UTF-8' ?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"xmlns:h="http://java.sun.com/jsf/html"><h:head><title>Hello</title></h:head><h:body>Hi Khun. #{helloManagedBean.name}.</h:body></html>
<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"><html xmlns="http://www.w3.org/1999/xhtml"xmlns:h="http://java.sun.com/jsf/html"xmlns:f ="http://java.sun.com/jsf/core"><h:head><title>Hello Form</title></h:head><h:body><h:form>What's your name? : <h:inputText value="#{helloManagedBean.name}" /> : <h:commandButton value="OK" action="#{helloManagedBean.hello}" /> <br /></h:form></h:body></html>
/** copyright 2010*/package cc.nuboat.easyjsf.managedbean;import javax.faces.bean.ManagedBean;/**** @author nuboat*/@ManagedBeanpublic class HelloManagedBean {private String name;public String hello() {return "hello";}public String getName() {return name;}public void setName(String name) {this.name = name;}}
| JVM option passed to Resin | Meaning |
| -Xms | initial java heap size |
| -Xmx | maximum java heap size |
| -Xmn | the size of the heap for the young generation |
processes = 150 memory_target = 812M control_files = "/oracle/oradata/orcl/control01.ctl" control_files = "/oracle/flash_recovery_area/orcl/control02.ctl" db_block_size = 8192 compatible = "11.2.0.0.0" db_recovery_file_dest = "/oracle/flash_recovery_area" db_recovery_file_dest_size= 3852M undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "co.th" dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)" audit_file_dest = "/oracle/admin/orcl/adump" audit_trail = "DB" db_name = "orcl" open_cursors = 300 diagnostic_dest = "/oracle"4. ทำการสร้าง PFILE ชื่อ initorcl.ora ไว้ที่ Path /oracle/db11201/dbs โดยนำ content ของ alert log ที่ copy มาใส่ลงไปในไฟล์
$ sqlplus /nolog sql> conn / as sysdba sql> startup
sql> create spfile='spfileorcl.ora'
from pfile='/oracle/db11201/dbs/initorcl.ora';
7. เราจะได้ spfile ที่ชื่อ spfileorcl.ora มานะครับSQL> startup ORACLE instance started. Total System Global Area 849530880 bytes Fixed Size 1339824 bytes Variable Size 499125840 bytes Database Buffers 343932928 bytes Redo Buffers 5132288 bytes Database mounted. Database opened. SQL>
connect hr/hr create table image_table (id number primary key, image ordsys.ordimage);2. ทำการสร้าง directory ที่เก็บรูปไว้โดย ตั้งให้ตรงกับ directory ที่เก็บรูปไว้อยู่ ด้วย user sys และทำการให้สิทธิในการอ่าน directory แก่ user hr
connect / as sysdba create or replace directory imagedir as '/home/oracle/quickstart/'; grant read on directory imagedir to hr;3. ใช้ user hr ในการสร้าง PL/SQL procedure ในการ import รูปเข้ามายัง table
create or replace procedure image_import(dest_id number, filename varchar2) is img ordsys.ordimage; ctx raw(64) := null; begin delete from image_table where id = dest_id; insert into image_table (id,image) values (dest_id, ordsys.ordimage.init()) returning image into img; img.importFrom(ctx, 'file', 'IMAGEDIR', filename); update image_table set image=img where id=dest_id; end; /! ที่ IMAGEDIR จะต้องพิมพ์เป็นตัวใหญ่ทั้งหมด แม้ในตอนที่สร้าง directory ขึ้นมาจาพิมพ์ด้วยตัวพิมพ์เล็กก็ตาม
call image_import(1,’book2.jpg’); call image_import(2,’check.png’);เสร็จแล้วรูปทั้งสองรูปจะถูกเพิ่มเข้าไปยัง table
SQL> select id,t.image.getheight(),t.image.getwidth() from image t; ID T.IMAGE.GETHEIGHT() T.IMAGE.GETWIDTH() ---------- ------------------- ------------------ 1 134 572 2 464 667
#!/bin/sh #chkconfig: 345 99 10 #description: Oracle auto start-stop script. # #Set ORA_HOME to be equivalent to the $ORACLE_HOME #from which you wish to execute dbstart and dbshut; # #Set ORA_OWNER to the user id of the owner of the #Oracle database in ORA_HOME. ORA_HOME=/oracle/db11201 ORA_OWNER=oracle if [ ! -f $ORA_HOME/bin/dbstart ] then echo "Oracle startup: cannot start" exit fi case "$1" in 'start') #Start the Oracle databases: #The following command assumes that the oracle login #will not prompt the user for any values su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start dbconsole" & su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart $ORA_HOME" touch /var/lock/subsys/dbora ;; 'stop') #Stop the Oracle databases: #The following command assumes that the oracle login #will not prompt the user for any values su - $ORA_OWNER -c "$ORA_HOME/bin/emctl stop dbconsole" & su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut $ORA_HOME" rm -f /var/lock/subsys/dbora ;; esac
#chmod 750 /etc/init.d/dbora #ln -s /etc/init.d/dbora /etc/rc.d/rc0.d/K01dbora #ln -s /etc/init.d/dbora /etc/rc.d/rc3.d/S99dbora #ln -s /etc/init.d/dbora /etc/rc.d/rc4.d/S99dbora #ln -s /etc/init.d/dbora /etc/rc.d/rc5.d/S99dbora #ln -s /etc/init.d/dbora /etc/rc.d/rc6.d/K01dbora
| 1 | rowid |
| 2 | rowid |
| 3 | rowid |
| . | . |
| . | . |
| . | . |
| Database Behavior | ABORT | IMMEDIATE | TRANSACTIONAL | NORMAL |
|---|---|---|---|---|
Permits new user connections | No | No | No | No |
Waits until current sessions end | No | No | No | Yes |
Waits until current transactions end | No | No | Yes | Yes |
Performs a checkpoint and closes open files | No | Yes | Yes | Yes |
