Package com.stimulsoft.report.dictionary.databases

Class StiJDBCDatabase

java.lang.Object

com.stimulsoft.base.serializing.StiSerializedObject

com.stimulsoft.base.services.StiService

com.stimulsoft.report.dictionary.databases.StiDatabase

com.stimulsoft.report.dictionary.databases.StiJDBCDatabase

All Implemented Interfaces:

IStiJsonReportObject, IStiSerializable, IStiSerializableRef, IStiName, ICloneable, IStiAlias, IStiInherited, Cloneable

Direct Known Subclasses:

StiDuckDbDatabase, StiMsSqlDatabase, StiMySqlDatabase, StiOracleDatabase, StiPostgreSQLDatabase, StiSqlDatabase

public class StiJDBCDatabase
extends StiDatabase

Field Summary

Fields inherited from class com.stimulsoft.base.services.StiService

properties

Fields inherited from interface com.stimulsoft.base.serializing.interfaceobject.IStiSerializableRef

REFERENCE_EMPTY, REFERENCE_REPORT

Constructor Summary

Constructors

Modifier	Constructor	Description
	StiJDBCDatabase()	Creates empty object.
protected	StiJDBCDatabase(String name, String connectionString)
protected	StiJDBCDatabase(String name, String alias, String connectionString)
	StiJDBCDatabase(String name, String url, String driver, String user, String password)
	StiJDBCDatabase(String name, String alias, String url, String driver, String user, String password)
	StiJDBCDatabase(String name, String alias, Connection con)

Method Summary

Modifier and Type	Method	Description
void	applyDatabaseInformation(StiDatabaseInformation information, StiReport report, StiDatabaseInformation informationAll)
void	connect(StiDataStoreSource source, Boolean fillTable, StiReport report)
StiSqlSource	createDataSource(String nameInSource, String name)
StiJDBCDatabase	createSqlConnector()
void	disconnect()
void	fillTable(StiDataStoreSource source)
protected StiAbstractAdapter	getAdapter(String connectionString)
StiAbstractAdapter	getAdapter2(String connectionString)
Connection	getConnection()
final String	getConnectionString()	Gets or sets a connection string which contains SQL connection parameters.
final String	getConnectionStringEncrypted()
DataTable	getData(DataTable dataTable, ResultSet rs)
DataTable	getData(DataTable dataTable, ResultSet rs, Boolean convertNull)
StiDatabaseInformation	getDatabaseInformation(Connection con, StiAbstractAdapter adapter, StiReport report)
String	getDatabaseSpecificName(String name)
String	getDriver()
String	getPassword()
final boolean	getPromptUserNameAndPassword()	Gets or sets a value which indicates that UserName and Password parameters should be requested from user.
static List<Object>	getQueryParameter(String query, Connection con, StiDataSource source)
String	getSampleConnectionString()
String	getServiceName()	Gets a service name.
String	getUrl()
String	getUser()
void	LoadFromJsonObject(JSONObject jObject)
static void	registerOutParameterOracle(Object pstmt, int index, int sqlType)
JSONObject	SaveToJsonObject(StiJsonSaveMode mode)
void	setConnection(Connection con)
final void	setConnectionString(String value)
final void	setConnectionStringEncrypted(String value)
void	setDriver(String driver)
void	setPassword(String password)
final void	setPromptUserNameAndPassword(boolean value)
void	setUrl(String url)
void	setUser(String user)
void	testConnection(Connection con, StiAbstractAdapter adapter)
String	toString()

Methods inherited from class com.stimulsoft.report.dictionary.databases.StiDatabase

clone, connect, createDataSources, edit, getAlias, getConnectedEvent, getConnectingEvent, getDisconnectedEvent, getDisconnectingEvent, getInherited, getKey, getName, getServiceCategory, getServiceType, getString, invokeConnected, invokeConnecting, invokeDisconnected, invokeDisconnecting, onConnected, onDisconnected, onDisconnecting, parsePath, regData, setAlias, setConnectedEvent, setConnectingEvent, setDisconnectedEvent, setDisconnectingEvent, setInherited, setKey, setName

Methods inherited from class com.stimulsoft.base.services.StiService

getProperties, getServiceEnabled, getServiceInfo, isPropertyPresent, MemberwiseClone, packService, properties, setProperties, setServiceEnabled

Methods inherited from class com.stimulsoft.base.serializing.StiSerializedObject

cleanReference, getReference, setReference

Methods inherited from class java.lang.Object

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

Constructor Details

StiJDBCDatabase

public StiJDBCDatabase()

Creates empty object.

