permaculture playing cards*
The moose likes BEA/Weblogic and the fly likes Error with creating JDBC Data Source (Weblogic 9.2) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "Error with creating JDBC Data Source (Weblogic 9.2)" Watch "Error with creating JDBC Data Source (Weblogic 9.2)" New topic
Author

Error with creating JDBC Data Source (Weblogic 9.2)

Javian Berts
Greenhorn

Joined: May 08, 2009
Posts: 15
I am trying to configure a data source in WL 9.2 from the admin console.
The data source is supposed to point to a MS SQL 2005 Server

After I filled up all the necessary details to create a new datasource and hit the "Test Configuration" button in the admin console, I got this error: "Cannot load driver: com.microsoft.jdbc.sqlserver.SQLServerDriver".

I have also copied the sqljdbc.jar file to the %WL_HOME%\server\lib\ directory but that did not help either.


The following is the error printed in the AdminServer.log

####<Jun 15, 2011 4:24:45 PM GMT+08:00> <Error> <Console> <AdobeTest-2> <AdminServer> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <weblogic> <> <> <1308126285776> <BEA-240003> <Console encountered the following error java.lang.ClassNotFoundException: Cannot load driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
at com.bea.console.utils.jdbc.JDBCUtils.testConnection(JDBCUtils.java:500)
at com.bea.console.actions.jdbc.datasources.createjdbcdatasource.CreateJDBCDataSource.testConnectionConfiguration(CreateJDBCDataSource.java:369)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.beehive.netui.pageflow.FlowController.invokeActionMethod(FlowController.java:869)
at org.apache.beehive.netui.pageflow.FlowController.getActionMethodForward(FlowController.java:808)
at org.apache.beehive.netui.pageflow.FlowController.internalExecute(FlowController.java:477)
at org.apache.beehive.netui.pageflow.PageFlowController.internalExecute(PageFlowController.java:305)
at org.apache.beehive.netui.pageflow.FlowController.execute(FlowController.java:335)
at org.apache.beehive.netui.pageflow.internal.FlowControllerAction.execute(FlowControllerAction.java:51)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.access$201(PageFlowRequestProcessor.java:95)
at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor$ActionRunner.execute(PageFlowRequestProcessor.java:2042)
at org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors$WrapActionInterceptorChain.continueChain(ActionInterceptors.java:63)
at org.apache.beehive.netui.pageflow.interceptor.action.ActionInterceptor.wrapAction(ActionInterceptor.java:167)
at org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors$WrapActionInterceptorChain.invoke(ActionInterceptors.java:49)
at org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors$WrapActionInterceptorChain.continueChain(ActionInterceptors.java:57)
at org.apache.beehive.netui.pageflow.interceptor.action.internal.ActionInterceptors.wrapAction(ActionInterceptors.java:86)
at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processActionPerform(PageFlowRequestProcessor.java:2114)
at com.bea.console.internal.ConsolePageFlowRequestProcessor.processActionPerform(ConsolePageFlowRequestProcessor.java:221)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.processInternal(PageFlowRequestProcessor.java:554)
at org.apache.beehive.netui.pageflow.PageFlowRequestProcessor.process(PageFlowRequestProcessor.java:851)
at org.apache.beehive.netui.pageflow.AutoRegisterActionServlet.process(AutoRegisterActionServlet.java:630)
at org.apache.beehive.netui.pageflow.PageFlowActionServlet.process(PageFlowActionServlet.java:157)
at com.bea.console.internal.ConsoleActionServlet.process(ConsoleActionServlet.java:241)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at com.bea.console.internal.ConsoleActionServlet.doGet(ConsoleActionServlet.java:130)

Any idea what went wrong?

Thanks in advance

Matt Cartwright
Ranch Hand

Joined: Aug 25, 2008
Posts: 149

the jar file containing the driver class is not on the server's CLASSPATH,

double check the driver class name and make sure you have at least mssqlserver.jar
on the CLASSPATH.

You can edit the setDomainEnv.sh file to manipulate the CLASSPATH...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Error with creating JDBC Data Source (Weblogic 9.2)