Re: FW: 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 : 			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 : 			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 : 			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