Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <dependency org="net.sourceforge.jtds" name="jtds" rev="1.3.1" />
- <Resource name="jdbc/jtds/sybase/somedb"
- auth="Container"
- type="javax.sql.DataSource"
- driverClassName="net.sourceforge.jtds.jdbc.Driver"
- url="jdbc:jtds:sybase://localhost:2501/somedb"
- username="someuser" password="somepassword"
- />
- InitialContext cxt = new InitialContext();
- if ( cxt == null ) {
- throw new RuntimeException("Uh oh -- no context!");
- }
- DataSource ds = (DataSource) cxt.lookup( lookupName );
- org.apache.tomcat.dbcp.dbcp2.BasicDataSource
- Connection conn = ds.getConnection();
- java.lang.AbstractMethodError
- net.sourceforge.jtds.jdbc.JtdsConnection.isValid(JtdsConnection.java:2833)
- org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:924)
- org.apache.tomcat.dbcp.dbcp2.PoolableConnection.validate(PoolableConnection.java:282)
- org.apache.tomcat.dbcp.dbcp2.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:359)
- org.apache.tomcat.dbcp.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2316)
- org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2299)
- org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2043)
- org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1543)
- validationQuery="select 1"
- /* (non-Javadoc)
- * @see java.sql.Connection#isValid(int)
- */
- public boolean isValid(int timeout) throws SQLException {
- // TODO Auto-generated method stub
- throw new AbstractMethodError();
- }
- public void More ...validate(String sql, int timeout) throws SQLException {
- ...
- if (sql == null || sql.length() == 0) {
- ...
- if (!isValid(timeout)) {
- throw new SQLException("isValid() returned false");
- }
- return;
- }
- ...
- }
- BasicDataSource ds = new BasicDataSource();
- ds.setUsername(user);
- ds.setPassword(getPassword());
- ds.setUrl(jdbcUrl);
- ds.setDriverClassName(driver);
- ds.setMaxTotal(10);
- ds.setValidationQuery("select 1"); //DBCP throws error without this query
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement