[teiid-issues] [JBoss JIRA] (TEIID-3617) Provide an option to Limit per user based connections

[Kylin Soong (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13254556#comment-13254556 ] 

Kylin Soong commented on TEIID-3617:
------------------------------------

I have done a updates(https://github.com/teiid/teiid/pull/726), add 3 cli to do this:
{code}
/subsystem=teiid/transport=jdbc:add-max-session-per-user(username=teiidUser,max-sessions=25)
/subsystem=teiid/transport=jdbc:remove-max-session-per-user(username=teiidUser)
/subsystem=teiid/transport=jdbc:max-session-per-user()
{code}

If use embedded, use EmbeddedConfiguration as below
{code}
EmbeddedConfiguration config = new EmbeddedConfiguration();
config.addMaxSessionPerUser("anonymous", 3);
embeddedserver.start(config);
{code}

Any comments, suggests feel free let me know.

> Provide an option to Limit per user based connections
> -----------------------------------------------------
>
>                 Key: TEIID-3617
>                 URL: https://issues.jboss.org/browse/TEIID-3617
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Server
>            Reporter: Xian Liu
>            Assignee: Kylin Soong
>             Fix For: 9.1
>
>
> we deploy teiid for users to get data, but some users will create many connections to teiid and they are not necessary, I need to find a good way to limit each user account can only get like 50 connections or so



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)