conn=149369392, SQLDriverConnect( in)='DSN=PostgreSQL;', fDriverCompletion=1
DSN info: DSN='PostgreSQL',server='thorbecke',port='5432',dbase='jeroen',user='postgres',passwd='postgres'
          readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
          conn_settings=''
          translation_dll='',translation_option=''
Global Options: Version='06.40.0006', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
                disable_optimizer=0, ksqo=1, unique_index=1, use_declarefetch=1
                text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
                extra_systable_prefixes='dd_;', conn_settings=''
conn=149369392, query=' '
conn=149369392, query='set DateStyle to 'ISO''
conn=149369392, query='set ksqo to 'ON''
conn=149369392, query='BEGIN'
conn=149369392, query='declare SQL_CUR08E80040 cursor for select oid from pg_type where typname='lo''
conn=149369392, query='fetch 100 in SQL_CUR08E80040'
    [ fetched 0 rows ]
conn=149369392, query='close SQL_CUR08E80040'
conn=149369392, query='END'
conn=149369392, SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=jeroen;SERVER=thorbecke;PORT=5432;UID=postgres;PWD=postgres;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
conn=149369392, query='BEGIN'
conn=149369392, query='declare SQL_CUR08E80040 cursor for SELECT Config, nValue FROM MSysConf'
ERROR from backend during send_query: 'ERROR:  msysconf: Table does not exist.'
conn=149369392, query='ABORT'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
                 ------------------------------------------------------------
                 hdbc=149369392, stmt=149422144, result=0
                 manual_result=0, prepare=0, internal=0
                 bindings=0, bindings_allocated=0
                 parameters=0, parameters_allocated=0
                 statement_type=0, statement='SELECT Config, nValue FROM MSysConf'
                 stmt_with_params='declare SQL_CUR08E80040 cursor for SELECT Config, nValue FROM MSysConf'
                 data_at_exec=-1, current_exec_param=-1, put_data=0
                 currTuple=-1, current_col=-1, lobj_fd=-1
                 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1
                 cursor_name='SQL_CUR08E80040'
                 ----------------QResult Info -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR:  msysconf: Table does not exist.'
            ------------------------------------------------------------
            henv=149369376, conn=149369392, status=1, num_stmts=16
            sock=149375728, stmts=149383984, lobj_type=-999
            ---------------- Socket Info -------------------------------
            socket=348, reverse=0, errornumber=0, errormsg='(null)'
            buffer_in=149375776, buffer_out=149379880
            buffer_filled_in=3, buffer_filled_out=0, buffer_read_in=2
conn=149369392, query='BEGIN'
conn=149369392, query='declare SQL_CUR08E90110 cursor for select relname, usename, relhasrules from pg_class, pg_user where relkind = 'r' and relname !~ '^xinv[0-9]+' and int4out(usesysid) = int4out(relowner)order by relname'
conn=149369392, query='fetch 100 in SQL_CUR08E90110'
    [ fetched 36 rows ]
conn=149369392, query='close SQL_CUR08E90110'
conn=149369392, query='END'
conn=149369392, query='BEGIN'
conn=149369392, query='declare SQL_CUR08EA1EE8 cursor for select u.usename, c.relname, a.attname, a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from pg_user u, pg_class c, pg_attribute a, pg_type t where int4out(u.usesysid) = int4out(c.relowner) and c.oid= a.attrelid and a.atttypid = t.oid and (a.attnum > 0) and c.relname like 'Adres gegevens' order by attnum'
conn=149369392, query='fetch 100 in SQL_CUR08EA1EE8'
    [ fetched 5 rows ]
conn=149369392, query='close SQL_CUR08EA1EE8'
conn=149369392, query='END'
conn=149369392, query='BEGIN'
conn=149369392, query='declare SQL_CUR08EC2088 cursor for select u.usename, c.relname, a.attname, a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from pg_user u, pg_class c, pg_attribute a, pg_type t where int4out(u.usesysid) = int4out(c.relowner) and c.oid= a.attrelid and a.atttypid = t.oid and (a.attnum > 0) and c.relname like 'Adres gegevens' order by attnum'
conn=149369392, query='fetch 100 in SQL_CUR08EC2088'
    [ fetched 5 rows ]
conn=149369392, query='close SQL_CUR08EC2088'
conn=149369392, query='END'
conn=149369392, query='BEGIN'
conn=149369392, query='declare SQL_CUR08EB1FB8 cursor for select c.relname, i.indkey, i.indisunique, i.indisclustered from pg_index i, pg_class c, pg_class d where c.oid = i.indexrelid and d.relname = 'Adres gegevens' and d.oid = i.indrelid'
conn=149369392, query='fetch 100 in SQL_CUR08EB1FB8'
    [ fetched 1 rows ]
conn=149369392, query='close SQL_CUR08EB1FB8'
conn=149369392, query='END'
conn=149369392, query='BEGIN'
conn=149369392, query='declare SQL_CUR08EA1EE8 cursor for SELECT "Adres gegevens"."Volgnr" FROM "Adres gegevens" '
conn=149369392, query='fetch 100 in SQL_CUR08EA1EE8'
    [ fetched 1 rows ]
conn=149369392, query='close SQL_CUR08EA1EE8'
conn=149369392, query='END'
conn=149369392, query='BEGIN'
conn=149369392, query='declare SQL_CUR08EA1EE8 cursor for SELECT "Voornaam","Achternaam","Straat","Nummer","Volgnr"  FROM "Adres gegevens"  WHERE "Volgnr" = 1 OR "Volgnr" = 1 OR "Volgnr" = 1 OR "Volgnr" = 1 OR "Volgnr" = 1 OR "Volgnr" = 1 OR "Volgnr" = 1 OR "Volgnr" = 1 OR "Volgnr" = 1 OR "Volgnr" = 1'
conn=149369392, query='fetch 100 in SQL_CUR08EA1EE8'
    [ fetched 1 rows ]
conn=149369392, query='close SQL_CUR08EA1EE8'
conn=149369392, query='END'
conn=149389320, SQLDriverConnect( in)='DSN=PostgreSQL;', fDriverCompletion=1
DSN info: DSN='PostgreSQL',server='thorbecke',port='5432',dbase='jeroen',user='postgres',passwd='postgres'
          readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
          conn_settings=''
          translation_dll='',translation_option=''
Global Options: Version='06.40.0006', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
                disable_optimizer=0, ksqo=1, unique_index=1, use_declarefetch=1
                text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
                extra_systable_prefixes='dd_;', conn_settings=''
conn=149389320, query=' '
conn=149389320, query='set DateStyle to 'ISO''
conn=149389320, query='set ksqo to 'ON''
conn=149389320, query='BEGIN'
conn=149389320, query='declare SQL_CUR08EA1EE8 cursor for select oid from pg_type where typname='lo''
conn=149389320, query='fetch 100 in SQL_CUR08EA1EE8'
    [ fetched 0 rows ]
