299118 - SQL Component Not Usable From XPCShell

Status: RESOLVED INCOMPLETE

(Core Graveyard :: SQL, defect)

Description

[gordan]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.0; en-GB; rv:1.7.5) Gecko/20041110 Firefox/1.0
Build Identifier: ftp://ftp.mozilla.org/pub/mozilla.org/mozilla/releases/mozilla1.7.8/source/mozilla-1.7.8-source.tar.bz2

SQL service components do not work when used from XPCShell.
They _DO_ appear to work when usef from the GUI, though.

Reproducible: Always

Steps to Reproduce:
Compile Mozilla (just tried with 1.7.8, but older versions exhibit the same
behaviour:

# export MOZ_ENABLE_PGSQL=1
# export MOZ_PGSQL_INCLUDES=/usr/include/pgsql
# export MOZ_PGSQL_LIBS=/usr/lib/pgsql
# ./configure --enable-pgsql --enable-extensions=default,sql
[...]
# make
[...]
# make install
[...]
# /usr/local/lib/mozilla-1.7.8/xpcshell
[...]
*** Registering "sql" components (all right -- a generic module!)
[...]
js> for (var list in Components.interfaces)
     if (/sql/i.test(list))
       print(list);
mozISqlService
mozISqlResultEnumerator
mozISqlInputStream
mozISqlConnectionPgsql
mozISqlResult
mozISqlRequest
mozISqlRequestObserver
mozISqlDataSource
mozISqlResultPgsql
mozISqlConnection
js> for (var list in Components.classes)
     if (/sql/i.test(list))
       print(list);
@mozilla.org/sql/service;1
@mozilla.org/rdf/datasource;1?name=sql
@mozilla.org/sql/connection;1?type=pgsql
js> var sqlService =
Components.classes["@mozilla.org/sql/service;1"].getService(Components.interfaces.mozISqlService);
uncaught exception: [Exception... "Component returned failure code: 0x80570016
(NS_ERROR_XPC_GS_RETURNED_FAILURE) [nsIJSCID.getService]"  nsresult: "0x80570016
(NS_ERROR_XPC_GS_RETURNED_FAILURE)"  location: "JS frame :: typein ::
<TOP_LEVEL> :: line 7"  data: no]

Comment 1

[Benjamin Smedberg]

The SQL extension and component are no longer active.