1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
|
/*
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);
}
}
|
