License Number Configuration |
Property |
Description |
Default value |
shop.License |
The
ExperShop commercial license number (Optional).
If no commercial license number is specified, ExperShop will display
a popup window with an ad banner for ExperLog upon each new
session.
There is no other license restriction: you may use ExperShop for
free, but it will advertise for us.
ExperShop commercial licenses are sold online on experlog's web site
(http://www.experlog.com).
|
none |
JDBC Configuration |
Property |
Description |
Default value |
jdbc.Driver |
The
JDBC Driver class |
org.enhydra.instantdb.jdbc.idbDriver |
jdbc.Url |
The
JDBC URL |
jdbc:idb:c:\\ExperSHOP\\shops\\lite\\lite.prp (Windows),
jdbc:idb:/usr/local/ExperSHOP/shops/lite/lite.prp (Unix) |
jdbc.User |
The
database user name |
empty
string |
jdbc.Password |
The
database password |
empty
string |
jdbc.MaxConn |
The
database max number of connections |
10 |
jdbc.MinConn |
The
database min number of connections |
5 |
jdbc.Multiplex |
Number of virtual connection
on the same physical connection.
Example:
jdbc.MaxConn: 4
jdbc.Multiplex: 2
means 8 minimum available connections for the application.
|
1 |
jdbc.ReconnectOnError |
Values: true or false.
If true, tells the connection pool to reopen database connections
upon errors (including SQL errors). |
false |
jdbc.cacheRS |
Cache
JDBC ResultSet columns: true, or false.
This option should be set to true only when necessary, and if you
don't trust your JDBC driver (some JDBC drivers, particularly when
using ODBC, don't allow to access twice the same column in a tuple
: this is an implementation bug). |
false |
jdbc.threadSafe |
Tell
ExperShop if your JDBC driver is thread-safe or not: for example,
the JDBC/ODBC bridge with the Microsoft Access ODBC driver is not
thread safe, the Oracle thin JDBC driver is thread-safe.
Set this field to false only if necessary, because of its impact on
the overall performance. |
true |
jdbc.PreOpen |
Used
as a workaround for a bug with some JVMs / JDBC drivers: before 1st
use, the connection is opened then closed. This may cause problems
with some drivers, use only if necessary. |
false |
jdbc.Cart |
The class which manages the
cart client |
com.expershop.shop.ESCart |
jdbc.Client |
The class which manages the client |
com.expershop.base.ESClient |
jdbc.ConnectionPool |
The class which manages the pool
of jdbc connections |
com.expershop.db.ESConnectionPool |
sqlencode.Substitutions |
A list
of substitutions to be made when using (SqlEncode): for example,
a single quote must be duplicated in an Oracle request ("I'm here"
becomes "I''m here"), and replaced by "\'" in an InstantDB request
("I'm here" becomes "I\'m here").
The syntax of sqlencode.Substitutions is:
c1=s1;c2=s2;...cn=sn (replace char c1 with string s1, char c2 with
string s2, etc...)
The suggested value for Oracle is: \'=\'\';\r=\" \";\n=\" \"; |
\'=\\\';\r=\"
\";\n=\" \"; |
SHOP
Configuration |
Property |
Description |
Default
value |
shop.AdminPassword |
The
shop administrator password |
admin |
shop.RootDir |
The
shop's Root directory |
empty
string |
shop.HomePage |
The
shop's home page (relative to the shop's Root directory) |
EShop.tmpl |
shop.Currency |
The
currency unit |
USD |
shop.tax.defaultzone |
The
default zone name for value added tax calculation |
none |
shop.tax.[zone-name].rate |
The
value added tax rate for a given tax zone |
none |
shop.tax.[zone-name].taxincluded |
Tells
wether product prices already include taxes or not (values: true
or false). |
false
(tax are not included). |
shop.tax.[zone-name].includeshipping |
Tells
if taxes should apply on shipping costs just like on products (values
: true or false). |
true
: taxes apply on shipping costs. |
shop.shippingcost.defaultzone |
The
default zone name for shipping cost calculation |
none |
shop.shippingcost.[zone-name].rate |
The
shipping cost rate for a given shipping cost zone |
none |
shop.shippingcost.[zone-name].type |
The
shipping cost type for a given shipping cost zone.
Type should be one of:
- FLAT
(the zone's rate is the shipping cost value)
- QTY
(the shipping cost value is equal to the zone rate multiplied
by the number of items in the cart)
- WEIGHT
(the shipping cost value is equal to the zone rate multiplied
by the weight of all items in the cart)
- PRICE
(the shipping cost value is equal to the zone rate multiplied
by the total price of items in the cart, tax not included)
|
none |
shop.NeedPassword |
A boolean
flag (true or false): if true, customers will require to type their
password at login time, and the password will be checked; if false,
passwords won't be enforced |
false |
shop.Timeout |
The
remote client session inactivity timeout in seconds |
3600 |
shop.Locale |
The application's locale: used for number and date formats.
The locale's syntax is the same as the syntax specified for java
locales: Language_Country[_Variant]
For example, en_US for US english, fr_FR for french. |
None (use the system's locale) |
Order
Confirmation |
Property |
Description |
Default
value |
email.MailHost |
Mail
Host name or IP address |
none |
email.From |
Shop's
email address (will be put in the "From" part of the message) |
none |
email.ManagerEmail |
Shop
Manager's email address (if order confirmations must be sent to the
shop owner, for example) |
none |
email.ManagerSubject |
Email
subject for the shop manager's order confirmations |
New
Order |
email.ManagerTemplate |
A path
to a template file that will be expanded to produce an e-mail sent
to the shop manager when a customer places an order; The path is relative
to the shop.ESRootDir value |
none |
email.CustomerSubject |
Email
subject for the customer's order confirmations |
Your
Order |
email.CustomerTemplate |
A path
to a template file that will be expanded to produce an order confirmation
e-mail sent to the customer; The path is relative to the shop.ESRootDir
value |
none |
log.Logfile |
A path
to an ASCII file that will contain an order log (all orders will be
logged there); The path is relative to the shop.ESRootDir value |
none |
log.Template |
A path
to a template file that will be expanded to produce an ASCII order
log; The path is relative to the shop.ESRootDir value |
none |
Secure Payment: see the corresponding documentation |
Property |
Description |
Default value |
shop.keepPreOrders |
Possible values: true (keep pre-orders upon session timeout) or
false (delete pre-orders upon session timeout).
Some secure payment technologies are asynchronous: ExperShop lets
the bank's site operate the payment, then the bank tells ExperShop
when the transaction is over.
For those payment systems, ExperShop "pre-orders" the shopping cart
content (the order is saved in a "PREORDER" state), and 2 strategies
are possible:
- By default, if the bank never returns any transaction status,
orders in "PREORDER" status are destroyed upon session timeout
(see shop.Timeout).
- if "shop.keepPreOrders" is set to "true", orders in "PREORDER"
status are kept in a "TIMEOUT" status upon session timeout -
this may be useful to prevent transaction errors due to network
incidents or bank server crash.
|
false: pre-orders are destroyed upon session timeout. |
pay.cych.Url |
An URL
to a CyberCash MCK cgi directory (for CyberCash secure
payment only) |
empty
string |
Miscellaneous
Configuration |
Property |
Description |
Default
value |
trace.level |
trace level:
0 : Servlet
1 : Client
2 : Store
3 : Product
4 : Order
5 : Department
6 : Customer
7 : Cart
8 : Pay
9 : Dyn
10 : Bulk
11 : Db
12 : Pool
13 : Timer
31 : Warnings
all : all traces
e.g. : 0,1,5,9,31
|
31 |
trace.logwriter |
class which manages the LogWriter object
du shop. |
com.expershop.util.LogWriter |
trace.file |
traces output file,
if the file is not set, all trace will be logged on the error stream (error_log under Apache) |
/tmp/shop.trc |
trace.header |
Property to add header in front of all
the traces (thread + date) |
false |
trace.tempo |
Temporisation permettant de ralentir
les traces (uniquement pour systèmes lents) |
0 |
console.applicationoff |
error template when the application
an error occurs ou when the application is stopped.
|
aucun |