EJBs & CMP with real database users

From: Matt Hughes (mhughes_at_artemisgroup.com)
Date: 08/24/04 

Date: 24 Aug 2004 09:16:08 -0700

I am in the beggining stages of designing a J2EE application. The
current application that I am porting to J2EE maintains real users in
the database, not just a user table. That is, every connection to the
database must be made with the individual username/password for each
user. All the examples and literature I have read regarding CMP
entity beans only has one user for all beans. Is it possible to let
users log in to the application using their creditials (which would in
turn connect to the database) and only let them view data they are
allowed to see?

My major problem is that there are a lot of views in my DB schema that
are based on user_id. I have little control over the schema and do
not feel like reimplementing 20 or so views in my code. Has anyone
run into this problem or know of a solution?

Relevant Pages

  • EJBs & CMP with real database users
    ... I am in the beggining stages of designing a J2EE application. ... the database, ... My major problem is that there are a lot of views in my DB schema that ... I have little control over the schema and do ...
    (comp.lang.java.databases)
  • Re: moving from J2SE to the J2EE world? how?
    ... > I am a java desktop application programmer with about 5 years ... > I think it is time to move into the J2EE world, ... database, and that does well as a web app. ... Java, Cocoa, and Database consulting for the life sciences ...
    (comp.lang.java.programmer)
  • Re: J2EE and various databases, including SQL Server
    ... Ken Larson wrote: ... > I've done a fair amount of Java, but I am just starting to learn J2EE. ... > I'm dealing right now with a requirement for a project that the database ...
    (comp.lang.java.programmer)
  • Re: EJB persistence versus Database persistence?
    ... the layer you have to write is the connection between ... > your objects and the actual database subsystem that you choose. ... question the economic rationale for a J2EE based solution versus a JDBC ... Let's just abolish once and for all this "toy" aura envelops MySQL shall we? ...
    (comp.lang.java.programmer)
  • Re: Java is becoming the new Cobol
    ... In the Unisys 2200 environment using their Network Database Server, you get a schema work area depending on how you invoke the schema. ... However, it not only copies the schema area into the program, but the "DMCA" (Database Management Communication Area - basically, the block of information that holds your connection state) is copied in too. ... So, you're left with working-storage, which makes it visible to your program only, or common-storage, which makes it visible to programs linked in. ...
    (comp.lang.cobol)