Amit, Is the JAR containing the com.p6spy.engine.spy.P6SpyDriver class in Tomcat's lib directory?
Thanks, David On Wed, Feb 25, 2009 at 5:28 AM, Amit Kumar Verma <[email protected]>wrote: > > Hi > all, > Boot.scala is costomised for jndi connection. Web.xml is also correct. > I am using apache-tomcat -6.0.10 and have context like this > - > <Resource name="jdbc/mysqlDS" > auth="Container" > type="javax.sql.DataSource" > driverClassName="com.p6spy.engine.spy.P6SpyDriver" > url="jdbc:postgresql://192.168.0.30:5000/somedbname" > username="someusername" > password="somepassword" > maxActive="4" > maxIdle="0" > maxWait="11000" > / > > > I have p6spy.jar both in my lib and endorsed folder of tomcat, and > even in lib of project but I am not able to connect to the postgre db. > I am getting following error > org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC > driver class 'com.p6spy.engine.spy.P6SpyDriver' > at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource > (BasicDataSource.java:766) > at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection > (BasicDataSource.java:540) > at bootstrap.liftweb.DBVendor$.newConnection(Boot.scala:40) > at net.liftweb.mapper.DB$$anonfun$2.apply(DB.scala:70) > at net.liftweb.mapper.DB$$anonfun$2.apply(DB.scala:70) > at net.liftweb.util.Full.flatMap(Can.scala:259) > at net.liftweb.mapper.DB$.newConnection(DB.scala:70) > at net.liftweb.mapper.DB$.getConnection(DB.scala:87) > at net.liftweb.mapper.DB$.use(DB.scala:241) > at net.liftweb.mapper.MetaMapper$class.findMapDb > (MetaMapper.scala:158) > at com.vtech.travelmerchant.model.MLoginMapper$.findMapDb > (MLoginMapper.scala:7) > at net.liftweb.mapper.MetaMapper$class.findAll > (MetaMapper.scala:136) > at com.vtech.travelmerchant.model.MLoginMapper$.findAll > (MLoginMapper.scala:7) > at com.vtech.travelmerchant.snippet.login.loginUser$1 > (login.scala:39) > at com.vtech.travelmerchant.snippet.login$$anonfun$getLogin > $1.apply(login.scala:44) > at com.vtech.travelmerchant.snippet.login$$anonfun$getLogin > $1.apply(login.scala:44) > at net.liftweb.http.S$NFuncHolder$$anonfun$apply$51.apply > (S.scala:644) > at net.liftweb.http.S$NFuncHolder$$anonfun$apply$51.apply > (S.scala:644) > at scala.List.map(List.scala: > 734) > please help me, where I am going wrong. > > > > -- Lift, the simply functional web framework http://liftweb.net Beginning Scala http://www.apress.com/book/view/1430219890 Follow me: http://twitter.com/dpp Git some: http://github.com/dpp --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Lift" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/liftweb?hl=en -~----------~----~----~----~------~----~------~--~---