StiJDBCDatabase

public StiJDBCDatabase(String name,
 String url,
 String driver,
 String user,
 String password)

Parameters:

name -

url -

driver -

user -

password -

StiJDBCDatabase

public StiJDBCDatabase(String name,
 String alias,
 String url,
 String driver,
 String user,
 String password)

Parameters:

name -

alias -

url -

driver -

user -

password -

StiJDBCDatabase

public StiJDBCDatabase(String name,
 String alias,
 Connection con)

StiJDBCDatabase

protected StiJDBCDatabase(String name,
 String connectionString)

StiJDBCDatabase

protected StiJDBCDatabase(String name,
 String alias,
 String connectionString)

Method Details

getConnection

public Connection getConnection()

Returns:

the con

getUrl

public String getUrl()

Returns:

the url

setUrl

public void setUrl(String url)

Parameters:

url - the url to set

setUser

public void setUser(String user)

getUser

public String getUser()

setPassword

public void setPassword(String password)

getPassword

public String getPassword()

getPromptUserNameAndPassword

public final boolean getPromptUserNameAndPassword()

Gets or sets a value which indicates that UserName and Password parameters should be requested from user.

setPromptUserNameAndPassword

public final void setPromptUserNameAndPassword(boolean value)

getConnectionString

public final String getConnectionString()

Gets or sets a connection string which contains SQL connection parameters.

setConnectionString

public final void setConnectionString(String value)

getConnectionStringEncrypted

public final String getConnectionStringEncrypted()
                                          throws NoSuchAlgorithmException

Throws:

NoSuchAlgorithmException

setConnectionStringEncrypted

public final void setConnectionStringEncrypted(String value)
                                        throws NoSuchAlgorithmException

Throws:

NoSuchAlgorithmException

getAdapter

protected StiAbstractAdapter getAdapter(String connectionString)

getServiceName

public String getServiceName()

Gets a service name.

Overrides:

getServiceName in class StiDatabase

connect

public void connect(StiDataStoreSource source,
 Boolean fillTable,
 StiReport report)
             throws StiException

Specified by:

connect in class StiDatabase

Throws:

StiException

fillTable

public void fillTable(StiDataStoreSource source)

getData

public DataTable getData(DataTable dataTable,
 ResultSet rs)
                  throws SQLException

Throws:

SQLException

getData

public DataTable getData(DataTable dataTable,
 ResultSet rs,
 Boolean convertNull)
                  throws SQLException

Throws:

SQLException

disconnect

public void disconnect()

Specified by:

disconnect in class StiDatabase

registerOutParameterOracle

public static void registerOutParameterOracle(Object pstmt,
 int index,
 int sqlType)

getQueryParameter

public static List<Object> getQueryParameter(String query,
 Connection con,
 StiDataSource source)
                                      throws SQLException

Throws:

SQLException

testConnection

public void testConnection(Connection con,
 StiAbstractAdapter adapter)
                    throws SQLException

Throws:

SQLException

getAdapter2

public StiAbstractAdapter getAdapter2(String connectionString)

getDatabaseInformation

public StiDatabaseInformation getDatabaseInformation(Connection con,
 StiAbstractAdapter adapter,
 StiReport report)

Overrides:

getDatabaseInformation in class StiDatabase

createDataSource

public StiSqlSource createDataSource(String nameInSource,
 String name)

applyDatabaseInformation

public void applyDatabaseInformation(StiDatabaseInformation information,
 StiReport report,
 StiDatabaseInformation informationAll)

Overrides:

applyDatabaseInformation in class StiDatabase

toString

public String toString()

Overrides:

toString in class StiDatabase

setConnection

public void setConnection(Connection con)

Parameters:

con - the con to set

getDriver

public String getDriver()

Returns:

the driver

getDatabaseSpecificName

public String getDatabaseSpecificName(String name)

setDriver

public void setDriver(String driver)

Parameters:

driver - the driver to set

LoadFromJsonObject

public void LoadFromJsonObject(JSONObject jObject)
                        throws JSONException

Specified by:

LoadFromJsonObject in interface IStiJsonReportObject

Overrides:

LoadFromJsonObject in class StiDatabase

Throws:

JSONException

SaveToJsonObject

public JSONObject SaveToJsonObject(StiJsonSaveMode mode)
                            throws JSONException

Specified by:

SaveToJsonObject in interface IStiJsonReportObject

Overrides:

SaveToJsonObject in class StiDatabase

Throws:

JSONException

createSqlConnector

public StiJDBCDatabase createSqlConnector()

getSampleConnectionString

public String getSampleConnectionString()