Hi,

Try to use validationQuery="select 1".

By doing this, when you ojb before a connection be returned by the
connection pool it will be tested using this query, i.e, if connection
is down it is removed from pool and another (fresh one) is created.

I think this will solve your problem.

 
-----Original Message-----
From: Ramon Cano Granizo [mailto:[EMAIL PROTECTED] 
Sent: quarta-feira, 12 de Novembro de 2003 8:59
To: OJB Users List
Subject: ojb Error in MySQL 

Hello,
     i'm using obj-rc4 and MySQL4 whit tomcat 3.3 and when i start the
server, everything goes right.

    The problem comes making a request 8 hours after the server is
runnig, the applications wait a while and it seems it's making
something, but then throws a java.lang.StackOverFlowException, and i
can't see any log,

here is the repository_database,


  <jdbc-connection-descriptor
        jcd-alias="RuraliaMySQL"
        default-connection="true"
        platform="MySQL"
        jdbc-level="2.0"
        driver="com.mysql.jdbc.Driver"
        protocol="jdbc"
        subprotocol="mysql"
        dbalias="//localhost:3306/ruralia2?autoReconnect=true"
        username="root"
        password=""
        batch-mode="false"
   useAutoCommit="2"
   ignoreAutoCommitExceptions="false"        
   >
  

       <connection-pool
            maxActive="21"
            validationQuery="" /



perhaps is the version of the driver?

anyone can help me?


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to