博文

目前显示的是标签为“JDBC”的博文

JdbcRowSet & SQL Server(Sqljdbc4.jar)

Create a JdbcRowSet object in various ways: 1. By using the reference implementation constructor that takes a ResultSet object 2. By using the reference implementation constructor that takes a Connection object 3. By using the reference implementation default constructor 4. By using an instance of RowSetFactory , which is created from the class RowSetProvider Testing Environment : JDBC driver: Sqljdbc4.jar Java SE Version:1.7.0_51 Result: 1.Passing ResultSet Objects // It works. 2.Passing Connection Objects // It does not work 3.Using the Default Constructor // It does not work 4.Using the RowSetFactory Interface // It does not work import com.sun.rowset.JdbcRowSetImpl; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import javax.sql.rowset. JdbcRowSet ; import javax.sql.rowset.RowSetFactory; import javax.sql.rowset.RowSetProvider;     public static void main(String[] args)...

Oracle 12c jdbc connect string for PDB

Ref :  h t t p s:// forums.oracle.com/thread/2566804 1 . link string in code # <!--指定连接数据库用的驱动 ojdbc6.jar--> database.driver=oracle.jdbc.OracleDriver #// oracle.jdbc.driver.OracleDriver is deprecated and replaced with oracle.jdbc.OracleDriver. #h t tp://download.oracle.com/otn_hosted_doc/jdeveloper/905/jdbc-javadoc/oracle/jdbc/OracleDriver.html # <!--指定连接数据库的路径--> # for oracle 11g database.url= jdbc:oracle:thin:@localhost:1521:orcl # for oracle 12c1 database.url= jdbc:oracle:thin:@//127.0.0.1:1522/pdborcl or database.url= jdbc:oracle:thin:@127.0.0.1:1522/pdborcl #<!--指定连接数据库的用户名--> database.username=test # <!--指定连接数据库的密码--> database.password=test <!--指定数据库使用的SQL--> hibernate.dialect=org.hibernate.dialect.Oracle9Dialect #org.hibernate.dialect.OracleDialect #Oracle10gDialect # <!--当show_sql属性为true时表示在程序运行时在控制台输出SQL语句,默认为false--> hibernate.show_sql=false oracle.maxConnection=100 oracle.expireTime=2400000 oracle.updateTim...