Win a copy of Testing JavaScript Applications this week in the HTML Pages with CSS and JavaScript forum!
    Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

nee help how to compare objects......

 
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hi everybody...,


I am trying to retreive data from sql db tables, and insert into oracale db table.before inserting into oracle table i have to check the modified date column in oracle. if sql table is having updated data i have to insert.

I am using jdbc api. I got connected to both databases and retreived data from databases. the code i wrote is below, but am stucked at comparing the data and inserting into oracle.
please help me.......

Thanks in advanse
---------------------------------------------------------------------------

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

public class Conn {

Connection con = null;

public static Connection getSqlConnection(String Username, String Password)
throws SQLException {
String url = "jdbc:sqlserver://localhost\\SQLEXPRESSS:1433;databaseName=Murthy;";
Connection con = null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = DriverManager.getConnection(url, Username, Password);
if (con != null)
System.out.println("connected");
else
System.out.println("not connected");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return con;
}

public static Connection getOracleConnection(String Username,
String Password) throws SQLException {
String url = "jdbc racle:thin:@localhost:1521:XE";
Connection con = null;

try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(url, Username, Password);
if (con != null)
System.out.println("connected");
else
System.out.println("not connected");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

return con;
}

public void read() throws SQLException {
Connection con = null;
ResultSet res = null;
Statement stmt = null;
try {
con = getSqlConnection("sa", "amsol");
stmt = con.createStatement();
String query = "select * from [User]";
res = stmt.executeQuery(query);
while (res.next()) {

String ans = res.getString(1);
String ans1 = res.getString(2);
String ans2 = res.getString(3);
String ans3 = res.getString(4);
String ans4 = res.getString(5);
}

} catch (Exception e) {
System.out.println(e);
}

finally {
try {
if (stmt != null) stmt.close();
}
catch (Exception ee) {
} try { if (con != null) con.close(); } catch (Exception c) { } }


}

public void read2() throws SQLException {
con = getOracleConnection("system", "murthy");
Statement stmt = con.createStatement();
String query = "select * from tb_User";
ResultSet res1 = stmt.executeQuery(query);
while (res1.next()) {

String data = res1.getString(8);

}
}

public static void main(String[] args) throws SQLException {
Conn connect = new Conn();
connect.read();
connect.read2();


}

}
I am unable to compare the two resultset objects. I have to compare them based on that i have to either update the row in oracle db or insert the row into oracle db.

I am trying to compare the objects in main method.

I tried arraylist,<pojo> they are not working. can you give me idea how to compare the objects. if i use the resultset object it is saying like resultset is not having any row it is closed.
 
Rancher
Posts: 3742
16
  • Mark post as helpful
  • send pies
  • Report post to moderator
Don't ask the same question more than once.
 
Ranch Hand
Posts: 451
1
IntelliJ IDE Spring Java
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hi,

If you intend to store the details about when the record was inserted or last updated shouldn't you also have a column for the Timestamp value of insertion/updation. If you have such a column in both these database tables, you can then fetch its value for both and a comparison would let you know whether you need to insert or update.

Cheers,
Raj.
 
I wish to win the lottery. I wish for a lovely piece of pie. And I wish for a tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic