Re: [Dev] [EI][DSS] NPE when trying ARRAY SQLType

[Chanika Geeganage]

Hi Nuwandi,

The parameter type should be set as ARRAY instead of SCALAR if you want to
input an array. For example,

 

However the NPE should be fixed. Can you create an issue for that.
In the request you can send the payload as in [1]

[1]
https://docs.wso2.com/display/DSS351/Data+Types+of+Mappings#DataTypesofMappings-Arraydatatype

On Sat, Oct 20, 2018 at 1:58 AM Nuwandi Wickramasinghe 
wrote:

> Hi,
>
> I'm trying (With EI 6.4.0) to create an operation for a db query where the
> input param *SQLType* is defined as an *ARRAY*. Following are the query
> details.
>
> *SQL:* SELECT ORDER_ID FROM ROLE_ORDER WHERE ROLE IN (:Roles)
>
> Input Mappings
> *Mapping Name* *Parameter Type* *Type* *Action*
> Roles SCALAR ARRAY
>
> When I try to add a New Action for above query, following error is thrown.
>
> [2018-10-20 00:01:12,604] [EI-Core] ERROR - DBDeployer The
> OrderDetailService.dbs service, which is not valid, caused {1}
>
> java.lang.NullPointerException
>
> at
> org.wso2.carbon.dataservices.core.DBUtils.getSimpleSchemaTypeName(DBUtils.java:914)
>
> at
> org.wso2.carbon.dataservices.core.DataServiceDocLitWrappedSchemaGenerator.createInputEntryElement(DataServiceDocLitWrappedSchemaGenerator.java:292)
>
>
> In DBUtils class, I *cannot see any conversionType* mapped for "ARRAY"
> SqlType (In the map [1]). Would that be the reason for this?
>
> I have a requirement to run a query in the following format where I can
> pass ROLE1, ROLE2 etc (1 or more repetitions) as SOAP input parameters. Is
> there a way to achieve that?
>
> *SELECT ORDER_ID FROM ROLE_ORDER WHERE ROLE IN ('ROLE1', 'ROLE2')*
>
> [1]
> https://github.com/wso2/carbon-data/blob/v4.4.81/components/data-services/org.wso2.carbon.dataservices.core/src/main/java/org/wso2/carbon/dataservices/core/DBUtils.java#L135
>
> thanks
> Nuwandi
> --
>
> Best Regards,
>
> Nuwandi Wickramasinghe
>
> Senior Software Engineer
>
> WSO2 Inc.
>
> Web : http://wso2.com
>
> Mobile : 0719214873
>


-- 

*Chanika Geeganage* | Associate Technical Lead | WSO2 Inc.

(m) +94-77-3522586 | (e) chan...@wso2.com


___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] [APIM 2.5.0] API Gateways not showing in store console

[Thilini Shanika]

Hi Godwin,

Further, if you don't have more than one gateway environments defined under
a given type (production, sandbox, or hybrid), API Gateway drop-down won't
be showing up in API console, since you don't have multiple gateway
endpoints to select in the drop down. That is by design and not a bug.

On Sat, Oct 20, 2018 at 5:16 AM Nuwan Dias  wrote:

> Valid types are "production", "sandbox" and "hybrid". Are you using one of
> these or something called "production and sandbox"?
>
> On Fri, Oct 19, 2018 at 9:11 PM Harsha Kumara  wrote:
>
>> @Thilini Shanika 
>>
>> On Fri, Oct 19, 2018 at 3:20 PM Godwin Shrimal  wrote:
>>
>>> Hi APIM Team,
>>>
>>> We can't see gateways in API Store Console when we use type as
>>> production and sandbox. If we use both gateways as hybrid then I can see
>>> the API Gateways in the swagger console.
>>> Is it a known issue?
>>>
>>> Thanks
>>> Godwin
>>> --
>>> *Godwin Amila Shrimal*
>>> Associate Technical Lead
>>> WSO2 Inc.; http://wso2.com
>>> lean.enterprise.middleware
>>>
>>> mobile: *+94761124419*
>>> linkedin: *https://www.linkedin.com/in/godwin-amila-2ba26844/
>>> *
>>> twitter: https://twitter.com/godwinamila
>>> 
>>>
>>
>>
>> --
>>
>> *Harsha Kumara*
>>
>> Associate Technical Lead, WSO2 Inc.
>> Mobile: +94775505618
>> Email: hars...@wso2.coim
>> Blog: harshcreationz.blogspot.com
>>
>> GET INTEGRATION AGILE
>> Integration Agility for Digitally Driven Business
>> ___
>> Dev mailing list
>> Dev@wso2.org
>> http://wso2.org/cgi-bin/mailman/listinfo/dev
>>
>
>
> --
> *Nuwan Dias* | Director | WSO2 Inc.
> (m) +94 777 775 729 | (e) nuw...@wso2.com
> [image: Signature.jpg]
>


-- 
Thilini Shanika
Associate Technical Lead
WSO2, Inc.; http://wso2.com
20, Palmgrove Avenue, Colombo 3

E-mail: tgtshan...@gmail.com
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] [APIM 2.5.0] API Gateways not showing in store console

[Nuwan Dias]

Valid types are "production", "sandbox" and "hybrid". Are you using one of
these or something called "production and sandbox"?

On Fri, Oct 19, 2018 at 9:11 PM Harsha Kumara  wrote:

> @Thilini Shanika 
>
> On Fri, Oct 19, 2018 at 3:20 PM Godwin Shrimal  wrote:
>
>> Hi APIM Team,
>>
>> We can't see gateways in API Store Console when we use type as production
>> and sandbox. If we use both gateways as hybrid then I can see the API
>> Gateways in the swagger console.
>> Is it a known issue?
>>
>> Thanks
>> Godwin
>> --
>> *Godwin Amila Shrimal*
>> Associate Technical Lead
>> WSO2 Inc.; http://wso2.com
>> lean.enterprise.middleware
>>
>> mobile: *+94761124419*
>> linkedin: *https://www.linkedin.com/in/godwin-amila-2ba26844/
>> *
>> twitter: https://twitter.com/godwinamila
>> 
>>
>
>
> --
>
> *Harsha Kumara*
>
> Associate Technical Lead, WSO2 Inc.
> Mobile: +94775505618
> Email: hars...@wso2.coim
> Blog: harshcreationz.blogspot.com
>
> GET INTEGRATION AGILE
> Integration Agility for Digitally Driven Business
> ___
> Dev mailing list
> Dev@wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>


-- 
*Nuwan Dias* | Director | WSO2 Inc.
(m) +94 777 775 729 | (e) nuw...@wso2.com
[image: Signature.jpg]
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

[Dev] [EI][DSS] NPE when trying ARRAY SQLType

[Nuwandi Wickramasinghe]

Hi,

I'm trying (With EI 6.4.0) to create an operation for a db query where the
input param *SQLType* is defined as an *ARRAY*. Following are the query
details.

*SQL:* SELECT ORDER_ID FROM ROLE_ORDER WHERE ROLE IN (:Roles)

Input Mappings
*Mapping Name* *Parameter Type* *Type* *Action*
Roles SCALAR ARRAY

When I try to add a New Action for above query, following error is thrown.

[2018-10-20 00:01:12,604] [EI-Core] ERROR - DBDeployer The
OrderDetailService.dbs service, which is not valid, caused {1}

java.lang.NullPointerException

at
org.wso2.carbon.dataservices.core.DBUtils.getSimpleSchemaTypeName(DBUtils.java:914)

at
org.wso2.carbon.dataservices.core.DataServiceDocLitWrappedSchemaGenerator.createInputEntryElement(DataServiceDocLitWrappedSchemaGenerator.java:292)


