Hi,
I just implemented Josso in our web application developed using
appfuse 1.7.I have one question regarding adding jaasrealm in
tomcat-context.xml.
I have appuser,role and userrole tables under my schema name like
oemc.Undermy schema only user and roles tables all other tables are
already in
production database like in my web app based on the role display the menus
adding vouchers and displaying lists of vouchers all values are under other
schemas names..My question is in tomcat-context.xml i added jaasrealm and
Resourceparams with my schema name ex oemc..but in the properties.xml ,
build.properties and database.properties refers different schema ex
production database ..How can i refer one schema for user and role table and
other schema for other tables like displaying voucher and adding voucher in
different table..
example:tomcat-context.xml
Added jaasrealm for user and role table
<Realm className="org.josso.tc50.agent.jaas.CatalinaJAASRealm"
appName="josso"
userClassNames="org.josso.gateway.identity.service.BaseUserImpl
"
roleClassNames="org.josso.gateway.identity.service.BaseRoleImpl
"
debug="1" />
<Resource name="jdbc/omis" auth="Container" type="javax.sql.DataSource
"/>
<ResourceParams name="jdbc/omis">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<!-- Maximum number of dB connections in pool. Make sure you
configure your mysqld max_connections large enough to handle
all of your db connections. Set to 0 for no limit.
-->
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<!-- Maximum number of idle dB connections to retain in pool.
Set to 0 for no limit.
-->
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<!-- Maximum time to wait for a dB connection to become available
in ms, in this example 10 seconds. An Exception is thrown if
this timeout is exceeded. Set to -1 to wait indefinitely.
-->
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<!-- MySQL dB username and password for dB connections -->
<parameter>
<name>username</name>
<value>oemc</value>
</parameter>
<parameter>
<name>password</name>
<value>oemc</value>
</parameter>
<!-- Class name for JDBC driver -->
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<!-- Autocommit setting. This setting is required to make
Hibernate work. Or you can remove calls to commit(). -->
<parameter>
<name>defaultAutoCommit</name>
<value>true</value>
</parameter>
<!-- The JDBC connection url for connecting to your MySQL dB.
The autoReconnect=true argument to the url makes sure that the
mm.mysql JDBC Driver will automatically reconnect if mysqld
closed the
connection. mysqld by default closes idle connections after 8
hours.
-->
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@200.2.3.118:1526:omis</value>
</parameter>
<!-- Recover abandoned connections -->
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<!-- Set the number of seconds a dB connection has been idle
before it is considered abandoned.
-->
<parameter>
<name>removeAbandonedTimeout</name>
<value>60</value>
</parameter>
<!-- Log a stack trace of the code which abandoned the dB
connection resources.
-->
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
</ResourceParams>
My Properties.xml refers different database table: example: different schema
name.
this refers different schema..preq and preq.
database.driverName="oracle.jdbc.driver.OracleDriver"
database.connectionURL="jdbc:oracle:thin:@200.2.3.118:1526:omis"
database.username=preq
database.password=preq
Pls let me know how can i refers different schemas one for user and role
table schema and another one for all menu items tables like add display list
from another table????
Your help would be greatly appreciated..I have to fix this issue asap.helpme.
Thanks in advance.
