trovacap-java-loginfo — CVS loginfo notification

[Trovacap-java-loginfo] jTrovaCap/lib/thinlet - New directory

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/lib/thinlet
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv20524/lib/thinlet

Log Message:
Directory /cvsroot/trovacap-java/jTrovaCap/lib/thinlet added to the repository

[Trovacap-java-loginfo] jTrovaCap/lib/log4j - New directory

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/lib/log4j
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv20524/lib/log4j

Log Message:
Directory /cvsroot/trovacap-java/jTrovaCap/lib/log4j added to the repository

[Trovacap-java-loginfo] jTrovaCap/lib/junit-3.8.1 - New directory

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/lib/junit-3.8.1
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv20524/lib/junit-3.8.1

Log Message:
Directory /cvsroot/trovacap-java/jTrovaCap/lib/junit-3.8.1 added to the repository

[Trovacap-java-loginfo] jTrovaCap/lib/j2ssh - New directory

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/lib/j2ssh
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv20524/lib/j2ssh

Log Message:
Directory /cvsroot/trovacap-java/jTrovaCap/lib/j2ssh added to the repository

[Trovacap-java-loginfo] jTrovaCap/lib/hsqldb - New directory

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/lib/hsqldb
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv20524/lib/hsqldb

Log Message:
Directory /cvsroot/trovacap-java/jTrovaCap/lib/hsqldb added to the repository

[Trovacap-java-loginfo] jTrovaCap/lib/jsch - New directory

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/lib/jsch
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv20524/lib/jsch

Log Message:
Directory /cvsroot/trovacap-java/jTrovaCap/lib/jsch added to the repository

[Trovacap-java-loginfo] jTrovaCap/lib/hibernate/core - New directory

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/lib/hibernate/core
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv20524/lib/hibernate/core

Log Message:
Directory /cvsroot/trovacap-java/jTrovaCap/lib/hibernate/core added to the repository

[Trovacap-java-loginfo] jTrovaCap/lib/IzPack-4.0.0 - New directory

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/lib/IzPack-4.0.0
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv20524/lib/IzPack-4.0.0

Log Message:
Directory /cvsroot/trovacap-java/jTrovaCap/lib/IzPack-4.0.0 added to the repository

[Trovacap-java-loginfo] jTrovaCap/lib/hibernate - New directory

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/lib/hibernate
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv20524/lib/hibernate

Log Message:
Directory /cvsroot/trovacap-java/jTrovaCap/lib/hibernate added to the repository

[Trovacap-java-loginfo] jTrovaCap/bin jTrovaCap.jar,1.1,1.2

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/bin
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv26877/bin

Modified Files:
	jTrovaCap.jar 
Log Message:
Update to release 1.2

Index: jTrovaCap.jar
===================================================================
RCS file: /cvsroot/trovacap-java/jTrovaCap/bin/jTrovaCap.jar,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
Binary files /tmp/cvs9678oz and /tmp/cvs8Wjt04 differ

[Trovacap-java-loginfo] jTrovaCap/java/uk/co/marcoratto/jtrovacap/thinlet Gui.java, 1.1, 1.2

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/java/uk/co/marcoratto/jtrovacap/thinlet
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv26823/java/uk/co/marcoratto/jtrovacap/thinlet

Modified Files:
	Gui.java 
Log Message:
Update to release 1.2

Index: Gui.java
===================================================================
RCS file: /cvsroot/trovacap-java/jTrovaCap/java/uk/co/marcoratto/jtrovacap/thinlet/Gui.java,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** Gui.java	18 Jun 2007 09:57:34 -0000	1.1
--- Gui.java	2 Jul 2008 14:13:12 -0000	1.2
***************
*** 1,17 ****
  package uk.co.marcoratto.jtrovacap.thinlet;
  
! import java.sql.*;
! import thinlet.*;
! import java.util.*;
! import java.awt.*;
! import java.awt.datatransfer.*;
  
