Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[udig-devel] [jira] Created: (UDIG-1379) ArcSDEServiceExtention preferences for connection use 
ArcSDEServiceExtention preferences for connection use
-----------------------------------------------------

                 Key: UDIG-1379
                 URL: http://jira.codehaus.org/browse/UDIG-1379
             Project: uDIG
          Issue Type: Bug
          Components: arcsde
    Affects Versions: UDIG 1.1-RC14
            Reporter: Jody Garnett
            Assignee: Jody Garnett
             Fix For: UDIG 1.2.M0


One limitation of using ArcSDE (for any java program) is having to literally pay for each connection made available by the server. When you purchase ArcSDE they hand out a limited number of connections to non ESRI software; while you can buy a license that makes more connections available to you .... we can also set an upper limit as an application preference.

Limitations:
- setting up a connection takes a *long* time; holding on to the connection is a really wise move; especially when rendering
- a single Transaction.AUTO_COMMIT connection needs to be available for the catalog to make use of when asking questions about "metadata" etc...

We need to set a Preference page up so users can set a limit on their own based on their deployment needs.

Configurations Ideas

Set the limit to 2 and wait for failure
* 1 connection is made for Transaction.AUTO_COMMIT (and is shared by all* maps with arcsde layers when rendering)
* 1 connection is made per Map that is editing an ArcSDE layer, that connection will also be used for that map when it is rendering
* this solution should be stable for working on a single map

Force limit to one:
- grab all metadata needed by the datastore using a Transaction.AUTO_COMMIT
- Force the map to kick off a Transaction right away (in order reserve it for the use of the Map)
- should be able to work on a single map this way; although I am worried the datastore + catalog will fail



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

Back to the top