Announcement

**Isomorphic** · 17 Jan 2013, 10:22

Please post your server.properties file

**devep1** · 17 Jan 2013, 12:08

Originally posted by Isomorphic View Post

Please post your server.properties file

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__

# Set this to the GWT module name.
gwtModuleName: applicationScaffold

# 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: $gwtModuleName/sc

# administration app
apps.adminConsole.location: $webRoot/applicationScaffold/sc/tools
ui.adminConsole.location: $webRoot/applicationScaffold/sc/tools

# -------------- 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:hsql://localhost/isomorphic

sql.DB2.database.type: db2
sql.DB2.interface.type: driverManager
sql.DB2.driver: com.ibm.db2.jcc.DB2Driver
sql.DB2.driver.url: jdbc:db2://localhost:50000/WS_CRG

# -------------- SETTINGS FOR JPA --------------------

# According to JPA specifications only simple class name can be used in queries.
# Some providers follows these specs strictly (for example EclipseLink).
# Some providers allows using fully-qualified class name usage (for example Hibernate, Datanucleus).
# Setting defaluts to false - simple class name usage.
# To resolve class name collisions this setting can be set to true
# (should be used with provider supporting fully-qualified class name usage).
#jpa.useQualifiedClassName: true

# Default EMF provider implementation (implements EMFProviderInterface).
# Fully qualified class name.
# Existing implementations:
# com.isomorphic.jpa.EMFProviderLMT - for Locally Managed Transactions (LMT)
# com.isomorphic.jpa.EMFProviderNoTransactions - no transactions support
# com.isomorphic.jpa.EMFProviderBMT - for Bean Managed Transactions (BMT)
# com.isomorphic.jpa.EMFProviderCMT - for Container Managed Transactions (CMT)
# com.isomorphic.jpa.EMFProviderSpring - for Spring Framework Managed Transactions (CMT)
jpa.emfProvider: com.isomorphic.jpa.EMFProviderSpring

# Settings for LMT type
# Name of the datasource
jpa.persistenceUnitName: ds

# Resource references for Spring type
# EntityManagerFactory and transaction manager beans declared in Spring Application Context.
# Example declaration:
# <!-- SpringApplicationContextProvider bean definition required to get access to application context. -->
# <bean id="springApplicationContextProvider" class="com.isomorphic.spring.SpringApplicationContextProvider" />
#
# <!-- Connection to data base -->
# <bean id="dataSource"
#       class="org.springframework.jdbc.datasource.DriverManagerDataSource"
#       p:driverClassName="DRIVER_CLASS"
#       p:url="CONNECTION_URL"
#       p:username="DB_USER_NAME"
#       p:password="DB_USER_PASSWORD" />
#
# <!-- Reference to JPA EntityManagerFactory -->
# <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
#     <property name="dataSource" ref="dataSource" />
#     <property name="jpaVendorAdapter">
#         <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
#             <property name="database" value="DB_TYPE" />
#         </bean>
#     </property>
#     <property name="persistenceUnitName" value="PERSISTENCE_UNIT_NAME" />
# </bean>
#
# <!-- Reference to JpaTransactionManager -->
# <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
#     <property name="entityManagerFactory" ref="entityManagerFactory" />
# </bean>
jpa.entityManagerFactory: entityManagerFactory
jpa.transaction: transactionManager

# -------------- 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
project.ui: $webRoot/shared/ui
project.apps: $webRoot/shared/app

# Note: modulesDir is only used with the loadISC and loadModules JSP tags; if
# you intend to use those tags, do not change this setting
modulesDir: modules/

# -------------- 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, xmlToJS, uploadProgressCheck, exportClientData, downloadClientExport, setAttributes
RPCManager.enabledBuiltinMethods: getLogNames

**Isomorphic** · 17 Jan 2013, 13:14

Your database connection settings (those starting "sql.DB2.") do not include credentials; that exception about a missing userid is DB2 rejecting the connection attempt. You'll have to research the correct settings for your JDBC driver and connection type, but as a start point, try adding entries like this:

Code:

sql.DB2.driver.user: myuserid
sql.DB2.driver.password: thepassword

**devep1** · 17 Jan 2013, 14:58

Originally posted by Isomorphic View Post

Your database connection settings (those starting "sql.DB2.") do not include credentials; that exception about a missing userid is DB2 rejecting the connection attempt. You'll have to research the correct settings for your JDBC driver and connection type, but as a start point, try adding entries like this:

Code:

sql.DB2.driver.user: myuserid
sql.DB2.driver.password: thepassword

Found, the correct syntax is:

Code:

sql.DB2.driver.url: jdbc:db2://localhost:50000/DBNAME:user=USERNAME;password=USERPWD;

Thank you.

Announcement

Null userid is not supported.

Comment

Comment

Comment

Comment