mondrian.olap4j
Class MondrianOlap4jConnection

java.lang.Object
  mondrian.olap4j.MondrianOlap4jConnection

All Implemented Interfaces:

java.sql.Connection, java.sql.Wrapper, OlapConnection, OlapWrapper

abstract class MondrianOlap4jConnection
extends java.lang.Object
implements OlapConnection

Implementation of OlapConnection for the Mondrian OLAP engine.

This class has sub-classes which implement JDBC 3.0 and JDBC 4.0 APIs; it is instantiated using Factory.newConnection(mondrian.olap4j.MondrianOlap4jDriver, java.lang.String, java.util.Properties).

Since:

May 23, 2007

Version:

$Id: //open/mondrian/src/main/mondrian/olap4j/MondrianOlap4jConnection.java#18 $

Author:

jhyde

Nested Class Summary

(package private) static class

MondrianOlap4jConnection.Helper Package-private helper class which encapsulates policies which are common throughout the driver.

Field Summary

(package private) Connection	connection Underlying mondrian connection.
(package private) MondrianOlap4jDriver	driver
(package private) Factory	factory
(package private) MondrianOlap4jConnection.Helper	helper Handler for errors.
(package private) static java.lang.String	LOCALDB_CATALOG_NAME The name of the sole catalog.
(package private) MondrianOlap4jSchema	olap4jSchema Current schema.
(package private) java.util.Map<Schema,MondrianOlap4jSchema>	schemaMap Map from mondrian schema objects to olap4j schemas.

Fields inherited from interface java.sql.Connection

TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE

Constructor Summary

MondrianOlap4jConnection(Factory factory, MondrianOlap4jDriver driver, java.lang.String url, java.util.Properties info)
Creates an Olap4j connection to Mondrian.

Method Summary

(package private) static boolean	acceptsURL(java.lang.String url)
void	clearWarnings()
void	close()
void	commit()
ScenarioImpl	createScenario()
OlapStatement	createStatement()
java.sql.Statement	createStatement(int resultSetType, int resultSetConcurrency)
java.sql.Statement	createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability)
boolean	getAutoCommit()
java.lang.String	getCatalog()
NamedList<Catalog>	getCatalogs()
int	getHoldability()
java.util.Locale	getLocale()
OlapDatabaseMetaData	getMetaData()
MdxParserFactory	getParserFactory()
java.lang.String	getRoleName()
Scenario	getScenario()
Schema	getSchema()
int	getTransactionIsolation()
java.util.Map<java.lang.String,java.lang.Class<?>>	getTypeMap()
java.sql.SQLWarning	getWarnings()
boolean	isClosed()
boolean	isReadOnly()
boolean	isWrapperFor(java.lang.Class<?> iface)
java.lang.String	nativeSQL(java.lang.String sql)
java.sql.CallableStatement	prepareCall(java.lang.String sql)
java.sql.CallableStatement	prepareCall(java.lang.String sql, int resultSetType, int resultSetConcurrency)
java.sql.CallableStatement	prepareCall(java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
PreparedOlapStatement	prepareOlapStatement(java.lang.String mdx)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int autoGeneratedKeys)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int[] columnIndexes)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
java.sql.PreparedStatement	prepareStatement(java.lang.String sql, java.lang.String[] columnNames)
void	releaseSavepoint(java.sql.Savepoint savepoint)
void	rollback()
void	rollback(java.sql.Savepoint savepoint)
void	setAutoCommit(boolean autoCommit)
void	setCatalog(java.lang.String catalog)
void	setHoldability(int holdability)
void	setLocale(java.util.Locale locale)
void	setReadOnly(boolean readOnly)
void	setRoleName(java.lang.String roleName)
java.sql.Savepoint	setSavepoint()
java.sql.Savepoint	setSavepoint(java.lang.String name)
void	setScenario(Scenario scenario)
void	setTransactionIsolation(int level)
void	setTypeMap(java.util.Map<java.lang.String,java.lang.Class<?>> map)
static java.util.Map<java.lang.String,java.lang.String>	toMap(java.util.Properties properties) Converts a Properties object to a Map with String keys and values.
(package private) MondrianOlap4jCube	toOlap4j(Cube cube)
(package private) MondrianOlap4jNamedSet	toOlap4j(Cube cube, NamedSet namedSet)
(package private) MondrianOlap4jDimension	toOlap4j(Dimension dimension)
(package private) ParseTreeNode	toOlap4j(Exp exp)
(package private) MondrianOlap4jHierarchy	toOlap4j(Hierarchy hierarchy)
(package private) MondrianOlap4jLevel	toOlap4j(Level level)
(package private) MondrianOlap4jMember	toOlap4j(Member member)
(package private) SelectNode	toOlap4j(Query query)
(package private) MondrianOlap4jSchema	toOlap4j(Schema schema)
(package private) Type	toOlap4j(Type type)
(package private) Type[]	toOlap4j(Type[] mondrianTypes)
<T> T	unwrap(java.lang.Class<T> iface)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface java.sql.Connection

createArrayOf, createBlob, createClob, createNClob, createSQLXML, createStruct, getClientInfo, getClientInfo, isValid, setClientInfo, setClientInfo

Field Detail

helper

final MondrianOlap4jConnection.Helper helper

Handler for errors.

connection

Connection connection

Underlying mondrian connection. Set on creation, cleared on close.

olap4jSchema

MondrianOlap4jSchema olap4jSchema

Current schema.

schemaMap

final java.util.Map<Schema,MondrianOlap4jSchema> schemaMap

Map from mondrian schema objects to olap4j schemas.

LOCALDB_CATALOG_NAME

static final java.lang.String LOCALDB_CATALOG_NAME

The name of the sole catalog.

See Also:

Constant Field Values

factory

final Factory factory

driver

final MondrianOlap4jDriver driver

Constructor Detail

MondrianOlap4jConnection

MondrianOlap4jConnection(Factory factory,
                         MondrianOlap4jDriver driver,
                         java.lang.String url,
                         java.util.Properties info)
                   throws java.sql.SQLException

Creates an Olap4j connection to Mondrian.

This method is intentionally package-protected. The public API uses the traditional JDBC DriverManager. See MondrianOlap4jDriver for more details.

Parameters:

factory - Factory

driver - Driver

url - Connect-string URL

info - Additional properties

Throws:

java.sql.SQLException - if there is an error

Pre-condition:

acceptsURL(url)

Method Detail

acceptsURL

static boolean acceptsURL(java.lang.String url)

createStatement

public OlapStatement createStatement()

Specified by:

createStatement in interface java.sql.Connection

Specified by:

createStatement in interface OlapConnection

createScenario

public ScenarioImpl createScenario()

Specified by:

createScenario in interface OlapConnection

setScenario

public void setScenario(Scenario scenario)

Specified by:

setScenario in interface OlapConnection

getScenario

public Scenario getScenario()

Specified by:

getScenario in interface OlapConnection

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql)
                                            throws java.sql.SQLException

Specified by:

prepareStatement in interface java.sql.Connection

Throws:

java.sql.SQLException

prepareCall

public java.sql.CallableStatement prepareCall(java.lang.String sql)
                                       throws java.sql.SQLException

Specified by:

prepareCall in interface java.sql.Connection

Throws:

java.sql.SQLException

nativeSQL

public java.lang.String nativeSQL(java.lang.String sql)
                           throws java.sql.SQLException

Specified by:

nativeSQL in interface java.sql.Connection

Throws:

java.sql.SQLException

setAutoCommit

public void setAutoCommit(boolean autoCommit)
                   throws java.sql.SQLException

Specified by:

setAutoCommit in interface java.sql.Connection

Throws:

java.sql.SQLException

getAutoCommit

public boolean getAutoCommit()
                      throws java.sql.SQLException

Specified by:

getAutoCommit in interface java.sql.Connection

Throws:

java.sql.SQLException

commit

public void commit()
            throws java.sql.SQLException

Specified by:

commit in interface java.sql.Connection

Throws:

java.sql.SQLException

rollback

public void rollback()
              throws java.sql.SQLException

Specified by:

rollback in interface java.sql.Connection

Throws:

java.sql.SQLException

close

public void close()
           throws java.sql.SQLException

Specified by:

close in interface java.sql.Connection

Throws:

java.sql.SQLException

isClosed

public boolean isClosed()
                 throws java.sql.SQLException

Specified by:

isClosed in interface java.sql.Connection

Throws:

java.sql.SQLException

getMetaData

public OlapDatabaseMetaData getMetaData()

Specified by:

getMetaData in interface java.sql.Connection

Specified by:

getMetaData in interface OlapConnection

getCatalogs

public NamedList<Catalog> getCatalogs()

Specified by:

getCatalogs in interface OlapConnection

setReadOnly

public void setReadOnly(boolean readOnly)
                 throws java.sql.SQLException

Specified by:

setReadOnly in interface java.sql.Connection

Throws:

java.sql.SQLException

isReadOnly

public boolean isReadOnly()
                   throws java.sql.SQLException

Specified by:

isReadOnly in interface java.sql.Connection

Throws:

java.sql.SQLException

setCatalog

public void setCatalog(java.lang.String catalog)
                throws java.sql.SQLException

Specified by:

setCatalog in interface java.sql.Connection

Throws:

java.sql.SQLException

getCatalog

public java.lang.String getCatalog()
                            throws java.sql.SQLException

Specified by:

getCatalog in interface java.sql.Connection

Throws:

java.sql.SQLException

setTransactionIsolation

public void setTransactionIsolation(int level)
                             throws java.sql.SQLException

Specified by:

setTransactionIsolation in interface java.sql.Connection

Throws:

java.sql.SQLException

getTransactionIsolation

public int getTransactionIsolation()
                            throws java.sql.SQLException

Specified by:

getTransactionIsolation in interface java.sql.Connection

Throws:

java.sql.SQLException

getWarnings

public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException

Specified by:

getWarnings in interface java.sql.Connection

Throws:

java.sql.SQLException

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException

Specified by:

clearWarnings in interface java.sql.Connection

Throws:

java.sql.SQLException

createStatement

public java.sql.Statement createStatement(int resultSetType,
                                          int resultSetConcurrency)
                                   throws java.sql.SQLException

Specified by:

createStatement in interface java.sql.Connection

Throws:

java.sql.SQLException

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                                   int resultSetType,
                                                   int resultSetConcurrency)
                                            throws java.sql.SQLException

Specified by:

prepareStatement in interface java.sql.Connection

Throws:

java.sql.SQLException

prepareCall

public java.sql.CallableStatement prepareCall(java.lang.String sql,
                                              int resultSetType,
                                              int resultSetConcurrency)
                                       throws java.sql.SQLException

Specified by:

prepareCall in interface java.sql.Connection

Throws:

java.sql.SQLException

getTypeMap

public java.util.Map<java.lang.String,java.lang.Class<?>> getTypeMap()
                                                              throws java.sql.SQLException

Specified by:

getTypeMap in interface java.sql.Connection

Throws:

java.sql.SQLException

setTypeMap

public void setTypeMap(java.util.Map<java.lang.String,java.lang.Class<?>> map)
                throws java.sql.SQLException

Specified by:

setTypeMap in interface java.sql.Connection

Throws:

java.sql.SQLException

setHoldability

public void setHoldability(int holdability)
                    throws java.sql.SQLException

Specified by:

setHoldability in interface java.sql.Connection

Throws:

java.sql.SQLException

getHoldability

public int getHoldability()
                   throws java.sql.SQLException

Specified by:

getHoldability in interface java.sql.Connection

Throws:

java.sql.SQLException

setSavepoint

public java.sql.Savepoint setSavepoint()
                                throws java.sql.SQLException

Specified by:

setSavepoint in interface java.sql.Connection

Throws:

java.sql.SQLException

setSavepoint

public java.sql.Savepoint setSavepoint(java.lang.String name)
                                throws java.sql.SQLException

Specified by:

setSavepoint in interface java.sql.Connection

Throws:

java.sql.SQLException

rollback

public void rollback(java.sql.Savepoint savepoint)
              throws java.sql.SQLException

Specified by:

rollback in interface java.sql.Connection

Throws:

java.sql.SQLException

releaseSavepoint

