Using a space in JDBC connection URL

[jdiggs]

I am attempting to modify an existing and working data source that uses a space in the connection string.  The data source was recently migrated from jasper server 5.1 to 5.5 without a problem.

Now when I attempt to update this connection string I receive an error stating that I have an invalid character.  When taking out the space, the connection works, but does not perform as required.

Is there a way I can edit this connection string behind the scenes and force it to accept the blank space in the connection string?  Maybe there is a table I can update?

[hozawa]

Can you save your URL string? I had other problems with the datasource page but if I just directly enter the url string in the "URL" and ignore "host" and "port" settings and igrnore the error message, datasource worked OK. Also, skip 5.5 and use 5.6.1. 5.5 was too buggy.

[jdiggs]

Unfortunately, the save option is completely disabled for me. Can anyone with 5.6 give this a try and let me know if you can save your data source with a space in it? I would hate to upgrade only to find out it makes no difference.

 

From the sound of it, it might be worth the upgrade anyhow, but I hate to churn if I can avoid it.

[jdiggs]

I was able to work around this by updating table jijdbcdatasource and updating column connectionurl with the psql command.