Skip to main content

FW: Vista, Jee5, sql2000 &sql2005

21 replies [Last post]
Anonymous

Reply viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Dennis Gesker

Just a couple of things to check/try...

Try uninstalling... upon reinstall make sure that you have installed
all the pre-requisites (.Net 3.5, etc.)
Maybe actually log in as Administrator to do the reinstall
After install confirm that the service is running from task manager.
After confirmed that ms-sql is running confirm that the tcp/ip port is
open on 1433 (Configuration Manager) -- again tcp/ip on port 1433
doesn't seem to be enabled by default in ms-sql express.

Its important to confirm that 1433 is open and accepting connections.
If this port isn't open and able to accept connections there is no
point going forward and configuring you jdbc connection because there
isn't a port for to which the jdbc driver can connect.

Here is a link on how to configure/open this port:

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

There error message in you last post is not from ms-sql but from the
jdbc driver so before you delve deeper into setting up jdbc make sure
ms-sql is properly installed and able to communicate on port 1433.

Dennis

On Tue, Mar 3, 2009 at 2:40 PM, Dennis Gesker wrote:
> Eve:
>
> I'm jumping in the thread a little late so if I'm answering the wrong
> question I apologize in advance. But, my dev machine seems to be setup
> similar to what you are trying to setup so I thought maybe I could
> offer some tips
>
> I had been using MS-SQL 2008 express on Vista 64 (jdk_1.6.0._11,
> glassfish-v2.1b60f) however my issue was not the driver. My issue was
> that MS-SQL Express seemed to not enable TCP/IP by default so I had to
> enable it using the configuration manager.
>
> Once TCP/IP was enabled I was able to connect using the jTDS driver.
> However, I was not able to connect using Microsofts' driver. The
> driver complained about ms-sql 2008 express being an incorrect
> version. I did find a pre-release of the next version of the jdbc
> driver (sqljdbc4.jar) that seemed to work OK on the MS Website. There
> were two jars (sqljdbc4.jar and sqljdbc.jar) in the pre-release
> version. You will only need sqljdbc4.jar.
>
> By the way, I also recommend just copying the needed jars to the
> glassfish/lib directory as the easiest way to make glassfish aware of
> the driver.
>
> Also, just as an FYI there is a very useful file that you can add to
> your [ProjectName]\setup folder called sun-resources.xml where you can
> put in all the settings for your database pool/connection. When you
> put this file in the setup folder is shows up under the "Server
> Resources" node in NetBeans which is really convenient
>
> Just as a reference my sun-resources.xml file (using the jTDS Driver)
> looks kind of like:
>
>
> > Server 9.0 Resource Definitions //EN"
> "http://www.sun.com/software/appserver/dtds/sun-resources_1_3.dtd">
>
>   > object-type="user" pool-name="MyDbPool"/>
>
>   > associate-with-thread="false" connection-creation-retry-attempts="0"
> connection-creation-retry-interval-in-seconds="10"
> connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0"
> connection-validation-method="auto-commit"
> datasource-classname="net.sourceforge.jtds.jdbcx.JtdsDataSource"
> fail-all-connections="false" idle-timeout-in-seconds="300"
> is-connection-validation-required="false"
> is-isolation-level-guaranteed="true"
> lazy-connection-association="false" lazy-connection-enlistment="false"
> match-connections="false" max-connection-usage-count="0"
> max-pool-size="128" max-wait-time-in-millis="60000" name="MyDbPool"
> non-transactional-connections="false" pool-resize-quantity="2"
> res-type="javax.sql.ConnectionPoolDataSource"
> statement-timeout-in-seconds="-1" steady-pool-size="16"
> validate-atmost-once-period-in-seconds="0" wrap-jdbc-objects="false">
>    
>    
>    
>    
>    
>    
>    

>  
>
>
>
>
>
> With a few modifications you can adjust the above file contents for
> the MS-JDBC driver.
>
> Finally, a while back I posted some directions for getting JSPWiki
> running on Glassfish. This series of postings also includes some step
> by step for setting up Db/JDBC (though more specific to jdbc auth)
> which you may find helpful.
>
> http://gesker.blogspot.com/2007/03/jspwikiglassfish-install-part-1.html
> http://gesker.blogspot.com/2007/03/jspwikiglassfish-install-part-10-of-1...
> http://gesker.blogspot.com/2007/03/jspwikiglassfish-install-part-11-of-1...
>
>
> Anyway, I hope that helps to get you going. Good luck with your project.
>
> Dennis
>
>
>
> On Tue, Mar 3, 2009 at 8:48 AM, Eve Pokua wrote:
>>
>>  Martin,
>>
>>  i've tried both windows and sql mode. And im log on as administrator.
>>
>> .net framework 3.1 sp1 is installed.  So what  im  I doing wrong?
>>
>>  thanks
>>
>> eve
>> ________________________________
>> From: mgainty@hotmail.com
>> To: users@glassfish.dev.java.net
>> Date: Tue, 3 Mar 2009 08:02:16 -0500
>> Subject: RE: Vista, Jee5, sql2000 &sql2005
>>
>> can you run the service as Windows Compatibility Mode
>> AND Run as Administrator
>> Keep in Mind later versions of SQLServer (such as 05) do not run without
>> .NET Framework
>> (last time I checked you needed .NET Framework 2.0)
>>
>> Martin
>> ______________________________________________
>> Disclaimer and confidentiality note
>> Everything in this e-mail and any attachments relates to the official
>> business of Sender. This transmission is of a confidential nature and Sender
>> does not endorse distribution to any party other than intended recipient.
>> Sender does not necessarily endorse content contained within this
>> transmission.
>>
>>
>>
>>
>> ________________________________
>> From: gorgeous65@msn.com
>> To: users@glassfish.dev.java.net
>> Date: Tue, 3 Mar 2009 12:13:26 +0000
>> Subject: RE: Vista, Jee5, sql2000 &sql2005
>>
>>    hello,
>>
>> I've attached the file as requested.   But even, starting the service of the
>> SQL server says -  i need administration previleges.  im using Vista. and
>> 2005 SQL server express.  So more likely  MS issue.  But if you've similar
>> issue, pls let me know.
>>
>>
>>
>> thanks
>> eve
>>
>>> Date: Mon, 2 Mar 2009 20:34:07 -0800
>>> From: glassfish@javadesktop.org
>>> To: users@glassfish.dev.java.net
>>> Subject: Re: RE: Vista, Jee5, sql2000 &sql2005
>>>
>>> Please attach your jdbc-connection-pool element configuration from the
>>> domain.xml. From this, we could see if adding any additional property could
>>> solve your issue. domain.xml is found under
>>> /domains//config directory.
>>> [Message sent by forum member 'sm157516' (sm157516)]
>>>
>>> http://forums.java.net/jive/thread.jspa?messageID=334707
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
>>> For additional commands, e-mail: users-help@glassfish.dev.java.net
>>>
>>
>> ________________________________
>> Beyond Hotmail — see what else you can do with Windows Live. Find out more!
>> ________________________________
>> Windows Liveâ„¢ Groups: Create an online spot for your favorite groups to
>> meet. Check it out.
>> ________________________________
>> Share your photos with Windows Live Photos – Free. Try it Now!
>
>
>
> --
> Dennis R. Gesker
> email: dennis@gesker.com
> google talk: gesker@gmail.com
> aim: dennisgesker
> pgp/gpg: 0x267D3FE8
> First things first, but not necessarily in that order. -- Unknown
>

--
Dennis R. Gesker
email: dennis@gesker.com
google talk: gesker@gmail.com
aim: dennisgesker
pgp/gpg: 0x267D3FE8
First things first, but not necessarily in that order. -- Unknown

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
For additional commands, e-mail: users-help@glassfish.dev.java.net

Eve Pokua

Dennis,

you are right, the error is coming from the driver because, im now able to

start the sql server service. I change the login settings in the configuration

manager to local System. But connection is still being refused when i pin from thd admin

console... 1433 port is enabled.

I will try your suggestion before.

Thanks

eve

> Date: Tue, 3 Mar 2009 16:30:17 -0700
> From: dennis@gesker.com
> To: users@glassfish.dev.java.net
> CC: ejb@glassfish.dev.java.net; persistence@glassfish.dev.java.net
> Subject: Re: Vista, Jee5, sql2000 &sql2005
>
> Just a couple of things to check/try...
>
> Try uninstalling... upon reinstall make sure that you have installed
> all the pre-requisites (.Net 3.5, etc.)
> Maybe actually log in as Administrator to do the reinstall
> After install confirm that the service is running from task manager.
> After confirmed that ms-sql is running confirm that the tcp/ip port is
> open on 1433 (Configuration Manager) -- again tcp/ip on port 1433
> doesn't seem to be enabled by default in ms-sql express.
>
> Its important to confirm that 1433 is open and accepting connections.
> If this port isn't open and able to accept connections there is no
> point going forward and configuring you jdbc connection because there
> isn't a port for to which the jdbc driver can connect.
>
> Here is a link on how to configure/open this port:
>
> http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
>
> There error message in you last post is not from ms-sql but from the
> jdbc driver so before you delve deeper into setting up jdbc make sure
> ms-sql is properly installed and able to communicate on port 1433.
>
> Dennis
>
>
> On Tue, Mar 3, 2009 at 2:40 PM, Dennis Gesker wrote:
> > Eve:
> >
> > I'm jumping in the thread a little late so if I'm answering the wrong
> > question I apologize in advance. But, my dev machine seems to be setup
> > similar to what you are trying to setup so I thought maybe I could
> > offer some tips
> >
> > I had been using MS-SQL 2008 express on Vista 64 (jdk_1.6.0._11,
> > glassfish-v2.1b60f) however my issue was not the driver. My issue was
> > that MS-SQL Express seemed to not enable TCP/IP by default so I had to
> > enable it using the configuration manager.
> >
> > Once TCP/IP was enabled I was able to connect using the jTDS driver.
> > However, I was not able to connect using Microsofts' driver. The
> > driver complained about ms-sql 2008 express being an incorrect
> > version. I did find a pre-release of the next version of the jdbc
> > driver (sqljdbc4.jar) that seemed to work OK on the MS Website. There
> > were two jars (sqljdbc4.jar and sqljdbc.jar) in the pre-release
> > version. You will only need sqljdbc4.jar.
> >
> > By the way, I also recommend just copying the needed jars to the
> > glassfish/lib directory as the easiest way to make glassfish aware of
> > the driver.
> >
> > Also, just as an FYI there is a very useful file that you can add to
> > your [ProjectName]\setup folder called sun-resources.xml where you can
> > put in all the settings for your database pool/connection. When you
> > put this file in the setup folder is shows up under the "Server
> > Resources" node in NetBeans which is really convenient
> >
> > Just as a reference my sun-resources.xml file (using the jTDS Driver)
> > looks kind of like:
> >
> >
> > > > Server 9.0 Resource Definitions //EN"
> > "http://www.sun.com/software/appserver/dtds/sun-resources_1_3.dtd">
> >
> > > > object-type="user" pool-name="MyDbPool"/>
> >
> > > > associate-with-thread="false" connection-creation-retry-attempts="0"
> > connection-creation-retry-interval-in-seconds="10"
> > connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0"
> > connection-validation-method="auto-commit"
> > datasource-classname="net.sourceforge.jtds.jdbcx.JtdsDataSource"
> > fail-all-connections="false" idle-timeout-in-seconds="300"
> > is-connection-validation-required="false"
> > is-isolation-level-guaranteed="true"
> > lazy-connection-association="false" lazy-connection-enlistment="false"
> > match-connections="false" max-connection-usage-count="0"
> > max-pool-size="128" max-wait-time-in-millis="60000" name="MyDbPool"
> > non-transactional-connections="false" pool-resize-quantity="2"
> > res-type="javax.sql.ConnectionPoolDataSource"
> > statement-timeout-in-seconds="-1" steady-pool-size="16"
> > validate-atmost-once-period-in-seconds="0" wrap-jdbc-objects="false">
> >
> >
> >
> >
> >
> >
> >

> >
> >
> >
> >
> >
> >
> > With a few modifications you can adjust the above file contents for
> > the MS-JDBC driver.
> >
> > Finally, a while back I posted some directions for getting JSPWiki
> > running on Glassfish. This series of postings also includes some step
> > by step for setting up Db/JDBC (though more specific to jdbc auth)
> > which you may find helpful.
> >
> > http://gesker.blogspot.com/2007/03/jspwikiglassfish-install-part-1.html
> > http://gesker.blogspot.com/2007/03/jspwikiglassfish-install-part-10-of-1...
> > http://gesker.blogspot.com/2007/03/jspwikiglassfish-install-part-11-of-1...
> >
> >
> > Anyway, I hope that helps to get you going. Good luck with your project.
> >
> > Dennis
> >
> >
> >
> > On Tue, Mar 3, 2009 at 8:48 AM, Eve Pokua wrote:
> >>
> >> Martin,
> >>
> >> i've tried both windows and sql mode. And im log on as administrator.
> >>
> >> .net framework 3.1 sp1 is installed. So what im I doing wrong?
> >>
> >> thanks
> >>
> >> eve
> >> ________________________________
> >> From: mgainty@hotmail.com
> >> To: users@glassfish.dev.java.net
> >> Date: Tue, 3 Mar 2009 08:02:16 -0500
> >> Subject: RE: Vista, Jee5, sql2000 &sql2005
> >>
> >> can you run the service as Windows Compatibility Mode
> >> AND Run as Administrator
> >> Keep in Mind later versions of SQLServer (such as 05) do not run without
> >> .NET Framework
> >> (last time I checked you needed .NET Framework 2.0)
> >>
> >> Martin
> >> ______________________________________________
> >> Disclaimer and confidentiality note
> >> Everything in this e-mail and any attachments relates to the official
> >> business of Sender. This transmission is of a confidential nature and Sender
> >> does not endorse distribution to any party other than intended recipient.
> >> Sender does not necessarily endorse content contained within this
> >> transmission.
> >>
> >>
> >>
> >>
> >> ________________________________
> >> From: gorgeous65@msn.com
> >> To: users@glassfish.dev.java.net
> >> Date: Tue, 3 Mar 2009 12:13:26 +0000
> >> Subject: RE: Vista, Jee5, sql2000 &sql2005
> >>
> >> hello,
> >>
> >> I've attached the file as requested. But even, starting the service of the
> >> SQL server says - i need administration previleges. im using Vista. and
> >> 2005 SQL server express. So more likely MS issue. But if you've similar
> >> issue, pls let me know.
> >>
> >>
> >>
> >> thanks
> >> eve
> >>
> >>> Date: Mon, 2 Mar 2009 20:34:07 -0800
> >>> From: glassfish@javadesktop.org
> >>> To: users@glassfish.dev.java.net
> >>> Subject: Re: RE: Vista, Jee5, sql2000 &sql2005
> >>>
> >>> Please attach your jdbc-connection-pool element configuration from the
> >>> domain.xml. From this, we could see if adding any additional property could
> >>> solve your issue. domain.xml is found under
> >>> /domains//config directory.
> >>> [Message sent by forum member 'sm157516' (sm157516)]
> >>>
> >>> http://forums.java.net/jive/thread.jspa?messageID=334707
> >>>
> >>> ---------------------------------------------------------------------
> >>> To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> >>> For additional commands, e-mail: users-help@glassfish.dev.java.net
> >>>
> >>
> >> ________________________________
> >> Beyond Hotmail — see what else you can do with Windows Live. Find out more!
> >> ________________________________
> >> Windows Liveâ„¢ Groups: Create an online spot for your favorite groups to
> >> meet. Check it out.
> >> ________________________________
> >> Share your photos with Windows Live Photos – Free. Try it Now!
> >
> >
> >
> > --
> > Dennis R. Gesker
> > email: dennis@gesker.com
> > google talk: gesker@gmail.com
> > aim: dennisgesker
> > pgp/gpg: 0x267D3FE8
> > First things first, but not necessarily in that order. -- Unknown
> >
>
>
>
> --
> Dennis R. Gesker
> email: dennis@gesker.com
> google talk: gesker@gmail.com
> aim: dennisgesker
> pgp/gpg: 0x267D3FE8
> First things first, but not necessarily in that order. -- Unknown
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> For additional commands, e-mail: users-help@glassfish.dev.java.net
>

_________________________________________________________________
All your Twitter and other social updates in one place
http://clk.atdmt.com/UKM/go/137984870/direct/01/
[att1.html]

Eve Pokua

Hello,

I shall copy sqljdbc.jar into /domains/domain1/lib/extand see what happens.

Thanks

eve

> Date: Tue, 3 Feb 2009 22:21:07 -0800> From: glassfish@javadesktop.org> To: users@glassfish.dev.java.net> Subject: Re: FW: Vista, Jee5, sql2000 &sql2005> > Is the sqljdbc.jar copied in the /lib or /domains/domain1/lib/ext directories? The jar should be made available to the application server in order to load the class : com.microsoft.sqlserver.jdbc.SQLServerDataSource.> [Message sent by forum member 'sm157516' (sm157516)]> > http://forums.java.net/jive/thread.jspa?messageID=330006> > ---------------------------------------------------------------------> To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net> For additional commands, e-mail: users-help@glassfish.dev.java.net>
_________________________________________________________________

Hotmail, Messenger, Photos and more - all with the new Windows Live. Get started!
http://www.download.live.com/
[att1.html]

Eve Pokua

> > 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! > > 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
[att1.html]
[email.eml]
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
For additional commands, e-mail: users-help@glassfish.dev.java.net

sm157516
Offline
Joined: 2005-03-28

Is the sqljdbc.jar copied in the /lib or /domains/domain1/lib/ext directories? The jar should be made available to the application server in order to load the class : com.microsoft.sqlserver.jdbc.SQLServerDataSource.

Dr. Charles O. Odeyale

No, it is not in either location; not even on my system for that matter. I
have gone to Sun.com to look for it but came back empty. I will continue to
look to download a copy and report back. Is there anything else I may need,
or need to do?

Thanks.

----- Original Message -----
From:
To:
Sent: Wednesday, February 04, 2009 1:21 AM
Subject: Re: FW: Vista, Jee5, sql2000 &sql2005

> Is the sqljdbc.jar copied in the /lib or
> /domains/domain1/lib/ext directories? The jar should be made
> available to the application server in order to load the class :
> com.microsoft.sqlserver.jdbc.SQLServerDataSource.
> [Message sent by forum member 'sm157516' (sm157516)]
>
> http://forums.java.net/jive/thread.jspa?messageID=330006
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> For additional commands, e-mail: users-help@glassfish.dev.java.net
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
For additional commands, e-mail: users-help@glassfish.dev.java.net

Marina Vatkina

Did you try to search Microsoft site?

thanks,
-marina

Dr. Charles O. Odeyale wrote:
> No, it is not in either location; not even on my system for that matter.
> I have gone to Sun.com to look for it but came back empty. I will
> continue to look to download a copy and report back. Is there anything
> else I may need, or need to do?
>
> Thanks.
>
> ----- Original Message ----- From:
> To:
> Sent: Wednesday, February 04, 2009 1:21 AM
> Subject: Re: FW: Vista, Jee5, sql2000 &sql2005
>
>
>> Is the sqljdbc.jar copied in the /lib or
>> /domains/domain1/lib/ext directories? The jar should be
>> made available to the application server in order to load the class :
>> com.microsoft.sqlserver.jdbc.SQLServerDataSource.
>> [Message sent by forum member 'sm157516' (sm157516)]
>>
>> http://forums.java.net/jive/thread.jspa?messageID=330006
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
>> For additional commands, e-mail: users-help@glassfish.dev.java.net
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> For additional commands, e-mail: users-help@glassfish.dev.java.net
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
For additional commands, e-mail: users-help@glassfish.dev.java.net

Ryan de Laplante

The .jar does not come with GlassFish, you have to download it manually.

I do not recommend using Microsoft's JDBC driver. When we use it in
production to communicate with a remote SQL Server 2005 EE, at least
once per week there is a problem trying to connect to the database. The
Microsoft driver blocks the thread that is asking for a connection
indefinitely. Looking at the FINE/FINER logs, it shows "TDS prelogin
response error". Once this happens 5 times then the HTTP Listener for
your web application can no longer respond to web requests and it looks
like GlassFish is locked up. This happens even when you set the
loginTimeout property. We tested the latest 1.2 version of the driver.

We use the open source jTDS driver instead. It doesn't have this
problem and works well.

Ryan

Marina Vatkina wrote:
> Did you try to search Microsoft site?
>
> thanks,
> -marina
>
> Dr. Charles O. Odeyale wrote:
>> No, it is not in either location; not even on my system for that
>> matter. I have gone to Sun.com to look for it but came back empty. I
>> will continue to look to download a copy and report back. Is there
>> anything else I may need, or need to do?
>>
>> Thanks.
>>
>> ----- Original Message ----- From:
>> To:
>> Sent: Wednesday, February 04, 2009 1:21 AM
>> Subject: Re: FW: Vista, Jee5, sql2000 &sql2005
>>
>>
>>> Is the sqljdbc.jar copied in the /lib or
>>> /domains/domain1/lib/ext directories? The jar should
>>> be made available to the application server in order to load the
>>> class : com.microsoft.sqlserver.jdbc.SQLServerDataSource.
>>> [Message sent by forum member 'sm157516' (sm157516)]
>>>
>>> http://forums.java.net/jive/thread.jspa?messageID=330006
>>>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
For additional commands, e-mail: users-help@glassfish.dev.java.net

Eve Pokua

Hello,

I have finally got round to download this JTDS driver -

http://sourceforge.net/project/showfiles.php?group_id=33291&package_id=2...

unzip it

and copied the jar file -

jtds-1.2.2

into a directory i created -

c:\ClassPath\JTDS\jtds-1.2.2

SETUP MY Environmental variables as-

CLASSPATH=C:\CLassPath\JTDS\jtds-1.2.2.

Also added it to my Application Server\JVM seetings\path settings

under

Classpath Prefix =C:\CLassPath\JTDS\jtds-1.2.2

I get the error -

Class name is wrong or classpath is not set for : net.sourceforge.jtds.jdbcx.JtdsDataSource

I hope I am on the right track. Any ideas? its my first time of using this driver.

thanks.

eve

> Date: Wed, 4 Feb 2009 15:55:58 -0500
> From: ryan@ijws.com
> To: users@glassfish.dev.java.net
> Subject: Re: FW: Vista, Jee5, sql2000 &sql2005
>
> The .jar does not come with GlassFish, you have to download it manually.
>
> I do not recommend using Microsoft's JDBC driver. When we use it in
> production to communicate with a remote SQL Server 2005 EE, at least
> once per week there is a problem trying to connect to the database. The
> Microsoft driver blocks the thread that is asking for a connection
> indefinitely. Looking at the FINE/FINER logs, it shows "TDS prelogin
> response error". Once this happens 5 times then the HTTP Listener for
> your web application can no longer respond to web requests and it looks
> like GlassFish is locked up. This happens even when you set the
> loginTimeout property. We tested the latest 1.2 version of the driver.
>
> We use the open source jTDS driver instead. It doesn't have this
> problem and works well.
>
>
> Ryan
>
>
>
>
> Marina Vatkina wrote:
> > Did you try to search Microsoft site?
> >
> > thanks,
> > -marina
> >
> > Dr. Charles O. Odeyale wrote:
> >> No, it is not in either location; not even on my system for that
> >> matter. I have gone to Sun.com to look for it but came back empty. I
> >> will continue to look to download a copy and report back. Is there
> >> anything else I may need, or need to do?
> >>
> >> Thanks.
> >>
> >> ----- Original Message ----- From:
> >> To:
> >> Sent: Wednesday, February 04, 2009 1:21 AM
> >> Subject: Re: FW: Vista, Jee5, sql2000 &sql2005
> >>
> >>
> >>> Is the sqljdbc.jar copied in the /lib or
> >>> /domains/domain1/lib/ext directories? The jar should
> >>> be made available to the application server in order to load the
> >>> class : com.microsoft.sqlserver.jdbc.SQLServerDataSource.
> >>> [Message sent by forum member 'sm157516' (sm157516)]
> >>>
> >>> http://forums.java.net/jive/thread.jspa?messageID=330006
> >>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> For additional commands, e-mail: users-help@glassfish.dev.java.net
>

_________________________________________________________________
View your Twitter and Flickr updates from one place – Learn more!
http://clk.atdmt.com/UKM/go/137984870/direct/01/
[att1.html]

Martin Gainty

configure the component thru the admin interface e.g.
http://localhost:4848/

library should be located in
%GLASSFISH_HOME%\domains\domain1\jbi\shared-libraries\jtds\install_root\jtds-1.2.2.jar

place jbi.xml configuration

%GLASSFISH_HOME%\domains\domain1\jbi\shared-libraries\jtds\install_root\META-INF\jbi.xml

version="1.0"
xmlns="http://java.sun.com/xml/ns/jbi"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">



jtds
blah..blah..blah..

jtds-1.2.2.jar

HTH
Martin
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.

From: gorgeous65@msn.com
To: users@glassfish.dev.java.net
Date: Mon, 2 Mar 2009 00:30:22 +0000
Subject: RE: Vista, Jee5, sql2000 &sql2005

Hello,

I have finally got round to download this JTDS driver -

http://sourceforge.net/project/showfiles.php?group_id=33291&package_id=2...

unzip it

and copied the jar file -

jtds-1.2.2

into a directory i created -

c:\ClassPath\JTDS\jtds-1.2.2

SETUP MY Environmental variables as-

CLASSPATH=C:\CLassPath\JTDS\jtds-1.2.2.

Also added it to my Application Server\JVM seetings\path settings

under

Classpath Prefix =C:\CLassPath\JTDS\jtds-1.2.2

I get the error -

Class name is wrong or classpath is not set for : net.sourceforge.jtds.jdbcx.JtdsDataSource

I hope I am on the right track. Any ideas? its my first time of using this driver.

thanks.

eve

> Date: Wed, 4 Feb 2009 15:55:58 -0500
> From: ryan@ijws.com
> To: users@glassfish.dev.java.net
> Subject: Re: FW: Vista, Jee5, sql2000 &sql2005
>
> The .jar does not come with GlassFish, you have to download it manually.
>
> I do not recommend using Microsoft's JDBC driver. When we use it in
> production to communicate with a remote SQL Server 2005 EE, at least
> once per week there is a problem trying to connect to the database. The
> Microsoft driver blocks the thread that is asking for a connection
> indefinitely. Looking at the FINE/FINER logs, it shows "TDS prelogin
> response error". Once this happens 5 times then the HTTP Listener for
> your web application can no longer respond to web requests and it looks
> like GlassFish is locked up. This happens even when you set the
> loginTimeout property. We tested the latest 1.2 version of the driver.
>
> We use the open source jTDS driver instead. It doesn't have this
> problem and works well.
>
>
> Ryan
>
>
>
>
> Marina Vatkina wrote:
> > Did you try to search Microsoft site?
> >
> > thanks,
> > -marina
> >
> > Dr. Charles O. Odeyale wrote:
> >> No, it is not in either location; not even on my system for that
> >> matter. I have gone to Sun.com to look for it but came back empty. I
> >> will continue to look to download a copy and report back. Is there
> >> anything else I may need, or need to do?
> >>
> >> Thanks.
> >>
> >> ----- Original Message ----- From:
> >> To:
> >> Sent: Wednesday, February 04, 2009 1:21 AM
> >> Subject: Re: FW: Vista, Jee5, sql2000 &sql2005
> >>
> >>
> >>> Is the sqljdbc.jar copied in the /lib or
> >>> /domains/domain1/lib/ext directories? The jar should
> >>> be made available to the application server in order to load the
> >>> class : com.microsoft.sqlserver.jdbc.SQLServerDataSource.
> >>> [Message sent by forum member 'sm157516' (sm157516)]
> >>>
> >>> http://forums.java.net/jive/thread.jspa?messageID=330006
> >>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> For additional commands, e-mail: users-help@glassfish.dev.java.net
>

Beyond Hotmail — see what else you can do with Windows Live. Find out more!
_________________________________________________________________
Windows Liveâ„¢: Life without walls.
http://windowslive.com/explore?ocid=TXT_TAGLM_WL_allup_1a_explore_032009
[att1.html]

Ryan de Laplante

I've always put JDBC driver .jar files in domains\domain1\lib\ or
domains\domain1\lib\ext\

Next create a JDBC Connection Pool and JNDI reference in GlassFish's web
admin console.

I'm not familiar with what Martin Gainty described below (JBI)

Martin Gainty wrote:
> configure the component thru the admin interface e.g.
> http://localhost:4848/
>
> library should be located in
> %GLASSFISH_HOME%\domains\domain1\jbi\shared-libraries\jtds\install_root\jtds-1.2.2.jar
>
> place jbi.xml configuration
>
> %GLASSFISH_HOME%\domains\domain1\jbi\shared-libraries\jtds\install_root\META-INF\jbi.xml
>
>
>

> > version="1.0"
> xmlns="http://java.sun.com/xml/ns/jbi"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
>
>

>
>
> jtds
> blah..blah..blah..
>

>
>
jtds-1.2.2.jar >

>

>
>
> HTH
> Martin
> ______________________________________________
> Disclaimer and confidentiality note
> Everything in this e-mail and any attachments relates to the official
> business of Sender. This transmission is of a confidential nature and
> Sender does not endorse distribution to any party other than intended
> recipient. Sender does not necessarily endorse content contained
> within this transmission.
>
>
>
>
> ------------------------------------------------------------------------
> From: gorgeous65@msn.com
> To: users@glassfish.dev.java.net
> Date: Mon, 2 Mar 2009 00:30:22 +0000
> Subject: RE: Vista, Jee5, sql2000 &sql2005
>
> Hello,
>
> I have finally got round to download this JTDS driver -
>
> http://sourceforge.net/project/showfiles.php?group_id=33291&package_id=2...
>
> unzip it
>
> and copied the jar file -
>
> jtds-1.2.2
>
> into a directory i created -
>
> c:\ClassPath\JTDS\jtds-1.2.2
>
> SETUP MY Environmental variables as-
>
> CLASSPATH=C:\CLassPath\JTDS\jtds-1.2.2.
>
>
> Also added it to my Application Server\JVM seetings\path settings
>
> under
>
> Classpath Prefix =C:\CLassPath\JTDS\jtds-1.2.2
>
> I get the error -
>
> Class name is wrong or classpath is not set for :
> net.sourceforge.jtds.jdbcx.JtdsDataSource
>
>
> I hope I am on the right track. Any ideas? its my first time
> of using this driver.
>
> thanks.
>
> eve
>
>
> > Date: Wed, 4 Feb 2009 15:55:58 -0500
> > From: ryan@ijws.com
> > To: users@glassfish.dev.java.net
> > Subject: Re: FW: Vista, Jee5, sql2000 &sql2005
> >
> > The .jar does not come with GlassFish, you have to download it manually.
> >
> > I do not recommend using Microsoft's JDBC driver. When we use it in
> > production to communicate with a remote SQL Server 2005 EE, at least
> > once per week there is a problem trying to connect to the database. The
> > Microsoft driver blocks the thread that is asking for a connection
> > indefinitely. Looking at the FINE/FINER logs, it shows "TDS prelogin
> > response error". Once this happens 5 times then the HTTP Listener for
> > your web application can no longer respond to web requests and it looks
> > like GlassFish is locked up. This happens even when you set the
> > loginTimeout property. We tested the latest 1.2 version of the driver.
> >
> > We use the open source jTDS driver instead. It doesn't have this
> > problem and works well.
> >
> >
> > Ryan
> >
> >
> >
> >
> > Marina Vatkina wrote:
> > > Did you try to search Microsoft site?
> > >
> > > thanks,
> > > -marina
> > >
> > > Dr. Charles O. Odeyale wrote:
> > >> No, it is not in either location; not even on my system for that
> > >> matter. I have gone to Sun.com to look for it but came back empty. I
> > >> will continue to look to download a copy and report back. Is there
> > >> anything else I may need, or need to do?
> > >>
> > >> Thanks.
> > >>
> > >> ----- Original Message ----- From:
> > >> To:
> > >> Sent: Wednesday, February 04, 2009 1:21 AM
> > >> Subject: Re: FW: Vista, Jee5, sql2000 &sql2005
> > >>
> > >>
> > >>> Is the sqljdbc.jar copied in the /lib or
> > >>> /domains/domain1/lib/ext directories? The jar should
> > >>> be made available to the application server in order to load the
> > >>> class : com.microsoft.sqlserver.jdbc.SQLServerDataSource.
> > >>> [Message sent by forum member 'sm157516' (sm157516)]
> > >>>
> > >>> http://forums.java.net/jive/thread.jspa?messageID=330006
> > >>>
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> > For additional commands, e-mail: users-help@glassfish.dev.java.net
> >
>
> ------------------------------------------------------------------------
> Beyond Hotmail — see what else you can do with Windows Live. Find out
> more!
> ------------------------------------------------------------------------
> Windows Liveâ„¢: Life without walls. Check it out.
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
For additional commands, e-mail: users-help@glassfish.dev.java.net

Eve Pokua

Hello Ryan, Martin,

Everyone,

When I create it like what Martin suggested, when I restart the application server,

it gets rid of the directory. I then created it like what Ryan suggested, it works but

I have a different type of problem.

I can't seem to be able to connect to my MS SQL Express even though before I could.

I can't seem to start the service even though before it started automatically and it setting

of automatically is set on the service. Something must be wrong. On top of that it says in

the admin console when I ping- error. Server log -

Caused by: java.sql.SQLException: Unknown server host name 'EDELLVE\SQLEXPRESS'.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:377)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
at net.sourceforge.jtds.jdbcx.JtdsDataSource.getConnection(JtdsDataSource.java:186)
at net.sourceforge.jtds.jdbcx.JtdsDataSource.getPooledConnection(JtdsDataSource.java:264)
at net.sourceforge.jtds.jdbcx.JtdsDataSource.getPooledConnection(JtdsDataSource.java:250)
at com.sun.gjc.spi.CPManagedConnectionFactory.createManagedConnection(CPManagedConnectionFactory.java:126)
... 75 more
Caused by: java.net.UnknownHostException: EDELLVE\SQLEXPRESS
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:177)
|#]

[#|2009-03-02T14:04:45.315+0000|WARNING|sun-appserver9.1|javax.enterprise.system.stream.err|_ThreadID=14;_ThreadName=httpWorkerThread-4848-0;_RequestID=6445f8cc-0f01-40b4-b059-e8716d72fd6c;| at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
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.server.ss.provider.ASPlainSocketImpl$2.run(ASPlainSocketImpl.java:419)
at java.security.AccessController.doPrivileged(Native Method)
at com.sun.enterprise.server.ss.provider.ASPlainSocketImpl._invoke(ASPlainSocketImpl.java:416)
at com.sun.enterprise.server.ss.provider.ASPlainSocketImpl.connect(ASPlainSocketImpl.java:288)
at com.sun.enterprise.server.ss.provider.ASClientSocketImpl.connect(ASClientSocketImpl.java:267)
at java.net.Socket.connect(Socket.java:519)
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 net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:304)
at net.sourceforge.jtds.jdbc.SharedSocket.(SharedSocket.java:255)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:310)
... 81 more
|#]

Basically, the server host name is wrong, even though I copied the exact name from management

studio express. And can't log into the Management studio express with either SQL Autherication

or windows; or start the service. But it used to work before that's why I was able to create a database

in it.

Thanks

eve

> Date: Sun, 1 Mar 2009 22:36:34 -0500
> From: ryan@ijws.com
> To: users@glassfish.dev.java.net
> Subject: Re: Vista, Jee5, sql2000 &sql2005
>
> I've always put JDBC driver .jar files in domains\domain1\lib\ or
> domains\domain1\lib\ext\
>
> Next create a JDBC Connection Pool and JNDI reference in GlassFish's web
> admin console.
>
> I'm not familiar with what Martin Gainty described below (JBI)
>
>
> Martin Gainty wrote:
> > configure the component thru the admin interface e.g.
> > http://localhost:4848/
> >
> > library should be located in
> > %GLASSFISH_HOME%\domains\domain1\jbi\shared-libraries\jtds\install_root\jtds-1.2.2.jar
> >
> > place jbi.xml configuration
> >
> > %GLASSFISH_HOME%\domains\domain1\jbi\shared-libraries\jtds\install_root\META-INF\jbi.xml
> >
> >
> >

> > > > version="1.0"
> > xmlns="http://java.sun.com/xml/ns/jbi"
> > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
> >
> >

> >
> >
> > jtds
> > blah..blah..blah..
> >

> >
> >
jtds-1.2.2.jar > >

> >

> >
> >
> > HTH
> > Martin
> > ______________________________________________
> > Disclaimer and confidentiality note
> > Everything in this e-mail and any attachments relates to the official
> > business of Sender. This transmission is of a confidential nature and
> > Sender does not endorse distribution to any party other than intended
> > recipient. Sender does not necessarily endorse content contained
> > within this transmission.
> >
> >
> >
> >
> > ------------------------------------------------------------------------
> > From: gorgeous65@msn.com
> > To: users@glassfish.dev.java.net
> > Date: Mon, 2 Mar 2009 00:30:22 +0000
> > Subject: RE: Vista, Jee5, sql2000 &sql2005
> >
> > Hello,
> >
> > I have finally got round to download this JTDS driver -
> >
> > http://sourceforge.net/project/showfiles.php?group_id=33291&package_id=2...
> >
> > unzip it
> >
> > and copied the jar file -
> >
> > jtds-1.2.2
> >
> > into a directory i created -
> >
> > c:\ClassPath\JTDS\jtds-1.2.2
> >
> > SETUP MY Environmental variables as-
> >
> > CLASSPATH=C:\CLassPath\JTDS\jtds-1.2.2.
> >
> >
> > Also added it to my Application Server\JVM seetings\path settings
> >
> > under
> >
> > Classpath Prefix =C:\CLassPath\JTDS\jtds-1.2.2
> >
> > I get the error -
> >
> > Class name is wrong or classpath is not set for :
> > net.sourceforge.jtds.jdbcx.JtdsDataSource
> >
> >
> > I hope I am on the right track. Any ideas? its my first time
> > of using this driver.
> >
> > thanks.
> >
> > eve
> >
> >
> > > Date: Wed, 4 Feb 2009 15:55:58 -0500
> > > From: ryan@ijws.com
> > > To: users@glassfish.dev.java.net
> > > Subject: Re: FW: Vista, Jee5, sql2000 &sql2005
> > >
> > > The .jar does not come with GlassFish, you have to download it manually.
> > >
> > > I do not recommend using Microsoft's JDBC driver. When we use it in
> > > production to communicate with a remote SQL Server 2005 EE, at least
> > > once per week there is a problem trying to connect to the database. The
> > > Microsoft driver blocks the thread that is asking for a connection
> > > indefinitely. Looking at the FINE/FINER logs, it shows "TDS prelogin
> > > response error". Once this happens 5 times then the HTTP Listener for
> > > your web application can no longer respond to web requests and it looks
> > > like GlassFish is locked up. This happens even when you set the
> > > loginTimeout property. We tested the latest 1.2 version of the driver.
> > >
> > > We use the open source jTDS driver instead. It doesn't have this
> > > problem and works well.
> > >
> > >
> > > Ryan
> > >
> > >
> > >
> > >
> > > Marina Vatkina wrote:
> > > > Did you try to search Microsoft site?
> > > >
> > > > thanks,
> > > > -marina
> > > >
> > > > Dr. Charles O. Odeyale wrote:
> > > >> No, it is not in either location; not even on my system for that
> > > >> matter. I have gone to Sun.com to look for it but came back empty. I
> > > >> will continue to look to download a copy and report back. Is there
> > > >> anything else I may need, or need to do?
> > > >>
> > > >> Thanks.
> > > >>
> > > >> ----- Original Message ----- From:
> > > >> To:
> > > >> Sent: Wednesday, February 04, 2009 1:21 AM
> > > >> Subject: Re: FW: Vista, Jee5, sql2000 &sql2005
> > > >>
> > > >>
> > > >>> Is the sqljdbc.jar copied in the /lib or
> > > >>> /domains/domain1/lib/ext directories? The jar should
> > > >>> be made available to the application server in order to load the
> > > >>> class : com.microsoft.sqlserver.jdbc.SQLServerDataSource.
> > > >>> [Message sent by forum member 'sm157516' (sm157516)]
> > > >>>
> > > >>> http://forums.java.net/jive/thread.jspa?messageID=330006
> > > >>>
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> > > For additional commands, e-mail: users-help@glassfish.dev.java.net
> > >
> >
> > ------------------------------------------------------------------------
> > Beyond Hotmail — see what else you can do with Windows Live. Find out
> > more!
> > ------------------------------------------------------------------------
> > Windows Liveâ„¢: Life without walls. Check it out.
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> For additional commands, e-mail: users-help@glassfish.dev.java.net
>

_________________________________________________________________
Free photo editing software from Windows Live . Try it now!
http://clk.atdmt.com/UKM/go/134665240/direct/01/
[att1.html]

Eve Pokua

Sorry,

This is what i get when I try to log into the management studio:

TITLE: Connect to Server
------------------------------

Cannot connect to EDELLVE\SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while
establishing a connection to SQL Server. The server was not
found or was not accessible. Verify that the instance name
is correct and that SQL Server is configured to allow remote c
onnections. (provider: Shared Memory Provider, error: 40 -
Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=
MSSQLServer&EvtID=2&LinkId=20476

------------------------------
BUTTONS:

OK

From: gorgeous65@msn.com
To: users@glassfish.dev.java.net
Date: Mon, 2 Mar 2009 14:16:12 +0000
Subject: RE: Vista, Jee5, sql2000 &sql2005

Hello Ryan, Martin,

Everyone,

When I create it like what Martin suggested, when I restart the application server,
it gets rid of the directory. I then created it like what Ryan suggested, it works but
I have a different type of problem.

I can't seem to be able to connect to my MS SQL Express even though before I could.
I can't seem to start the service even though before it started automatically and it setting
of automatically is set on the service. Something must be wrong. On top of that it says in
the admin console when I ping- error. Server log -

Caused by: java.sql.SQLException: Unknown server host name 'EDELLVE\SQLEXPRESS'.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:377)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
at net.sourceforge.jtds.jdbcx.JtdsDataSource.getConnection(JtdsDataSource.java:186)
at net.sourceforge.jtds.jdbcx.JtdsDataSource.getPooledConnection(JtdsDataSource.java:264)
at net.sourceforge.jtds.jdbcx.JtdsDataSource.getPooledConnection(JtdsDataSource.java:250)
at com.sun.gjc.spi.CPManagedConnectionFactory.createManagedConnection(CPManagedConnectionFactory.java:126)
... 75 more
Caused by: java.net.UnknownHostException: EDELLVE\SQLEXPRESS
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:177)
|#]
[#|2009-03-02T14:04:45.315+0000|WARNING|sun-appserver9.1|javax.enterprise.system.stream.err|_ThreadID=14;_ThreadName=httpWorkerThread-4848-0;_RequestID=6445f8cc-0f01-40b4-b059-e8716d72fd6c;| at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
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.server.ss.provider.ASPlainSocketImpl$2.run(ASPlainSocketImpl.java:419)
at java.security.AccessController.doPrivileged(Native Method)
at com.sun.enterprise.server.ss.provider.ASPlainSocketImpl._invoke(ASPlainSocketImpl.java:416)
at com.sun.enterprise.server.ss.provider.ASPlainSocketImpl.connect(ASPlainSocketImpl.java:288)
at com.sun.enterprise.server.ss.provider.ASClientSocketImpl.connect(ASClientSocketImpl.java:267)
at java.net.Socket.connect(Socket.java:519)
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 net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:304)
at net.sourceforge.jtds.jdbc.SharedSocket.(SharedSocket.java:255)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:310)
... 81 more
|#]

Basically, the server host name is wrong, even though I copied the exact name from management
studio express. And can't log into the Management studio express with either SQL Autherication
or windows; or start the service. But it used to work before that's why I was able to create a database
in it.

Thanks

eve

> Date: Sun, 1 Mar 2009 22:36:34 -0500
> From: ryan@ijws.com
> To: users@glassfish.dev.java.net
> Subject: Re: Vista, Jee5, sql2000 &sql2005
>
> I've always put JDBC driver .jar files in domains\domain1\lib\ or
> domains\domain1\lib\ext\
>
> Next create a JDBC Connection Pool and JNDI reference in GlassFish's web
> admin console.
>
> I'm not familiar with what Martin Gainty described below (JBI)
>
>
> Martin Gainty wrote:
> > configure the component thru the admin interface e.g.
> > http://localhost:4848/
> >
> > library should be located in
> > %GLASSFISH_HOME%\domains\domain1\jbi\shared-libraries\jtds\install_root\jtds-1.2.2.jar
> >
> > place jbi.xml configuration
> >
> > %GLASSFISH_HOME%\domains\domain1\jbi\shared-libraries\jtds\install_root\META-INF\jbi.xml
> >
> >
> >

> > > > version="1.0"
> > xmlns="http://java.sun.com/xml/ns/jbi"
> > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
> >
> >

> >
> >
> > jtds
> > blah..blah..blah..
> >

> >
> >
jtds-1.2.2.jar > >

> >

