[Proxool-cvs] proxool/src/java-test/org/logicalcobwebs/proxool PropertyTest.java,NONE,1.1

[<bil...@us...>]

Update of /cvsroot/proxool/proxool/src/java-test/org/logicalcobwebs/proxool
In directory sc8-pr-cvs1:/tmp/cvs-serv29218/src/java-test/org/logicalcobwebs/proxool

Added Files:
	PropertyTest.java 
Log Message:
New test for delegate properties

--- NEW FILE: PropertyTest.java ---
/*
 * This software is released under a licence similar to the Apache Software Licence.
 * See org.logicalcobwebs.proxool.package.html for details.
 * The latest version is available at http://proxool.sourceforge.net
 */
package org.logicalcobwebs.proxool;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

/**
 * Tests whether {@link ConnectionPoolDefinition} recognises properties
 * properly
 * @version $Revision: 1.1 $, $Date: 2003/11/04 13:22:43 $
 * @author billhorsman
 * @author $Author: billhorsman $ (current maintainer)
 * @since Proxool 0.8.2
 */
public class PropertyTest extends AbstractProxoolTest {

    public PropertyTest(String alias) {
        super(alias);
    }

    /**
     * Test whether we are successfully passing properties onto the delegate driver. This
     * relies on a feature of Hypersonic 1.7.1 where ResultSetMetaData.isWritable() is
     * unsupported. The default behaviour, however, is just to return a value that maybe
     * incorrect but without throwing an exception. If you set the property jdbc.strict_md = true
     * then Hypersonic does throw an exception. This might change in future versions of Hypersonic
     * so we should keep an eye on this.
     * See <a href="http://hsqldb.sourceforge.net/doc/src/org/hsqldb/jdbcResultSet.html">http://hsqldb.sourceforge.net/doc/src/org/hsqldb/jdbcResultSet.html</a>
     */
    public void testDelegateProperty() throws Exception {

        String testName = "delegateProperty";
        String alias = testName;

        // Register pool
        String url = TestHelper.buildProxoolUrl(alias,
                TestConstants.HYPERSONIC_DRIVER,
                TestConstants.HYPERSONIC_TEST_URL);
        Properties info = new Properties();
        info.setProperty(ProxoolConstants.USER_PROPERTY, TestConstants.HYPERSONIC_USER);
        info.setProperty(ProxoolConstants.PASSWORD_PROPERTY, TestConstants.HYPERSONIC_PASSWORD);
        Connection c = null;
        try {
            c = DriverManager.getConnection(url, info);
            Statement s = c.createStatement();
            try {
                s.execute("drop table z");
            } catch (SQLException e) {
                // Probably because it doesn't exist.
            }
            s.execute("create table z (a int(4))");

            s.execute("select * from z");
            ResultSet rs = s.getResultSet();
            ResultSetMetaData rsmd = rs.getMetaData();
            // by default, this should work without error (even if the value returned is rubbish)
            rsmd.isWritable(1);
        } finally {
            if (c != null) {
                c.close();
                c = null;
            }
        }
        // And now test with the strict meta data
        info.setProperty("jdbc.strict_md", "true");
        try {
            c = DriverManager.getConnection(url, info);
            Statement s = c.createStatement();
            s.execute("select * from z");
            ResultSet rs = s.getResultSet();
            ResultSetMetaData rsmd = rs.getMetaData();
            try {
                rsmd.isWritable(1);
                fail("Expected isWritable() to throw unsupported exception");
            } catch (SQLException e) {
                // Expected an exception
            }
        } finally {
            if (c != null) {
                c.close();
            }
        }
    }
}
/*
 Revision history:
 $Log: PropertyTest.java,v $
 Revision 1.1  2003/11/04 13:22:43  billhorsman
 New test for delegate properties

  */