aspose file tools*
The moose likes JDBC and the fly likes datasource for mysql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "datasource for mysql" Watch "datasource for mysql" New topic
Author

datasource for mysql

divya kundapur
Ranch Hand

Joined: Aug 21, 2007
Posts: 110
Hi,

I m using struts1.2.9, tomcat 6 and mysql. I m trying to establish connection pooling and have done the following

in META-INF/context.xml

<Context path="" reloadable="false">
<Resource driverClassName="com.mysql.jdbc.Driver" maxActive="40" maxIdle="5" maxWait="5000" minEvictableIdleTimeMillis="30000" name="jdbc/mydB" password="root123" testOnBorrow="true" testWhileIdle="true" type="javax.sql.DataSource" url="jdbc:mysql://localhost:3306/test?autoReconnect=true&zeroDateTimeBehavior=convertToNull" username="root"/>
<WatchedResource>WEB-INF/web.xml</WatchedResource>
</Context>

wrote a java class



when i try to open db connection i m getting null pointer exception.. What else needs to be configured to get this working. any ideas are welcome.

Thank you


SCJP - 5.0
amit punekar
Ranch Hand

Joined: May 14, 2004
Posts: 512
Hi,
I am not sure where in you code you are getting the NPE.
But the code below looks wrong, probably you can correct it and check .

Line 1 seems wrong and will fetch the resource that is DataSource and not the Context.
Instead you should just have something like

Where datasource string can be JNDI Name of the datasource. In your case "java:comp/env/jdbc/mydB".



Regards,
Amit
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: datasource for mysql