I've done some more random fiddling and I discovered something that is
almost useful... It appears that the SQL Server is only allowing *one*
connection using the given login credentials. The frustrating part is I
have double checked the setting and it is "MULTI_USER" which is supposed to
allow multiple sessions with the same credentials (as opposed to
"SINGLE_USER"). So until I figure out what is wrong with the server, Is it
possible to run AppFuse with only one DB connection? Where do you set the
DBCP properties?
Thanks
Nathan
On Sun, Nov 9, 2008 at 1:28 PM, Nathan Anderson <[EMAIL PROTECTED]> wrote:
> Hello all!
>
> It's been a long time since I have been able to work on an AppFuse project,
> so it is time for another crash course ;) There are a few technologies
> being used in this project that are a bit out of the norm for me, so I'll
> probably be asking a lot of questions.
>
> So far I have created a new SpringMVC Basic app from the archtype. The
> first deviation from typical is that we are using an SQL Server 2005. So I
> modified the pom "sqlserver" db profile to match my server. DbUnit seems to
> create the database correctly, the tables are added to the "dbo" schema so
> they look like "dbo.app_user" and are populated with the testing data. That
> is what I expected so I'm hoping at least that much is right.
>
> The problem is "integration-test" fails when it gets to the "Save User" web
> test with a "Data Access Error." And I see the same problem when running
> the app with "jetty:run-war" ("jetty:run" completely fails, but I suspect
> that is a different problem).
>
> Any suggestions?
>
> Thanks
> Nathan
>
