title: #WSO2 - DAS - storing event in SQL server 2008
body: <p>In my project I need to collect data, process/Analyze data and published it.
  I am using WSO2 DAS 3.0.0 for the same.</p>
  
  <p>In order to achieve this I have followed below steps:-</p>
  
  <ol>
  <li>Created event stream(define attribute).</li>
  <li>Created Event receiver. (HTTP,SOAP)</li>
  <li>Created event publisher (store event in My sql but getting error in SQL server see below).</li>
  </ol>
  
  <p>My question is as below:-</p>
  
  <ol>
  <li><p>Is there any other way to store persisted event in Database. Can I store event in database using Main->stream->persist event. Can I use this to store event in Database or I need to use Main->publishers. Select "output event adapter type"- RDBMS to store the event?</p></li>
  <li><p>Can I use SQL server 2008 to store the event in SQL server 2008? I am getting below error while storing data into SQL server 2008.</p></li>
  </ol>
  
  <p>Cannot Execute Create Table Query. There is already an object named 'tbl_City' in the database. Hence Event is dropped.</p>
  
  <p>TID[-1234] [DAS] [2015-11-09 12:28:06,265] ERROR {org.wso2.carbon.event.output.adapter.rdbms.RDBMSEventAdapter} - Cannot Execute Create Table Query. There is already an object named 'tbl_City' in the database. Hence Event is dropped. org.wso2.carbon.event.output.adapter.rdbms.RDBMSEventAdapter.createTableIfNotExist(RDBMSEventAdapter.java:416) org.wso2.carbon.event.output.adapter.rdbms.RDBMSEventAdapter.executeProcessActions(RDBMSEventAdapter.java:290) org.wso2.carbon.event.output.adapter.rdbms.RDBMSEventAdapter.publish(RDBMSEventAdapter.java:134) org.wso2.carbon.event.output.adapter.core.internal.OutputAdapterRuntime.publish(OutputAdapterRuntime.java:62) org.wso2.carbon.event.output.adapter.core.internal.CarbonOutputEventAdapterService.publish(CarbonOutputEventAdapterService.java:143) org.wso2.carbon.event.publisher.core.internal.EventPublisher.process(EventPublisher.java:361) org.wso2.carbon.event.publisher.core.internal.EventPublisher.sendEvent(EventPublisher.java:209) org.wso2.carbon.event.publisher.core.internal.EventPublisher.consumeEvent(EventPublisher.java:275) org.wso2.carbon.event.stream.core.internal.EventJunction.sendEvent(EventJunction.java:142) org.wso2.carbon.event.receiver.core.internal.management.InputEventDispatcher.onEvent(InputEventDispatcher.java:27) org.wso2.carbon.event.receiver.core.internal.EventReceiver.sendEvent(EventReceiver.java:259) org.wso2.carbon.event.receiver.core.internal.EventReceiver.processTypedEvent(EventReceiver.java:237) org.wso2.carbon.event.receiver.core.internal.EventReceiver$TypedEventSubscription.onEvent(EventReceiver.java:317) org.wso2.carbon.event.input.adapter.core.internal.InputAdapterRuntime.onEvent(InputAdapterRuntime.java:110) org.wso2.carbon.event.input.adapter.http.HTTPMessageServlet$HTTPRequestProcessor.run(HTTPMessageServlet.java:210) java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) java.util.concurrent.FutureTask.run(FutureTask.java:262) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) java.lang.Thread.run(Thread.java:745) </p>
  
  <p>Please confirm.</p>