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
108
109
110
111
112
113
114
115
116
117
118
|
/*
Derby - Class org.apache.derbyTesting.functionTests.tests.lang.OptionalToolExample
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.lang;
import org.apache.derby.iapi.sql.dictionary.OptionalTool;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**
* <p>
* Simple OptionalTool.
* </p>
*/
public class OptionalToolExample implements OptionalTool
{
///////////////////////////////////////////////////////////////////////////////////
//
// CONSTANTS
//
///////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////
//
// STATE
//
///////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////
//
// CONSTRUCTOR
//
///////////////////////////////////////////////////////////////////////////////////
/** 0-arg constructor required by the OptionalTool contract */
public OptionalToolExample() {}
///////////////////////////////////////////////////////////////////////////////////
//
// OptionalTool BEHAVIOR
//
///////////////////////////////////////////////////////////////////////////////////
public void loadTool( String... configurationParameters )
throws SQLException
{ loadToolMinion( "toString" ); }
public void unloadTool( String... configurationParameters )
throws SQLException
{ unloadToolMinion( "toString" ); }
///////////////////////////////////////////////////////////////////////////////////
//
// MINIONS
//
///////////////////////////////////////////////////////////////////////////////////
protected void loadToolMinion( String functionName )
throws SQLException
{
getDerbyConnection().prepareStatement
(
"create function " + functionName + "( intVal int ) returns varchar( 32672 )\n" +
"language java parameter style java no sql\n" +
"external name 'java.lang.Integer.toString'"
).execute();
}
protected void unloadToolMinion( String functionName )
throws SQLException
{
getDerbyConnection().prepareStatement( "drop function " + functionName ).execute();
}
private Connection getDerbyConnection() throws SQLException
{
return DriverManager.getConnection( "jdbc:default:connection" );
}
///////////////////////////////////////////////////////////////////////////////////
//
// NESTED CLASS
//
///////////////////////////////////////////////////////////////////////////////////
public static final class VariableName extends OptionalToolExample
{
public void loadTool( String... configurationParameters )
throws SQLException
{ loadToolMinion( configurationParameters[ 0 ] ); }
public void unloadTool( String... configurationParameters )
throws SQLException
{ unloadToolMinion( configurationParameters[ 0 ] ); }
}
}
|
