[
https://issues.apache.org/jira/browse/STONEHENGE-23?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12701015#action_12701015
]
Ben Dewey commented on STONEHENGE-23:
-------------------------------------
>From my initial testing I think the following lines need to be added to
>(trunk\stocktrader\wsas\common\src\org\wso2\stocktrader\mssql\MSSQLDAOFactory.java)
(43) public static final String PROP_MSSQL_DB_INSTANCE =
"org.wso2.stocktrader.mssql.MSSQLDAOFactory.instance";
(145) if (prop.getProperty(PROP_MSSQL_DB_INSTANCE) != null) {
// I'm rusty with java so != null or != "" whatever getProperty would return
buf.append(";Instance=" + prop.getProperty(PROP_MSSQL_DB_INSTANCE));
}
And the respective property should be added to the mssql-db.properties
> 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
> Priority: Minor
>
> 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.
