jsexception.error.creating.connection

[bisouelle]

Hi,

I use jasperserver 3.5.0 on windows

I do a  report using iReport agains Infomix database and it works fine.

I put the Informix JDBC driver JAR(s) in the application server classpath /WEB-INF/lib

and i set up the Informix data source in JasperServer,the Test Connection work very fine

When I transfer report to Jasper Server and try to run it, I receive error message below.

com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection
 at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:62)
 ..........

org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted
  ..........

java.util.NoSuchElementException: Could not create a validated object, cause: Transactions not supported
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:806)
 at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
 at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection
   ........
 

Can you help me? Thanks

 

[lucianc]

Try the following: edit WEB-INF/applicationContext.xml, find a bean named jdbcDataSourceServiceFactory and the two line below to it.

If that doesn't do it, try defining JNDI data sources instead (and changing the default attribute values).

Regards,

Lucian

Code:

        <property name="defaultReadOnly" value="false"/>        <property name="defaultAutoCommit" value="true"/>

[aezaz123]

Code:

Hi,



I saw you discussion in this error in server. Even i am facing this problem.

I have some jrxml files created from ireport in some other machine. i tried to publish thous report to server which we are keeping in different machine. when i publish report from client machine it is not showu=ing any error. But when i tried to open published report through server i am getting this below error



"com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection"



for details i have attached snap of that error



I am new to jasper plz any one let me know how to resove this error. i tried solution give in your discussion but it is not working yet.



One more thing if i tried to open server report published from server in client its opening fine but if i publish from client to server i am facing this problem.



Please its very urgent..



looking forward for any one's reply



Thanks in Advance



Aezaz Ahmed