Return-Path: 
 <cocoon-users-return-19615-apmail-xml-cocoon-users-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org
Received: (qmail 27150 invoked by uid 500); 22 May 2001 09:08:39 -0000
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:cocoon-users-help@xml.apache.org>
list-unsubscribe: <mailto:cocoon-users-unsubscribe@xml.apache.org>
list-post: <mailto:cocoon-users@xml.apache.org>
Reply-To: cocoon-users@xml.apache.org
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 27111 invoked from network); 22 May 2001 09:08:33 -0000
Message-ID: <3B0A2CFC.7080400@hargre.fsnet.co.uk>
Date: Tue, 22 May 2001 10:10:20 +0100
From: Peter Hargreaves <pd@hargre.fsnet.co.uk>
User-Agent: Mozilla/5.0 (Windows; U; WinNT4.0; en-US;
 m18) Gecko/20010131 Netscape6/6.01
X-Accept-Language: en
MIME-Version: 1.0
To: cocoon-users@xml.apache.org
Subject: Re: C2 Installation Probs - cocoondb.properties
References: <011501c0e21b$783afce0$0200a8c0@fuckup>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Spam-Rating: h31.sny.collab.net 1.6.2 0/1000/N

Hi Peter,

Peter Nuetzel - inglobo wrote:

> Hi again,
> 
> I think the problem with the SQLConnection isn't related to the SVG
> examples.

I agree it seems to be stopping several things from working properly. I 
get the same messages when attempting any sub-sitemap examples.

> I've updated Cocoon2 on friday and the SVG examples also dont work - I only
> get broken image links shown in my browser.

The broken links could be because your browser can not handle SVG. I use 
Netscape 6 to view my SVG. At the moment I get a broken link when viewed 
with MSIE5 or Netscape4.7 When I view with Netscape 6 I get an SVG image 
which just describes the URL. I had SVG working on a previous download 
of C2.

> But no exceptions in my
> cocoon.log file.

Maybe SVG is broken in other ways - for both of us.

> I think I also experienced this connection problem you described with
> earlier versions of C2.
> Stop your servlet engine and edit cocoondb.properties. If the value of the
> 'modified' property is 'yes' set it to 'no' an start your server again.
> modified=no

I'm already set to modified=no but have just tried yes with no 
impovement! In doing this I noticed that my cocoondb.* files are all 
read only - so I've made them all writeable. It has helped - my simple 
SQL and Sample Forms now work again. But I still get the same error 
messages in cocoon.log

> That solved this problem in my environment. I think this is a HSQL related
> problem.

Or is is an Avalon problem? As you can see, the first error is now 
reported as a cocoondb.backup problem. I think I'll put my problem out 
again under an new heading.

Many thanks for your help.

