[Is it possible to have MS SQL in Jasper Server ?]

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.
 

[Weird thing happened in JasperServer]

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.
 

[Weird thing happened in JasperServer]

db2jcc-v9.1.jar

com.ibm.db2.jcc.DB2Driver

 

That is what i  use

 

[Weird thing happened in JasperServer]

I use the jdbc datasource which created in JasperReport console. I provided the drive class

and jdbc url .Is that ok?

[Weird thing happened in JasperServer]

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