1
package org.hisp.dhis.importexport.dhis14.file.sqlmap;
4
* Copyright (c) 2004-2007, University of Oslo
7
* Redistribution and use in source and binary forms, with or without
8
* modification, are permitted provided that the following conditions are met:
9
* * Redistributions of source code must retain the above copyright notice, this
10
* list of conditions and the following disclaimer.
11
* * Redistributions in binary form must reproduce the above copyright notice,
12
* this list of conditions and the following disclaimer in the documentation
13
* and/or other materials provided with the distribution.
14
* * Neither the name of the HISP project nor the names of its contributors may
15
* be used to endorse or promote products derived from this software without
16
* specific prior written permission.
18
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
19
* ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
20
* WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
21
* DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR
22
* ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
23
* (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
24
* LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON
25
* ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
26
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
27
* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
30
import java.io.Reader;
31
import java.util.Properties;
33
import org.hisp.dhis.importexport.IbatisConfigurationManager;
35
import com.ibatis.common.resources.Resources;
36
import com.ibatis.sqlmap.client.SqlMapClient;
37
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
40
* @author Lars Helge Overland
41
* @version $Id: IbatisSqlMapClientProvider.java 5517 2008-08-04 14:59:27Z larshelg $
43
public class IbatisSqlMapClientProvider
44
implements SqlMapClientProvider
46
// -------------------------------------------------------------------------
48
// -------------------------------------------------------------------------
50
private static final String KEY_CONNECTION_URL = "ibatis.connection.url";
51
private static final String KEY_DATABASE_URL = "ibatis.connection.url.database";
52
private static final String VALUE_CONNECTION_URL = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=";
54
private String configurationFile;
56
public void setConfigurationFile( String configurationFile )
58
this.configurationFile = configurationFile;
61
// -------------------------------------------------------------------------
63
// -------------------------------------------------------------------------
65
private IbatisConfigurationManager configurationManager;
67
public void setConfigurationManager( IbatisConfigurationManager configurationManager )
69
this.configurationManager = configurationManager;
72
// -------------------------------------------------------------------------
73
// SqlMapClientProvider implementation
74
// -------------------------------------------------------------------------
76
public SqlMapClient getSqlMapClient()
80
Reader reader = Resources.getResourceAsReader( configurationFile );
82
SqlMapClient sqlMapClient = SqlMapClientBuilder.buildSqlMapClient( reader, getDatabaseProperties() );
86
catch ( Exception ex )
88
throw new RuntimeException( "Failed to create SqlMapClient", ex );
92
// -------------------------------------------------------------------------
94
// -------------------------------------------------------------------------
96
private Properties getDatabaseProperties()
98
Properties properties = configurationManager.getPropertiesConfiguration();
100
properties.setProperty( KEY_CONNECTION_URL, VALUE_CONNECTION_URL +
101
properties.getProperty( KEY_DATABASE_URL ) );