[Squirrel-sql-commits] sql12/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/expanders SequenceParentExpander.java, 1.1, 1.2

[Rob M. <man...@us...>]

Update of /cvsroot/squirrel-sql/sql12/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/expanders
In directory sfp-cvsdas-3.v30.ch3.sourceforge.com:/tmp/cvs-serv30402/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/expanders

Modified Files:
	SequenceParentExpander.java 
Log Message:
Add debug logging to log the query used for sequence parent expanding.


Index: SequenceParentExpander.java
===================================================================
RCS file: /cvsroot/squirrel-sql/sql12/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/expanders/SequenceParentExpander.java,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** SequenceParentExpander.java	16 Feb 2009 22:52:45 -0000	1.1
--- SequenceParentExpander.java	25 Dec 2009 03:01:35 -0000	1.2
***************
*** 35,38 ****
--- 35,40 ----
  import net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData;
  import net.sourceforge.squirrel_sql.fw.sql.SQLUtilities;
+ import net.sourceforge.squirrel_sql.fw.util.log.ILogger;
+ import net.sourceforge.squirrel_sql.fw.util.log.LoggerController;
  
  /**
***************
*** 47,50 ****
--- 49,54 ----
  {
  
+ 	private final static ILogger s_log = LoggerController.createLogger(SequenceParentExpander.class);
+ 		
  	/**
  	 * The database-specific class that provides the query for "finding" sequences in a schema/catalog.
***************
*** 90,97 ****
  		final ObjFilterMatcher filterMatcher = new ObjFilterMatcher(session.getProperties());
  
! 		final PreparedStatement pstmt = conn.prepareStatement(extractor.getSequenceParentQuery());
  		ResultSet rs = null;
  		try
  		{
  			extractor.bindParameters(pstmt, parentDbinfo, filterMatcher);
  
--- 94,108 ----
  		final ObjFilterMatcher filterMatcher = new ObjFilterMatcher(session.getProperties());
  
! 		final String sequenceParentQuerySql = extractor.getSequenceParentQuery();
! 		if (s_log.isDebugEnabled()) {
! 			s_log.debug("createChildren: running sequence parent query for sequence children: "
! 				+ sequenceParentQuerySql);
! 		}
! 
! 		PreparedStatement pstmt = null;
  		ResultSet rs = null;
  		try
  		{
+ 			pstmt = conn.prepareStatement(sequenceParentQuerySql);		
  			extractor.bindParameters(pstmt, parentDbinfo, filterMatcher);