Commons Dbcp
  1. Commons Dbcp
  2. DBCP-143

[dbcp] SQLNestedException thrown by server causes client ClassNotFoundException.

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.0
    • Labels:
      None
    • Environment:

      Operating System: other
      Platform: Other

      Description

      This is a GUI client / application server / database server application.

      On the GUI client side, we see java.lang.ClassNotFoundException:
      org.apache.commons.dbcp.SQLNestedException.

      This happens when the database server is down, DBCP cannot connect to the
      database, and throws a org.apache.commons.dbcp.SQLNestedException.

      Our application server code sends the java.sql.SQLException it sees to the
      client via RMI.

      However, on the client, we have not provided commons-dbcp.jar.

      And I don't think we should - DBCP is server code.

      But, when the client does not have SQLNestedException's class file, the attempt
      to de-serialize it results in the ClassNotFoundException we've been seeing.

      Even old http://java.sun.com/j2se/1.3/docs/api/java/sql/SQLException.html has
      the facilities that SQLNestedExcepion offers: It is able to chain another
      SQLException to itself. So while SQLNestedException clearly causes problems, I
      don't understand what DBCP gains from it.

      What would we loose if it were scratched?

      1. DBCP-143.patch
        24 kB
        Dain Sundstrom

        Issue Links

          Activity

          Phil Steitz made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Mark Thomas made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Niall Pemberton made changes -
          Link This issue relates to DBCP-310 [ DBCP-310 ]
          Mark Thomas made changes -
          Fix Version/s 2.0 [ 12313721 ]
          Fix Version/s 1.4 [ 12312615 ]
          Dain Sundstrom made changes -
          Fix Version/s 1.4 [ 12312615 ]
          Fix Version/s 1.3 [ 12311977 ]
          Dain Sundstrom made changes -
          Attachment DBCP-143.patch [ 12362384 ]
          Phil Steitz made changes -
          Bugzilla Id 37181
          Fix Version/s 1.3 [ 12311977 ]
          Henri Yandell made changes -
          Project Commons [ 12310458 ] Commons Dbcp [ 12310469 ]
          Component/s Dbcp [ 12311109 ]
          Key COM-2498 DBCP-143
          Assignee Jakarta Commons Developers Mailing List [ commons-dev@jakarta.apache.org ]
          Affects Version/s unspecified [ 12311647 ]
          Henri Yandell made changes -
          Field Original Value New Value
          issue.field.bugzillaimportkey 37181 12342650
          Andreas Krüger created issue -

            People

            • Assignee:
              Unassigned
              Reporter:
              Andreas Krüger
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development