java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/InternationalConnectSimpleDSTest.java

/*
 
   Derby - Class org.apache.derbyTesting.functionTests.tests.jdbcapi.InternationalConnectSimpleDSTest
 
   Licensed to the Apache Software Foundation (ASF) under one or more
   contributor license agreements.  See the NOTICE file distributed with
   this work for additional information regarding copyright ownership.
   The ASF licenses this file to you under the Apache License, Version 2.0
   (the "License"); you may not use this file except in compliance with
   the License.  You may obtain a copy of the License at
 
      http://www.apache.org/licenses/LICENSE-2.0
 
   Unless required by applicable law or agreed to in writing, software
   distributed under the License is distributed on an "AS IS" BASIS,
   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   See the License for the specific language governing permissions and
   limitations under the License.
 
 */
package org.apache.derbyTesting.functionTests.tests.jdbcapi;

import java.io.File;
import java.sql.Connection;
import java.sql.SQLException;

import javax.sql.DataSource;

import junit.framework.Test;

import org.apache.derbyTesting.junit.BaseJDBCTestCase;
import org.apache.derbyTesting.junit.JDBCDataSource;
import org.apache.derbyTesting.junit.TestConfiguration;

public class InternationalConnectSimpleDSTest extends BaseJDBCTestCase {

    /**
     * Test chinese characters in 
     * - Database Name
     * - User 
     * - Password
     * This test runs with J2ME and tests only simple DataSource.
     * DriverManager, XADataSource and ConnectionPoolDataSource are tested with
     * InternationalConnectTests which runs on J2SE.
     */
  
    public InternationalConnectSimpleDSTest(String name) {
        super(name);
    }

    /**
     * Test Connection for chinese database name, user and password.
     * @throws SQLException
     */
    public void testSimpleDSConnect() throws SQLException {
        // Test chinese database name.
        DataSource ds = JDBCDataSource.getDataSource();
        JDBCDataSource.setBeanProperty(ds, "databaseName", "\u4e10");
        JDBCDataSource.setBeanProperty(ds, "createDatabase", "create");        
        try {
            Connection conn = ds.getConnection();
            conn.close();
        } catch (SQLException se ) {
            if (usingEmbedded())
                throw se;
            else
                assertSQLState("22005",se);
        }   
        // Chinese user
        try {
            JDBCDataSource.setBeanProperty(ds, "user", "\u4e10");
            Connection conn = ds.getConnection();
            conn.close();
        } catch (SQLException se ) {
            if (usingEmbedded())
                throw se;
            else
                assertSQLState("22005",se);
        } 
        // Chinese password
        try {
            JDBCDataSource.setBeanProperty(ds, "password", "\u4e10");            
            Connection conn = ds.getConnection();
            conn.close();
        } catch (SQLException se ) {
            if (usingEmbedded())
                throw se;
            else
                assertSQLState("22005",se);
        } 
    }
    
    public void tearDown() {
    	// Shutdown Derby before trying to remove the db.
    	// Because of  DERBY-4149, just shutting down the database
    	// is not good enough because it will fail and the 
    	// directory won't be removed.    	
        TestConfiguration.getCurrent().shutdownEngine();    	               
        removeDirectory(getSystemProperty("derby.system.home") +
                File.separator + "\u4e10");
    }
   
    public static Test suite() {
        return TestConfiguration.defaultSuite(InternationalConnectSimpleDSTest.class);
    }
    
}