[gdal-dev] Re: [mapserver-users] OGR VRT ODBC connection problem

[Peter J Halls]

Brent,

    firstly, whilst SQLPLUS is a useful tool to ensure the Oracle environment is 
correctly configured, it does not test ODBC - nor does the very much nicer, Java 
based, SQL Developer, which is also not restricted to use with Oracle.

    Secondly, how many tables are there in your Oracle tablespace?  I currently 
have around 70 or 80 and OGR takes forever to start.  OGR reads the schema for 
every table in the tablespace, trying to identify the spatial tables and 
pre-load the key data in readiness.  If you have a lot of tables, the 
initialisation step may certainly seem to hang.

    Thirdly, enabling debug in GDAL will enable you to track a lot of what is 
going on and should enable you to quickly determine what is causing the hang - 
although fixing it may take rather more effort, of course.

    Lastly, I built GDAL against the Oracle Call Interface (OCI) libraries, not 
ODBC: this connects to Oracle in a similar manner to that used by the Oracle 
products and I find it to be fast and efficient.

Best wishes,

Peter

pcreso at pcreso.com wrote:
> Thanks Stephen, 
> 
> I should have included this in my first msg, apologies, but thanks for the reply.
> 
> I'm running GDAL v1.6.1, from
> ogrinfo --version
> GDAL 1.6.1, released 2009/05/11
>  
> 
> And, running isql (from unixodbc) also works.
> 
> isql --help
> unixODBC 2.2.12
> 
> isql -v metp niwatest niwatest
> libnuma: Warning: /sys not mounted or no numa system. Assuming one node: No such file or directory
> +---------------------------------------+
> | Connected!                            |
> |                                       |
> | sql-statement                         |
> | help [tablename]                      |
> | quit                                  |
> |                                       |
> +---------------------------------------+
> SQL> select count(*) from land_station;
> +-----------------------------------------+
> | COUNT(*)                                |
> +-----------------------------------------+
> | 8338                                    |
> +-----------------------------------------+    
> 
> 
> So isql succeeds, and is definately using ODBC.
> 
> ogrinfo just hangs. Both have the /sys warning msg, which I am ignoring.
> 
> 
> I'm still lost with respect to this....
> 
> 
> Thanks,
> 
>    Brent
> 
> 
> 
> --- On Mon, 2/21/11, Stephen Woodbridge <woodbri at swoodbridge.com> wrote:
> 
> From: Stephen Woodbridge <woodbri at swoodbridge.com>
> Subject: Re: [mapserver-users] OGR VRT ODBC connection problem
> To: pcreso at pcreso.com
> Cc: mapserver-users at lists.osgeo.org, gdal-dev at lists.osgeo.org
> Date: Monday, February 21, 2011, 2:12 PM
> 
> Hi Brent,
> 
> I'm certainly not an expert on this, but I think the issue might be that 
> sqlplus does not use an ODBC connection it uses some proprietary Oracle 
> socket protocol to connect.
> 
> Do you have ODBC services setup, configured and running on the Linux 
> host? How have you verified this?
> 
> If not then this is likely the issue. Sorry I don't use ODBC, so I can't 
> help much more then this.
> 
> -Steve W
> 
> On 2/20/2011 7:12 PM, pcreso at pcreso.com wrote:
>> Hi,
>>
>> Apologies for the cross posting, but I figure there are experts on both
>> lists.
>>
>> I'm trying to get a ogr virtual connection working from a Linux host to
>> a remote Oracle DB to use mapserver for a WFS service providing the
>> required data..
>>
>> ODBC is working, eg:
>>
>> sqlplus user/user at metp <mailto:niwatest/niwatest at metp>
>> select count(*) from land_station;
>> 8338
>>
>> etc...
>>
>> However, when testing with ogr2ogr, I get:
>>
>> ogrinfo ODBC:user/user at metp land_station
>>
>> libnuma: Warning: /sys not mounted or no numa system. Assuming one node:
>> No such file or directory
>>
>> and the terminal window hangs, I'm unable to get any response, & have to
>> kill the connection to continue.
>>
>>
>> Any suggestions?
>>
>>
>> Thanks,
>>
>> Brent Wood
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> mapserver-users mailing list
>> mapserver-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev

-- 
--------------------------------------------------------------------------------
Peter J Halls, GIS Advisor & Acting Team Leader Applications Support Group,
                Information Directorate, University of York
Telephone: 01904 323806     Fax: 01904 323740
Snail mail: C/O IT Services, University of York, Heslington, York YO10 5DD
This message has the status of a private and personal communication
--------------------------------------------------------------------------------