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

Also, very odd, and I don't know why this is happening, but in order to get the 
WSAS Business Service to process an order I had to change my DBCONFIG Table 
setting from what I expected (localhost\SQLExpress) to only localhost.

-Ben

Reply via email to