xref: /AOO41X/main/connectivity/source/drivers/odbcbase/ODriver.cxx (revision cdf0e10c4e3984b49a9502b011690b615761d4a3)
1*cdf0e10cSrcweir /*************************************************************************
2*cdf0e10cSrcweir  *
3*cdf0e10cSrcweir  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
4*cdf0e10cSrcweir  *
5*cdf0e10cSrcweir  * Copyright 2000, 2010 Oracle and/or its affiliates.
6*cdf0e10cSrcweir  *
7*cdf0e10cSrcweir  * OpenOffice.org - a multi-platform office productivity suite
8*cdf0e10cSrcweir  *
9*cdf0e10cSrcweir  * This file is part of OpenOffice.org.
10*cdf0e10cSrcweir  *
11*cdf0e10cSrcweir  * OpenOffice.org is free software: you can redistribute it and/or modify
12*cdf0e10cSrcweir  * it under the terms of the GNU Lesser General Public License version 3
13*cdf0e10cSrcweir  * only, as published by the Free Software Foundation.
14*cdf0e10cSrcweir  *
15*cdf0e10cSrcweir  * OpenOffice.org is distributed in the hope that it will be useful,
16*cdf0e10cSrcweir  * but WITHOUT ANY WARRANTY; without even the implied warranty of
17*cdf0e10cSrcweir  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
18*cdf0e10cSrcweir  * GNU Lesser General Public License version 3 for more details
19*cdf0e10cSrcweir  * (a copy is included in the LICENSE file that accompanied this code).
20*cdf0e10cSrcweir  *
21*cdf0e10cSrcweir  * You should have received a copy of the GNU Lesser General Public License
22*cdf0e10cSrcweir  * version 3 along with OpenOffice.org.  If not, see
23*cdf0e10cSrcweir  * <http://www.openoffice.org/license.html>
24*cdf0e10cSrcweir  * for a copy of the LGPLv3 License.
25*cdf0e10cSrcweir  *
26*cdf0e10cSrcweir  ************************************************************************/
27*cdf0e10cSrcweir 
28*cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove
29*cdf0e10cSrcweir #include "precompiled_connectivity.hxx"
30*cdf0e10cSrcweir #include "odbc/ODriver.hxx"
31*cdf0e10cSrcweir #include "odbc/OConnection.hxx"
32*cdf0e10cSrcweir #include "odbc/OFunctions.hxx"
33*cdf0e10cSrcweir #include "odbc/OTools.hxx"
34*cdf0e10cSrcweir #include "connectivity/dbexception.hxx"
35*cdf0e10cSrcweir #include "resource/common_res.hrc"
36*cdf0e10cSrcweir #include "resource/sharedresources.hxx"
37*cdf0e10cSrcweir 
38*cdf0e10cSrcweir using namespace connectivity::odbc;
39*cdf0e10cSrcweir using namespace com::sun::star::uno;
40*cdf0e10cSrcweir using namespace com::sun::star::lang;
41*cdf0e10cSrcweir using namespace com::sun::star::beans;
42*cdf0e10cSrcweir using namespace com::sun::star::sdbc;
43*cdf0e10cSrcweir // --------------------------------------------------------------------------------
44*cdf0e10cSrcweir ODBCDriver::ODBCDriver(const ::com::sun::star::uno::Reference< ::com::sun::star::lang::XMultiServiceFactory >& _rxFactory)
45*cdf0e10cSrcweir 	:ODriver_BASE(m_aMutex)
46*cdf0e10cSrcweir 	,m_xORB(_rxFactory)
47*cdf0e10cSrcweir     ,m_pDriverHandle(SQL_NULL_HANDLE)
48*cdf0e10cSrcweir {
49*cdf0e10cSrcweir }
50*cdf0e10cSrcweir // --------------------------------------------------------------------------------
51*cdf0e10cSrcweir void ODBCDriver::disposing()
52*cdf0e10cSrcweir {
53*cdf0e10cSrcweir 	::osl::MutexGuard aGuard(m_aMutex);
54*cdf0e10cSrcweir 
55*cdf0e10cSrcweir 
56*cdf0e10cSrcweir 	for (OWeakRefArray::iterator i = m_xConnections.begin(); m_xConnections.end() != i; ++i)
57*cdf0e10cSrcweir 	{
58*cdf0e10cSrcweir 		Reference< XComponent > xComp(i->get(), UNO_QUERY);
59*cdf0e10cSrcweir 		if (xComp.is())
60*cdf0e10cSrcweir 			xComp->dispose();
61*cdf0e10cSrcweir 	}
62*cdf0e10cSrcweir 	m_xConnections.clear();
63*cdf0e10cSrcweir 
64*cdf0e10cSrcweir 	ODriver_BASE::disposing();
65*cdf0e10cSrcweir }
66*cdf0e10cSrcweir 
67*cdf0e10cSrcweir // static ServiceInfo
68*cdf0e10cSrcweir //------------------------------------------------------------------------------
69*cdf0e10cSrcweir rtl::OUString ODBCDriver::getImplementationName_Static(  ) throw(RuntimeException)
70*cdf0e10cSrcweir {
71*cdf0e10cSrcweir 	return rtl::OUString::createFromAscii("com.sun.star.comp.sdbc.ODBCDriver");
72*cdf0e10cSrcweir 		// this name is referenced in the configuration and in the odbc.xml
73*cdf0e10cSrcweir 		// Please take care when changing it.
74*cdf0e10cSrcweir }
75*cdf0e10cSrcweir 
76*cdf0e10cSrcweir typedef Sequence< ::rtl::OUString > SS;
77*cdf0e10cSrcweir //------------------------------------------------------------------------------
78*cdf0e10cSrcweir SS ODBCDriver::getSupportedServiceNames_Static(  ) throw (RuntimeException)
79*cdf0e10cSrcweir {
80*cdf0e10cSrcweir 	SS aSNS( 1 );
81*cdf0e10cSrcweir 	aSNS[0] = ::rtl::OUString::createFromAscii("com.sun.star.sdbc.Driver");
82*cdf0e10cSrcweir 	return aSNS;
83*cdf0e10cSrcweir }
84*cdf0e10cSrcweir 
85*cdf0e10cSrcweir //------------------------------------------------------------------
86*cdf0e10cSrcweir ::rtl::OUString SAL_CALL ODBCDriver::getImplementationName(  ) throw(RuntimeException)
87*cdf0e10cSrcweir {
88*cdf0e10cSrcweir 	return getImplementationName_Static();
89*cdf0e10cSrcweir }
90*cdf0e10cSrcweir 
91*cdf0e10cSrcweir //------------------------------------------------------------------
92*cdf0e10cSrcweir sal_Bool SAL_CALL ODBCDriver::supportsService( const ::rtl::OUString& _rServiceName ) throw(RuntimeException)
93*cdf0e10cSrcweir {
94*cdf0e10cSrcweir 	SS aSupported(getSupportedServiceNames());
95*cdf0e10cSrcweir 	const ::rtl::OUString* pSupported = aSupported.getConstArray();
96*cdf0e10cSrcweir 	const ::rtl::OUString* pEnd = pSupported + aSupported.getLength();
97*cdf0e10cSrcweir 	for (;pSupported != pEnd && !pSupported->equals(_rServiceName); ++pSupported)
98*cdf0e10cSrcweir 		;
99*cdf0e10cSrcweir 
100*cdf0e10cSrcweir 	return pSupported != pEnd;
101*cdf0e10cSrcweir }
102*cdf0e10cSrcweir 
103*cdf0e10cSrcweir //------------------------------------------------------------------
104*cdf0e10cSrcweir SS SAL_CALL ODBCDriver::getSupportedServiceNames(  ) throw(RuntimeException)
105*cdf0e10cSrcweir {
106*cdf0e10cSrcweir 	return getSupportedServiceNames_Static();
107*cdf0e10cSrcweir }
108*cdf0e10cSrcweir 
109*cdf0e10cSrcweir // --------------------------------------------------------------------------------
110*cdf0e10cSrcweir Reference< XConnection > SAL_CALL ODBCDriver::connect( const ::rtl::OUString& url, const Sequence< PropertyValue >& info ) throw(SQLException, RuntimeException)
111*cdf0e10cSrcweir {
112*cdf0e10cSrcweir 	if ( ! acceptsURL(url) )
113*cdf0e10cSrcweir 		return NULL;
114*cdf0e10cSrcweir 
115*cdf0e10cSrcweir 	if(!m_pDriverHandle)
116*cdf0e10cSrcweir 	{
117*cdf0e10cSrcweir 		::rtl::OUString aPath;
118*cdf0e10cSrcweir 		if(!EnvironmentHandle(aPath))
119*cdf0e10cSrcweir 			throw SQLException(aPath,*this,::rtl::OUString(),1000,Any());
120*cdf0e10cSrcweir 	}
121*cdf0e10cSrcweir 	OConnection* pCon = new OConnection(m_pDriverHandle,this);
122*cdf0e10cSrcweir 	Reference< XConnection > xCon = pCon;
123*cdf0e10cSrcweir 	pCon->Construct(url,info);
124*cdf0e10cSrcweir 	m_xConnections.push_back(WeakReferenceHelper(*pCon));
125*cdf0e10cSrcweir 
126*cdf0e10cSrcweir 	return xCon;
127*cdf0e10cSrcweir }
128*cdf0e10cSrcweir // --------------------------------------------------------------------------------
129*cdf0e10cSrcweir sal_Bool SAL_CALL ODBCDriver::acceptsURL( const ::rtl::OUString& url )
130*cdf0e10cSrcweir 		throw(SQLException, RuntimeException)
131*cdf0e10cSrcweir {
132*cdf0e10cSrcweir 	return (!url.compareTo(::rtl::OUString::createFromAscii("sdbc:odbc:"),10));
133*cdf0e10cSrcweir }
134*cdf0e10cSrcweir // --------------------------------------------------------------------------------
135*cdf0e10cSrcweir Sequence< DriverPropertyInfo > SAL_CALL ODBCDriver::getPropertyInfo( const ::rtl::OUString& url, const Sequence< PropertyValue >& /*info*/ ) throw(SQLException, RuntimeException)
136*cdf0e10cSrcweir {
137*cdf0e10cSrcweir 	if ( acceptsURL(url) )
138*cdf0e10cSrcweir 	{
139*cdf0e10cSrcweir 		::std::vector< DriverPropertyInfo > aDriverInfo;
140*cdf0e10cSrcweir 
141*cdf0e10cSrcweir 		Sequence< ::rtl::OUString > aBooleanValues(2);
142*cdf0e10cSrcweir         aBooleanValues[0] = ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "false" ) );
143*cdf0e10cSrcweir 		aBooleanValues[1] = ::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "true" ) );
144*cdf0e10cSrcweir 
145*cdf0e10cSrcweir 		aDriverInfo.push_back(DriverPropertyInfo(
146*cdf0e10cSrcweir 				::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("CharSet"))
147*cdf0e10cSrcweir 				,::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("CharSet of the database."))
148*cdf0e10cSrcweir 				,sal_False
149*cdf0e10cSrcweir 				,::rtl::OUString()
150*cdf0e10cSrcweir 				,Sequence< ::rtl::OUString >())
151*cdf0e10cSrcweir 				);
152*cdf0e10cSrcweir 		aDriverInfo.push_back(DriverPropertyInfo(
153*cdf0e10cSrcweir 				::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("UseCatalog"))
154*cdf0e10cSrcweir 				,::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Use catalog for file-based databases."))
155*cdf0e10cSrcweir 				,sal_False
156*cdf0e10cSrcweir 				,::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "false" ) )
157*cdf0e10cSrcweir 				,aBooleanValues)
158*cdf0e10cSrcweir 				);
159*cdf0e10cSrcweir 		aDriverInfo.push_back(DriverPropertyInfo(
160*cdf0e10cSrcweir 				::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("SystemDriverSettings"))
161*cdf0e10cSrcweir 				,::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Driver settings."))
162*cdf0e10cSrcweir 				,sal_False
163*cdf0e10cSrcweir 				,::rtl::OUString()
164*cdf0e10cSrcweir 				,Sequence< ::rtl::OUString >())
165*cdf0e10cSrcweir 				);
166*cdf0e10cSrcweir 		aDriverInfo.push_back(DriverPropertyInfo(
167*cdf0e10cSrcweir 				::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("ParameterNameSubstitution"))
168*cdf0e10cSrcweir 				,::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Change named parameters with '?'."))
169*cdf0e10cSrcweir 				,sal_False
170*cdf0e10cSrcweir 				,::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "false" ) )
171*cdf0e10cSrcweir 				,aBooleanValues)
172*cdf0e10cSrcweir 				);
173*cdf0e10cSrcweir 		aDriverInfo.push_back(DriverPropertyInfo(
174*cdf0e10cSrcweir 				::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("IgnoreDriverPrivileges"))
175*cdf0e10cSrcweir 				,::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Ignore the privileges from the database driver."))
176*cdf0e10cSrcweir 				,sal_False
177*cdf0e10cSrcweir 				,::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "false" ) )
178*cdf0e10cSrcweir 				,aBooleanValues)
179*cdf0e10cSrcweir 				);
180*cdf0e10cSrcweir 		aDriverInfo.push_back(DriverPropertyInfo(
181*cdf0e10cSrcweir 				::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("IsAutoRetrievingEnabled"))
182*cdf0e10cSrcweir 				,::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Retrieve generated values."))
183*cdf0e10cSrcweir 				,sal_False
184*cdf0e10cSrcweir 				,::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "false" ) )
185*cdf0e10cSrcweir 				,aBooleanValues)
186*cdf0e10cSrcweir 				);
187*cdf0e10cSrcweir 		aDriverInfo.push_back(DriverPropertyInfo(
188*cdf0e10cSrcweir 				::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("AutoRetrievingStatement"))
189*cdf0e10cSrcweir 				,::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Auto-increment statement."))
190*cdf0e10cSrcweir 				,sal_False
191*cdf0e10cSrcweir 				,::rtl::OUString()
192*cdf0e10cSrcweir 				,Sequence< ::rtl::OUString >())
193*cdf0e10cSrcweir 				);
194*cdf0e10cSrcweir 		aDriverInfo.push_back(DriverPropertyInfo(
195*cdf0e10cSrcweir 				::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("GenerateASBeforeCorrelationName"))
196*cdf0e10cSrcweir 				,::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Generate AS before table correlation names."))
197*cdf0e10cSrcweir 				,sal_False
198*cdf0e10cSrcweir 				,::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "true" ) )
199*cdf0e10cSrcweir 				,aBooleanValues)
200*cdf0e10cSrcweir 				);
201*cdf0e10cSrcweir 		aDriverInfo.push_back(DriverPropertyInfo(
202*cdf0e10cSrcweir 				::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("EscapeDateTime"))
203*cdf0e10cSrcweir 				,::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Escape date time format."))
204*cdf0e10cSrcweir 				,sal_False
205*cdf0e10cSrcweir 				,::rtl::OUString( RTL_CONSTASCII_USTRINGPARAM( "true" ) )
206*cdf0e10cSrcweir 				,aBooleanValues)
207*cdf0e10cSrcweir 				);
208*cdf0e10cSrcweir 
209*cdf0e10cSrcweir 		return Sequence< DriverPropertyInfo >(&aDriverInfo[0],aDriverInfo.size());
210*cdf0e10cSrcweir 	}
211*cdf0e10cSrcweir 	::connectivity::SharedResources aResources;
212*cdf0e10cSrcweir     const ::rtl::OUString sMessage = aResources.getResourceString(STR_URI_SYNTAX_ERROR);
213*cdf0e10cSrcweir     ::dbtools::throwGenericSQLException(sMessage ,*this);
214*cdf0e10cSrcweir 	return Sequence< DriverPropertyInfo >();
215*cdf0e10cSrcweir }
216*cdf0e10cSrcweir // --------------------------------------------------------------------------------
217*cdf0e10cSrcweir sal_Int32 SAL_CALL ODBCDriver::getMajorVersion(  ) throw(RuntimeException)
218*cdf0e10cSrcweir {
219*cdf0e10cSrcweir 	return 1;
220*cdf0e10cSrcweir }
221*cdf0e10cSrcweir // --------------------------------------------------------------------------------
222*cdf0e10cSrcweir sal_Int32 SAL_CALL ODBCDriver::getMinorVersion(  ) throw(RuntimeException)
223*cdf0e10cSrcweir {
224*cdf0e10cSrcweir 	return 0;
225*cdf0e10cSrcweir }
226*cdf0e10cSrcweir // --------------------------------------------------------------------------------
227*cdf0e10cSrcweir //-----------------------------------------------------------------------------
228*cdf0e10cSrcweir 
229*cdf0e10cSrcweir 
230