JDBC Programming Sample

The following example creates a connection to the database named “DB” on server “MYSERVER.” It then creates a statement object on that connection that is sensitive and updateable. Using the statement object a “SELECT” query is performed. Once the result set object is obtained a call to “absolute” is made in order to move to the fifth row. Once on the fifth row the second column is updated with an integer value of 101. Then a call to “updateRow” is made to actually make the update.

Class.forName("com.pervasive.jdbc.v2.Driver");

Connection conn=

DriverManager.getConnection("jdbc:pervasive://MYSERVER:1583/DB");

 

Statement stmt =

conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);

 

ResultSet rs =

m_stmt.executeQuery("SELECT * FROM mytable");

 

 

rs.absolute(5);

rs.updateInt(2, 101);

rs.updateRow();

 

rs.close();

stmt.close();

conn.close();