I think it was incorrect of me to start a new problem at the end of another thread. So, I have started this new one, properly.
Now my problem is connecting to my database. My database is not found in the server.properties file I deploy to the server.
I have a dbName in all of my datasource.ds.xml files. (dbName="PlanetProjectDB"). This works fine in the embedded Tomcat, even after I switched to MySQL. So, I did some research in the SC reference and found "SQL Database Settings in server.properties". But, I am a bit confused.
Where does the ds.xml dbName show up in the server.properties file? Nothing matches up with the MySQL section in the server.properties examples.
Here are the files involved with this new problem.
context.xml under META-INF
web.xml
server.properties under WEB-INF/classes
The resulting Tomcat catalina.out
Rick
P.S. I am running SmartClient Version: v8.2p_2012-06-08/EVAL Development Only on Mozilla Firefox 3.6.18 with Firebug using Windows XP Pro 32 bit.
Now my problem is connecting to my database. My database is not found in the server.properties file I deploy to the server.
I have a dbName in all of my datasource.ds.xml files. (dbName="PlanetProjectDB"). This works fine in the embedded Tomcat, even after I switched to MySQL. So, I did some research in the SC reference and found "SQL Database Settings in server.properties". But, I am a bit confused.
Although the Admin Console provides a UI to let you to configure database access for DataSources that use SmartClient's built-in SQL engine, it is also possible to configure these DataSources with manual entries in your server.properties file.
When you manually configure a DataSource like this, you do so by maintaining a set of properties with names structured like this:
sql.{dbName}.x.y
where {dbName} is the name of the database configuration you are providing. Note that this database name is just an arbitrary name for a particular database configuration; many of the default ones provided with SmartClient are named after a database type, in order to make their intended use more immediately obvious, but this is not by any means a requirement.
For the remainder of this discussion, we will assume we are configuring a database with a name of "MyDatabase".
When you manually configure a DataSource like this, you do so by maintaining a set of properties with names structured like this:
sql.{dbName}.x.y
where {dbName} is the name of the database configuration you are providing. Note that this database name is just an arbitrary name for a particular database configuration; many of the default ones provided with SmartClient are named after a database type, in order to make their intended use more immediately obvious, but this is not by any means a requirement.
For the remainder of this discussion, we will assume we are configuring a database with a name of "MyDatabase".
Here are the files involved with this new problem.
context.xml under META-INF
Code:
<Context>
<Resource name="jdbc/PlanetProjectDB"
auth="Container"
type="javax.sql.DataSource"
username="root"
password="6up0wbgvFN"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/PUBLIC"
maxActive="15"
maxIdle="3"/>
</Context>
Code:
<web-app xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"
version="2.4">
<!-- Note: The servlets/filters referenced here are documented in the SDK javadoc -->
<!-- //>FileLoader -->
<!-- Dynamic Compression -->
<filter>
<filter-name>CompressionFilter</filter-name>
<filter-class>com.isomorphic.servlet.CompressionFilter</filter-class>
</filter>
<!-- CompressionFilter for dynamic compression -->
<filter-mapping>
<filter-name>CompressionFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- //<FileLoader -->
<!-- The IDACall servlet handles all Built-in DataSource operations -->
<servlet>
<servlet-name>IDACall</servlet-name>
<servlet-class>com.isomorphic.servlet.IDACall</servlet-class>
</servlet>
<!-- The RESTHandler servlet handles SmartClient Server DataSource operations issued by
REST clients - it's like IDACall, but for the REST protocol. Typically, the clients
of this servlet would not be ordinary SmartClient/SmartGWT applications (though they
could be), but other client technologies that need to access SmartClient DataSource
operations as reusable services -->
<servlet>
<servlet-name>RESTHandler</servlet-name>
<servlet-class>com.isomorphic.servlet.RESTHandler</servlet-class>
</servlet>
<!-- The DataSourceLoader servlet returns Javascript representations of the dataSources whose
ID's are passed to it - it is an alternative to using the <loadDS> JSP tag -->
<servlet>
<servlet-name>DataSourceLoader</servlet-name>
<servlet-class>com.isomorphic.servlet.DataSourceLoader</servlet-class>
</servlet>
<!-- The FileDownload servlet downloads static files, like a webserver -->
<servlet>
<servlet-name>FileDownload</servlet-name>
<servlet-class>com.isomorphic.servlet.FileDownload</servlet-class>
</servlet>
<!-- ISC init: initializes ISC framework -->
<servlet>
<servlet-name>Init</servlet-name>
<servlet-class>com.isomorphic.base.Init</servlet-class>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet>
<servlet-name>HttpProxy</servlet-name>
<servlet-class>com.isomorphic.servlet.HttpProxyServlet</servlet-class>
</servlet>
<!-- The PreCache servlet initializes when the servlet engine starts up and pre-loads
data need for all client requests. This is optional, and improves performance
of the first few page requests. PreCache cannot be invoked by a browser, because
there is no "servlet-mapping" defined for it. -->
<servlet>
<servlet-name>PreCache</servlet-name>
<servlet-class>com.isomorphic.servlet.PreCache</servlet-class>
<load-on-startup>2</load-on-startup>
</servlet>
<!-- RPCManager uses this URL by default for Built-in DataSource operations -->
<servlet-mapping>
<servlet-name>IDACall</servlet-name>
<url-pattern>/isomorphic/IDACall/*</url-pattern>
</servlet-mapping>
<!-- Built-in DataSource operations backcompat -->
<servlet-mapping>
<servlet-name>IDACall</servlet-name>
<url-pattern>/isomorphic/IDACall.aspx/*</url-pattern>
</servlet-mapping>
<!-- DataSourceLoader requests -->
<servlet-mapping>
<servlet-name>DataSourceLoader</servlet-name>
<url-pattern>/isomorphic/DataSourceLoader</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>HttpProxy</servlet-name>
<url-pattern>/isomorphic/HttpProxy/*</url-pattern>
</servlet-mapping>
<!-- Use FileDownload servlet to download all static content that's part of the skin, such as
image files, so we can set Expires headers and other cache control directives. In a
production deployment, you'd want to use a webserver such as Apache to do this.
-->
<servlet-mapping>
<servlet-name>FileDownload</servlet-name>
<url-pattern>/isomorphic/skins/*</url-pattern>
</servlet-mapping>
<!-- serve ISC modules compressed, with expires headers -->
<servlet-mapping>
<servlet-name>FileDownload</servlet-name>
<url-pattern>/isomorphic/system/modules/*</url-pattern>
</servlet-mapping>
<!-- serve ISC development modules compressed, with expires headers -->
<servlet-mapping>
<servlet-name>FileDownload</servlet-name>
<url-pattern>/isomorphic/system/development/*</url-pattern>
</servlet-mapping>
<!-- server skin assets with expires headers -->
<servlet-mapping>
<servlet-name>FileDownload</servlet-name>
<url-pattern>/isomorphic/system/reference/skin/*</url-pattern>
</servlet-mapping>
<!-- General config -->
<session-config>
<session-timeout>30</session-timeout>
</session-config>
<jsp-config>
<!-- Isomorphic JSP tags -->
<taglib>
<taglib-uri>isomorphic</taglib-uri>
<taglib-location>/WEB-INF/iscTaglib.xml</taglib-location>
</taglib>
<!-- Serve *.isc files with iscHeader/iscFooter -->
<jsp-property-group>
<url-pattern>*.isc</url-pattern>
<include-prelude>/shared/jsp/iscHeader.jsp</include-prelude>
<include-coda>/shared/jsp/iscFooter.jsp</include-coda>
</jsp-property-group>
<!-- Process *.rpc files as RPC requests - puts you in an iterator over current RPC requests -->
<jsp-property-group>
<url-pattern>*.rpc</url-pattern>
<include-prelude>/shared/jsp/rpcHeader.jsp</include-prelude>
<include-coda>/shared/jsp/rpcFooter.jsp</include-coda>
</jsp-property-group>
</jsp-config>
<mime-mapping>
<extension>manifest</extension>
<mime-type>text/cache-manifest</mime-type>
</mime-mapping>
<resource-ref>
<description>Planet Project Database connection</description>
<res-ref-name>jdbc/PlanetProjectDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
<welcome-file-list>
<welcome-file>PlanetProject.jsp</welcome-file>
</welcome-file-list>
</web-app>
Code:
# The webRoot directory: # the directory that the servlet engine regards as the place where applications # that use the servlet engine should be installed. Generally, it is safe to leave # this at the default setting of __AUTODETECT__. When the SmartClient server is # started, it logs a message to stdout telling you the autodetected path to your # webRoot. If this path is not your actual webRoot, then you'll want to override # this config parameter here. # # Valid values: # # 1. Absolute path to the webRoot directory # # 2. Special token: __AUTODETECT__ # When this token is used, SmartClient attempts to auto-detect the webRoot using # standard servlet APIs. This may or may not work - depending on your # container type and deployment type. For example, WAR/EAR deployments # on some containers never make it to disk, and so the container refuses # to provide the webRoot path. # # If SmartClient cannnot detect the webRoot, it sets the webRoot to # __USE_CONTAINER__ (see below). # # 3. Special token: __USE_CONTAINER__ # When this token is used, SmartClient uses standard servet APIs for accessing # filesystem resources. This is slower than direct file access and, since # the servlet APIs provide no mechanism for writing to disk, means that some # development tools like the FileAssembler will not work. # webRoot: __AUTODETECT__ # if you've moved the isomorphic directory from its default location in webRoot, # set the root-relative path to it here # # For example, if in your deployment the 'isomorphic' dir is in /foo/bar, then set # then you'll need to set this to foo/bar/isomorphic isomorphicPathRootRelative: isomorphic # -------------- PICK DATABASE TO USE -------------------- # # The SmartClient SDK ships with examples that use a database as the persistence # layer. By default, the SDK uses a built-in version of HSQLDB, but you can # specify a different database to use here. # which database do you want to use? HSQLDB is enabled by default. #sql.defaultDatabase: HSQLDB # If you want to use Mysql instead, uncomment the following line # and comment all other sql.defaultDatabase definitions sql.defaultDatabase: Mysql # If you want to use Oracle instead, uncomment the following line # and comment all other sql.defaultDatabase definitions #sql.defaultDatabase: Oracle # If you want to use Postgres instead, uncomment the following line # and comment all other sql.defaultDatabase definitions #sql.defaultDatabase: PostgreSQL # If you want to use DB2 instead, uncomment the following line # and comment all other sql.defaultDatabase definitions #sql.defaultDatabase: DB2 # -------------- SETTINGS FOR HSQLDB -------------------- sql.HSQLDB.database.type: hsqldb sql.HSQLDB.interface.type: driverManager sql.HSQLDB.driver: org.hsqldb.jdbcDriver sql.HSQLDB.driver.url: jdbc:hsqldb:file:$webRoot/WEB-INF/db/hsqldb/isomorphic # -------------- SETTINGS FOR MYSQL -------------------- # These are the settings for use with the Mysql database. If you have # just done a fresh install of MySQL on the same machine where you are # running your servlet engine, the values provided below will probably # just work on most platforms. # Configuration for Mysql Connector/J 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 #sql.Mysql.driver.databaseName: PUBLIC POSSIBLE NEW VALUE # 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: 6up0wbgvFN # -------------- SETTINGS FOR ORACLE -------------------- # These are the settings for use with the Oracle database. # hostname and port where the database server is installed sql.Oracle.driver.serverName: localhost sql.Oracle.driver.portNumber: 1521 # SID of Oracle Database sql.Oracle.driver.databaseName: isomorphic # 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; create/drop sequences; # insert/update/replace/delete rows. sql.Oracle.driver.user: system sql.Oracle.driver.password: manager # -------------- SETTINGS FOR PostgreSQL -------------------- # These are the settings for use with the PostgreSQL database. # hostname and port where the database server is installed sql.PostgreSQL.driver.serverName: localhost sql.PostgreSQL.driver.portNumber: 5432 # name of the database to use sql.PostgreSQL.driver.databaseName: isomorphic # 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; create/drop sequences; # insert/update/replace/delete rows. sql.PostgreSQL.driver.user: postgres sql.PostgreSQL.driver.password: test # -------------- SETTINGS FOR DB2 --------------------------- # These are the settings for use with the DB2 database. # hostname and port where the database server is installed sql.PostgreSQL.driver.serverName: localhost sql.PostgreSQL.driver.portNumber: 6789 # name of the database to use sql.PostgreSQL.driver.databaseName: isomorphic # 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; create/drop sequences; # insert/update/replace/delete rows. sql.PostgreSQL.driver.user: db2admin sql.PostgreSQL.driver.password: # -------------- SETTINGS FOR SQLServer ------ -------------- # These are the settings for use with the SQLServer database. # # SQLServer is configured via a jdbc URL params are: hostname :port; dbName ; uid; password sql.SQLServer.driver.url: jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Northwind;User=sa;Password= # -------------- SETTINGS FOR Intersystems Cache -------------- sql.Cache.driver.user: _SYSTEM sql.Cache.driver.password: sys sql.Cache.driver.databaseName: SAMPLES sql.Cache.driver.portNumber: 1972 sql.Cache.driver.serverName: localhost # -------------- HIBERNATE SETTINGS -------------------- # Where the system looks for your Hibernate configuration hibernate.config: $webRoot/WEB-INF/classes/hibernate.cfg.xml # -------------- SAMPLE JNDI SETTINGS ------------------ # This is the minimal set of properties needed to define a SmartClient/SmartGWT # database connection to a JNDI resource. These sample properties assume an # Oracle JNDI resource with the name "jndiTest" - such a resource would be # 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" /> # # (Note that the java:comp/env/ prelude in this line is optional - SC/SGWT 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 # -------------- LOADING APP AND DATASOURCE DEFINITIONS -------------------- # Where the system looks for DataSource definition files ([dataSourceId].ds.xml or # [dataSourceID].ds.js). It's useful to put all your DataSources in one # directory since DataSources are frequently shared between applications. # "project.datasources" is also where the DataSource Importer tool looks # for available DataSources. project.datasources: $webRoot/shared/ds, $webRoot/examples/shared/ds project.ui: $webRoot/shared/ui project.apps: $webRoot/shared/app # -------------- SECURE APPLICATION EXAMPLE DEFINITIONS -------------------- authentication.enabled: yes # superuserRole: If specified, user with this role will have access to all # dataSource operations regardless of the any requiresRole settings #authentication.superuserRole: manager authenticator.authExample:com.isomorphic.datasource.DataSourceAuthenticator authenticator.authExample.datasource: user authenticator.authExample.usernameField: username authenticator.authExample.passwordField: password authenticator.authExample.saltField: salt authenticator.authExample.cookieDomain: .smartclient.com authenticator.authExample.sessionTimeout: 1800 # -------------- JMS Configuration for Real Time Messaging -------------------- # If you comment in the properties below, the simple messaging example will work # against Active MQ JMS instead. Be sure to start your ActiveMQ server and double # check the configuraition below, notably the TCP endpoint of your ActiveMQ server. # If you make changes here, you'll also need to modify ActiveMQ's jndi.properties # also located in WEB-INF/classes # # You'll also need to drop the ActiveMQ jar into WEB-INF/lib - it's typically # named apache-activemq-4.1.1.jar or similar. # # For additional information, see this forum post: # http://forums.smartclient.com/showthread.php?p=1785#post1785 # #messaging.dispatcherImplementer: com.isomorphic.messaging.JMSMessageDispatcher # #jndi.messaging.java.naming.factory.initial: org.apache.activemq.jndi.ActiveMQInitialContextFactory #jndi.messaging.java.naming.provider.url: tcp://localhost:61616 # #messaging.jms.context: messaging #messaging.jms.jndiPrefix: #messaging.jms.topicConnectionFactory: TopicConnectionFactory # -------------- Other settings -------------------- # The setting RPCManager.enabledBuiltinMethods enables or disables the BuiltInRPCs - RPC calls # that are built into the SmartClient Server. The setting below reflects the framework default # of enabling only those RPCs that are typically needed in an application. # # See the JavaDoc for com.isomorphic.rpc.BuiltinRPC and com.isomorphic.tools.BuiltinRPC for all # available builtinRPCs and their behavior. # # Note that many of the BuiltinRPCs are designed for use by tools such as Visual Builder, and # provide services such as direct access to the file system (for load and save of screens) that # would be unsafe to expose to untrusted users. # #RPCManager.enabledBuiltinMethods: getPdfObject, getPdfObject, xmlToJS, uploadProgressCheck, exportClientData, downloadClientExport # SECURITY NOTE: DO NOT ENABLE THIS IN PRODUCTION # The special '*' value enables all builtin RPCs. # Do not deploy applications with all builtin RPCs enabled. Some of these are # development-only tools that have not been audited from a security standpoint. RPCManager.enabledBuiltinMethods: * # SECURITY: DO NOT ENABLE THIS IN PRODUCTION # This datasource allows remote deletion and viewing of any file under webRoot. # It is used by the Visual Builder to load/save views. FilesystemDataSource.enabled: true
The resulting Tomcat catalina.out
Code:
=== 2012-08-03 22:42:15,982 [80-1] INFO RequestContext - URL: '/', User-Agent: 'Mozilla/5.0 (Windows NT 5.1; rv:12.0) Gecko/20100101 Firefox/12.0': Moz (Gecko) with Accept-Encoding header === 2012-08-03 22:42:18,786 [80-1] INFO Compression - /: 262949 -> 28090 bytes === 2012-08-03 22:42:18,881 [80-1] DEBUG ServletTools - setting cookie 'isc_cState' to: 'ready' === 2012-08-03 22:42:19,902 [80-1] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/system/modules/ISC_Core.js === 2012-08-03 22:42:20,682 [80-2] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/system/modules/ISC_Foundation.js === 2012-08-03 22:42:20,581 [80-3] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/system/modules/ISC_Grids.js === 2012-08-03 22:42:21,082 [80-1] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/system/modules/ISC_Drawing.js === 2012-08-03 22:42:20,581 [80-5] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/system/modules/ISC_Containers.js === 2012-08-03 22:42:21,082 [80-6] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/system/modules/ISC_Forms.js === 2012-08-03 22:42:21,381 [80-1] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/system/modules/ISC_Analytics.js === 2012-08-03 22:42:21,481 [80-4] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/system/modules/ISC_DataBinding.js === 2012-08-03 22:42:21,383 [80-6] INFO RequestContext - URL: '/isomorphic/system/modules/ISC_DocViewer.js', User-Agent: 'Mozilla/5.0 (Windows NT 5.1; rv:12.0) Gecko/20100101 Firefox/12.0': Moz (Gecko) with Accept-Encoding header === 2012-08-03 22:42:21,881 [80-1] INFO RequestContext - URL: '/isomorphic/system/modules/ISC_VisualBuilder.js', User-Agent: 'Mozilla/5.0 (Windows NT 5.1; rv:12.0) Gecko/20100101 Firefox/12.0': Moz (Gecko) with Accept-Encoding header === 2012-08-03 22:42:21,881 [80-6] INFO Download - File /opt/tomcat/webapps/ROOT/isomorphic/system/modules/ISC_DocViewer.js not found, sending 404 === 2012-08-03 22:42:22,131 [80-4] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/load_skin.js === 2012-08-03 22:42:22,181 [80-1] INFO Download - File /opt/tomcat/webapps/ROOT/isomorphic/system/modules/ISC_VisualBuilder.js not found, sending 404 === 2012-08-03 22:42:23,382 [80-1] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/skin_styles.css === 2012-08-03 22:42:25,710 [80-1] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/shared/background.gif === 2012-08-03 22:42:25,800 [80-1] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/SectionHeader/header_opened_stretch.png === 2012-08-03 22:42:25,800 [80-6] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/SectionHeader/header_opened_start.png === 2012-08-03 22:42:25,884 [80-6] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/SectionHeader/header_opened_end.png === 2012-08-03 22:42:26,082 [80-1] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/SectionHeader/opener_opened.png === 2012-08-03 22:42:26,089 [80-4] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/ListGrid/header_background.gif === 2012-08-03 22:42:26,182 [80-6] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/ListGrid/header.png === 2012-08-03 22:42:26,281 [80-5] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/loadingSmall.gif === 2012-08-03 22:42:26,281 [80-1] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/blank.gif === 2012-08-03 22:42:26,300 [80-6] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/Tab/top/tab_Selected_start.png === 2012-08-03 22:42:26,383 [80-5] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/Tab/top/tab_Selected_stretch.png === 2012-08-03 22:42:26,383 [80-1] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/Tab/top/tab_start.png === 2012-08-03 22:42:26,480 [80-3] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/Tab/top/tab_stretch.png === 2012-08-03 22:42:26,484 [80-4] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/Tab/top/tab_Selected_end.png === 2012-08-03 22:42:26,584 [80-4] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/Tab/top/tab_end.png === 2012-08-03 22:42:26,584 [80-1] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/button/button_Disabled_start.png === 2012-08-03 22:42:26,680 [80-1] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/button/button_Disabled_stretch.png === 2012-08-03 22:42:26,684 [80-4] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/button/button_Disabled_end.png === 2012-08-03 22:42:27,382 [80-3] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/Window/window_T.png === 2012-08-03 22:42:27,481 [80-1] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/Window/window_TR.png === 2012-08-03 22:42:27,681 [80-5] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/Window/window_TL.png === 2012-08-03 22:42:27,781 [80-1] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/Window/window_L.png === 2012-08-03 22:42:28,081 [80-1] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/Window/window_BL.png === 2012-08-03 22:42:28,181 [80-5] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/Window/window_R.png === 2012-08-03 22:42:28,281 [80-2] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/Window/window_B.png === 2012-08-03 22:42:28,481 [80-7] INFO Download - Returning 304: Not modified on conditional get of: /opt/tomcat/webapps/ROOT/isomorphic/skins/SilverWave/images/Window/window_BR.png === 2012-08-03 22:42:28,583 [80-3] INFO RequestContext - URL: '/isomorphic/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 5.1; rv:12.0) Gecko/20100101 Firefox/12.0': Moz (Gecko) with Accept-Encoding header === 2012-08-03 22:42:28,681 [80-4] INFO RequestContext - URL: '/isomorphic/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 5.1; rv:12.0) Gecko/20100101 Firefox/12.0': Moz (Gecko) with Accept-Encoding header === 2012-08-03 22:42:28,682 [80-6] INFO RequestContext - URL: '/isomorphic/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 5.1; rv:12.0) Gecko/20100101 Firefox/12.0': Moz (Gecko) with Accept-Encoding header === 2012-08-03 22:42:29,981 [80-3] DEBUG XML - Parsed XML from (in memory stream): 397ms === 2012-08-03 22:42:29,982 [80-4] DEBUG XML - Parsed XML from (in memory stream): 301ms === 2012-08-03 22:42:30,082 [80-6] DEBUG XML - Parsed XML from (in memory stream): 401ms === 2012-08-03 22:42:30,281 [80-3] DEBUG XML - Parsed XML from /opt/tomcat/webapps/ROOT/isomorphic/system/schema/List.ds.xml: 199ms === 2012-08-03 22:42:30,682 [80-6] DEBUG XML - Parsed XML from /opt/tomcat/webapps/ROOT/isomorphic/system/schema/List.ds.xml: 200ms === 2012-08-03 22:42:30,683 [80-3] DEBUG RPCManager - Processing 1 requests. === 2012-08-03 22:42:30,882 [80-4] DEBUG XML - Parsed XML from /opt/tomcat/webapps/ROOT/isomorphic/system/schema/List.ds.xml: 301ms === 2012-08-03 22:42:31,183 [80-4] DEBUG RPCManager - Processing 1 requests. === 2012-08-03 22:42:31,081 [80-6] DEBUG RPCManager - Processing 1 requests. === 2012-08-03 22:42:32,081 [80-3] DEBUG XML - Parsed XML from /opt/tomcat/webapps/ROOT/shared/ds/IssueLikelihood.ds.xml: 199ms === 2012-08-03 22:42:32,081 [80-6] DEBUG XML - Parsed XML from /opt/tomcat/webapps/ROOT/shared/ds/IssueImpact.ds.xml: 199ms === 2012-08-03 22:42:32,582 [80-4] DEBUG XML - Parsed XML from /opt/tomcat/webapps/ROOT/shared/ds/TeamMember.ds.xml: 401ms === 2012-08-03 22:42:33,981 [80-3] INFO SQLDataSource - Deriving dataSource IssueLikelihood from table: IssueLikelihood === 2012-08-03 22:42:35,181 [80-4] DEBUG XML - Parsed XML from /opt/tomcat/webapps/ROOT/isomorphic/system/schema/OperationBinding.ds.xml: 300ms === 2012-08-03 22:42:35,281 [80-6] INFO PoolableSQLConnectionFactory - No explicit configuration for db: PlanetProjectDB in server.properties - will look for a Connection object at PlanetProjectDB or java:comp/env/PlanetProjectDB. === 2012-08-03 22:42:35,281 [80-6] INFO PoolManager - SmartClient pooling disabled for 'PlanetProjectDB' objects === 2012-08-03 22:42:35,281 [80-6] DEBUG PoolableSQLConnectionFactory - Initializing SQL config for 'PlanetProjectDB' via JNDI === 2012-08-03 22:42:35,781 [80-3] DEBUG PoolableSQLConnectionFactory - Initializing SQL config for 'PlanetProjectDB' via JNDI === 2012-08-03 22:42:36,082 [80-6] ERROR SQLConnectionManager - Caught exception javax.naming.NameNotFoundException: Name PlanetProjectDB is not bound in this Context at org.apache.naming.NamingContext.lookup(NamingContext.java:770) at org.apache.naming.NamingContext.lookup(NamingContext.java:153) at com.isomorphic.sql.PoolableSQLConnectionFactory.makeUnpooledObject(PoolableSQLConnectionFactory.java:267) at com.isomorphic.sql.PoolableSQLConnectionFactory.makeObject(PoolableSQLConnectionFactory.java:340) at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:76) at com.isomorphic.sql.SQLConnectionManager.getConnection(SQLConnectionManager.java:156) at com.isomorphic.sql.SQLDriver.implementerClassForDB(SQLDriver.java:241) at com.isomorphic.sql.SQLDriver.instance(SQLDriver.java:202) at com.isomorphic.sql.SQLDataSource.init(SQLDataSource.java:173) at com.isomorphic.datasource.DataSource.initialize(DataSource.java:374) at com.isomorphic.datasource.BasicDataSource.fromConfig(BasicDataSource.java:158) at com.isomorphic.datasource.DataSource.fromConfig(DataSource.java:359) at com.isomorphic.datasource.FileSystemDSRepo.loadDS(FileSystemDSRepo.java:110) at com.isomorphic.datasource.DataSource.forName(DataSource.java:178) at com.isomorphic.datasource.DataSource.forName(DataSource.java:170) at com.isomorphic.datasource.DataSource.forName(DataSource.java:165) at com.isomorphic.datasource.PoolableDataSourceFactory.makeUnpooledObject(PoolableDataSourceFactory.java:95) at com.isomorphic.datasource.PoolableDataSourceFactory.makeObject(PoolableDataSourceFactory.java:102) at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:82) at com.isomorphic.datasource.DataSourceManager.getDataSource(DataSourceManager.java:87) at com.isomorphic.datasource.DSRequest.getDataSource(DSRequest.java:1739) at com.isomorphic.rpc.RPCManager.parseRequest(RPCManager.java:1940) at com.isomorphic.rpc.RPCManager.<init>(RPCManager.java:296) at com.isomorphic.rpc.RPCManager.<init>(RPCManager.java:281) at com.isomorphic.rpc.RPCManager.<init>(RPCManager.java:281) at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:116) at com.isomorphic.servlet.IDACall.doPost(IDACall.java:73) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:568) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:856) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:565) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1509) at java.lang.Thread.run(Thread.java:722)
P.S. I am running SmartClient Version: v8.2p_2012-06-08/EVAL Development Only on Mozilla Firefox 3.6.18 with Firebug using Windows XP Pro 32 bit.
Comment