Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Java > jdbc/mypool webserver 7

Reply
Thread Tools

jdbc/mypool webserver 7

 
 
gert
Guest
Posts: n/a
 
      10-04-2007
This is how my sun-web.xml looks like

{code}<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sun-web-app PUBLIC "-//Sun Microsystems, Inc.//DTD
Application Server 9.0 Servlet 2.5//EN" "http://www.sun.com/software/
appserver/dtds/sun-web-app_2_5-0.dtd">
<sun-web-app error-url="">
<context-root>/warTest</context-root>
<resource-ref>
<res-ref-name>jdbc/mypool</res-ref-name>
<jndi-name>jdbc/mysql</jndi-name>
</resource-ref>
</sun-web-app>{code}

and this is how my code looks like

http://appwsgi.googlecode.com/svn/tr...ses/Query.java

Now how do i actually make a mysql pool on a webserver 7

 
Reply With Quote
 
 
 
 
gert
Guest
Posts: n/a
 
      10-04-2007
On Oct 4, 7:16 am, gert <(E-Mail Removed)> wrote:
> This is how my sun-web.xml looks like
>
> {code}<?xml version="1.0" encoding="UTF-8"?>
> <!DOCTYPE sun-web-app PUBLIC "-//Sun Microsystems, Inc.//DTD
> Application Server 9.0 Servlet 2.5//EN" "http://www.sun.com/software/
> appserver/dtds/sun-web-app_2_5-0.dtd">
> <sun-web-app error-url="">
> <context-root>/warTest</context-root>
> <resource-ref>
> <res-ref-name>jdbc/mypool</res-ref-name>
> <jndi-name>jdbc/mysql</jndi-name>
> </resource-ref>
> </sun-web-app>{code}
>
> and this is how my code looks like
>
> http://appwsgi.googlecode.com/svn/tr...ses/Query.java
>
> Now how do i actually make a mysql pool on a webserver 7


wait a minute i found something, i get back to you if it doesn't
work

http://blogs.sun.com/jyrivirkki/entr...ith_web_server

 
Reply With Quote
 
 
 
 
gert
Guest
Posts: n/a
 
      10-04-2007
On Oct 4, 7:22 am, gert <(E-Mail Removed)> wrote:
> On Oct 4, 7:16 am, gert <(E-Mail Removed)> wrote:
>
> > This is how my sun-web.xml looks like

>
> > {code}<?xml version="1.0" encoding="UTF-8"?>
> > <!DOCTYPE sun-web-app PUBLIC "-//Sun Microsystems, Inc.//DTD
> > Application Server 9.0 Servlet 2.5//EN" "http://www.sun.com/software/
> > appserver/dtds/sun-web-app_2_5-0.dtd">
> > <sun-web-app error-url="">
> > <context-root>/warTest</context-root>
> > <resource-ref>
> > <res-ref-name>jdbc/mypool</res-ref-name>
> > <jndi-name>jdbc/mysql</jndi-name>
> > </resource-ref>
> > </sun-web-app>{code}

>
> > and this is how my code looks like

>
> >http://appwsgi.googlecode.com/svn/tr...ses/Query.java

>
> > Now how do i actually make a mysql pool on a webserver 7

>
> wait a minute i found something, i get back to you if it doesn't
> work
>
> http://blogs.sun.com/jyrivirkki/entr...ith_web_server


what does this mean ?

PWC4216: Name mysql is not bound in this Context

 
Reply With Quote
 
gert
Guest
Posts: n/a
 
      10-04-2007
On Oct 4, 8:46 am, gert <(E-Mail Removed)> wrote:
> On Oct 4, 7:22 am, gert <(E-Mail Removed)> wrote:
>
>
>
> > On Oct 4, 7:16 am, gert <(E-Mail Removed)> wrote:

>
> > > This is how my sun-web.xml looks like

>
> > > {code}<?xml version="1.0" encoding="UTF-8"?>
> > > <!DOCTYPE sun-web-app PUBLIC "-//Sun Microsystems, Inc.//DTD
> > > Application Server 9.0 Servlet 2.5//EN" "http://www.sun.com/software/
> > > appserver/dtds/sun-web-app_2_5-0.dtd">
> > > <sun-web-app error-url="">
> > > <context-root>/warTest</context-root>
> > > <resource-ref>
> > > <res-ref-name>jdbc/mypool</res-ref-name>
> > > <jndi-name>jdbc/mysql</jndi-name>
> > > </resource-ref>
> > > </sun-web-app>{code}

>
> > > and this is how my code looks like

>
> > >http://appwsgi.googlecode.com/svn/tr...ses/Query.java

>
> > > Now how do i actually make a mysql pool on a webserver 7

>
> > wait a minute i found something, i get back to you if it doesn't
> > work

>
> >http://blogs.sun.com/jyrivirkki/entr...ith_web_server

>
> what does this mean ?
>
> PWC4216: Name pool is not bound in this Context


This are all my conf and servlet files

http://appwsgi.googlecode.com/svn/trunk/sun/sun-web.xml
http://appwsgi.googlecode.com/svn/trunk/sun/web.xml
http://appwsgi.googlecode.com/svn/trunk/server.xml (part of it)
http://appwsgi.googlecode.com/svn/tr...ses/Query.java

 
Reply With Quote
 
gert
Guest
Posts: n/a
 
      10-05-2007
http://forum.java.sun.com/thread.jsp...06501&#9906501

Actually I think I am finally getting the picture here what is going
on.

The driver issue was caused by a second driver located inside my web/
lib folder of the web application it self that couldn't be removed
without stopping the service manually. After removing and starting the
service again I got a pool of mysql connections.

But my pool runs out of connections resulting in a "RSR0009: Resource
not available for pool [jdbc/mysql]. Wait-time expired" error

So my servlet code has some issues I think ?

http://appwsgi.googlecode.com/svn/tr...ses/Query.java

Ps Maybe I also need to put some extra properties that will do some
sort of garbage collection on my connections ?

 
Reply With Quote
 
gert
Guest
Posts: n/a
 
      10-05-2007
On Oct 5, 5:35 am, gert <(E-Mail Removed)> wrote:
> http://forum.java.sun.com/thread.jspa?messageID=9906501
>
> Actually I think I am finally getting the picture here what is going
> on.
>
> The driver issue was caused by a second driver located inside my web/
> lib folder of the web application it self that couldn't be removed
> without stopping the service manually. After removing and starting the
> service again I got a pool of mysql connections.
>
> But my pool runs out of connections resulting in a "RSR0009: Resource
> not available for pool [jdbc/mysql]. Wait-time expired" error
>
> So my servlet code has some issues I think ?
>
> http://appwsgi.googlecode.com/svn/tr...ses/Query.java
>
> Ps Maybe I also need to put some extra properties that will do some
> sort of garbage collection on my connections ?


works now i think

http://forum.java.sun.com/thread.jspa?threadID=5222730


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
What files to upload to webserver? James Walker ASP .Net 1 07-31-2004 05:11 AM
Forbidden Message, when accessing .pl files from Java Webserver Murari Perl 3 04-06-2004 05:38 PM
Micro Webserver Fred Atkinson Cisco 0 02-13-2004 11:37 PM
Force Ip Address to webserver Travis Best Cisco 2 12-13-2003 07:04 AM
PIX 515E and Windows Webserver w/ multiple IPs on single NIC Gilbert T. Gutierrez, Jr. Cisco 0 10-21-2003 10:41 PM



Advertisments