BTW:
I am using the JSQLConnect JDBC driver from Net-Direct at
http://www.j-netdirect.com .
> -----Original Message-----
> From: Frank Villarreal [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 25, 2001 10:36 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Please help! + turbine + ms sql server
>
>
> 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_IP
> ADDRESS_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
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
