kam1

Hi guys, I meet this problem too. I created the js-mssql-ds.xml under MYSERVER\deploy folder which is like below <?xml version="1.0" encoding="UTF-8"?> <datasources> <local-tx-datasource> <jndi-name>jdbc/wlsconnect</jndi-name> <connection-url>jdbc:jtds:sqlserver://CNSHG2k3RP01/CAS_WLSC_Connect</connection-url> <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class> <user-name>username</user-name> <password>password</password> <min-pool-size>5</min-pool-size> <max-pool-size>20</max-pool-size> <idle-timeout-minutes>15</idle-timeout-minutes> <metadata> <type-mapping>MS SQLSERVER</type-mapping> </metadata> <check-valid-connection-sql>select 1</check-valid-connection-sql> </local-tx-datasource> </datasources> Then I created the jndi datasource in Jasper server .Service name: jdbc/wlsconnect But test failed. I have put the jtds jar under \lib\ext\jtds-1.2.2.jar Do you have any idea what is going on here? I have mysql and db2 jndi datasource run well . But not this jtds sqlserver one.

Thank you very much! Now I configured a JNDI datasource ,and configed the timeout period in *-ds.xml (i am using jboss). Now Daily reports become fine.

db2jcc-v9.1.jar com.ibm.db2.jcc.DB2Driver That is what i use

I use the jdbc datasource which created in JasperReport console. I provided the drive class and jdbc url .Is that ok?

I met some problem with JasperServer3.1. I created the report by using ireport3.1.4 .And the weird thing is that the report usually runs well on server.But sometimes it gets error like below. it gets error like 2 of 5 days.(Report is run daily as a schedule). com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : DailyClaimV2 at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:668) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:588) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1212) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:842) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:123) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:420) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:661) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:356) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:788) at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:60) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:288) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeReport(ReportExecutionJob.java:441) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:369) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:188) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) Caused by: com.ibm.db2.jcc.b.DisconnectException: [ibm][db2][jcc][t4][2030][11211] A communication error has been detected. Communication protocol being used: TCP/IP. Communication API being used: SOCKETS. Location where the error was detected: T4Agent.sendRequest(). Communication function detecting the error: OutputStream.flush(). Protocol specific error codes Connection reset by peer: socket write error, *, 0. Message: Connection reset by peer: socket write error at com.ibm.db2.jcc.a.a.a(a.java:365) at com.ibm.db2.jcc.a.a.A(a.java:334) at com.ibm.db2.jcc.a.a.n(a.java:292) at com.ibm.db2.jcc.b.p.c(p.java:280) at com.ibm.db2.jcc.b.rh.d(rh.java:2341) at com.ibm.db2.jcc.b.rh.T(rh.java:426) at com.ibm.db2.jcc.b.rh.executeQuery(rh.java:409) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:135) ... 16 more Caused by: java.net.SocketException: Connection reset by peer: socket write error at java.net.SocketOutputStream.socketWrite0(Native Method) at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92) at java.net.SocketOutputStream.write(SocketOutputStream.java:136) at com.ibm.db2.jcc.a.gb.b(gb.java:1534) at com.ibm.db2.jcc.a.gb.a(gb.java:1483) at com.ibm.db2.jcc.a.a.A(a.java:328) ... 23 more Does anybody have any idea? Thanks in advance