You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Johnson <jo...@soho.club.tw> on 2004/02/21 08:52:26 UTC
Can not get Connection from DataSource named //192.168.10.1:5432/test
I'm trying to bind the ojb-jdo example to postgresql
when open the page,it show me Cannot get Connection from DataSource named //192.168.10.1:5432/test
below is my repository.xml
<descriptor-repository version="1.0" isolation-level="read-uncommitted">
<jdbc-connection-descriptor jcd-alias="test" default-connection="true" platform="PostgreSQL" jdbc-level="3.0" driver="org.postgresql.Driver" protocol="jdbc" subprotocol="postgresql" dbalias="//192.168.10.1:5432/test" username="postgres" password="" eager-release="false" batch-mode="false" useAutoCommit="1" ignoreAutoCommitExceptions="false">
<connection-pool maxActive="21" validationQuery=""/>
<sequence-manager className="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl">
<attribute attribute-name="autoNaming" attribute-value="true"/>
<attribute attribute-name="grabSize" attribute-value="20"/>
<attribute attribute-name="globalSequenceId" attribute-value="false"/>
<attribute attribute-name="globalSequenceStart" attribute-value="10000"/>
</sequence-manager>
</jdbc-connection-descriptor>
<class-descriptor class="com.goodwill.bean.Registration" table="REGISTRATION">
<field-descriptor name="id" primarykey="true" default-fetch="true" autoincrement="true" sequence-name="user_seq'::text" column="ID" jdbc-type="INTEGER"/>
<field-descriptor name="name" nullable="false" default-fetch="true" column="NAME" jdbc-type="VARCHAR"/>
<field-descriptor name="email" nullable="false" default-fetch="true" column="EMAIL" jdbc-type="VARCHAR"/>
<field-descriptor name="age" default-fetch="true" column="AGE" jdbc-type="INTEGER"/>
<field-descriptor name="password" nullable="false" default-fetch="true" column="PASSWORD" jdbc-type="VARCHAR"/>
</class-descriptor>
</descriptor-repository>
and this is cocoon.xconf about jdbc
<jdbc logger="core.datasources.test" name="test">
<pool-controller max="10" min="5"/>
<dburl>jdbc:postgres://192.168.10.1:5432/test</dburl>
<user>postgres</user>
<password/>
</jdbc>
can anyone point what's wrong
Best Regards
Johnson
Re: Can not get Connection from DataSource named //192.168.10.1:5432/test
Posted by Johnson <jo...@soho.club.tw>.
the detail error message is
Original Exception: org.apache.ojb.broker.PersistenceBrokerException: Cannot
get Connection from DataSource named //192.168.10.1:5432/test
at
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.localBegin(Connectio
nManagerImpl.java:193)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.beginTransaction(Persistenc
eBrokerImpl.java:382)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.beginTransaction(Dele
gatingPersistenceBroker.java:129)
at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.beginTransaction(Dele
gatingPersistenceBroker.java:129)
at
org.apache.ojb.jdori.sql.OjbStoreConnector.begin(OjbStoreConnector.java:116)
at com.sun.jdori.common.TransactionImpl.beginInternal(Unknown Source)
at com.sun.jdori.common.TransactionImpl.begin(Unknown Source)
at com.goodwill.RegistrationDAO.retrieve(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:230)
at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1244)
at
org.mozilla.javascript.continuations.ContinuationInterpreter.interpret(Conti
nuationInterpreter.java:1105)
at
org.mozilla.javascript.continuations.ContinuationInterpreter.interpret(Conti
nuationInterpreter.java:190)
at
org.mozilla.javascript.continuations.ContinuationInterpreter.interpret(Conti
nuationInterpreter.java:138)
at
org.mozilla.javascript.continuations.InterpretedFunctionImpl.call(Interprete
dFunctionImpl.java:121)
at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1244)
at
org.apache.cocoon.components.flow.javascript.fom.FOM_JavaScriptInterpreter.c
allFunction(FOM_JavaScriptInterpreter.java:719)
at
org.apache.cocoon.components.treeprocessor.sitemap.CallFunctionNode.invoke(C
allFunctionNode.java:160)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:84)
at
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invok
e(PreparableMatchNode.java:165)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:107)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipel
ineNode.java:162)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:107)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pipe
linesNode.java:136)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:371)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:312)
at
org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNod
e.java:133)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:84)
at
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.invok
e(PreparableMatchNode.java:165)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:107)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(Pipel
ineNode.java:162)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invo
keNodes(AbstractParentProcessingNode.java:107)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(Pipe
linesNode.java:136)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:371)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcess
or.java:312)
at org.apache.cocoon.Cocoon.process(Cocoon.java:656)
at
org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1112)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:284)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:204)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:257)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex
t.java:151)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContext
Valve.java:245)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:199)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex
t.java:151)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:195
)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex
t.java:151)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164
)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex
t.java:149)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:156)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContex
t.java:151)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:700)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:683)
at java.lang.Thread.run(Thread.java:534)
Caused by: org.apache.ojb.broker.accesslayer.LookupException: Cannot get
Connection from DataSource named //192.168.10.1:5432/test
at
org.apache.cocoon.ojb.components.ConnectionFactoryAvalonDataSource.lookupCon
nection(ConnectionFactoryAvalonDataSource.java:119)
at
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.getConnection(Connec
tionManagerImpl.java:144)
at
org.apache.ojb.broker.accesslayer.ConnectionManagerImpl.localBegin(Connectio
nManagerImpl.java:186)
... 64 more
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at
org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(Jdb
cConnectionFactory.java:185)
at
org.apache.avalon.excalibur.pool.ResourceLimitingPool.newPoolable(ResourceLi
mitingPool.java:672)
at
org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolable(V
alidatedResourceLimitingPool.java:178)
at
org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.ne
wPoolable(ResourceLimitingJdbcConnectionPool.java:123)
at
org.apache.avalon.excalibur.pool.ResourceLimitingPool.get(ResourceLimitingPo
ol.java:402)
at
org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(Validated
ResourceLimitingPool.java:130)
at
org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getCon
nection(ResourceLimitingJdbcDataSource.java:222)
at
org.apache.cocoon.ojb.components.ConnectionFactoryAvalonDataSource.lookupCon
nection(ConnectionFactoryAvalonDataSource.java:115)
... 66 more
----- Original Message -----
From: "Antonio Gallardo" <ag...@agssa.net>
To: <us...@cocoon.apache.org>
Sent: Saturday, February 21, 2004 4:06 PM
Subject: Re: Can not get Connection from DataSource named
//192.168.10.1:5432/test
> Hi:
>
> Are you tried to make a connection using JDBC outside Cocoon?
>
> An easy application I often use is Squirrel SQL -
> http://squirrel-sql.sourceforge.net/
>
> BTW, can you post the error you got?
>
> Best Regards,
>
> Antonio Gallardo
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource
Posted by Johnson <jo...@soho.club.tw>.
the same pls see
"file:/jakarta-tomcat-5.0.18/webapps/cocoon/test/flow/registration.js", line
8: uncaught JavaScript exception: at registration
(file:/jakarta-tomcat-5.0.18/webapps/cocoon/test/flow/registration.js, Line
8): org.apache.ojb.broker.PersistenceBrokerException: Cannot get Connection
from DataSource named postgres://127.0.0.1:5432/test
org.apache.avalon.framework.CascadingRuntimeException:
"file:/jakarta-tomcat-5.0.18/webapps/cocoon/test/flow/registration.js", line
8: uncaught JavaScript exception: at registration
(file:/jakarta-tomcat-5.0.18/webapps/cocoon/test/flow/registration.js, Line
8): org.apache.ojb.broker.PersistenceBrokerException: Cannot get Connection
from DataSource named postgres://127.0.0.1:5432/test
best regards
johnson
ps.the server has two nics. one is 192.168.10.1,another 192.168.10.252
----- Original Message -----
From: "Antonio Gallardo" <ag...@agssa.net>
To: <us...@cocoon.apache.org>
Sent: Saturday, February 21, 2004 5:58 PM
Subject: Re: Can not get Connection from DataSource
> Johnson dijo:
>
> Are you tried to connect to 127.0.0.1 instead of 192.168.10.1? Perhaps in
> 192.168.10.1 the 5432 port not open or postgreSQL does not allow connect
> to this port.
>
> If you are planning to deploy your DB Server in the same machine as
> Tomcat, I will recommend you to use 127.0.0.1 address instead of
> 192.168.10.1. If not you will need to reconfigure the IP address each time
> you will deploy your app (fresh install or an update).
>
> Best Regards,
>
> Antonio Gallardo
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource
Posted by Johnson <jo...@soho.club.tw>.
another message from catalina.out
[JDO] DEBUG: OjbStoreConnector.begin: connectionReadyForRelease=false
what's it.
Best Regards
----- Original Message -----
From: "Antonio Gallardo" <ag...@agssa.net>
To: <us...@cocoon.apache.org>
Sent: Saturday, February 21, 2004 6:24 PM
Subject: Re: Can not get Connection from DataSource
> Johnson dijo:
> > I found the chane of dbalias don't affect the result if the jcd-alias is
> > define in cocoon.xconf.
>
> Yep. I noted this. You can remove the cocoon.xconf connection. Also try to
> avoid the same name for both in repository.xml and cocoon.xconf. See the
> sample in more detail.
>
> Best Regards,
>
> Antonio Gallardo
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource
Posted by Johnson <jo...@soho.club.tw>.
If I delete the connection in cocoon.xconf "Cannot lookup DataSources named"
appear
----- Original Message -----
From: "Antonio Gallardo" <ag...@agssa.net>
To: <us...@cocoon.apache.org>
Sent: Saturday, February 21, 2004 6:24 PM
Subject: Re: Can not get Connection from DataSource
> Johnson dijo:
> > I found the chane of dbalias don't affect the result if the jcd-alias is
> > define in cocoon.xconf.
>
> Yep. I noted this. You can remove the cocoon.xconf connection. Also try to
> avoid the same name for both in repository.xml and cocoon.xconf. See the
> sample in more detail.
>
> Best Regards,
>
> Antonio Gallardo
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource
Posted by Johnson <jo...@soho.club.tw>.
If jcd-alias not the same to cocoon.xconf,the name lookup fail
Best Regards
----- Original Message -----
From: "Antonio Gallardo" <ag...@agssa.net>
To: <us...@cocoon.apache.org>
Sent: Saturday, February 21, 2004 6:24 PM
Subject: Re: Can not get Connection from DataSource
> Johnson dijo:
> > I found the chane of dbalias don't affect the result if the jcd-alias is
> > define in cocoon.xconf.
>
> Yep. I noted this. You can remove the cocoon.xconf connection. Also try to
> avoid the same name for both in repository.xml and cocoon.xconf. See the
> sample in more detail.
>
> Best Regards,
>
> Antonio Gallardo
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource
Posted by Johnson <jo...@soho.club.tw>.
how fool I'm
just write wrong db-url in cocoon.xconf
must be postgresql
I wrote to postgres
ths for your help
Johnson
----- Original Message -----
From: "Antonio Gallardo" <ag...@agssa.net>
To: <us...@cocoon.apache.org>
Sent: Saturday, February 21, 2004 8:45 PM
Subject: Re: Can not get Connection from DataSource
> Johnson dijo:
> > I use tomcat 4.1.30 the same?
>
> Tomcat 4.1.30 or Tomcat 4.1.29.
>
> Also just to be sure. Did you have the posgresql JDBC driver in
WEB-APP/lib?
>
> Best Regards,
>
> Antonio Gallardo
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource
Posted by Johnson <jo...@soho.club.tw>.
1.4.1.30
2.yes I have
----- Original Message -----
From: "Antonio Gallardo" <ag...@agssa.net>
To: <us...@cocoon.apache.org>
Sent: Saturday, February 21, 2004 8:45 PM
Subject: Re: Can not get Connection from DataSource
> Johnson dijo:
> > I use tomcat 4.1.30 the same?
>
> Tomcat 4.1.30 or Tomcat 4.1.29.
>
> Also just to be sure. Did you have the posgresql JDBC driver in
WEB-APP/lib?
>
> Best Regards,
>
> Antonio Gallardo
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource
Posted by Antonio Gallardo <ag...@agssa.net>.
Johnson dijo:
> I use tomcat 4.1.30 the same?
Tomcat 4.1.30 or Tomcat 4.1.29.
Also just to be sure. Did you have the posgresql JDBC driver in WEB-APP/lib?
Best Regards,
Antonio Gallardo
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource
Posted by Johnson <jo...@soho.club.tw>.
I use tomcat 4.1.30 the same
----- Original Message -----
From: "Antonio Gallardo" <ag...@agssa.net>
To: <us...@cocoon.apache.org>
Sent: Saturday, February 21, 2004 6:24 PM
Subject: Re: Can not get Connection from DataSource
> Johnson dijo:
> > I found the chane of dbalias don't affect the result if the jcd-alias is
> > define in cocoon.xconf.
>
> Yep. I noted this. You can remove the cocoon.xconf connection. Also try to
> avoid the same name for both in repository.xml and cocoon.xconf. See the
> sample in more detail.
>
> Best Regards,
>
> Antonio Gallardo
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource
Posted by Antonio Gallardo <ag...@agssa.net>.
Johnson dijo:
> I found the chane of dbalias don't affect the result if the jcd-alias is
> define in cocoon.xconf.
Yep. I noted this. You can remove the cocoon.xconf connection. Also try to
avoid the same name for both in repository.xml and cocoon.xconf. See the
sample in more detail.
Best Regards,
Antonio Gallardo
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource
Posted by Johnson <jo...@soho.club.tw>.
I found the chane of dbalias don't affect the result if the jcd-alias is
define in cocoon.xconf.
----- Original Message -----
From: "Antonio Gallardo" <ag...@agssa.net>
To: <us...@cocoon.apache.org>
Sent: Saturday, February 21, 2004 5:58 PM
Subject: Re: Can not get Connection from DataSource
> Johnson dijo:
>
> Are you tried to connect to 127.0.0.1 instead of 192.168.10.1? Perhaps in
> 192.168.10.1 the 5432 port not open or postgreSQL does not allow connect
> to this port.
>
> If you are planning to deploy your DB Server in the same machine as
> Tomcat, I will recommend you to use 127.0.0.1 address instead of
> 192.168.10.1. If not you will need to reconfigure the IP address each time
> you will deploy your app (fresh install or an update).
>
> Best Regards,
>
> Antonio Gallardo
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource
Posted by Antonio Gallardo <ag...@agssa.net>.
Johnson dijo:
Are you tried to connect to 127.0.0.1 instead of 192.168.10.1? Perhaps in
192.168.10.1 the 5432 port not open or postgreSQL does not allow connect
to this port.
If you are planning to deploy your DB Server in the same machine as
Tomcat, I will recommend you to use 127.0.0.1 address instead of
192.168.10.1. If not you will need to reconfigure the IP address each time
you will deploy your app (fresh install or an update).
Best Regards,
Antonio Gallardo
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource
Posted by Johnson <jo...@soho.club.tw>.
the server is linux with cocoon 2.1.4 and postgreSQL 7.1.4 on it,tomcat is
5.0.18.
I use win xp,pgAdmin on it to connect the postgres.
there're in the same network,no firewall.
Druid is on server.
Best Regards
Johnson
----- Original Message -----
From: "Antonio Gallardo" <ag...@agssa.net>
To: <us...@cocoon.apache.org>
Sent: Saturday, February 21, 2004 5:34 PM
Subject: Re: Can not get Connection from DataSource
> >From your posts, looks like your are on a windows machine. I guess
> postgres is running on a Linux machine.
>
> Webmin is running on the same server where you have you postgreSQL server.
> Is there running tomcat 5.0.18. Because to me it looks like a tipicla
> closed port on the server. Are you checked the firewall?
>
> What about pgAdminIII? It this running on the same machine as you are
> running Tomcat?
>
> Best Regards,
>
> Antonio Gallardo
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Error compiling fresh CVS download
Posted by Geoff Howard <co...@leverageweb.com>.
Johan Kok wrote:
>
> Got the following error trying to compile cocoon after CVS download:
>
> C:\Apache\cocoon\cocoon-2.2\src\java\org\apache\cocoon\components\flow\AbstractI
>
Don't use 2.2 yet.
http://marc.theaimsgroup.com/?l=xml-cocoon-users&m=107600552608370&w=2
Geoff
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Error compiling fresh CVS download
Posted by Johan Kok <jk...@in-corp.com>.
Got the following error trying to compile cocoon after CVS download:
C:\Apache\cocoon\cocoon-2.2\src\java\org\apache\cocoon\components\flow\AbstractI
nterpreter.java:65: package org.apache.cocoon.components.flow.util does
not exis
t
import org.apache.cocoon.components.flow.util.PipelineUtil;
^
C:\Apache\cocoon\cocoon-2.2\src\java\org\apache\cocoon\components\flow\AbstractI
nterpreter.java:186: cannot resolve symbol
symbol : class PipelineUtil
location: class org.apache.cocoon.components.flow.AbstractInterpreter
PipelineUtil pipeUtil = new PipelineUtil();
^
C:\Apache\cocoon\cocoon-2.2\src\java\org\apache\cocoon\components\flow\AbstractI
nterpreter.java:186: cannot resolve symbol
symbol : class PipelineUtil
location: class org.apache.cocoon.components.flow.AbstractInterpreter
PipelineUtil pipeUtil = new PipelineUtil();
^
3 errors
BUILD FAILED
C:\Apache\cocoon\cocoon-2.2\tools\targets\compile-build.xml:51: Compile
failed;
see the compiler error output for details.
Total time: 1 minute 4 seconds
C:\Apache\cocoon\cocoon-2.2>
Antonio Gallardo wrote:
>>>From your posts, looks like your are on a windows machine. I guess
>postgres is running on a Linux machine.
>
>Webmin is running on the same server where you have you postgreSQL server.
>Is there running tomcat 5.0.18. Because to me it looks like a tipicla
>closed port on the server. Are you checked the firewall?
>
>What about pgAdminIII? It this running on the same machine as you are
>running Tomcat?
>
>Best Regards,
>
>Antonio Gallardo
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
>For additional commands, e-mail: users-help@cocoon.apache.org
>
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource
Posted by Antonio Gallardo <ag...@agssa.net>.
>From your posts, looks like your are on a windows machine. I guess
postgres is running on a Linux machine.
Webmin is running on the same server where you have you postgreSQL server.
Is there running tomcat 5.0.18. Because to me it looks like a tipicla
closed port on the server. Are you checked the firewall?
What about pgAdminIII? It this running on the same machine as you are
running Tomcat?
Best Regards,
Antonio Gallardo
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource
Posted by Johnson <jo...@soho.club.tw>.
I can connect the database using pgAdminIII,and webmin.
Best Regards
Johnson
----- Original Message -----
From: "Antonio Gallardo" <ag...@agssa.net>
To: <us...@cocoon.apache.org>
Sent: Saturday, February 21, 2004 5:00 PM
Subject: Re: Can not get Connection from DataSource
> Hi:
>
> Can you connect to the database using:
> http://squirrel-sql.sourceforge.net/
>
> Best Regards,
>
> Antonio Gallardo.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource
Posted by Johnson <jo...@soho.club.tw>.
Plus Druid
----- Original Message -----
From: "Antonio Gallardo" <ag...@agssa.net>
To: <us...@cocoon.apache.org>
Sent: Saturday, February 21, 2004 5:00 PM
Subject: Re: Can not get Connection from DataSource
> Hi:
>
> Can you connect to the database using:
> http://squirrel-sql.sourceforge.net/
>
> Best Regards,
>
> Antonio Gallardo.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource
Posted by Antonio Gallardo <ag...@agssa.net>.
Hi:
Can you connect to the database using:
http://squirrel-sql.sourceforge.net/
Best Regards,
Antonio Gallardo.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource named //192.168.10.1:5432/test
Posted by Johnson <jo...@soho.club.tw>.
1.I build a postgres in the same server,try to store in it.
2. the message is.
"file:/jakarta-tomcat-5.0.18/webapps/cocoon/test/flow/registration.js", line
8: uncaught JavaScript exception: at registration
(file:/jakarta-tomcat-5.0.18/webapps/cocoon/test/flow/registration.js, Line
8): org.apache.ojb.broker.PersistenceBrokerException: Cannot get Connection
from DataSource named //192.168.10.1:5432/test
The repository.xml package.jdo and the build.xml are gen by Druid 3.4.
Best Regards
Johnson
----- Original Message -----
From: "Antonio Gallardo" <ag...@agssa.net>
To: <us...@cocoon.apache.org>
Sent: Saturday, February 21, 2004 4:06 PM
Subject: Re: Can not get Connection from DataSource named
//192.168.10.1:5432/test
> Hi:
>
> Are you tried to make a connection using JDBC outside Cocoon?
>
> An easy application I often use is Squirrel SQL -
> http://squirrel-sql.sourceforge.net/
>
> BTW, can you post the error you got?
>
> Best Regards,
>
> Antonio Gallardo
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource named
//192.168.10.1:5432/test
Posted by Antonio Gallardo <ag...@agssa.net>.
Hi:
Are you tried to make a connection using JDBC outside Cocoon?
An easy application I often use is Squirrel SQL -
http://squirrel-sql.sourceforge.net/
BTW, can you post the error you got?
Best Regards,
Antonio Gallardo
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource named
//192.168.10.1:5432/test
Posted by Antonio Gallardo <ag...@agssa.net>.
Johnson dijo:
> I'm trying to bind the ojb-jdo example to postgresql
> when open the page,it show me Cannot get Connection from DataSource named
> //192.168.10.1:5432/test
> below is my repository.xml
>
> <descriptor-repository version="1.0" isolation-level="read-uncommitted">
> <jdbc-connection-descriptor jcd-alias="test" default-connection="true"
> platform="PostgreSQL" jdbc-level="3.0" driver="org.postgresql.Driver"
> protocol="jdbc" subprotocol="postgresql"
> dbalias="//192.168.10.1:5432/test" username="postgres" password=""
> eager-release="false" batch-mode="false" useAutoCommit="1"
> ignoreAutoCommitExceptions="false">
> <connection-pool maxActive="21" validationQuery=""/>
^^
Where is your validation query?
You can write any query that will be tested against your database. Example:
I have a table called "Catalog" then I can write as a validation query:
validationQuery="SELECT 1 FROM Catalog"
More info at: http://db.apache.org/ojb/repository.html#connection-pool
> <sequence-manager
className="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl">
> <attribute attribute-name="autoNaming" attribute-value="true"/>
> <attribute attribute-name="grabSize" attribute-value="20"/>
> <attribute attribute-name="globalSequenceId" attribute-value="false"/>
> <attribute attribute-name="globalSequenceStart"
> attribute-value="10000"/>
> </sequence-manager>
Change the <sequence-manager> to:
<sequence-manager
className="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl">
<attribute attribute-name="grabSize" attribute-value="20"/>
attribute-value="10000"/>
</sequence-manager>
> </jdbc-connection-descriptor>
> <class-descriptor class="com.goodwill.bean.Registration"
> table="REGISTRATION">
> <field-descriptor name="id" primarykey="true" default-fetch="true"
> autoincrement="true" sequence-name="user_seq'::text" column="ID"
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Remove it. You are not using nextval sequences.
After these changes, try again! :-D
Best Regards,
Antonio Gallardo
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource named
//192.168.10.1:5432/test
Posted by Antonio Gallardo <ag...@agssa.net>.
Johnson dijo:
> just delete the attrib of seq,and rebuild,still don't work.
Is the error the same or is there other error? Are you did all the changes
I suggested?
Best Regards,
Antonio Gallardo
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource named //192.168.10.1:5432/test
Posted by Johnson <jo...@soho.club.tw>.
just delete the attrib of seq,and rebuild,still don't work
Johnson
----- Original Message -----
From: "Antonio Gallardo" <ag...@agssa.net>
To: <us...@cocoon.apache.org>
Sent: Saturday, February 21, 2004 9:06 PM
Subject: Re: Can not get Connection from DataSource named
//192.168.10.1:5432/test
> You need to change the sequence manager. Here is the doc to configure the
> High/LowSequenceManager:
>
>
http://db.apache.org/ojb/sequencemanager.html#High/Low%20sequence%20manager
>
> Best Regards,
>
> Antonio Gallardo
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource named
//192.168.10.1:5432/test
Posted by Antonio Gallardo <ag...@agssa.net>.
You need to change the sequence manager. Here is the doc to configure the
High/LowSequenceManager:
http://db.apache.org/ojb/sequencemanager.html#High/Low%20sequence%20manager
Best Regards,
Antonio Gallardo
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource named //192.168.10.1:5432/test
Posted by Johnson <jo...@soho.club.tw>.
I see , I will try!
Tks.
Best Regards
Johnson
----- Original Message -----
From: "Antonio Gallardo" <ag...@agssa.net>
To: <us...@cocoon.apache.org>
Sent: Saturday, February 21, 2004 8:51 PM
Subject: Re: Can not get Connection from DataSource named
//192.168.10.1:5432/test
> Johnson dijo:
> > I'm trying to bind the ojb-jdo example to postgresql
> > when open the page,it show me Cannot get Connection from DataSource
named
> > //192.168.10.1:5432/test
> > below is my repository.xml
> >
> > <descriptor-repository version="1.0" isolation-level="read-uncommitted">
> > <jdbc-connection-descriptor jcd-alias="test" default-connection="true"
> > platform="PostgreSQL" jdbc-level="3.0" driver="org.postgresql.Driver"
> > protocol="jdbc" subprotocol="postgresql"
> > dbalias="//192.168.10.1:5432/test" username="postgres" password=""
> > eager-release="false" batch-mode="false" useAutoCommit="1"
> > ignoreAutoCommitExceptions="false">
> > <connection-pool maxActive="21" validationQuery=""/>
> > <sequence-manager
> >
className="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl">
> > <attribute attribute-name="autoNaming" attribute-value="true"/>
> > <attribute attribute-name="grabSize" attribute-value="20"/>
> > <attribute attribute-name="globalSequenceId"
attribute-value="false"/>
> > <attribute attribute-name="globalSequenceStart"
> > attribute-value="10000"/>
> > </sequence-manager>
> > </jdbc-connection-descriptor>
> > <class-descriptor class="com.goodwill.bean.Registration"
> > table="REGISTRATION">
> > <field-descriptor name="id" primarykey="true" default-fetch="true"
> > autoincrement="true" sequence-name="user_seq'::text" column="ID"
> ^^^^^^^^^^^^^^^^^
> A valid name for a sequence?
>
> Can you change it? I don't like it and maybe this is the source of the
> problem
>
> Best Regards,
>
> Antonio Gallardo.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org
Re: Can not get Connection from DataSource named
//192.168.10.1:5432/test
Posted by Antonio Gallardo <ag...@agssa.net>.
Johnson dijo:
> I'm trying to bind the ojb-jdo example to postgresql
> when open the page,it show me Cannot get Connection from DataSource named
> //192.168.10.1:5432/test
> below is my repository.xml
>
> <descriptor-repository version="1.0" isolation-level="read-uncommitted">
> <jdbc-connection-descriptor jcd-alias="test" default-connection="true"
> platform="PostgreSQL" jdbc-level="3.0" driver="org.postgresql.Driver"
> protocol="jdbc" subprotocol="postgresql"
> dbalias="//192.168.10.1:5432/test" username="postgres" password=""
> eager-release="false" batch-mode="false" useAutoCommit="1"
> ignoreAutoCommitExceptions="false">
> <connection-pool maxActive="21" validationQuery=""/>
> <sequence-manager
> className="org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl">
> <attribute attribute-name="autoNaming" attribute-value="true"/>
> <attribute attribute-name="grabSize" attribute-value="20"/>
> <attribute attribute-name="globalSequenceId" attribute-value="false"/>
> <attribute attribute-name="globalSequenceStart"
> attribute-value="10000"/>
> </sequence-manager>
> </jdbc-connection-descriptor>
> <class-descriptor class="com.goodwill.bean.Registration"
> table="REGISTRATION">
> <field-descriptor name="id" primarykey="true" default-fetch="true"
> autoincrement="true" sequence-name="user_seq'::text" column="ID"
^^^^^^^^^^^^^^^^^
A valid name for a sequence?
Can you change it? I don't like it and maybe this is the source of the
problem
Best Regards,
Antonio Gallardo.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org