Thomas Franz wrote:
>
> Sorry, I can't help you, but you
> may help me ! I guess it would help
> me already if you could provide me with
> your turbine.properties and maybe your
> db script.
>
Here you go Thomas ... this is a snippet from my turbine.properties file...
(also attached is the MSSQLServer 7 script I wrote to create the Turbine
database)...
<snip>
# -------------------------------------------------------------------
#
# D A T A B A S E S E T T I N G S
#
# -------------------------------------------------------------------
# These are your database settings. Look in the
# org.apache.turbine.util.db.pool.* packages for more information.
# The default driver for Turbine is for MySQL.
#
# The parameters to connect to the default database. You MUST
# configure these properly.
# -------------------------------------------------------------------
database.default.driver=com.jnetdirect.jsql.JSQLDriver
database.default.url=jdbc:JSQLConnect://YOUR_DATABASESERVER_IPADDRESS_GOES_H
ERE/database=TURBINE&user=myusername
database.default.username=myusername
database.default.password=mypassword
# The number of database connections to cache per ConnectionPool
# instance.
database.maxConnections=3
# The amount of time (in milliseconds) a connection request will have to
wait
# before a time out occurs and an error is thrown.
#
# Default: ten seconds = 10 * 1000
database.connectionWaitTimeout=10000
# The amount of time (in milliseconds) that database connections will be
# cached.
#
# Default: one hour = 60 * 60 * 1000
database.expiryTime=3600000
# The interval (in milliseconds) between which the PoolBrokerService logs
# the status of it's ConnectionPools.
#
# Default: No logging = 0 = 0 * 1000
database.logInterval=0
# These are the supported JDBC drivers and their associated Turbine
# adaptor. These properties are used by the DBFactory. You can add
# all the drivers you want here.
database.adaptor=DBMSSQL
database.adaptor.DBMSSQL=com.jnetdirect.jsql.JSQLDriver
#
# Determines if the quantity column of the IDBroker's id_table should
# be increased automatically if requests for ids reaches a high
# volume.
database.idbroker.cleverquantity=true
</snip>
- Frank
turbine-mssqlserver.sql
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
