MSSQL problems

Hi Guys,

I've just been taking a look around Roo and am impressed so far.

I've had an issue though with MSSQL drivers (often a problem). When I deploy to tomcat, using just the out of the box MSSQL config I get the following error:

Code:

---

Property 'driverClassName' threw exception; nested exception is java.lang.Illega
lStateException: Could not load JDBC driver class [com.microsoft.jdbc.sqlserver.
SQLServerDriver]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1278)
        at
...

---

I've tried modifying the database properties but I then need to modify the application context, etc. While this is doable, it would be nice not to have to.

Is there something else I should have done from within Roo? If not, are there any plans to improve this?

Thanks,
Kevin

Hi Kevin,

It seems like you don't have the driver in your classpath. You could consider using the jtds driver if you don't have access to the Microsoft one.

Can you open a Jira ticket for this so we can test against jtds and see if that works better? This driver would be available via maven.

Thanks.

-Stefan