Results 1 to 1 of 1
- 01-07-2009, 11:44 AM #1
Member
- Join Date
- Aug 2008
- Posts
- 41
- Rep Power
- 0
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 !!
Similar Threads
-
ResultSet.updateRow() problem
By kvikas in forum Advanced JavaReplies: 1Last Post: 04-22-2008, 03:11 AM -
problem with ResultSet.updateRow()
By kvikas in forum New To JavaReplies: 0Last Post: 04-14-2008, 10:00 AM -
ResultSet to XML
By Java Tip in forum Java TipReplies: 0Last Post: 02-14-2008, 09:50 AM -
ResultSet example
By Java Tip in forum Java TipReplies: 0Last Post: 01-20-2008, 08:59 AM -
Cannot set DataSource for RowSet
By piterskiy in forum JDBCReplies: 0Last Post: 12-07-2007, 07:58 PM


LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks