hi
I tried to write a code that reads the data from excel sheet and writes into DB2 database.It worked perfectly .But if it has repetition fields, then also it inserts the data.So I used a primary key in the database to avoid repetition.Then I wrote a code which inserts data into database when there is no repetition of data.But if it contains repeatitive data, then it must rollback all the process in database or remove the data that is inserted through the program.I used save point and rollback for this action.
When i run the program it shows "
java.lang.UnsupportedOperationException ".Can anyone help me out.
So my code is
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<html>
<body>
<%
Connection c;
Connection c1;
Statement stmnt;
Statement stmnt1;
Savepoint svpt1=null ;
int r=0;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
c = DriverManager.getConnection("jdbc
dbc:tt","",""); //excel DSN = tt
c1= DriverManager.getConnection("jdbc
dbc :db2","",""); //DB2 DSN = db2
stmnt = c.createStatement();
stmnt1 = c1.createStatement();
ResultSet rs = stmnt.executeQuery("SELECT * FROM [Sheet1$]");
try
{
while(rs.next())
{
String a1=rs.getString("percen");
String a2=rs.getString("name");
svpt1 = c1.setSavepoint("first");
r= stmnt1.executeUpdate("INSERT INTO TAB1 VALUES('"+a1+"','"+a2+"');");//insert fields into database DB2
out.println(a1+" "+a2);
}
c1.commit();
response.sendRedirect("index.jsp");
}
catch(Exception e)
{
c1.rollback(svpt1);
}
}
catch(Exception e)
{
out.println(e);
}
%>
</body>
</html>
Manoj
[ October 22, 2008: Message edited by: Potter James ]
[ October 22, 2008: Message edited by: Potter James ]
[ October 22, 2008: Message edited by: Potter James ]