It does not solve the problem.
Here the output logs for the both configurations.
Not Working:
[BOOT] INFO: OJB.properties:
file:C:/dev/projets/Catalogue/dist/webapp/WEB-INF/classes/OJB.properties
[org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO:
Already created persistence broker instances: 0
[DEFAULT] INFO: OJB Descriptor Repository:
file:C:/dev/projets/Catalogue/dist/webapp/WEB-INF/classes/repository.xml
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG: startDoc
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG: >
descriptor-repository
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG: >
jdbc-connection-descriptor
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG:
platform: MySQL
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG:
jdbc-level: 2.0
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG:
driver: null
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG:
protocol: null
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG:
subprotocol: null
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG:
dbalias: null
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG:
jndi-datasource-name: java:comp/env/jdbc/catalogueDS
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG:
username: us_catalogue
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG:
password: us_catalogue
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG: <
jdbc-connection-descriptor
...
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG: <
descriptor-repository
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG: endDoc
[DEFAULT] INFO: ...Finished parsing
[org.apache.ojb.broker.util.sequence.SequenceManagerFactory] INFO: Use
sequence manager class: class
org.apache.ojb.broker.util.sequence.SequenceManagerHiLoImpl
[org.apache.ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG:
getCollectionByQuery (class
org.apache.ojb.broker.util.collections.ManageableVector, class
com.eurelis.webtools.catalogue.Catalogue, Query from class
com.eurelis.webtools.catalogue.Catalogue where null)
[org.apache.ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG:
getIteratorFromQuery class com.eurelis.webtools.catalogue.Catalogue,
Query from class com.eurelis.webtools.catalogue.Catalogue where null
[org.apache.ojb.broker.accesslayer.RsIterator] DEBUG: RsIterator(Query
from class com.eurelis.webtools.catalogue.Catalogue where null, table:
catalogue FieldDescriptions:
[Lorg.apache.ojb.broker.metadata.FieldDescriptor;@76e8a7)
[org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeQuery :
Query from class com.eurelis.webtools.catalogue.Catalogue where null
Working:
[BOOT] INFO: OJB.properties:
file:C:/dev/projets/Catalogue/dist/webapp/WEB-INF/classes/OJB.properties
[org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO:
Already created persistence broker instances: 0
[DEFAULT] INFO: OJB Descriptor Repository:
file:C:/dev/projets/Catalogue/dist/webapp/WEB-INF/classes/repository.xml
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG: startDoc
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG: >
descriptor-repository
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG: >
jdbc-connection-descriptor
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG:
platform: MySQL
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG:
jdbc-level: 2.0
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG:
driver: null
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG:
protocol: null
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG:
subprotocol: null
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG:
dbalias: null
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG:
jndi-datasource-name: java:comp/env/jdbc/catalogueDS
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG:
username: us_catalogue
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG:
password: us_catalogue
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG: <
jdbc-connection-descriptor
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG: <
descriptor-repository
[org.apache.ojb.broker.metadata.RepositoryXmlHandler] DEBUG: endDoc
[DEFAULT] INFO: ...Finished parsing
[org.apache.ojb.broker.util.sequence.SequenceManagerFactory] INFO: Use
sequence manager class: class
org.apache.ojb.broker.util.sequence.SequenceManagerHiLoImpl
[org.apache.ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG:
getCollectionByQuery (class
org.apache.ojb.broker.util.collections.ManageableVector, class
com.eurelis.webtools.catalogue.Catalogue, Query from class
com.eurelis.webtools.catalogue.Catalogue where null)
[org.apache.ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG:
getIteratorFromQuery class com.eurelis.webtools.catalogue.Catalogue,
Query from class com.eurelis.webtools.catalogue.Catalogue where null
[org.apache.ojb.broker.accesslayer.RsIterator] DEBUG: RsIterator(Query
from class com.eurelis.webtools.catalogue.Catalogue where null, table:
catalogue FieldDescriptions:
[Lorg.apache.ojb.broker.metadata.FieldDescriptor;@e35bb7)
[org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeQuery :
Query from class com.eurelis.webtools.catalogue.Catalogue where null
[org.apache.ojb.broker.accesslayer.SqlGenerator] DEBUG: SQL: SELECT
A0.description,A0.name,A0.id,A0.idcategory,A0.categoryclassname,A0.itemc
lassname FROM catalogue A0
[org.apache.ojb.broker.accesslayer.RsIterator] DEBUG: hasNext() -> true
[org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO:
Already created persistence broker instances: 1
[org.apache.ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG:
getObjectByIdentity com.eurelis.webtools.catalogue.test.RealCategory{1}
[org.apache.ojb.broker.accesslayer.SqlGenerator] DEBUG: SQL: SELECT
idcatalogue,description,name,id,idcategory FROM category WHERE
(category.id = ? )
[org.apache.ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG:
getObjectByIdentity com.eurelis.webtools.catalogue.test.RealCategory{0}
[org.apache.ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG:
getCollectionByQuery (class
org.apache.ojb.broker.util.collections.ManageableVector, class
com.eurelis.webtools.catalogue.test.RealCategory, Query from class
com.eurelis.webtools.catalogue.test.RealCategory where idcategory = ? )
...
[org.apache.ojb.broker.accesslayer.SqlGenerator] DEBUG: SQL: SELECT
A0.idcatalogue,A0.description,A0.name,A0.id,A0.idcategory FROM item A0
WHERE A0.idcategory = ?
[org.apache.ojb.broker.accesslayer.RsIterator] DEBUG: hasNext() -> true
[org.apache.ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG:
getObjectByIdentity com.eurelis.webtools.catalogue.test.RealCategory{2}
[org.apache.ojb.broker.accesslayer.RsIterator] DEBUG: hasNext() -> true
[org.apache.ojb.broker.singlevm.PersistenceBrokerImpl] DEBUG:
getObjectByIdentity com.eurelis.webtools.catalogue.test.RealCategory{2}
[org.apache.ojb.broker.accesslayer.RsIterator] DEBUG: hasNext() -> false
[org.apache.ojb.broker.accesslayer.RsIterator] DEBUG: hasNext() -> false
Here is my OJB.properties file :
useSerializedRepository=false
useServer=false
BrokerServers=localhost\:2001
ServerThreadCount=10
BrokerPoolSize=10
PersistenceBrokerFactoryClass=org.apache.ojb.broker.ta.PersistenceBroker
FactoryDefaultImpl
PersistenceBrokerClass=org.apache.ojb.broker.singlevm.PersistenceBrokerI
mpl
maxActive=100
maxIdle=-1
maxWait=2000
timeBetweenEvictionRunsMillis=-1
minEvictableIdleTimeMillis=1000000
whenExhaustedAction=0
ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFacto
ryDefaultImpl
maxConnectionsInPool=21
useAutoCommit=1
ignoreAutoCommitExceptions=false
SequenceManagerClass=org.apache.ojb.broker.util.sequence.SequenceManager
HiLoImpl
SequenceManagerGrabSize=10
SequenceManagerGlobalIDs=false
ObjectCacheClass=org.apache.ojb.broker.cache.ObjectCacheDefaultImpl
LockManagerClass=org.apache.ojb.odmg.locking.LockManagerDefaultImpl
LockMapClass=org.apache.ojb.odmg.locking.InMemoryLockMapImpl
LockTimeout=60000
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.SqlGenerator.LogLevel=DEBUG
ODMG.LogLevel=DEBUG
performance.LogLevel=INFO
soda.LogLevel=WARN
OqlCollectionClass=org.apache.ojb.odmg.collections.DListImpl
PrefetchInLimit=200
PersistentFieldClass=org.apache.ojb.broker.metadata.PersistentFieldDefau
ltImpl
-----Message d'origine-----
De : Armin Waibel [mailto:[EMAIL PROTECTED]]
Envoy� : vendredi 6 septembre 2002 14:03
� : OJB Users List
Objet : Re: JNDI configuration
Try to set in the OJB.properties
under "ConnectionFactory / Default ConnectionPool"
ConnectionFactoryClass=
org.apache.ojb.broker.accesslayer.ConnectionFactoryDefaultImpl
HTH,
Armin
----- Original Message -----
From: "Vincent Lambert" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 06, 2002 1:21 PM
Subject: JNDI configuration
> Hi,
>
> I am trying to configure OJB to connect a database with a connection
> pool. I am using :
> OJB 0.9.5
> Tomcat 4.0.3
> JDK 1.4
> Commons-collections 2.0
> Commons-dbpc 1.0
> Commons-pool 1.0.1
>
>
> Here is my jdbc-connection-descriptor :
>
> <jdbc-connection-descriptor
> platform="MySQL"
> jdbc-level="3.0"
> jndi-datasource-name="java:comp/env/jdbc/catalogueDS"
> username="us_catalogue"
> password="us_catalogue"/>
>
>
>
> Every thing works well when i use th followind DataSource :
>
> <Resource name="jdbc/catalogueDS" auth="Container"
> type="javax.sql.DataSource"/>
> <ResourceParams name="jdbc/catalogueDS">
> <parameter>
> <name>user</name>
> <value>us_catalogue</value>
> </parameter>
> <parameter>
> <name>password</name>
> <value>us_catalogue</value>
> </parameter>
> <parameter>
> <name>driverClassName</name>
> <value>org.gjt.mm.mysql.Driver</value>
> </parameter>
> <parameter>
> <name>driverName</name>
>
> <value>jdbc:mysql://localhost:3306/db_catalogue</value>
> </parameter>
> </ResourceParams>
>
>
> But when I configure a connection pool it does not work any more :
>
> <Resource name="jdbc/catalogueDS" auth="Container"
> type="javax.sql.DataSource"/>
> <ResourceParams name="jdbc/catalogueDS">
> <parameter>
> <name>factory</name>
>
> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
> </parameter>
> <parameter>
> <name>maxActive</name>
> <value>5</value>
> </parameter>
> <parameter>
> <name>maxIdle</name>
> <value>3</value>
> </parameter>
> <parameter>
> <name>maxWait</name>
> <value>60000</value>
> </parameter>
> <parameter>
> <name>username</name>
> <value>us_catalogue</value>
> </parameter>
> <parameter>
> <name>password</name>
> <value>us_catalogue</value>
> </parameter>
> <parameter>
> <name>driverClassName</name>
> <value>org.gjt.mm.mysql.Driver</value>
> </parameter>
> <parameter>
> <name>url</name>
>
> <value>jdbc:mysql://localhost:3306/db_catalogue</value>
> </parameter>
> </ResourceParams>
>
>
> Thanks for help...
>
> Regards,
> Vince
>
--
To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
