[Zope-DB] Connect Zope to MS-SQL
Marcos Iuato
marcos at hiper.com.br
Thu Aug 5 16:19:54 EDT 2004
I 'm trying to connect zope on linux to MS-SQL Server using
Freetds + UnixODBC + SQLRelay from debian testing
also tryed:
Freetds + UnixODBC + SQLRelay from debian stable
This works but is very unstable, a stored procedure sometimes is ok,
sometimes happens a rollback and sometimes commit but returns no results.
Has anyone using an open sorce solution to connect zope on linux to MS-SQL
Server? or everybody is using mxODBC Zope DA?
Well, i will attach a log file of SQLRelay, any help will be appreciated.
Regards,
Marcos Iuato
-------------- next part --------------
connection : getting unix socket...
connection : opening /var/cache/sqlrelay/tmp/sockseq
connection : locking...
connection : got sequence number: 1
connection : writing new sequence number: 2
connection : unlocking...
connection : done getting unix socket
08/05/2004 13:37:13 BRT connection [5969] : logging in...
08/05/2004 13:37:16 BRT connection [5969] : done logging in
08/05/2004 13:37:16 BRT connection [5969] : setting autocommit...
08/05/2004 13:37:16 BRT connection [5969] : done setting autocommit
08/05/2004 13:37:16 BRT connection [5969] : initializing cursors...
08/05/2004 13:37:16 BRT connection [5969] : 0
08/05/2004 13:37:16 BRT connection [5969] : 1
08/05/2004 13:37:16 BRT connection [5969] : 2
08/05/2004 13:37:16 BRT connection [5969] : 3
08/05/2004 13:37:16 BRT connection [5969] : 4
08/05/2004 13:37:16 BRT connection [5969] : done initializing cursors
connection : attaching to shared memory and semaphores
connection : id filename:
connection : /var/cache/sqlrelay/tmp/sqlrodbcguarulhos
connection : attaching to shared memory...
connection : attaching to semaphores...
connection : done attaching to shared memory and semaphores
connection : incrementing connection count...
connection : 2
connection : done incrementing connection count
connection : creating /var/cache/sqlrelay/tmp/sqlrodbcguarulhos-msguarulhos
08/05/2004 13:37:16 BRT connection [5969] : listening on sockets...
08/05/2004 13:37:16 BRT connection [5969] : listening on unix socket: /var/cache/sqlrelay/tmp/1
08/05/2004 13:37:16 BRT connection [5969] : listening on inet socket: 0
08/05/2004 13:37:16 BRT connection [5969] : done listening on sockets
08/05/2004 13:37:16 BRT connection [5969] : waiting for available database...
connection : database is available
08/05/2004 13:37:16 BRT connection [5969] : database is available
08/05/2004 13:37:16 BRT connection [5969] : initializing session...
08/05/2004 13:37:16 BRT connection [5969] : done initializing session...
connection : announcing availability...
connection : handoff=reconnect
connection : done announcing availability...
08/05/2004 13:37:22 BRT connection [5969] : waiting for client...
08/05/2004 13:37:22 BRT connection [5969] : reconnect succeeded
08/05/2004 13:37:22 BRT connection [5969] : done waiting for client
08/05/2004 13:37:22 BRT connection [5969] : client session...
08/05/2004 13:37:22 BRT connection [5969] : getting command...
08/05/2004 13:37:22 BRT connection [5969] : done getting command
08/05/2004 13:37:22 BRT connection [5969] : authenticate
08/05/2004 13:37:22 BRT connection [5969] : authenticate...
08/05/2004 13:37:22 BRT connection [5969] : authentication was done on listener
08/05/2004 13:37:22 BRT connection [5969] : getting command...
08/05/2004 13:37:22 BRT connection [5969] : done getting command
08/05/2004 13:37:22 BRT connection [5969] : new query
08/05/2004 13:37:22 BRT connection [5969] : 0
08/05/2004 13:37:22 BRT connection [5969] : found a free cursor...
08/05/2004 13:37:22 BRT connection [5969] : done getting a cursor
08/05/2004 13:37:22 BRT connection [5969] : handling query...
08/05/2004 13:37:22 BRT connection [5969] : getting query...
08/05/2004 13:37:22 BRT connection [5969] : querylength:
08/05/2004 13:37:22 BRT connection [5969] : 21
08/05/2004 13:37:22 BRT connection [5969] : query:
08/05/2004 13:37:22 BRT connection [5969] : Pr_Sel_ReqResp 1, 'P'
08/05/2004 13:37:22 BRT connection [5969] : getting query succeeded
08/05/2004 13:37:22 BRT connection [5969] : getting input binds...
08/05/2004 13:37:22 BRT connection [5969] : done getting input binds
08/05/2004 13:37:22 BRT connection [5969] : getting output binds...
08/05/2004 13:37:22 BRT connection [5969] : done getting output binds
08/05/2004 13:37:22 BRT connection [5969] : getting send column info...
08/05/2004 13:37:22 BRT connection [5969] : send column info
08/05/2004 13:37:22 BRT connection [5969] : done getting send column info...
08/05/2004 13:37:22 BRT connection [5969] : processing query...
08/05/2004 13:37:22 BRT connection [5969] : preparing/executing...
08/05/2004 13:37:23 BRT connection [5969] : commit or rollback check...
08/05/2004 13:37:23 BRT connection [5969] : commit or rollback needed
08/05/2004 13:37:23 BRT connection [5969] : done with commit or rollback check
08/05/2004 13:37:23 BRT connection [5969] : processing query succeeded
08/05/2004 13:37:23 BRT connection [5969] : done processing query
08/05/2004 13:37:23 BRT connection [5969] : returning result set header...
08/05/2004 13:37:23 BRT connection [5969] : returning row counts...
08/05/2004 13:37:23 BRT connection [5969] : sending row counts...
08/05/2004 13:37:23 BRT connection [5969] : actual rows unknown
08/05/2004 13:37:23 BRT connection [5969] : affected rows: 0
08/05/2004 13:37:23 BRT connection [5969] : done sending row counts
08/05/2004 13:37:23 BRT connection [5969] : done returning row counts
08/05/2004 13:37:23 BRT connection [5969] : column info will be sent
08/05/2004 13:37:23 BRT connection [5969] : returning column counts...
08/05/2004 13:37:23 BRT connection [5969] : sending column count...
08/05/2004 13:37:23 BRT connection [5969] : 21
08/05/2004 13:37:23 BRT connection [5969] : done sending column count
08/05/2004 13:37:23 BRT connection [5969] : done returning column counts
08/05/2004 13:37:23 BRT connection [5969] : returning column info...
08/05/2004 13:37:23 BRT connection [5969] : sending column type format...
08/05/2004 13:37:23 BRT connection [5969] : id's
08/05/2004 13:37:23 BRT connection [5969] : done sending column type format
08/05/2004 13:37:23 BRT connection [5969] : nr_CD_RESPONSAVEL:28:8 (0,0) NOT NULL
08/05/2004 13:37:23 BRT connection [5969] : tx_NM_RESPONSAVEL:17:60 (60,0) NOT NULL
08/05/2004 13:37:23 BRT connection [5969] : tx_DS_NACIONALIDADE:17:20 (20,0) NOT NULL
08/05/2004 13:37:23 BRT connection [5969] : tx_DS_NATURALIDADE:17:40 (40,0) NOT NULL
08/05/2004 13:37:23 BRT connection [5969] : tx_DS_UF:17:2 (2,0) NOT NULL
08/05/2004 13:37:23 BRT connection [5969] : nr_CTPS:28:8 (0,0) NOT NULL
08/05/2004 13:37:23 BRT connection [5969] : nr_SERIE_CTPS:17:5 (5,0) NOT NULL
08/05/2004 13:37:23 BRT connection [5969] : tx_DS_UF_CTPS:17:2 (2,0) NOT NULL
08/05/2004 13:37:23 BRT connection [5969] : tx_DS_REPARTICAO:17:20 (20,0) NOT NULL
08/05/2004 13:37:23 BRT connection [5969] : dt_LICENCIATURA:0:4 (30,0) NOT NULL
08/05/2004 13:37:23 BRT connection [5969] : tx_DS_TITULO_HABILITACAO:17:15 (15,0) NOT NULL
08/05/2004 13:37:23 BRT connection [5969] : tx_DS_EMAIL:17:60 (60,0) NOT NULL
08/05/2004 13:37:23 BRT connection [5969] : dt_INSCRICAO:0:4 (30,0) NOT NULL
08/05/2004 13:37:23 BRT connection [5969] : tx_NR_CPFCNPJ:17:14 (14,0) NOT NULL
08/05/2004 13:37:23 BRT connection [5969] : tx_DS_RG:17:15 (15,0) NOT NULL
08/05/2004 13:37:23 BRT connection [5969] : tx_DS_RGDV:17:3 (3,0) NOT NULL
08/05/2004 13:37:23 BRT connection [5969] : dt_NASCIMENTO:0:4 (30,0) NOT NULL
08/05/2004 13:37:23 BRT connection [5969] : tx_ST_ATIVIDADE:17:1 (1,0) NOT NULL
08/05/2004 13:37:23 BRT connection [5969] : dt_INICIO_SUSPENSAO:0:4 (30,0) NOT NULL
08/05/2004 13:37:23 BRT connection [5969] : dt_FINAL_SUSPENSAO:0:4 (30,0) NOT NULL
08/05/2004 13:37:23 BRT connection [5969] : nr_INSC_MUNICIPAL:56:4 (0,0) NOT NULL
08/05/2004 13:37:23 BRT connection [5969] : done returning column info
08/05/2004 13:37:23 BRT connection [5969] : returning output bind values
08/05/2004 13:37:23 BRT connection [5969] : 0
08/05/2004 13:37:23 BRT connection [5969] : done returning output bind values
08/05/2004 13:37:23 BRT connection [5969] : done returning result set header
08/05/2004 13:37:23 BRT connection [5969] : handle query succeeded
08/05/2004 13:37:23 BRT connection [5969] : returning result set data...
08/05/2004 13:37:23 BRT connection [5969] : skipping 0 rows...
08/05/2004 13:37:23 BRT connection [5969] : done skipping rows
08/05/2004 13:37:23 BRT connection [5969] : fetching 0 rows...
08/05/2004 13:37:23 BRT connection [5969] : "1","PRISMA ENGENHARIA E TOPOGRAFIA"," "," "," ",NULL"0 "," "," ",NULL" ","prismatopografia at ul.com.br","2002-08-12 00:00:00"," ",NULLNULLNULL"A",NULLNULLNULL
08/05/2004 13:37:23 BRT connection [5969] : done returning result set data
08/05/2004 13:37:23 BRT connection [5969] : getting command...
08/05/2004 13:37:23 BRT connection [5969] : done getting command
08/05/2004 13:37:23 BRT connection [5969] : commit
08/05/2004 13:37:23 BRT connection [5969] : getting command...
08/05/2004 13:37:23 BRT connection [5969] : done getting command
08/05/2004 13:37:23 BRT connection [5969] : end session
08/05/2004 13:37:23 BRT connection [5969] : ending session...
08/05/2004 13:37:23 BRT connection [5969] : aborting all busy cursors...
08/05/2004 13:37:23 BRT connection [5969] : done aborting all busy cursors
08/05/2004 13:37:23 BRT connection [5969] : resetting autocommit behavior...
08/05/2004 13:37:23 BRT connection [5969] : setting autocommit on...
08/05/2004 13:37:23 BRT connection [5969] : done setting autocommit on...
08/05/2004 13:37:23 BRT connection [5969] : done resetting autocommit behavior...
08/05/2004 13:37:23 BRT connection [5969] : done ending session
08/05/2004 13:37:23 BRT connection [5969] : waiting for client to close the connection...
08/05/2004 13:37:23 BRT connection [5969] : done waiting for client to close the connection...
08/05/2004 13:37:23 BRT connection [5969] : done with client session
connection : decrementing session count...
connection : 0
connection : done decrementing session count
08/05/2004 13:37:23 BRT connection [5969] : waiting for available database...
connection : database is available
08/05/2004 13:37:23 BRT connection [5969] : database is available
08/05/2004 13:37:23 BRT connection [5969] : initializing session...
08/05/2004 13:37:23 BRT connection [5969] : done initializing session...
connection : announcing availability...
connection : handoff=reconnect
connection : done announcing availability...
08/05/2004 13:43:56 BRT connection [5969] : waiting for client...
08/05/2004 13:43:56 BRT connection [5969] : reconnect succeeded
08/05/2004 13:43:56 BRT connection [5969] : done waiting for client
08/05/2004 13:43:56 BRT connection [5969] : client session...
08/05/2004 13:43:56 BRT connection [5969] : getting command...
08/05/2004 13:43:56 BRT connection [5969] : done getting command
08/05/2004 13:43:56 BRT connection [5969] : authenticate
08/05/2004 13:43:56 BRT connection [5969] : authenticate...
08/05/2004 13:43:56 BRT connection [5969] : authentication was done on listener
08/05/2004 13:43:56 BRT connection [5969] : getting command...
08/05/2004 13:43:56 BRT connection [5969] : done getting command
08/05/2004 13:43:56 BRT connection [5969] : new query
08/05/2004 13:43:56 BRT connection [5969] : 0
08/05/2004 13:43:56 BRT connection [5969] : found a free cursor...
08/05/2004 13:43:56 BRT connection [5969] : done getting a cursor
08/05/2004 13:43:56 BRT connection [5969] : handling query...
08/05/2004 13:43:56 BRT connection [5969] : getting query...
08/05/2004 13:43:56 BRT connection [5969] : querylength:
08/05/2004 13:43:56 BRT connection [5969] : 21
08/05/2004 13:43:56 BRT connection [5969] : query:
08/05/2004 13:43:56 BRT connection [5969] : Pr_Sel_ReqResp 9, 'P'
08/05/2004 13:43:56 BRT connection [5969] : getting query succeeded
08/05/2004 13:43:56 BRT connection [5969] : getting input binds...
08/05/2004 13:43:56 BRT connection [5969] : done getting input binds
08/05/2004 13:43:56 BRT connection [5969] : getting output binds...
08/05/2004 13:43:56 BRT connection [5969] : done getting output binds
08/05/2004 13:43:56 BRT connection [5969] : getting send column info...
08/05/2004 13:43:56 BRT connection [5969] : send column info
08/05/2004 13:43:56 BRT connection [5969] : done getting send column info...
08/05/2004 13:43:56 BRT connection [5969] : processing query...
08/05/2004 13:43:56 BRT connection [5969] : preparing/executing...
08/05/2004 13:43:56 BRT connection [5969] : commit or rollback check...
08/05/2004 13:43:56 BRT connection [5969] : commit or rollback needed
08/05/2004 13:43:56 BRT connection [5969] : done with commit or rollback check
08/05/2004 13:43:56 BRT connection [5969] : processing query succeeded
08/05/2004 13:43:56 BRT connection [5969] : done processing query
08/05/2004 13:43:56 BRT connection [5969] : returning result set header...
08/05/2004 13:43:56 BRT connection [5969] : returning row counts...
08/05/2004 13:43:56 BRT connection [5969] : sending row counts...
08/05/2004 13:43:56 BRT connection [5969] : actual rows unknown
08/05/2004 13:43:56 BRT connection [5969] : affected rows: 0
08/05/2004 13:43:56 BRT connection [5969] : done sending row counts
08/05/2004 13:43:56 BRT connection [5969] : done returning row counts
08/05/2004 13:43:56 BRT connection [5969] : column info will be sent
08/05/2004 13:43:56 BRT connection [5969] : returning column counts...
08/05/2004 13:43:56 BRT connection [5969] : sending column count...
08/05/2004 13:43:56 BRT connection [5969] : 0
08/05/2004 13:43:56 BRT connection [5969] : done sending column count
08/05/2004 13:43:56 BRT connection [5969] : done returning column counts
08/05/2004 13:43:56 BRT connection [5969] : returning column info...
08/05/2004 13:43:56 BRT connection [5969] : sending column type format...
08/05/2004 13:43:56 BRT connection [5969] : id's
08/05/2004 13:43:56 BRT connection [5969] : done sending column type format
08/05/2004 13:43:56 BRT connection [5969] : done returning column info
08/05/2004 13:43:56 BRT connection [5969] : returning output bind values
08/05/2004 13:43:56 BRT connection [5969] : 0
08/05/2004 13:43:56 BRT connection [5969] : done returning output bind values
08/05/2004 13:43:56 BRT connection [5969] : done returning result set header
08/05/2004 13:43:56 BRT connection [5969] : handle query succeeded
08/05/2004 13:43:56 BRT connection [5969] : returning result set data...
08/05/2004 13:43:56 BRT connection [5969] : done returning result set data
08/05/2004 13:43:56 BRT connection [5969] : getting command...
08/05/2004 13:43:56 BRT connection [5969] : done getting command
08/05/2004 13:43:56 BRT connection [5969] : commit
08/05/2004 13:43:58 BRT connection [5969] : getting command...
08/05/2004 13:43:58 BRT connection [5969] : done getting command
08/05/2004 13:43:58 BRT connection [5969] : end session
08/05/2004 13:43:58 BRT connection [5969] : ending session...
08/05/2004 13:43:58 BRT connection [5969] : aborting all busy cursors...
08/05/2004 13:43:58 BRT connection [5969] : done aborting all busy cursors
08/05/2004 13:43:58 BRT connection [5969] : resetting autocommit behavior...
08/05/2004 13:43:58 BRT connection [5969] : setting autocommit on...
08/05/2004 13:43:58 BRT connection [5969] : done setting autocommit on...
08/05/2004 13:43:58 BRT connection [5969] : done resetting autocommit behavior...
08/05/2004 13:43:58 BRT connection [5969] : done ending session
08/05/2004 13:43:58 BRT connection [5969] : waiting for client to close the connection...
08/05/2004 13:43:58 BRT connection [5969] : done waiting for client to close the connection...
08/05/2004 13:43:58 BRT connection [5969] : done with client session
connection : decrementing session count...
connection : 0
connection : done decrementing session count
08/05/2004 13:43:58 BRT connection [5969] : waiting for available database...
connection : database is available
08/05/2004 13:43:58 BRT connection [5969] : database is available
08/05/2004 13:43:58 BRT connection [5969] : initializing session...
08/05/2004 13:43:58 BRT connection [5969] : done initializing session...
connection : announcing availability...
More information about the Zope-DB
mailing list