Re: FW: ODBC 9.3.0210 not commiting, Discard ALL - Mailing list pgsql-odbc
From | Barry Bell |
---|---|
Subject | Re: FW: ODBC 9.3.0210 not commiting, Discard ALL |
Date | |
Msg-id | 8c97cdd164004b408fc71413e1a04a43@BY2PR08MB281.namprd08.prod.outlook.com Whole thread Raw |
In response to | Re: FW: ODBC 9.3.0210 not commiting, Discard ALL (Hiroshi Inoue <inoue@tpf.co.jp>) |
List | pgsql-odbc |
I am not getting any error. Just that the inserts are not commiting. (They do commit with ver 9.3.100) Where would I see the " was Mylog output."? Barry Bell -----Original Message----- From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Hiroshi Inoue Sent: Sunday, March 30, 2014 11:23 PM To: pgsql-odbc@postgresql.org Subject: Re: FW: [ODBC] ODBC 9.3.0210 not commiting, Discard ALL Hi Barry, My reply seems to have been rejected. So I reply to ML. (2014/03/29 1:10), Barry Bell wrote: > Only "ini" I could find was "postgressql-sdbc.uno" > [Bootstrap] > PQ_LOGLEVEL=NONE > > Hope this helps, Connection string: > "Driver={PostgreSQL ANSI};Server=hhl-pgdev.harte-hanks.com;Port=65432;Database=db;Uid=u;Pwd=p;BI=2;TextAsLongVarchar=1;UnknownSizes=2;UseServerSidePrepare=1;B0=254;B7=1;C5=0;AB=8;" > > For the ODBC driver log: > vfp9 2928-f338 ENTER SQLExecDirect > HSTMT 0x009C8C08 > UCHAR * 0x053B3568 [ -3] "\ 9\ 9\ 9Insert into autorunlog ( recordid,program,description,starttime,endtime,records) values ( "nextval"('autorunlog_seq'),? ,? ,? ,? ,? )\ 0" > SDWORD -3 > > vfp9 2928-f338 EXIT SQLExecDirect with return code 0 (SQL_SUCCESS) > HSTMT 0x009C8C08 > UCHAR * 0x053B3568 [ -3] "\ 9\ 9\ 9Insert into autorunlog ( recordid,program,description,starttime,endtime,records) values ( "nextval"('autorunlog_seq'),? ,? ,? ,? ,? )\ 0" > SDWORD -3 Hmm what I really wanted was Mylog output. You can take the log by adding ;Debug=1 or ;B2=1 to your connection string. > DBLOG > > 2014-03-27 15:55:55.336 EDT,"","",2566,"localhost:51398",53348244.a06,50,"PARSE",2014-03-27 15:55:48 EDT,9/417,0,LOG,00000,"duration:0.241 ms parse <unnamed>: Insert into autorunlog ( recordid,program,description,starttime,endtime,records) values ( ""nextval""('autorunlog_seq'),$1 ,$2 ,$3 ,$4 ,$5 )",,,,,,,,"exec_parse_message,postgres.c:1391","" > 2014-03-27 15:55:55.336 EDT,"hits","hits",2566,"localhost:51398",53348244.a06,51,"BIND",2014-03-27 15:55:48 EDT,9/417,0,LOG,00000,"duration:0.040 ms bind <unnamed>: Insert into autorunlog ( recordid,program,description,starttime,endtime,records) values ( ""nextval""('autorunlog_seq'),$1 ,$2 ,$3 ,$4 ,$5 )","parameters:$1 = 'DOEFUELPRICES', $2 = 'DOE Fuel Prices Update', $3 = '2014-03-27 15:55:47', $4 = '2014-03-27 15:55:55',$5 = '0'",,,,,,,"exec_bind_message, postgres.c:1771","" > 2014-03-27 15:55:55.337 EDT,"","",2566,"localhost:51398",53348244.a06,52,"INSERT",2014-03-27 15:55:48 EDT,9/417,7419304,LOG,00000,"duration:0.233 ms execute <unnamed>: Insert into autorunlog ( recordid,program,description,starttime,endtime,records) values ( ""nextval""('autorunlog_seq'),$1 ,$2 ,$3 ,$4 ,$5 )","parameters:$1 = 'DOEFUELPRICES', $2 = 'DOE Fuel Prices Update', $3 = '2014-03-27 15:55:47', $4 = '2014-03-27 15:55:55',$5 = '0'",,,,,,,"exec_execute_message, postgres.c:1991","" > 2014-03-27 15:55:55.346 EDT,"","",2566,"localhost:51398",53348244.a06,53,"DISCARD ALL",2014-03-27 15:55:48 EDT,9/0,0,LOG,00000,"duration:8.486 ms statement: DISCARD ALL",,,,,,,,"exec_simple_query, postgres.c:1125","" Unfortunately I can find no problem in the above log. Do some errors occur after this? regards, Hiroshi Inoue -- Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-odbc
pgsql-odbc by date: