camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From atiato <>
Subject JDBC connection for http hits to Oracle DB ...
Date Thu, 07 Feb 2013 14:21:56 GMT
Dears ,

I'm using Spring JDBC template and I'm calling DB package for every http hit
to apache camel Jetty server.

the question is : 

will we hit DB using new JDBC connection for every hit ?

or will we using the same JDBC template for all ? I mean use available JDBC
connections in the pool ?

as I already Have 2000 concurrent request to Jetty server if we have new
JDBC connection for every hit then it will be an issue with hitting DB .

the JDBC connection is as below Data Source and I'm passing this Datasource
to Bean and using the JDBC template within that Bean which in turn calls DB
package .

Can u explain How we communicate with DB ?

<bean id="oracle-ds" class="org.apache.commons.dbcp.BasicDataSource"
		<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"
		<property name="url" value="jdbc:oracle:thin:@"
		<property name="username" value="TABS" />
		<property name="password" value="tbstst$172" />
		<property name="maxActive" value="200" />
		<property name="poolPreparedStatements" value="true" />

and I'm passing id oracle-ds as below :

<bean class="" id="myBean">
		<property name="dataSource" ref="oracle-ds" />
		<property name="maps">
				<entry key="stage" value="015" />
				<entry key="OperatorCodeID1" value="20" />
				<entry key="OperatorCodeID2" value="10" />
				<entry key="20" value="MTNS" />
				<entry key="10" value="MTNS" />
				<entry key="11" value="SDNI" />
				<entry key="21" value="SDNI" />
				<entry key="12" value="ZAIN" />
				<entry key="22" value="ZAIN" />
				<entry key="92" value="ZAIN" />
				<entry key="42" value="ZAIN" />

Thanks and appreciate your feedback,

Omar Atia

View this message in context:
Sent from the Camel - Users mailing list archive at

View raw message