É possível criar um pool de conexões com o banco de dados, porém por padrão os parâmetros maxIdle e maxActive,são configurados para o máximo de 7, por questões de desempenho e performance do servidor do banco de dados. O parâmetro maxWait, deverá ser setado para 15000 milisegundos (15 seg) e outros parâmetros são configurados da seguinte forma:

removeAbandoned = true removeAbandonedTimeout = 60

Indicamos que configure a datasource JNDI via painel de controle, pois ela já será criada com as configurações ideais  :

1. Acesse o Painel de Controle e entre com seu login e senha;
2. Em Hospedagem de Sites, clique em Gerenciar hospedagem;
3. Clique em Ferramentas no menu à esquerda;
4. Clique em Contextos JAVA no menu central;
5. Coloque o nome do contexto que deseja;
6. Coloque o nome da datasource;
7. Selecione o banco de dados e coloque a senha do mesmo;
8. Efetue o reinício do servidor JVM dedicado utilizando (tomcat stop/start);

Salientamos que configurações específicas na datasource não podem ser alteradas por questões de desempenho ficando da seguinte forma :

maxActive = "10" maxIdle = "10"  maxWait = "15000"  validationQuery = "select current_date" removeAbandoned = "true"  removeAbandonedTimeout = "30"  logAbandoned = "true"

Para casos envolvendo o MySQL, clique aqui.

