RelationalDatabase connector

[Arnal, Pascal]

I have a connector that search user attributes in one database with one dependency.

        <resolver:DataConnector id="SQL" xsi:type="dc:RelationalDatabase">
                <resolver:Dependency ref="USER_DEPENDENCY" />
                <dc:ContainerManagedConnection resourceName="%{idp.attribute.resolver.SQL.jndiName}" />
                <dc:QueryTemplate>
                        <![CDATA[
                                SELECT *  FROM MyTable WHERE MyColumn IN ($USER_DEPENDENCY )
                                 ]]>
                </dc:QueryTemplate>
        </resolver:DataConnector>

I try also with
                        <![CDATA[
                                #set( $values = ['Value1', ' Value2'] )

                                #foreach( $value in $values )
                                        #if ( !$data )
                                                #set ($data = $value)
                                        #else
                                                #set ($data = "$data', '$value")
                                        #end
                                #end

                                SELECT *  FROM MyTable WHERE MyColumn IN ('$USER_DEPENDENCY' )
                                ]]>

And the result SQL query is
SELECT *  FROM MyTable WHERE MyColumn IN ('Value1'',''Value2' ) which is of course not what I want.

Thanks


-----Message d'origine-----
De : users-bounces at shibboleth.net [mailto:users-bounces at shibboleth.net] De la part de Cantor, Scott
Envoyé : 18 mars 2015 13:18
À : Shib Users
Objet : Re: RelationalDatabase connector

On 3/18/15, 1:02 PM, "Arnal, Pascal" <Pascal.Arnal at lacapitale.com> wrote:

>Hi,
>
>I would like to use RelationalDatabase in my attribute-resolver with one dependency.
>
>My querie look like :
>SELECT * FROM MyTable WHERE MyColum in (MyDependency)
>
>However, because of StringEscapeUtils.escapeSql in EscapingReferenceInsertionEventHandler
>I can’t get the correct query syntax.
>
>Is there a way to do that ?

What is it you want to do and what's not working?

-- Scott

--
To unsubscribe from this list send an email to users-unsubscribe at shibboleth.net

AVIS: Ce courriel privilégié et confidentiel est destiné à la seule personne ou entité à laquelle il est adressé. Pour toute autre personne, toute action prise en rapport à ce courriel ainsi que toute lecture, reproduction, transmission et/ou divulgation d'une partie ou de l'ensemble de celui-ci est interdite. Si vous n'êtes pas la personne autorisée à recevoir ce courriel, S.V.P. le retourner à l'expéditeur et le détruire. Bien que ce courriel ait été traité contre les virus, il est de la responsabilité du destinataire de s'assurer que l'envoi en est exempt. Nos communications avec vous peuvent contenir des renseignements confidentiels ou protégés par le secret professionnel. Si vous désirez que nous communiquions avec vous par un autre moyen de transmission que le courrier électronique ordinaire non sécurisé, veuillez nous en aviser.

NOTICE: This privileged and confidential email is intended only for the individual or entity to whom it is addressed. With regard to all others, any action related with this email as well as any reading, reproduction, transmission and/or dissemination in whole or in part of the information included in this email is prohibited. If you are not the addressee, immediately return the email to sender prior to destroying all copies. Even if this email is believed to be free from any virus, it is the responsibility of the recipient to make sure that it is virus exempt. Our communications to you may contain confidential information or information protected under solicitor-client privilege. Please advise if you wish us to use a mode of communication other than regular, unsecured e-mail in our communications with you.