A datastore exception ... is forbidden - help

3 messages Options
Embed this post
Permalink
Chandler, Peter - 0443 - MITLL

A datastore exception ... is forbidden - help

Reply Threaded More More options
Print post
Permalink
Some javascript/style in this post has been disabled (why?)

I created a new feature type (and namespace) and tried a WFS transaction/insert. The result was a datastore exception (below).

Does anyone know how to correct this error? What am I doing wrong?

 

Thanks in advance,

 

Peter.

 

Request:

<?xml version="1.0" encoding="UTF-8"?>

<wfs:Transaction version="1.1.0" service="WFS" xmlns:app="http://www.deegree.org/app"

    xmlns:sch="http://www.ascc.net/xml/schematron" xmlns:dgjdbc="http://www.deegree.org/jdbc"

    xmlns:deegreewfs="http://www.deegree.org/wfs" xmlns:gml="http://www.opengis.net/gml"

    xmlns:ogc="http://www.opengis.net/ogc" xmlns:wfs="http://www.opengis.net/wfs"

    xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mynamespace="http://www.my.com/mynamespace/1.0"

    xmlns:ns2="http://www.opengis.net/gml"

    xmlns:ns3="http://www.w3.org/1999/xlink"

    xsi:schemaLocation="http://www.my.com/mynamespace/1.0 file:/export/home/paris/1/pchandler/programs/apache-tomcat-6.0.20/webapps/deegree-wfs/WEB-INF/conf/wfs/featuretypes/mymynamespace.xsd">

    <wfs:Insert handle="insert" idgen="GenerateNew">

        <wfs:FeatureCollection>

            <gml:featureMember>

                <mynamespace:mynamespaceschema gml:id="mynamespaceSCHEMA_1">

                    <mynamespace:myattribute>myattribute0</mynamespace:myattribute>

                </mynamespace:mynamespaceschema>

            </gml:featureMember>

        </wfs:FeatureCollection>

    </wfs:Insert>

</wfs:Transaction>

 

RESPONSE:

<ServiceExceptionReport>

  <ServiceException locator="org.deegree.ogcwebservices.wfs.TransactionHandler">

     A datastore exception occured during the processing of operation with handle 'insert': Insertion of features with type "mynamespace:mynamespaceschema      (mynamespace=http://www.my.com/mynamespace/1.0)" is forbidden (insert=false).

  </ServiceException>

</ServiceExceptionReport>

 

TOMCAT LOG:

[17:50:54]  INFO: WFS successfully initialized.

[17:50:54]  INFO: -------------------------------------------------------------------------------

[17:50:54]  INFO: Initialized successfully (context 'deegree WFS 2.2'):

[17:50:54]  INFO: - WFS

[17:50:54]  INFO: -------------------------------------------------------------------------------

Oct 30, 2009 5:50:54 PM org.apache.coyote.http11.Http11Protocol start

INFO: Starting Coyote HTTP/1.1 on http-8080

Oct 30, 2009 5:50:54 PM org.apache.jk.common.ChannelSocket init

INFO: JK: ajp13 listening on /0.0.0.0:8009

Oct 30, 2009 5:50:54 PM org.apache.jk.server.JkMain start

INFO: Jk running ID=0 time=1/15  config=null

Oct 30, 2009 5:50:54 PM org.apache.catalina.startup.Catalina start

INFO: Server startup in 5113 ms

[17:51:09]  INFO: Handling request '0' from '127.0.0.1' to service: 'WFS'

[17:51:09]  INFO: No working directory for the lock manager specified. Using default temp directory: '/export/home/paris/1/pchandler/programs/apache-tomcat-6.0.20/temp'

[17:51:09]  INFO: Lock manager will use directory '/export/home/paris/1/pchandler/programs/apache-tomcat-6.0.20/temp' to persist it's locks.

[17:51:09]  INFO: Restoring 0 locks from directory "/export/home/paris/1/pchandler/programs/apache-tomcat-6.0.20/temp".

[17:51:09]  INFO: pool configuration read from pool.properties

[17:51:09] ERROR: Insertion of features with type "mynamespace:mynamespaceschema (mynamespace=http://www.my.com/mynamespace/1.0)" is forbidden (insert=false).

