Memo : Weblogic JDBC Persistent Store

Script to use for table creation of a JDBC persistent store :

CREATE TABLE TABLE_NAME (
id     int  not null primary key,
type   int  not null,
handle int  not null,
record blob not null
);

The table name is computed with the prefix name defined at persistent store configuration with the appended string WLSTORE. So for exemple if prefix name is MYAPPLI, the table name will be MYAPPLIWLSTORE.

The command line to create the table could be :

java utils.Schema  url JDBC_driver  [options] DDL_file

options could be :

• -u for database connection username
• -p for the user password
• -s for the database SID

You will find hereunder is an example of the installation command line :

java utils.Schema jdbc:weblogic:oracle:DEMO weblogic.jdbc.oci.Driver -u user1 -p password1 -verbose   createTab.ddl

Command line to use the Jconsole to connect on Weblogic 10.3.1

This is the command line that is usefull for the connection of the jconsole on a Weblogic server 10.3.1

%JAVA_HOME%\bin\jconsole -J-Djava.class.path=%JAVA_HOME%\lib\jconsole.jar;%JAVA_HOME%\lib\tools.jar;%BEA_HOME%\server\lib\wljmxclient.jar -J-Djmx.remote.protocole.provider.pkgs=weblogic.management.remote -J-Dcom.sun.management.jmxremote

where JAVA_HOME references the jdk and BEA_HOME the installation directory of the weblogic server