In DBUtils class, I *cannot see any conversionType* mapped for "ARRAY"
SqlType (In the map [1]). Would that be the reason for this?

I have a requirement to run a query in the following format where I can
pass ROLE1, ROLE2 etc (1 or more repetitions) as SOAP input parameters. Is
there a way to achieve that?

*SELECT ORDER_ID FROM ROLE_ORDER WHERE ROLE IN ('ROLE1', 'ROLE2')*

[1]
https://github.com/wso2/carbon-data/blob/v4.4.81/components/data-services/org.wso2.carbon.dataservices.core/src/main/java/org/wso2/carbon/dataservices/core/DBUtils.java#L135

thanks
Nuwandi
-- 

Best Regards,

Nuwandi Wickramasinghe

Senior Software Engineer

WSO2 Inc.

Web : http://wso2.com

Mobile : 0719214873
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] Issue in getting the fileName when getting the API Documents content via REST API

[Harsha Kumara]

On Fri, Oct 19, 2018 at 10:30 AM Uvindra Dias Jayasinha 
wrote:

> Here is my take on this. When I originally designed the schema I wasn't
> taking into consideration any of the practical implications associated with
> API resources being saved and retrieved at DB level. But now that we are at
> implementation stage some of these implications are much more clearer now.
>
> The AM_API_RESOURCES is a generic API resource table(For storing all file
> based resources associated with APIs). It will be storing the Swagger file,
> Ballerina file and documentation associated with the API.
>
> The AM_API_DOC_META_DATA table is specialized to store additional meta
> data only associated with documentation.
>
> Practically we need to do two calls for document uploads and adding meta
> data because we are dealing with two different content
> types(application/json for meta data and multipart/form-data for the file).
>
> All files have a name associated with them so it makes sense to have the
> file name in the AM_API_RESOURCES table. I don't think its a good idea to
> have a NULL value in a column that we are going to update later, this could
> lead to all kinds of complications that we will need to handle at code
> level. So its better to have the file name in AM_API_RESOURCES where we can
> ensure that we always have a valid name at the time of upload. It is also
> very easy for us to enforce that a file name for a given type does not get
> duplicated with a table level constraint if we go with this option.
>
> Joining between two tables like this in case we need to get the file name
> is trivial so I don't think we should let that affect us coming up with the
> best possible solution.
>
+1 it's a not good practice to add record which will update from null to
some value cause of update going for another table.

>
> So Im +1 for option 2. WDYT?
>
> On Thu, 18 Oct 2018 at 17:31, Mushthaq Rumy  wrote:
>
>> Adding @dev-wso2 
>>
>> On Thu, Oct 18, 2018 at 5:25 PM Nuwan Dias  wrote:
>>
>>> Please discuss technical problems externally.
>>>
>>> On Thu, Oct 18, 2018 at 3:44 PM Mushthaq Rumy  wrote:
>>>
 Hi All,

 While I was implementing the view page for API document (File) I came
 across an issue where we get the file name as null when using the
 micro-service to get the content of the the API document.
 While analyzing, when adding a file as an API document, I found out
 that first we save only the doc metadata  and then we save the file content
 using a second call.

 After analyzing the DB scripts I figured out that the fileName is
 stored in AM_API_DOC_META_DATA table and the content is stored in
 AM_API_RESOURCES. So during the first call we do not have the file name and
 it is saved as null. During the second call the fileName is passed to the
 micro-service but it is not stored anywhere. Hence, the fileName is null
 when we get the content of the file. So to solve this issue, I thought of
 two solutions.

 1. During the second call while adding a file document for API as we
 get the FileName to the micro-service we can retrieve the document metadata
 using the documentId and update the fileName apart from saving the content.
 Hence, it will be available when retrieving the content.

 2. We can change the fileName field from AM_API_DOC_META_DATA to
 AM_API_RESOURCES as the content of the document is stored in this table.
 And while saving the content we can save it with the fileName. Hence, it
 will be available when retrieving the content.

 IMO as option 1 will have more DB calls, option 2 would be the
 preferred solution.

 Appreciate your valuable inputs.

 Thanks & Regards,
 Mushthaq
 --
 Mushthaq Rumy
 *Senior Software Engineer*
 Mobile : +94 (0) 779 492140
 Email : musht...@wso2.com
 WSO2, Inc.; http://wso2.com/
 lean . enterprise . middleware.

 