org.deegree.io.datastore.TransactionException: Insertion of features with type "mynamespace:mynamespaceschema (mynamespace=http://www.my.com/mynamespace/1.0)" is forbidden (insert=false).

                at org.deegree.io.datastore.sql.transaction.insert.InsertHandler.insertFeature(InsertHandler.java:202)

                at org.deegree.io.datastore.sql.transaction.insert.InsertHandler.performInsert(InsertHandler.java:144)

                at org.deegree.io.datastore.sql.transaction.SQLTransaction.performInsert(SQLTransaction.java:173)

                at org.deegree.ogcwebservices.wfs.TransactionHandler.performInsert(TransactionHandler.java:496)

                at org.deegree.ogcwebservices.wfs.TransactionHandler.performOperations(TransactionHandler.java:401)

                at org.deegree.ogcwebservices.wfs.TransactionHandler.handleRequest(TransactionHandler.java:150)

                at org.deegree.ogcwebservices.wfs.WFService.doService(WFService.java:151)

                at org.deegree.enterprise.servlet.WFSHandler.performTransaction(WFSHandler.java:663)

                at org.deegree.enterprise.servlet.WFSHandler.perform(WFSHandler.java:169)

                at org.deegree.enterprise.servlet.OGCServletController.doService(OGCServletController.java:151)

                at org.deegree.enterprise.servlet.OGCServletController.doPost(OGCServletController.java:314)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

                 ….

 [17:51:09]  INFO: Error while performing WFS request.

org.deegree.ogcwebservices.OGCWebServiceException: datastore exception occured during the processing of operation with handle 'insert': Insertion of features with type "mynamespace:mynamespaceschema (mynamespace=http://www.my.com/mynamespace/1.0)" is forbidden (insert=false).

                at org.deegree.ogcwebservices.wfs.TransactionHandler.performOperations(TransactionHandler.java:421)

                at org.deegree.ogcwebservices.wfs.TransactionHandler.handleRequest(TransactionHandler.java:150)

                at org.deegree.ogcwebservices.wfs.WFService.doService(WFService.java:151)

                at org.deegree.enterprise.servlet.WFSHandler.performTransaction(WFSHandler.java:663)

                at org.deegree.enterprise.servlet.WFSHandler.perform(WFSHandler.java:169)

                at org.deegree.enterprise.servlet.OGCServletController.doService(OGCServletController.java:151)

                at org.deegree.enterprise.servlet.OGCServletController.doPost(OGCServletController.java:314)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

                …

 [17:51:09]  WARN: Going to buffer response body of large or unknown size. Using getResponseAsStream instead is recommended.

 

 

Peter Chandler

MIT Lincoln Laboratory

244 Wood Street

Lexington, MA  02420

Email:  [hidden email]

781-981-3938

 


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
deegree-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/deegree-users
Chandler, Peter - 0443 - MITLL

Re: A datastore exception ... is forbidden - help

Reply Threaded More More options
Print post
Permalink
Some javascript/style in this post has been disabled (why?)

Looked at the code a bit, and my “MappedFeatureType” is not Insertable?

Question How do you make a featuretype insertable?

 

199            MappedFeatureType ft = (MappedFeatureType) feature.getFeatureType();

200            if ( !ft.isInsertable() ) {

201                String msg = Messages.getMessage( "DATASTORE_FT_NOT_INSERTABLE", ft.getName() );

202                throw new TransactionException( msg );

203            }

 

 

From: Chandler, Peter - 0443 - MITLL
Sent: Monday, November 02, 2009 9:52 AM
To: '[hidden email]'
Subject: A datastore exception ... is forbidden - help

 

I created a new feature type (and namespace) and tried a WFS transaction/insert. The result was a datastore exception (below).

Does anyone know how to correct this error? What am I doing wrong?

 

Thanks in advance,

 

Peter.

 

Request:

<?xml version="1.0" encoding="UTF-8"?>

<wfs:Transaction version="1.1.0" service="WFS" xmlns:app="http://www.deegree.org/app"

    xmlns:sch="http://www.ascc.net/xml/schematron" xmlns:dgjdbc="http://www.deegree.org/jdbc"

    xmlns:deegreewfs="http://www.deegree.org/wfs" xmlns:gml="http://www.opengis.net/gml"

    xmlns:ogc="http://www.opengis.net/ogc" xmlns:wfs="http://www.opengis.net/wfs"

    xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mynamespace="http://www.my.com/mynamespace/1.0"

    xmlns:ns2="http://www.opengis.net/gml"

    xmlns:ns3="http://www.w3.org/1999/xlink"

    xsi:schemaLocation="http://www.my.com/mynamespace/1.0 file:/export/home/paris/1/pchandler/programs/apache-tomcat-6.0.20/webapps/deegree-wfs/WEB-INF/conf/wfs/featuretypes/mymynamespace.xsd">

    <wfs:Insert handle="insert" idgen="GenerateNew">

        <wfs:FeatureCollection>

            <gml:featureMember>

                <mynamespace:mynamespaceschema gml:id="mynamespaceSCHEMA_1">

                    <mynamespace:myattribute>myattribute0</mynamespace:myattribute>

                </mynamespace:mynamespaceschema>

            </gml:featureMember>

        </wfs:FeatureCollection>

    </wfs:Insert>

