mondrian.olap4j
Class MondrianOlap4jConnection

java.lang.Object
  extended by 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

Get Mondrian at SourceForge.net. Fast, secure and free Open Source software downloads