Hello everyone,
I've an issue setting up sqlserver 2005 express in the admin console.
I have tried everything I know off.
I am using Vista home prem. Sun Java application server 9.1.
I am yet to try the new Glassfish application server v2 or v3.
Just that I had issues when I tried using it.
Classpath is set as:
C:\CLassPath\sqljdbc
both in evironmental and admin console.
classnames:
com.microsoft.sqlserver.jdbc.SQLServerDriver
com.microsoft.sqlserver.jdbc.SQLServerXADataSource
com.microsoft.sqlserver.jdbc.SQLServerDriver
Class name is wrong or classpath is not set for : com.microsoft.sqlserver.jdbc.SQLServerDataSource
com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource
com.microsoft.sqlserver.jdbc.SQLServerDataSource
using:
http://msdn.microsoft.com/en-us/library/ms378729(SQL.90).aspx
error:
Caused by: javax.resource.ResourceException: Class name is wrong or classpath is not set for : com.microsoft.sqlserver.jdbc.SQLServerDataSource at com.sun.gjc.common.DataSourceObjectBuilder.getDataSourceObject(DataSourceObjectBuilder.java:248) at com.sun.gjc.common.DataSourceObjectBuilder.constructDataSourceObject(DataSourceObjectBuilder.java:109) at com.sun.gjc.spi.ManagedConnectionFactory.getDataSource(ManagedConnectionFactory.java:972) at com.sun.gjc.spi.DSManagedConnectionFactory.getDataSource(DSManagedConnectionFactory.java:141) at com.sun.gjc.spi.DSManagedConnectionFactory.createManagedConnection(DSManagedConnectionFactory.java:95) at com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.getUnpooledConnection(ConnectorConnectionPoolAdminServiceImpl.java:1304) at com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.testConnectionPool(ConnectorConnectionPoolAdminServiceImpl.java:551) ... 73 more|#]
[#|2009-02-01T17:15:02.599+0000|INFO|sun-appserver9.1|javax.enterprise.system.tools.admin|_ThreadID=15;_ThreadName=httpWorkerThread-4848-0;ResourceDeployEvent -- redeploy jcp/STOCKINFORdb;|ADM1041:Sent the event to instance:[ResourceDeployEvent -- redeploy jcp/STOCKINFORdb]|#]
[#|2009-02-01T17:15:02.683+0000|INFO|sun-appserver9.1|javax.enterprise.system.core|_ThreadID=15;_ThreadName=httpWorkerThread-4848-0;jcp:STOCKINFORdb;|CORE5008: Resource Redeployed: [jcp:STOCKINFORdb].|#]
[#|2009-02-01T17:15:05.848+0000|SEVERE|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=14;_ThreadName=httpWorkerThread-4848-1;_RequestID=fca44f9c-5f9a-404f-b1d3-2ea428cb02b4;|RAR5099 : Wrong class name or classpath for Datasource Object java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDataSource at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1498) at com.sun.gjc.common.DataSourceObjectBuilder.getDataSourceObject(DataSourceObjectBuilder.java:242) at com.sun.gjc.common.DataSourceObjectBuilder.constructDataSourceObject(DataSourceObjectBuilder.java:109) at com.sun.gjc.spi.ManagedConnectionFactory.getDataSource(ManagedConnectionFactory.java:972) at com.sun.gjc.spi.DSManagedConnectionFactory.getDataSource(DSManagedConnectionFactory.java:141) at com.sun.gjc.spi.DSManagedConnectionFactory.createManagedConnection(DSManagedConnectionFactory.java:95) at com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.getUnpooledConnection(ConnectorConnectionPoolAdminServiceImpl.java:1304) at com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.testConnectionPool(ConnectorConnectionPoolAdminServiceImpl.java:551) at com.sun.enterprise.connectors.ConnectorRuntime.testConnectionPool(ConnectorRuntime.java:514) at com.sun.enterprise.admin.mbeans.ResourcesMBean.pingConnectionPool(ResourcesMBean.java:2387) 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:597)
[#|2009-02-01T17:15:05.848+0000|WARNING|sun-appserver9.1|javax.enterprise.resource.resourceadapter|_ThreadID=14;_ThreadName=httpWorkerThread-4848-1;_RequestID=fca44f9c-5f9a-404f-b1d3-2ea428cb02b4;|Class name is wrong or classpath is not set for : com.microsoft.sqlserver.jdbc.SQLServerDataSource|#]
[#|2009-02-01T17:15:05.848+0000|WARNING|sun-appserver9.1|javax.enterprise.system.stream.err|_ThreadID=14;_ThreadName=httpWorkerThread-4848-1;_RequestID=fca44f9c-5f9a-404f-b1d3-2ea428cb02b4;|java.lang.RuntimeException: javax.resource.ResourceException: Class name is wrong or classpath is not set for : com.microsoft.sqlserver.jdbc.SQLServerDataSource at com.sun.enterprise.tools.admingui.util.JMXUtil.invoke(JMXUtil.java:124) at com.sun.enterprise.tools.admingui.util.JMXUtil.invoke(JMXUtil.java:75) at com.sun.enterprise.tools.admingui.handlers.JdbcHandlers.pingJdbcConnectionPool(JdbcHandlers.java:530) 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:597) at com.sun.jsftemplating.layout.descriptors.handler.Handler.invoke(Handler.java:421) at com.sun.jsftemplating.layout.descriptors.LayoutElementBase.dispatchHandlers(LayoutElementBase.java:343) at com.sun.jsftemplating.layout.descriptors.LayoutElementBase.dispatchHandlers(LayoutElementBase.java:317) at com.sun.jsftemplating.layout.event.CommandActionListener.invokeCommandHandlers(CommandActionListener.java:133) at com.sun.jsftemplating.layout.event.CommandActionListener.processAction(CommandActionListener.java:81) at javax.faces.event.ActionEvent.processListener(ActionEvent.java:77) at javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:746)
Caused by: javax.resource.ResourceException: Class name is wrong or classpath is not set for : com.microsoft.sqlserver.jdbc.SQLServerDataSource at com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.testConnectionPool(ConnectorConnectionPoolAdminServiceImpl.java:556) at com.sun.enterprise.connectors.ConnectorRuntime.testConnectionPool(ConnectorRuntime.java:514) at com.sun.enterprise.admin.mbeans.ResourcesMBean.pingConnectionPool(ResourcesMBean.java:2387) 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:597) at com.sun.enterprise.admin.MBeanHelper.invokeOperationInBean(MBeanHelper.java:375) at com.sun.enterprise.admin.MBeanHelper.invokeOperationInBean(MBeanHelper.java:358) at com.sun.enterprise.admin.config.BaseConfigMBean.invoke(BaseConfigMBean.java:464) at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:836) at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:761) at sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.sun.enterprise.admin.util.proxy.ProxyClass.invoke(ProxyClass.java:90) at $Proxy1.invoke(Unknown Source)
Caused by: javax.resource.ResourceException: Class name is wrong or classpath is not set for : com.microsoft.sqlserver.jdbc.SQLServerDataSource at com.sun.gjc.common.DataSourceObjectBuilder.getDataSourceObject(DataSourceObjectBuilder.java:248) at com.sun.gjc.common.DataSourceObjectBuilder.constructDataSourceObject(DataSourceObjectBuilder.java:109) at com.sun.gjc.spi.ManagedConnectionFactory.getDataSource(ManagedConnectionFactory.java:972) at com.sun.gjc.spi.DSManagedConnectionFactory.getDataSource(DSManagedConnectionFactory.java:141) at com.sun.gjc.spi.DSManagedConnectionFactory.createManagedConnection(DSManagedConnectionFactory.java:95) at com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.getUnpooledConnection(ConnectorConnectionPoolAdminServiceImpl.java:1304) at com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.testConnectionPool(ConnectorConnectionPoolAdminServiceImpl.java:551) ... 73 more|#]
when i do the settings for sqlserver 2000 on xp, it works.
but when i try to work with sqlserver express 2005 with either xp or vista,
i have issues. Any suggestions? or is there a service pack forgot to install.
Please help.
_________________________________________________________________
Twice the fun—Share photos while you chat with Windows Live Messenger. Learn more.
http://www.microsoft.com/uk/windows/windowslive/products/messenger.aspx