public long getSequenz(String seqname) {
        String sql = "SELECT NEXT VALUE FOR "+seqname+" FROM Sequenz;";
        DataTable dt = selectDBS(sql);
        ArrayList<String> tupel = dt.tableRows.get(0);
        long pindex = Long.valueOf(tupel.get(0));
        return pindex;            
    }



    public DataTable selectDBS(String sql) {
        DataTable dt=new DataTable();
        int i;
          // Verbindung zur Datenbank, Auslese Variablen
        Statement  st = null;
        ResultSet  rs = null;

        try {
          // Treiber INIT, Verbinden  und SQL-Statement auslösen
          st = conn.createStatement();
          
            // SQL-Statement          
          rs = st.executeQuery( sql );

          // Get meta data:
          ResultSetMetaData rsmd = rs.getMetaData();
          int anzCols = rsmd.getColumnCount();  // neue Felder
          dt.anzCools=anzCols;

            // Man braucht den Vektor headerNames, da jetzt noch nicht
           // alle Spalten vorhanden sind.
          for( i=0; i<anzCols; i++ ) {   // Attention: first column with 1 instead of 0
            dt.headerColums.add( rsmd.getColumnName( i+1 ) );
          }
            // Schleife über alle Tupel
          while( rs.next() ) {
              // neue Zeile
              // Zeile aller Daten
            ArrayList<String> tupel = new ArrayList<String>();
            for( i=0; i<anzCols; i++ ) { // Attention: first column with 1 instead of 0
              //String s=rs.getString( i+1 );
              tupel.add ( rs.getString( i+1 ) );
            }
              // Tupel zur Gesamtliste hinzufügen
            dt.tableRows.add( tupel );
            dt.anzRows = dt.tableRows.size();
          }


        } catch( Exception ex ) {
          System.out.println( ex );
        } finally {
          try { if( null != rs ) rs.close(); } catch( Exception ex ) {}
          try { if( null != st ) st.close(); } catch( Exception ex ) {}
        }
        return dt;
    }
    


public class DataTable {
    public int anzRows=0;
    public int anzCools=0;
    
    public ArrayList<String> headerColums = new ArrayList<String>();
    
    public ArrayList<ArrayList> tableRows = new ArrayList<ArrayList>();
    
}