Veja também


    Em servidores compartilhados os bancos de dados recebem um nome padronizado pela Locaweb, tal medida foi adotada por medidas administrativas(organização, padronização, controle e etc), pois, com o compartilhamento do servidor seria inviável a personalização de nome de banco de dados, tal personalização pode ser realizada em servidores dedicados

    Servidores Dedicados

    Veja também


    Como efetuar um Backup do banco MySQL via SSH?

    Para efetuar um Backup do banco MySQL via SSH execute os comandos abaixo logo após conectar na área de hospedagem:

    Para bases MySQL 5.1 (bases adquiridas a partir de janeiro de 2008)

    Para fazer backup de todas as tabelas

    mysqldump -h HOST -u LOGIN -p -R --opt BANCO > backup.sql

    Para fazer backup de somente uma tabela

    mysqldump -h HOST -u LOGIN -p -R --opt BANCO TABELA > backup.sql

    Para fazer o backup com procedures e triggers:

    mysqldump -h HOST -u LOGIN -pSENHA --opt --routines --triggers BANCO > backup.sql

    Para bases MySQL até a versão 5.0 (bases adquiridas até dezembro de 2007)

    Para fazer backup de todas as tabelas

    mysqldump -h HOST -u LOGIN -p --opt BANCO > backup.sql

    Para fazer backup de somente uma tabela

    mysqldump -h HOST -u LOGIN -p --opt BANCO TABELA > backup.sql

      • O arquivo .SQL será gerado no nível da estrutura de diretórios em que estiver presente na execução (use o comando pwd para saber o diretório atual).

      Encontrando problemas com acentução dos caracteres utilize:

      Para Europeu Ocidental (Latin1, iso-8859-1), mais comum no Brasil e no ocidente europeu.

      mysqldump -h HOST -u LOGIN -p -R --opt --default-character-set=latin1 BANCO > backup.sql

      Para Unicode (utf-8), internacional, com suporte a vários idiomas, inclusive asiáticos.

      mysqldump -h HOST -u LOGIN -p -R --opt --default-character-set=utf8 BANCO > backup.sql

      Obs: Não se esqueçam de retirar o parâmetro -R caso seja dump de uma base MySQL na versão até 5.0.

      Obs: Caso queira, o script de backup pode ser agendado para execução no “cron”, permitindo que sempre o backup mais atual esteja disponível em sua área.

      Importante: Dependendo do tamanho da sua base de dados, você poderá deparar-se com alguma mensagem de erro referente à perda de conexão ou tempo de CPU excedido, neste caso, crie um chamado no HelpDesk clicando no botão abaixo solicitando o dump (backup) de sua base de dados e informando seu login e a senha dela no campo Dados Sigilosos do chamado que o mesmo será alocado em sua área de FTP.

      Atenção: Vale ressaltar que essa documentação é valida para clientes que possuem hospedagem na plataforma Linux que dispõe do acesso SSH e também pode ser realizado através de um terminal SSH através do Sistema Operacional Linux.

      Veja também como efetuar um Backup do banco MySQL via PhpMyAdmin

      Veja também


      Esse artigo ajudou você?

      96 respostas para “Posso criar um pool de conexões com banco de dados?”

      1. towing vancouver

        One important thing is that when you’re searching for a education loan you may find that you will want a co-signer. There are many conditions where this is correct because you might discover that you do not use a past credit rating so the bank will require that you’ve got someone cosign the borrowed funds for you. Thanks for your post.

        Responder
      2. Mona Fowler

        I’ve been surfing online greater than 3 hours today, but I by no means discovered any fascinating article like yours. It is pretty price sufficient for me. In my view, if all website owners and bloggers made just right content material as you did, the net will be a lot more helpful than ever before.

        Responder
      3. try this site 9janewswatch.com

        I am very happy to read this. This is the kind of manual that needs to be given and not the accidental misinformation that’s at the other blogs. Appreciate your sharing this best doc.

        Responder
      4. Wonda Havas

        you could have a fantastic weblog here! would you wish to make some invite posts on my weblog?

        Responder
      5. read here legal-news-central.com

        Hey just wanted to give you a quick heads up and let you know a few of the pictures aren’t loading correctly. I’m not sure why but I think its a linking issue. I’ve tried it in two different browsers and both show the same results.

        Responder
      6. Visit Website electrician

        Hello there, just became alert to your blog through Google, and found that it’s truly informative. I’m gonna watch out for brussels. I’ll be grateful if you continue this in future. Lots of people will be benefited from your writing. Cheers!

        Responder
      7. click to read 336news.com

        Hey there! This post couldn’t be written any better! Reading this post reminds me of my previous room mate! He always kept chatting about this. I will forward this post to him. Fairly certain he will have a good read. Thank you for sharing!

        Responder
      8. Leslie Greger

        Hey! I simply would like to give an enormous thumbs up for the great info you could have right here on this post. I will likely be coming again to your blog for extra soon.

        Responder
      9. Bio Melt Pro official website

        This web site really has all of the info I needed concerning this subject and didn’t know who to ask.

        Responder
      10. porno

        Hmm is anyone else encountering problems with the pictures on this blog loading? I’m trying to determine if its a problem on my end or if it’s the blog. Any feedback would be greatly appreciated.

        Responder
      11. boubou cuir

        I genuinely enjoy reading on this site, it holds great content. “Beware lest in your anxiety to avoid war you obtain a master.” by Demosthenes.

        Responder
      12. ליווי בישראל

        מילפית שמנ ה מוצצת ומזדיינת חזק ויודעת לפנק את הגבר
        ליווי במרכז

        Responder
      13. Christian Luinstra

        I am typically to running a blog and i really appreciate your content. The article has actually peaks my interest. I am going to bookmark your site and keep checking for brand spanking new information.

        Responder
      14. Jarod Gaisford

        This is very useful suggestions. I have to say I really like reading this article alot. It helps me to turn into better grasp about the subject. It is all well and good produced. I will definitely search for this kind of material incredibly intriguing. Hopefully you can present more one day.

        Responder
      15. ליווי בישראל

        סרטון ביתמ של זוג בו הבחורה רוכבת על הזין של החבר שלה ונהנית
        שירותי ליווי

        Responder
      16. Little Caesars

        Love the blog. I’ll return to see your new content regularly!

        Responder
      17. Rasheeda Mcghaney

        I am a mother looking to chat. I love sucking dick btw hmu

        Responder
      18. שירותי ליווי

        הוא הלך לבקר אבל פתאום הוא ראה איז כוסית האמא וזיין אותה חזק
        שירותי ליווי

        Responder
      19. נערת ליווי

        הוא הצעיר מהחדר ליד אבל בשבילה זה לא מפריע – מילף סקסית בטירוף מזיינת בחור צעיר בסקס אנלי מופרע
        שירותי ליווי במרכז

        Responder
      20. cialis no prescription

        Good day! Do you know if they make any plugins to safeguard against hackers? I’m kinda paranoid about losing everything I’ve worked hard on. Any recommendations?

        Responder
      21. שירותי ליווי

        נכנסו לשירותים ציבוריים והתחילה למצוץ לו עד שהם התחילו להזדיין
        נערות ליווי במרכז

        Responder
      22. Elenore Binker

        I like the efforts you have put in this, regards for all the great articles .

        Responder
      23. נערות ליוויl

        יפנית סקסית בסקס עם פוט פטיש חובה צפייה
        שירותי ליווי במרכז

        Responder
      24. נערת ליווי

        2 זוגות שהשתעממו מהרגיל החליטו לבצע חילופי זוגות וליהנות קצת יותר
        נערות ליווי

        Responder
      25. official website 365planetnews.com

        The very root of your writing whilst appearing reasonable initially, did not settle perfectly with me after some time. Somewhere within the sentences you were able to make me a believer unfortunately just for a while. I however have a problem with your leaps in assumptions and one might do well to help fill in those breaks. In the event that you actually can accomplish that, I will surely end up being fascinated.

        Responder
      26. ליווי בישראל

        עם משקפי צלילה וציוד מתאים בלונדינית סקסית יוצאת לבדוק את יכולות חוסר הנשימה שלה במציצה עמוקה ורטובה במיוחד
        שירותי ליווי במרכז

        Responder
      27. שירותי ליווי

        איטלקיה שווה ביותר מתחילה בלמצוץ זין כמו שצריך ובסוף מקבלת זין עמוק בתחת כמו שהיא אוהבת
        נערות ליווי במרכז

        Responder
      28. anchor 24 hr electrician

        Thank you a lot for giving everyone an extraordinarily superb opportunity to read critical reviews from this website. It’s always so superb and also full of a good time for me personally and my office peers to search your web site no less than thrice per week to find out the latest secrets you will have. And indeed, I’m actually happy with the fabulous techniques served by you. Selected 3 tips in this posting are surely the most beneficial we have ever had.

        Responder
      29. gaming news

        This blog was… how do you say it? Relevant!! Finally I have found something that helped me. Thanks.

        Responder
      30. Two Sided Tape For Dresses

        I am constantly invstigating online for ideas that can benefit me. Thanks!

        Responder
      31. Pain Cream with THC

        Hi there, You have done a great job. I will certainly digg it and personally suggest to my friends. I’m confident they will be benefited from this website.

        Responder
      32. נערות ליוויl

        יפנית כוסית נדפקת בתחת ושם גם החבר שלה גומר לה
        נערות ליווי

        Responder
      33. Sterling Wildberger

        I don’t know if it’s just me or if perhaps everyone else encountering problems with your blog. It seems like some of the written text within your content are running off the screen. Can someone else please provide feedback and let me know if this is happening to them as well? This could be a problem with my internet browser because I’ve had this happen previously. Many thanks

        Responder
      34. ליווי בישראל

        מילפית עם שדיים גדולים בגאנג באנג עם 3 גברים שחורים שנכנסים אליה מכל חור אפשרי
        שירותי ליווי

        Responder
      35. Synapse XT

        Hi, I do believe this is a great web site. I stumbledupon it 😉 I may return once again since i have bookmarked it. Money and freedom is the greatest way to change, may you be rich and continue to help others.

        Responder
      36. Playset installation

        Hi my loved one! I want to say that this post is awesome, nice written and include approximately all important infos. I would like to see more posts like this.

        Responder
      37. plumbers near me Click Here

        Howdy! Do you use Twitter? I’d like to follow you if that would be ok. I’m absolutely enjoying your blog and look forward to new posts.

        Responder
      38. JBO.com

        Pretty! This was an incredibly wonderful article. Thank you for supplying these details.

        Responder
      39. Solar Sean

        Thanks for writing this awesome article. I’ll be back to view more.

        Responder
      40. Ted Siebens

        Having read this I believed it was rather enlightening. I appreciate you taking the time and effort to put Daftar Judi Bola Mix Parlay this short article together. I once again find myself spending way too much time both reading and commenting

        Responder
      41. Uric Acid In Feet

        Thanks for ones marvelous posting! I genuinely enjoyed reading it, you may be a great author.I will make certain to bookmark your blog and will eventually come back from now on. I want to encourage you continue your great job, have a nice holiday weekend!

        Responder
      42. Lawanda Billick

        Absolutely pent subject matter, appreciate it for selective information .Tracie Brinkley

        Responder
      43. 출장 안마

        Hello! I could have sworn I챠ve visited this blog before but after going through many of the posts I realized it챠s new to me. Anyhow, I챠m certainly delighted I discovered it and I챠ll be bookmarking it and checking back regularly!

        Responder
      44. 죠스출장안마

        I blog often and I really appreciate your information. This great article has truly peaked my interest. I am going to take a note of your blog and keep checking for new information about once per week. I subscribed to your Feed as well.

        Responder
      45. Reputable Roofing Companies Near Me

        Please let me know if you’re looking for a article writer for your weblog. You have some really good articles and I feel I would be a good asset. If you ever want to take some of the load off, I’d absolutely love to write some material for your blog in exchange for a link back to mine. Please send me an email if interested. Cheers!

        Responder
      46. female vibrator

        My brother recommended I might like this blog. He was entirely right. This post actually made my day. You cann’t imagine simply how much time I had spent for this information! Thanks!

        Responder
      47. ProstaStream supplement

        This is a topic which is near to my heart… Many thanks! Exactly where can I find the contact details for questions?

        Responder
      48. plus size stockings

        you’ve gotten an amazing weblog right here! would you like to make some invite posts on my blog?

        Responder
      49. best lingerie

        Wonderful paintings! This is the kind of info that should be shared around the net. Shame on Google for not positioning this put up higher! Come on over and consult with my web site . Thank you =)

        Responder
      50. Non Steroidal Anti Inflammatory Drugs For Dogs

        I loved as much as you will receive carried out right here. The sketch is attractive, your authored material stylish. nonetheless, you command get got an nervousness over that you wish be delivering the following. unwell unquestionably come further formerly again as exactly the same nearly very often inside case you shield this increase.

        Responder
      51. SamuelChorp

        2 זוגות שהשתעממו מהרגיל החליטו לבצע חילופי זוגות וליהנות קצת יותר
        https://www.israelxclub.co.il/נערות-ליווי-בבת-ים/

        Responder
      52. נערת ליווי

        בחורה עמוה מספיק לה רק מכונה – לא צריכה כלום חוץ מזה לגמירה רטובה
        נערות ליווי בתל אביב

        Responder
      53. Facebook Video marketing guy

        I really enjoyed this blog post. You are an excellent writer. I’ll be back to see more! Thanks!

        Responder
      54. What Can I Give My Dog For Joint Stiffness

        What’s Going down i am new to this, I stumbled upon this I’ve found It positively helpful and it has aided me out loads. I’m hoping to give a contribution & aid other users like its aided me. Great job.

        Responder
      55. Skincell Pro Costs

        Very good blog post. I certainly appreciate this website. Keep it up!

        Responder
      56. נערות ליווי בתל אביבי

        זוג צעיר מזדיין במלון בלי לדעת שיש מצלמה
        נערות ליווי בחיפה

        Responder
      57. Girl Scout Cookies Extreme Feminized Cannabis Seeds

        I seriously love your site.. Excellent colors & theme. Did you build this website yourself? Please reply back as I’m trying to create my own site and would like to learn where you got this from or what the theme is called. Thank you.

        Responder
      58. Keven Vandawalker

        Having read this I believed it was extremely enlightening. I appreciate you finding the time and energy to put cara perhitungan kartu baccarat this information together. I once again find myself personally spending a lot of time both reading and leaving comments

        Responder
      59. דירות דיסקרטיות ברמתן גן

        https://www.israelxclub.co.il/d7a0d7a2d7a8d795d7aa-d79cd799d795d795d799-d791d790d799d79cd7aa-d7a9d799d7a8d795d7aad799-d79cd799d795d795d799-d791d790d799d79cd7aa/ שלום לכולם יש פה מספר קישורים שאני מאוד רוצה להמליץ לכולם כי באמת יש פה מידע מצויין עבור שירותי עיסוי בישראל

        Responder
      60. free horror

        After I originally left a comment I seem to have clicked the -Notify me when new comments are added- checkbox and now each time a comment is added I recieve four emails with the exact same comment. There has to be a way you can remove me from that service? Many thanks.

        Responder
      61. Ta Giel

        During my mission on the web, We seen this blog submit, It is rather in depth and I think you ought to acknowledge this particular remark. I need money too

        Responder
      62. Affiliate Trainer Devin

        Awesome blog post! I’ll be back to see your next article! Thanks!

        Responder
      63. additional hints

        I simply want to mention I am very new to blogging and truly loved this blog. Almost certainly I’m going to bookmark your blog post . You amazingly have impressive articles. Kudos for revealing your blog site.

        Responder
      64. Maya Leuthauser

        i love the smile of Rachel Bilson, i got a huge crush on her*

        Responder
      65. Pest Control Sean

        If you are searching for the ultimate pest control company, look no more. These guys dominate!

        Responder
      66. Pretty Gaming

        Good site you have here.. It’s hard to find quality writing like yours nowadays. I seriously appreciate people like you! Take care!!

        Responder
      67. 슬롯 머신

        Best view i have ever seen !

        Responder
      68. Errol Rosborough

        i always like Superman and of course the TV Series Smallville, Lana Lang is very pretty too;;

        Responder
      69. DC white glove delivery

        I’m really impressed with your writing skills and also with the layout on your blog. Is this a paid theme or did you customize it yourself? Either way keep up the excellent quality writing, it is rare to see a nice blog like this one these days..

        Responder
      70. Reasons For Hip Pain

        When I initially commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get three e-mails with the same comment. Is there any way you can remove me from that service? Cheers!

        Responder
      71. Ben Soldano

        Outstanding post, I think blog owners should larn a lot from this blog its really user genial .

        Responder
      72. Shawna Samperi

        Good – I should certainly pronounce, impressed with your site. I had no trouble navigating through all the tabs and related information ended up being truly easy to do to access. I recently found what I hoped for before you know it in the least. Quite unusual. Is likely to appreciate it for those who add forums or anything, website theme . a tones way for your client to communicate. Nice task.

        Responder
      73. Fincci Pneus VTT à vendre

        A further issue is really that video gaming has become one of the all-time most significant forms of excitement for people spanning various ages. Kids participate in video games, and also adults do, too. The XBox 360 has become the favorite video games systems for many who love to have a lot of games available to them, in addition to who like to relax and play live with other people all over the world. Many thanks for sharing your opinions.

        Responder
      74. Gout In Foot Treatment

        Wow, marvelous blog format! How long have you been blogging for? you made running a blog look easy. The full look of your website is wonderful, as smartly as the content!

        Responder
      75. which tax credits are refundable 2019

        Hello there! Would you mind if I share your blog with my facebook group? There’s a lot of folks that I think would really enjoy your content. Please let me know. Cheers

        Responder
      76. 출장마사지

        This website definitely has all the info I wanted concerning this subject and didnít know who to ask.

        Responder
      77. 슬롯

        Best view i have ever seen !

        Responder
      78. charities that accept car donations directly

        Wow, amazing blog layout! How long have you been blogging for?
        you made blogging look easy. The overall look of your web site is excellent,as wel as the content.

        Responder
      79. pier and beam foundation contractors

        Thanks so much for giving everyone an exceptionally nice opportunity to read from this site. It really is so sweet and also packed with a good time for me personally and my office colleagues to search your website more than 3 times a week to see the new things you will have. Of course, I am also always impressed considering the magnificent hints served by you. Certain 2 points on this page are in reality the most effective I’ve ever had.

        Responder
      80. 마사지알바

        Hey, usually are you too great? Your own writing widens my understanding. Give thanks to you.

        Responder
      81. VitalFlow Ingredients side effects

        When I originally commented I appear to have clicked on the -Notify me when new comments are added- checkbox and now every time a comment is added I receive 4 emails with the same comment. Is there a means you are able to remove me from that service? Thanks.

        Responder
      82. plumbing companies near me my latest blog post

        You made a number of nice points there. I did a search on the topic and found mainly persons will agree with your blog.

        Responder
      83. home warranty companies

        Great looking website. Assume you did a great
        deal of your very own coding.

        Responder
      84. נערות ליווי

        בחורה צעירה ובלונדינית מקבלת בתחת בסקס אנאלי סוער – גמישה במיוחד ויודעת את העבודה
        נערות ליווי באילת

        Responder
      85. porno

        I really enjoy examining on this website, it has fantastic articles. “Beware lest in your anxiety to avoid war you obtain a master.” by Demosthenes.

        Responder
      86. Pool table refelting

        One thing is always that one of the most widespread incentives for using your credit cards is a cash-back as well as rebate provision. Generally, you’re going to get 1-5 back on various acquisitions. Depending on the card, you may get 1 in return on most expenditures, and 5 in return on buying made at convenience stores, filling stations, grocery stores and ‘member merchants’.

        Responder
      87. Bariatric Multivitamin With Iron Chewable

        Hey very nice web site!! Man .. Excellent .. Amazing .. I’ll bookmark your blog and take the feeds also…I’m happy to find numerous useful info here in the post, we need work out more strategies in this regard, thanks for sharing. . . . . .

        Responder
      88. home renovation ideas pictures

        Hey there! I know this is somewhat off topic but I was wondering if you knew where I could locate a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m having difficulty finding one? Thanks a lot!

        Responder
      89. that site

        I just want to say I am beginner to blogging and site-building and truly loved this blog site. Most likely I’m likely to bookmark your site . You definitely come with fabulous stories. Many thanks for sharing your web site.

        Responder
      90. 9 tendencias de marketing digital

        Very nice post and right to the point. I don’t know if this is actually the best place to ask but do you people have any thoughts on where to employ some professional writers? Thanks 🙂

        Responder
      91. alberta car towing

        I have seen a great deal of useful elements on your web page about pc’s. However, I’ve got the view that laptops are still not quite powerful sufficiently to be a option if you normally do jobs that require many power, such as video editing and enhancing. But for web surfing, statement processing, and the majority of other prevalent computer functions they are fine, provided you can’t mind small screen size. Many thanks sharing your thinking.

        Responder
      92. Elliptical assembly service

        I gotta bookmark this web site it seems very beneficial handy

        Responder
      93. Marilyn Gomoran

        I just want to tell you that I’m beginner to blogging and site-building and absolutely liked your blog site. Very likely I’m planning to bookmark your site . You certainly come with exceptional posts. Thanks for revealing your website page.

        Responder

      Comente sobre este conteúdo! Escreva o que pensa, complemente, vamos discutir. O conhecimento é livre!