import  java.sql.*;

 public   class  Nextval {
	
	 public   static   int  nextval(String seqname)  throws  SQLException {
		Connection con =  null ;
		Statement st =  null ;
		ResultSet rs =  null ;
		 try  {
			con = DriverManager.getConnection("jdbc:default:connection");
			con.setAutoCommit(false);
			st = con.createStatement();
			rs = st.executeQuery("values nextval for " + seqname);
			 return  rs.next()?rs.getInt( 1 ): 0 ;
		}  finally  {
			 if  (rs !=  null ) {rs.close(); rs =  null ;}
			 if  (st !=  null ) {st.close(); st =  null ;}
			 if  (con !=  null ) {con.close(); con =  null ;}
		}
	}
}

create function nextval(seqname varchar( 128 ))
RETURNS int
LANGUAGE Java
EXTERNAL NAME 'Nextval.nextval'
FENCED THREADSAFE
READS SQL DATA
NOT NULL CALL
NO EXTERNAL ACTION
DISALLOW PARALLEL
PARAMETER STYLE java;