All pastes #1013324 Raw Edit

Apache Derby Database Limitation

public java v1 · immutable
#1013324 ·published 2008-05-10 00:11 UTC
rendered paste body
import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class DerbyTestCase {	private static String URL 		= "jdbc:derby:data/TestDB";	private static String driveName = "org.apache.derby.jdbc.EmbeddedDriver";	{		try {			Class.forName(driveName);		} catch (ClassNotFoundException e) {			e.printStackTrace();		}	}	public static void main(String [] args) {		try {						Connection c = DriverManager.getConnection(URL);			Statement s = c.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE, ResultSet.HOLD_CURSORS_OVER_COMMIT);			String sql;						//ReCreate Schema			try {				//sql = "DROP TABLE MY_DUMMY_TABLE";				//s.execute(sql);				//sql = "CREATE TABLE MY_DUMMY_TABLE (ID INT GENERATED BY DEFAULT AS IDENTITY, NAME VARCHAR(30) DEFAULT '' NOT NULL)";				//s.execute(sql);							} catch (Exception e) {				e.printStackTrace();			}						sql = "SELECT * FROM MY_DUMMY_TABLE";			ResultSet rs = s.executeQuery(sql);						//Critical Junction			rs.moveToInsertRow();			rs.updateString("NAME", "John");			rs.insertRow();						System.out.println(rs.getInt("id"));			System.out.println(rs.getString("NAME"));			rs.moveToCurrentRow();			rs.moveToInsertRow();			rs.updateString("NAME", "Ralphs");			rs.insertRow();						System.out.println(rs.getInt("id"));			System.out.println(rs.getString("NAME"));						rs.refreshRow();			rs.close();			s.close();			c.close();		} catch (SQLException e) {			// TODO Auto-generated catch block			e.printStackTrace();		}	}}