profield external data sources connection issue

[Stefano Bicego]

Hi, i have tried to connect to external db mysql on other host. this is the log message:

Sep 6, 2013 4:03:01 PM com.sun.jersey.spi.container.servlet.WebComponent filterFormParameters

WARNING: A servlet POST request, to the URI https://xxxx.com/rest/profields/1.0/queryselect/getconnection?0.1814490999095142, contains form parameters in the request body but the request body has been consumed by the servlet or a servlet filter accessing the request parameters. Only resource methods using @FormParam will work as expected. Resource methods consuming the request body by other means will not work as expected.

i think the issue is around the number of parameters supported in the connection string. User and Pwd are not supported.....

Could you help me ?

[carlos.fernandez]

We don't know what is happened with your "Test connection" resource, because we have tested with the same environment and it worked.

Maybe a system or external configuration is causing the Atlassian Rest plugin warning.

Anyway, can you try to save the connection even if the Test fails and using it in a field?

[carlos.fernandez]

Hello Stefano,

We have tried in an environment like yours with a standard jdbc connection string:

jdbc:mysql://server_ip/database?user=????&password=????

And we haven't had any errors.

Could you send us an example of your connection string?

Regards.

[Stefano Bicego]

jdbc:mysql://my_ip:3306/my_db?user=my_user&password=my_pwd

[carlos.fernandez]

Hello, sorry for the delay on the answer

We couldn't reproduce the error. Could you please send us more information about your environment? Like database server, Profields version...

Regards.

[Stefano Bicego]

jira version: 5.2.1

db version mysql 5.5

profields version: 3.0.5

[Stefano Bicego]

Hi Carlos,

no, the connection failed. The message is like you have not inserted the password, but the password is good. I can't update now to 6, because some plugins are not yet compliant.

Waiting good news from your side...

Thank you

[carlos.fernandez]

Hello Stephano,

Can you finally create the connection?

It seems an Atlassian Rest plugin issue. You can see more details here:

https://jira.atlassian.com/browse/JRA-29661

https://ecosystem.atlassian.net/browse/REST-200

Probably if you upgrade to Jira 6+, the warning won't show again.

Anyway we will try to reproduce the warning in our environment and try to solve it without the Jira upgrade

Regards.

[Stefano Bicego]

Do you have a news ?

[Guillermo _DEISER_]

Hello Stefano;

Thank you for your feedback and sorry for the incovenience. Of course wwe can help you. We will try to forward your question to the product team. Would you mind to create an issue in our supporting service at http://www.madeira20.com - It will let you keep the track of any news or updatea bout the evolution of the problem fixing.

Kind Regards

[Stefano Bicego]

ok, done....