1、要安装好timesten
2、需要配好system dsn ttdemo
3、创建表和存储过程
以上略
4、java内容如下:
package com;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.sql.rowset.*;
import com.sun.rowset.CachedRowSetImpl;
import com.timesten.jdbc.TimesTenDataSource;
public class Test {
public static void main(String arg[]) {
try {
//Class.forName("oracle.jdbc.driver.OracleDriver");
Class.forName("com.timesten.jdbc.TimesTenDriver");
String url = "jdbc:timesten:direct:dsn=ttdemo;uid=logstat;pwd=logstat;ORACLEID=logstat_214;OraclePWD=logstat";
TimesTenDataSource ds = new TimesTenDataSource();
ds.setUrl(url);
Connection con = ds.getConnection();
con.setAutoCommit(false);
PreparedStatement pstmt = null;
String sql = "{call p_insert( , )}";
pstmt = con.prepareCall(sql);
pstmt.setInt(1,1);