Skip site navigation (1) Skip section navigation (2)

Re: ANOTHER NEW ODBC DRIVER

From: Byron Nikolaidis <byronn(at)insightdist(dot)com>
To: "Jose' Soares Da Silva" <sferac(at)bo(dot)nettuno(dot)it>
Cc: "pgsql-interfaces(at)postgreSQL(dot)org" <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: ANOTHER NEW ODBC DRIVER
Date: 1998-05-13 15:09:05
Message-ID: 3559B791.7C926DDE@insightdist.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
This is the backend "canonifier" problem that was previously discussed on the interfaces list under "New Driver and Unique Indexes".

I'll forward it to you.

Byron


Jose' Soares Da Silva wrote:

> On Fri, 8 May 1998, Byron Nikolaidis wrote:
>
> > Version .0238 is now at our website.
> >
> Hello Byron,
> I have a 'palloc failure: memory exahusted' message using PSQLODBC
> with M$-Access97 as following:
> ---------------------------------------------------------------------------
> conn=69337208, SQLDriverConnect( in)='DSN=PostgreSQL;DATABASE=java;SERVER=verde;PORT=5432;READONLY=0;PROTOCOL=;CONNSETTINGS=;'
> DSN info(DSN='PostgreSQL',server='verde',dbase='java',user='postgres',passwd='',port='5432',readonly='0',protocol='', conn_settings='')
> conn=69337208, SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=java;SERVER=verde;PORT=5432;UID=postgres;READONLY=0;PWD=;PROTOCOL=;CONNSETTINGS='
> conn=69337208, query=' '
> conn=69337208, query='BEGIN'
> conn=69337208, query='set DateStyle to 'ISO'; set geqo to 'OFF''
> Command response: 'SET VARIABLE'
> conn=69337208, query='declare C69350472 cursor for select oid from pg_type where typname='lo''
> conn=69337208, query='fetch 100 in C69350472'
>     [ fetched 0 rows ]
> conn=69337208, query='close C69350472'
> conn=69337208, query='END'
> conn=69337208, query='BEGIN'
> conn=69337208, query='declare C69350472 cursor for SELECT Config, nValue FROM MSysConf'
> ERROR from backend during send_query: 'ERROR:  msysconf: Table does not exist.'
> conn=69337208, query='ABORT'
> conn=69337208, query='BEGIN'
> conn=69337208, query='declare C69350472 cursor for SELECT figure.azienda,figure.tipo,figure.gruppo,figure.inizio_attivita FROM figure '
> conn=69337208, query='fetch 100 in C69350472'
>     [ fetched 3 rows ]
> conn=69337208, query='close C69350472'
> conn=69337208, query='END'
> conn=69337208, query='BEGIN'
> conn=69337208, query='declare C69350472 cursor for SELECT azienda,tipo,gruppo,inizio_attivita,fine_attivita,codice_figura  FROM figure  WHERE azienda = '001BO001   ' AND tipo = '1' AND gruppo = '1 ' AND inizio_attivita = '1998-01-12''
> conn=69337208, query='fetch 100 in C69350472'
>     [ fetched 1 rows ]
> conn=69337208, query='close C69350472'
> conn=69337208, query='END'
> conn=69337208, query='BEGIN'
> conn=69337208, query='declare C69422552 cursor for SELECT azienda,tipo,gruppo,inizio_attivita,fine_attivita,codice_figura  FROM figure  WHERE azienda = '00212      ' AND tipo = '1' AND gruppo = '1 ' AND inizio_attivita = '1997-01-01' OR azienda = '1233
>     ' AND tipo = '1' AND gruppo = '11' AND inizio_attivita = '1998-02-12' OR azienda = '1233       ' AND tipo = '1' AND gruppo = '11' AND inizio_attivita = '1998-02-12' OR azienda = '1233       ' AND tipo = '1' AND gruppo = '11' AND inizio_attivita = '199
> 8-02-12' OR azienda = '1233       ' AND tipo = '1' AND gruppo = '11' AND inizio_attivita = '1998-02-12' OR azienda = '1233       ' AND tipo = '1' AND gruppo = '11' AND inizio_attivita = '1998-02-12' OR azienda = '1233       ' AND tipo = '1' AND gruppo = '
> 11' AND inizio_attivita = '1998-02-12' OR azienda = '1233       ' AND tipo = '1' AND gruppo = '11' AND inizio_attivita = '1998-02-12' OR azienda = '1233       ' AND tipo = '1' AND gruppo = '11' AND inizio_attivita = '1998-02-12' OR azienda = '1233       '
>  AND tipo = '1' AND gruppo = '11' AND inizio_attivita = '1998-02-12''
> ERROR from backend during send_query: 'FATAL 1:  palloc failure: memory exhausted'
> ---------------------------------------------------------------------------
> I linked the below table on Access97, It's primary key is:
>         composed by (azienda,tipo,inizio_attivita)...
>
> CREATE TABLE figure (
>         azienda                 CHAR(11) NOT NULL,
>         tipo                    CHAR,
>         gruppo                  CHAR(02),
>         inizio_attivita         DATE,
>         fine_attivita           DATE,
>         codice_figura           CHAR(11) NOT NULL,
>         PRIMARY KEY (azienda,tipo,inizio_attivita)
>         );
>
> java=>  select * from figure;
> azienda    |tipo|gruppo|inizio_attivita|fine_attivita|codice_figura
> -----------+----+------+---------------+-------------+-------------
> 001BO001   |   1|    1 |     1998-01-12|             |  01
> 00212      |   1|    1 |     1997-01-01|             |  12
> 1233       |   1|    11|     1998-02-12|             |  23
> (3 rows)
>
> When I try to read next record (by clik on right arrow),
> I have the above message.
>                                            Thanks for help, Jose'




pgsql-interfaces by date

Next:From: Sean ReillyDate: 1998-05-13 22:08:27
Subject: Re: [INTERFACES] binary insert with JDBC
Previous:From: Olaf MittelstaedtDate: 1998-05-13 14:33:47
Subject: Re: [INTERFACES] Accessing PgSql-Database from NT (ODBCD)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group