! import uk.co.marcoratto.jtrovacap.hsqldb.*;
  
  /**
!  * Simple demonstration of widgets and events
   */
  public class Gui extends Thinlet {
  
  	/**
  	 * Loads the xml file
--- 1,54 ----
+ /*
+  * Copyright (C) 2007 Marco Ratto
+  *
+  * This file is part of the project trovacap-java.
+  *
+  * trovacap-java is free software; you can redistribute it and/or modify
+  * it under the terms of the GNU General Public License as published by
+  * the Free Software Foundation; either version 2 of the License, or
+  * any later version.
+  *
+  * trovacap-java is distributed in the hope that it will be useful,
+  * but WITHOUT ANY WARRANTY; without even the implied warranty of
+  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+  * GNU General Public License for more details.
+  *
+  * You should have received a copy of the GNU General Public License
+  * along with trovacap-java; if not, write to the Free Software
+  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+  */
  package uk.co.marcoratto.jtrovacap.thinlet;
  
! import java.util.List;
! import java.util.Locale;
! import java.util.ResourceBundle;
! import java.awt.FontMetrics;
! import java.awt.Toolkit;
! import java.awt.datatransfer.Clipboard;
! import java.awt.datatransfer.StringSelection;
  
! import org.apache.log4j.Logger;
! 
! import thinlet.Thinlet;
! import uk.co.marcoratto.jtrovacap.hsqldb.CapDAO;
! import uk.co.marcoratto.jtrovacap.hsqldb.Cap;
! import uk.co.marcoratto.jtrovacap.hsqldb.CapDAOException;
  
  /**
!  * @author Marco Ratto
   */
  public class Gui extends Thinlet {
  
+    private String comune = null;
+    private String provincia = null;
+    private String toponimo = null;
+    private String cap = null;
+    
+    private Object dialog;
+    private Object alert;
+    private ResourceBundle bundle;
+ 	   
+    private static Logger logger = Logger.getLogger("uk.co.marcoratto.jtrovacap");
+    
  	/**
  	 * Loads the xml file
***************
*** 65,82 ****
  		Object choice = null;
  		try {
! 		    con = DbConnection.getInstance().getConnection();
! 		    TabCapDAO dao = new TabCapDAO(); 
! 		    java.util.List l =  dao.getElencoProvince(con);
  		    for (int j=0; j<l.size(); j++) {
- 		    	TabCapDTO dto = (TabCapDTO) l.get(j);
  		        choice = create("choice");
! 		        setString(choice, "text", dto.getProvCap());
  				add(table, choice, -1);
  		    }
! 		} catch (Exception e) {
! 			e.printStackTrace();
! 		} finally {
! 			DbConnection.getInstance().closeConnection(con);
! 		}
  	}
  
--- 102,114 ----
  		Object choice = null;
  		try {
! 		    List<String> l = CapDAO.getInstance().getElencoProvince();
  		    for (int j=0; j<l.size(); j++) {
  		        choice = create("choice");
! 		        setString(choice, "text", l.get(j));
  				add(table, choice, -1);
  		    }
! 		} catch (CapDAOException e) {
! 			logger.error(e);
! 		} 
  	}
  
***************
*** 105,112 ****
       }
  
!      System.out.println("comune=" + comune);
! 	 System.out.println("provincia=" + provincia);
! 	 System.out.println("toponimo=" + toponimo);
! 	 System.out.println("cap=" + cap);
  	  
  	  if ((comune == null) && 
--- 137,144 ----
       }
  
!      logger.debug("comune=" + comune);
!      logger.debug("provincia=" + provincia);
!      logger.debug("toponimo=" + toponimo);
!      logger.debug("cap=" + cap);
  	  
  	  if ((comune == null) && 
***************
*** 119,126 ****
  	  removeAll(elenco);
  	  try {
! 		    con = DbConnection.getInstance().getConnection();
! 		    TabCapDAO dao = new TabCapDAO(); 
! 		    int i =  dao.getTotal(con, comune, provincia, toponimo, cap);
! 		    System.out.println("Total Records=" + i);
  		    if (i == 0) {
  				  showAlert(bundle.getString("msg.no_records"));
--- 151,156 ----
  	  removeAll(elenco);
  	  try {
! 		    int i =  CapDAO.getInstance().getTotal(comune, provincia, toponimo, cap);
! 		    logger.debug("Total Records=" + i);
  		    if (i == 0) {
  				  showAlert(bundle.getString("msg.no_records"));
***************
*** 128,170 ****
  				  showAlert(bundle.getString("msg.too_many_records"));
  		    } else {
! 		    	  java.util.List l =  dao.getElenco(con, comune, provincia, toponimo, cap);
  		    	  for (int j=0; j<l.size(); j++) {
! 		    		  TabCapDTO dto = (TabCapDTO) l.get(j);
  		    	
  		    		  Object row = create("row");
  		    		  Object cellDUG = create("cell");
! 		    		  setString(cellDUG, "text", dto.getDugtCap());
  		    		  add(row, cellDUG);
! 		    		  this.adjustColumn(elenco, "colDug", dto.getDugtCap());
  			    	            
  		    		  Object cellToponimo = create("cell");
! 	            setString(cellToponimo, "text", dto.getTopoCap());
  	            add(row, cellToponimo);
! 	            this.adjustColumn(elenco, "colCap", dto.getTopoCap());
  	            
  	            Object cellCivici = create("cell");
! 	            setString(cellCivici, "text", dto.getNcivCap());
  	            add(row, cellCivici);
! 	            this.adjustColumn(elenco, "colCivici", dto.getNcivCap());
  	            
  	            Object cellCap = create("cell");
! 	            setString(cellCap, "text", dto.getCapiCap());
  	            add(row, cellCap);
! 	            this.adjustColumn(elenco, "colCap", dto.getCapiCap());
  
  	            Object cellComune = create("cell");
! 	            setString(cellComune, "text", dto.getComuCap());
  	            add(row, cellComune);
! 	            this.adjustColumn(elenco, "colComune", dto.getComuCap());
  
  	            Object cellFrazione = create("cell");
! 	            setString(cellFrazione, "text", dto.getFrazCap());
  	            add(row, cellFrazione);
! 	            this.adjustColumn(elenco, "colFrazione", dto.getFrazCap());
  
  	            Object cellProvincia = create("cell");
! 	            setString(cellProvincia, "text", dto.getProvCap());
  	            add(row, cellProvincia);
! 	            this.adjustColumn(elenco, "colProvincia", dto.getProvCap());
  	            
  	            add(elenco, row);
--- 158,200 ----
  				  showAlert(bundle.getString("msg.too_many_records"));
  		    } else {
! 		    	  List<Cap> l =  CapDAO.getInstance().getElenco(comune, provincia, toponimo, cap);
  		    	  for (int j=0; j<l.size(); j++) {
! 		    		  Cap dto = (Cap) l.get(j);
  		    	
  		    		  Object row = create("row");
  		    		  Object cellDUG = create("cell");
! 		    		  setString(cellDUG, "text", dto.getDugt());
  		    		  add(row, cellDUG);
! 		    		  this.adjustColumn(elenco, "colDug", dto.getDugt());
  			    	            
  		    		  Object cellToponimo = create("cell");
! 	            setString(cellToponimo, "text", dto.getTopo());
  	            add(row, cellToponimo);
! 	            this.adjustColumn(elenco, "colCap", dto.getTopo());
  	            
  	            Object cellCivici = create("cell");
! 	            setString(cellCivici, "text", dto.getNciv());
  	            add(row, cellCivici);
! 	            this.adjustColumn(elenco, "colCivici", dto.getNciv());
  	            
  	            Object cellCap = create("cell");
! 	            setString(cellCap, "text", dto.getCapi());
  	            add(row, cellCap);
! 	            this.adjustColumn(elenco, "colCap", dto.getCapi());
  
  	            Object cellComune = create("cell");
! 	            setString(cellComune, "text", dto.getComu());
  	            add(row, cellComune);
! 	            this.adjustColumn(elenco, "colComune", dto.getComu());
  
  	            Object cellFrazione = create("cell");
! 	            setString(cellFrazione, "text", dto.getFraz());
  	            add(row, cellFrazione);
! 	            this.adjustColumn(elenco, "colFrazione", dto.getFraz());
  
  	            Object cellProvincia = create("cell");
! 	            setString(cellProvincia, "text", dto.getProv());
  	            add(row, cellProvincia);
! 	            this.adjustColumn(elenco, "colProvincia", dto.getProv());
  	            
  	            add(elenco, row);
***************
*** 172,179 ****
  		    }
  		} catch (Exception e) {
! 			e.printStackTrace();
! 		} finally {
! 			DbConnection.getInstance().closeConnection(con);
! 		}
     }
     
--- 202,207 ----
  		    }
  		} catch (Exception e) {
! 			logger.error(e);
! 		} 
     }
     
***************
*** 232,235 ****
--- 260,264 ----
  		   clipboard.setContents(new StringSelection(sb.toString()), null);  
  	   } catch (Exception e) {
+ 		   logger.warn(e);
  	   }
     }
***************
*** 249,260 ****
     }   
  
-    private String comune = null;
-    private String provincia = null;
-    private String toponimo = null;
-    private String cap = null;
-    private Connection con = null;
-    
-    private Object dialog;
-    private Object alert;
-    private ResourceBundle bundle;
  }
--- 278,280 ----

[Trovacap-java-loginfo] jTrovaCap/java/i18n i18n_it.properties, 1.1, 1.2

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/java/i18n
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv26823/java/i18n

Modified Files:
	i18n_it.properties 
Log Message:
Update to release 1.2

Index: i18n_it.properties
===================================================================
RCS file: /cvsroot/trovacap-java/jTrovaCap/java/i18n/i18n_it.properties,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** i18n_it.properties	18 Jun 2007 09:57:27 -0000	1.1
--- i18n_it.properties	2 Jul 2008 14:13:12 -0000	1.2
***************
*** 23,26 ****
  
  msg.search_error=ERRORE!Impostare almeno un campo.
! msg.no_records=ERRORE! Nessun record trovato.
! msg.too_many_records=ERRORE! Troppi records (max. 1000).
--- 23,26 ----
  
  msg.search_error=ERRORE!Impostare almeno un campo.
! msg.no_records=ERRORE!Nessun record trovato.
! msg.too_many_records=ERRORE!Troppi records (max. 1000).

[Trovacap-java-loginfo] jTrovaCap/java/uk/co/marcoratto/jtrovacap Runme.java, 1.1, 1.2

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/java/uk/co/marcoratto/jtrovacap
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv26823/java/uk/co/marcoratto/jtrovacap

Modified Files:
	Runme.java 
Log Message:
Update to release 1.2

Index: Runme.java
===================================================================
RCS file: /cvsroot/trovacap-java/jTrovaCap/java/uk/co/marcoratto/jtrovacap/Runme.java,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** Runme.java	18 Jun 2007 09:57:29 -0000	1.1
--- Runme.java	2 Jul 2008 14:13:12 -0000	1.2
***************
*** 1,4 ****
--- 1,25 ----
+ /*
+  * Copyright (C) 2007 Marco Ratto
+  *
+  * This file is part of the project trovacap-java.
+  *
+  * trovacap-java is free software; you can redistribute it and/or modify
+  * it under the terms of the GNU General Public License as published by
+  * the Free Software Foundation; either version 2 of the License, or
+  * any later version.
+  *
+  * trovacap-java is distributed in the hope that it will be useful,
+  * but WITHOUT ANY WARRANTY; without even the implied warranty of
+  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+  * GNU General Public License for more details.
+  *
+  * You should have received a copy of the GNU General Public License
+  * along with trovacap-java; if not, write to the Free Software
+  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+  */
  package uk.co.marcoratto.jtrovacap;
  
+ import org.apache.log4j.Logger;
+ 
  import thinlet.FrameLauncher;
  import uk.co.marcoratto.jtrovacap.thinlet.Gui;
***************
*** 6,14 ****
  public class Runme {
  
! 	/**
! 	 * Creates a frame including this thinlet demo
! 	 */
! 	public static void main(final String[] args) throws Exception {
! 		new FrameLauncher("jTrovaCap", new Gui(), 800, 600);
  	}
  	
--- 27,38 ----
  public class Runme {
  
! 	private static Logger logger = Logger.getLogger("uk.co.marcoratto.jtrovacap");
! 	
! 	public static void main(final String[] args) {
! 		try {
! 			new FrameLauncher("jTrovaCap", new Gui(), 800, 600);			
! 		} catch (Throwable t) {
! 			logger.error(t);
! 		}
  	}
  	

[Trovacap-java-loginfo] jTrovaCap/java/uk/co/marcoratto/jtrovacap/hsqldb CapDAOException.java, NONE, 1.1 CapDAO.java, NONE, 1.1 Cap.hbm.xml, NONE, 1.1 Cap.java, NONE, 1.1 DbConnection.java, 1.1, NONE TabCapDTO.java, 1.1, NONE TabCapDAO.java, 1.1, NONE

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/java/uk/co/marcoratto/jtrovacap/hsqldb
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv26823/java/uk/co/marcoratto/jtrovacap/hsqldb

Added Files:
	CapDAOException.java CapDAO.java Cap.hbm.xml Cap.java 
Removed Files:
	DbConnection.java TabCapDTO.java TabCapDAO.java 
Log Message:
Update to release 1.2

--- DbConnection.java DELETED ---

--- TabCapDAO.java DELETED ---

--- NEW FILE: CapDAO.java ---
/*
 * Copyright (C) 2007 Marco Ratto
 *
 * This file is part of the project trovacap-java.
 *
 * trovacap-java is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * any later version.
 *
 * trovacap-java is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with trovacap-java; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 */
package uk.co.marcoratto.jtrovacap.hsqldb;

import java.sql.SQLException;
import java.util.List;

import org.apache.log4j.Logger;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;

import uk.co.marcoratto.util.HibernateUtil;

/**
 * This class provides methods to populate DB Table of CAP
 */
public class CapDAO {
	
	private Session session;
	
	private static CapDAO istance = null;
	
	private static Logger logger = Logger.getLogger("uk.co.marcoratto.jtrovacap");
	
	private CapDAO() {
	}
	
    public static CapDAO getInstance() {
        if (istance == null) {
        	istance = new CapDAO();
        }
        return istance;
      }
	
	public int getTotal(String comune, String provincia, String toponimo, String cap) {
		int outValue = -1;
	  	this.session = HibernateUtil.getSessionFactory().getCurrentSession();
        session.beginTransaction();
        
        Criteria criteria = session.createCriteria(Cap.class);
        criteria.setProjection(Projections.rowCount());
        
		  if (comune != null) {
			  criteria.add( Restrictions.or(
		                Restrictions.like("comu", "%" + comune.toUpperCase() + "%"),
		                Restrictions.like("fraz", "%" + comune.toUpperCase() + "%")));
		  }
		  if (provincia != null) {
			  criteria.add(Restrictions.eq("prov", provincia.toUpperCase()));
	      }
		  if (toponimo != null) {
			  criteria.add(Restrictions.like("topo", "%" + toponimo.toUpperCase() + "%"));
	      }
		  if (cap != null) {
			  criteria.add(Restrictions.like("capi", "%" + cap + "%"));
	      }
          outValue = ((Integer) criteria.list().get(0)).intValue();
          
          logger.debug("Total=" + outValue);
          session.getTransaction().commit();
	      return outValue;
	}
	  	
	public List<Cap> getElenco(String comune, String provincia, String toponimo, String cap) throws SQLException {
		this.session = HibernateUtil.getSessionFactory().getCurrentSession();
		this.session.beginTransaction();

        Criteria criteria = this.session.createCriteria(Cap.class);
        
		if (comune != null) {
			  criteria.add( Restrictions.or(
		                Restrictions.like("comu", "%" + comune.toUpperCase() + "%"),
		                Restrictions.like("fraz", "%" + comune.toUpperCase() + "%")));
		}
		if (provincia != null) {
			  criteria.add(Restrictions.eq("prov", provincia.toUpperCase()));
	    }
		  if (toponimo != null) {
			  criteria.add(Restrictions.like("topo", "%" + toponimo.toUpperCase() + "%"));
	      }
		  if (cap != null) {
			  criteria.add(Restrictions.like("capi", "%" + cap + "%"));
	      }
		  
		  List<Cap> l = (List<Cap>) criteria.list();
		  
		  this.session.getTransaction().commit();

          logger.debug("Total=" + l.size());
		  
		  return l;
    }
    
    public List<String> getElencoProvince() throws CapDAOException {
    	List<String> out; 
		try {
	        this.session = HibernateUtil.getSessionFactory().getCurrentSession();
	        this.session.beginTransaction();

	        Criteria criteria = this.session.createCriteria(Cap.class);
	        criteria.addOrder(Order.asc("prov"));
	        criteria.setProjection( Projections.projectionList() 
	        						.add( Projections.groupProperty("prov"), "prov"));	        
	        
	        out = criteria.list();
	        
			this.session.getTransaction().commit();
	        
	        logger.debug("Total=" + out.size());
		} catch (Throwable t) {
			throw new CapDAOException(t);
		}     	

		
		return out;
    }

}
--- TabCapDTO.java DELETED ---

--- NEW FILE: CapDAOException.java ---
/*
 * Copyright (C) 2007 Marco Ratto
 *
 * This file is part of the project trovacap-java.
 *
 * trovacap-java is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * any later version.
 *
 * trovacap-java is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with trovacap-java; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 */
package uk.co.marcoratto.jtrovacap.hsqldb;

public class CapDAOException extends Exception {

	public CapDAOException() {
	}

	public CapDAOException(String message) {
		super(message);
	}

	public CapDAOException(Throwable cause) {
		super(cause);
	}

	public CapDAOException(String message, Throwable cause) {
		super(message, cause);
	}

}

--- NEW FILE: Cap.java ---
/*
 * Copyright (C) 2007 Marco Ratto
 *
 * This file is part of the project trovacap-java.
 *
 * trovacap-java is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * any later version.
 *
 * trovacap-java is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with trovacap-java; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 */
package uk.co.marcoratto.jtrovacap.hsqldb;

/*
 * For Table TAB_CAP
 */
public class Cap {

    /* ID_CAP, PK */
    private long id;

    /* PROV_CAP */
    private String prov;

    /* COMU_CAP */
    private String comu;

    /* COM2_CAP */
    private String com2;

    /* FRAZ_CAP */
    private String fraz;

    /* FRA2_CAP */
    private String fra2;

    /* TOPO_CAP */
    private String topo;

    /* TOP2_CAP */
    private String top2;

    /* DUGT_CAP */
    private String dugt;

    /* NCIV_CAP */
    private String nciv;

    /* CAPI_CAP */
    private String capi;
    
    public Cap() {    	
    }

    /* ID_CAP, PK */
    public long getId() {
        return id;
    }

    public void setId(long l) {
        this.id = l;
    }
    
    /* PROV */
    public String getProv() {
        return prov;
    }

    /* PROV */
    public void setProv(String s) {
        this.prov = s;
    }

    /* COMU_CAP */
    public String getComu() {
        return comu;
    }

    /* COMU_CAP */
    public void setComu(String s) {
        this.comu = s;
    }

    /* COM2_CAP */
    public String getCom2() {
        return com2;
    }

    /* COM2_CAP */
    public void setCom2(String s) {
        this.com2 = s;
    }

    /* FRAZ_CAP */
    public String getFraz() {
        return fraz;
    }

    /* FRAZ_CAP */
    public void setFraz(String s) {
        this.fraz = s;
    }

    /* FRA2_CAP */
    public String getFra2() {
        return fra2;
    }

    /* FRA2_CAP */
    public void setFra2(String s) {
        this.fra2 = s;
    }

    /* TOPO_CAP */
    public String getTopo() {
        return topo;
    }

    /* TOPO_CAP */
    public void setTopo(String s) {
        this.topo = s;
    }

    /* TOP2_CAP */
    public String getTop2() {
        return top2;
    }

    /* TOP2_CAP */
    public void setTop2(String s) {
        this.top2 = s;
    }

    /* DUGT_CAP */
    public String getDugt() {
        return dugt;
    }

    /* DUGT_CAP */
    public void setDugt(String s) {
        this.dugt = s;
    }

    /* NCIV_CAP */
    public String getNciv() {
        return nciv;
    }

    /* NCIV_CAP */
    public void setNciv(String s) {
        this.nciv = s;
    }

    /* CAPI_CAP */
    public String getCapi() {
        return capi;
    }
    
    /* CAPI_CAP */
    public void setCapi(String s) {
        this.capi = s;
    }

}
--- NEW FILE: Cap.hbm.xml ---
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>

    <class name="uk.co.marcoratto.jtrovacap.hsqldb.Cap" table="CAP">
        <id name="id" column="ID">
            <generator class="assigned"/>
        </id>        
        <property name="prov" type="string"/>
        <property name="comu" type="string" column="COMU"/>
        <property name="com2" type="string" column="COM2"/>
        <property name="fraz" type="string" column="FRAZ"/>
        <property name="fra2" type="string" column="FRA2"/>
        <property name="topo" type="string" column="TOPO"/>
        <property name="top2" type="string" column="TOP2"/>
        <property name="dugt" type="string" column="DUGT"/>
        <property name="nciv" type="string" column="NCIV"/>
        <property name="capi" type="string" column="CAPI"/>        

    </class>

</hibernate-mapping>

[Trovacap-java-loginfo] jTrovaCap/java/uk/co/marcoratto/util HibernateUtil.java, NONE, 1.1

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/java/uk/co/marcoratto/util
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv26823/java/uk/co/marcoratto/util

Added Files:
	HibernateUtil.java 
Log Message:
Update to release 1.2

--- NEW FILE: HibernateUtil.java ---
/*
 * Copyright (C) 2007 Marco Ratto
 *
 * This file is part of the project trovacap-java.
 *
 * trovacap-java is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * any later version.
 *
 * trovacap-java is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with trovacap-java; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 */
package uk.co.marcoratto.util;

import org.apache.log4j.Logger;
import org.hibernate.*;
import org.hibernate.cfg.*;

public class HibernateUtil {

    private static final SessionFactory sessionFactory;
    
    private static Logger logger = Logger.getLogger("uk.co.marcoratto.jtrovacap");

    static {
        try {
            // Create the SessionFactory from hibernate.cfg.xml
            sessionFactory = new Configuration().configure().buildSessionFactory();            
        } catch (Throwable t) {
        	logger.error(t);
            throw new ExceptionInInitializerError(t);
        }
    }

    public static SessionFactory getSessionFactory() {
        return sessionFactory;
    }

}

[Trovacap-java-loginfo] jTrovaCap/java log4j.properties, NONE, 1.1 hibernate.cfg.xml, NONE, 1.1

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/java
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv26823/java

Added Files:
	log4j.properties hibernate.cfg.xml 
Log Message:
Update to release 1.2

--- NEW FILE: hibernate.cfg.xml ---
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

    <session-factory>

        <!-- Database connection settings -->
        <property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
        <property name="connection.url">jdbc:hsqldb:res:/hsqldb/trova_cap</property>
        <property name="connection.username">sa</property>
        <property name="connection.password"></property>

        <!-- JDBC connection pool (use the built-in) -->
        <property name="connection.pool_size">1</property>

        <!-- SQL dialect -->
        <property name="dialect">org.hibernate.dialect.HSQLDialect</property>

        <!-- Enable Hibernate's automatic session context management -->
        <property name="current_session_context_class">thread</property>

		<!--  
		
		-->
		<property name = "hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</property>
		
        <!-- Disable the second-level cache  -->
        <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

        <!-- Echo all executed SQL to stdout -->
        <property name="show_sql">true</property>

        <!-- Drop and re-create the database schema on startup 
        <property name="hbm2ddl.auto">create</property>
        -->

        <mapping resource="uk/co/marcoratto/jtrovacap/hsqldb/Cap.hbm.xml"/>

    </session-factory>

</hibernate-configuration>


--- NEW FILE: log4j.properties ---
### direct log messages to stdout ###
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### direct messages to file hibernate.log ###
#log4j.appender.file=org.apache.log4j.FileAppender
#log4j.appender.file.File=hibernate.log
#log4j.appender.file.layout=org.apache.log4j.PatternLayout
#log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### set log levels - for more verbose logging change 'info' to 'debug' ###

log4j.rootLogger=warn, stdout

#log4j.logger.org.hibernate=info
log4j.logger.org.hibernate=warn

### log HQL query parser activity
#log4j.logger.org.hibernate.hql.ast.AST=debug

### log just the SQL
#log4j.logger.org.hibernate.SQL=debug

### log JDBC bind parameters ###
log4j.logger.org.hibernate.type=warn
#log4j.logger.org.hibernate.type=debug

### log schema export/update ###
log4j.logger.org.hibernate.tool.hbm2ddl=warn

### log HQL parse trees
log4j.logger.org.hibernate.hql=warn

### log cache activity ###
log4j.logger.org.hibernate.cache=warn

### log transaction activity
log4j.logger.org.hibernate.transaction=warn

### log JDBC resource acquisition
log4j.logger.org.hibernate.jdbc=warn

### enable the following line if you want to track down connection ###
### leakages when using DriverManagerConnectionProvider ###
log4j.logger.org.hibernate.connection.DriverManagerConnectionProvider=warn

log4j.logger.uk.co.marcoratto.jtrovacap=warn, stdout

[Trovacap-java-loginfo] jTrovaCap/java/uk/co/marcoratto/util - New directory

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/java/uk/co/marcoratto/util
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv26617/java/uk/co/marcoratto/util

Log Message:
Directory /cvsroot/trovacap-java/jTrovaCap/java/uk/co/marcoratto/util added to the repository

[Trovacap-java-loginfo] jTrovaCap/test/uk/co/marcoratto/jtrovacap TestListProvince.java, 1.1, 1.2 TestCount.java, 1.1, 1.2 TestLists.java, 1.1, 1.2 TestAll.java, 1.1, 1.2

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/test/uk/co/marcoratto/jtrovacap
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv26414/test/uk/co/marcoratto/jtrovacap

Modified Files:
	TestListProvince.java TestCount.java TestLists.java 
	TestAll.java 
Log Message:
Update to release 1.2

Index: TestAll.java
===================================================================
RCS file: /cvsroot/trovacap-java/jTrovaCap/test/uk/co/marcoratto/jtrovacap/TestAll.java,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** TestAll.java	2 Jul 2008 09:55:51 -0000	1.1
--- TestAll.java	2 Jul 2008 14:12:50 -0000	1.2
***************
*** 1,2 ****
--- 1,21 ----
+ /*
+  * Copyright (C) 2007 Marco Ratto
+  *
+  * This file is part of the project trovacap-java.
+  *
+  * trovacap-java is free software; you can redistribute it and/or modify
+  * it under the terms of the GNU General Public License as published by
+  * the Free Software Foundation; either version 2 of the License, or
+  * any later version.
+  *
+  * trovacap-java is distributed in the hope that it will be useful,
+  * but WITHOUT ANY WARRANTY; without even the implied warranty of
+  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+  * GNU General Public License for more details.
+  *
+  * You should have received a copy of the GNU General Public License
+  * along with trovacap-java; if not, write to the Free Software
+  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+  */
  package uk.co.marcoratto.jtrovacap;
  

Index: TestCount.java
===================================================================
RCS file: /cvsroot/trovacap-java/jTrovaCap/test/uk/co/marcoratto/jtrovacap/TestCount.java,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** TestCount.java	2 Jul 2008 09:55:51 -0000	1.1
--- TestCount.java	2 Jul 2008 14:12:50 -0000	1.2
***************
*** 1,11 ****
  package uk.co.marcoratto.jtrovacap;
  
- import java.io.File;
- import java.util.List;
  
  import org.hibernate.Criteria;
- import org.hibernate.Hibernate;
  import org.hibernate.Session;
- import org.hibernate.criterion.Order;
  import org.hibernate.criterion.Projections;
  import org.hibernate.criterion.Restrictions;
--- 1,26 ----
+ /*
+  * Copyright (C) 2007 Marco Ratto
+  *
+  * This file is part of the project trovacap-java.
+  *
+  * trovacap-java is free software; you can redistribute it and/or modify
+  * it under the terms of the GNU General Public License as published by
+  * the Free Software Foundation; either version 2 of the License, or
+  * any later version.
+  *
+  * trovacap-java is distributed in the hope that it will be useful,
+  * but WITHOUT ANY WARRANTY; without even the implied warranty of
+  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+  * GNU General Public License for more details.
+  *
+  * You should have received a copy of the GNU General Public License
+  * along with trovacap-java; if not, write to the Free Software
+  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+  */
  package uk.co.marcoratto.jtrovacap;
  
  
  import org.hibernate.Criteria;
  import org.hibernate.Session;
  import org.hibernate.criterion.Projections;
  import org.hibernate.criterion.Restrictions;

Index: TestLists.java
===================================================================
RCS file: /cvsroot/trovacap-java/jTrovaCap/test/uk/co/marcoratto/jtrovacap/TestLists.java,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** TestLists.java	2 Jul 2008 09:55:51 -0000	1.1
--- TestLists.java	2 Jul 2008 14:12:50 -0000	1.2
***************
*** 1,12 ****
  package uk.co.marcoratto.jtrovacap;
  
- import java.io.File;
  import java.util.List;
  
  import org.hibernate.Criteria;
- import org.hibernate.Hibernate;
  import org.hibernate.Session;
  import org.hibernate.criterion.Order;
- import org.hibernate.criterion.Projections;
  import org.hibernate.criterion.Restrictions;
  
--- 1,28 ----
+ /*
+  * Copyright (C) 2007 Marco Ratto
+  *
+  * This file is part of the project trovacap-java.
+  *
+  * trovacap-java is free software; you can redistribute it and/or modify
+  * it under the terms of the GNU General Public License as published by
+  * the Free Software Foundation; either version 2 of the License, or
+  * any later version.
+  *
+  * trovacap-java is distributed in the hope that it will be useful,
+  * but WITHOUT ANY WARRANTY; without even the implied warranty of
+  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+  * GNU General Public License for more details.
+  *
+  * You should have received a copy of the GNU General Public License
+  * along with trovacap-java; if not, write to the Free Software
+  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+  */
  package uk.co.marcoratto.jtrovacap;
  
  import java.util.List;
  
  import org.hibernate.Criteria;
  import org.hibernate.Session;
  import org.hibernate.criterion.Order;
  import org.hibernate.criterion.Restrictions;
  

Index: TestListProvince.java
===================================================================
RCS file: /cvsroot/trovacap-java/jTrovaCap/test/uk/co/marcoratto/jtrovacap/TestListProvince.java,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** TestListProvince.java	2 Jul 2008 09:55:51 -0000	1.1
--- TestListProvince.java	2 Jul 2008 14:12:50 -0000	1.2
***************
*** 1,2 ****
--- 1,21 ----
+ /*
+  * Copyright (C) 2007 Marco Ratto
+  *
+  * This file is part of the project trovacap-java.
+  *
+  * trovacap-java is free software; you can redistribute it and/or modify
+  * it under the terms of the GNU General Public License as published by
+  * the Free Software Foundation; either version 2 of the License, or
+  * any later version.
+  *
+  * trovacap-java is distributed in the hope that it will be useful,
+  * but WITHOUT ANY WARRANTY; without even the implied warranty of
+  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+  * GNU General Public License for more details.
+  *
+  * You should have received a copy of the GNU General Public License
+  * along with trovacap-java; if not, write to the Free Software
+  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
+  */
  package uk.co.marcoratto.jtrovacap;
  

[Trovacap-java-loginfo] jTrovaCap/screenshots/jTrovaCap_v1.2 main.png, NONE, 1.1

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/screenshots/jTrovaCap_v1.2
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv26397/screenshots/jTrovaCap_v1.2

Added Files:
	main.png 
Log Message:
Update to release 1.2

--- NEW FILE: main.png ---
(This appears to be a binary file; contents omitted.)

[Trovacap-java-loginfo] jTrovaCap/screenshots/jTrovaCap_v1.2 - New directory

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/screenshots/jTrovaCap_v1.2
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv26378/screenshots/jTrovaCap_v1.2

Log Message:
Directory /cvsroot/trovacap-java/jTrovaCap/screenshots/jTrovaCap_v1.2 added to the repository

[Trovacap-java-loginfo] jTrovaCap/test/uk/co/marcoratto/jtrovacap TestListProvince.java, NONE, 1.1 TestCount.java, NONE, 1.1 TestLists.java, NONE, 1.1 TestAll.java, NONE, 1.1

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/test/uk/co/marcoratto/jtrovacap
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv17571/test/uk/co/marcoratto/jtrovacap

Added Files:
	TestListProvince.java TestCount.java TestLists.java 
	TestAll.java 
Log Message:
Update to release 1.2

--- NEW FILE: TestAll.java ---
package uk.co.marcoratto.jtrovacap;

import junit.framework.Test;
import junit.framework.TestSuite;

public class TestAll {

	public static void main (String[] args) {
		junit.swingui.TestRunner.run(TestAll.class);
		// junit.textui.TestRunner.run (suite());
	}

	public static Test suite ( ) {
		TestSuite suite = new TestSuite("JUnit Test All");		
		suite.addTest(TestListProvince.suite());
		suite.addTest(TestCount.suite());
		suite.addTest(TestLists.suite());		
	    return suite;
	}
}
--- NEW FILE: TestCount.java ---
package uk.co.marcoratto.jtrovacap;

import java.io.File;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Hibernate;
import org.hibernate.Session;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;

import uk.co.marcoratto.jtrovacap.hsqldb.Cap;
import uk.co.marcoratto.util.HibernateUtil;

import junit.framework.Test;
import junit.framework.TestCase;
import junit.framework.TestSuite;
import junit.textui.TestRunner;

/**
 * @author Marco Ratto
 *
 */
public class TestCount extends TestCase {

	private Session session;
		
	protected void setUp() {
		System.out.println(this.getName() + ".setUp()");		
	}

	protected void tearDown() {
		System.out.println(this.getName() + ".tearDown()");
	}

	public static void main (String[] args) {
		TestRunner.run(suite());
	}
	
	public static Test suite() {
		return new TestSuite(TestCount.class);
	}	
	
		
	public void testTotal1() {
		System.out.println(this.getClass().getName() + ".testTotal1()");
		try {
	        this.session = HibernateUtil.getSessionFactory().getCurrentSession();
	        session.beginTransaction();
	        
	        Criteria criteria = session.createCriteria(Cap.class);
	        criteria.add(Restrictions.eq("prov", "AG"));
	        criteria.setProjection(Projections.rowCount());
	        int actual = ((Integer) criteria.list().get(0)).intValue();
	        session.getTransaction().commit();	
	        
	        int expected = 57;
	       	assertEquals(expected, actual);
		} catch (Throwable t) {
			t.printStackTrace();
			fail(t.getMessage());
		} 
	}	
	
	
	public void testTotal2() {
		System.out.println(this.getClass().getName() + ".testTotal1()");
		try {
	        this.session = HibernateUtil.getSessionFactory().getCurrentSession();
	        session.beginTransaction();
	        
	        Criteria criteria = session.createCriteria(Cap.class);
	        criteria.add(Restrictions.like("comu", "%CHIVASSO%"));
	        criteria.setProjection(Projections.rowCount());
	        int actual = ((Integer) criteria.list().get(0)).intValue();
	        session.getTransaction().commit();	
	        
	        int expected = 4;
	       	assertEquals(expected, actual);
		} catch (Throwable t) {
			t.printStackTrace();
			fail(t.getMessage());
		} 
	}	
	

	public void testTotal3() {
		System.out.println(this.getClass().getName() + ".testTotal3()");
		try {
	        this.session = HibernateUtil.getSessionFactory().getCurrentSession();
	        session.beginTransaction();
	        
	        Criteria criteria = session.createCriteria(Cap.class);
	        criteria.add(Restrictions.like("capi", "%10034%"));
	        criteria.setProjection(Projections.rowCount());
	        int actual = ((Integer) criteria.list().get(0)).intValue();
	        session.getTransaction().commit();	
	        
	        int expected = 4;
	       	assertEquals(expected, actual);
		} catch (Throwable t) {
			t.printStackTrace();
			fail(t.getMessage());
		} 
	}
	

	public void testTotal4() {
		System.out.println(this.getClass().getName() + ".testTotal4()");
		try {
	        this.session = HibernateUtil.getSessionFactory().getCurrentSession();
	        session.beginTransaction();
	        
	        Criteria criteria = session.createCriteria(Cap.class);
	        criteria.add( Restrictions.or(
	                Restrictions.like("comu", "%torino%"),
	                Restrictions.like("fraz", "%%")));
	        criteria.add(Restrictions.like("prov", "%TO%"));
	        criteria.add(Restrictions.like("topo", "%CHIVASSO%"));
	        criteria.setProjection(Projections.rowCount());
	        int actual = ((Integer) criteria.list().get(0)).intValue();
	        session.getTransaction().commit();	
	        
	        int expected = 1;
	       	assertEquals(expected, actual);
		} catch (Throwable t) {
			t.printStackTrace();
			fail(t.getMessage());
		} 
	}	
	
}

--- NEW FILE: TestLists.java ---
package uk.co.marcoratto.jtrovacap;

import java.io.File;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Hibernate;
import org.hibernate.Session;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;

import uk.co.marcoratto.jtrovacap.hsqldb.Cap;
import uk.co.marcoratto.util.HibernateUtil;

import junit.framework.Test;
import junit.framework.TestCase;
import junit.framework.TestSuite;
import junit.textui.TestRunner;

/**
 * @author Marco Ratto
 *
 */
public class TestLists extends TestCase {

	private Session session;
		
	protected void setUp() {
		System.out.println(this.getName() + ".setUp()");		
	}

	protected void tearDown() {
		System.out.println(this.getName() + ".tearDown()");
	}

	public static void main (String[] args) {
		TestRunner.run(suite());
	}
	
	public static Test suite() {
		return new TestSuite(TestLists.class);
	}	
	
	public void testElenco1() {
		System.out.println(this.getClass().getName() + ".testElenco1()");
		try {
	        this.session = HibernateUtil.getSessionFactory().getCurrentSession();
	        session.beginTransaction();

	        Criteria criteria = this.session.createCriteria(Cap.class);
	        criteria.add(Restrictions.eq("prov", "AG"));
	        criteria.addOrder( Order.asc("comu"));
	        criteria.addOrder( Order.asc("fraz"));
	        List l = criteria.list();
	        int actual = l.size();
	        System.out.println(this.getClass().getName() + ".testElenco1():size=" + actual);
            for (int i = 0; i < l.size(); i++) {
            	Cap dto = (Cap) l.get(i);
                System.out.println(dto.getComu());
            }	        
	        session.getTransaction().commit();	
	        int expected = 57;
	        assertEquals(expected, actual);
		} catch (Throwable t) {
			t.printStackTrace();
			fail(t.getMessage());
		} 
	}	
	
	public void testElenco2() {
		System.out.println(this.getClass().getName() + ".testElenco2()");
		try {
	        this.session = HibernateUtil.getSessionFactory().getCurrentSession();
	        session.beginTransaction();

	        Criteria criteria = this.session.createCriteria(Cap.class);
	        criteria.add(Restrictions.like("comu", "%CHIVASSO%"));
	        criteria.addOrder( Order.asc("comu"));
	        criteria.addOrder( Order.asc("fraz"));	        
	        List l = criteria.list();
	        int actual = l.size();
	        System.out.println(this.getClass().getName() + ".testElenco2():size=" + actual);
            for (int i = 0; i < l.size(); i++) {
            	Cap dto = (Cap) l.get(i);
                System.out.println(dto.getFraz());
            }	        
	        session.getTransaction().commit();	
	        int expected = 4;
	        assertEquals(expected, actual);
		} catch (Throwable t) {
			t.printStackTrace();
			fail(t.getMessage());
		} 
	}	
	
	public void testElenco3() {
		System.out.println(this.getClass().getName() + ".testElenco3()");
		try {
	        this.session = HibernateUtil.getSessionFactory().getCurrentSession();
	        session.beginTransaction();

	        Criteria criteria = this.session.createCriteria(Cap.class);
	        criteria.add(Restrictions.like("capi", "%10034%"));
	        criteria.addOrder( Order.asc("comu"));
	        criteria.addOrder( Order.asc("fraz"));	        
	        List l = criteria.list();
	        int actual = l.size();
	        System.out.println(this.getClass().getName() + ".testElenco3():size=" + actual);
            for (int i = 0; i < l.size(); i++) {
            	Cap dto = (Cap) l.get(i);
                System.out.println(dto.getFraz());
            }	        
	        session.getTransaction().commit();	
	        int expected = 4;
	        assertEquals(expected, actual);
		} catch (Throwable t) {
			t.printStackTrace();
			fail(t.getMessage());
		} 
	}		
	
	public void testElenco4() {
		System.out.println(this.getClass().getName() + ".testElenco3()");
		try {
	        this.session = HibernateUtil.getSessionFactory().getCurrentSession();
	        session.beginTransaction();

	        Criteria criteria = this.session.createCriteria(Cap.class);
	        criteria.add( Restrictions.or(
	                Restrictions.like("comu", "%torino%"),
	                Restrictions.like("fraz", "%%")));
	        criteria.add(Restrictions.like("prov", "%TO%"));
	        criteria.add(Restrictions.like("topo", "%CHIVASSO%"));
	        criteria.addOrder( Order.asc("comu"));
	        criteria.addOrder( Order.asc("fraz"));	        
	        List l = criteria.list();
	        int actual = l.size();
	        System.out.println(this.getClass().getName() + ".testElenco3():size=" + actual);
            for (int i = 0; i < l.size(); i++) {
            	Cap dto = (Cap) l.get(i);
                System.out.println(dto.getCapi());
            }	        
	        session.getTransaction().commit();	
	        int expected = 1;
	        assertEquals(expected, actual);
		} catch (Throwable t) {
			t.printStackTrace();
			fail(t.getMessage());
		} 
	}	
	
}

--- NEW FILE: TestListProvince.java ---
package uk.co.marcoratto.jtrovacap;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Projections;

import uk.co.marcoratto.jtrovacap.hsqldb.Cap;
import uk.co.marcoratto.util.HibernateUtil;

import junit.framework.Test;
import junit.framework.TestCase;
import junit.framework.TestSuite;
import junit.textui.TestRunner;

/**
 * @author Marco Ratto
 *
 */
public class TestListProvince extends TestCase {

	private Session session;
		
	protected void setUp() {
		System.out.println(this.getName() + ".setUp()");		
	}

	protected void tearDown() {
		System.out.println(this.getName() + ".tearDown()");
	}

	public static void main (String[] args) {
		TestRunner.run(suite());
	}
	
	public static Test suite() {
		return new TestSuite(TestListProvince.class);
	}	
	
	public void testElencoProvince() {
		System.out.println(this.getClass().getName() + ".testList()");
		try {
	        this.session = HibernateUtil.getSessionFactory().getCurrentSession();
	        session.beginTransaction();

	        Criteria criteria = this.session.createCriteria(Cap.class);
	        criteria.addOrder(Order.asc("prov"));
	        criteria.setProjection( Projections.projectionList() 
	        						.add( Projections.groupProperty("prov"), "prov"));	  
	        
	        List l = criteria.list();
	        
	        int actual = l.size();
	        System.out.println(this.getClass().getName() + ".testList():size=" + actual);
            for (int i = 0; i < l.size(); i++) {
            	String s = (String) l.get(i);
                System.out.println(s);
            }	        
	        session.getTransaction().commit();	
	        
	        int expected = 108;
	        this.assertEquals(expected, actual);
		} catch (Throwable t) {
			t.printStackTrace();
			fail(t.getMessage());
		} 
	}	
			
}

[Trovacap-java-loginfo] jTrovaCap/test/uk/co/marcoratto - New directory

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/test/uk/co/marcoratto
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv17535/test/uk/co/marcoratto

Log Message:
Directory /cvsroot/trovacap-java/jTrovaCap/test/uk/co/marcoratto added to the repository

[Trovacap-java-loginfo] jTrovaCap/test/uk/co/marcoratto/jtrovacap - New directory

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/test/uk/co/marcoratto/jtrovacap
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv17535/test/uk/co/marcoratto/jtrovacap

Log Message:
Directory /cvsroot/trovacap-java/jTrovaCap/test/uk/co/marcoratto/jtrovacap added to the repository

[Trovacap-java-loginfo] jTrovaCap/test - New directory

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/test
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv17535/test

Log Message:
Directory /cvsroot/trovacap-java/jTrovaCap/test added to the repository

[Trovacap-java-loginfo] jTrovaCap/test/uk - New directory

[Marco R. <mar...@us...>]

Update of /cvsroot/trovacap-java/jTrovaCap/test/uk
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv17535/test/uk

Log Message:
Directory /cvsroot/trovacap-java/jTrovaCap/test/uk added to the repository