On Fri, Nov 13, 2009 at 4:23 PM, titexe <[email protected]> wrote: > > Problem is solved > > I change JTDS through JDBC, and I added the following line: > > <property name="poolPreparedStatements" value="true"/> > > Now you can manage the connection pools >
Great and thanks for sharing your findings. Others using the JDTS driver may benefit from your help. > > > Claus Ibsen-2 wrote: >> >> On Fri, Nov 13, 2009 at 3:26 PM, titexe <[email protected]> wrote: >>> >>> Thank you for your response, >>> >>> can you tell me, how I can do? because I tried to look on the doc, but I >>> found nothing. >>> >> >> Try this url :) >> http://tinyurl.com/yls2mcm >> >> notice its friday today >> >> >>> Again, thank you, >>> >>> >>> Claus Ibsen-2 wrote: >>>> >>>> Hi >>>> >>>> You need to use a pooled datasource for connections so they are reused. >>>> >>>> >>>> On Fri, Nov 13, 2009 at 3:06 PM, titexe <[email protected]> wrote: >>>>> >>>>> Hello, >>>>> >>>>> I have a route camel that take the message in queue OUT and makes an >>>>> update >>>>> in the database. >>>>> >>>>> In fact that I receive many messages in 10,000 messages. >>>>> I receive an error: >>>>> java.sql.SQLException: Network error IOException: Address already in >>>>> use >>>>> error. >>>>> >>>>> By checking on the system, I found many connections to the database. >>>>> >>>>> Camel is what creates every time a connection for each message? >>>>> >>>>> What is the solution to share the same connection for a pool of >>>>> messages? >>>>> >>>>> below my configuration : >>>>> >>>>> <route errorHandlerRef="myDeadLetterChannel"> >>>>> <from uri="activemq:queue:OUT"/> >>>>> <t uri="activemq:queue:IN"/> >>>>> <setBody> >>>>> UPDATE SET <simple> InterfaceMonitor CamelSent = CURRENT_TIMESTAMP >>>>> WHERE >>>>> Id >>>>> = '$ (in.header.MessageId)' </ simple> >>>>> </ setBody> >>>>> <t uri="jdbc:testdb"/> >>>>> </ route> >>>>> >>>>> <bean id="testdb" class="net.sourceforge.jtds.jdbcx.JtdsDataSource"> >>>>> <property name="serverName" value="192.167.10.55"/> >>>>> <property name="portNumber" value="1433"/> >>>>> <property name="databaseName" value="IP"/> >>>>> <property name="user" value="appuser"/> >>>>> <property name="password" value="Passw0rd"/> >>>>> </ bean> >>>>> >>>>> >>>>> >>>>> Thank you in advance >>>>> >>>>> titexe >>>>> -- >>>>> View this message in context: >>>>> http://old.nabble.com/Camel-Database-%3A-Connection-management-database-by-Camel--tp26337091p26337091.html >>>>> Sent from the Camel - Users mailing list archive at Nabble.com. >>>>> >>>>> >>>> >>>> >>>> >>>> -- >>>> Claus Ibsen >>>> Apache Camel Committer >>>> >>>> Author of Camel in Action: http://www.manning.com/ibsen/ >>>> Open Source Integration: http://fusesource.com >>>> Blog: http://davsclaus.blogspot.com/ >>>> Twitter: http://twitter.com/davsclaus >>>> >>>> >>> >>> -- >>> View this message in context: >>> http://old.nabble.com/Camel-Database-%3A-Connection-management-database-by-Camel--tp26337091p26337337.html >>> Sent from the Camel - Users mailing list archive at Nabble.com. >>> >>> >> >> >> >> -- >> Claus Ibsen >> Apache Camel Committer >> >> Author of Camel in Action: http://www.manning.com/ibsen/ >> Open Source Integration: http://fusesource.com >> Blog: http://davsclaus.blogspot.com/ >> Twitter: http://twitter.com/davsclaus >> >> > > -- > View this message in context: > http://old.nabble.com/Camel-Database-%3A-Connection-management-database-by-Camel--tp26337091p26338275.html > Sent from the Camel - Users mailing list archive at Nabble.com. > > -- Claus Ibsen Apache Camel Committer Author of Camel in Action: http://www.manning.com/ibsen/ Open Source Integration: http://fusesource.com Blog: http://davsclaus.blogspot.com/ Twitter: http://twitter.com/davsclaus
