• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Problem with default connection pool in Jforum

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
com.mob.forum.PooledConnection - Sorry custom code... can't really say anything definitive.

But if you app uses DataSources with no problems, it should work.

A last alternative would be to use the SimpleConnection code which opens a separate connection for each action. Much slower/more overhead.. but if it works...




[originally posted on jforum.net by monroe]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi
Jforum rockssssssssssssss............................

I succesfully integrated Jforum with my application and everything is fine except the problem with connection pool.

In general we all are using

database.connection.implementation = com.mob.forum.PooledConnection
database.datasource.name = java:/MySqlDS
database.connection.implementation = com.mob.forum.PooledConnection
database.datasource.name = java:/MySqlDS


This connection is breaking after a few milliseconds as set in

database.ping.delay=<time in seconds>

So i am planning to switch to container managed datasource with connection pools.

Way i am going to do it is:
database.connection.implementation =com.mob.forum.DataSourceConnection
database.datasource.name = java:comp/env/jdbc/TestDB

And creating JNDI stuff with datasource TestDB.


Can any one let me know if there are any better ways to handle this issue.

Regards
GregJhonson

[originally posted on jforum.net by gregjhonson]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Way i am going to do it is:
database.connection.implementation =com.mob.forum.DataSourceConnection
database.datasource.name = java:comp/env/jdbc/TestDB
[originally posted on jforum.net by BariyaB]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hey Monroe,
thanks for your reply............
Its not custom code its the same code given in Jofurm source. I just renamed the package from net.jforum to com.mob.forum.

Its just because of code merge. I didnt touch any piece of code.

Now please tell me the best solution and why Jforum is designed such that there is a connection issue with database???


Regards
Greg
[originally posted on jforum.net by gregjhonson]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Is Jforum.net is using the same default stuff for connection pool

I dont think so


can you guys please throw some light on it


[originally posted on jforum.net by gregjhonson]
 
Consider Paul's rocket mass heater.
reply
    Bookmark Topic Watch Topic
  • New Topic