![Red Hat Application Server Manual Download Page 287](http://html.mh-extra.com/html/red-hat/application-server/application-server_manual_1427406287.webp)
Chapter 40. Configuring JDBC Resource Adapters
279
To enable this tracing feature, perform the following configuration steps:
1. Update the appropriate RAR file’s
jonas-ra.xml
file by setting the
dsClass
property to
com.p6spy.engine.spy.P6SpyDriver
.
2. Set the
realdriver
property in the
spy.properties
file (located in
$JONAS_BASE/conf
)
to the JDBC driver of your actual database.
3. Verify that
logger.org.objectweb.jonas.jdbc.sql.level
is set to
DEBUG
in
$JONAS_BASE/conf/trace.properties
.
Example:
jonas-ra.xml file content:
jonas-resource
jndiname
jdbc_3
/jndiname
rarlink
JOnASJDBC_DM
/rarlink
native-lib
/native-lib
log-enabled
true
/log-enabled
log-topic
org.objectweb.jonas.jdbc.DMPostgres
/log-topic
pool-params
pool-init
0
/pool-init
pool-min
0
/pool-min
pool-max
100
/pool-max
pool-max-age
0
/pool-max-age
pstmt-max
10
/pstmt-max
/pool-params
jdbc-conn-params
jdbc-check-level
0
/jdbc-check-level
jdbc-test-statement
/jdbc-test-statement
/jdbc-conn-params
jonas-config-property
jonas-config-property-name
user
/jonas-config-property-name
jonas-config-property-value
jonas
/jonas-config-property-value
/jonas-config-property
jonas-config-property
jonas-config-property-name
password
/jonas-config-property-name
jonas-config-property-value
jonas
/jonas-config-property-value
/jonas-config-property
jonas-config-property
jonas-config-property-name
loginTimeout
/jonas-config-property-name
jonas-config-property-value
/jonas-config-property-value
/jonas-config-property
jonas-config-property
jonas-config-property-name
URL
/jonas-config-property-name
jonas-config-property-value
jdbc:postgresql://your_host:port/your_db
/jonas-config-property-value
/jonas-config-property
jonas-config-property
jonas-config-property-name
dsClass
/jonas-config-property-name
jonas-config-property-value
com.p6spy.engine.spy.P6SpyDriver
/jonas-config-property-value
/jonas-config-property
jonas-config-property
jonas-config-property-name
mapperName
/jonas-config-property-name
jonas-config-property-value
rdb.postgres
/jonas-config-property-value
/jonas-config-property
jonas-config-property
jonas-config-property-name
logTopic
/jonas-config-property-name
jonas-config-property-value
org.objectweb.jonas.jdbc.DMPostgres
/jonas-config-property-value
/jonas-config-property
Summary of Contents for Application Server
Page 1: ...Red Hat Application Server JOnAS User Guide ...
Page 8: ......
Page 22: ...14 Chapter 1 Java Open Application Server JOnAS a J2EE Platform ...
Page 58: ...50 Chapter 3 JOnAS Configuration ...
Page 66: ...58 Chapter 5 JOnAS Class Loader Hierarchy ...
Page 78: ...70 Chapter 6 JOnAS Command Reference ...
Page 80: ......
Page 86: ...78 Chapter 7 Developing Session Beans ...
Page 136: ...128 Chapter 9 Developing Message Driven Beans ...
Page 142: ...134 Chapter 10 Defining the Deployment Descriptor ...
Page 148: ...140 Chapter 11 Transactional Behavior of EJB Applications ...
Page 158: ...150 Chapter 14 EJB Packaging ...
Page 162: ...154 Chapter 15 Application Deployment and Installation Guide ...
Page 164: ......
Page 176: ...168 Chapter 18 WAR Packaging ...
Page 178: ......
Page 184: ...176 Chapter 20 Defining the Client Deployment Descriptor ...
Page 186: ...178 Chapter 21 Client Packaging ...
Page 188: ......
Page 192: ...184 Chapter 23 EAR Packaging ...
Page 194: ......
Page 200: ...192 Chapter 24 JOnAS Services ...
Page 204: ...196 Chapter 25 JOnAS and the Connector Architecture ...
Page 222: ...214 Chapter 27 Ant EJB Tasks Using EJB JAR ...
Page 234: ...226 Chapter 29 Web Services with JOnAS ...
Page 236: ......
Page 260: ...252 Chapter 34 How to use Axis in JOnAS ...
Page 270: ...262 Chapter 36 Web Service Interoperability between JOnAS and BEA WebLogic ...
Page 296: ......