2 Replies Latest reply on Feb 14, 2012 4:53 PM by Joseph Fouts

    How to set db2 security mechanism property using JBoss7

    Joseph Fouts Novice

      Our db2 admin tells me that are tables are setup with the database name as the user and NO password.

       

      Using the db2 type 4 driver outside of jboss 7 I have to set the following security mechanism property.

       

      Here is the code I needed to put in my standalone test java program to make a connection using my db2

      type 4 driver:

       

                setProperty("securityMechanism", "" + com.ibm.db2.jcc.DB2BaseDataSource.USER_ONLY_SECURITY);

       

       

      Without this property getting set (standalone.xml?) I'm getting a "Security Manager" violation sql error.

       

       

      Does anyone know how I would set this property using jboss 7?

       

      I have the db2 driver setup as a module and defined in the standalone.xml.

       

      Thanks.