Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to setup connection pooling

 
Marsoni Hutao
Greenhorn
Posts: 22
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Firstly, Thank you for Introducing me to this new concept.

Here is a document on using pooling with SQLServer. Actually setting up the pool depends on what web server you are running.


In my webapp, I've 2 different connections, one is incoming i.e. from where the input data comes and the other is outgoing, i.e. where the data is sent to.

I've mentioned these as two different one as the incoming comes from an excel and the outgoing is to SqlServer.

My Question is can I have multiple connection pooling, i.e. one for excel and other for SqlServer.

If you are the server admin and need guidance on setting up the pool, we have other forums where you can get help with the specifics.


Can you please provide me a link to this.

Thanks,
Marsoni
 
J. Kevin Robbins
Bartender
Pie
Posts: 1801
28
Chrome Eclipse IDE Firefox Browser jQuery Linux MySQL Database Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I split this off from the original thread as a change of topic.

You'll only have one connection pool, but you can have multiple data sources that all use the same pool.

To start with, what web server are you running? Tomcat, ISS, Glassfish, Websphere?
 
Marsoni Hutao
Greenhorn
Posts: 22
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm using Tomcat WebServer.
 
Dave Tolls
Ranch Hand
Posts: 2112
16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The first question that leaps into my head is, does an Excel file allow you to have multiple JDBC connections into it at the same time?
 
Marsoni Hutao
Greenhorn
Posts: 22
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
does an Excel file allow you to have multiple JDBC connections into it at the same time?


You can use a DNSLESS connection, only one connection at a time.
 
J. Kevin Robbins
Bartender
Pie
Posts: 1801
28
Chrome Eclipse IDE Firefox Browser jQuery Linux MySQL Database Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You didn't mention the version, so I'll assume 7. Start here. Try not to get overwhelmed by all the configuration options. You can get started with the defaults in most cases and then tweak the settings based on monitoring.

Here is another good read and here is a good example on how to setup and use JNDI once you have the pool setup.

Come back for help as you need it. Good luck.
 
J. Kevin Robbins
Bartender
Pie
Posts: 1801
28
Chrome Eclipse IDE Firefox Browser jQuery Linux MySQL Database Netbeans IDE
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dave Tolls wrote:The first question that leaps into my head is, does an Excel file allow you to have multiple JDBC connections into it at the same time?


That gives me cold chills just thinking about it. I had to write one app that "scraped" data from a spreadsheet. It was ugly. These days I'm on a mission to get everything in DB2 and get rid of all the spreadsheets that are being used as databases. And don't even get me started on all the Access crap that needs to be moved.

We have spreadsheets here that would instill fear into the hearts of most IT people. And if course the people that originally created them are long gone and nobody here knows how to maintain them.

Sorry. Got off-topic on a rant there for moment.
 
Dave Tolls
Ranch Hand
Posts: 2112
16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Marsoni Hutao wrote:
does an Excel file allow you to have multiple JDBC connections into it at the same time?


You can use a DNSLESS connection, only one connection at a time.


Then that's a problem.
You are writing this in a multi-threaded environment (being a webapp).

As with Kevin, I have an inherent dislike for the (ab)use of Excel in this way. Spreadsheets are great for what they do, but they should not be used as a ersatz-database.
They should (IMO) also not be used as an upload source for a DB...but that's another story.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic