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]

Reply via email to