• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 783
  • Last Modified:

What is a database realm?

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
stephaneeybert
Asked:
stephaneeybert
1 Solution
 
pepenietoCommented:
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now