protected override DbConnection CreateDbConnection()
{
DB2ConnectionStringBuilder connStrBuilder = new DB2ConnectionStringBuilder();
connStrBuilder.Server = HostExePath;
connStrBuilder.Database = Database;
connStrBuilder.UserID = DbUsername;
connStrBuilder.Password = DbPassword;
string connectionString = connStrBuilder.ConnectionString;
/*
* string connectionString = string.Format("Server={0};Database={1};UID={2};PASSWORD={3};", HostExePath, Database, DbUsername, DbPassword);
* if (Port != null && !Port.Equals(""))
* {
* connectionString = string.Format("Server={0};Database={1};Port={2};UID={3};PASSWORD={4};", HostExePath, Database, Port, DbUsername, DbPassword);
* }*/
DB2Connection connection = new DB2Connection(connectionString);
try
{
connection.Open();
}
catch (Exception ex)
{
Log(ex.Message);
return(null);
}
return(connection);
}
public void CrearTabla(string script)
{
TreeNode node = arbol.SelectedNode;
DB2ConnectionStringBuilder cn = new DB2ConnectionStringBuilder();
cn.UserID = "db2admin";
cn.Password = "******";
cn.Database = node.Parent.Text;
cn.Server = "localhost";
DB2Connection connect = new DB2Connection(cn.ToString());
string query = @"CREATE TABLE " + nombre_tabla.Text + "( " + script + ");";
try {
connect.Open();
DB2Command cmd = new DB2Command(query, connect);
cmd.ExecuteNonQuery();
TreeNode nodo = arbol.SelectedNode.Nodes.Add(nombre_tabla.Text);
nodo.ImageIndex = 2;
nodo.SelectedImageIndex = 2;
nodo.ContextMenuStrip = subMenus [2];
MessageBox.Show("Su tabla ha sido creada correctamente!");
this.Hide();
} catch (DB2Exception e) {
MessageBox.Show("Ha ocurrido un error al crear su tabla!\n" + e.Message);
}
connect.Close();
}
public static void Initialize()
{
var connectionString = ConfigurationManager.ConnectionStrings["TestDb"].ConnectionString;
var connectionBuilder = new DB2ConnectionStringBuilder(connectionString);
//connect to postgres database to create a new database
var databaseName = connectionBuilder.DBName;
connectionString = connectionBuilder.ToString();
using (var conn = new DB2Connection(connectionString))
{
conn.Open();
using (var cmd = new DB2Command())
{
cmd.CommandText = string.Format(@"
IF db_id('{0}') IS NULL
BEGIN
CREATE DATABASE {0}
END
", databaseName);
cmd.Connection = conn;
var result = cmd.ExecuteScalar();
}
DropTables(conn, databaseName);
}
}
private void button2_Click(object sender, EventArgs e)
{
DB2ConnectionStringBuilder cn = new DB2ConnectionStringBuilder();
cn.UserID = usuario.Text;
cn.Password = contrasena.Text;
cn.Database = name_db.Text;
cn.Server = server.Text;
DB2Connection connect = new DB2Connection(cn.ToString());
try {
connect.Open();
MessageBox.Show("Conexion Exitosa!\n" + "Version servidor: " + connect.ServerVersion + " Base de datos: " + connect.Database.ToString());
CrearConexion(cn.Database);
obtenerTablas(connect);
obtenerIndices(connect);
obtenerProcedimientos(connect);
obtenerFunciones(connect);
obtenerVistas(connect);
obtenerTriggers(connect);
obtenerChecks(connect);
obtenerUsuarios(connect);
obtenerPrimaryKeys(connect);
obtenerForeginKeys(connect);
this.Hide();
} catch (DB2Exception error) {
MessageBox.Show("A ocurrido un error!\n" + error.Message);
}
connect.Close();
}
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);
}
void IProvider.Initialize(IDataServices dataServices, object connection)
{
if (dataServices == null)
{
throw SqlClient.Error.ArgumentNull("dataServices");
}
DbConnection conn;
if (connection is string)
{
conn = new DB2Connection((string)connection);
}
else
{
conn = ((DbConnection)connection);
}
connectionString = conn.ConnectionString;
var builder = new DB2ConnectionStringBuilder(connectionString);
dbName = builder.Database;
if (string.IsNullOrEmpty(dbName))
{
dbName = dataServices.Model.DatabaseName;
}
if (string.IsNullOrEmpty(dbName))
{
throw SqlClient.Error.CouldNotDetermineCatalogName();
}
Initialize(dataServices, conn);
}
public DB2(Connection connectionInfo, int timeout)
{
var connBuilder = new DB2ConnectionStringBuilder();
if (!String.IsNullOrEmpty(connectionInfo.Port))
{
connBuilder.Server = String.Format("{0}:{1}", connectionInfo.Host, connectionInfo.Port);
//connBuilder["Server"] = String.Format("{0}:{1}", connectionInfo.Host, connectionInfo.Port);
}
else
{
connBuilder.Server = connectionInfo.Host;
//connBuilder["Server"] = connectionInfo.Host;
}
connBuilder.Database = connectionInfo.Database;
connBuilder.UserID = connectionInfo.UserName;
connBuilder.Password = connectionInfo.Password;
connBuilder.MaxPoolSize = Convert.ToInt32(connectionInfo.MaxConnections);
connBuilder.ConnectionLifeTime = timeout;
//connBuilder["Database"] = connectionInfo.Database;
//connBuilder["UID"] = connectionInfo.UserName;
//connBuilder["PWD"] = connectionInfo.Password;
//connBuilder["Max Pool Size"] = connectionInfo.MaxConnections;
//connBuilder["Connection Lifetime"] = timeout;
//throw new Exception(connBuilder.ToString());
this.Setup(connBuilder.ConnectionString, DB2Factory.Instance);
}
public void Refrescar(string db)
{
DB2ConnectionStringBuilder cn = new DB2ConnectionStringBuilder();
cn.UserID = "db2admin";
cn.Password = "******";
cn.Database = db;
cn.Server = "localhost";
DB2Connection connect = new DB2Connection(cn.ToString());
try {
connect.Open();
CrearConexion(cn.Database);
obtenerTablas(connect);
obtenerIndices(connect);
obtenerProcedimientos(connect);
obtenerFunciones(connect);
obtenerVistas(connect);
obtenerTriggers(connect);
obtenerChecks(connect);
obtenerUsuarios(connect);
obtenerPrimaryKeys(connect);
obtenerForeginKeys(connect);
} catch (DB2Exception error) {
MessageBox.Show("A ocurrido un error!\n" + error.Message);
}
connect.Close();
}
bool IProviderExtend.TableExists(MetaTable metaTable)
{
var builder = new DB2ConnectionStringBuilder(connectionString);
var sql = string.Format("SELECT COUNT(*) FROM SYSCAT.TABLES WHERE OWNER = '{0}' AND TABNAME = '{1}'", builder.UserID.ToUpper(), metaTable.TableName.ToUpper());
var count = services.Context.ExecuteQuery <int>(sql).SingleOrDefault();
return(count > 0);
}
public Db2SimpleConnectionStringBuilder([NotNull] DB2ConnectionStringBuilder connectionStringBuilder)
{
if (connectionStringBuilder == null)
{
throw new ArgumentNullException("connectionStringBuilder");
}
_connectionStringBuilder = connectionStringBuilder;
}
private string GetConnectionString(string dataBaseName)
{
var builder = new DB2ConnectionStringBuilder(connectionString)
{
Database = dataBaseName
};
return(builder.ConnectionString);
}
protected override string GetConnectionStringWithLoginInfo(string userName, string password)
{
DB2ConnectionStringBuilder builder = new DB2ConnectionStringBuilder(ConnectionString);
builder.UserID = userName;
builder.Password = password;
return(builder.ToString());
}
/// <inheritDoc />
protected override string BuildConnectionString(ReadOnlySpan <char> dsn, string user, string password, PhpArray options)
{
//TODO ibm db2 pdo parameters to dotnet connectionstring
var csb = new DB2ConnectionStringBuilder(dsn.ToString());
csb.UserID = user;
csb.Password = password;
return(csb.ConnectionString);
}
protected override void SetConnectionString(string value)
{
FConnectionString = value;
DB2ConnectionStringBuilder builder = new DB2ConnectionStringBuilder(value);
tbServer.Text = builder.Server;
tbUserName.Text = builder.UserID;
tbPassword.Text = builder.Password;
tbDatabase.Text = builder.Database;
}
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();
}
protected override string GetConnectionString()
{
DB2ConnectionStringBuilder builder = new DB2ConnectionStringBuilder(FConnectionString);
builder.Server = tbServer.Text;
builder.UserID = tbUserName.Text;
builder.Password = tbPassword.Text;
builder.Database = tbDatabase.Text;
return(builder.ToString());
}
public DB2Connection obtenerConexion(string usuario)
{
DB2ConnectionStringBuilder cn = new DB2ConnectionStringBuilder();
cn.UserID = "db2admin";
cn.Password = "******";
cn.Database = usuario;
cn.Server = "localhost";
DB2Connection connect = new DB2Connection(cn.ToString());
return(connect);
}
public static string GetConnectionString(this ConnectionInfo info)
{
var connectionStringBuilder = new DB2ConnectionStringBuilder {
ConnectionString = info.ConnectionString
};
if (!string.IsNullOrWhiteSpace(info.EncPassword))
{
connectionStringBuilder.Password = info.EncPassword;
}
return(connectionStringBuilder.ConnectionString);
}
public static void Clean()
{
var connectionString = ConfigurationManager.ConnectionStrings["TestDb"].ConnectionString;
var connectionBuilder = new DB2ConnectionStringBuilder(connectionString);
var databaseName = connectionBuilder.DBName;
using (var conn = new DB2Connection(connectionString))
{
conn.Open();
DropTables(conn, databaseName);
}
}
private void btnAdvanced_Click(object sender, EventArgs e)
{
using (AdvancedConnectionPropertiesForm form = new AdvancedConnectionPropertiesForm())
{
DB2ConnectionStringBuilder builder = new DB2ConnectionStringBuilder(ConnectionString);
form.AdvancedProperties = builder;
if (form.ShowDialog() == DialogResult.OK)
{
ConnectionString = form.AdvancedProperties.ToString();
}
}
}
/// <summary>
/// Main constructor
/// </summary>
/// <param name="serverName">Server name (host name).</param>
/// <param name="portNumber">Port number where the database can be accessed to.</param>
/// <param name="userId">User Id.</param>
/// <param name="passWord">Password.</param>
/// <param name="databaseName">Name of the dabase to connect to.</param>
/// <param name="persistSecurityInfo">Persist security information</param>
public DBConnectorDB2(string serverName, int portNumber, string userId, string passWord, string databaseName, bool persistSecurityInfo)
{
connectionString = new DB2ConnectionStringBuilder()
{
Database = databaseName,
Server = string.Concat(serverName, ":", portNumber.ToString()),
PersistSecurityInfo = persistSecurityInfo,
UserID = userId,
Password = passWord
};
Parameters = new List <DB2Parameter>();
ErrorList = new List <Error>();
}
public override DbConnectionStringBuilder GetConnectionStringBuilder(string connectionString = null)
{
var db2ConnectionStringBuilder = new DB2ConnectionStringBuilder(connectionString);
var isolationLevel = (string)db2ConnectionStringBuilder["IsolationLevel"];
if (isolationLevel.IsNullEmptyOrWhitespace())
{
db2ConnectionStringBuilder.IsolationLevel = "ReadUnCommitted";
}
db2ConnectionStringBuilder.QueryTimeout = 0;
db2ConnectionStringBuilder.BrowsableConnectionString = false;
return(db2ConnectionStringBuilder);
}
public ICustomActivityResult Execute()
{
DB2Connection con = null;
DB2DataAdapter adapter = null;
DataTable dt = new DataTable("resultSet");
try
{
DB2ConnectionStringBuilder cnb = new DB2ConnectionStringBuilder(ConnectionString);
if (!string.IsNullOrEmpty(UserName))
{
cnb.UserID = UserName;
cnb.Password = Password;
}
con = new DB2Connection(cnb.ConnectionString);
con.Open();
using (DB2Command command = new DB2Command(Query, con))
{
command.CommandType = System.Data.CommandType.Text;
command.CommandTimeout = Convert.ToInt32(TimeInSeconds);
adapter = new DB2DataAdapter(command);
adapter.Fill(dt);
}
return(this.GenerateActivityResult(dt));
}
finally
{
if (adapter != null)
{
adapter.Dispose();
}
adapter = null;
if (con != null)
{
con.Close();
con.Dispose();
}
con = null;
dt.Dispose();
dt = null;
}
}
public override string GetConnectionId()
{
DB2ConnectionStringBuilder builder = new DB2ConnectionStringBuilder(ConnectionString);
string info = "";
try
{
info = builder.Database;
}
catch
{
}
return("DB2: " + info);
}
private void GetDBObjectNames(string name, List <string> list)
{
DataTable schema = null;
using (DbConnection connection = GetConnection())
{
connection.Open();
DB2ConnectionStringBuilder builder = new DB2ConnectionStringBuilder(connection.ConnectionString);
schema = connection.GetSchema(name, new string[] { null, builder.UserID, null, null });
}
foreach (DataRow row in schema.Rows)
{
list.Add(row["TABLE_NAME"].ToString());
}
}
private void buttonConnect_Click(object sender, EventArgs e)
{
DB2ConnectionStringBuilder builder = new DB2ConnectionStringBuilder();
builder.Server = textboxServer.Text;
builder.Database = textboxDatabase.Text;
builder.UserID = textboxUser.Text;
if (textboxPassword.Text.Length > 0)
{
builder.Password = textboxPassword.Text;
}
this.ConnectionString = builder.ConnectionString;
}
/// <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;
}
}
public ICustomActivityResult Execute()
{
DB2Connection con = null;
DataTable dt = new DataTable("resultSet");
dt.Columns.Add("rowsAffected", typeof(string));
int rowsAffected = 0;
try
{
DB2ConnectionStringBuilder cnb = new DB2ConnectionStringBuilder(ConnectionString);
if (!string.IsNullOrEmpty(UserName))
{
cnb.UserID = UserName;
cnb.Password = Password;
}
con = new DB2Connection(cnb.ConnectionString);
con.Open();
using (DB2Command command = new DB2Command(Query, con))
{
command.CommandType = System.Data.CommandType.Text;
command.CommandTimeout = Convert.ToInt32(TimeInSeconds);
rowsAffected = command.ExecuteNonQuery();
}
dt.Rows.Add(rowsAffected);
return(this.GenerateActivityResult(dt));
}
finally
{
if (con != null)
{
con.Close();
con.Dispose();
}
con = null;
}
}
private void button1_Click(object sender, EventArgs e)
{
DB2ConnectionStringBuilder cn = new DB2ConnectionStringBuilder();
cn.UserID = usuario.Text;
cn.Password = contrasena.Text;
cn.Database = name_db.Text;
cn.Server = server.Text;
DB2Connection connect = new DB2Connection(cn.ToString());
try {
connect.Open();
//MessageBox.Show("Conexion Exitosa!\n" + "Version servidor: " + connect.ServerVersion + " Base de datos: " + connect.Database.ToString());
} catch (DB2Exception error) {
MessageBox.Show("A ocurrido un error!\n" + error.Message);
}
connect.Close();
}