conn=149389320, query='close SQL_CUR08EA1EE8'
conn=149389320, query='END'
conn=149389320, SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=jeroen;SERVER=thorbecke;PORT=5432;UID=postgres;PWD=postgres;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
conn=149389320, query='BEGIN'
conn=149389320, query='CREATE TABLE "Uitzendkracht"("Gen_Bijzonderheden" int4,"Gen_Bijzonderheden_2" int4,"Uitzendkrachtnummer" int4,"Gen_Geschiktheid" int4,"Voornaam" varchar(20),"s_Generation" int4,"Voorletters" varchar(8),"s_GUID" bytea,"Tussenvoegsels" varchar(10),"Achternaam" varchar(20),"s_Lineage" lo,"Geboortedatum" datetime,"Inschrijfdatum" datetime,"Uitschrijfdatum" datetime,"Bankrekeningnummer" varchar(10),"Plaats_bank" varchar(20),"Gironummer" varchar(7),"O_W_nummer" varchar(15),"Sofinummer" varchar(10),"Telefoonnummer_1" varchar(20),"Telefoonnummer_2" varchar(20),"Aanvang_studie" varchar(4),"Bijzonderheden" text,"Bijzonderheden_2" text,"Studierichtingsnaam" varchar(30),"Studentenvereniging" varchar(15),"Geslacht" varchar(1),"Tariefgroep" int2,"Tonen" char(1),"Ingevoerd_door" varchar(25),"OV_kaart" varchar(10),"Scholierenregeling" char(1),"Status" varchar(20),"Deelt_met" varchar(50),"Vooropleiding" varchar(50),"Werkt_vast_bij" varchar(80),"Wijzigingsdatum" datetime,"Ziekenfondsnaam" varchar(25),"Ziekenfondsnummer" varchar(15),"Geschiktheid" text,"Reservering_vakantiegeld" char(1),"Reservering_vakantiedagen" char(1),"Fulltime_beschikbaar" char(1),"_wekentabel" char(1),"Loontabel" varchar(50),"Scholingsgesprek" char(1),"Scholingsresultaat" text,"Fase1datum_uit_verleden" datetime,"Prioriteit_voor_werk" char(1))'
ERROR from backend during send_query: 'ERROR:  Unable to locate type name 'lo' in catalog'
conn=149389320, query='COMMIT'
STATEMENT ERROR: func=SC_execute, desc='', errnum=17, errmsg='Error creating the table'
                 ------------------------------------------------------------
                 hdbc=149389320, stmt=149561064, result=0
                 manual_result=0, prepare=0, internal=0
                 bindings=0, bindings_allocated=0
                 parameters=0, parameters_allocated=0
                 statement_type=4, statement='CREATE TABLE "Uitzendkracht"("Gen_Bijzonderheden" int4,"Gen_Bijzonderheden_2" int4,"Uitzendkrachtnummer" int4,"Gen_Geschiktheid" int4,"Voornaam" varchar(20),"s_Generation" int4,"Voorletters" varchar(8),"s_GUID" bytea,"Tussenvoegsels" varchar(10),"Achternaam" varchar(20),"s_Lineage" lo,"Geboortedatum" datetime,"Inschrijfdatum" datetime,"Uitschrijfdatum" datetime,"Bankrekeningnummer" varchar(10),"Plaats_bank" varchar(20),"Gironummer" varchar(7),"O_W_nummer" varchar(15),"Sofinummer" varchar(10),"Telefoonnummer_1" varchar(20),"Telefoonnummer_2" varchar(20),"Aanvang_studie" varchar(4),"Bijzonderheden" text,"Bijzonderheden_2" text,"Studierichtingsnaam" varchar(30),"Studentenvereniging" varchar(15),"Geslacht" varchar(1),"Tariefgroep" int2,"Tonen" char(1),"Ingevoerd_door" varchar(25),"OV_kaart" varchar(10),"Scholierenregeling" char(1),"Status" varchar(20),"Deelt_met" varchar(50),"Vooropleiding" varchar(50),"Werkt_vast_bij" varchar(80),"Wijzigingsdatum" datetime,"Ziekenfondsnaam" varchar(25),"Ziekenfondsnummer" varchar(15),"Geschiktheid" text,"Reservering_vakantiegeld" char(1),"Reservering_vakantiedagen" char(1),"Fulltime_beschikbaar" char(1),"_wekentabel" char(1),"Loontabel" varchar(50),"Scholingsgesprek" char(1),"Scholingsresultaat" text,"Fase1datum_uit_verleden" datetime,"Prioriteit_voor_werk" char(1))'
                 stmt_with_params='CREATE TABLE "Uitzendkracht"("Gen_Bijzonderheden" int4,"Gen_Bijzonderheden_2" int4,"Uitzendkrachtnummer" int4,"Gen_Geschiktheid" int4,"Voornaam" varchar(20),"s_Generation" int4,"Voorletters" varchar(8),"s_GUID" bytea,"Tussenvoegsels" varchar(10),"Achternaam" varchar(20),"s_Lineage" lo,"Geboortedatum" datetime,"Inschrijfdatum" datetime,"Uitschrijfdatum" datetime,"Bankrekeningnummer" varchar(10),"Plaats_bank" varchar(20),"Gironummer" varchar(7),"O_W_nummer" varchar(15),"Sofinummer" varchar(10),"Telefoonnummer_1" varchar(20),"Telefoonnummer_2" varchar(20),"Aanvang_studie" varchar(4),"Bijzonderheden" text,"Bijzonderheden_2" text,"Studierichtingsnaam" varchar(30),"Studentenvereniging" varchar(15),"Geslacht" varchar(1),"Tariefgroep" int2,"Tonen" char(1),"Ingevoerd_door" varchar(25),"OV_kaart" varchar(10),"Scholierenregeling" char(1),"Status" varchar(20),"Deelt_met" varchar(50),"Vooropleiding" varchar(50),"Werkt_vast_bij" varchar(80),"Wijzigingsdatum" datetime,"Ziekenfondsnaam" varchar(25),"Ziekenfondsnummer" varchar(15),"Geschiktheid" text,"Reservering_vakantiegeld" char(1),"Reservering_vakantiedagen" char(1),"Fulltime_beschikbaar" char(1),"_wekentabel" char(1),"Loontabel" varchar(50),"Scholingsgesprek" char(1),"Scholingsresultaat" text,"Fase1datum_uit_verleden" datetime,"Prioriteit_voor_werk" char(1))'
                 data_at_exec=-1, current_exec_param=-1, put_data=0
                 currTuple=-1, current_col=-1, lobj_fd=-1
                 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1
                 cursor_name='SQL_CUR08EA1EE8'
                 ----------------QResult Info -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR:  Unable to locate type name 'lo' in catalog'
            ------------------------------------------------------------
            henv=149369376, conn=149389320, status=1, num_stmts=16
            sock=149388392, stmts=149554944, lobj_type=-999
            ---------------- Socket Info -------------------------------
            socket=332, reverse=0, errornumber=0, errormsg='(null)'
            buffer_in=149555936, buffer_out=149395656
            buffer_filled_in=3, buffer_filled_out=0, buffer_read_in=2
conn=149389320, SQLDisconnect
conn=149369392, SQLDisconnect