Oracle遇到的问题
配置信息应该都没有错，驱动也反复加载了，没有问题
运行Myeclipse编译可过，在网页测试时出现如下错误：
java.sql.SQLException: 调用中无效的参数
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:207)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:235)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:413)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:207)
at com.login.common.DBCommon.getConnection(DBCommon.java:41)
at com.login.common.DBCommon.doQuery(DBCommon.java:152)
at com.login.dao.LoginDao.login(LoginDao.java:14)
at com.login.service.LoginService.login(LoginService.java:9)
at com.login.servlet.LoginServlet.doPost(LoginServlet.java:25)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.ap
相关文档：
/**
* 更新记录，原子操作，不会commit
* @param sql_id
* @param condition
* @return
* @throws SQLException
*/
&nbs ......
http://www.wangchao.net.cn/bbsdetail_1776477.html
第 13 章 物化视图
8.1.5企业版/个人版开始支持
需要权限：GRANT CREATE MATERIALIZED VIEW，还必须直接赋予GRANT QUERY REWRITE.为实现查询重写，必须使用CBO.
......
http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96524/c21cnsis.htm#2937
Types of Locks
Oracle automatically uses different types of locks to control concurrent access to data and to prevent destructive interaction between users. Oracle automatically locks a resource on behalf of a tran ......
如果数据文件损坏，会遇到1157 和 1110的错误。这时候需要介质恢复数据库。
恢复数据库需要有相应的备份和备份以来产生的所有的归档日志文件和联机日志文件。
如果在mount到open的时候发现普通的数据文件损坏，数据库会停留在mount状态下，这时候可以执行alter database datafile x offline drop 和alter database open � ......
