[C2] ESQL: How to find the id of the last inserted record?

2001-07-26 Thread Rune Sandnes
I'm inserting records into a database table using ESQL, the database has a primary id with autoincrement. I need to find the newly created id of the new record, is there a way to do this on MSSQL2000 from ESQL? (Doing a select on max(id) won't do because of the possiblity of race conditions.)

SV: Repost of JDBC ODBC problem

2001-07-31 Thread Rune Sandnes
From: Berin Loritsch [mailto:[EMAIL PROTECTED]] If you are trying to connect to MS SQL Server, there are a number of third party JDBC drivers that I would highly recommend you use. Any partical JDBC drivers you would recommend? We have tried Merant's driver, which works nicely, but seems a

Problem with C2 memory usage

2001-09-02 Thread Rune Sandnes
We have some problems with memory usage in Cocoon2b2 on Windows 2000 with IIS and Tomcat 3.2.3. Everything works fine for a while, but after a number of accesses the amount of memory Cocoon uses grows really big (e.g. 180MB) and things work slower and slower. We have to restart tomcat to get

RE: WebSphere/Cocoon Gurus - Help!!!!

2001-09-17 Thread Rune Sandnes
Has anyone of you tried Cocoon 2 on WebSphere? It could be interesting for us... Rune, Trondheim, Norway - Please check that your question has not already been answered in the FAQ before posting.

Corrocean.com - new Cocoon 2 site ready for the live site list

2001-11-19 Thread Rune Sandnes
We just finished a large site for a customer in the offshore industry, you can find it at www.corrocean.com. This is a Cocoon 2 site, using rc1, we were hoping for a Cocoon2 final release before our own, but rc1 works nicely so far. Please add this to the live sites list. There doesn't seem to

RE: Corrocean.com - new Cocoon 2 site ready for the live site list

2001-11-20 Thread Rune Sandnes
Fra: Alex Kachanov [mailto:[EMAIL PROTECTED]] Looks impressive How many hits you have? How high is the load? How powerful is the machine? They get maybe 400-500 sessions a day, with approx 10-30 pageviews per session. It's not that many visitors, it's a fairly narrow business field, We

Specifying XSL sheet for client side translation in XSP?

2001-12-28 Thread Rune Sandnes
I have gotten the browser-detection features to work with Cocoon 2, I plan to serve raw XML and XSL to users of Explorer 6, so they can do the XSL-transformation client-side, Cocoon will do the transformation for other browsers. My sitemap looks like this, and it works nicely for static files:

SV: Specifying XSL sheet for client side translation in XSP?

2002-01-08 Thread Rune Sandnes
I solved a similiar problem using a XSL stylesheet which only puts a xml:stylesheet processing instructing in the resulting XML-Stream before it is send to the browser. Thank you for the tip, but I wonder if this will actually help in reducing the load on the server? Is there a noticable

C2 caching of XSP?

2002-02-22 Thread Rune Sandnes
I'm a bit nervous for our rollout of a site with anticipated high volume using C2. I'm not sure the caching system will help us, at least not what I have looked at so far. Our pipeline is like this: map:match pattern=*/*/ map:generate type=serverpages src=contentgen.xsp

[C2] XSPCookieHelper does not set domain?

2002-03-05 Thread Rune Sandnes
called adduser/ then that would be the name of the cookies domain. Example: XSPCookieHelper.addCookie(objectModel, testname, testvalue, comment, www.servername.com, 10 * 365 * 24 * 60 * 60, , , 1); Regards, Rune Sandnes, Trondheim, Norway

RE: [C2] DeltaTimeCacheValidity?

2002-03-27 Thread Rune Sandnes
public CacheValidity generateValidity() { return new TimeStampCacheValidity(documentTimestamp); } or public CacheValidity generateValidity() { return new DeltaTimeCacheValidity(10); } If I am not mistaken, the ESQL statements will be

Destroying cached object

2002-04-14 Thread Rune Sandnes
I have looked at various methods of deciding when a cached object is no longer valid (including DBPrism cache invalidator suggested by Marcelo Ochoa) What I really want to do is simple, cache all pages for 30 minutes with DeltaTimeCacheValidity, but be able to destroy the cache from the

Livesites

2002-05-06 Thread Rune Sandnes
Another live site you can add to the Cocoon 2 livesites list: TINE, the largest Norwegian dairy company is at http://www.tine.no/ The site is mostly in Norwegian, but has an international section. (TINE is the company that makes Jarlsberg cheese) It runs on Cocoon 2.0.2 under Websphere, and