Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
To be reviewed
-
Resolution: Won't Fix or Usage Issue
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: Transport: JDBC
-
Labels:None
-
Environment:
Mule 1.4.3 oracle 10g JDK 1.5 Windows
-
User impact:High
-
Log Output:Data Base is running at infinite looop ...means database row object are printing at infinite loop without stoping (start row -->endrow--> again start row)
-
Similar Issues:None
Description
Oracle Database connection in not closing .Results are printing in infinite loop.....Please help me how to close the connection of database.
Here is my Coinfig file:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mule-configuration PUBLIC "-//MuleSource //DTD mule-configuration XML V1.0//EN" "http://mule.mulesource.org/dtds/mule-spring-configuration.dtd">
<mule-configuration id="testjdbc" version="1.0">
<description>The example</description>
<container-context className="org.mule.extras.spring.SpringContainerContext" name="spring" >
<properties>
<property name="configFile" value="conf/spring-config.xml" />
<property name="destroy-method" value="close"/>
</properties>
</container-context>
<connector name="SystemStreamConnector" className="org.mule.providers.stream.SystemStreamConnector">
<properties>
<property name="messageDelayTime" value="1000" />
</properties>
</connector>
<connector name="jdbcConnector" className="org.mule.providers.jdbc.JdbcConnector" >
<properties>
<container-property name="dataSource" reference="jbpmDataSource" required="true"/>
<map name="queries">
<property name="testjdbctest" value="SELECT * FROM DUMP" />
</map>
</properties>
</connector>
<model name="testjdbc">
<mule-descriptor name="DataPresenter" implementation="org.mule.samples.hello.MuleJDBCComponent">
<inbound-router>
<endpoint address="jdbc://testjdbctest">
</endpoint>
</inbound-router>
<outbound-router>
<router className="org.mule.routing.outbound.OutboundPassThroughRouter">
<endpoint address="stream://System.out" />
</router></outbound-router>
</mule-descriptor></model> </mule-configuration>
Here is my JAVA code:
------------------------------
public class MuleJDBCComponent {
/*
public String doStop(Object src) {
String data;
//java.sql.Connection con = this.connector.getConnection();
data=src.toString();
//org.mule.providers.jdbc.JdbcUtils.close(con);
return data;
} */
Please use the mule-users list for questions.
Mule does close the connection properly IIRC but the underlying JDBC pool may be configured not to do so.