java.lang.AbstractMethodError: net.sourceforge.jtds.jdbc.ConnectionJDBC3.isValid(I)Z

JIRA | David Smith | 1 year ago
  1. 0

    Last night, I updated our Confluence installation from 5.7.4 to 5.8.4. After this, all instances of the sql-query macro display this error: Error rendering macro 'sql-query' : net.sourceforge.jtds.jdbc.ConnectionJDBC3.isValid(I)Z This issue appears for all instances I can find of the sql-query macro, with all our data sources. Our data sources are still defined in conf/server.xml, similarly to this: {{ <Resource name="jdbc/adisreportsnapshottool" auth="Container" type="javax.sql.DataSource" driverClassName="net.sourceforge.jtds.jdbc.Driver" url="jdbc:jtds:sqlserver://adisdb1.wustl.edu:1433/ReportSnapshotTool" username="webuser" password="redacted" maxActive="20" maxIdle="10" maxWait="-1" /> }} Here's the first few lines from the relevant part of atlassian-confluence.log (I can send the whole 450-line trace if needed): {{2015-07-10 13:40:10,290 ERROR [http-nio-8090-exec-11] [xhtml.view.macro.ViewMacroMarshaller] marshalInternal Error rendering macro: sql-query -- url: /display/%7Em.ahearn/Server+Lookup | userName: m.ahearn | action: viewpage | page: 23789716 java.lang.AbstractMethodError: net.sourceforge.jtds.jdbc.ConnectionJDBC3.isValid(I)Z at org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:913) at org.apache.tomcat.dbcp.dbcp2.PoolableConnection.validate(PoolableConnection.java:226) at org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:302) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2208) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2191) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1945) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1412) at org.swift.confluence.sql.SqlDataHelper.getDatabaseConnectionFromDatasource(SqlDataHelper.java:640) at org.swift.confluence.sql.SqlDataHelper.getDatabaseConnection(SqlDataHelper.java:492) at org.swift.confluence.sql.SqlDataHelper.process(SqlDataHelper.java:147) at org.swift.confluence.sql.SqlMacro.process(SqlMacro.java:227) at org.swift.confluence.sql.SqlMacro.execute(SqlMacro.java:174) at org.randombits.support.confluence.ConfluenceMacro.execute(ConfluenceMacro.java:65) }} Please let me know if there's any more information you need to track this issue down. Thanks!

    JIRA | 1 year ago | David Smith
    java.lang.AbstractMethodError: net.sourceforge.jtds.jdbc.ConnectionJDBC3.isValid(I)Z
  2. 0

    Last night, I updated our Confluence installation from 5.7.4 to 5.8.4. After this, all instances of the sql-query macro display this error: Error rendering macro 'sql-query' : net.sourceforge.jtds.jdbc.ConnectionJDBC3.isValid(I)Z This issue appears for all instances I can find of the sql-query macro, with all our data sources. Our data sources are still defined in conf/server.xml, similarly to this: {{ <Resource name="jdbc/adisreportsnapshottool" auth="Container" type="javax.sql.DataSource" driverClassName="net.sourceforge.jtds.jdbc.Driver" url="jdbc:jtds:sqlserver://adisdb1.wustl.edu:1433/ReportSnapshotTool" username="webuser" password="redacted" maxActive="20" maxIdle="10" maxWait="-1" /> }} Here's the first few lines from the relevant part of atlassian-confluence.log (I can send the whole 450-line trace if needed): {{2015-07-10 13:40:10,290 ERROR [http-nio-8090-exec-11] [xhtml.view.macro.ViewMacroMarshaller] marshalInternal Error rendering macro: sql-query -- url: /display/%7Em.ahearn/Server+Lookup | userName: m.ahearn | action: viewpage | page: 23789716 java.lang.AbstractMethodError: net.sourceforge.jtds.jdbc.ConnectionJDBC3.isValid(I)Z at org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:913) at org.apache.tomcat.dbcp.dbcp2.PoolableConnection.validate(PoolableConnection.java:226) at org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:302) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2208) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2191) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1945) at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1412) at org.swift.confluence.sql.SqlDataHelper.getDatabaseConnectionFromDatasource(SqlDataHelper.java:640) at org.swift.confluence.sql.SqlDataHelper.getDatabaseConnection(SqlDataHelper.java:492) at org.swift.confluence.sql.SqlDataHelper.process(SqlDataHelper.java:147) at org.swift.confluence.sql.SqlMacro.process(SqlMacro.java:227) at org.swift.confluence.sql.SqlMacro.execute(SqlMacro.java:174) at org.randombits.support.confluence.ConfluenceMacro.execute(ConfluenceMacro.java:65) }} Please let me know if there's any more information you need to track this issue down. Thanks!

    JIRA | 1 year ago | David Smith
    java.lang.AbstractMethodError: net.sourceforge.jtds.jdbc.ConnectionJDBC3.isValid(I)Z
  3. 0

    Webapp won't run uder Tomcat 8.0.23

    Stack Overflow | 1 year ago | Azu
    javax.servlet.ServletException: La ejecución del Servlet lanzó una excepción
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Some thing wrong with the setting Tomcat 7/HA-JDBC/SQLServer2000/Spring

    ha-jdbc | 3 years ago | seekey
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in ServletContext resource [/WEB-INF/spring/applicationContext.xml]: Invocation of init method failed; nested exception is java.lang.AbstractMethodError: net.sourceforge.jtds.jdbc.ConnectionJDBC3.isValid(I)Z
  6. 0

    Spring学习心得(二)——日志和数据库 - C++ - ITeye技术网站

    iteye.com | 1 year ago
    java.lang.AbstractMethodError: com.mysql.jdbc.Connection.isValid(I)Z

    6 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.lang.AbstractMethodError

      net.sourceforge.jtds.jdbc.ConnectionJDBC3.isValid(I)Z

      at org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.isValid()
    2. org.apache.tomcat
      BasicDataSource.getConnection
      1. org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:913)
      2. org.apache.tomcat.dbcp.dbcp2.PoolableConnection.validate(PoolableConnection.java:226)
      3. org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:302)
      4. org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2208)
      5. org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2191)
      6. org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1945)
      7. org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1412)
      7 frames
    3. org.swift.confluence
      SqlMacro.execute
      1. org.swift.confluence.sql.SqlDataHelper.getDatabaseConnectionFromDatasource(SqlDataHelper.java:640)
      2. org.swift.confluence.sql.SqlDataHelper.getDatabaseConnection(SqlDataHelper.java:492)
      3. org.swift.confluence.sql.SqlDataHelper.process(SqlDataHelper.java:147)
      4. org.swift.confluence.sql.SqlMacro.process(SqlMacro.java:227)
      5. org.swift.confluence.sql.SqlMacro.execute(SqlMacro.java:174)
      5 frames
    4. org.randombits.support
      ConfluenceMacro.execute
      1. org.randombits.support.confluence.ConfluenceMacro.execute(ConfluenceMacro.java:65)
      1 frame