Error: Could not insert

Hi there,

I'm running jasperreports-server-cp-4.5.0 on Debian Sqeeze (AWS).

I installed using both bundled tomcat and postgresql, everything seemd to go well untill, in the web interface I tried adding a datasource from a remote (read-only) postgresql database. I can add the DB, and even successfully test the connection (passed!) but when I create the source I get the belowe errors output in the page. My first thought was a permissions issue on the Jaspersoft database, but that doesn't seem to be the case. Anybody else experienced this?

 

Error Message

com.jaspersoft.jasperserver.api.JSExceptionWrapper: could not insert: [com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.impl.datasource.RepoJdbcDataSource]; nested exception is org.hibernate.exception.DataException: could not insert: [com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.impl.datasource.RepoJdbcDataSource]

 

Error Message

org.springframework.dao.DataIntegrityViolationException: could not insert: [com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.impl.datasource.RepoJdbcDataSource]; nested exception is org.hibernate.exception.DataException: could not insert: [com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.impl.datasource.RepoJdbcDataSource]

Error Message

org.hibernate.exception.DataException: could not insert: [com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.impl.datasource.RepoJdbcDataSource]

 

 

And the console:  ERROR:  value too long for type character varying(100)   - STATEMENT:  insert into JIJdbcDatasource (driver, password, connectionUrl, username, timezone, id) values ($1, $2, $3, $4, $5, $6)
 
 
 
 
 

 

 

devanw's picture
1
Joined: Feb 3 2012 - 3:18am
Last seen: 11 years 8 months ago

1 Answer:

It looks like one of the columns in the JIJdbcDatasource table is varying(100) and what you are trying to insert must be longer than that. I just ran into this error trying to add a jdbc connection to google bigquery.

mark.brown's picture
Joined: Oct 16 2012 - 2:11pm
Last seen: 10 years 8 months ago
Feedback
randomness