Connection Failed in report

Posted on January 29, 2014 at 2:58am
0

Hi,

I build a report in ireport's with a connection to a Informix database. It uses a JDBC connection with ifxdriver, and it work's perfectly.

The problem is when it was publish in the jasperserver. It always give the error "An error occurred while creating the connection. Try again."

The datasource is perfectly working, giving connection passed. 

I tried several solution without success, i Test the driver with a jsp page (Works), disabling firewall, building a test report, and so many other.


Any way i can debug the problem? or any special feature for connection informix server?


Ty.

iReport Designer
JasperReports® Library
JasperReports® Server
Jaspersoft® Studio
ssvicente's picture
ssvicente
10
Joined: Nov 16 2011 - 4:24am
Last seen: 7 years 4 months ago

did you add the connection to jasperserver too?

sjoerd.jump - 7 years 8 months ago
Yes the connection is in jasperserver and it gives success!
ssvicente - 7 years 8 months ago
add comment

5 Answers:

1
Posted on January 29, 2014 at 11:48am

Please take a look at jaserver.log file to see what kind of error you are getting - connection refused, timed out, user credential error, driver error, etc. This could help to determine the root cause of the problem.

tchen's picture
tchen
95027
Joined: Feb 27 2008 - 7:33am
Last seen: 19 hours 33 min ago
0
Posted on January 30, 2014 at 2:52am

Sorry,

The problem is creating a connection connection.

An error occurred while creating the connection. Try again.

com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:63)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.setReportParameterValues(BaseJdbcDataSource.java:49)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.setReportParameterValues(JdbcDataSourceService.java:68)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1696)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1057)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:991)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:902)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:724)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted
        at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:103)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:55)
 ... 9 moreCaused by: 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)
 ... 10 more

ssvicente's picture
ssvicente
10
Joined: Nov 16 2011 - 4:24am
Last seen: 7 years 4 months ago
0
Posted on January 31, 2014 at 1:29am

post a snapshot of ur data which ur entering to publish..

rachita.iyer27's picture
rachita.iyer27
7
Joined: Jan 28 2014 - 1:52am
Last seen: 7 years 4 months ago

i posted the xml, but already tried with a simple query!

ssvicente - 7 years 8 months ago
add comment
0
Posted on February 6, 2014 at 9:47am 
<?xml version="1.0" 
      encoding="UTF-8"?>
