Solved

What is a database realm?

Posted on 2002-03-13
1
777 Views
Last Modified: 2013-12-10
Dear all,


What is a database realm? Do I need to have one to use a mysql database with connection pooling?


In the config.xml file, I have this setup:

  <JDBCConnectionPool
    CapacityIncrement="2"
    DriverName="org.gjt.mm.mysql.Driver"
    InitialCapacity="4"
    LoginDelaySeconds="1"
    MaxCapacity="10"
    Name="mysqlPool"
    Properties="user=hans;password=qgCQFkPV"
    RefreshMinutes="10"
    ShrinkPeriodMinutes="15"
    ShrinkingEnabled="true"
    Targets=""
    TestConnectionsOnRelease="false"
    TestConnectionsOnReserve="false"
    TestTableName="dual"
    URL="jdbc:mysql://localhost:3306/db1"
  />
 
  <JDBCDataSource
    JNDIName="generic-dataSource-mysqlPool"
    Name="generic-dataSource-mysqlPool"
    PoolName="mysqlPool"
    Targets="genericServer"
  />


  <RDBMSRealm
    Name="defaultRDBMSRealmForMySql"
    RealmClassName="generic.security.rdbmsrealm.RDBMSRealm"
    DatabaseDriver="org.gjt.mm.mysql.Driver"
    DatabaseURL="jdbc:mysql://localhost:3306/db1"
    DatabaseUserName="hans"
    DatabasePassword="qgCQFkPV"
    SchemaProperties=""
    Notes="The data source for the mySql database db1"
  />


Do I need the rdbmsrealm?


Stephane

0
Comment
Question by:stephaneeybert
1 Comment
 
LVL 1

Accepted Solution

by:
pepenieto earned 50 total points
ID: 6885007
A Database realm is used for managing java security. That is, if you want to use java security (ACL´s, USER´s, GROUP´s) in your application, and you want the users & groups of your application to be the same that managed for weblogic, you must do a rdbmsrealm that tells weblogic what are the tables, views, sql statements,... to access your database information.

If you want to use your mysql database you don´t need rdbmsrealm.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Verbose logging is used to diagnose garbage collector problems. By default, -verbose:gc output is written to either native_stderr.log or native_stdout.log.   It is also possible to redirect the logs to a user-specified file. This article will de…
There are numerous questions about how to setup an IBM HTTP Server to be administered from WebSphere Application Server administrative console. I do hope this article will wrap things up and become a reference for this task. You need three things…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question