[ 
https://issues.apache.org/jira/browse/STONEHENGE-23?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12701042#action_12701042
 ] 

S.Uthaiyashankar commented on STONEHENGE-23:
--------------------------------------------

org.wso2.stocktrader.mssql.MSSQLDAOFactory.host=localhost
org.wso2.stocktrader.mssql.MSSQLDAOFactory.port=1433

should work for SQLExpress as well. If you have SQLServer and SQLExpress 
together, then SQLExpress might listen on a different port? Can you try it and 
let me know? (It worked for me, but I am using SQLExpress 2005). If it is not 
working, we'll add it. Will you be able to provide a patch in that case? 

> There is not property available for an Instance Name in WSAS db-properties.
> ---------------------------------------------------------------------------
>
>                 Key: STONEHENGE-23
>                 URL: https://issues.apache.org/jira/browse/STONEHENGE-23
>             Project: Stonehenge
>          Issue Type: Bug
>          Components: WSAS_BS
>            Reporter: Ben Dewey
>            Assignee: S.Uthaiyashankar
>            Priority: Minor
>             Fix For: M1
>
>
> A ran into another anomaly with the Named Instance of SQL Express.  The jtds 
> faq had this link that helped me find a solution 
> http://jtds.sourceforge.net/faq.html#instanceName.  What I did is very much 
> an injection hack (notice the db property),  I think we should Add a JIRA 
> ticket for this optional parameter.
> org.wso2.stocktrader.mssql.MSSQLDAOFactory.host=localhost
> org.wso2.stocktrader.mssql.MSSQLDAOFactory.port=1433
> org.wso2.stocktrader.mssql.MSSQLDAOFactory.db=StockTraderDB;Instance=SQLExpress
> org.wso2.stocktrader.mssql.MSSQLDAOFactory.user=trade
> org.wso2.stocktrader.mssql.MSSQLDAOFactory.password=trade

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to