 |
Forums |
Admin Discussion Forums: help Start New Thread
| Message: 1004022 |
|
BY: Eric Montague (emontague)
DATE: 2008-09-27 00:20
SUBJECT: RE: Backend sent unrecognized response type: q /*
drop table if exists test_table;
CREATE TABLE test_table (
field varchar(254)
);
CREATE OR REPLACE FUNCTION testExceptionBadTableName() RETURNS VOID AS
$BODY$
DECLARE
textField text;
BEGIN
SELECT
t.noField
INTO
textField
FROM
no_table AS t
WHERE
t.key = 0
;
END;
$BODY$
LANGUAGE 'plpgsql'
VOLATILE
CALLED ON NULL INPUT
SECURITY INVOKER;
CREATE OR REPLACE FUNCTION testExceptionBadFieldName() RETURNS VOID AS
$BODY$
DECLARE
textField text;
BEGIN
SELECT
t.noField
INTO
textField
FROM
test_table AS t
WHERE
t.key = 0
;
END;
$BODY$
LANGUAGE 'plpgsql'
VOLATILE
CALLED ON NULL INPUT
SECURITY INVOKER;
*/
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using Npgsql;
namespace ConsoleTest
{
class Program
{
static void Main(string[] args)
{
InstallConnection = CreateIDbConnection();
DoErrorTable();
DoErrorField();
DoErrorTable();
}
static private void DoErrorField(object sender, EventArgs e)
{
System.Console.WriteLine("****DO ERROR FIELD:");
try
{
using (IDbCommand cmd = CreateIDbCommand(InstallConnection))
{
cmd.CommandText =
"Select testExceptionBadFieldName()";
cmd.ExecuteScalar();
}
}
catch (Exception ex)
{
System.Console.WriteLine("****EXCEPTION:" + System.Environment.NewLine + ex.ToString());
}
}
static private void DoErrorTable(object sender, EventArgs e)
{
System.Console.WriteLine("****DO ERROR TABLE:");
try
{
using (IDbCommand cmd = CreateIDbCommand(InstallConnection))
{
cmd.CommandText =
"Select testExceptionBadTableName()";
cmd.ExecuteScalar();
}
}
catch (Exception ex)
{
System.Console.WriteLine("****EXCEPTION:" + System.Environment.NewLine + ex.ToString());
}
}
static private IDbCommand CreateIDbCommand(IDbConnection conn)
{
IDbCommand cmd = new NpgsqlCommand();
cmd.Connection = conn;
cmd.CommandTimeout = 240;
return cmd;
}
static private IDbConnection CreateIDbConnection()
{
IDbConnection idbConnection;
idbConnection = new NpgsqlConnection(ConnectionString);
idbConnection.Open();
return idbConnection;
}
static private String ConnectionString
{
get
{
return
String.Format("User ID={0};DATABASE={1};SERVER={2};PORT={3};",
"username",
"databasename",
"servername",
"5432");
}
}
static private void DoErrorField()
{
System.Console.WriteLine("****DO ERROR FIELD:");
try
{
using (IDbCommand cmd = CreateIDbCommand(InstallConnection))
{
cmd.CommandText =
"Select testExceptionBadFieldName()";
cmd.ExecuteScalar();
}
}
catch (Exception ex)
{
System.Console.WriteLine("****EXCEPTION:" + System.Environment.NewLine + ex.ToString());
}
}
static private void DoErrorTable()
{
System.Console.WriteLine("****DO ERROR TABLE:");
try
{
using (IDbCommand cmd = CreateIDbCommand(InstallConnection))
{
cmd.CommandText =
"Select testExceptionBadTableName()";
cmd.ExecuteScalar();
}
}
catch (Exception ex)
{
System.Console.WriteLine("****EXCEPTION:" + System.Environment.NewLine + ex.ToString());
}
}
static private IDbConnection InstallConnection
{
get { return idbConnection; }
set { idbConnection = value; }
}
static private IDbCommand InstallCommand
{
get { return _idbCommand; }
set { _idbCommand = value; }
}
static private IDbCommand _idbCommand;
static private IDbConnection idbConnection;
}
}
| |
Thread View
Post a followup to this message
|
|
Backend sent unrecognized response type: q