Re: [gnome-db] libgda problem

[Rodrigo Moya <rodrigo gnome-db org>]

On Mon, 2003-09-15 at 13:45 +0000, snpe wrote:
> On Monday 15 September 2003 09:21 am, you wrote:
> > On Mon, 2003-09-15 at 00:29 +0000, snpe wrote:
> > > On Sunday 14 September 2003 03:28 pm, Rodrigo Moya wrote:
> > > > On Sun, 2003-08-03 at 22:20 +0000, snpe wrote:
> > > > > On Saturday 02 August 2003 03:54 pm, Gonzalo Paniagua Javier wrote:
> > > > > > El s?, 02-08-2003 a las 19:25, snpe escribió:
> > > > > > > I do next (again) :
> > > > > > > export CVSROOT=:pserver:anonymous anoncvs gnome org:/cvs/gnome
> > > > > > > rm -rf libgda
> > > > > > > cvs co libgda
> > > > > > > // release for sql_parser.h is 1.3
> > > > > > > cd libgda
> > > > > > > ./autogen.sh --prefix=/u1/gnome2
> > > > > > > make
> > > > > > >
> > > > > > > and error is here
> > > > > >
> > > > > > Can you please try this patch? If it works for you, i'll commit.
> > > > >
> > > > > It work for parser, but compile fail for oracle This is error :
> > > > >  gcc -DPACKAGE_NAME=\"\" -DPACKAGE_TARNAME=\"\"
> > > > > -DPACKAGE_VERSION=\"\" -DPACKAGE_STRING=\"\" -DPACKAGE_BUGREPORT=\"\"
> > > > > -DPACKAGE=\"libgda\" -DVERSION=\"0.91.0\"
> > > > > -DBONOBO_EXPLICIT_TRANSLATION_DOMAIN=\"libgda-2\" -DSTDC_HEADERS=1
> > > > > -DHAVE_SYS_TYPES_H=1 -DHAVE_SYS_STAT_H=1
> > > > > -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 -DHAVE_MEMORY_H=1
> > > > > -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 -DHAVE_STDINT_H=1
> > > > > -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1 -DYYTEXT_POINTER=1
> > > > > -DGETTEXT_PACKAGE=\"libgda-2\" -DHAVE_ALLOCA_H=1 -DHAVE_ALLOCA=1
> > > > > -DHAVE_STDLIB_H=1 -DHAVE_UNISTD_H=1 -DHAVE_GETPAGESIZE=1
> > > > > -DHAVE_MMAP=1 -DHAVE_ARGZ_H=1 -DHAVE_LIMITS_H=1 -DHAVE_LOCALE_H=1
> > > > > -DHAVE_NL_TYPES_H=1 -DHAVE_MALLOC_H=1 -DHAVE_STRING_H=1
> > > > > -DHAVE_UNISTD_H=1 -DHAVE_SYS_PARAM_H=1 -DHAVE_GETCWD=1
> > > > > -DHAVE_MUNMAP=1 -DHAVE_PUTENV=1 -DHAVE_SETENV=1 -DHAVE_SETLOCALE=1
> > > > > -DHAVE_STRCHR=1 -DHAVE_STRCASECMP=1 -DHAVE_STRDUP=1
> > > > > -DHAVE___ARGZ_COUNT=1 -DHAVE___ARGZ_STRINGIFY=1 -DHAVE___ARGZ_NEXT=1
> > > > > -DHAVE_LC_MESSAGES=1 -DHAVE_GETTEXT=1
> > > > > -DHAVE_DCGETTEXT=1 -DENABLE_NLS=1 -DHAVE_ODBC=1 -DHAVE_MYSQL=1
> > > > > -DHAVE_POSTGRES=1 -DHAVE_ORACLE=1 -DHAVE_LDAP=1 -DHAVE_POPT_H=1
> > > > > -DHAVE_READLINE_READLINE_H=1 -DHAVE_READLINE_HISTORY_H=1 -I. -I.
> > > > > -I../.. -I../.. -pthread -I/u1/gnome2/include/glib-2.0
> > > > > -I/u1/gnome2/lib/glib-2.0/include -I/u1/gnome2/include/libxml2
> > > > > -I/u1/gnome2/include -I/u1/app/oracle/product/8.0.5/rdbms/demo
> > > > > -I/u1/app/oracle/product/8.0.5/rdbms/public
> > > > > -I/u1/app/oracle/product/8.0.5/plsql/public
> > > > > -I/u1/app/oracle/product/8.0.5/network/public -g -O2 -Wall
> > > > > -Wmissing-prototypes -Wnested-externs -Wpointer-arith
> > > > > -Wno-sign-compare -Wp,-MD,.deps/utils.pp -c utils.c  -fPIC -o
> > > > > .libs/utils.o utils.c: In function `gda_oracle_handle_error':
> > > > > utils.c:114: warning: deprecated use of label at end of compound
> > > > > statement utils.c: In function `oracle_sqltype_to_gda_type':
> > > > > utils.c:156: `SQLT_DATE' undeclared (first use in this function)
> > > > > utils.c:156: (Each undeclared identifier is reported only once
> > > > > utils.c:156: for each function it appears in.)
> > > > > utils.c:157: `SQLT_TIME' undeclared (first use in this function)
> > > > > utils.c:158: `SQLT_TIME_TZ' undeclared (first use in this function)
> > > > > utils.c:159: `SQLT_TIMESTAMP' undeclared (first use in this function)
> > > > > utils.c:160: `SQLT_TIMESTAMP_TZ' undeclared (first use in this
> > > > > function) utils.c:161: `SQLT_TIMESTAMP_LTZ' undeclared (first use in
> > > > > this function) utils.c:171: `SQLT_INTERVAL_YM' undeclared (first use
> > > > > in this function) utils.c:172: `SQLT_INTERVAL_DS' undeclared (first
> > > > > use in this function) utils.c: In function
> > > > > `oracle_sqltype_to_string':
> > > > > utils.c:256: `SQLT_DATE' undeclared (first use in this function)
> > > > > utils.c:258: `SQLT_TIME' undeclared (first use in this function)
> > > > > utils.c:260: `SQLT_TIME_TZ' undeclared (first use in this function)
> > > > > utils.c:262: `SQLT_TIMESTAMP' undeclared (first use in this function)
> > > > > utils.c:264: `SQLT_TIMESTAMP_TZ' undeclared (first use in this
> > > > > function) utils.c:266: `SQLT_INTERVAL_YM' undeclared (first use in
> > > > > this function) utils.c:268: `SQLT_INTERVAL_DS' undeclared (first use
> > > > > in this function) utils.c:270: `SQLT_TIMESTAMP_LTZ' undeclared (first
> > > > > use in this function) utils.c: In function
> > > > > `gda_value_to_oracle_value':
> > > > > utils.c:345: warning: assignment discards qualifiers from pointer
> > > > > target type utils.c:353: warning: assignment discards qualifiers from
> > > > > pointer target type utils.c:361: warning: assignment discards
> > > > > qualifiers from pointer target type make[2]: *** [utils.lo] Error 1
> > > > > make[2]: Leaving directory
> > > > > `/u1/gnome2.cvs/gnome2/libgda/providers/oracle' make[1]: ***
> > > > > [all-recursive] Error 1
> > > > > make[1]: Leaving directory `/u1/gnome2.cvs/gnome2/libgda/providers'
> > > > > make: *** [all-recursive] Error 1
> > > >
> > > > what oracle version are you compiling against?
> > >
> > > I try 8.0.5 and it don't work, but oracle 9i work fine.
> >
> > hmm, iirc, we did some changes to support 8.1.x and 9i. Maybe at that
> > time we broke the support for 8.0.x. It looks as if the header path is
> > not pulled in correctly for 8.0.5.
> >
> > Anyone with oracle installed and oracle experience to try to fix it?
> >
> There isn't btw SQLT_DATE in complete oracle 8.0.5 tree - it introduce in 8i, probably

right, then this confirms it gor broken when we upgraded it for 8.1.x.
Is 8.0.5 a widely used version still? I ask because, iirc, we dropped
8.0.x support because it was quite difficult to support all the
versions.

Could you please confirm/deny this?

cheers