You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Alexandre Touret <al...@cgbi.fr> on 2003/04/23 14:57:48 UTC
Datasource & Tomcat
Hi all,
I try to connect OJB 1.0RC1 with a datasource which is configured on
Tomcat 4.1.24.
When I try to execute any request OJB fail to obtain the reference of
the datasource.
I tryed to lookup the datasource with JNDI and it s OK
The exception:
org.apache.ojb.broker.PersistenceBrokerException: Naming Exception while
looking up DataSource (java:jdbc/catalog): Le Nom jdbc n'est pas lié à
ce Contexte: Naming Exception while looking up DataSource
(java:jdbc/catalog): Le Nom jdbc n'est pas lié à ce Contexte
My repository_database.xml
<jdbc-connection-descriptor
jcd-alias="db"
default-connection="true"
platform="hsqldb"
jdbc-level="2.0"
jndi-datasource-name="java:jdbc/catalog"
username="sa"
password=""
eager-release="true"
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="grabSize" attribute-value="20"/>
<attribute attribute-name="globalSequenceId"
attribute-value="false"/>
</sequence-manager>
</jdbc-connection-descriptor>
My OJB.properties
repositoryFile=repository.xml
useSerializedRepository=false
useServer=false
BrokerServers=127.0.0.1\:2001
ServerThreadCount=10
BrokerPoolSize=10
UseCompression=false
PersistenceBrokerFactoryClass=org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl
PersistenceBrokerClass=org.apache.ojb.broker.singlevm.PersistenceBrokerImpl
maxIdle=-1
maxWait=2000
timeBetweenEvictionRunsMillis=-1
minEvictableIdleTimeMillis=1000000
whenExhaustedAction=0
#ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl
#ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryNotPooledImpl
ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryManagedImpl
#ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryDBCPImpl
ConnectionManagerClass=org.apache.ojb.broker.accesslayer.ConnectionManagerImpl
SqlGeneratorClass=org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl
StatementManagerClass=org.apache.ojb.broker.accesslayer.StatementManager
JdbcAccessClass=org.apache.ojb.broker.accesslayer.JdbcAccessImpl
ObjectCacheClass=org.apache.ojb.broker.cache.ObjectCacheDefaultImpl
LockManagerClass=org.apache.ojb.odmg.locking.LockManagerDefaultImpl
LockMapClass=org.apache.ojb.odmg.locking.InMemoryLockMapImpl
LockTimeout=60000
ImplicitLocking=true
LockAssociations=WRITE
LoggerClass=org.apache.ojb.broker.util.logging.PoorMansLoggerImpl
LoggerConfigFile=log4j.properties
DEFAULT.LogLevel=DEBUG
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.LogLevel=DEBUG
org.apache.ojb.broker.PersistenceBrokerFactory.LogLevel=DEBUG
org.apache.ojb.broker.server.PersistenceBrokerClient.LogLevel=DEBUG
org.apache.ojb.broker.server.RequestProcessor.LogLevel=DEBUG
org.apache.ojb.broker.server.BrokerPool.LogLevel=DEBUG
org.apache.ojb.broker.metadata.RepositoryXmlHandler.LogLevel=DEBUG
org.apache.ojb.broker.accesslayer.JdbcAccess.LogLevel=DEBUG
org.apache.ojb.broker.accesslayer.RsIterator.LogLevel=DEBUG
org.apache.ojb.broker.accesslayer.StatementsForClass.LogLevel=DEBUG
org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl.LogLevel=DEBUG
org.apache.ojb.broker.metadata.RepositoryPersistor.LogLevel=DEBUG
org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl.LogLevel=DEBUG
ODMG.LogLevel=WARN
JDO.LogLevel=DEBUG
performance.LogLevel=DEBUG
soda.LogLevel=DEBUG
ConfigurableFactory.LogLevel=DEBUG
OqlCollectionClass=org.apache.ojb.odmg.collections.DListImpl
SqlInLimit=200
PersistentFieldClass=org.apache.ojb.broker.metadata.fieldaccess.PersistentFieldDefaultImpl
OJBTxManagerClass=org.apache.ojb.odmg.LocalTxManager
JTATransactionManagerClass=org.apache.ojb.otm.transaction.factory.JBossTransactionManagerFactory
autobuild=false
Thanks for your help
Alexandre Touret
--
______________________________
Alexandre Touret
CGBI
69 Boulevard Galliéni
92130 Issy les Moulineaux
tel.: 01/55/95/53/95 Poste: 5395
mailto:alexandre.touret@cgbi.fr
Re: Datasource & Tomcat
Posted by Jason McKerr <mc...@nacse.org>.
Oops. That last one I sent is for Orion/Oracle9iAS.
For Tomcat or Resin you likely need something like:
jndi-datasource-name="java:comp/env/jdbc/WSNEESOracle"
Sorry about that.
Jason
On Wed, 2003-04-23 at 08:42, Jason McKerr wrote:
> With Tomcat it is likely that yu should only have your JNDI look
> something like
>
> "jdbc/catalog" or
>
> jndi-datasource-name="jdbc/catalog"
>
> Jason
>
>
>
> On Wed, 2003-04-23 at 05:57, Alexandre Touret wrote:
> > Hi all,
> > I try to connect OJB 1.0RC1 with a datasource which is configured on
> > Tomcat 4.1.24.
> > When I try to execute any request OJB fail to obtain the reference of
> > the datasource.
> > I tryed to lookup the datasource with JNDI and it s OK
> >
> > The exception:
> >
> > org.apache.ojb.broker.PersistenceBrokerException: Naming Exception while
> > looking up DataSource (java:jdbc/catalog): Le Nom jdbc n'est pas lié à
> > ce Contexte: Naming Exception while looking up DataSource
> > (java:jdbc/catalog): Le Nom jdbc n'est pas lié à ce Contexte
> >
> > My repository_database.xml
> >
> > <jdbc-connection-descriptor
> > jcd-alias="db"
> > default-connection="true"
> > platform="hsqldb"
> > jdbc-level="2.0"
> > jndi-datasource-name="java:jdbc/catalog"
> > username="sa"
> > password=""
> > eager-release="true"
> > 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="grabSize" attribute-value="20"/>
> > <attribute attribute-name="globalSequenceId"
> > attribute-value="false"/>
> > </sequence-manager>
> > </jdbc-connection-descriptor>
> >
> >
> > My OJB.properties
> > repositoryFile=repository.xml
> > useSerializedRepository=false
> > useServer=false
> > BrokerServers=127.0.0.1\:2001
> > ServerThreadCount=10
> > BrokerPoolSize=10
> > UseCompression=false
> > PersistenceBrokerFactoryClass=org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl
> > PersistenceBrokerClass=org.apache.ojb.broker.singlevm.PersistenceBrokerImpl
> > maxIdle=-1
> > maxWait=2000
> > timeBetweenEvictionRunsMillis=-1
> > minEvictableIdleTimeMillis=1000000
> > whenExhaustedAction=0
> > #ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl
> > #ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryNotPooledImpl
> > ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryManagedImpl
> > #ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryDBCPImpl
> > ConnectionManagerClass=org.apache.ojb.broker.accesslayer.ConnectionManagerImpl
> > SqlGeneratorClass=org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl
> > StatementManagerClass=org.apache.ojb.broker.accesslayer.StatementManager
> > JdbcAccessClass=org.apache.ojb.broker.accesslayer.JdbcAccessImpl
> > ObjectCacheClass=org.apache.ojb.broker.cache.ObjectCacheDefaultImpl
> > LockManagerClass=org.apache.ojb.odmg.locking.LockManagerDefaultImpl
> > LockMapClass=org.apache.ojb.odmg.locking.InMemoryLockMapImpl
> > LockTimeout=60000
> > ImplicitLocking=true
> > LockAssociations=WRITE
> > LoggerClass=org.apache.ojb.broker.util.logging.PoorMansLoggerImpl
> > LoggerConfigFile=log4j.properties
> > DEFAULT.LogLevel=DEBUG
> > org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.LogLevel=DEBUG
> > org.apache.ojb.broker.PersistenceBrokerFactory.LogLevel=DEBUG
> > org.apache.ojb.broker.server.PersistenceBrokerClient.LogLevel=DEBUG
> >
> > org.apache.ojb.broker.server.RequestProcessor.LogLevel=DEBUG
> > org.apache.ojb.broker.server.BrokerPool.LogLevel=DEBUG
> > org.apache.ojb.broker.metadata.RepositoryXmlHandler.LogLevel=DEBUG
> > org.apache.ojb.broker.accesslayer.JdbcAccess.LogLevel=DEBUG
> > org.apache.ojb.broker.accesslayer.RsIterator.LogLevel=DEBUG
> > org.apache.ojb.broker.accesslayer.StatementsForClass.LogLevel=DEBUG
> > org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl.LogLevel=DEBUG
> > org.apache.ojb.broker.metadata.RepositoryPersistor.LogLevel=DEBUG
> > org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl.LogLevel=DEBUG
> > ODMG.LogLevel=WARN
> > JDO.LogLevel=DEBUG
> > performance.LogLevel=DEBUG
> > soda.LogLevel=DEBUG
> > ConfigurableFactory.LogLevel=DEBUG
> > OqlCollectionClass=org.apache.ojb.odmg.collections.DListImpl
> > SqlInLimit=200
> > PersistentFieldClass=org.apache.ojb.broker.metadata.fieldaccess.PersistentFieldDefaultImpl
> > OJBTxManagerClass=org.apache.ojb.odmg.LocalTxManager
> > JTATransactionManagerClass=org.apache.ojb.otm.transaction.factory.JBossTransactionManagerFactory
> > autobuild=false
> >
> >
> > Thanks for your help
> >
> > Alexandre Touret
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
Re: Datasource & Tomcat
Posted by Jason McKerr <mc...@nacse.org>.
With Tomcat it is likely that yu should only have your JNDI look
something like
"jdbc/catalog" or
jndi-datasource-name="jdbc/catalog"
Jason
On Wed, 2003-04-23 at 05:57, Alexandre Touret wrote:
> Hi all,
> I try to connect OJB 1.0RC1 with a datasource which is configured on
> Tomcat 4.1.24.
> When I try to execute any request OJB fail to obtain the reference of
> the datasource.
> I tryed to lookup the datasource with JNDI and it s OK
>
> The exception:
>
> org.apache.ojb.broker.PersistenceBrokerException: Naming Exception while
> looking up DataSource (java:jdbc/catalog): Le Nom jdbc n'est pas lié à
> ce Contexte: Naming Exception while looking up DataSource
> (java:jdbc/catalog): Le Nom jdbc n'est pas lié à ce Contexte
>
> My repository_database.xml
>
> <jdbc-connection-descriptor
> jcd-alias="db"
> default-connection="true"
> platform="hsqldb"
> jdbc-level="2.0"
> jndi-datasource-name="java:jdbc/catalog"
> username="sa"
> password=""
> eager-release="true"
> 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="grabSize" attribute-value="20"/>
> <attribute attribute-name="globalSequenceId"
> attribute-value="false"/>
> </sequence-manager>
> </jdbc-connection-descriptor>
>
>
> My OJB.properties
> repositoryFile=repository.xml
> useSerializedRepository=false
> useServer=false
> BrokerServers=127.0.0.1\:2001
> ServerThreadCount=10
> BrokerPoolSize=10
> UseCompression=false
> PersistenceBrokerFactoryClass=org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl
> PersistenceBrokerClass=org.apache.ojb.broker.singlevm.PersistenceBrokerImpl
> maxIdle=-1
> maxWait=2000
> timeBetweenEvictionRunsMillis=-1
> minEvictableIdleTimeMillis=1000000
> whenExhaustedAction=0
> #ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl
> #ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryNotPooledImpl
> ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryManagedImpl
> #ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFactoryDBCPImpl
> ConnectionManagerClass=org.apache.ojb.broker.accesslayer.ConnectionManagerImpl
> SqlGeneratorClass=org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl
> StatementManagerClass=org.apache.ojb.broker.accesslayer.StatementManager
> JdbcAccessClass=org.apache.ojb.broker.accesslayer.JdbcAccessImpl
> ObjectCacheClass=org.apache.ojb.broker.cache.ObjectCacheDefaultImpl
> LockManagerClass=org.apache.ojb.odmg.locking.LockManagerDefaultImpl
> LockMapClass=org.apache.ojb.odmg.locking.InMemoryLockMapImpl
> LockTimeout=60000
> ImplicitLocking=true
> LockAssociations=WRITE
> LoggerClass=org.apache.ojb.broker.util.logging.PoorMansLoggerImpl
> LoggerConfigFile=log4j.properties
> DEFAULT.LogLevel=DEBUG
> org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.LogLevel=DEBUG
> org.apache.ojb.broker.PersistenceBrokerFactory.LogLevel=DEBUG
> org.apache.ojb.broker.server.PersistenceBrokerClient.LogLevel=DEBUG
>
> org.apache.ojb.broker.server.RequestProcessor.LogLevel=DEBUG
> org.apache.ojb.broker.server.BrokerPool.LogLevel=DEBUG
> org.apache.ojb.broker.metadata.RepositoryXmlHandler.LogLevel=DEBUG
> org.apache.ojb.broker.accesslayer.JdbcAccess.LogLevel=DEBUG
> org.apache.ojb.broker.accesslayer.RsIterator.LogLevel=DEBUG
> org.apache.ojb.broker.accesslayer.StatementsForClass.LogLevel=DEBUG
> org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl.LogLevel=DEBUG
> org.apache.ojb.broker.metadata.RepositoryPersistor.LogLevel=DEBUG
> org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl.LogLevel=DEBUG
> ODMG.LogLevel=WARN
> JDO.LogLevel=DEBUG
> performance.LogLevel=DEBUG
> soda.LogLevel=DEBUG
> ConfigurableFactory.LogLevel=DEBUG
> OqlCollectionClass=org.apache.ojb.odmg.collections.DListImpl
> SqlInLimit=200
> PersistentFieldClass=org.apache.ojb.broker.metadata.fieldaccess.PersistentFieldDefaultImpl
> OJBTxManagerClass=org.apache.ojb.odmg.LocalTxManager
> JTATransactionManagerClass=org.apache.ojb.otm.transaction.factory.JBossTransactionManagerFactory
> autobuild=false
>
>
> Thanks for your help
>
> Alexandre Touret
Re: Datasource & Tomcat
Posted by Alexandre Touret <al...@cgbi.fr>.
It s work fine
Thank you very much :-)
Alexandre Touret
Olaf Meske wrote:
> Hi,
> I use the same thing.
> Hop this helps:
>
> Alexandre Touret wrote:
> [...]
>
>>
>> My repository_database.xml
>>
>> <jdbc-connection-descriptor
>> jcd-alias="db"
>> default-connection="true"
>> platform="hsqldb"
>> jdbc-level="2.0"
>> jndi-datasource-name="java:jdbc/catalog"
>
>
> jndi-datasource-name="java:comp/env/jdbc/catalog"
> and remove the username and password attributes.
> The JDNI lookup name starts always with "java:comp/env/" and
> the username, password thing throws an Unsupported Exception from the
> dbcp pooling.
>
>> username="sa"
>> password=""
>> eager-release="true"
>> 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="grabSize" attribute-value="20"/>
>> <attribute attribute-name="globalSequenceId"
>> attribute-value="false"/>
>> </sequence-manager>
>> </jdbc-connection-descriptor>
>>
> [...]
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
--
______________________________
Alexandre Touret
CGBI
69 Boulevard Galliéni
92130 Issy les Moulineaux
tel.: 01/55/95/53/95 Poste: 5395
mailto:alexandre.touret@cgbi.fr
Re: Datasource & Tomcat
Posted by Olaf Meske <ol...@iqnex.com>.
Hi,
I use the same thing.
Hop this helps:
Alexandre Touret wrote:
[...]
>
> My repository_database.xml
>
> <jdbc-connection-descriptor
> jcd-alias="db"
> default-connection="true"
> platform="hsqldb"
> jdbc-level="2.0"
> jndi-datasource-name="java:jdbc/catalog"
jndi-datasource-name="java:comp/env/jdbc/catalog"
and remove the username and password attributes.
The JDNI lookup name starts always with "java:comp/env/" and
the username, password thing throws an Unsupported Exception from the
dbcp pooling.
> username="sa"
> password=""
> eager-release="true"
> 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="grabSize" attribute-value="20"/>
> <attribute attribute-name="globalSequenceId"
> attribute-value="false"/>
> </sequence-manager>
> </jdbc-connection-descriptor>
>
[...]