</wfs:Transaction>

 

RESPONSE:

<ServiceExceptionReport>

  <ServiceException locator="org.deegree.ogcwebservices.wfs.TransactionHandler">

     A datastore exception occured during the processing of operation with handle 'insert': Insertion of features with type "mynamespace:mynamespaceschema      (mynamespace=http://www.my.com/mynamespace/1.0)" is forbidden (insert=false).

  </ServiceException>

</ServiceExceptionReport>

 

TOMCAT LOG:

[17:50:54]  INFO: WFS successfully initialized.

[17:50:54]  INFO: -------------------------------------------------------------------------------

[17:50:54]  INFO: Initialized successfully (context 'deegree WFS 2.2'):

[17:50:54]  INFO: - WFS

[17:50:54]  INFO: -------------------------------------------------------------------------------

Oct 30, 2009 5:50:54 PM org.apache.coyote.http11.Http11Protocol start

INFO: Starting Coyote HTTP/1.1 on http-8080

Oct 30, 2009 5:50:54 PM org.apache.jk.common.ChannelSocket init

INFO: JK: ajp13 listening on /0.0.0.0:8009

Oct 30, 2009 5:50:54 PM org.apache.jk.server.JkMain start

INFO: Jk running ID=0 time=1/15  config=null

Oct 30, 2009 5:50:54 PM org.apache.catalina.startup.Catalina start

INFO: Server startup in 5113 ms

[17:51:09]  INFO: Handling request '0' from '127.0.0.1' to service: 'WFS'

[17:51:09]  INFO: No working directory for the lock manager specified. Using default temp directory: '/export/home/paris/1/pchandler/programs/apache-tomcat-6.0.20/temp'

[17:51:09]  INFO: Lock manager will use directory '/export/home/paris/1/pchandler/programs/apache-tomcat-6.0.20/temp' to persist it's locks.

[17:51:09]  INFO: Restoring 0 locks from directory "/export/home/paris/1/pchandler/programs/apache-tomcat-6.0.20/temp".

[17:51:09]  INFO: pool configuration read from pool.properties

[17:51:09] ERROR: Insertion of features with type "mynamespace:mynamespaceschema (mynamespace=http://www.my.com/mynamespace/1.0)" is forbidden (insert=false).

org.deegree.io.datastore.TransactionException: Insertion of features with type "mynamespace:mynamespaceschema (mynamespace=http://www.my.com/mynamespace/1.0)" is forbidden (insert=false).

                at org.deegree.io.datastore.sql.transaction.insert.InsertHandler.insertFeature(InsertHandler.java:202)

                at org.deegree.io.datastore.sql.transaction.insert.InsertHandler.performInsert(InsertHandler.java:144)

                at org.deegree.io.datastore.sql.transaction.SQLTransaction.performInsert(SQLTransaction.java:173)

                at org.deegree.ogcwebservices.wfs.TransactionHandler.performInsert(TransactionHandler.java:496)

                at org.deegree.ogcwebservices.wfs.TransactionHandler.performOperations(TransactionHandler.java:401)

                at org.deegree.ogcwebservices.wfs.TransactionHandler.handleRequest(TransactionHandler.java:150)

                at org.deegree.ogcwebservices.wfs.WFService.doService(WFService.java:151)

                at org.deegree.enterprise.servlet.WFSHandler.performTransaction(WFSHandler.java:663)

                at org.deegree.enterprise.servlet.WFSHandler.perform(WFSHandler.java:169)

                at org.deegree.enterprise.servlet.OGCServletController.doService(OGCServletController.java:151)

                at org.deegree.enterprise.servlet.OGCServletController.doPost(OGCServletController.java:314)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

                 ….

 [17:51:09]  INFO: Error while performing WFS request.

