Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 01-07-2009, 11:44 AM
Member
 
Join Date: Aug 2008
Posts: 39
Rep Power: 0
hungleon88 is on a distinguished road
Default Problem with resultSet.updateNString and rowSet.updateNString
This is my code
1) I use resultSet to insert to database
String sql = "Select * from Students";
preStm = cn.prepareStatement(sql,ResultSet.TYPE_SCROLL_SENS ITIVE,ResultSet.CONCUR_UPDATABLE);

rSet = preStm.executeQuery();
rSet.first();
rSet.updateString(1, text_ID_insert.getText());
rSet.updateNString(2, text_name_insert.getText());
rSet.updateInt(3, Integer.parseInt(combo_class_insert.getSelectedIte m().toString()));
rSet.updateNString(4, text_address_insert.getText());
rSet.updateString(5, text_tel_insert.getText());
rSet.insertRow();


2) I use rowSet
rowSet = new JdbcRowSetImpl(rSet);
rowSet.moveToInsertRow();
rowSet.updateString(1, text_ID_insert.getText());
rowSet.updateNString(2, text_name_insert.getText());
rowSet.updateInt(3, Integer.parseInt(combo_class_insert.getSelectedIte m().toString()));
rowSet.updateNString(4, text_address_insert.getText());
rowSet.updateString(5, text_tel_insert.getText());

rowSet.insertRow();

Both 1 and 2 get error like this :
Exception in thread "AWT-EventQueue-0" java.lang.UnsupportedOperationException: Operation not yet supported
at sun.jdbc.odbc.JdbcOdbcResultSet.updateNString(Jdbc OdbcResultSet.java:6766)


How can i insert data with NVarchar type to database??
Please Hint me !!
Bookmark Post in Technorati
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ResultSet.updateRow() problem kvikas Advanced Java 1 04-22-2008 03:11 AM
problem with ResultSet.updateRow() kvikas New To Java 0 04-14-2008 10:00 AM
ResultSet to XML Java Tip Java Tips 0 02-14-2008 09:50 AM
ResultSet example Java Tip Java Tips 0 01-20-2008 08:59 AM
Cannot set DataSource for RowSet piterskiy Database 0 12-07-2007 07:58 PM


All times are GMT +2. The time now is 01:56 AM.



VBulletin, Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2009, Crawlability, Inc.
Copyright ©2006 - 2007, www.java-forums.org