Win a copy of Penetration Testing Basics this week in the Security forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Using J2SE/JDBC to access a J2EE database

Edward Kenworthy
Ranch Hand
Posts: 66
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

[ October 05, 2004: Message edited by: Edward Kenworthy ]
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic