public void SetUpFixture()
{
DB2ConnectionStringBuilder connectionStringBuilder = new DB2ConnectionStringBuilder();
connectionStringBuilder.ConnectionString = "Server=testserver:50000;Database=SAMPLE";
connectionStringBuilder.UserID = "db2admin";
connectionStringBuilder.Password = "******";
_connectionStringBuilder = connectionStringBuilder;
_connection = _connectionStringBuilder.Open();
}
public void SetUpFixture()
{
DB2ConnectionStringBuilder connectionStringBuilder = new DB2ConnectionStringBuilder();
connectionStringBuilder.ConnectionString = "Server=localhost:50000;Database=sample";
connectionStringBuilder.UserID = "db2inst1";
connectionStringBuilder.Password = "******";
_connectionStringBuilder = connectionStringBuilder;
_connection = _connectionStringBuilder.Open();
}
private bool disposed = false; //used for the Dispose method
#endregion Fields
#region Constructors
/// <summary>
/// Main constructor
/// </summary>
/// <param name="dataSource">Server name</param>
/// <param name="initialCatalog">Data base name</param>
/// <param name="userId">User Id</param>
/// <param name="passWord">Password</param>
/// <param name="persistSecurityInfo">Whether to keep password in memory or not</param>
/// <param name="queryTimeout">Time in seconds for query execution time before a timeout exception</param>
/// <param name="connectionTimeOut">Time in seconds for connection time before a timeout exception</param>
public DBConnectorDB2(string dataSource, string initialCatalog, string userId, string passWord,
bool persistSecurityInfo, int queryTimeout, int connectionTimeOut)
{
connectionString = new DB2ConnectionStringBuilder();
connectionString.Database = initialCatalog;
connectionString.allowDynamicSQL = true;
connectionString.QueryTimeout = queryTimeout;
connectionString.Server = dataSource;
connectionString.UserID = userId;
connectionString.Password = passWord;
connectionString.PersistSecurityInfo = persistSecurityInfo;
connectionString.Connect_Timeout = connectionTimeOut;
Parameters = new List<DB2Parameter>();
ErrorList = new List<Error>();
}
/// <summary>Damの選択</summary>
private void cmbDataProvider_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
// 初期は、無効にして、ODP.NET、HiRDB選択時のみ有効にする。
this.nudNumOfBind.Enabled = false;
if (this.cmbDataProvider.SelectedItem.ToString() == Literal.DAP_SQL)
{
//sqlClient
this._dam = new DamSqlSvr();
//接続文字列のサンプルを設定する（空の場合）。
SqlConnectionStringBuilder csb = new SqlConnectionStringBuilder();
csb.DataSource = this._ip;
csb.InitialCatalog = "Northwind";
csb.UserID = this._uid;
csb.Password = this._pwd;
this.txtCnnStr.Text = csb.ConnectionString;
// 状態
((ToolStripStatusLabel)this.statBar.Items[0]).Text = this.RM_GetString("STATUS_SQL_CREATED");
}
else if (this.cmbDataProvider.SelectedItem.ToString() == Literal.DAP_OLE)
{
//OLEDB.NET
this._dam = new DamOLEDB();
//接続文字列のサンプルを設定する（空の場合）。
OleDbConnectionStringBuilder csb = new OleDbConnectionStringBuilder();
csb.Provider = "Provider";
csb.DataSource = "DataSourceName";
csb.FileName = "FileName";
this.txtCnnStr.Text = csb.ConnectionString;
// 活性
this.nudNumOfBind.Enabled = true;
// 状態
((ToolStripStatusLabel)this.statBar.Items[0]).Text = this.RM_GetString("STATUS_OLE_CREATED");
}
if (this.cmbDataProvider.SelectedItem.ToString() == Literal.DAP_ODB)
{
//ODBC.NET
this._dam = new DamODBC();
//接続文字列のサンプルを設定する（空の場合）。
OdbcConnectionStringBuilder csb = new OdbcConnectionStringBuilder();
csb.Driver = "DriverName";
csb.Dsn = "DataSourceName";
this.txtCnnStr.Text = csb.ConnectionString;
// 活性
this.nudNumOfBind.Enabled = true;
// 状態
((ToolStripStatusLabel)this.statBar.Items[0]).Text = this.RM_GetString("STATUS_ODB_CREATED");
}
if (this.cmbDataProvider.SelectedItem.ToString() == Literal.DAP_ORA)
{
//Oracle Client
this._dam = new DamOraClient();
//接続文字列のサンプルを設定する（空の場合）。
System.Data.OracleClient.OracleConnectionStringBuilder csb = new System.Data.OracleClient.OracleConnectionStringBuilder();
csb.DataSource = this._ip + "/orcl";
csb.UserID = this._uid;
csb.Password = this._pwd;
this.txtCnnStr.Text = csb.ConnectionString;
// 活性
this.nudNumOfBind.Enabled = true;
// 状態
((ToolStripStatusLabel)this.statBar.Items[0]).Text = this.RM_GetString("STATUS_ODP_CREATED");
}
if (this.cmbDataProvider.SelectedItem.ToString() == Literal.DAP_ODP)
{
//ODP.NET
this._dam = new DamOraOdp();
//接続文字列のサンプルを設定する（空の場合）。
Oracle.DataAccess.Client.OracleConnectionStringBuilder csb = new Oracle.DataAccess.Client.OracleConnectionStringBuilder();
csb.DataSource = this._ip + "/orcl";
csb.UserID = this._uid;
csb.Password = this._pwd;
this.txtCnnStr.Text = csb.ConnectionString;
// 活性
this.nudNumOfBind.Enabled = true;
// 状態
((ToolStripStatusLabel)this.statBar.Items[0]).Text = this.RM_GetString("STATUS_ODP_CREATED");
}
else if (this.cmbDataProvider.SelectedItem.ToString() == Literal.DAP_DB2)
{
//DB2.NET
this._dam = new DamDB2();
//接続文字列のサンプルを設定する（空の場合）。
DB2ConnectionStringBuilder csb = new DB2ConnectionStringBuilder();
//csb.Server = this._ip + ":50000";
csb.Database = "SAMPLE";
csb.UserID = this._uid;
csb.Password = this._pwd;
this.txtCnnStr.Text = csb.ConnectionString;
// 状態
((ToolStripStatusLabel)this.statBar.Items[0]).Text = this.RM_GetString("STATUS_DB2_CREATED");
}
//else if (this.cmbDataProvider.SelectedItem.ToString() == Literal.DAP_HiRDB)
//{
// //HiRDBデータ プロバイダ
// this._dam = new DamHiRDB();
// //接続文字列のサンプルを設定する（空の場合）。
// //HiRDBデータ プロバイダは、ConnectionStringBuilderがない。
// string csb = "";
// csb += "DataSource=C:\\Windows\\HiRDB.ini;";
// csb += "UID=" + this._uid + ";";
// csb += "PWD=" + this._pwd + ";";
// this.txtCnnStr.Text = csb;
// // 活性
// this.nudNumOfBind.Enabled = true;
// // 状態
// ((ToolStripStatusLabel)this.statBar.Items[0]).Text = Literal.STATUS_HRD_CREATED;
//}
else if (this.cmbDataProvider.SelectedItem.ToString() == Literal.DAP_MySQL)
{
//MySQL Connector/NET
this._dam = new DamMySQL();
//接続文字列のサンプルを設定する（空の場合）。
MySqlConnectionStringBuilder csb = new MySqlConnectionStringBuilder();
csb.Server = this._ip;
csb.Database = "test";
csb.UserID = this._uid;
csb.Password = this._pwd;
this.txtCnnStr.Text = csb.ConnectionString;
// 状態
((ToolStripStatusLabel)this.statBar.Items[0]).Text = this.RM_GetString("STATUS_MSL_CREATED");
}
else if (this.cmbDataProvider.SelectedItem.ToString() == Literal.DAP_PstgrS)
{
//Npgsql
this._dam = new DamPstGrS();
//接続文字列のサンプルを設定する（空の場合）。
//NpgsqlConnectionStringBuilderは、冗長な接続文字列を返すので使わない。
//NpgsqlConnectionStringBuilder csb = new NpgsqlConnectionStringBuilder();
string csb = "";
//csb.Host = this._ip;
//csb.Database = "postgres";
//csb.UserName = this._uid;
//csb.Password = this._pwd;
csb += "HOST=" + this._ip + ";";
csb += "DATABASE=postgres;";
csb += "UID=" + this._uid + ";";
csb += "PWD=" + this._pwd + ";";
this.txtCnnStr.Text = csb;
// 状態
((ToolStripStatusLabel)this.statBar.Items[0]).Text = this.RM_GetString("STATUS_PGS_CREATED");
}
else
{
//ありえない
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Main constructor
/// </summary>
/// <param name="connString">A connection string to the database</param>
public DBConnectorDB2(string connString)
{
connectionString = new DB2ConnectionStringBuilder(connString);
Parameters = new List<DB2Parameter>();
ErrorList = new List<Error>();
}
public void TestReliableConnection()
{
int retries = 0;
var retryStrategy = new RetryStrategy();
retryStrategy.MaxRetryCount = 1;
retryStrategy.Retrying += (sender, re) => { Console.WriteLine("Retrying. Attempt {0}", re.Attempt); retries++; };
try
{
DB2ConnectionStringBuilder connectionStringBuilder = new DB2ConnectionStringBuilder();
connectionStringBuilder.ConnectionString = "Server=testserver:9999;Database=SAMPLE";
connectionStringBuilder.UserID = "db2admin";
connectionStringBuilder.Password = "******";
using (var reliable = new ReliableConnection<DB2Connection>(connectionStringBuilder.ConnectionString, retryStrategy))
{
reliable.Open();
}
}
catch
{
}
Assert.AreEqual(1, retries);
}
/// <summary>
/// Overrides the native Didspose method
/// </summary>
/// <param name="disposing">True or False</param>
protected virtual void Dispose(bool disposing)
{
if (!disposed)
{
if (disposing)
{
// Clear all property values that maybe have been set
// when the class was instantiated
Clear();
connectionString.Clear();
connectionString = null;
}
// Indicate that the instance has been disposed.
disposed = true;
}
}