/*
* Created on 27.01.2005@09:50:11
*
* TODO Licence info
*/
package de.tutorials;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.io.StringWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import oracle.jdbc.pool.OracleDataSource;
/**
* @author Darimont
*
* TODO Explain me
*/
public class ClobExample {
public static void main(String[] args) {
try {
Thread.currentThread().getContextClassLoader().loadClass(
"oracle.jdbc.OracleDriver");
} catch (Exception e) {
e.printStackTrace();
}
try {
OracleDataSource ods = new OracleDataSource();
ods.setServerName("localhost");
ods.setDatabaseName("orcl");
ods.setUser("tom");
ods.setPassword("mypwd");
ods.setDriverType("oci");
ods.setPortNumber(1521);
//ods.setLogWriter(new PrintWriter(System.out));
Connection con = ods.getConnection();
PreparedStatement pstmt = con
.prepareStatement("insert into texte (id,text_data) values(?,?)");
pstmt.setInt(1, 1);
File file = new File("c:/symbol3.txt");
// Schreiben ...
FileReader fr = new FileReader(file);
pstmt.setCharacterStream(2,fr,(int)file.length());
pstmt.execute();
fr.close();
// Auslesen:
ResultSet rs = con.createStatement().executeQuery(
"SELECT id, text_data from texte");
ResultSetMetaData rsmd = rs.getMetaData();
while (rs.next()) {
int id = rs.getInt("id");
System.out.print("id: " + id + "\t\t");
StringWriter sWriter = new StringWriter();
BufferedReader br = new BufferedReader(rs
.getCharacterStream("text_data"));
String str;
while ((str = br.readLine()) != null) {
sWriter.write(str);
}
System.out.println(" text_data: " + sWriter);
}
con.close();
} catch (SQLException e1) {
e1.printStackTrace();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
}