>>>
>>>
>>> --
>>> *Nuwan Dias* | Director | WSO2 Inc.
>>> (m) +94 777 775 729 | (e) nuw...@wso2.com
>>> [image: Signature.jpg]
>>>
>>
>>
>> --
>> Mushthaq Rumy
>> *Senior Software Engineer*
>> Mobile : +94 (0) 779 492140
>> Email : musht...@wso2.com
>> WSO2, Inc.; http://wso2.com/
>> lean . enterprise . middleware.
>>
>> 
>>
>
>
> --
> Regards,
> Uvindra
>
> Mobile: 33962
>


-- 

*Harsha Kumara*

Associate Technical Lead, WSO2 Inc.
Mobile: +94775505618
Email: hars...@wso2.coim
Blog: harshcreationz.blogspot.com

GET INTEGRATION AGILE
Integration Agility for Digitally Driven Business
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] [APIM 2.5.0] API Gateways not showing in store console

[Harsha Kumara]

@Thilini Shanika 

On Fri, Oct 19, 2018 at 3:20 PM Godwin Shrimal  wrote:

> Hi APIM Team,
>
> We can't see gateways in API Store Console when we use type as production
> and sandbox. If we use both gateways as hybrid then I can see the API
> Gateways in the swagger console.
> Is it a known issue?
>
> Thanks
> Godwin
> --
> *Godwin Amila Shrimal*
> Associate Technical Lead
> WSO2 Inc.; http://wso2.com
> lean.enterprise.middleware
>
> mobile: *+94761124419*
> linkedin: *https://www.linkedin.com/in/godwin-amila-2ba26844/
> *
> twitter: https://twitter.com/godwinamila
> 
>


-- 

*Harsha Kumara*

Associate Technical Lead, WSO2 Inc.
Mobile: +94775505618
Email: hars...@wso2.coim
Blog: harshcreationz.blogspot.com

GET INTEGRATION AGILE
Integration Agility for Digitally Driven Business
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Re: [Dev] [IS] InCommon Federation Compliance for WSO2IS - UI Component

[Johann Nallathamby]

Hi Sahan,

Two concerns here:
1. Is the placement of the feature in the menu correct?
2. I don't know if it was intensional, but isn't it better to avoid
InCommon logos and only label it using standard federation terminology?
Because we haven't done it like that so far for other profiles such as
eIDAS. But again I don't know if this is intensional to get traction to the
product.

Regards,
Johann.

On Wed, Sep 26, 2018 at 8:26 AM Sahan Gunathilaka  wrote:

