New connection without reason 2007-12-03 - By Mauricio Bruns
Back
Hi,
I'm using myodbc 3.51.22, mysql 4.1.20 and Clarion. I don't know why,
but sometimes, without reason it (myodbc, mysql or clarion) creates a
new connection between two queries that couldn't be separate. For
example I do "INSERT INTO ...." (in a autoinc table) and after I do
"SELECT last_insert_id()", but each query was executed in their own
connection, than the second query return 0. Do you think that it could
be myodbc error?
Here is some part of mysql log:
C:\Arquivos de programas\MySQL\MySQL Server 4.1\bin\mysqld-nt, Version:
4.1.22-community-nt-log. started with:
TCP Port: 3306, Named Pipe: MySQL
Time Id Command Argument
071129 14:52:17 1 Connect root@(protected) on Test
1 Query SET SQL_AUTO_IS_NULL = 0
1 Query SELECT @@(protected)
1 Query SET SESSION TRANSACTION ISOLATION LEVEL
REPEATABLE READ
1 Query SELECT * FROM Empresa WHERE 0 = 1
1 Query SELECT
CodEmpresa,NomeEmpresa,CodSistema,NrUsuarios,DriverBD,AliqPis,AliqCofins,AliqCS
,AliqIRF,VlrMinimoIRF,AliqIRLucro,PrazoIRJ,PrazoICMS,PrazoIPI,PrazoPIS
,PrazoCofins,PrazoCS,PrazoFP,PrazoFGTS,PrazoINSS,VlrMinimoICMSDifer
,CodFilialPadrao,SeImpressoraFilial,CodClienteINSS,CodClienteIRF,CodClientePCC
,CodClienteISS,MetPrevisaoFluxo
FROM Empresa WHERE 0 = 1
...
1 Query INSERT INTO NotaPed
(NrCadDoc,CodEmpresa,CodFilial,TipoDocto,NrNota,SerieNF,CodCliente,NrPedido
,NrAtendimento)
VALUES (117286,1,5,1,15188,'3',23574,6344,214)
1 Query Begin
1 Query INSERT INTO DocIte
(NrCadDoc,CodEmpresa,CodFilial,TipoDocto,NrNota,SerieNF,CodCliente,NrSeqIte
,CodProduto,CodVariante,CodTamanho,CodQualidade,UnidMedida,QtdePecas,QtdeMovto
,PesoLiquido,PesoBruto,PrecoUnitario,PrecoUnitarioLiq,TipoOperFat,CodNatFiscal
,CodProced,CodICMS,CodIPI,IncidePIS,IncideCofins,IncideCSLL,AliqICMS,CodClaFis
,TaxaIPI,VlrProduto,VlrSeguro,VlrDespAces,VlrIpiNContrib,VlrBonif,VlrBonif2
,VlrFrete,VlrFreteCalc,VlrOutDespesas,VlrISS,VlrIRF,VlrFunRural,VlrICMS
,VlrICMSSubs,VlrICMSDifer,VlrIPI,VlrIPIDesp,VlrPIS,VlrCofins,VlrCSLL,VlrPCC
,VlrINSS,VlrTaxaImportacao,VlrImpostosCobr,VlrServicoPago,VlrContabil
,VlrComissao,VlrComissaoAdic,VlrEncFinanc,CodColecao,CodLocal,CodLocalDest
,CodCusto,CodAplic,NrLoteProd,NrVolume,NrAtendimento,NrPedido,NrSeqPed,NrOrcam
,NrSeqOrc,NrOrdem,NrSeqProd,QtdePerda,SitEstoque,TipoOperEtq,CodMensNF
,CodFuncionario,CodProdutoCli,DescProduto,Observ,QtdeGrade1,QtdeGrade2
,QtdeGrade3,QtdeGrade4,QtdeGrade5,QtdeGrade6,QtdeGrade7,QtdeGrade8,QtdeGrade9
,QtdeGrade10,QtdeGrade11,QtdeGrade12)
VALUES
(117286,1,5,1,15188,'3',23574,1,'20120174','','','','PC',0,1.000
,0.000 ,0.000 ,23.000000 ,23.000000
,'P','510202','0','00','90','S','S','S',17.00 ,' ',0.00
,23.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00
,0.00 ,0.00 ,0.00 ,0.00 ,3.91 ,0.00 ,0.00 ,0.00
,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00 ,0.00
,0.00 ,0.00 ,1.15 ,0.00 ,0.00
,8,0,0,0,0,'',0,214,6344,1,0,0,0,0,0.000
,'N','N',0,0,'','T-SHIRT','',0,0,0,0,0,0,0,0,0,0,0,0)
131 Connect root@(protected) on Test
131 Query SET SQL_AUTO_IS_NULL = 0
131 Query SET SESSION TRANSACTION ISOLATION LEVEL
REPEATABLE READ
131 Query Select last_insert_id()
1 Query Commit
...
Thanks in advance,
Mauricio Bruns
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=mysql@(protected)
|
|
