Eve,
I suggest you switch to the users_at_GF alias - it has many more people to help,
including our connector team.
Regards,
-marina
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/>