I tried your suggestions but unfortunatelly it did not work. :(
Thanks even though.
intl lang='pt_BR'
Carlos,
Estou usando OJB em conjunto com portlets.
Tudo tava funcionando bem em meus testes com o pluto + OJB + mysql.
Ai quando coloquei no portal definitivo liferay + OJB + mysql não funcionou
mais!
To achando que é alguma incompatibilidade do liferay com mysql se bem que
nao deveria dar problema... É muito estranho, pq quando a base é oracle
funciona.
Bem, muito obrigado pela sua ajuda, grande abraco,
marcel.
- Original Message -
From: Edson Carlos Ericksson Richter [EMAIL PROTECTED]
To: OJB Users List ojb-user@db.apache.org
Sent: Tuesday, May 16, 2006 2:20 PM
Subject: Re: Error in beginTransaction!
I don't know if this affects you, but I have serious trouble with
maxIdle 2... So I always set it to 2 or greather...
Since you configured to use TestOnBorrow, check query you are using to
make this test. I use something like select 1 from DUAL in Oracle
databases, and select 1 in MS SQL. I don't know what you can do in
MySQL, but choose one very fast, because it could has heavy impact on
your app later...
intl lang='pt_BR'
Olá!
Marcel, eu trabalho com o OJB a uns 4 anos... e não tenho problemas com
beginTransaction. Porém, com o SapDB, notadamente, eu tinha problemas
para obter conexões se eu deixasse o parametro maxIdle = 1 ou maxIdle =
0... E o SapDB também tinha o péssimo hábito de fechar minhas conexões e
não re-abrí-las. Então, eu sempre usei maxIdle = 2, e TestOnBorrow=true
e ainda a query que eu usava para o teste (que não ví na tua
configuração) era select 1 from DUAL, e no MS SQL é simplesmente
select 1.
Eu até tinha esquecido deste parametro (maxIdle), e não mudei quando
migrei de SapDB para Oracle e posteriormente para MS SQL...
Espero que isto ajude.
/intl
Richter
Marcel Souza escreveu:
Hello folks,
I am stucked in a problem using OJB.
I am trying to use MySQL and OJB but it always happens an error during
broker.beginTransaction() that says Can't lookup a connection.
Anyone has a sugestion to solve it???
Thanks in advance, Marcel.
15:33:01,390 INFO [ObjectCacheFactory] Start creating new ObjectCache
instance
15:33:01,390 INFO [ObjectCacheFactory] Default ObjectCache class was
org.apache
.ojb.broker.cache.ObjectCacheDefaultImpl
15:33:01,390 INFO [CacheDistributor] Use property
'descriptorBasedCaches' is se
t 'false'
15:33:01,390 INFO [ObjectCacheFactory] Instantiate new
org.apache.ojb.broker.ca
che.CacheDistributor class object
15:33:01,390 INFO [ObjectCacheFactory] New ObjectCache instance was
created
15:33:01,390 INFO [ConnectionFactoryPooledImpl] Create new connection
pool:org.
[EMAIL PROTECTED]
jcd-alias=mysql
default-connection=false
dbms=MySQL
jdbc-level=2.0
driver=com.mysql.jdbc.Driver
protocol=jdbc
sub-protocol=mysql
db-alias=//localhost:3306/lportal
user=root
password=*
eager-release=false
ConnectionPoolDescriptor={whenExhaustedAction=0, maxIdle=-1,
maxActive=21, max
Wait=5000, removeAbandoned=false, numTestsPerEvictionRun=10,
testWhileIdle=false
, minEvictableIdleTimeMillis=60, testOnReturn=false,
logAbandoned=false, rem
oveAbandonedTimeout=300, timeBetweenEvictionRunsMillis=-1,
testOnBorrow=true}
batchMode=false
useAutoCommit=AUTO_COMMIT_SET_TRUE_AND_TEMPORARY_FALSE
ignoreAutoCommitExceptions=false
sequenceDescriptor=null
]
15:33:01,390 INFO [STDOUT] javax.portlet.PortletException: Erro
DoViewPadrao -
Can't lookup a connection
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]