Re: [gnome-db] libgda problem

[Rodrigo Moya <rodrigo gnome-db org>]

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?

cheers