<jasperReport 
      xmlns="http://jasperreports.sourceforge.net/jasperreports" 
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
      xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" 
      name="ClientesOrga" 
      language="groovy"
      pageWidth="842" 
      pageHeight="595" 
      orientation="Landscape"
      columnWidth="802"
      leftMargin="20"
      rightMargin="20"
      topMargin="20"
      bottomMargin="20"
      uuid="63938b7e-28bd-45fc-820a-d4fe6a47d759">
 
    <property name="ireport.zoom" value="1.0"/>
    <property name="ireport.x" value="0"/>
    <property name="ireport.y" value="0"/>
    <property name="ireport.jasperserver.reportUnit"
              value="/Dielmar/Comercial/Clientes/Cliente"/>
    <property name="ireport.jasperserver.url"
              value="http://192.168.1.15:8080/jasperserver/services/repository"/>
    <queryString>
        <![CDATA[select kunde,name_k,str_k,plz_neu,ort_k,steuer,bezir_kv,sc130.nat_tx[1,15] as Paisfrom sc100 join sc130 on sc100.nat = sc130.natwhere sc100.status <> 9order by sc100.name_k]]> 
    </queryString>
    <field name="kunde" class="java.lang.Integer"/>
    <field name="name_k" class="java.lang.String"/>
    <field name="str_k" class="java.lang.String"/>
    <field name="plz_neu" class="java.lang.String"/>
    <field name="ort_k" class="java.lang.String"/>
    <field name="steuer" class="java.lang.String"/>
    <field name="bezir_kv" class="java.lang.String"/>
    <field name="pais" class="java.lang.String"/>
    <variable name="Data" class="java.util.Date">
        <variableExpression>
            <![CDATA[$V{Data}]]>
        </variableExpression>
    </variable>
    <background>
        <band splitType="Stretch"/>
    </background>
    <title>
        <band height="84" splitType="Stretch">
            <rectangle radius="10">
                <reportElement uuid="12144899-8f77-4705-8461-c619d41ed2ee"
                               x="10" y="0" width="783" height="79"/>
                <graphicElement>
                    <pen lineWidth="1.5"/>
                </graphicElement>
            </rectangle>
            <staticText>
                <reportElement uuid="b7f838d4-65ed-4d59-829d-73cbf8f39f00"
                               x="321" y="8" width="201" height="33"/>
                <textElement>
                    <font fontName="Courier New" size="28" isBold="true"/>
                </textElement>
                <text><![CDATA[DIELMAR S.A]]></text>
            </staticText>
        </band>
    </title>
    <pageHeader>
        <band height="43" splitType="Stretch">
            <rectangle>
                <reportElement uuid="63323299-43bc-4430-8e22-0baff55f4498"
                               x="2" y="13" width="552" height="20"
                               backcolor="#CCCCCC"/>
            </rectangle>
            <staticText>
                <reportElement uuid="42ea5690-b8a1-4d16-9b95-c2f4e14404ea"
                               x="250" y="13" width="51" height="20"/>
                <textElement>
                    <font size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[Cliente]]></text>
            </staticText>
            <rectangle>
                <reportElement uuid="efaef4e3-0247-4262-b21e-91ccc32afa59"
                               x="556" y="13" width="237" height="20"
                               backcolor="#CCCCCC"/>
            </rectangle>
            <staticText>
                <reportElement uuid="5259446e-5677-4025-a792-b8d2be105548"
                               x="649" y="15" width="51" height="20"/>
                <textElement>
                    <font size="12" isBold="true"/>
                </textElement>
                <text><![CDATA[Distrito]]></text>
            </staticText>
        </band>
    </pageHeader>
    <columnHeader>
        <band height="22" splitType="Stretch">
            <staticText>
                <reportElement uuid="cd57edf2-21da-47f4-9c19-988554b62755"
                               x="0" y="0" width="48" height="20"/>
                <textElement>
                    <font isBold="true"/>
                </textElement>
                <text><![CDATA[Nr.]]></text>
            </staticText>
            <staticText>
                <reportElement uuid="c8b79470-9464-4549-8d84-c61f08ff0f91"
                               x="48" y="0" width="120" height="20"/>
                <textElement>
                    <font isBold="true"/>
                </textElement>
                <text><![CDATA[Nome]]></text>
            </staticText>
            <staticText>    
                <reportElement uuid="c8caed53-8c38-40bd-98da-9113b1cc8106"
                               x="206" y="0" width="96" height="20"/>
                <textElement>
                    <font isBold="true"/>    
                </textElement>    
                <text><![CDATA[Morada]]></text>
            </staticText>   
            <staticText>    
                <reportElement uuid="18d12e1d-94b6-497b-9061-221d0118799d"
                               x="302" y="2" width="57" height="20"/>
                <textElement>     
                    <font isBold="true"/>    
                </textElement>    
                <text><![CDATA[CP]]></text>   
            </staticText>   
            <staticText>    
                <reportElement uuid="9f5fd4cc-1850-4dd6-af36-918416c5cc1e"
                               x="359" y="2" width="93" height="20"/>
                <textElement>     
                    <font isBold="true"/>
                </textElement>    
                <text><![CDATA[Localidade]]></text>   
            </staticText>
            <staticText>    
                <reportElement uuid="8cf4c885-04c2-4157-a002-5b43916240d5"
                               x="452" y="0" width="100" height="20"/>
                <textElement>     
                    <font isBold="true"/>
                </textElement>    
                <text><![CDATA[NIF]]></text>   
            </staticText>   
            <staticText>    
                <reportElement uuid="0db7a6e2-c1bf-47a0-8b7d-941435b3ba36"
                               x="686" y="1" width="100" height="20"/>
                <textElement>     
                    <font isBold="true"/>
                </textElement>    
                <text><![CDATA[pais]]></text>   
            </staticText>   
            <staticText>    
                <reportElement uuid="b6ad6ce9-9b31-4adc-a007-c5037f1f212b"
                               x="557" y="1" width="100" height="20"/>
                <textElement>     
                    <font isBold="true"/>
                </textElement>    
                <text><![CDATA[Nome]]></text>   
            </staticText>
        </band> 
    </columnHeader> 
    <detail>
        <band height="29" splitType="Stretch">
            <textField>
                <reportElement uuid="d6d92f36-5694-4b9e-b152-88762882755a"
                               x="0" y="0" width="48" height="20"/>
                <textElement/>
                <textFieldExpression><![CDATA[$F{kunde}]]></textFieldExpression>
            </textField>
            <textField>    
                <reportElement uuid="224316ed-b0a4-4b5e-8449-6ea18039cc24"
                               x="48" y="0" width="157" height="29"/>
                <textElement/>
                <textFieldExpression><![CDATA[$F{name_k}]]></textFieldExpression>
            </textField>
            <textField>    
                <reportElement uuid="cc47fd0c-d301-45cd-be54-2bb880f26c54"
                               x="205" y="1" width="96" height="28"/>
                <textElement/>    
                <textFieldExpression><![CDATA[$F{str_k}]]></textFieldExpression>
            </textField>
            <textField>    
                <reportElement uuid="1c4ffc58-ef49-4ba1-93b3-e02486c630b0"
                               x="301" y="0" width="57" height="29"/>
                <textElement/>    
                <textFieldExpression><![CDATA[$F{plz_neu}]]></textFieldExpression>
            </textField>
            <textField>    
                <reportElement uuid="200d866f-2807-4b4f-a835-9781547c7f4a"
                               x="358" y="0" width="94" height="29"/>
                <textElement/>
                <textFieldExpression><![CDATA[$F{ort_k}]]></textFieldExpression>
            </textField>
            <textField>    
                <reportElement uuid="119d4574-7757-452d-898e-8c9856da5c09"
                               x="452" y="1" width="100" height="20"/>
                <textElement/>    
                <textFieldExpression><![CDATA[$F{steuer}]]></textFieldExpression>
            </textField>
            <textField>    
                <reportElement uuid="c2f58a3a-174b-42c0-b962-57c33085d2e4"
                               x="687" y="1" width="100" height="20"/>
                <textElement/>    
                <textFieldExpression><![CDATA[$F{pais}]]></textFieldExpression>
            </textField>
            <textField>    
                <reportElement uuid="ba7ecbc3-031d-493a-96eb-35584c1e591c"
                               x="556" y="1" width="127" height="20"/>
                <textElement/>    
                <textFieldExpression><![CDATA[$F{bezir_kv}]]></textFieldExpression>
            </textField>
        </band>
    </detail>
    <columnFooter>  
        <band splitType="Stretch"/>
    </columnFooter>
    <pageFooter>
        <band height="34" splitType="Stretch">
            <textField pattern="dd-MM-yyyy">    
                <reportElement uuid="1110ca39-c165-4c54-8d41-886c9baff7cb"
                               x="0" y="10" width="100" height="20"/>
                <textElement/>    
                <textFieldExpression><![CDATA[new Date()]]></textFieldExpression>
            </textField>
            <line>    
                <reportElement uuid="1c0338c0-f956-45d7-8610-5b1012091fc0"
                               x="0" y="7" width="793" height="1"/>
                <graphicElement>
                    <pen lineWidth="1.5"/>
                </graphicElement>
            </line>
            <textField evaluationTime="Report">    
                <reportElement uuid="4bef8c2e-17fc-4782-94fd-9b56ca5ed28a"
                               x="748" y="10" width="45" height="20"/>
                <textElement/>
                <textFieldExpression>
                    <![CDATA["/  "+$V{PAGE_NUMBER}]]>
                </textFieldExpression>
            </textField>
            <textField>    
                <reportElement uuid="681d1ec7-87ac-46dc-968c-99c500469856"
                               x="732" y="10" width="13" height="20"/>
                <textElement/>    
                <textFieldExpression>
                    <![CDATA[$V{PAGE_NUMBER}]]>
                </textFieldExpression>
            </textField>
        </band>
    </pageFooter>
    <summary>
        <band height="41" splitType="Stretch"/>
    </summary>
</jasperReport>

ssvicente's picture
ssvicente
10
Joined: Nov 16 2011 - 4:24am
Last seen: 7 years 4 months ago
0
Posted on June 20, 2018 at 7:56pm

I got the same error, did you solve it?

christian.cortes's picture
christian.cortes
2
Joined: May 14 2013 - 6:10pm
Last seen: 2 years 2 months ago
Feedback
randomness