public interface AdminConsole
SQL engine. You can either
use the Admin
Console UI (as explained below) or directly specify equivalent properties in your
server.properties file (see "Manually
specifying.." below).
To use the Admin Console, make sure you have followed the
full installation instructions - double check that
you have the
correct GWT <inherits> as shown in those instructions. Then, launch your GWT project
from your IDE, and open a web browser to moduleBaseURL/tools/adminConsole.jsp. For
example, if you load your application by going to a URL that ends in
builtinds/builtinds.html, the correct URL for the Admin Console is
builtinds/tools/adminConsole.jsp.
If it's not clear what URL to use, you can add the following code to your onModuleLoad() method to create a button that opens the Admin Console:
IButton adminButton = new IButton("Admin Console");
adminButton.addClickHandler(new ClickHandler() {
public void onClick(ClickEvent event) {
com.smartgwtee.tools.client.SCEE.openDataSourceConsole();
}
});
adminButton.draw();
NOTE: if you are using Pro Edition, the method to call is
com.smartgwtpro.tools.client.SCPRO.openDataSourceConsole(), and for Power Edition,
com.smartgwtpower.tools.client.SCPower.openDataSourceConsole().
Having opened the Admin Console, available JNDI connections will be discovered and shown
automatically. If you aren't using JDNI, use the GUI to enter and test JDBC settings. Both
ConnectionManager and JDBC DataSource settings are supported. Once you've got a working
connection, set it as the default connection using the "Set as Default" button.
These settings will be written to server.properties
in your deployment directory - use
the "Download server.properties" button to download the settings and merge them to the
server.properties file in your Eclipse (or other IDE) project.
Test Data
You can create a test file that contains a sample dataset which can be imported into your database table with the Admin Console.
The test file to use with your DataSource is specified in the testFileName
DataSource configuration property. The test file uses the extension .data.xml.
The test data file should consist of a top-level <List> element containing a series of XML elements named after your DataSource's ID, each of which creates one DataSource record. Values for each field are given within tags named after the field name.
For example, the following XML is from the supplyItem.data.xml test data file supplied with the Isomorphic Smart GWT package. This file is located in [webroot]/examples/shared/ds/test_data/.
<List>
<supplyItem>
<description>A revolutionary cushion-grip ballpoint pen that reduces
required gripping power, relieving stress and alleviating writing
fatigue. Excellent for people who suffer from arthritis or carpal
tunnel syndrome. Medium point, black ink. Refillable.</description>
<category>1</category>
<itemRef>ODC 204-502-153</itemRef>
<maxQuantity>5</maxQuantity>
<requiresJustification>0</requiresJustification>
<itemName>Dr. Grip Pens -- Blue Barrel</itemName>
<itemID>1</itemID>
<unitCost>4.99</unitCost>
</supplyItem>
<supplyItem>
<description>A revolutionary cushion-grip ballpoint pen that reduces
required gripping power, relieving stress and alleviating writing
fatigue. Excellent for people who suffer from arthritis or carpal
tunnel syndrome. Medium point, black ink. Refillable.</description>
<category>1</category>
<itemRef>ODC 204-708-834</itemRef>
<maxQuantity>5</maxQuantity>
<requiresJustification>0</requiresJustification>
<itemName>Dr. Grip Pens -- Black Barrel</itemName>
<itemID>2</itemID>
<unitCost>4.99</unitCost>
</supplyItem>
<supplyItem>
<description>Personalized business cards for all your networking
needs.</description>
<category>2</category>
<itemRef></itemRef>
<maxQuantity>500</maxQuantity>
<requiresJustification>1</requiresJustification>
<itemName>Personalized business cards -- 500 count</itemName>
<itemID>3</itemID>
<unitCost>25.00</unitCost>
</supplyItem>
...
<List/>
Data for a tree-like DataSource can be specified with the same format.
The following code example is from the supplyCategory.data.xml test data file. This file
is also located in [webroot]/examples/shares/ds/test_data/.
<List>
<supplyCategory>
<itemName>Office Paper Products</itemName>
<parentID>root</parentID>
</supplyCategory>
<supplyCategory>
<itemName>Calculator Rolls</itemName>
<parentID>Office Paper Products</parentID>
</supplyCategory>
<supplyCategory>
<itemName>Adding Machine/calculator Roll</itemName>
<parentID>Calculator Rolls</parentID>
</supplyCategory>
. . .
</List>
Notice that all records must define values for the itemName primary key field and for the
parentID field that establishes the tree relationship.
Manually specifying database connection settings
The Admin Console maintains settings in the server.properties
file, found in
your application's WEB-INF/classes directory. If you prefer, you can maintain
these settings by directly editing that file. You should restart your servlet engine
after changing this file.
For example, the following settings are the defaults in a new Smart GWT installation for
a MySQL server; they are approximately correct for a MySQL server running on the same
machine as the servlet engine and listening on the default MySQL port. For details of what
each of these properties means, check this
page.
sql.Mysql.database.type: mysql
sql.Mysql.database.ansiMode: false
sql.Mysql.interface.type: dataSource
sql.Mysql.driver: com.mysql.jdbc.jdbc2.optional.MysqlDataSource
# name of the database to use
sql.Mysql.driver.databaseName: isomorphic
# hostname and port where the database server is installed
sql.Mysql.driver.serverName: localhost
sql.Mysql.driver.portNumber: 3306
# username and password that can create and modify tables in that database
# this user must have the following privileges for the system to function
# properly: create/alter/drop table; insert/update/replace/delete rows.
sql.Mysql.driver.user: root
sql.Mysql.driver.password:
Note the distinction here between database type and database name. Database
type refers to the actual product - Oracle, DB2 or whatever. In the above example, database
type is "mysql" (all lowercase) - the value of property sql.Mysql.database.type.
Database type is very important. The type of a given database connection dictates whether
features like SQL paging and transactions are supported; it even dictates the syntax of the
SQL we generate.
Database name is just an arbitrary name for a particular database connection, and it is
embedded in the property names immediately after the sql prefix. In this example
it happens to be very similar to the database type - "Mysql" as opposed to "mysql" - but in
fact the name has no significance and could be any string. When referring to specific
database connections in your DataSources with the
dbName property, it is the database
name you use.
NOTE: It is common for DataSources to not specify dbName. In this case, the
default database is used. To specify the default database manually in
server.properties, set
sql.defaultDatabase, using database
name. So, to set our example connection from above as the default:
sql.defaultDatabase: Mysql
Manually specifying JNDI settings
Instead of specifying database connection parameters directly in
server.properties,
it is possible to connect to a database that is configured as a JNDI resource in your
application server. Assume you have an Oracle JNDI resource with the name "jndiTest",
configured similar to this in Tomcat:
<Resource name="jdbc/jndiTest"
auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@192.168.132.152:1521:xe"
username="system"
password="manager"
initialSize="5"
maxActive="50" />
The minimal set of properties required to create a Smart GWT database connection that
attaches to this resource is as follows (Note that the java:comp/env/ prelude
in the first line is optional - the server will automatically look there if it can't find
the resource in the absolute location)
sql.myOracleConnection.driver.name: java:comp/env/jdbc/jndiTest
sql.myOracleConnection.database.type: oracle
sql.myOracleConnection.interface.type: jndi