> >
> >
> > HTH
> > Martin
> > ______________________________________________
> > Disclaimer and confidentiality note
> > Everything in this e-mail and any attachments relates to the official
> > business of Sender. This transmission is of a confidential nature and
> > Sender does not endorse distribution to any party other than intended
> > recipient. Sender does not necessarily endorse content contained
> > within this transmission.
> >
> >
> >
> >
> > ------------------------------------------------------------------------
> > From: gorgeous65@msn.com
> > To: users@glassfish.dev.java.net
> > Date: Mon, 2 Mar 2009 00:30:22 +0000
> > Subject: RE: Vista, Jee5, sql2000 &sql2005
> >
> > Hello,
> >
> > I have finally got round to download this JTDS driver -
> >
> > http://sourceforge.net/project/showfiles.php?group_id=33291&package_id=2...
> >
> > unzip it
> >
> > and copied the jar file -
> >
> > jtds-1.2.2
> >
> > into a directory i created -
> >
> > c:\ClassPath\JTDS\jtds-1.2.2
> >
> > SETUP MY Environmental variables as-
> >
> > CLASSPATH=C:\CLassPath\JTDS\jtds-1.2.2.
> >
> >
> > Also added it to my Application Server\JVM seetings\path settings
> >
> > under
> >
> > Classpath Prefix =C:\CLassPath\JTDS\jtds-1.2.2
> >
> > I get the error -
> >
> > Class name is wrong or classpath is not set for :
> > net.sourceforge.jtds.jdbcx.JtdsDataSource
> >
> >
> > I hope I am on the right track. Any ideas? its my first time
> > of using this driver.
> >
> > thanks.
> >
> > eve
> >
> >
> > > Date: Wed, 4 Feb 2009 15:55:58 -0500
> > > From: ryan@ijws.com
> > > To: users@glassfish.dev.java.net
> > > Subject: Re: FW: Vista, Jee5, sql2000 &sql2005
> > >
> > > The .jar does not come with GlassFish, you have to download it manually.
> > >
> > > I do not recommend using Microsoft's JDBC driver. When we use it in
> > > production to communicate with a remote SQL Server 2005 EE, at least
> > > once per week there is a problem trying to connect to the database. The
> > > Microsoft driver blocks the thread that is asking for a connection
> > > indefinitely. Looking at the FINE/FINER logs, it shows "TDS prelogin
> > > response error". Once this happens 5 times then the HTTP Listener for
> > > your web application can no longer respond to web requests and it looks
> > > like GlassFish is locked up. This happens even when you set the
> > > loginTimeout property. We tested the latest 1.2 version of the driver.
> > >
> > > We use the open source jTDS driver instead. It doesn't have this
> > > problem and works well.
> > >
> > >
> > > Ryan
> > >
> > >
> > >
> > >
> > > Marina Vatkina wrote:
> > > > Did you try to search Microsoft site?
> > > >
> > > > thanks,
> > > > -marina
> > > >
> > > > Dr. Charles O. Odeyale wrote:
> > > >> No, it is not in either location; not even on my system for that
> > > >> matter. I have gone to Sun.com to look for it but came back empty. I
> > > >> will continue to look to download a copy and report back. Is there
> > > >> anything else I may need, or need to do?
> > > >>
> > > >> Thanks.
> > > >>
> > > >> ----- Original Message ----- From:
> > > >> To:
> > > >> Sent: Wednesday, February 04, 2009 1:21 AM
> > > >> Subject: Re: FW: Vista, Jee5, sql2000 &sql2005
> > > >>
> > > >>
> > > >>> Is the sqljdbc.jar copied in the /lib or
> > > >>> /domains/domain1/lib/ext directories? The jar should
> > > >>> be made available to the application server in order to load the
> > > >>> class : com.microsoft.sqlserver.jdbc.SQLServerDataSource.
> > > >>> [Message sent by forum member 'sm157516' (sm157516)]
> > > >>>
> > > >>> http://forums.java.net/jive/thread.jspa?messageID=330006
> > > >>>
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> > > For additional commands, e-mail: users-help@glassfish.dev.java.net
> > >
> >
> > ------------------------------------------------------------------------
> > Beyond Hotmail — see what else you can do with Windows Live. Find out
> > more!
> > ------------------------------------------------------------------------
> > Windows Liveâ„¢: Life without walls. Check it out.
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> For additional commands, e-mail: users-help@glassfish.dev.java.net
>

Windows Live Messenger just got better. Find out more!
_________________________________________________________________
View your Twitter and Flickr updates from one place – Learn more!
http://clk.atdmt.com/UKM/go/137984870/direct/01/
[att1.html]

Ryan de Laplante

I don't think it is possible for a JDBC driver, GlassFish or Java to
have made Management Studio or SQL Server to stop working. I think it
is an unrelated problem.

Once you get it working again, examine the various JDBC driver
properties you can add to the datasource in GlassFish:

http://jtds.sourceforge.net/faq.html#driverImplementation

For example: instance, loginTimeout, portNumber

The connection pools you create in the glassfish admin console get saved
in domains\domain1\config\domain.xml. My dev computer's connection to
SQL Server 2005 looks like this:

associate-with-thread="false" connection-creation-retry-attempts="0"
connection-creation-retry-interval-in-seconds="10"
connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0"
connection-validation-method="auto-commit"
datasource-classname="net.sourceforge.jtds.jdbcx.JtdsDataSource"
fail-all-connections="true" idle-timeout-in-seconds="300"
is-connection-validation-required="true"
is-isolation-level-guaranteed="false"
lazy-connection-association="false" lazy-connection-enlistment="false"
match-connections="false" max-connection-usage-count="0"
max-pool-size="32" max-wait-time-in-millis="60000"
name="CentralDataPool" non-transactional-connections="false"
pool-resize-quantity="2" res-type="javax.sql.ConnectionPoolDataSource"
statement-timeout-in-seconds="-1" steady-pool-size="8"
validate-atmost-once-period-in-seconds="0" wrap-jdbc-objects="false">
a description of this connection pool

Eve Pokua wrote:
> Sorry,
>
> This is what i get when I try to log into the management studio:
>
> TITLE: Connect to Server
> ------------------------------
> Cannot connect to EDELLVE\SQLEXPRESS.
> ------------------------------
> ADDITIONAL INFORMATION:
> A network-related or instance-specific error occurred while
> establishing a connection to SQL Server. The server was not
> found or was not accessible. Verify that the instance name
> is correct and that SQL Server is configured to allow remote c
> onnections. (provider: Shared Memory Provider, error: 40 -
> Could not open a connection to SQL Server) (Microsoft SQL Server,
> Error: 2)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc
> =
> MSSQLServer&EvtID=2&LinkId=20476
> ------------------------------
> BUTTONS:
> OK
>
> ------------------------------------------------------------------------
> From: gorgeous65@msn.com
> To: users@glassfish.dev.java.net
> Date: Mon, 2 Mar 2009 14:16:12 +0000
> Subject: RE: Vista, Jee5, sql2000 &sql2005
>
> Hello Ryan, Martin,
>
> Everyone,
>
> When I create it like what Martin suggested, when I restart the
> application server,
> it gets rid of the directory. I then created it like what
> Ryan suggested, it works but
> I have a different type of problem.
>
> I can't seem to be able to connect to my MS SQL Express even though
> before I could.
> I can't seem to start the service even though before it
> started automatically and it setting
> of automatically is set on the service. Something must be wrong. On
> top of that it says in
> the admin console when I ping- error. Server log -
>
> Caused by: java.sql.SQLException: Unknown server host name
> 'EDELLVE\SQLEXPRESS'.
> at
> net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:377)
> at
> net.sourceforge.jtds.jdbc.ConnectionJDBC3.(ConnectionJDBC3.java:50)
> at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
> at
> net.sourceforge.jtds.jdbcx.JtdsDataSource.getConnection(JtdsDataSource.java:186)
> at
> net.sourceforge.jtds.jdbcx.JtdsDataSource.getPooledConnection(JtdsDataSource.java:264)
> at
> net.sourceforge.jtds.jdbcx.JtdsDataSource.getPooledConnection(JtdsDataSource.java:250)
> at
> com.sun.gjc.spi.CPManagedConnectionFactory.createManagedConnection(CPManagedConnectionFactory.java:126)
> ... 75 more
> Caused by: java.net.UnknownHostException: EDELLVE\SQLEXPRESS
> at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:177)
> |#]
> [#|2009-03-02T14:04:45.315+0000|WARNING|sun-appserver9.1|javax.enterprise.system.stream.err|_ThreadID=14;_ThreadName=httpWorkerThread-4848-0;_RequestID=6445f8cc-0f01-40b4-b059-e8716d72fd6c;| at
> java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
> 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.server.ss.provider.ASPlainSocketImpl$2.run(ASPlainSocketImpl.java:419)
> at java.security.AccessController.doPrivileged(Native Method)
> at
> com.sun.enterprise.server.ss.provider.ASPlainSocketImpl._invoke(ASPlainSocketImpl.java:416)
> at
> com.sun.enterprise.server.ss.provider.ASPlainSocketImpl.connect(ASPlainSocketImpl.java:288)
> at
> com.sun.enterprise.server.ss.provider.ASClientSocketImpl.connect(ASClientSocketImpl.java:267)
> at java.net.Socket.connect(Socket.java:519)
> 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
> net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:304)
> at net.sourceforge.jtds.jdbc.SharedSocket.(SharedSocket.java:255)
> at
> net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:310)
> ... 81 more
> |#]
>
>
> Basically, the server host name is wrong, even though I copied the
> exact name from management
> studio express. And can't log into the Management studio express with
> either SQL Autherication
> or windows; or start the service. But it used to work before that's
> why I was able to create a database
> in it.
>
> Thanks
>
> eve
>
> > Date: Sun, 1 Mar 2009 22:36:34 -0500
> > From: ryan@ijws.com
> > To: users@glassfish.dev.java.net
> > Subject: Re: Vista, Jee5, sql2000 &sql2005
> >
> > I've always put JDBC driver .jar files in domains\domain1\lib\ or
> > domains\domain1\lib\ext\
> >
> > Next create a JDBC Connection Pool and JNDI reference in GlassFish's
> web
> > admin console.
> >
> > I'm not familiar with what Martin Gainty described below (JBI)
> >
> >
> > Martin Gainty wrote:
> > > configure the component thru the admin interface e.g.
> > > http://localhost:4848/
> > >
> > > library should be located in
> > >
> %GLASSFISH_HOME%\domains\domain1\jbi\shared-libraries\jtds\install_root\jtds-1.2.2.jar
> > >
> > > place jbi.xml configuration
> > >
> > >
> %GLASSFISH_HOME%\domains\domain1\jbi\shared-libraries\jtds\install_root\META-INF\jbi.xml
> > >
> > >
> > >

> > > > > > version="1.0"
> > > xmlns="http://java.sun.com/xml/ns/jbi"
> > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
> > >
> > >

> > >
> > >
> > > jtds
> > > blah..blah..blah..
> > >

> > >
> > >
jtds-1.2.2.jar > > >

> > >

> > >
> > >
> > > HTH
> > > Martin
> > > ______________________________________________
> > > Disclaimer and confidentiality note
> > > Everything in this e-mail and any attachments relates to the official
> > > business of Sender. This transmission is of a confidential nature and
> > > Sender does not endorse distribution to any party other than intended
> > > recipient. Sender does not necessarily endorse content contained
> > > within this transmission.
> > >
> > >
> > >
> > >
> > >
> ------------------------------------------------------------------------
> > > From: gorgeous65@msn.com
> > > To: users@glassfish.dev.java.net
> > > Date: Mon, 2 Mar 2009 00:30:22 +0000
> > > Subject: RE: Vista, Jee5, sql2000 &sql2005
> > >
> > > Hello,
> > >
> > > I have finally got round to download this JTDS driver -
> > >
> > >
> http://sourceforge.net/project/showfiles.php?group_id=33291&package_id=2...
> > >
> > > unzip it
> > >
> > > and copied the jar file -
> > >
> > > jtds-1.2.2
> > >
> > > into a directory i created -
> > >
> > > c:\ClassPath\JTDS\jtds-1.2.2
> > >
> > > SETUP MY Environmental variables as-
> > >
> > > CLASSPATH=C:\CLassPath\JTDS\jtds-1.2.2.
> > >
> > >
> > > Also added it to my Application Server\JVM seetings\path settings
> > >
> > > under
> > >
> > > Classpath Prefix =C:\CLassPath\JTDS\jtds-1.2.2
> > >
> > > I get the error -
> > >
> > > Class name is wrong or classpath is not set for :
> > > net.sourceforge.jtds.jdbcx.JtdsDataSource
> > >
> > >
> > > I hope I am on the right track. Any ideas? its my first time
> > > of using this driver.
> > >
> > > thanks.
> > >
> > > eve
> > >
> > >
> > > > Date: Wed, 4 Feb 2009 15:55:58 -0500
> > > > From: ryan@ijws.com
> > > > To: users@glassfish.dev.java.net
> > > > Subject: Re: FW: Vista, Jee5, sql2000 &sql2005
> > > >
> > > > The .jar does not come with GlassFish, you have to download it
> manually.
> > > >
> > > > I do not recommend using Microsoft's JDBC driver. When we use it in
> > > > production to communicate with a remote SQL Server 2005 EE, at least
> > > > once per week there is a problem trying to connect to the
> database. The
> > > > Microsoft driver blocks the thread that is asking for a connection
> > > > indefinitely. Looking at the FINE/FINER logs, it shows "TDS prelogin
> > > > response error". Once this happens 5 times then the HTTP
> Listener for
> > > > your web application can no longer respond to web requests and
> it looks
> > > > like GlassFish is locked up. This happens even when you set the
> > > > loginTimeout property. We tested the latest 1.2 version of the
> driver.
> > > >
> > > > We use the open source jTDS driver instead. It doesn't have this
> > > > problem and works well.
> > > >
> > > >
> > > > Ryan
> > > >
> > > >
> > > >
> > > >
> > > > Marina Vatkina wrote:
> > > > > Did you try to search Microsoft site?
> > > > >
> > > > > thanks,
> > > > > -marina
> > > > >
> > > > > Dr. Charles O. Odeyale wrote:
> > > > >> No, it is not in either location; not even on my system for that
> > > > >> matter. I have gone to Sun.com to look for it but came back
> empty. I
> > > > >> will continue to look to download a copy and report back. Is
> there
> > > > >> anything else I may need, or need to do?
> > > > >>
> > > > >> Thanks.
> > > > >>
> > > > >> ----- Original Message ----- From:
> > > > >> To:
> > > > >> Sent: Wednesday, February 04, 2009 1:21 AM
> > > > >> Subject: Re: FW: Vista, Jee5, sql2000 &sql2005
> > > > >>
> > > > >>
> > > > >>> Is the sqljdbc.jar copied in the /lib or
> > > > >>> /domains/domain1/lib/ext directories? The jar
> should
> > > > >>> be made available to the application server in order to load the
> > > > >>> class : com.microsoft.sqlserver.jdbc.SQLServerDataSource.
> > > > >>> [Message sent by forum member 'sm157516' (sm157516)]
> > > > >>>
> > > > >>> http://forums.java.net/jive/thread.jspa?messageID=330006
> > > > >>>
> > > >
> > > >
> > > >
> ---------------------------------------------------------------------
> > > > To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> > > > For additional commands, e-mail: users-help@glassfish.dev.java.net
> > > >
> > >
> > >
> ------------------------------------------------------------------------
> > > Beyond Hotmail — see what else you can do with Windows Live. Find out
> > > more!
> > >
> ------------------------------------------------------------------------
> > > Windows Liveâ„¢: Life without walls. Check it out.
> > >
>
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> > For additional commands, e-mail: users-help@glassfish.dev.java.net
> >
>
> ------------------------------------------------------------------------
> Windows Live Messenger just got better. Find out more!
>
> ------------------------------------------------------------------------
> Windows Live Hotmail just got better. Find out more!
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
For additional commands, e-mail: users-help@glassfish.dev.java.net

Eve Pokua

Ryan,

Its a MS issue and Im looking and searching on how to resolve it.

Im using Vista as well.

Thanks.

eve

> Date: Mon, 2 Mar 2009 09:53:56 -0500
> From: ryan@ijws.com
> To: users@glassfish.dev.java.net
> Subject: Re: Vista, Jee5, sql2000 &sql2005
>
> I don't think it is possible for a JDBC driver, GlassFish or Java to
> have made Management Studio or SQL Server to stop working. I think it
> is an unrelated problem.
>
> Once you get it working again, examine the various JDBC driver
> properties you can add to the datasource in GlassFish:
>
> http://jtds.sourceforge.net/faq.html#driverImplementation
>
> For example: instance, loginTimeout, portNumber
>
> The connection pools you create in the glassfish admin console get saved
> in domains\domain1\config\domain.xml. My dev computer's connection to
> SQL Server 2005 looks like this:
>
>
> > associate-with-thread="false" connection-creation-retry-attempts="0"
> connection-creation-retry-interval-in-seconds="10"
> connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0"
> connection-validation-method="auto-commit"
> datasource-classname="net.sourceforge.jtds.jdbcx.JtdsDataSource"
> fail-all-connections="true" idle-timeout-in-seconds="300"
> is-connection-validation-required="true"
> is-isolation-level-guaranteed="false"
> lazy-connection-association="false" lazy-connection-enlistment="false"
> match-connections="false" max-connection-usage-count="0"
> max-pool-size="32" max-wait-time-in-millis="60000"
> name="CentralDataPool" non-transactional-connections="false"
> pool-resize-quantity="2" res-type="javax.sql.ConnectionPoolDataSource"
> statement-timeout-in-seconds="-1" steady-pool-size="8"
> validate-atmost-once-period-in-seconds="0" wrap-jdbc-objects="false">
> a description of this connection pool
>
>
>
>
>
>
>

>
>
>
>
> Eve Pokua wrote:
> > Sorry,
> >
> > This is what i get when I try to log into the management studio:
> >
> > TITLE: Connect to Server
> > ------------------------------
> > Cannot connect to EDELLVE\SQLEXPRESS.
> > ------------------------------
> > ADDITIONAL INFORMATION:
> > A network-related or instance-specific error occurred while
> > establishing a connection to SQL Server. The server was not
> > found or was not accessible. Verify that the instance name
> > is correct and that SQL Server is configured to allow remote c
> > onnections. (provider: Shared Memory Provider, error: 40 -
> > Could not open a connection to SQL Server) (Microsoft SQL Server,
> > Error: 2)
> > For help, click:
> > http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc
> > =
> > MSSQLServer&EvtID=2&LinkId=20476
> > ------------------------------
> > BUTTONS:
> > OK
> >
> > ------------------------------------------------------------------------
> > From: gorgeous65@msn.com
> > To: users@glassfish.dev.java.net
> > Date: Mon, 2 Mar 2009 14:16:12 +0000
> > Subject: RE: Vista, Jee5, sql2000 &sql2005
> >
> > Hello Ryan, Martin,
> >
> > Everyone,
> >
> > When I create it like what Martin suggested, when I restart the
> > application server,
> > it gets rid of the directory. I then created it like what
> > Ryan suggested, it works but
> > I have a different type of problem.
> >
> > I can't seem to be able to connect to my MS SQL Express even though
> > before I could.
> > I can't seem to start the service even though before it
> > started automatically and it setting
> > of automatically is set on the service. Something must be wrong. On
> > top of that it says in
> > the admin console when I ping- error. Server log -
> >
> > Caused by: java.sql.SQLException: Unknown server host name
> > 'EDELLVE\SQLEXPRESS'.
> > at
> > net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:377)
> > at
> > net.sourceforge.jtds.jdbc.ConnectionJDBC3.(ConnectionJDBC3.java:50)
> > at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
> > at
> > net.sourceforge.jtds.jdbcx.JtdsDataSource.getConnection(JtdsDataSource.java:186)
> > at
> > net.sourceforge.jtds.jdbcx.JtdsDataSource.getPooledConnection(JtdsDataSource.java:264)
> > at
> > net.sourceforge.jtds.jdbcx.JtdsDataSource.getPooledConnection(JtdsDataSource.java:250)
> > at
> > com.sun.gjc.spi.CPManagedConnectionFactory.createManagedConnection(CPManagedConnectionFactory.java:126)
> > ... 75 more
> > Caused by: java.net.UnknownHostException: EDELLVE\SQLEXPRESS
> > at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:177)
> > |#]
> > [#|2009-03-02T14:04:45.315+0000|WARNING|sun-appserver9.1|javax.enterprise.system.stream.err|_ThreadID=14;_ThreadName=httpWorkerThread-4848-0;_RequestID=6445f8cc-0f01-40b4-b059-e8716d72fd6c;| at
> > java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
> > 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.server.ss.provider.ASPlainSocketImpl$2.run(ASPlainSocketImpl.java:419)
> > at java.security.AccessController.doPrivileged(Native Method)
> > at
> > com.sun.enterprise.server.ss.provider.ASPlainSocketImpl._invoke(ASPlainSocketImpl.java:416)
> > at
> > com.sun.enterprise.server.ss.provider.ASPlainSocketImpl.connect(ASPlainSocketImpl.java:288)
> > at
> > com.sun.enterprise.server.ss.provider.ASClientSocketImpl.connect(ASClientSocketImpl.java:267)
> > at java.net.Socket.connect(Socket.java:519)
> > 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
> > net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:304)
> > at net.sourceforge.jtds.jdbc.SharedSocket.(SharedSocket.java:255)
> > at
> > net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:310)
> > ... 81 more
> > |#]
> >
> >
> > Basically, the server host name is wrong, even though I copied the
> > exact name from management
> > studio express. And can't log into the Management studio express with
> > either SQL Autherication
> > or windows; or start the service. But it used to work before that's
> > why I was able to create a database
> > in it.
> >
> > Thanks
> >
> > eve
> >
> > > Date: Sun, 1 Mar 2009 22:36:34 -0500
> > > From: ryan@ijws.com
> > > To: users@glassfish.dev.java.net
> > > Subject: Re: Vista, Jee5, sql2000 &sql2005
> > >
> > > I've always put JDBC driver .jar files in domains\domain1\lib\ or
> > > domains\domain1\lib\ext\
> > >
> > > Next create a JDBC Connection Pool and JNDI reference in GlassFish's
> > web
> > > admin console.
> > >
> > > I'm not familiar with what Martin Gainty described below (JBI)
> > >
> > >
> > > Martin Gainty wrote:
> > > > configure the component thru the admin interface e.g.
> > > > http://localhost:4848/
> > > >
> > > > library should be located in
> > > >
> > %GLASSFISH_HOME%\domains\domain1\jbi\shared-libraries\jtds\install_root\jtds-1.2.2.jar
> > > >
> > > > place jbi.xml configuration
> > > >
> > > >
> > %GLASSFISH_HOME%\domains\domain1\jbi\shared-libraries\jtds\install_root\META-INF\jbi.xml
> > > >
> > > >
> > > >

> > > > > > > > version="1.0"
> > > > xmlns="http://java.sun.com/xml/ns/jbi"
> > > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
> > > >
> > > >

> > > >
> > > >
> > > > jtds
> > > > blah..blah..blah..
> > > >

> > > >
> > > >
jtds-1.2.2.jar > > > >

> > > >

> > > >
> > > >
> > > > HTH
> > > > Martin
> > > > ______________________________________________
> > > > Disclaimer and confidentiality note
> > > > Everything in this e-mail and any attachments relates to the official
> > > > business of Sender. This transmission is of a confidential nature and
> > > > Sender does not endorse distribution to any party other than intended
> > > > recipient. Sender does not necessarily endorse content contained
> > > > within this transmission.
> > > >
> > > >
> > > >
> > > >
> > > >
> > ------------------------------------------------------------------------
> > > > From: gorgeous65@msn.com
> > > > To: users@glassfish.dev.java.net
> > > > Date: Mon, 2 Mar 2009 00:30:22 +0000
> > > > Subject: RE: Vista, Jee5, sql2000 &sql2005
> > > >
> > > > Hello,
> > > >
> > > > I have finally got round to download this JTDS driver -
> > > >
> > > >
> > http://sourceforge.net/project/showfiles.php?group_id=33291&package_id=2...
> > > >
> > > > unzip it
> > > >
> > > > and copied the jar file -
> > > >
> > > > jtds-1.2.2
> > > >
> > > > into a directory i created -
> > > >
> > > > c:\ClassPath\JTDS\jtds-1.2.2
> > > >
> > > > SETUP MY Environmental variables as-
> > > >
> > > > CLASSPATH=C:\CLassPath\JTDS\jtds-1.2.2.
> > > >
> > > >
> > > > Also added it to my Application Server\JVM seetings\path settings
> > > >
> > > > under
> > > >
> > > > Classpath Prefix =C:\CLassPath\JTDS\jtds-1.2.2
> > > >
> > > > I get the error -
> > > >
> > > > Class name is wrong or classpath is not set for :
> > > > net.sourceforge.jtds.jdbcx.JtdsDataSource
> > > >
> > > >
> > > > I hope I am on the right track. Any ideas? its my first time
> > > > of using this driver.
> > > >
> > > > thanks.
> > > >
> > > > eve
> > > >
> > > >
> > > > > Date: Wed, 4 Feb 2009 15:55:58 -0500
> > > > > From: ryan@ijws.com
> > > > > To: users@glassfish.dev.java.net
> > > > > Subject: Re: FW: Vista, Jee5, sql2000 &sql2005
> > > > >
> > > > > The .jar does not come with GlassFish, you have to download it
> > manually.
> > > > >
> > > > > I do not recommend using Microsoft's JDBC driver. When we use it in
> > > > > production to communicate with a remote SQL Server 2005 EE, at least
> > > > > once per week there is a problem trying to connect to the
> > database. The
> > > > > Microsoft driver blocks the thread that is asking for a connection
> > > > > indefinitely. Looking at the FINE/FINER logs, it shows "TDS prelogin
> > > > > response error". Once this happens 5 times then the HTTP
> > Listener for
> > > > > your web application can no longer respond to web requests and
> > it looks
> > > > > like GlassFish is locked up. This happens even when you set the
> > > > > loginTimeout property. We tested the latest 1.2 version of the
> > driver.
> > > > >
> > > > > We use the open source jTDS driver instead. It doesn't have this
> > > > > problem and works well.
> > > > >
> > > > >
> > > > > Ryan
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Marina Vatkina wrote:
> > > > > > Did you try to search Microsoft site?
> > > > > >
> > > > > > thanks,
> > > > > > -marina
> > > > > >
> > > > > > Dr. Charles O. Odeyale wrote:
> > > > > >> No, it is not in either location; not even on my system for that
> > > > > >> matter. I have gone to Sun.com to look for it but came back
> > empty. I
> > > > > >> will continue to look to download a copy and report back. Is
> > there
> > > > > >> anything else I may need, or need to do?
> > > > > >>
> > > > > >> Thanks.
> > > > > >>
> > > > > >> ----- Original Message ----- From:
> > > > > >> To:
> > > > > >> Sent: Wednesday, February 04, 2009 1:21 AM
> > > > > >> Subject: Re: FW: Vista, Jee5, sql2000 &sql2005
> > > > > >>
> > > > > >>
> > > > > >>> Is the sqljdbc.jar copied in the /lib or
> > > > > >>> /domains/domain1/lib/ext directories? The jar
> > should
> > > > > >>> be made available to the application server in order to load the
> > > > > >>> class : com.microsoft.sqlserver.jdbc.SQLServerDataSource.
> > > > > >>> [Message sent by forum member 'sm157516' (sm157516)]
> > > > > >>>
> > > > > >>> http://forums.java.net/jive/thread.jspa?messageID=330006
> > > > > >>>
> > > > >
> > > > >
> > > > >
> > ---------------------------------------------------------------------
> > > > > To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> > > > > For additional commands, e-mail: users-help@glassfish.dev.java.net
> > > > >
> > > >
> > > >
> > ------------------------------------------------------------------------
> > > > Beyond Hotmail — see what else you can do with Windows Live. Find out
> > > > more!
> > > >
> > ------------------------------------------------------------------------
> > > > Windows Liveâ„¢: Life without walls. Check it out.
> > > >
> >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> > > For additional commands, e-mail: users-help@glassfish.dev.java.net
> > >
> >
> > ------------------------------------------------------------------------
> > Windows Live Messenger just got better. Find out more!
> >
> > ------------------------------------------------------------------------
> > Windows Live Hotmail just got better. Find out more!
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> For additional commands, e-mail: users-help@glassfish.dev.java.net
>

_________________________________________________________________
All your Twitter and other social updates in one place
http://clk.atdmt.com/UKM/go/137984870/direct/01/
[att1.html]

sm157516
Offline
Joined: 2005-03-28

Please attach your jdbc-connection-pool element configuration from the domain.xml. From this, we could see if adding any additional property could solve your issue. domain.xml is found under /domains//config directory.

Eve Pokua

hello,

I've attached the file as requested. But even, starting the service of the

SQL server says - i need administration previleges. im using Vista. and

2005 SQL server express. So more likely MS issue. But if you've similar issue, pls let me know.

thanks

eve

> Date: Mon, 2 Mar 2009 20:34:07 -0800
> From: glassfish@javadesktop.org
> To: users@glassfish.dev.java.net
> Subject: Re: RE: Vista, Jee5, sql2000 &sql2005
>
> Please attach your jdbc-connection-pool element configuration from the domain.xml. From this, we could see if adding any additional property could solve your issue. domain.xml is found under /domains//config directory.
> [Message sent by forum member 'sm157516' (sm157516)]
>
> http://forums.java.net/jive/thread.jspa?messageID=334707
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> For additional commands, e-mail: users-help@glassfish.dev.java.net
>

_________________________________________________________________
View your Twitter and Flickr updates from one place – Learn more!
http://clk.atdmt.com/UKM/go/137984870/direct/01/
[att1.html]
[domain.xml]
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
For additional commands, e-mail: users-help@glassfish.dev.java.net

Martin Gainty

can you run the service as Windows Compatibility Mode
AND Run as Administrator
Keep in Mind later versions of SQLServer (such as 05) do not run without .NET Framework
(last time I checked you needed .NET Framework 2.0)

Martin
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.

From: gorgeous65@msn.com
To: users@glassfish.dev.java.net
Date: Tue, 3 Mar 2009 12:13:26 +0000
Subject: RE: Vista, Jee5, sql2000 &sql2005

hello,

I've attached the file as requested. But even, starting the service of the

SQL server says - i need administration previleges. im using Vista. and

2005 SQL server express. So more likely MS issue. But if you've similar issue, pls let me know.

thanks

eve

> Date: Mon, 2 Mar 2009 20:34:07 -0800
> From: glassfish@javadesktop.org
> To: users@glassfish.dev.java.net
> Subject: Re: RE: Vista, Jee5, sql2000 &sql2005
>
> Please attach your jdbc-connection-pool element configuration from the domain.xml. From this, we could see if adding any additional property could solve your issue. domain.xml is found under /domains//config directory.
> [Message sent by forum member 'sm157516' (sm157516)]
>
> http://forums.java.net/jive/thread.jspa?messageID=334707
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> For additional commands, e-mail: users-help@glassfish.dev.java.net
>

Beyond Hotmail — see what else you can do with Windows Live. Find out more!
_________________________________________________________________
Windows Liveâ„¢ Groups: Create an online spot for your favorite groups to meet.
http://windowslive.com/online/groups?ocid=TXT_TAGLM_WL_groups_032009
[att1.html]

Eve Pokua

Martin,

i've tried both windows and sql mode. And im log on as administrator.

.net framework 3.1 sp1 is installed. So what im I doing wrong?

thanks

eve

From: mgainty@hotmail.com
To: users@glassfish.dev.java.net
Date: Tue, 3 Mar 2009 08:02:16 -0500
Subject: RE: Vista, Jee5, sql2000 &sql2005

can you run the service as Windows Compatibility Mode
AND Run as Administrator
Keep in Mind later versions of SQLServer (such as 05) do not run without .NET Framework
(last time I checked you needed .NET Framework 2.0)

Martin
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission.

From: gorgeous65@msn.com
To: users@glassfish.dev.java.net
Date: Tue, 3 Mar 2009 12:13:26 +0000
Subject: RE: Vista, Jee5, sql2000 &sql2005

hello,

I've attached the file as requested. But even, starting the service of the
SQL server says - i need administration previleges. im using Vista. and
2005 SQL server express. So more likely MS issue. But if you've similar issue, pls let me know.

thanks
eve

> Date: Mon, 2 Mar 2009 20:34:07 -0800
> From: glassfish@javadesktop.org
> To: users@glassfish.dev.java.net
> Subject: Re: RE: Vista, Jee5, sql2000 &sql2005
>
> Please attach your jdbc-connection-pool element configuration from the domain.xml. From this, we could see if adding any additional property could solve your issue. domain.xml is found under /domains//config directory.
> [Message sent by forum member 'sm157516' (sm157516)]
>
> http://forums.java.net/jive/thread.jspa?messageID=334707
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> For additional commands, e-mail: users-help@glassfish.dev.java.net
>

Beyond Hotmail — see what else you can do with Windows Live. Find out more!

Windows Liveâ„¢ Groups: Create an online spot for your favorite groups to meet. Check it out.
_________________________________________________________________
25GB of FREE Online Storage – Find out more
http://clk.atdmt.com/UKM/go/134665320/direct/01/
[att1.html]

Dennis Gesker

Eve:

I'm jumping in the thread a little late so if I'm answering the wrong
question I apologize in advance. But, my dev machine seems to be setup
similar to what you are trying to setup so I thought maybe I could
offer some tips

I had been using MS-SQL 2008 express on Vista 64 (jdk_1.6.0._11,
glassfish-v2.1b60f) however my issue was not the driver. My issue was
that MS-SQL Express seemed to not enable TCP/IP by default so I had to
enable it using the configuration manager.

Once TCP/IP was enabled I was able to connect using the jTDS driver.
However, I was not able to connect using Microsofts' driver. The
driver complained about ms-sql 2008 express being an incorrect
version. I did find a pre-release of the next version of the jdbc
driver (sqljdbc4.jar) that seemed to work OK on the MS Website. There
were two jars (sqljdbc4.jar and sqljdbc.jar) in the pre-release
version. You will only need sqljdbc4.jar.

By the way, I also recommend just copying the needed jars to the
glassfish/lib directory as the easiest way to make glassfish aware of
the driver.

Also, just as an FYI there is a very useful file that you can add to
your [ProjectName]\setup folder called sun-resources.xml where you can
put in all the settings for your database pool/connection. When you
put this file in the setup folder is shows up under the "Server
Resources" node in NetBeans which is really convenient

Just as a reference my sun-resources.xml file (using the jTDS Driver)
looks kind of like:


Server 9.0 Resource Definitions //EN"
"http://www.sun.com/software/appserver/dtds/sun-resources_1_3.dtd">

object-type="user" pool-name="MyDbPool"/>

associate-with-thread="false" connection-creation-retry-attempts="0"
connection-creation-retry-interval-in-seconds="10"
connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0"
connection-validation-method="auto-commit"
datasource-classname="net.sourceforge.jtds.jdbcx.JtdsDataSource"
fail-all-connections="false" idle-timeout-in-seconds="300"
is-connection-validation-required="false"
is-isolation-level-guaranteed="true"
lazy-connection-association="false" lazy-connection-enlistment="false"
match-connections="false" max-connection-usage-count="0"
max-pool-size="128" max-wait-time-in-millis="60000" name="MyDbPool"
non-transactional-connections="false" pool-resize-quantity="2"
res-type="javax.sql.ConnectionPoolDataSource"
statement-timeout-in-seconds="-1" steady-pool-size="16"
validate-atmost-once-period-in-seconds="0" wrap-jdbc-objects="false">

With a few modifications you can adjust the above file contents for
the MS-JDBC driver.

Finally, a while back I posted some directions for getting JSPWiki
running on Glassfish. This series of postings also includes some step
by step for setting up Db/JDBC (though more specific to jdbc auth)
which you may find helpful.

http://gesker.blogspot.com/2007/03/jspwikiglassfish-install-part-1.html
http://gesker.blogspot.com/2007/03/jspwikiglassfish-install-part-10-of-1...
http://gesker.blogspot.com/2007/03/jspwikiglassfish-install-part-11-of-1...

Anyway, I hope that helps to get you going. Good luck with your project.

Dennis

On Tue, Mar 3, 2009 at 8:48 AM, Eve Pokua wrote:
>
>  Martin,
>
>  i've tried both windows and sql mode. And im log on as administrator.
>
> .net framework 3.1 sp1 is installed.  So what  im  I doing wrong?
>
>  thanks
>
> eve
> ________________________________
> From: mgainty@hotmail.com
> To: users@glassfish.dev.java.net
> Date: Tue, 3 Mar 2009 08:02:16 -0500
> Subject: RE: Vista, Jee5, sql2000 &sql2005
>
> can you run the service as Windows Compatibility Mode
> AND Run as Administrator
> Keep in Mind later versions of SQLServer (such as 05) do not run without
> .NET Framework
> (last time I checked you needed .NET Framework 2.0)
>
> Martin
> ______________________________________________
> Disclaimer and confidentiality note
> Everything in this e-mail and any attachments relates to the official
> business of Sender. This transmission is of a confidential nature and Sender
> does not endorse distribution to any party other than intended recipient.
> Sender does not necessarily endorse content contained within this
> transmission.
>
>
>
>
> ________________________________
> From: gorgeous65@msn.com
> To: users@glassfish.dev.java.net
> Date: Tue, 3 Mar 2009 12:13:26 +0000
> Subject: RE: Vista, Jee5, sql2000 &sql2005
>
>    hello,
>
> I've attached the file as requested.   But even, starting the service of the
> SQL server says -  i need administration previleges.  im using Vista. and
> 2005 SQL server express.  So more likely  MS issue.  But if you've similar
> issue, pls let me know.
>
>
>
> thanks
> eve
>
>> Date: Mon, 2 Mar 2009 20:34:07 -0800
>> From: glassfish@javadesktop.org
>> To: users@glassfish.dev.java.net
>> Subject: Re: RE: Vista, Jee5, sql2000 &sql2005
>>
>> Please attach your jdbc-connection-pool element configuration from the
>> domain.xml. From this, we could see if adding any additional property could
>> solve your issue. domain.xml is found under
>> /domains//config directory.
>> [Message sent by forum member 'sm157516' (sm157516)]
>>
>> http://forums.java.net/jive/thread.jspa?messageID=334707
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
>> For additional commands, e-mail: users-help@glassfish.dev.java.net
>>
>
> ________________________________
> Beyond Hotmail — see what else you can do with Windows Live. Find out more!
> ________________________________
> Windows Liveâ„¢ Groups: Create an online spot for your favorite groups to
> meet. Check it out.
> ________________________________
> Share your photos with Windows Live Photos – Free. Try it Now!

--
Dennis R. Gesker
email: dennis@gesker.com
google talk: gesker@gmail.com
aim: dennisgesker
pgp/gpg: 0x267D3FE8
First things first, but not necessarily in that order. -- Unknown

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
For additional commands, e-mail: users-help@glassfish.dev.java.net

Eve Pokua

Hello Dennis,

Thanks for your reply. The problem is not the driver. i can't seem to start

the MS SQL server service. Something about administrator windows logon. But I'm log on

as administrator. here's the error -

Caused by: javax.resource.spi.ResourceAllocationException: Connection could not be allocated because: Network error IOException: Connection refused: connect
at com.sun.gjc.spi.CPManagedConnectionFactory.createManagedConnection(CPManagedConnectionFactory.java:138)
at com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.getUnpooledConnection(ConnectorConnectionPoolAdminServiceImpl.java:1304)
at com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.testConnectionPool(ConnectorConnectionPoolAdminServiceImpl.java:551)
... 73 more
Caused by: java.sql.SQLException: Network error IOException: Connection refused: connect
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.(ConnectionJDBC2.java:385)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
at net.sourceforge.jtds.jdbcx.JtdsDataSource.getConnection(JtdsDataSource.java:186)
at net.sourceforge.jtds.jdbcx.JtdsDataSource.getPooledConnection(JtdsDataSource.java:264)
at net.sourceforge.jtds.jdbcx.JtdsDataSource.getPooledConnection(JtdsDataSource.java:250)
at com.sun.gjc.spi.CPManagedConnectionFactory.createManagedConnection(CPManagedConnectionFactory.java:126)
... 75 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImp|#]

[#|2009-03-03T13:52:14.510+0000|WARNING|sun-appserver9.1|javax.enterprise.system.stream.err|_ThreadID=15;_ThreadName=httpWorkerThread-4848-1;_RequestID=ddb9a77b-d28b-43cd-a28c-307d10777e61;|l.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
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.server.ss.provider.ASPlainSocketImpl$2.run(ASPlainSocketImpl.java:419)
at java.security.AccessController.doPrivileged(Native Method)
at com.sun.enterprise.server.ss.provider.ASPlainSocketImpl._invoke(ASPlainSocketImpl.java:416)
at com.sun.enterprise.server.ss.provider.ASPlainSocketImpl.connect(ASPlainSocketImpl.java:288)
at com.sun.enterprise.server.ss.provider.ASClientSocketImpl.connect(ASClientSocketImpl.java:267)
at java.net.Socket.connect(Socket.java:519)

It says connection refuse.

Thanks.

eve

> Date: Tue, 3 Mar 2009 14:40:29 -0700
> From: dennis@gesker.com
> To: users@glassfish.dev.java.net
> CC: ejb@glassfish.dev.java.net; persistence@glassfish.dev.java.net
> Subject: Re: Vista, Jee5, sql2000 &sql2005
>
> Eve:
>
> I'm jumping in the thread a little late so if I'm answering the wrong
> question I apologize in advance. But, my dev machine seems to be setup
> similar to what you are trying to setup so I thought maybe I could
> offer some tips
>
> I had been using MS-SQL 2008 express on Vista 64 (jdk_1.6.0._11,
> glassfish-v2.1b60f) however my issue was not the driver. My issue was
> that MS-SQL Express seemed to not enable TCP/IP by default so I had to
> enable it using the configuration manager.
>
> Once TCP/IP was enabled I was able to connect using the jTDS driver.
> However, I was not able to connect using Microsofts' driver. The
> driver complained about ms-sql 2008 express being an incorrect
> version. I did find a pre-release of the next version of the jdbc
> driver (sqljdbc4.jar) that seemed to work OK on the MS Website. There
> were two jars (sqljdbc4.jar and sqljdbc.jar) in the pre-release
> version. You will only need sqljdbc4.jar.
>
> By the way, I also recommend just copying the needed jars to the
> glassfish/lib directory as the easiest way to make glassfish aware of
> the driver.
>
> Also, just as an FYI there is a very useful file that you can add to
> your [ProjectName]\setup folder called sun-resources.xml where you can
> put in all the settings for your database pool/connection. When you
> put this file in the setup folder is shows up under the "Server
> Resources" node in NetBeans which is really convenient
>
> Just as a reference my sun-resources.xml file (using the jTDS Driver)
> looks kind of like:
>
>
> > Server 9.0 Resource Definitions //EN"
> "http://www.sun.com/software/appserver/dtds/sun-resources_1_3.dtd">
>
> > object-type="user" pool-name="MyDbPool"/>
>
> > associate-with-thread="false" connection-creation-retry-attempts="0"
> connection-creation-retry-interval-in-seconds="10"
> connection-leak-reclaim="false" connection-leak-timeout-in-seconds="0"
> connection-validation-method="auto-commit"
> datasource-classname="net.sourceforge.jtds.jdbcx.JtdsDataSource"
> fail-all-connections="false" idle-timeout-in-seconds="300"
> is-connection-validation-required="false"
> is-isolation-level-guaranteed="true"
> lazy-connection-association="false" lazy-connection-enlistment="false"
> match-connections="false" max-connection-usage-count="0"
> max-pool-size="128" max-wait-time-in-millis="60000" name="MyDbPool"
> non-transactional-connections="false" pool-resize-quantity="2"
> res-type="javax.sql.ConnectionPoolDataSource"
> statement-timeout-in-seconds="-1" steady-pool-size="16"
> validate-atmost-once-period-in-seconds="0" wrap-jdbc-objects="false">
>
>
>
>
>
>
>

>
>
>
>
>
>
> With a few modifications you can adjust the above file contents for
> the MS-JDBC driver.
>
> Finally, a while back I posted some directions for getting JSPWiki
> running on Glassfish. This series of postings also includes some step
> by step for setting up Db/JDBC (though more specific to jdbc auth)
> which you may find helpful.
>
> http://gesker.blogspot.com/2007/03/jspwikiglassfish-install-part-1.html
> http://gesker.blogspot.com/2007/03/jspwikiglassfish-install-part-10-of-1...
> http://gesker.blogspot.com/2007/03/jspwikiglassfish-install-part-11-of-1...
>
>
> Anyway, I hope that helps to get you going. Good luck with your project.
>
> Dennis
>
>
>
> On Tue, Mar 3, 2009 at 8:48 AM, Eve Pokua wrote:
> >
> > Martin,
> >
> > i've tried both windows and sql mode. And im log on as administrator.
> >
> > .net framework 3.1 sp1 is installed. So what im I doing wrong?
> >
> > thanks
> >
> > eve
> > ________________________________
> > From: mgainty@hotmail.com
> > To: users@glassfish.dev.java.net
> > Date: Tue, 3 Mar 2009 08:02:16 -0500
> > Subject: RE: Vista, Jee5, sql2000 &sql2005
> >
> > can you run the service as Windows Compatibility Mode
> > AND Run as Administrator
> > Keep in Mind later versions of SQLServer (such as 05) do not run without
> > .NET Framework
> > (last time I checked you needed .NET Framework 2.0)
> >
> > Martin
> > ______________________________________________
> > Disclaimer and confidentiality note
> > Everything in this e-mail and any attachments relates to the official
> > business of Sender. This transmission is of a confidential nature and Sender
> > does not endorse distribution to any party other than intended recipient.
> > Sender does not necessarily endorse content contained within this
> > transmission.
> >
> >
> >
> >
> > ________________________________
> > From: gorgeous65@msn.com
> > To: users@glassfish.dev.java.net
> > Date: Tue, 3 Mar 2009 12:13:26 +0000
> > Subject: RE: Vista, Jee5, sql2000 &sql2005
> >
> > hello,
> >
> > I've attached the file as requested. But even, starting the service of the
> > SQL server says - i need administration previleges. im using Vista. and
> > 2005 SQL server express. So more likely MS issue. But if you've similar
> > issue, pls let me know.
> >
> >
> >
> > thanks
> > eve
> >
> >> Date: Mon, 2 Mar 2009 20:34:07 -0800
> >> From: glassfish@javadesktop.org
> >> To: users@glassfish.dev.java.net
> >> Subject: Re: RE: Vista, Jee5, sql2000 &sql2005
> >>
> >> Please attach your jdbc-connection-pool element configuration from the
> >> domain.xml. From this, we could see if adding any additional property could
> >> solve your issue. domain.xml is found under
> >> /domains//config directory.
> >> [Message sent by forum member 'sm157516' (sm157516)]
> >>
> >> http://forums.java.net/jive/thread.jspa?messageID=334707
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> >> For additional commands, e-mail: users-help@glassfish.dev.java.net
> >>
> >
> > ________________________________
> > Beyond Hotmail — see what else you can do with Windows Live. Find out more!
> > ________________________________
> > Windows Liveâ„¢ Groups: Create an online spot for your favorite groups to
> > meet. Check it out.
> > ________________________________
> > Share your photos with Windows Live Photos – Free. Try it Now!
>
>
>
> --
> Dennis R. Gesker
> email: dennis@gesker.com
> google talk: gesker@gmail.com
> aim: dennisgesker
> pgp/gpg: 0x267D3FE8
> First things first, but not necessarily in that order. -- Unknown
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@glassfish.dev.java.net
> For additional commands, e-mail: users-help@glassfish.dev.java.net
>

_________________________________________________________________
View your Twitter and Flickr updates from one place – Learn more!
http://clk.atdmt.com/UKM/go/137984870/direct/01/
[att1.html]