Re: [gnome-db] oracle9i

[James Leigh <james2002 canada com>]

On Wed, 2003-03-26 at 07:18, Rodrigo Moya wrote:
> On Tue, 2003-03-25 at 21:43, Steve Fosdick wrote:
> > > 3) Is libgda-0.10.0 going to work with the oracle-provider from 0.11.0?
> > 
> > I don't know, I haven't tried it.
> > 
> afaik, it should work, since there haven't been incompatible changes
> between 0.10 and 0.11, although, what do you want it for? Why not use
> the same version (0.11) for both libgda and the oracle provider?
>
No redhat8 rpms for 0.11 yet.  Should I use the 0.10 source for oracle
provider?

> > > $ ./configure --with-oracle=/opt/oracle/product/9.2.0/ --without-tds --without-odbc
> > > ...
> > >  Configuration summary
> > >    Installation prefix = /usr/local
> > >    Providers
> > >       Default (XML) = yes
> > >       FireBird = no
> > >       FreeTDS = no
> > >       IBM DB2 = no
> > >       MDB (MS Access) = yes
> > >       MySQL = no
> > >       ODBC = no
> > >       Oracle = yes
> > >       PostgreSQL = no
> > >       SQLite = yes
> > >       Sybase = no
> > >       xBase (dBase, Clipper, FoxPro) = no
> > >       LDAP = yes
> > > 
> > > $ make
> > > ...
> > > In file included from gda-oracle.h:39,
> > >                  from gda-oracle-provider.c:28:
> > > gda-oracle-provider.h:27:17: oci.h: No such file or directory
> > > ...
> >
> hmm, again the same :-( When running configure like this, is
> $ORACLE_HOME set to some value? And what dir does it say it's found
> oracle files in? (configure should output this info)
> 
ORACLE_HOME is not set is the above or below commands.

$ ./configure --with-oracle=/opt/oracle/product/9.2.0/ --without-tds --without-odbc
...
ORACLE installation... found ORACLE in /opt/oracle/product/9.2.0/
...
config.status: creating providers/oracle/Makefile
...
$ make clean; make
...
In file included from gda-oracle.h:39,
                 from gda-oracle-provider.c:28:
gda-oracle-provider.h:27:17: oci.h: No such file or directory
...

It is set in the commands below.

> > > $ export ORACLE_HOME=/opt/oracle/product/9.2.0/
> > > $ ./configure --with-oracle=/opt/oracle/product/9.2.0/ --without-tds --without-odbc
> > > ...
> > > $ make
> > > ...
> > > $ make install
> > > ...
> > > # ln -s /usr/local/lib/libgda/providers/libgda-oracle.so /usr/lib/libgda/providers/
> > > $ ls -l /usr/lib/libgda/providers/
> > > total 284
> > > -rwxr-xr-x    1 root     root        23598 Jan 28 13:19 libgda-default.so
> > > -rwxr-xr-x    1 root     root        56078 Jan 28 13:18 libgda-freetds.so
> > > -rwxr-xr-x    1 root     root        49499 Jan 28 13:18 libgda-mysql.so
> > > -rwxr-xr-x    1 root     root        38286 Jan 28 13:19 libgda-odbc.so
> > > lrwxrwxrwx    1 root     root           48 Mar 14 16:24 libgda-oracle.so -> /usr/local/lib/libgda/providers/libgda-oracle.so
> > > -rwxr-xr-x    1 root     root        62268 Jan 28 13:19 libgda-postgres.so
> > > -rwxr-xr-x    1 root     root        33725 Jan 28 13:19 libgda-sqlite.so
> > > $ mergeant
> > > ## add an oracle connect as PASSWORD=XXXX;USER=XXXX;TNSNAME=192.168.10.8
> > > ## then test connection
> > > (gnome-database-properties:16693): GLib-GObject-WARNING **: invalid cast from (NULL) pointer to `GObject'
> > > 
> > > (gnome-database-properties:16693): GLib-GObject-CRITICAL **: file gobject.c: line 1307 (g_object_unref): assertion `G_IS_OBJECT (object)' failed
> > > 
> > > (gnome-database-properties:16693): GModule-CRITICAL **: file gmodule.c: line 454 (g_module_close): assertion `module != NULL' failed
> > > ## and I have to xkill gnome-database-properties
> > > 
> hmm, could you run gda-test in a terminal and see what it outputs when
> it comes to open the oracle connection?
> 
$ gda-test

=========================================
= Testing configuration API
=========================================
 Section /apps/libgda
 Section /apps/libgda/Datasources/Default
        Key 'Provider' = 'Default'
        Key 'Username' = 'nouser'
        Key 'DSN' = 'URI=/tmp/gnome-db-test.db'
        Key 'Description' = 'Default libgda provider'
 Section /apps/libgda/Datasources/dev9i
        Key 'Provider' = 'Oracle'
        Key 'DSN' = 'PASSWORD=XXXX;USER=XXXX;TNSNAME=dev9i'
        Key 'Description' = ''
        Key 'Username' = 'XXXX'
        Key 'Password' = 'XXXX'

=========================================
= Testing provider configuration API
=========================================
 Provider = MS Access
        location = /usr/local/lib/libgda/providers/libgda-mdb.so
        description = Provider for Microsoft Access files
        gda_params = FILENAME
 Provider = Oracle
        location = /usr/local/lib/libgda/providers/libgda-oracle.so
        description = Provider for Oracle databases
        gda_params = TNSNAME USER PASSWORD
 Provider = SQLite
        location = /usr/local/lib/libgda/providers/libgda-sqlite.so
        description = Provider for SQLite databases
        gda_params = URI
 Provider = LDAP
        location = /usr/local/lib/libgda/providers/libgda-ldap.so
        description = Provider for LDAP directory
        gda_params = FLAGS HOST PORT BINDDN PASSWORD AUTHMETHOD
 Provider = Default
        location = /usr/local/lib/libgda/providers/libgda-default.so
        description = Default provider, based on XML
        gda_params = URI

=========================================
= Testing data source configuration
=========================================
 Data source = Default
        provider = Default
        cnc_string = URI=/tmp/gnome-db-test.db
        description = Default libgda provider
        username = nouser
 Data source = dev9i
        provider = Oracle
        cnc_string = PASSWORD=whippet;USER=cantel9i;TNSNAME=dev9i
        description =
        username = cantel9i

...

=========================================
= Testing GDA client API
=========================================
 Data source = Default, User = nouser
        Provider capabilities...
                Aggregates: Not supported
                Indexes: Not supported
                Namespaces: Not supported
                Procedures: Not supported
                Sequences: Not supported
                SQL: Not supported
                Transactions: Supported
                Triggers: Not supported
                Users: Not supported
                Views: Not supported
                XML queries: Supported

        Provider reports version: 0.11.0

        Namespaces
                NONE
        Databases 0
        Stored procedures
                NONE
        Connection Tables 0
        Available types 15
                bigint
                binary
                boolean
                date
                double
                integer
                list
                numeric
                point
                single
                smallint
                string
                time
                timestamp
                tinyint
        Views
                NONE
        Indexes
                NONE
        Aggregates
                NONE
        Users
                NONE
        Sequences
                NONE
        Triggers
                NONE
        Languages
                NONE
        Starting transaction...
** (gda-test:20514): CRITICAL **: file gda-util.c: line 199
(gda_file_save): ass
ertion `filename != NULL' failed
Error
        Finishing transaction...
** (gda-test:20514): CRITICAL **: file gda-util.c: line 199
(gda_file_save): ass
ertion `filename != NULL' failed
Error
        Starting transaction...
** (gda-test:20514): CRITICAL **: file gda-util.c: line 199
(gda_file_save): ass
ertion `filename != NULL' failed
Error
        Rolling back transaction...OK
 Data source = dev9i, User = XXXX
** ERROR: could not open connection to dev9i