Advertisement
Guest User

Untitled

a guest
Aug 30th, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.11 KB | None | 0 0
  1. <dependency org="net.sourceforge.jtds" name="jtds" rev="1.3.1" />
  2.  
  3. <Resource name="jdbc/jtds/sybase/somedb"
  4. auth="Container"
  5. type="javax.sql.DataSource"
  6. driverClassName="net.sourceforge.jtds.jdbc.Driver"
  7. url="jdbc:jtds:sybase://localhost:2501/somedb"
  8. username="someuser" password="somepassword"
  9. />
  10.  
  11. InitialContext cxt = new InitialContext();
  12. if ( cxt == null ) {
  13. throw new RuntimeException("Uh oh -- no context!");
  14. }
  15. DataSource ds = (DataSource) cxt.lookup( lookupName );
  16.  
  17. org.apache.tomcat.dbcp.dbcp2.BasicDataSource
  18.  
  19. Connection conn = ds.getConnection();
  20.  
  21. java.lang.AbstractMethodError
  22. net.sourceforge.jtds.jdbc.JtdsConnection.isValid(JtdsConnection.java:2833)
  23. org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:924)
  24. org.apache.tomcat.dbcp.dbcp2.PoolableConnection.validate(PoolableConnection.java:282)
  25. org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:359)
  26. org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2316)
  27. org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2299)
  28. org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2043)
  29. org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1543)
  30.  
  31. validationQuery="select 1"
  32.  
  33. /* (non-Javadoc)
  34. * @see java.sql.Connection#isValid(int)
  35. */
  36. public boolean isValid(int timeout) throws SQLException {
  37. // TODO Auto-generated method stub
  38. throw new AbstractMethodError();
  39. }
  40.  
  41. public void More ...validate(String sql, int timeout) throws SQLException {
  42. ...
  43. if (sql == null || sql.length() == 0) {
  44. ...
  45. if (!isValid(timeout)) {
  46. throw new SQLException("isValid() returned false");
  47. }
  48. return;
  49. }
  50. ...
  51. }
  52.  
  53. BasicDataSource ds = new BasicDataSource();
  54. ds.setUsername(user);
  55. ds.setPassword(getPassword());
  56. ds.setUrl(jdbcUrl);
  57. ds.setDriverClassName(driver);
  58. ds.setMaxTotal(10);
  59. ds.setValidationQuery("select 1"); //DBCP throws error without this query
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement