> > 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./> > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------------------------> > Share your photos with Windows Live Photos – Free Find out more! > > <http://clk.atdmt.com/UKM/go/132630768/direct/01/>Share your photos with Windows Live Photos – Free Find out more!Share your photos with Windows Live Photos – Free Try it Now!
_________________________________________________________________
Twice the fun—Share photos while you chat with Windows Live Messenger. Learn more.
http://www.microsoft.com/uk/windows/windowslive/products/messenger.aspx
attached mail follows:
> Eve Pokua wrote:> > 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./> > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------------------------> > Share your photos with Windows Live Photos – Free Find out more! > > <http://clk.atdmt.com/UKM/go/132630768/direct/01/>
Share your photos with Windows Live Photos – Free Find out more!
_________________________________________________________________
Windows Live Messenger just got better .Video display pics, contact updates & more.
http://www.download.live.com/messenger