Re: [ebxmlms-general] Hermes and DB2

[Patrick Y. <kc...@ce...>]

Hello Christoph,

Basically, we can remove that option in our code. However, we need to do =
the regression test on our databases. Therefore, we may remove it in our =
next release. Meanwhile, please do the change for yourself first to make =
it work.

Thanks for pointing this out.

Regards, -Patrick

  ----- Original Message -----=20
  From: Chr...@ml...=20
  To: ebx...@li...=20
  Sent: Friday, March 12, 2004 5:22 PM
  Subject: [ebxmlms-general] Hermes and DB2


  Hello,

  I am evaluating Hermes v.0.9.3.1 on my WinXP using a DB2 V8 database =
on=20
  our DB server.=20
  The normal operation works fine.=20
  Now I wanted to test backup/restore and I got the error, that "scroll=20
  sensitive result sets" are not supported by my version of the DB2 jdbc =

  driver.

  I found, that this problem is caused by this part of =
DbTableManager.java:

      private static void backupTable(Connection connection, String=20
  tableName,
          String ddl, OutputStream os) throws DbTableManagerException {

          logger.debug("=3D> DbTableManager.backupTable (table: " + =
tableName
              + ")");

          try {
              // Query the table and set fetch size to 50 records per =
fetch
              Statement statement =3D connection.createStatement
                  (ResultSet.TYPE_SCROLL_SENSITIVE,=20
  ResultSet.CONCUR_READ_ONLY);    <=3D=3D=3D=3D=3D=3D=3D=3D unsupported =
in DB2 V7
              // statement.setFetchSize(50);
              ResultSet resultSet =3D statement.executeQuery
                  ("SELECT * FROM " + tableName);
              ResultSetMetaData resultSetMetaData =3D =
resultSet.getMetaData();
              int numColumns =3D resultSetMetaData.getColumnCount();

  The ResultSet.TYPE_SCROLL_SENSITIVE is not supported.

  Would it be possible to change this setting to =
ResultSet.TYPE_FORWARD_ONLY=20
  ?
  I believe, that no features are used, which would prevent this change.

  Bye
  Christoph=20

  Dr. Christoph Oberle
  MLP Lebensversicherung AG
  Mathematik / MLP Lebensversicherung AG
  Forum 7
  D-69126 Heidelberg
  Tel.: 06221/308-2683
  Fax: 06221/308-8111
  Mobil: 0172/7603343
  chr...@ml...






  -------------------------------------------------------
  This SF.Net email is sponsored by: IBM Linux Tutorials
  Free Linux tutorial presented by Daniel Robbins, President and CEO of
  GenToo technologies. Learn everything from fundamentals to system
  =
administration.http://ads.osdn.com/?ad_id=3D1470&alloc_id=3D3638&op=3Dcli=
ck
  _______________________________________________
  ebxmlms-general mailing list
  ebx...@li...
  https://lists.sourceforge.net/lists/listinfo/ebxmlms-general