|
Style Intelligence v12.0 | ||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
java.lang.Objectinetsoft.uql.XDataSource
inetsoft.uql.jdbc.JDBCDataSource
public class JDBCDataSource
JDBC data source represents a SQL database. It records JDBC URL and driver class.
| Field Summary | |
|---|---|
static String |
ACCESS
Access data source. |
static int |
CATALOG_SCHEMA_OPTION
Table name option as catalog.schema.table. |
static String |
CLOUDSCAPE
Cloudscape jdbc data source. |
static String |
DB2
Db2 jdbc data source. |
static int |
DEFAULT_OPTION
|
static String |
HIVE
Hadoop Hive JDBC data source. |
static String |
INFORMIX
Informix jdbc data source. |
static String |
INGRES
Ingres jdbc data source. |
static int |
JDBC_ACCESS
Access data source. |
static int |
JDBC_CLOUDSCAPE
Cloudscape jdbc data source. |
static int |
JDBC_DB2
Db2 jdbc data source. |
static int |
JDBC_HIVE
Hadoop Hive JDBC data source. |
static int |
JDBC_INFORMIX
Informix jdbc data source. |
static int |
JDBC_INGRES
Ingres jdbc data source. |
static int |
JDBC_LUCIDDB
LucidDB jdbc data source. |
static int |
JDBC_MYSQL
My SQL jdbc data source. |
static int |
JDBC_OBIEE
Oracle BI data source. |
static int |
JDBC_ODBC
Normal jdbc odbc data source. |
static int |
JDBC_ORACLE
Oracle jdbc data source. |
static int |
JDBC_POSTGRESQL
PostgreSQL jdbc data source. |
static int |
JDBC_SQLANYWHERE
SQL anywhere jdbc data source. |
static int |
JDBC_SQLSERVER
SQL server data source. |
static int |
JDBC_SYBASE
Sybase jdbc data source. |
static String |
LUCIDDB
LucidDB jdbc data source. |
static String |
MYSQL
My SQL jdbc data source. |
static String |
OBIEE
Oracle BI data source. |
static String |
ODBC
Normal jdbc odbc data source. |
static String |
ORACLE
Oracle jdbc data source. |
static String |
POSTGRESQL
PostgreSQL jdbc data source. |
static int |
SCHEMA_OPTION
Table name option as schema.table. |
static String |
SQLANYWHERE
SQL anywhere jdbc data source. |
static String |
SQLSERVER
SQL server data source. |
static String |
SYBASE
Sybase jdbc data source. |
static int |
TABLE_OPTION
Table name option as table. |
| Fields inherited from class inetsoft.uql.XDataSource |
|---|
CORBA, DOMAIN_DB2, DOMAIN_NONE, DOMAIN_ORACLE, DOMAIN_SQL, DOMAIN_SQLSERVER, EJB, JDBC, OBJECT, SAP, SOAP, TEXT, XML, XMLA |
| Constructor Summary | |
|---|---|
JDBCDataSource()
Create a JDBC data source. |
|
| Method Summary | |
|---|---|
void |
addDatasource(JDBCDataSource datasource)
Add additional connection. |
boolean |
checkDatabaseType(int type)
Check if the database is a special type. |
boolean |
containDatasource(String name)
Check if additional connection exists. |
boolean |
equals(Object obj)
Check if equals another object. |
JDBCDataSource |
getBaseDatasource()
|
int |
getDatabaseType()
Get the database type. |
String |
getDatabaseTypeString()
|
JDBCDataSource |
getDataSource(String name)
Get additional datasource by special name. |
String[] |
getDataSourceNames()
Get names of additional connections. |
String |
getDefaultDatabase()
Get the default database name. |
int |
getDomainType()
Get the domain type associated with this datasource. |
String |
getDriver()
Get the JDBC driver class full name. |
String |
getIdentity()
Identity of an datasource. |
int |
getMaxCursor()
Get the max cursor number the database allow to proceed at the same time. |
UserVariable[] |
getParameters()
Get the data source connection parameters. |
String |
getPassword()
Get the used user password. |
String |
getProductName()
Get the used product id. |
String |
getProductVersion()
Get the product version. |
String[] |
getSystemCatalogs()
Get a list of the catalogs this datasource uses for system tables. |
String[] |
getSystemSchemas()
Get a list of the schemas this datasource uses for system tables. |
int |
getTableNameOption()
Get the table name option. |
int |
getTransactionIsolation()
Get the transaction isolation level. |
String |
getURL()
Get the JDBC URL of the JDBC data source. |
String |
getURL(boolean runtime)
Get the JDBC URL of the JDBC data source. |
String |
getUser()
Get the used user id. |
boolean |
isAnsiJoin()
Check whether to use the ANSI join syntax for inner and outer joins. |
boolean |
isMVEnabled()
Return if materialized view is allowed to create on this datasource. |
boolean |
isRequireLogin()
Check if this data soure requires user login. |
boolean |
isRequireSave()
Check if this data soure requires save user and password. |
void |
parseXML(Element root)
Parse the XML element that contains information on this data source. |
void |
removeDatasource(String name)
Remove additional connection. |
void |
renameDatasource(String oname,
String nname)
Rename additional datasource. |
void |
setAnsiJoin(boolean ansi)
Set whether to use the ANSI join syntax for inner and outer joins. |
void |
setBaseDatasource(JDBCDataSource base)
|
void |
setDatabaseType(int type)
Set the database type. |
void |
setDefaultDatabase(String dbname)
Set the default database name. |
void |
setDriver(String driver)
Set the JDBC driver class full name. |
void |
setMVEnabled(boolean enabled)
|
void |
setPassword(String password)
Set the user password. |
void |
setProductName(String product)
Set the product id. |
void |
setProductVersion(String version)
Set the product version. |
void |
setRequireLogin(boolean login)
Set whether this data source requires user login during connection. |
void |
setRequireSave(boolean save)
Set whether this data source requires save user and password. |
void |
setTableNameOption(int option)
Set the table name option. |
void |
setTransactionIsolation(int level)
Set the transaction isolation level. |
void |
setURL(String url)
Set the JDBC URL of the JDBC data source. |
void |
setUser(String user)
Set the user id. |
boolean |
supportsCancel()
Check if the specified data source supports cancel. |
void |
writeXML(PrintWriter writer)
Generate the XML segment to represent this data source. |
| Methods inherited from class inetsoft.uql.XDataSource |
|---|
addFolder, clone, getDescription, getFolders, getFullName, getName, getRuntimeValue, getType, hashCode, removeFolder, removeFolders, setDescription, setName, toString |
| Methods inherited from class java.lang.Object |
|---|
finalize, getClass, notify, notifyAll, wait, wait, wait |
| Field Detail |
|---|
public static final int JDBC_ODBC
public static final int JDBC_ORACLE
public static final int JDBC_SYBASE
public static final int JDBC_INFORMIX
public static final int JDBC_DB2
public static final int JDBC_MYSQL
public static final int JDBC_ACCESS
public static final int JDBC_SQLSERVER
public static final int JDBC_INGRES
public static final int JDBC_CLOUDSCAPE
public static final int JDBC_SQLANYWHERE
public static final int JDBC_POSTGRESQL
public static final int JDBC_LUCIDDB
public static final int JDBC_HIVE
public static final int JDBC_OBIEE
public static final String ODBC
public static final String ORACLE
public static final String SYBASE
public static final String INFORMIX
public static final String DB2
public static final String MYSQL
public static final String ACCESS
public static final String SQLSERVER
public static final String INGRES
public static final String CLOUDSCAPE
public static final String SQLANYWHERE
public static final String POSTGRESQL
public static final String LUCIDDB
public static final String HIVE
public static final String OBIEE
public static final int CATALOG_SCHEMA_OPTION
public static final int SCHEMA_OPTION
public static final int TABLE_OPTION
public static final int DEFAULT_OPTION
| Constructor Detail |
|---|
public JDBCDataSource()
| Method Detail |
|---|
public void setDriver(String driver)
public String getDriver()
public int getMaxCursor()
public void setURL(String url)
public String getURL()
public String getURL(boolean runtime)
public void setRequireLogin(boolean login)
public boolean isRequireLogin()
public void setRequireSave(boolean save)
public boolean isRequireSave()
public void setDefaultDatabase(String dbname)
public String getDefaultDatabase()
public void setUser(String user)
public String getUser()
public boolean supportsCancel()
public void setMVEnabled(boolean enabled)
public void setPassword(String password)
public String getPassword()
public void setProductName(String product)
public String getProductName()
public void setProductVersion(String version)
public String getProductVersion()
public void setTransactionIsolation(int level)
level - one of the constants defined in java.sql.Connection.public int getTransactionIsolation()
public void setTableNameOption(int option)
option - the selected table option.public int getTableNameOption()
public void setAnsiJoin(boolean ansi)
public boolean isAnsiJoin()
public boolean isMVEnabled()
isMVEnabled in class XDataSourcepublic void setDatabaseType(int type)
type - a constant represents the database type.public int getDatabaseType()
public String getDatabaseTypeString()
public int getDomainType()
getDomainType in class XDataSourcepublic boolean checkDatabaseType(int type)
type - a constant represents the database type.public UserVariable[] getParameters()
getParameters in class XDataSourcepublic boolean equals(Object obj)
XDataSource
equals in class XDataSource
public void parseXML(Element root)
throws Exception
parseXML in interface inetsoft.util.XMLSerializableparseXML in class XDataSourceExceptionpublic void writeXML(PrintWriter writer)
writeXML in interface inetsoft.util.XMLSerializablewriteXML in class XDataSourcepublic String[] getSystemSchemas()
public String[] getSystemCatalogs()
public boolean containDatasource(String name)
public void addDatasource(JDBCDataSource datasource)
public String[] getDataSourceNames()
public JDBCDataSource getDataSource(String name)
public void renameDatasource(String oname,
String nname)
public void removeDatasource(String name)
public void setBaseDatasource(JDBCDataSource base)
public JDBCDataSource getBaseDatasource()
public String getIdentity()
|
Copyright © 1996-2014 InetSoft Technology Corp. All Rights Reserved. | ||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||