import java.sql.Clob;import java.sql.Connection;import java.sql.Date;import java.sql.PreparedStatement;import java.sql.SQLException;import java.util.logging.Level;import java.util.logging.Logger;import oracle.jdbc.pool.OracleDataSource;
/** * * @author Miodrag Spasic * September 2021 */public class DbWriter {
private String url = null; private final String username = "username"; private final String password = "password"; private final String defaultTnsPath = "your_path_to TNS file"; //test path private Connection conn;
private final OracleDbConnParams dbParams = new OracleDbConnParams(username, password, defaultTnsPath);
public void setConnection() throws SQLException { url = dbParams.getURI_PREFIX() + dbParams.getTnsString();
OracleDataSource ods = new OracleDataSource(); ods.setUser(username); ods.setPassword(password); ods.setURL(url);
conn = ods.getConnection(); System.out.println("Connected sucessfuly");
}
public void writeToTable() { try { String sqlInsertStatement = "insert into [table_name] values(?,?,?)"; PreparedStatement ps = conn.prepareStatement(sqlInsertStatement);
Date date = new Date(System.currentTimeMillis());
Clob clob = conn.createClob(); clob.setString(1, "");
ps.setDate(1, date); ps.setClob(2, clob); ps.setString(3, "");
ps.execute();
ps.close(); } catch (SQLException ex) { Logger.getLogger(DbWriter.class.getName()).log(Level.SEVERE, null, ex); }
}
//Usage of FBWriter public static void main(String[] args) throws SQLException { DbWriter dbWriter = new DbWriter(); dbWriter.setConnection(); dbWriter.writeToTable();
}
}
++++++++++++++++++++++++++++++++++++++++++++
/** * * @author Miodrag Spasic * September 2021 */
//Use this class to create connection parameters.
import java.io.File;import java.io.FileNotFoundException;import java.util.Scanner;import java.util.logging.Level;import java.util.logging.Logger;
public class OracleDbConnParams { //JDBC driver needs url for creating connection to oracle database. //It`s formed by concating uriPrefix and tns string.
private final String URI_PREFIX = "jdbc:oracle:thin:@"; private final String userName; private final String password; private final String defaultTnsPath;
public OracleDbConnParams(String userName, String password, String defaultTnsPath) { this.userName = userName; this.password = password; this.defaultTnsPath = defaultTnsPath; } Scanner s = null; public String getTnsString(){ String tns = null; StringBuilder stringBuilder = new StringBuilder(); File f = new File(defaultTnsPath); try { s = new Scanner(f); } catch (FileNotFoundException ex) { Logger.getLogger(OracleDbConnParams.class.getName()).log(Level.SEVERE, null, ex); } while(s.hasNextLine()){ stringBuilder.append(s.nextLine()); } s.close();
tns = stringBuilder.toString(); System.out.println(stringBuilder.toString()); return tns; }
public String getUriPrefix() { return uriPrefix; }
public String getUserName() { return userName; }
public String getPassword() { return password; }}
++++++++++++++++++++++++++++++++++++++++++