org.deegree.ogcwebservices.OGCWebServiceException: datastore exception occured during the processing of operation with handle 'insert': Insertion of features with type "mynamespace:mynamespaceschema (mynamespace=http://www.my.com/mynamespace/1.0)" is forbidden (insert=false).

                at org.deegree.ogcwebservices.wfs.TransactionHandler.performOperations(TransactionHandler.java:421)

                at org.deegree.ogcwebservices.wfs.TransactionHandler.handleRequest(TransactionHandler.java:150)

                at org.deegree.ogcwebservices.wfs.WFService.doService(WFService.java:151)

                at org.deegree.enterprise.servlet.WFSHandler.performTransaction(WFSHandler.java:663)

                at org.deegree.enterprise.servlet.WFSHandler.perform(WFSHandler.java:169)

                at org.deegree.enterprise.servlet.OGCServletController.doService(OGCServletController.java:151)

                at org.deegree.enterprise.servlet.OGCServletController.doPost(OGCServletController.java:314)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

                …

 [17:51:09]  WARN: Going to buffer response body of large or unknown size. Using getResponseAsStream instead is recommended.

 

 

Peter Chandler

MIT Lincoln Laboratory

244 Wood Street

Lexington, MA  02420

Email:  [hidden email]

781-981-3938

 


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
deegree-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/deegree-users
Chandler, Peter - 0443 - MITLL

Re: A datastore exception ... is forbidden - help

Reply Threaded More More options
Print post
Permalink
Some javascript/style in this post has been disabled (why?)

I solved this myself (my mistake), forgot the:

 

             <deegreewfs:transaction update="true" delete="true" insert="true"/>

 

Thanks for looking it this,

 

Regards,

 

Peter.

 

From: Chandler, Peter - 0443 - MITLL
Sent: Monday, November 02, 2009 10:22 AM
To: '[hidden email]'
Subject: RE: A datastore exception ... is forbidden - help

 

Looked at the code a bit, and my “MappedFeatureType” is not Insertable?

Question How do you make a featuretype insertable?

 

199            MappedFeatureType ft = (MappedFeatureType) feature.getFeatureType();

200            if ( !ft.isInsertable() ) {

201                String msg = Messages.getMessage( "DATASTORE_FT_NOT_INSERTABLE", ft.getName() );

202                throw new TransactionException( msg );

203            }

 

 

From: Chandler, Peter - 0443 - MITLL
Sent: Monday, November 02, 2009 9:52 AM
To: '[hidden email]'
Subject: A datastore exception ... is forbidden - help

 

I created a new feature type (and namespace) and tried a WFS transaction/insert. The result was a datastore exception (below).

Does anyone know how to correct this error? What am I doing wrong?

 

Thanks in advance,

 

Peter.

 

Request:

<?xml version="1.0" encoding="UTF-8"?>

<wfs:Transaction version="1.1.0" service="WFS" xmlns:app="http://www.deegree.org/app"

    xmlns:sch="http://www.ascc.net/xml/schematron" xmlns:dgjdbc="http://www.deegree.org/jdbc"

    xmlns:deegreewfs="http://www.deegree.org/wfs" xmlns:gml="http://www.opengis.net/gml"

    xmlns:ogc="http://www.opengis.net/ogc" xmlns:wfs="http://www.opengis.net/wfs"

    xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mynamespace="http://www.my.com/mynamespace/1.0"

    xmlns:ns2="http://www.opengis.net/gml"

    xmlns:ns3="http://www.w3.org/1999/xlink"

    xsi:schemaLocation="http://www.my.com/mynamespace/1.0 file:/export/home/paris/1/pchandler/programs/apache-tomcat-6.0.20/webapps/deegree-wfs/WEB-INF/conf/wfs/featuretypes/mymynamespace.xsd">

    <wfs:Insert handle="insert" idgen="GenerateNew">

        <wfs:FeatureCollection>

            <gml:featureMember>

                <mynamespace:mynamespaceschema gml:id="mynamespaceSCHEMA_1">

                    <mynamespace:myattribute>myattribute0</mynamespace:myattribute>

                </mynamespace:mynamespaceschema>

            </gml:featureMember>

        </wfs:FeatureCollection>

    </wfs:Insert>

</wfs:Transaction>

 

RESPONSE:

<ServiceExceptionReport>

  <ServiceException locator="org.deegree.ogcwebservices.wfs.TransactionHandler">

     A datastore exception occured during the processing of operation with handle 'insert': Insertion of features with type "mynamespace:mynamespaceschema      (mynamespace=http://www.my.com/mynamespace/1.0)" is forbidden (insert=false).

  </ServiceException>

</ServiceExceptionReport>

 

TOMCAT LOG:

[17:50:54]  INFO: WFS successfully initialized.

