You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tapestry.apache.org by Ted Steen <te...@gmail.com> on 2006/05/02 01:38:10 UTC

[Tapernate] Error when trying to use c3p0 connection pooling

I'm trying to switch to c3p0:s connection pooling, but when I do that I get
this error
http://rafb.net/paste/results/W4tsCJ17.html

I'm not doing anything fancy here, I just set c3p0.max_size=100

When I switch back to Hibernates native connection provider it works..
Is there anything I should set in order to get c3p0 to work?

I couldn't find anything on this subject on google, so I'm suspecting
that it is a tapernate specific problem

Cheers!
/ted

---------------------------------------------------------------------
To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tapestry-user-help@jakarta.apache.org


Re: [Tapernate] Error when trying to use c3p0 connection pooling

Posted by Andreas Bulling <sp...@phoenix.hadiko.de>.
On 02. Mai 2006 - 13:26:04, Ted Steen wrote:
| Ok, here are the relevant configuration files.
| By the way.. is there anyone who use MySQL + Tapernate + c3p0?
| Maybe it couldbe MySQL specific?

Yes, me ;) 

After a quick look at your configuration I've found the following
differences to my configuration...

I have:
<property name="hibernate.connection.driver_class" value="org.gjt.mm.mysql.Driver"/>
<property name="hibernate.connection.url" value="jdbc:mysql://localhost/plattform"/>

I don't have:
<property name="hibernate.format_sql" value="true" />
<property name="hibernate.query.substitutions" value="true 1, false 0, yes 'Y', no 'N'" />

Perhaps it's one of these options?

Cheers,
  Andreas

---------------------------------------------------------------------
To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tapestry-user-help@jakarta.apache.org


RE: [Tapernate] Error when trying to use c3p0 connection pooling

Posted by James Carman <ja...@carmanconsulting.com>.
The example application is working.  To rollback a transaction (in my case,
if the message contains "Ni!"), you just use the
TransactionUtils.setRollbackOnly() method (see my EditMessage page for an
example).  Remember, tapernate includes auto-wiring code, so all you have to
do is declare an abstract "getter" for whatever service you want (the return
type has to match the type of a HiveMind service for it to be auto-wired).

-----Original Message-----
From: Andreas Bulling [mailto:andreas@phoenix.hadiko.de] On Behalf Of
Andreas Bulling
Sent: Tuesday, May 02, 2006 8:38 AM
To: Tapestry users
Subject: Re: [Tapernate] Error when trying to use c3p0 connection pooling

| I use the mysql-connector-3.1.12.  I've checked in the changes to
| tapernate-example...

Ah, and I see some new transaction/hibernate stuff, too ;-)
Anything to tell concerning the code - can I try it, does it
work already?

Cheers,
  Andreas

---------------------------------------------------------------------
To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tapestry-user-help@jakarta.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tapestry-user-help@jakarta.apache.org


Re: [Tapernate] Error when trying to use c3p0 connection pooling

Posted by Andreas Bulling <sp...@phoenix.hadiko.de>.
| I use the mysql-connector-3.1.12.  I've checked in the changes to
| tapernate-example...

Ah, and I see some new transaction/hibernate stuff, too ;-)
Anything to tell concerning the code - can I try it, does it
work already?

Cheers,
  Andreas

---------------------------------------------------------------------
To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tapestry-user-help@jakarta.apache.org


Re: [Tapernate] Error when trying to use c3p0 connection pooling

Posted by Ted Steen <te...@gmail.com>.
Yes, I did. But the same error. :/

On 5/2/06, Andreas Bulling <sp...@phoenix.hadiko.de> wrote:
> On 02. Mai 2006 - 14:16:29, Ted Steen wrote:
> | Thanks for your answers!
> |
> | I tried the url jdbc:mysql://localhost/tapestrySandbox but to no avail.. :/
> |
> | James, which version of the connector did you use when you tried MySQL?
> | Also, it would be great if you could commit the mysql code (or just
> | mail me the changes if you don't want to bloat the svn history)
> |
> | Regarding the org.gjt.mm.mysql.Driver vs. com.mysql.jdbc.Driver
> | I read that the org.gjt.mm.mysql are there for backwards compatibility
> | see http://jguru.com/forums/view.jsp?EID=1282327
>
> And I've read somewhere that the folks from Hibernate recommend
> the connector I've mentioned... Anyway, did you try it?
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tapestry-user-help@jakarta.apache.org
>
>


--
/ted

---------------------------------------------------------------------
To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tapestry-user-help@jakarta.apache.org


Re: [Tapernate] Error when trying to use c3p0 connection pooling

Posted by Andreas Bulling <sp...@phoenix.hadiko.de>.
On 02. Mai 2006 - 14:16:29, Ted Steen wrote:
| Thanks for your answers!
| 
| I tried the url jdbc:mysql://localhost/tapestrySandbox but to no avail.. :/
| 
| James, which version of the connector did you use when you tried MySQL?
| Also, it would be great if you could commit the mysql code (or just
| mail me the changes if you don't want to bloat the svn history)
| 
| Regarding the org.gjt.mm.mysql.Driver vs. com.mysql.jdbc.Driver
| I read that the org.gjt.mm.mysql are there for backwards compatibility
| see http://jguru.com/forums/view.jsp?EID=1282327

And I've read somewhere that the folks from Hibernate recommend
the connector I've mentioned... Anyway, did you try it?

---------------------------------------------------------------------
To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tapestry-user-help@jakarta.apache.org


RE: [Tapernate] Error when trying to use c3p0 connection pooling

Posted by James Carman <ja...@carmanconsulting.com>.
Ted,

I use the mysql-connector-3.1.12.  I've checked in the changes to
tapernate-example so you can see an example of how to enable c3p0 with
MySQL.  Just uncomment some stuff in your build.properties (once you copy it
from example-build.properties) and the hivemodule.xml template.  

James



-----Original Message-----
From: Ted Steen [mailto:ted.steen@gmail.com] 
Sent: Tuesday, May 02, 2006 8:16 AM
To: Tapestry users
Subject: Re: [Tapernate] Error when trying to use c3p0 connection pooling

Thanks for your answers!

I tried the url jdbc:mysql://localhost/tapestrySandbox but to no avail.. :/

James, which version of the connector did you use when you tried MySQL?
Also, it would be great if you could commit the mysql code (or just
mail me the changes if you don't want to bloat the svn history)

Regarding the org.gjt.mm.mysql.Driver vs. com.mysql.jdbc.Driver
I read that the org.gjt.mm.mysql are there for backwards compatibility
see http://jguru.com/forums/view.jsp?EID=1282327




On 5/2/06, Andreas Bulling <sp...@phoenix.hadiko.de> wrote:
> On 02. Mai 2006 - 13:26:04, Ted Steen wrote:
> | Ok, here are the relevant configuration files.
> | By the way.. is there anyone who use MySQL + Tapernate + c3p0?
> | Maybe it couldbe MySQL specific?
>
> I forgot to tell you the URL where you can find
> the (by the way recommended) connector:
>
> http://dev.mysql.com/downloads/connector/j/3.1.html
>
> Hope it helps,
>   Andreas
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tapestry-user-help@jakarta.apache.org
>
>


--
/ted

---------------------------------------------------------------------
To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tapestry-user-help@jakarta.apache.org




---------------------------------------------------------------------
To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tapestry-user-help@jakarta.apache.org


Re: [Tapernate] Error when trying to use c3p0 connection pooling

Posted by Ted Steen <te...@gmail.com>.
Thanks for your answers!

I tried the url jdbc:mysql://localhost/tapestrySandbox but to no avail.. :/

James, which version of the connector did you use when you tried MySQL?
Also, it would be great if you could commit the mysql code (or just
mail me the changes if you don't want to bloat the svn history)

Regarding the org.gjt.mm.mysql.Driver vs. com.mysql.jdbc.Driver
I read that the org.gjt.mm.mysql are there for backwards compatibility
see http://jguru.com/forums/view.jsp?EID=1282327




On 5/2/06, Andreas Bulling <sp...@phoenix.hadiko.de> wrote:
> On 02. Mai 2006 - 13:26:04, Ted Steen wrote:
> | Ok, here are the relevant configuration files.
> | By the way.. is there anyone who use MySQL + Tapernate + c3p0?
> | Maybe it couldbe MySQL specific?
>
> I forgot to tell you the URL where you can find
> the (by the way recommended) connector:
>
> http://dev.mysql.com/downloads/connector/j/3.1.html
>
> Hope it helps,
>   Andreas
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tapestry-user-help@jakarta.apache.org
>
>


--
/ted

---------------------------------------------------------------------
To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tapestry-user-help@jakarta.apache.org


Re: [Tapernate] Error when trying to use c3p0 connection pooling

Posted by Andreas Bulling <sp...@phoenix.hadiko.de>.
On 02. Mai 2006 - 13:26:04, Ted Steen wrote:
| Ok, here are the relevant configuration files.
| By the way.. is there anyone who use MySQL + Tapernate + c3p0?
| Maybe it couldbe MySQL specific?

I forgot to tell you the URL where you can find
the (by the way recommended) connector:

http://dev.mysql.com/downloads/connector/j/3.1.html

Hope it helps,
  Andreas

---------------------------------------------------------------------
To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tapestry-user-help@jakarta.apache.org


RE: [Tapernate] Error when trying to use c3p0 connection pooling

Posted by James Carman <ja...@carmanconsulting.com>.
Ted,

I just changed my tapernate-example to use MySQL and it worked fine.  If you
would like, I can check in the changes so you can see it.

James

-----Original Message-----
From: Ted Steen [mailto:ted.steen@gmail.com] 
Sent: Tuesday, May 02, 2006 7:26 AM
To: Tapestry users
Subject: Re: [Tapernate] Error when trying to use c3p0 connection pooling

Ok, here are the relevant configuration files.
By the way.. is there anyone who use MySQL + Tapernate + c3p0?
Maybe it couldbe MySQL specific?


On 5/2/06, Andreas Bulling <sp...@phoenix.hadiko.de> wrote:
> Hi Ted,
>
> to be honest I don't think that this has something to do
> with Tapernate because I'm using Tapernate quite happily
> with Hibernate and c3p0 without any problems.
>
> Can you post your configuration as something rather seems to
> be wrong there IMHO..
>
> Cheers,
>   Andreas
>
> On 02. Mai 2006 - 01:38:10, Ted Steen wrote:
> | I'm trying to switch to c3p0:s connection pooling, but when I do that I
get
> | this error
> | http://rafb.net/paste/results/W4tsCJ17.html
> |
> | I'm not doing anything fancy here, I just set c3p0.max_size=100
> |
> | When I switch back to Hibernates native connection provider it works..
> | Is there anything I should set in order to get c3p0 to work?
> |
> | I couldn't find anything on this subject on google, so I'm suspecting
> | that it is a tapernate specific problem
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tapestry-user-help@jakarta.apache.org
>
>


--
/ted



---------------------------------------------------------------------
To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tapestry-user-help@jakarta.apache.org


Re: [Tapernate] Error when trying to use c3p0 connection pooling

Posted by Ted Steen <te...@gmail.com>.
Ok, here are the relevant configuration files.
By the way.. is there anyone who use MySQL + Tapernate + c3p0?
Maybe it couldbe MySQL specific?


On 5/2/06, Andreas Bulling <sp...@phoenix.hadiko.de> wrote:
> Hi Ted,
>
> to be honest I don't think that this has something to do
> with Tapernate because I'm using Tapernate quite happily
> with Hibernate and c3p0 without any problems.
>
> Can you post your configuration as something rather seems to
> be wrong there IMHO..
>
> Cheers,
>   Andreas
>
> On 02. Mai 2006 - 01:38:10, Ted Steen wrote:
> | I'm trying to switch to c3p0:s connection pooling, but when I do that I get
> | this error
> | http://rafb.net/paste/results/W4tsCJ17.html
> |
> | I'm not doing anything fancy here, I just set c3p0.max_size=100
> |
> | When I switch back to Hibernates native connection provider it works..
> | Is there anything I should set in order to get c3p0 to work?
> |
> | I couldn't find anything on this subject on google, so I'm suspecting
> | that it is a tapernate specific problem
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tapestry-user-help@jakarta.apache.org
>
>


--
/ted

Re: [Tapernate] Error when trying to use c3p0 connection pooling

Posted by Andreas Bulling <sp...@phoenix.hadiko.de>.
Hi Ted,

to be honest I don't think that this has something to do
with Tapernate because I'm using Tapernate quite happily
with Hibernate and c3p0 without any problems.

Can you post your configuration as something rather seems to 
be wrong there IMHO..

Cheers,
  Andreas

On 02. Mai 2006 - 01:38:10, Ted Steen wrote:
| I'm trying to switch to c3p0:s connection pooling, but when I do that I get
| this error
| http://rafb.net/paste/results/W4tsCJ17.html
| 
| I'm not doing anything fancy here, I just set c3p0.max_size=100
| 
| When I switch back to Hibernates native connection provider it works..
| Is there anything I should set in order to get c3p0 to work?
| 
| I couldn't find anything on this subject on google, so I'm suspecting
| that it is a tapernate specific problem


---------------------------------------------------------------------
To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tapestry-user-help@jakarta.apache.org