摘要: tnsnames.oraORCL= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.5.78 )(PORT = 1522)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) 法一: 1 OracleDataSource ds = new OracleDataSource(); 2 ds.setDriverType("oci"); 3 ds.setNetworkProtocol("tcp"); 4 ds.setServerN 阅读全文
posted @ 2011-08-28 22:31 freewater 阅读(587) 评论(0) 推荐(0) 编辑
摘要: OCI Connection PoolingThe OCI connection pooling feature is an Oracle-designed extension. The connectionpooling provided by the JDBC OCI driver enables applications to have multiple logicalconnections, all of which are using a small set of physical connections. Each call on alogical connection is ro 阅读全文
posted @ 2011-08-28 18:38 freewater 阅读(324) 评论(0) 推荐(0) 编辑
摘要: The DML returning feature provides more functionality compared to retrieval ofauto-generated keys. It can be used to retrieve not only auto-generated keys, but alsoother columns or values that the application may use.Note:■The server-side internal driver does not support DML returningand retrieval o 阅读全文
posted @ 2011-08-28 16:38 freewater 阅读(641) 评论(0) 推荐(0) 编辑
摘要: Registering Output ParametersThe type codes in java.sql.Types or oracle.jdbc.OracleTypes identify theSQL types of the output parameters in the registerOutParameter method of thejava.sql.CallableStatement andoracle.jdbc.OracleCallableStatement interfaces.These are the forms that the registerOutputPar 阅读全文
posted @ 2011-08-28 16:26 freewater 阅读(413) 评论(0) 推荐(0) 编辑
摘要: A ROWID is an identification tag unique for each row of an Oracle Database table. TheROWID can be thought of as a virtual column, containing the ID for each row.The oracle.sql.ROWID class is supplied as a container for ROWID SQL data type.If you include the ROWID pseudo-column in a query, then you c 阅读全文
posted @ 2011-08-28 15:02 freewater 阅读(2555) 评论(1) 推荐(0) 编辑