File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes JSP - Unsupported Operation Exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JSP - Unsupported Operation Exception " Watch "JSP - Unsupported Operation Exception " New topic
Author

JSP - Unsupported Operation Exception

Potter James
Greenhorn

Joined: Aug 18, 2008
Posts: 9
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 ]
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60774
    
  65

Please take the time to choose the correct forum for your posts. This forum is for questions on JSP.

For more information, please read this.

This post has been moved to a more appropriate forum.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Herman Schelti
Ranch Hand

Joined: Jul 17, 2006
Posts: 387
hi Potter,

You are using the JDBC_ODBC bridge, it does not implement very much.
Here's some code:



cheers,
Herman
Potter James
Greenhorn

Joined: Aug 18, 2008
Posts: 9
Originally posted by Herman Scheltinga:
hi Potter,

You are using the JDBC_ODBC bridge, it does not implement very much.
Here's some code:



cheers,
Herman



Can you say that where to insert that clearly..
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Why are you using the JDBC ODBC bridge to communicate with DB2? COuld you not just use a proper type 4 driver? As is intimated above, the JDBC ODBC bridge is not production quality.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JSP - Unsupported Operation Exception
 
Similar Threads
problem retrieving from database
insertion of checkbox values from jsp to database
how to convert .csv files into sql server files using java
Data source name not found and no default driver specified
Connecting to database form servlets