Hi Pedro,

My guess is maybe a bug with how the database is being looked up on
subsequent operations.

To confirm is your database stored outside of the geoserver data directory?

If you could share your db that would be helpful. Just a subset of it would
be fine. Feel free to send via private email.

-Justin

On Fri, Jan 14, 2011 at 6:04 AM, Pedro Mendes <[email protected]>wrote:

> List,
>
> I'm setting up a Spatialite DataSource with GS beta 3 plus a nightly build
> from the Spatialite plugin but i'm facing some problems. I successfully
> create a new vector datasource (through "Spatialite" not "SpatiaLite
> (JNDI)") and all the database tables are available in the layer chooser.
> The problems arise when there's any kind of transaction made against the
> database that uses SpatiaLite lib specific functions, such as, getting the a
> featuredata Native Bounding Box
>
> Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing
> database (no such function: AsText)
>
> If i put the bb values manually, the layer is created, but when doing the
> preview another error arises:
>
> Caused by: java.sql.SQLException: [SQLITE_ERROR] SQL error or missing
> database (no such function: envelope)
>
> I'm using the plugin version obtain at
> http://gridlock.openplans.org/geoserver/trunk/community-2011-01-08/ and far
> as I can see, it's inaltered since the "promotion" to a community module
> status.
>
> I followed the tutorial in
> http://docs.geoserver.org/latest/en/user/community/spatialite/index.html
>
> Any help will be appreciated.
>
> Thanks,
>
> Pedro Mendes
>
>
> ------------------------------------------------------------------------------
> Protect Your Site and Customers from Malware Attacks
> Learn about various malware tactics and how to avoid them. Understand
> malware threats, the impact they can have on your business, and how you
> can protect your company and customers by using code signing.
> http://p.sf.net/sfu/oracle-sfdevnl
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>


-- 
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
------------------------------------------------------------------------------
Protect Your Site and Customers from Malware Attacks
Learn about various malware tactics and how to avoid them. Understand 
malware threats, the impact they can have on your business, and how you 
can protect your company and customers by using code signing.
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to