public static void Main()
{
SQLRConnection con = new SQLRConnection("sqlrserver", 9000, "/tmp/example.socket", "user", "password", 0, 1);
SQLRCursor cur = new SQLRCursor(con);
cur.setResultSetBufferSize(5);
cur.sendQuery("select * from my_table");
Boolean done = false;
UInt64 row = 0;
String field;
while (!done)
{
for (UInt32 col = 0; col< cur.colCount(); col++)
{
field = cur.getField(row, col);
if (field != null)
{
Console.Write(field);
Console.Write(",");
}
else
{
done = true;
}
}
Console.Write("\n");
row++;
}
cur.sendQuery("select * from my_other_table");
private SQLRCursor getCursor()
{
if (_sqlrcur == null)
{
_sqlrcur = new SQLRCursor(_sqlrelaycon.SQLRConnection);
if (_sqlrelaycon._columnnamecase == "upper")
{
_sqlrcur.upperCaseColumnNames();
}
else if (_sqlrelaycon._columnnamecase == "lower")
{
_sqlrcur.lowerCaseColumnNames();
}
_sqlrcur.setResultSetBufferSize(_sqlrelaycon._resultsetbuffersize);
if (_sqlrelaycon._dontgetcolumninfo)
{
_sqlrcur.dontGetColumnInfo();
}
if (_sqlrelaycon._nullsasnulls)
{
_sqlrcur.getNullsAsNulls();
}
}
return(_sqlrcur);
}
public static void Main()
{
SQLRConnection con = new SQLRConnection("sqlrserver", 9000, "/tmp/example.socket", "user", "password", 0, 1);
SQLRCursor cur = new SQLRCursor(con);
cur.executeQuery("create table images (image blob, description clob)");
Byte imagedata[40000];
public static void Main()
{
SQLRConnection con = new SQLRConnection("sqlrserver", 9000, "/tmp/example.socket", "user", "password", 0, 1);
SQLRCursor cur = new SQLRCursor(con);
cur.sendQuery("select * from my_table");
cur.sendQuery("select * from my_table");
public static void Main()
{
SQLRConnection con = new SQLRConnection("sqlrserver", 9000, "/tmp/example.socket", "user", "password", 0, 1);
SQLRCursor cur = new SQLRCursor(con);
cur.prepareQuery("select * from mytable where mycolumn>:value");
cur.inputBind("value", 1);
cur.executeQuery();
public static void Main()
{
SQLRConnection con = new SQLRConnection("sqlrserver", 9000, "/tmp/example.socket", "user", "password", 0, 1);
SQLRCursor cur = new SQLRCursor(con);
if (cur.sendQuery("select * from my_nonexistant_table") != true)
{
Console.WriteLine(cur.errorMessage());
}
}
public static void Main()
{
SQLRConnection con = new SQLRConnection("sqlrserver", 9000, "/tmp/example.socket", "user", "password", 0, 1);
SQLRCursor cur = new SQLRCursor(con);
cur.sendQuery("insert into my_table values (1,2,3)");
cur.suspendResultSet();
con.suspendSession();
UInt16 rs = cur.getResultSetId();
UInt16 port = cur.getConnectionPort();
String socket = cur.getConnectionSocket();
public static void Main()
{
SQLRConnection con = new SQLRConnection("sqlrserver", 9000, "/tmp/example.socket", "user", "password", 0, 1);
SQLRCursor cur = new SQLRCursor(con);
cur.prepareQuery("select * from mytable $(whereclause)")
cur.substitution("whereclause", "where stringcol=:stringval and integercol>:integerval and floatcol>floatval");
cur.inputBind("stringval", "true");
cur.inputBind("integerval", 10);
cur.inputBind("floatval", 1.1, 2, 1);
cur.executeQuery();
public static void Main()
{
SQLRConnection con = new SQLRConnection("sqlrserver", 9000, "/tmp/example.socket", "user", "password", 0, 1);
SQLRCursor cur = new SQLRCursor(con);
cur.prepareQuery("begin select image into :image from images; select description into :desc from images; end;");
cur.defineOutputBindBlob("image");
cur.defineOutputBindClob("desc");
cur.executeQuery();
String image = cur.getOutputBindBlob("image");
UInt32 imagelength = cur.getOutputBindLength("image");
String desc = cur.getOutputBindClob("desc");
UInt32 desclength = cur.getOutputBindLength("desc");
con.endSession();
public static void Main()
{
SQLRConnection con = new SQLRConnection("sqlrserver", 9000, "/tmp/example.socket", "user", "password", 0, 1);
SQLRCursor cur = new SQLRCursor(con);
cur.sendQuery("select * from my_table");
con.endSession();
for (UInt64 row = 0; row< cur.rowCount(); row++)
{
for (UInt32 col = 0; col< cur.colCount(); col++)
{
Console.Write(cur.getField(row, col));
Console.Write(",");
}
Console.Write("\n");
}
}
public static void Main()
{
SQLRConnection con = new SQLRConnection("sqlrserver", 9000, "/tmp/example.socket", "user", "password", 0, 1);
SQLRCursor cur = new SQLRCursor(con);
cur.prepareQuery("begin :result1:=addTwoIntegers(:integer1,:integer2); :result2=addTwoFloats(:float1,:float2); :result3=convertToString(:integer3); end;");
cur.inputBind("integer1", 10);
cur.inputBind("integer2", 20);
cur.inputBind("float1", 1.1, 2, 1);
cur.inputBind("float2", 2.2, 2, 1);
cur.inputBind("integer3", 30);
cur.defineOutputBindInteger("result1");
cur.defineOutputBindDouble("result2");
cur.defineOutputBindString("result3", 100);
cur.executeQuery();
Int64 result1=cur.getOutputBindInteger("result1");
Double result2=cur.getOutputBindDouble("result2");
String result3=cur.getOutputBindString("result3");
con.endSession();
public static void Main()
{
SQLRConnection sqlrcon = new SQLRConnection(
"examplehost", 9000,
"/tmp/example.socket",
"exampleuser",
"examplepassword",
0, 1);
SQLRCursor sqlrcur = new SQLRCursor(sqlrcon);
sqlrcur.sendQuery("select * from exampletable");
for (UInt64 row = 0; row < sqlrcur.rowCount(); row++)
{
for (UInt64 col = 0; col < sqlrcur.colCount(); col++)
{
Console.WriteLine(sqlrcur.getField(row, col) + ",");
}
Console.WriteLine();
}
}
public static void Main()
{
SQLRConnection con = new SQLRConnection("sqlrserver", 9000, "/tmp/example.socket", "user", "password", 0, 1);
SQLRCursor cursor1 = new SQLRCursor(con);
SQLRCursor cursor2 = new SQLRCursor(con);
cursor1.setResultSetBufferSize(10);
cursor1.sendQuery("select * from my_huge_table");
UInt64 index = 0;
while (!cursor1.endOfResultSet())
{
cursor2.prepareQuery("insert into my_other_table values (:1,:2,:3)");
cursor2.inputBind("1", cursor1.getField(index, 1));
cursor2.inputBind("2", cursor1.getField(index, 2));
cursor2.inputBind("3", cursor1.getField(index, 3));
cursor2.executeQuery();
}
}
public static void Main()
{
SQLRConnection con = new SQLRConnection("sqlrserver", 9000, "/tmp/example.socket", "user", "password", 0, 1);
SQLRCursor cur = new SQLRCursor(con);
cur.sendQuery("select * from my_table");
con.endSession();
for (UInt32 i = 0; i< cur.colCount(); i++)
{
Console.Write("Name: ");
Console.WriteLine(cur.getColumnName(i));
Console.Write("Type: ");
Console.WriteLine(cur.getColumnType(i));
Console.Write("Length: ");
Console.WriteLine(cur.getColumnLength(i));
Console.Write("Precision: ");
Console.WriteLine(cur.getColumnPrecision(i));
Console.Write("Scale: ");
Console.WriteLine(cur.getColumnScale(i));
Console.Write("Longest Field: ");
Console.WriteLine(cur.getLongest(i));
Console.Write("Nullable: ");
Console.WriteLine(cur.getColumnIsNullable(i));
Console.Write("Primary Key: ");
Console.WriteLine(cur.getColumnIsPrimaryKey(i));
Console.Write("Unique: ");
Console.WriteLine(cur.getColumnIsUnique(i));
Console.Write("Part of Key: ");
Console.WriteLine(cur.getColumnIsPartOfKey(i));
Console.Write("Unsigned: ");
Console.WriteLine(cur.getColumnIsUnsigned(i));
Console.Write("Zero Filled: ");
Console.WriteLine(cur.getColumnIsZeroFilled(i));
Console.Write("Binary: ");
Console.WriteLine(cur.getColumnIsBinary(i));
Console.Write("Auto Increment:");
Console.WriteLine(cur.getColumnIsAutoIncrement(i));
Console.Write("\n");
}
}
public static void Main()
{
SQLRConnection con = new SQLRConnection("sqlrserver", 9000, "/tmp/example.socket", "user", "password", 0, 1);
SQLRCursor cur = new SQLRCursor(con);
// column names will be forced to upper case
cur.upperCaseColumnNames();
cur.sendQuery("select * from my_table");
con.endSession();
for (UInt32 i = 0; i< cur.colCount(); i++)
{
Console.Write("Name: ");
Console.WriteLine(getColumnName(i));
Console.Write("\n");
}
// column names will be forced to lower case
cur.lowerCaseColumnNames();
cur.sendQuery("select * from my_table");
con.endSession();
for (UInt32 i = 0; i< cur.colCount(); i++)
{
Console.Write("Name: ");
Console.WriteLine(cur.getColumnName(i));
Console.Write("\n");
}
// column names will be the same as they are in the database
cur.mixedCaseColumnNames();
cur.sendQuery("select * from my_table");
con.endSession();
for (UInt32 i = 0; i< cur.colCount(); i++)
{
Console.Write("Name: ");
Console.WriteLine(cur.getColumnName(i));
Console.Write("\n");
}
}
public static void Main()
{
SQLRConnection con = new SQLRConnection("sqlrserver", 9000, "/tmp/example.socket", "user", "password", 0, 1);
SQLRCursor cur = new SQLRCursor(con);
cur.prepareQuery("begin :curs:=sp_mytable; end;");
cur.defineOutputBindCursor("curs");
cur.executeQuery();
SQLRCursor bindcur = cur.getOutputBindCursor("curs");
bindcur.fetchFromBindCursor();
// print fields from table
for (int i = 0; i< bindcur.rowCount(); i++)
{
for (int j = 0; j< bindcur.colCount(); j++)
{
Console.Write(bindcur.getField(i, j));
Console.Write(", ");
}
Console.Write("\n");
}
}
private void copyOutBindValues()
{
for (Int32 i = 0; i < Parameters.Count; i++)
{
SQLRelayParameter param = (SQLRelayParameter)Parameters[i];
if (param.Direction == ParameterDirection.Output)
{
param.Size = _sqlrcur.getOutputBindLength(param.ParameterName);
switch (param.SQLRelayType)
{
case SQLRelayType.Clob:
param.Value = _sqlrcur.getOutputBindClob(param.ParameterName);
continue;
case SQLRelayType.Blob:
param.Value = _sqlrcur.getOutputBindBlob(param.ParameterName);
continue;
case SQLRelayType.Cursor:
SQLRCursor cursor = _sqlrcur.getOutputBindCursor(param.ParameterName);
if (cursor.fetchFromBindCursor())
{
param.Value = new SQLRelayDataReader(_sqlrelaycon, cursor, false);
}
continue;
}
switch (param.DbType)
{
case DbType.AnsiString:
case DbType.AnsiStringFixedLength:
case DbType.String:
case DbType.StringFixedLength:
case DbType.Time:
case DbType.Guid:
param.Value = _sqlrcur.getOutputBindString(param.ParameterName);
break;
case DbType.Date:
case DbType.DateTime:
case DbType.DateTime2:
case DbType.DateTimeOffset:
Int16 year = 0;
Int16 month = 0;
Int16 day = 0;
Int16 hour = 0;
Int16 minute = 0;
Int16 second = 0;
Int32 microsecond = 0;
String tz = null;
Boolean isnegative = false;
_sqlrcur.getOutputBindDate(param.ParameterName, out year, out month, out day, out hour, out minute, out second, out microsecond, out tz, out isnegative);
param.Value = new DateTime(year, month, day, hour, minute, second, microsecond / 1000);
break;
case DbType.Binary:
param.Value = _sqlrcur.getOutputBindBlob(param.ParameterName);
break;
case DbType.Boolean:
param.Value = _sqlrcur.getOutputBindInteger(param.ParameterName);
break;
case DbType.Currency:
case DbType.Decimal:
case DbType.Single:
case DbType.Double:
case DbType.VarNumeric:
param.Value = _sqlrcur.getOutputBindDouble(param.ParameterName);
break;
case DbType.Byte:
case DbType.Int16:
case DbType.Int32:
case DbType.Int64:
case DbType.SByte:
case DbType.UInt16:
case DbType.UInt32:
case DbType.UInt64:
param.Value = _sqlrcur.getOutputBindInteger(param.ParameterName);
break;
case DbType.Object:
case DbType.Xml:
param.Value = _sqlrcur.getOutputBindString(param.ParameterName);
break;
}
}
}
}
public static void Main()
{
SQLRConnection con = new SQLRConnection("sqlrserver", 9000, "/tmp/example.socket", "user", "password", 0, 1);
SQLRCursor cur = new SQLRCursor(con);