I have a J2EE application (Struts over SSB and CMP-EJB, yeah yeah I know, I inherited the architecture, give me a break I'm suffering enough ;-).
Anyway, I need to modify the data in the database the CMP-EJBs are running over. Doing this through Query Analyzer (the db is SQLServer) works just fine.
I'm wondering if there would be any issues in building a separate stand-alone J2SE application and have that perform transactional updates on the database (typically multiple inserts/update): I'm using Hibernate and an open source MSSQL type 4 jdbc driver.
We have experienced issues with Access (again, don't ask) locking up the database, would the same happen using my J2SE application?
Personally, I wouldn't have thought so, after all SQLServer is actually doing all the managing and everything goes through it.
Thoughts? [ October 05, 2004: Message edited by: Edward Kenworthy ]