Dear all, I have created the datasource.xml and blueprint.xml,in which datasource.xml creates the datasource and registered in jndi registry and blueprint.xml is reffering the datasource and connected created when i execute a heavy amount of data in csv its not inserting into table saying below error ;
11:25:28,472 | ERROR | read #27 - Split | DefaultErrorHandler | 100 - org.apache.camel.camel-core - 2.10.7 | Failed delivery for (MessageId: ID-SP11023-63116-1394514901165-2-10 on ExchangeId: ID-SP11023-63116-1394514901165-2-16939). Exhausted after delivery attempt: 1 caught: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Network error IOException: No buffer space available (maximum connections reached?): connect org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Network error IOException: No buffer space available (maximum connections reached?): connect my datasource.xml ...... ----------------------------- <blueprint xmlns="http://www.osgi.org/xmlns/blueprint/v1.0.0";> <bean class="net.sourceforge.jtds.jdbcx.JtdsDataSource" id="datasourceBean" > <property name="serverName" value="localhost"></property> <property name="databaseName" value="SampleDB"></property> <property name="portNumber" value="1433"></property> <property name="user" value="sa"></property> <property name="password" value="minnalsql12*"></property> </bean> <service id="datasourceService" auto-export="interfaces" ref="datasourceBean"> <service-properties> <entry key="osgi.jndi.service.name" value="jdbc/sqlDataSource"></entry> </service-properties> </service> </blueprint> ---------------------------------------- blueprint.xml ----------------------------------------- <blueprint xmlns="http://www.osgi.org/xmlns/blueprint/v1.0.0"; xmlns:cm="http://aries.apache.org/blueprint/xmlns/blueprint-cm/v1.0.0"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="http://www.osgi.org/xmlns/blueprint/v1.0.0 http://www.osgi.org/xmlns/blueprint/v1.0.0/blueprint.xsd";> <reference id="dataSource" interface="javax.sql.DataSource" filter="(osgi.jndi.service.name=jdbc/sqlDataSource)"/> <bean id="xyzProcessor" class="org.apache.camel.example.sql.MyProcessor" /> <camelContext id="camel" xmlns="http://camel.apache.org/schema/blueprint"; > <route id="CsvtoDBexample" autoStartup="true"> <from uri="file:D:/conatiner/CSV" /> <process ref="xyzProcessor"></process> <split parallelProcessing="true" streaming="true"> <simple>${body}</simple> <to uri="sql:insert into testingOne (Fal_Bank,Fal_Dealer,Fal_State) values (#,#,#)?dataSourceRef=dataSource" /> </split> </route> </camelContext> </blueprint> ------------------------------------------------ please do help me where im doing mistake :( Regards Rathi -- View this message in context: http://servicemix.396122.n5.nabble.com/Batch-insert-not-working-tp5719554.html Sent from the ServiceMix - User mailing list archive at Nabble.com.
