Jump to content

ssvicente
Go to solution Solved by Tom C,

Recommended Posts

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.

Link to comment
Share on other sites

  • Replies 8
  • Created
  • Last Reply

Top Posters In This Topic

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[/code]

 

Link to comment
Share on other sites

<?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>[/code]

 

Link to comment
Share on other sites

  • 4 years later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...