> - peter
> 
> -----Urspr�ngliche Nachricht-----
> Von: Peter Hargreaves <pd@hargre.fsnet.co.uk>
> An: cocoon-users@xml.apache.org <cocoon-users@xml.apache.org>
> Datum: Montag, 21. Mai 2001 18:31
> Betreff: Re: C2 Installation Probs - cocoondb.properties
> 
> 
>> Hi Peter,
>> 
>> Many thanks for the advice, things are much better now, many of the
>> examples are working! However, some are still not functioning and the
>> problem seems to be related to the last one. For instance, non of the
>> svg examples are working.
>> 
>> This time in my cocoon.log I get the following:
>> 
>> DEBUG   11036   [cocoon  ] (Thread-25):
>> org.apache.avalon.excalibur.datasource.JdbcConnection: could not be
>> instantiated.
>> java.sql.SQLException: File input/output error:
>> j:/jakarta-tomcat-3.2.1/webapps/cocoon/WEB-INF/db/cocoondb.backup
>>   at org.hsqldb.Trace.getError(Trace.java:180)
>>   at org.hsqldb.Trace.getError(Trace.java:144)
>>   at org.hsqldb.Trace.error(Trace.java:205)
>>   at org.hsqldb.Log.restoreBackup(Log.java, Compiled Code)
>>   at org.hsqldb.Log.open(Log.java:203)
>>   at org.hsqldb.Database.<init>(Database.java:96)
>>   at org.hsqldb.jdbcConnection.openStandalone(jdbcConnection.java:926)
>>   at org.hsqldb.jdbcConnection.<init>(jdbcConnection.java:682)
>>   at org.hsqldb.jdbcDriver.connect(jdbcDriver.java:116)
>>   at java.sql.DriverManager.getConnection(DriverManager.java:457)
>>   at java.sql.DriverManager.getConnection(DriverManager.java:137)
>>   at
>> org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(J
> 
> dbcConnectionFactory.java:56)
> 
>>   at
>> org.apache.avalon.excalibur.pool.AbstractPool.newPoolable(AbstractPool.jav
> 
> a,
> 
>> Compiled Code)
>>   at
>> org.apache.avalon.excalibur.pool.HardResourceLimitingPool.newPoolable(Hard
> 
> ResourceLimitingPool.java:87)
> 
>>   at
>> org.apache.avalon.excalibur.datasource.JdbcConnectionPool.newPoolable(Jdbc
> 
> ConnectionPool.java:54)
> 
>>   at
>> org.apache.avalon.excalibur.pool.SoftResourceLimitingPool.grow(SoftResourc
> 
> eLimitingPool.java,
> 
>> Compiled Code)
>>   at
>> org.apache.avalon.excalibur.datasource.JdbcConnectionPool.run(JdbcConnecti
> 
> onPool.java:119)
> 
>>   at java.lang.Thread.run(Thread.java:479)
>> 
>> Further down the cocoon.log I get the following:
>> 
>> DEBUG   14191   [cocoon  ] (Thread-25):
>> org.apache.avalon.excalibur.datasource.JdbcConnection: could not be
>> instantiated.
>> java.sql.SQLException: The database is already in use by another process
>>   at org.hsqldb.Trace.getError(Trace.java:180)
>>   at org.hsqldb.Trace.getError(Trace.java:144)
>>   at org.hsqldb.Trace.error(Trace.java:192)
>>   at org.hsqldb.Log.open(Log.java:199)
>>   at org.hsqldb.Database.<init>(Database.java:96)
>>   at org.hsqldb.jdbcConnection.openStandalone(jdbcConnection.java:926)
>>   at org.hsqldb.jdbcConnection.<init>(jdbcConnection.java:682)
>>   at org.hsqldb.jdbcDriver.connect(jdbcDriver.java:116)
>>   at java.sql.DriverManager.getConnection(DriverManager.java:457)
>>   at java.sql.DriverManager.getConnection(DriverManager.java:137)
>>   at
>> org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(J
> 
> dbcConnectionFactory.java:56)
> 
>>   at
>> org.apache.avalon.excalibur.pool.AbstractPool.newPoolable(AbstractPool.jav
> 
> a,
> 
>> Compiled Code)
>>   at
>> org.apache.avalon.excalibur.pool.HardResourceLimitingPool.newPoolable(Hard
> 
> ResourceLimitingPool.java:87)
> 
>>   at
>> org.apache.avalon.excalibur.datasource.JdbcConnectionPool.newPoolable(Jdbc
> 
> ConnectionPool.java:54)
> 
>>   at
>> org.apache.avalon.excalibur.pool.SoftResourceLimitingPool.grow(SoftResourc
> 
> eLimitingPool.java,
> 
>> Compiled Code)
>>   at
>> org.apache.avalon.excalibur.datasource.JdbcConnectionPool.run(JdbcConnecti
> 
> onPool.java:119)
> 
>>   at java.lang.Thread.run(Thread.java:479)
>> 
>> Again, many thanks to anyone who can spare a moment to help me.
>> 
>> Regards,
>> Peter.
>> 
>> Peter Nuetzel - inglobo wrote:
>> 
>>>> Hi Folks,
>>> 
>>> 
>>> Hi Peter,
>>> 
>>>> Could someone help please?
>>>> 
>>>> Following installation of 2.0a6 I can see the Welcome page but many of
>>>> the examples do not work. When the Welcome page is first loaded I get
>>>> the following message in my cocoon.log
>>>> 
>>>> WARN    521     [cocoon  ] (Thread-10): Could not force-load class:
>>>> com.ibm.servlet.classloader.Handler
>>>> 
>>>> I don't think this one is important but it might be. Further down I get
>>>> the messagethat I think is the problem, as follows:
>>>> 
>>> this is only needed for the IBM websphere server - you can disable the
>>> loading of that class in the web.xml file of the cocoon webapp.
>>> 
>>>> DEBUG   4737    [cocoon  ] (Thread-25):
>>>> org.apache.avalon.excalibur.datasource.JdbcConnection: could not be
>>>> instantiated.
>>>> java.sql.SQLException: File input/output error:
>>>> ${install.war}/cocoon/WEB-INF/db/cocoondb.properties
>>> 
>>> 
>>> </snip>
>>> 
>>> you also may edit cocoon.xconf to replace ${install.war} with your
>> 
> absolute
> 
>>> path to your servlet engines webapp directory. I think this can be also
>>> done automatically via the build file (or an environment variable?), but
>>> never tried it.
>>> 
>>>> I've had a good look through the mail archives and can't quite suss it.
>>>> 
>>>> Many thanks to anyone who has the time to help.
>>>> Peter.
>>>> 
>>> 
>>> de nada - peter
>>> 
>>> 
>>> 
>>> ---------------------------------------------------------------------
>>> Please check that your question has not already been answered in the
>>> FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
>>> 
>>> To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
>>> For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
>>> 
>>> 
>>> 
>>> 
>> 
>> ---------------------------------------------------------------------
>> Please check that your question has not already been answered in the
>> FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
>> 
>> To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
>> For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
>> 
> 
> 
> 
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
> 
> To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
> 
> 
> 
> 


---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>