SAM with SQLSERVER Data Source

[root]

I am trying to setup SAM by using MSSQL Server as a data source instead of Derby. 

I installed the SQLSERVER DataSource by adding the sqljdbc*.jar file into

<TalendRuntimePath>/deploy folder

I installed SQLServer DataSource in OSGI by giving the command:

feature:install tesb-datasource-sqlserver

I edited

<TalendRuntimePath>/etc/org.talend.esb.datasource.sqlserver.cfg

and provided my DB connection details

From Karaf, I ran:

tesb:start-sam

This created a Derby Data Source and installed the Derby-starter and tesb-datasource-derby feature. 

Why would this happen? How can I force use only SQLSERVER data source?
Please advise. Thank you.

[Anonymous]

Hi,

The "tesb:start-sam" is an aliase command for start the default Derby datasource and SAM server/services.

tesb:start-sam = { feature:install tesb-datasource-derby tesb-derby-starter tesb-sam-service-soap tesb-sam-service-rest } ;

So in case of other datasource you want to use, the "tesb:start-sam" should not be run in your final step, instead, you can do:
feature:install tesb-sam-service-soap
feature:install tesb-sam-service-rest

Regards.

[root]

xldai wrote:
Hi,

The "tesb:start-sam" is an aliase command for start the default Derby datasource and SAM server/services.

tesb:start-sam = { feature:install tesb-datasource-derby tesb-derby-starter tesb-sam-service-soap tesb-sam-service-rest } ;

So in case of other datasource you want to use, the "tesb:start-sam" should not be run in your final step, instead, you can do:
feature:install tesb-sam-service-soap
feature:install tesb-sam-service-rest

Regards.

Ahh, I see. Makes sense. Will try that!