JSPÊý¾ÝÔ´Á¬½ÓOracle³ö´í
ÔËÐл·¾³£ºMyEclipse8.5+Oracle 11g
ÔÚWEB-INF/libÎļþ¼ÐϵÄJDBCÇý¶¯£º
ojdbc5.jar;
ojdbc5_g.jar;
ojdbc6.jar;
ojdbc6_g.jar;
ÔÚMETA-INFÎļþ¼ÐϵÄÊý¾ÝÔ´ÅäÖÃÎļþcontext.xml:
<Context reloadable="true">
<Resource name="jdbc/bookstore" auth="Container"
type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:orcl"
username="scott" password="tiger" maxActive="200" maxIdle="30"
maxWait="-1"/>
</Context>
JSPÎļþµÄÁ¬½ÓÓï¾ä£º
Context ctx=new InitialContext();
DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/bookstore");
Connection conn=ds.getConnection();
ÔÚÕâÒ»¾ä±¨´í£º
org.apache.jasper.JasperException: An exception occurred processing JSP page /index.jsp
at Connection conn=ds.getConnection();
javax.servlet.ServletException: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
ps£ºÊ¹ÓÃClass.forName()·½·¨¿ÉÒ
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÊÌâÃèÊö£º
ÀýÈçÎÒÒªÏÔʾµÄÄÚÈÝÈçÏÂËùʾ
Ò»¼¶Ä¿Â¼1
Ò»¼¶Ä¿Â¼1×ÓÀà1
×ÓÀà1
Ò»¼¶Ä¿Â¼1×ÓÀà2
......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
JSPÖÐÒª´ÓÊý¾Ý¿âÀïÃæ¶ÁÈ¡Êý¾Ý ÿҳÏÔʾ5ÌõÊý¾Ý£¬Òª½øÐзҳ£¬»¹Òª·µ»ØÇ°Ò»Ò³ ¸ÃÔõôʵÏÖ°¡
ÓõÄʲôÊý¾Ý¿âÄØ£¿£¿£¿
MYSQL
....лл ÎÒÏÈ¿´¿´´úÂë
http://my.donews.com/benz/2006/10/21/YnmQXKsKWNgKiTJ ......