Re: [Springframework-developer] Rowsets and JdbcDaoSupport

[<tho...@tr...>]

Jonas,

For the database metadata there is a utility method that takes a
DatabaseMetaDataCallback implementation with a single method processMetaData. 
You need to catch the checked MetaDataAccessException.  There is no exception
translation since the translation would rely on the metadata to be available to
determine the database product.

Here is an example:

try {
  Map dbmdInfo = (Map) JdbcUtils.extractDatabaseMetaData(ds,
    new DatabaseMetaDataCallback() {
      public Object processMetaData(DatabaseMetaData dbmd) throws SQLException {
        Map info = new HashMap(2);
        if (dbmd != null) {
          info.put("DatabaseProductName", dbmd.getDatabaseProductName());
          info.put("DriverVersion", dbmd.getDriverVersion());
        }
        return info;
      }
    }
  );
}
catch (MetaDataAccessException ex) {
  logger.warn("Error while getting database metadata", ex);
}

Thomas


Quoting Jon...@o2...:

> What do you think about a generic addition? Like
>
>
> public interface ConnectionCallback
> {
>
>   Object doWithConnection(Connection conn)
>     throws
>       SQLException,
>       DataAccessException;
>
> }
>
> and accordingly in JdbcTemplate
>
>
> public Object execute(final ConnectionCallback action)
> {
>   ...
> }
>
>
> That would allow me to print/analyze/verify database metadata without
> caring for opening and closing the connection. And I could use my handmade
> rowset stuff. Of course, having explicit rowset support would be great!
>
> Regards,
> Jonas
>
>
>
>
>
>
>
>
> Thomas Risberg <tho...@tr...>
> Gesendet von: spr...@li...
> 08.07.2004 17:37
> Bitte antworten an springframework-developer
>
>
>         An:     spr...@li...
>         Kopie:
>         Thema:  Re: [Springframework-developer] Rowsets and JdbcDaoSupport
>
>
> Jonas,
>
> There is currently no support for RowSets.  We have some code in the
> sandbox that allows you to retrieve a cached rowset, but nothing for
> updating.  We might add this at some point since it would be fairly
> simple to add - probably a new method update(RowSet rset) on
> JdbcTemplate.  This might go in the 1.2 release since 1.1 is pretty much
> set with the 1.1 RC1 due out this weekend.  What is the demand for this
> support?
>
> Thomas
>
>
> Jon...@o2... wrote:
>
> >Dear spring developers,
> >
> >as my question was unanswered at the forum, I'm re-posting it here. Still
>
> >at the beginning of spring usage, thus very excited about its
> capabilities
> >and the code quality I saw so far :-)
> >
> >How to flush rowsets to the database without manually doing the
> connection
> >closing, transaction stuff etc., but using these nice callbacks instead?
> >
> >neither getJdbcTemplate().execute(..) nor getJdbcTemplate().update(..)
> >will work, as they assume me to create a java.sql.Statement resp. write
> >handcoded SQL update string...?
> >
> >The same applies to pure metdata handling, when I just want to read infos
>
> >from Connection without having statements and the like.
> >
> >To make it clear, this is how my code looks like, which I want to
> re-write
> >using callbacks:
> >
> ><code>
> >
> >public final class RowsetDAO
> >  extends JdbcDaoSupport
> >{
> >
> >...
> >
> >/**
> > * Saves the given disconnected rowset to the database.
> > *
> > * @param rowSet rowset to save
> > * @throws DataAccessException runtime exception on database error
> > * @throws NullPointerException if given rowset is null
> > */
> >public synchronized void saveMutableRowSet(CachedRowSet rowSet)
> >  throws
> >    NullPointerException,
> >    DataAccessException
> >{
> >  Connection conn;
> >
> >  if (rowSet==null)
> >  {
> >    throw new NullPointerException("Given mutable rowset to save must not
>
> >be null!");
> >  }
> >
> >  conn = getConnection();
> >
> >  try
> >  {
> >    LOG.debug("Saving rowset into table : " + rowSet.getTableName() );
> >    long startTime = System.currentTimeMillis();
> >
> >    rowSet.setUrl( conn.getMetaData().getURL() );
> > rowSet.setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED);
> >    rowSet.acceptChanges(conn);
> >    conn.commit();
> >
> >    long endTime = System.currentTimeMillis();
> >    LOG.debug("Executed SQL in : " + (endTime - startTime) + " ms");
> >  }
> >  catch (SQLException e)
> >  {
> >    LOG.error(e);
> >    try
> >    {
> >      conn.rollback();
> >    }
> >    catch (SQLException e1)
> >    {
> >      LOG.error("Could not rollback changes", e1);
> >    }
> >    throw getJdbcTemplate().getExceptionTranslator().translate(
> >      e.toString(),
> >      "saving mutable rowset",
> >      e
> >    );
> >  }
> >  finally
> >  {
> >    try
> >    {
> >      conn.close();
> >    }
> >    catch (SQLException e1)
> >    {
> >      LOG.error("Could not close connection", e1);
> >    }
> >  }
> >}
> >
> >...
> ></code>
> >
> >Jonas
> >
> >
> >
> >-------------------------------------------------------
> >This SF.Net email sponsored by Black Hat Briefings & Training.
> >Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
> >digital self defense, top technical experts, no vendor pitches,
> >unmatched networking opportunities. Visit www.blackhat.com
> >_______________________________________________
> >Springframework-developer mailing list
> >Spr...@li...
> >https://lists.sourceforge.net/lists/listinfo/springframework-developer
> >
> >
> >
> >
> >
>
>
>
> -------------------------------------------------------
> This SF.Net email sponsored by Black Hat Briefings & Training.
> Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
> digital self defense, top technical experts, no vendor pitches,
> unmatched networking opportunities. Visit www.blackhat.com
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>
>
>
> Jonas,
>
> There is currently no support for RowSets.  We have some code in the
> sandbox that allows you to retrieve a cached rowset, but nothing for
> updating.  We might add this at some point since it would be fairly
> simple to add - probably a new method update(RowSet rset) on
> JdbcTemplate.  This might go in the 1.2 release since 1.1 is pretty much
> set with the 1.1 RC1 due out this weekend.  What is the demand for this
> support?
>
> Thomas
>
>
>
>
> -------------------------------------------------------
> This SF.Net email sponsored by Black Hat Briefings & Training.
> Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
> digital self defense, top technical experts, no vendor pitches,
> unmatched networking opportunities. Visit www.blackhat.com
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>