Hi,
try to set also the following:
jdbc-level="3.0"
driver="com.mysql.jdbc.Driver"
and use the newest mysql JDBC driver
cheers,
danilo
Armin Waibel wrote:
Hi Marcel,
Marcel Souza wrote:
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???
Could you please post the whole stack trace - I can't find the root
exception?
In your jdbc-connection-descriptor you set:
> dbms=MySQL
please try to replace this by
platform="MySQL"
For example the my local mapping for mysql look like this:
<jdbc-connection-descriptor
jcd-alias="default"
default-connection="true"
platform="MySQL"
jdbc-level="2.0"
driver="org.gjt.mm.mysql.Driver"
protocol="jdbc"
subprotocol="mysql"
dbalias="//localhost:3306/ojb"
username="root"
password=""
batch-mode="false"
useAutoCommit="2"
ignoreAutoCommitExceptions="false"
>
regards,
Armin
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=600000, 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]