0 Replies Latest reply on Jul 11, 2014 1:18 AM by mahesh vs

    Connection To SQL SERVER 2008 r2 failed

    mahesh vs Newbie


      HI ,

       

      I am trying to connect to SQL server 2008 r2 from my camel program.

      Have deployed the camel project in jboss-fuse-6.0.0.redhat-024.

       

      The camel-route file is

       

      <ctx:property-placeholder
        location="file:C:\FactoryESB-PropertyFiles\PPTY_DATA-SOURCE.properties" />
          <bean id="outotec-datasource" class="org.springframework.jdbc.datasource.SimpleDriverDataSource">
        <property name="driverClass" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
              <property name="url" value="${url}" />
              <property name="username" value="${userName}" />
              <property name="password" value="${password}" />
          </bean>

      <osgi:service ref="outotec-datasource" interface="javax.sql.DataSource" />
       

      <camelContext xmlns="http://camel.apache.org/schema/spring"/></beans>

       

      Url :jdbc:sqlserver://D-113045818\\SQLEXPRESS:1433  

      username :sa

      password :abcd

       

      The SQL server is set to have mixed mode authentication. The service is failing for windows user MA272340.

      MA272340 is the windows admin user.

       

      The error log is as follows

      18:35:49,909 | ERROR | sumer[EAMBuffer] | DefaultErrorHandler              | 130 - org.apache.camel.camel-core - 2.10.0.redhat-60024 | Failed delivery for (MessageId: ID:D-113045818-50625-1404991425675-9:8:1:1:1 on ExchangeId: ID-D-113045818-50626-1404991428889-7-6). Exhausted after delivery attempt: 1 caught: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'MA272340'.

      com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'MA272340'.

      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)[283:com.outotec.sql-data-connector:1.0.0]

      at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246)[283:com.outotec.sql-data-connector:1.0.0]

      at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83)[283:com.outotec.sql-data-connector:1.0.0]

      at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2529)[283:com.outotec.sql-data-connector:1.0.0]

      at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1905)[283:com.outotec.sql-data-connector:1.0.0]

      at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)[283:com.outotec.sql-data-connector:1.0.0]

      at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:1893)[283:com.outotec.sql-data-connector:1.0.0]

      at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)[283:com.outotec.sql-data-connector:1.0.0]

      at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)[283:com.outotec.sql-data-connector:1.0.0]

      at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1045)[283:com.outotec.sql-data-connector:1.0.0]

      at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)[283:com.outotec.sql-data-connector:1.0.0]

      at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)[283:com.outotec.sql-data-connector:1.0.0]

      at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)[283:com.outotec.sql-data-connector:1.0.0]

      at org.springframework.jdbc.datasource.SimpleDriverDataSource.getConnectionFromDriver(SimpleDriverDataSource.java:140)[254:org.springframework.jdbc:3.1.3.RELEASE]

      at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)[254:org.springframework.jdbc:3.1.3.RELEASE]

      at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)[254:org.springframework.jdbc:3.1.3.RELEASE]

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[:1.7.0_04]

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[:1.7.0_04]

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[:1.7.0_04]

      at java.lang.reflect.Method.invoke(Method.java:601)[:1.7.0_04]

      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319)[107:org.springframework.aop:3.1.3.RELEASE]

      at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58)

      at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62)

      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)[107:org.springframework.aop:3.1.3.RELEASE]

      at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)[107:org.springframework.aop:3.1.3.RELEASE]

      at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)[107:org.springframework.aop:3.1.3.RELEASE]

      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)[107:org.springframework.aop:3.1.3.RELEASE]

      at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:56)

      at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:39)

      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)[107:org.springframework.aop:3.1.3.RELEASE]

      at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59)[133:org.springframework.osgi.core:1.2.1]

      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)[107:org.springframework.aop:3.1.3.RELEASE]

      at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)[107:org.springframework.aop:3.1.3.RELEASE]

      at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)[107:org.springframework.aop:3.1.3.RELEASE]

      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)[107:org.springframework.aop:3.1.3.RELEASE]

      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)[107:org.springframework.aop:3.1.3.RELEASE]

      at $Proxy106.getConnection(Unknown Source)

      at com.outotec.serializationclasses.ProcessAsDowntime.createConnection(ProcessAsDowntime.java:681)[268:com.outotec.asset-down-time:1.0.0]

      at com.outotec.serializationclasses.ProcessAsDowntime.checkExsitingdwmtyms(ProcessAsDowntime.java:616)[268:com.outotec.asset-down-time:1.0.0]

      at com.outotec.serializationclasses.ProcessAsDowntime.process(ProcessAsDowntime.java:133)[268:com.outotec.asset-down-time:1.0.0]

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[:1.7.0_04]

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[:1.7.0_04]

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[:1.7.0_04]

      at java.lang.reflect.Method.invoke(Method.java:601)[:1.7.0_04]

      at org.apache.camel.component.bean.MethodInfo.invoke(MethodInfo.java:390)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.component.bean.MethodInfo$1.doProceed(MethodInfo.java:277)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.component.bean.MethodInfo$1.proceed(MethodInfo.java:250)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.component.bean.BeanProcessor.process(BeanProcessor.java:161)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:99)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.component.bean.BeanProcessor.process(BeanProcessor.java:67)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.impl.ProcessorEndpoint.onExchange(ProcessorEndpoint.java:101)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.impl.ProcessorEndpoint$1.process(ProcessorEndpoint.java:71)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.util.AsyncProcessorConverterHelper$ProcessorToAsyncProcessorBridge.process(AsyncProcessorConverterHelper.java:61)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:73)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.SendProcessor$2.doInAsyncProducer(SendProcessor.java:122)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.impl.ProducerCache.doInAsyncProducer(ProducerCache.java:298)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.SendProcessor.process(SendProcessor.java:117)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:73)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:99)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:90)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:73)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:73)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:99)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:90)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.interceptor.TraceInterceptor.process(TraceInterceptor.java:91)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:73)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:99)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:90)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.fabric.FabricTraceProcessor.process(FabricTraceProcessor.java:81)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:73)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:99)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:90)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:73)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.RedeliveryErrorHandler.processErrorHandler(RedeliveryErrorHandler.java:334)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:220)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.RouteContextProcessor.processNext(RouteContextProcessor.java:46)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:90)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.interceptor.DefaultChannel.process(DefaultChannel.java:308)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.RouteContextProcessor.processNext(RouteContextProcessor.java:46)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:90)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.UnitOfWorkProcessor.processAsync(UnitOfWorkProcessor.java:150)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.UnitOfWorkProcessor.process(UnitOfWorkProcessor.java:117)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.RouteInflightRepositoryProcessor.processNext(RouteInflightRepositoryProcessor.java:48)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:90)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:73)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.DelegateAsyncProcessor.processNext(DelegateAsyncProcessor.java:99)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:90)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:73)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:99)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:86)[130:org.apache.camel.camel-core:2.10.0.redhat-60024]

      at org.apache.camel.component.jms.EndpointMessageListener.onMessage(EndpointMessageListener.java:104)[196:org.apache.camel.camel-jms:2.10.0.redhat-60024]

      at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:562)[175:org.springframework.jms:3.1.3.RELEASE]

      at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:500)[175:org.springframework.jms:3.1.3.RELEASE]

      at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:468)[175:org.springframework.jms:3.1.3.RELEASE]

      at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:326)[175:org.springframework.jms:3.1.3.RELEASE]

      at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:264)[175:org.springframework.jms:3.1.3.RELEASE]

      at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:1071)[175:org.springframework.jms:3.1.3.RELEASE]

      at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:1063)[175:org.springframework.jms:3.1.3.RELEASE]

      at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:960)[175:org.springframework.jms:3.1.3.RELEASE]

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)[:1.7.0_04]

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)[:1.7.0_04]

      at java.lang.Thread.run(Thread.java:722)[:1.7.0_04]