> Hi All,
> One of the major requirements to comply WSO2 IS with InCommon Federation
> is to support *auto refreshment* of metadata of participating Service
> Providers and Identity Providers at IS. Following is the designed UI to
> provide this requirement.
>
> [image: Screenshot_2018-09-26 WSO2 Management Console.png]
>
> *"Enable Auto Refresh*" check box and "*Refresh Time*" drop box can be
> set to automate the refreshing cycle. All service providers' and identity
> providers' configurations will be updated according to them after clicking
> on "*Save*" button.
>
> "*Force Refresh*" button lets users to refresh metadata instantly based
> on the latest update of metadata file at the InCommon Federation.
>
> "*Clear All*" button will remove all the configured data and result "0"
> for both "Total Service Providers" and "Total Identity Providers" in the
> table.
>
> If you have any suggestion on this, please let me know.
>
> Thank you!
> Best Regards!
>
> --
> *Sahan Gunathilaka*
> Intern - Software Engineering
> *WSO2*
> mobile:  +94776343266
>
> [image: http://wso2.com/signature]
>
> ___
> Dev mailing list
> Dev@wso2.org
> http://wso2.org/cgi-bin/mailman/listinfo/dev
>


-- 

*Johann Dilantha Nallathamby*
Senior Lead Solutions Engineer
WSO2, Inc.
lean.enterprise.middleware

Mobile: *+94 77 7776950*
LinkedIn: *http://www.linkedin.com/in/johann-nallathamby
*
Medium: *https://medium.com/@johann_nallathamby
*
Twitter: *@dj_nallaa*
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

[Dev] [APIM 2.5.0] API Gateways not showing in store console

[Godwin Shrimal]

Hi APIM Team,

We can't see gateways in API Store Console when we use type as production
and sandbox. If we use both gateways as hybrid then I can see the API
Gateways in the swagger console.
Is it a known issue?

Thanks
Godwin
-- 
*Godwin Amila Shrimal*
Associate Technical Lead
WSO2 Inc.; http://wso2.com
lean.enterprise.middleware

mobile: *+94761124419*
linkedin: *https://www.linkedin.com/in/godwin-amila-2ba26844/
*
twitter: https://twitter.com/godwinamila

___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

[Dev] How to secure STS with Issued Token in WSO2 IS?

[Joni Lee]

Dear developers,
I want to secure an STS with an issued token over the transport layer (i.e., an 
STS Client sends a RequestSecurityToken to the STS with a SAML assertion in the 
security header for authentication).
It found wso2-rampart has the following implementation for SAML assertion:
https://github.com/wso2/wso2-rampart/blob/master/modules/rampart-trust/src/main/java/org/apache/rahas/RahasData.java#L200
However, in WSO2 IS, I cannot find an appropriate security policy in the 
"Security Token Service Configuration".
Do you have any advices for me?
Many thanks

___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

[Dev] WSO2 API Manager 3.0.0-M31 Released!

[Tharindu Dharmarathna]

The WSO2 API Manager team is pleased to announce the release of API Manager
3.0.0-M31. It's now available to download.


## *Distribution*

- [wso2apim-3.0.0-m31](
https://github.com/wso2/product-apim/releases/download/v3.0.0-m31/wso2apim-3.0.0-m31.zip
)


## *Documentation*

- [WSO2 API Manager 3.0.0](https://docs.wso2.com/display/AM300/)

Following list contains all the features, improvements and bug fixes
available with this milestone.


## *Bug Fixes*

- [Product-APIM Bug fixses](
https://github.com/wso2/product-apim/issues?q=is%3Aissue+milestone%3A3.0.0-m31+is%3Aclosed
)

## *Improvements*

- [Product-APIM improvments](
https://github.com/wso2/product-apim/issues?utf8=%E2%9C%93=is%3Aissue+is%3Aclosed+milestone%3A3.0.0-m31+label%3AType%2FImprovement+
)

##* List of Open Issues*

- Open Issues for [Product-APIM](
https://github.com/wso2/product-apim/issues?q=is%3Aopen+is%3Aissue+label%3A3.
0.0+label%3AType%2FBug)

## *How To Contribute*

Your feedback is most welcome!


## *Mailing Lists*
```
Join our mailing list and collaborate with the developers directly.
```
Developer List : dev@wso2.org | Subscribe | [Mail Archive](
http://mail.wso2.org/mailarchive/dev/)

- User Forum : [StackOverflow](
https://stackoverflow.com/questions/tagged/wso2-am)

*Reporting Issues*

We encourage you to report issues, improvements and feature requests
regarding WSO2 API Manager through [WSO2 API Manager GIT Issues](
https://github.com/wso2/product-apim/issues).

*~ WSO2 API Manager Team ~*

Thanks

*Tharindu Dharmarathna*Associate Technical Lead
WSO2 Inc.; http://wso2.com
lean.enterprise.middleware
___
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev