mr.john.lynn Posted March 20, 2013 Share Posted March 20, 2013 I fired up my nice shiny new Jaspersoft 5.0.3 instance in Amazon EC2, and the first thing that I tried to do was add a JDBC data source. So I went to Create and then Data Source, and filled out all the information to point to a mySQL database that resides in another AWS instance. I clicked the "Test Connection" button and got the message "Connection passed" at the top of the screen. When I hit Submit to save the data source, I get a many-pages-long exception and stack trace. Looking at the stack trace, it looks like the main cause is: "org.postgresql.util.PSQLException: ERROR: value too long for type character varying(100)"Which value is too long? There's nothing unusual about this data source. And Test Connection was happy with it.Any ideas of what to do would be greatly appreciated! Link to comment Share on other sites More sharing options...
Solution mr.john.lynn Posted March 20, 2013 Author Solution Share Posted March 20, 2013 Problem is solved. The password for the data source is 50 characters long, which I guess is expanded because of encryption before storing it. The Password field on that data source web form should limit the field to some maximum length, in my opinion. For now, I changed my datasource password to be a short string. Link to comment Share on other sites More sharing options...
egeorge Posted November 6, 2014 Share Posted November 6, 2014 I resolved this by altering the table in the jasperserver database. I increased the field size from 100 to 500, although I don't think this is a very good solution at all.alter table jijdbcdatasource alter column password type varchar(500);I agree with mr.john.lynn that if there is a true limit, then it should be reflected in the datasource creation web interface. Link to comment Share on other sites More sharing options...
paparajuphani_1 Posted December 18, 2021 Share Posted December 18, 2021 just updated to 8.0.0 and trying to create an Azure SQL datasource. The "Azure user Certificate Password" is throwing me the value too long for type character varying(100). The value i am populating is less than 50 characters Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now