[17:50:54]  INFO: -------------------------------------------------------------------------------

[17:50:54]  INFO: Initialized successfully (context 'deegree WFS 2.2'):

[17:50:54]  INFO: - WFS

[17:50:54]  INFO: -------------------------------------------------------------------------------

Oct 30, 2009 5:50:54 PM org.apache.coyote.http11.Http11Protocol start

INFO: Starting Coyote HTTP/1.1 on http-8080

Oct 30, 2009 5:50:54 PM org.apache.jk.common.ChannelSocket init

INFO: JK: ajp13 listening on /0.0.0.0:8009

Oct 30, 2009 5:50:54 PM org.apache.jk.server.JkMain start

INFO: Jk running ID=0 time=1/15  config=null

Oct 30, 2009 5:50:54 PM org.apache.catalina.startup.Catalina start

INFO: Server startup in 5113 ms

[17:51:09]  INFO: Handling request '0' from '127.0.0.1' to service: 'WFS'

[17:51:09]  INFO: No working directory for the lock manager specified. Using default temp directory: '/export/home/paris/1/pchandler/programs/apache-tomcat-6.0.20/temp'

[17:51:09]  INFO: Lock manager will use directory '/export/home/paris/1/pchandler/programs/apache-tomcat-6.0.20/temp' to persist it's locks.

[17:51:09]  INFO: Restoring 0 locks from directory "/export/home/paris/1/pchandler/programs/apache-tomcat-6.0.20/temp".

[17:51:09]  INFO: pool configuration read from pool.properties

[17:51:09] ERROR: Insertion of features with type "mynamespace:mynamespaceschema (mynamespace=http://www.my.com/mynamespace/1.0)" is forbidden (insert=false).

org.deegree.io.datastore.TransactionException: Insertion of features with type "mynamespace:mynamespaceschema (mynamespace=http://www.my.com/mynamespace/1.0)" is forbidden (insert=false).

                at org.deegree.io.datastore.sql.transaction.insert.InsertHandler.insertFeature(InsertHandler.java:202)

                at org.deegree.io.datastore.sql.transaction.insert.InsertHandler.performInsert(InsertHandler.java:144)

                at org.deegree.io.datastore.sql.transaction.SQLTransaction.performInsert(SQLTransaction.java:173)

                at org.deegree.ogcwebservices.wfs.TransactionHandler.performInsert(TransactionHandler.java:496)

                at org.deegree.ogcwebservices.wfs.TransactionHandler.performOperations(TransactionHandler.java:401)

                at org.deegree.ogcwebservices.wfs.TransactionHandler.handleRequest(TransactionHandler.java:150)

                at org.deegree.ogcwebservices.wfs.WFService.doService(WFService.java:151)

                at org.deegree.enterprise.servlet.WFSHandler.performTransaction(WFSHandler.java:663)

                at org.deegree.enterprise.servlet.WFSHandler.perform(WFSHandler.java:169)

                at org.deegree.enterprise.servlet.OGCServletController.doService(OGCServletController.java:151)

                at org.deegree.enterprise.servlet.OGCServletController.doPost(OGCServletController.java:314)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

                 ….

 [17:51:09]  INFO: Error while performing WFS request.

org.deegree.ogcwebservices.OGCWebServiceException: datastore exception occured during the processing of operation with handle 'insert': Insertion of features with type "mynamespace:mynamespaceschema (mynamespace=http://www.my.com/mynamespace/1.0)" is forbidden (insert=false).

                at org.deegree.ogcwebservices.wfs.TransactionHandler.performOperations(TransactionHandler.java:421)

                at org.deegree.ogcwebservices.wfs.TransactionHandler.handleRequest(TransactionHandler.java:150)

                at org.deegree.ogcwebservices.wfs.WFService.doService(WFService.java:151)

                at org.deegree.enterprise.servlet.WFSHandler.performTransaction(WFSHandler.java:663)

                at org.deegree.enterprise.servlet.WFSHandler.perform(WFSHandler.java:169)

                at org.deegree.enterprise.servlet.OGCServletController.doService(OGCServletController.java:151)

                at org.deegree.enterprise.servlet.OGCServletController.doPost(OGCServletController.java:314)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

                …

 [17:51:09]  WARN: Going to buffer response body of large or unknown size. Using getResponseAsStream instead is recommended.

 

 

Peter Chandler

MIT Lincoln Laboratory

244 Wood Street

Lexington, MA  02420

Email:  [hidden email]

781-981-3938

 


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
deegree-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/deegree-users