sql error when deploying to remote server
hi,
am using studio creator 2 and trying to deploy to an application server 8.1 .
am using mysql database in my application, so i configured the datasource of the remote server to be default and i copied the mysql connetor .jar and DriverAdapter.jar to ../lib/ of the remote server but i get the folowing error at deployment:
com.sun.rave.web.ui.appbase.ApplicationException: org.apache.jasper.JasperException: java.sql.SQLException: Error in allocating a connection. Cause: Class name is wrong or classpath is not set for : com.sun.sql.datasource.DriverAdapter
com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.destroy(ViewHandlerImpl.java: 601)
com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.renderView(ViewHandlerImpl.ja va:316)
com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87 )
com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:221)
com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:249)
java.security.AccessController.doPrivileged(Native Method)
javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:282)
org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:165)
java.security.AccessController.doPrivileged(Native Method)
com.sun.rave.web.ui.util.UploadFilter.doFilter(UploadFilter.java:194)
The data source connection pool on the remote server has com.sun.sql.datasource.DriverAdapter as its datasource class name and as its resource type :javax.sql.dataSource
please help!
Thanks in advance,
Message was edited by:
Insighter
Message was edited by:
Insighter
