[GRASS-user] SQLite connection - error

[Espen Isaksen]

Hi!

I have tried to read the documentation and the mailing list for how to
connect to a SQLite database. So far I have done this:

1. db.connect driver=sqlite database='/home/espen/db.sqlite'
2. Created a new vector map called test
3. v.db.connect map=test table=GSHHS_f_L2 -o key=PK_UID

However I get this warning:

WARNING: SQLite driver: unable to parse decltype: POLYGON
WARNING: SQLite driver: unable to parse decltype: POLYGON
WARNING: SQLite driver: column 'Geometry', SQLite type 2 is not supported
WARNING: SQLite driver: unable to parse decltype: POLYGON
WARNING: SQLite driver: unable to parse decltype: POLYGON
WARNING: SQLite driver: column 'Geometry', SQLite type 2 is not supported
The table <GSHHS_f_L2> is now part of vector map <test> and may be deleted
or overwritten by GRASS modules

And running v.info map=test show that the layer does not have any objects

+----------------------------------------------------------------------------+
 | Layer:           test                                                      |
 | Mapset:          PERMANENT                                                 |
 | Location:        newLocation                                               |
 | Database:        /home/espen/Dokumenter/grassdata                          |
 | Title:                                                                     |
 | Map scale:       1:1                                                       |
 | Map format:      native                                                    |
 | Name of creator: espen                                                     |
 | Organization:                                                              |
 | Source date:     Wed Jun 23 08:55:30 2010                                  |
 |----------------------------------------------------------------------------|
 |   Type of Map:  vector (level: 2)                                          |
 |                                                                            |
 |   Number of points:       0               Number of areas:      0          |
 |   Number of lines:        0               Number of islands:    0          |
 |   Number of boundaries:   0               Number of faces:      0          |
 |   Number of centroids:    0               Number of kernels:    0          |
 |                                                                            |
 |   Map is 3D:              No                                               |
 |   Number of dblinks:      1                                                |
 |                                                                            |
 |         Projection: Lat/Lon                                                |
 |               N:                 0    S:                 0                 |
 |               E:                 0    W:                 0                 |
 |                                                                            |
 |   Digitization threshold: 0                                                |
 |   Comments:                                                                |
 |                                                                            |
 +----------------------------------------------------------------------------+

Could anybody explain to me what the warning means, and why I cannot
access the features? The only thing i can guess is that I can only use
version 1 of SQLite? However, I am not familiar with the different
versions of SQLite.

Kind regards,
Espen Isaksen