MSSQL problems

[ks1]

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:

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

[Stefan Schmidt]

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