You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Ron H <be...@gmail.com> on 2009/11/06 06:43:46 UTC
Broken pipe and how to recycle dead connections
hi!
i get the following exception:
java.net.SocketException
MESSAGE: Broken pipe
STACKTRACE:
java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
my conncetion is like that:
<transactionManager type="JDBC" commitRequired="false">
<dataSource type="SIMPLE">
<property value="${driver}" name="JDBC.Driver" />
<property value="${url}" name="JDBC.ConnectionURL" />
<property value="${username}" name="JDBC.Username" />
<property value="${password}" name="JDBC.Password" />
<property name="Pool.PingQuery" value="select 1 from Employees" />
<property name="Pool.PingEnabled" value="true" />
<property name="Pool.PingConnectionsOlderThan" value="0" />
<property name="Pool.PingConnectionsNotUsedFor" value="0" />
</dataSource>
</transactionManager>
my code is like that:
public YTUser getUserProfile(String userId) throws SQLException{
return (YTUser) sqlMapper.queryForObject("selectUser",userId);
}
i read that a solution could be to recycle dead connection. is it true? how
can i do it?
--
View this message in context: http://old.nabble.com/Broken-pipe-and-how-to-recycle-dead-connections-tp26226564p26226564.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
Re: Broken pipe and how to recycle dead connections
Posted by Guy Rouillier <gu...@burntmail.com>.
deligeli wrote:
> hi
>
> i get it for:
>
> SEVERE: Servlet.service() for servlet default threw exception
> java.lang.ClassNotFoundException: POOLED
> at
> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
> at
> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
> at java.lang.ClassLoader.loadClassInternal(Unknown Source)
> at java.lang.Class.forName0(Native Method)
> at java.lang.Class.forName(Unknown Source)
> at com.ibatis.common.resources.Resources.classForName(Resources.java:267)
> at com.ibatis.common.resources.Resources.instantiate(Resources.java:283)
> at
> com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser$9.process(SqlMapConfigParser.java:218)
> at
> com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:121)
>
> in what JAR does the POOLED class appear?
I started with iBatis 3. But looking in the JAR file for 2.3.4 (and for
3, BTW) there is no class named "POOLED". Comparing the iBatis 3 PDF
to the iBatis 2 sample, configuration of the dataSource appears to be
similar. If so, "POOLED" is a dataSource type, not a class. Show your
XML configuration for your dataSource and someone may be able to help.
>
>
>
> Guy Rouillier-2 wrote:
>> Ron H wrote:
>>> hi
>>>
>>> i am using ibatis2
>>>
>>> and get classnotfound error
>>>
>>> how can i deal with it?
>> Put the required JAR file containing the missing class into your runtime
>> classpath.
>>
>> --
>> Guy Rouillier
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>> For additional commands, e-mail: user-java-help@ibatis.apache.org
>>
>>
>>
>
--
Guy Rouillier
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
Re: Broken pipe and how to recycle dead connections
Posted by deligeli <od...@jpost.com>.
hi
i get it for:
SEVERE: Servlet.service() for servlet default threw exception
java.lang.ClassNotFoundException: POOLED
at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at com.ibatis.common.resources.Resources.classForName(Resources.java:267)
at com.ibatis.common.resources.Resources.instantiate(Resources.java:283)
at
com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser$9.process(SqlMapConfigParser.java:218)
at
com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:121)
in what JAR does the POOLED class appear?
Guy Rouillier-2 wrote:
>
> Ron H wrote:
>> hi
>>
>> i am using ibatis2
>>
>> and get classnotfound error
>>
>> how can i deal with it?
>
> Put the required JAR file containing the missing class into your runtime
> classpath.
>
> --
> Guy Rouillier
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>
>
--
View this message in context: http://old.nabble.com/Broken-pipe-and-how-to-recycle-dead-connections-tp26226564p26249926.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
Re: Broken pipe and how to recycle dead connections
Posted by Guy Rouillier <gu...@burntmail.com>.
Ron H wrote:
> hi
>
> i am using ibatis2
>
> and get classnotfound error
>
> how can i deal with it?
Put the required JAR file containing the missing class into your runtime
classpath.
--
Guy Rouillier
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
Re: Broken pipe and how to recycle dead connections
Posted by Ron H <be...@gmail.com>.
hi
i am using ibatis2
and get classnotfound error
how can i deal with it?
陈抒 wrote:
>
> use the red line:
>
>
> <environments default="development">
> <environment id="development">
> <transactionManager type="JDBC"/>
> <dataSource type="POOLED">
> <property name="driver" value="com.mysql.jdbc.Driver"/>
> <property name="url" value="jdbc:mysql://
> 192.168.0.110:3306/EffectiveEnglish"/>
> <property name="username" value="freebird"/>
> <property name="password" value="770328"/>
> </dataSource>
> </environment>
> </environments>
> 陈抒
> Best regards
> http://blog.csdn.net/sheismylife
>
>
> On Fri, Nov 6, 2009 at 1:43 PM, Ron H <be...@gmail.com> wrote:
>
>>
>> hi!
>>
>> i get the following exception:
>> java.net.SocketException
>> MESSAGE: Broken pipe
>>
>> STACKTRACE:
>>
>> java.net.SocketException: Broken pipe
>> at java.net.SocketOutputStream.socketWrite0(Native Method)
>> at
>> java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
>>
>> my conncetion is like that:
>> <transactionManager type="JDBC" commitRequired="false">
>> <dataSource type="SIMPLE">
>> <property value="${driver}" name="JDBC.Driver" />
>> <property value="${url}" name="JDBC.ConnectionURL"
>> />
>> <property value="${username}" name="JDBC.Username"
>> />
>> <property value="${password}" name="JDBC.Password"
>> />
>> <property name="Pool.PingQuery" value="select 1
>> from
>> Employees" />
>> <property name="Pool.PingEnabled" value="true" />
>> <property name="Pool.PingConnectionsOlderThan"
>> value="0" />
>> <property name="Pool.PingConnectionsNotUsedFor"
>> value="0" />
>>
>> </dataSource>
>> </transactionManager>
>>
>> my code is like that:
>> public YTUser getUserProfile(String userId) throws SQLException{
>> return (YTUser)
>> sqlMapper.queryForObject("selectUser",userId);
>> }
>> i read that a solution could be to recycle dead connection. is it true?
>> how
>> can i do it?
>> --
>> View this message in context:
>> http://old.nabble.com/Broken-pipe-and-how-to-recycle-dead-connections-tp26226564p26226564.html
>> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>> For additional commands, e-mail: user-java-help@ibatis.apache.org
>>
>>
>
>
--
View this message in context: http://old.nabble.com/Broken-pipe-and-how-to-recycle-dead-connections-tp26226564p26247439.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org
Re: Broken pipe and how to recycle dead connections
Posted by 陈抒 <cs...@gmail.com>.
use the red line:
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://
192.168.0.110:3306/EffectiveEnglish"/>
<property name="username" value="freebird"/>
<property name="password" value="770328"/>
</dataSource>
</environment>
</environments>
陈抒
Best regards
http://blog.csdn.net/sheismylife
On Fri, Nov 6, 2009 at 1:43 PM, Ron H <be...@gmail.com> wrote:
>
> hi!
>
> i get the following exception:
> java.net.SocketException
> MESSAGE: Broken pipe
>
> STACKTRACE:
>
> java.net.SocketException: Broken pipe
> at java.net.SocketOutputStream.socketWrite0(Native Method)
> at
> java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
>
> my conncetion is like that:
> <transactionManager type="JDBC" commitRequired="false">
> <dataSource type="SIMPLE">
> <property value="${driver}" name="JDBC.Driver" />
> <property value="${url}" name="JDBC.ConnectionURL"
> />
> <property value="${username}" name="JDBC.Username"
> />
> <property value="${password}" name="JDBC.Password"
> />
> <property name="Pool.PingQuery" value="select 1 from
> Employees" />
> <property name="Pool.PingEnabled" value="true" />
> <property name="Pool.PingConnectionsOlderThan"
> value="0" />
> <property name="Pool.PingConnectionsNotUsedFor"
> value="0" />
>
> </dataSource>
> </transactionManager>
>
> my code is like that:
> public YTUser getUserProfile(String userId) throws SQLException{
> return (YTUser)
> sqlMapper.queryForObject("selectUser",userId);
> }
> i read that a solution could be to recycle dead connection. is it true? how
> can i do it?
> --
> View this message in context:
> http://old.nabble.com/Broken-pipe-and-how-to-recycle-dead-connections-tp26226564p26226564.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>