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]