public void releaseSavepoint(java.sql.Savepoint savepoint)
                      throws java.sql.SQLException

Specified by:

releaseSavepoint in interface java.sql.Connection

Throws:

java.sql.SQLException

createStatement

public java.sql.Statement createStatement(int resultSetType,
                                          int resultSetConcurrency,
                                          int resultSetHoldability)
                                   throws java.sql.SQLException

Specified by:

createStatement in interface java.sql.Connection

Throws:

java.sql.SQLException

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                                   int resultSetType,
                                                   int resultSetConcurrency,
                                                   int resultSetHoldability)
                                            throws java.sql.SQLException

Specified by:

prepareStatement in interface java.sql.Connection

Throws:

java.sql.SQLException

prepareCall

public java.sql.CallableStatement prepareCall(java.lang.String sql,
                                              int resultSetType,
                                              int resultSetConcurrency,
                                              int resultSetHoldability)
                                       throws java.sql.SQLException

Specified by:

prepareCall in interface java.sql.Connection

Throws:

java.sql.SQLException

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                                   int autoGeneratedKeys)
                                            throws java.sql.SQLException

Specified by:

prepareStatement in interface java.sql.Connection

Throws:

java.sql.SQLException

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                                   int[] columnIndexes)
                                            throws java.sql.SQLException

Specified by:

prepareStatement in interface java.sql.Connection

Throws:

java.sql.SQLException

prepareStatement

public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
                                                   java.lang.String[] columnNames)
                                            throws java.sql.SQLException

Specified by:

prepareStatement in interface java.sql.Connection

Throws:

java.sql.SQLException

unwrap

public <T> T unwrap(java.lang.Class<T> iface)
         throws java.sql.SQLException

Specified by:

unwrap in interface java.sql.Wrapper

Specified by:

unwrap in interface OlapWrapper

Throws:

java.sql.SQLException

isWrapperFor

public boolean isWrapperFor(java.lang.Class<?> iface)
                     throws java.sql.SQLException

Specified by:

isWrapperFor in interface java.sql.Wrapper

Specified by:

isWrapperFor in interface OlapWrapper

Throws:

java.sql.SQLException

prepareOlapStatement

public PreparedOlapStatement prepareOlapStatement(java.lang.String mdx)
                                           throws OlapException

Specified by:

prepareOlapStatement in interface OlapConnection

Throws:

OlapException

getParserFactory

public MdxParserFactory getParserFactory()

Specified by:

getParserFactory in interface OlapConnection

getSchema

public Schema getSchema()
                 throws OlapException

Specified by:

getSchema in interface OlapConnection

Throws:

OlapException

toOlap4j

MondrianOlap4jCube toOlap4j(Cube cube)

toOlap4j

MondrianOlap4jDimension toOlap4j(Dimension dimension)

toOlap4j

MondrianOlap4jSchema toOlap4j(Schema schema)

toOlap4j

Type toOlap4j(Type type)

toOlap4j

MondrianOlap4jMember toOlap4j(Member member)

toOlap4j

MondrianOlap4jLevel toOlap4j(Level level)

toOlap4j

MondrianOlap4jHierarchy toOlap4j(Hierarchy hierarchy)

toOlap4j

Type[] toOlap4j(Type[] mondrianTypes)

toMap

public static java.util.Map<java.lang.String,java.lang.String> toMap(java.util.Properties properties)

Converts a Properties object to a Map with String keys and values.

Parameters:

properties - Properties

Returns:

Map backed by the given Properties object

toOlap4j

MondrianOlap4jNamedSet toOlap4j(Cube cube,
                                NamedSet namedSet)

toOlap4j

ParseTreeNode toOlap4j(Exp exp)

toOlap4j

SelectNode toOlap4j(Query query)

setLocale

public void setLocale(java.util.Locale locale)

Specified by:

setLocale in interface OlapConnection

getLocale

public java.util.Locale getLocale()

Specified by:

getLocale in interface OlapConnection

setRoleName

public void setRoleName(java.lang.String roleName)
                 throws OlapException

Specified by:

setRoleName in interface OlapConnection

Throws:

OlapException

getRoleName

public java.lang.String getRoleName()

Specified by:

getRoleName in interface OlapConnection