Hi,
Before few days (02.03 - 05.03) after one Microsoft update on my Windows
Vista I lost the access to my GlassFish. The only way to access it was using
127.0.0.1 because all other names like localhost, my_computer_name were
unavailable. When I removed the Updates and install new GF (the last)
everything was OK.
Miro.
On Mon, Mar 9, 2009 at 3:48 AM, Martin Gainty <mgainty_at_hotmail.com> wrote:
> if its not Socket permissions i would follow dennis' advice and make sure
> 1433 is open
>
> cmd>netstat -aon | grep 1433
>
> if you see the entry find the pid
> then quiesce the process with that pid
>
> If you're in windows starting in 'safe mode' will ensure automatic services
> won't occupy port 1433
>
> 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_at_msn.com
> To: users_at_glassfish.dev.java.net; ejb_at_glassfish.dev.java.net
> CC: persistence_at_glassfish.dev.java.net
> Date: Wed, 4 Mar 2009 13:34:29 +0000
> Subject: RE: Vista, Jee5, sql2000 &sql2005
>
> hi, Martin,
>
>
> Yes - it yes.
>
> permission java.lang.RuntimePermission "loadLibrary.*";
> permission java.lang.RuntimePermission "queuePrintJob";
> permission java.net.SocketPermission "*", "connect";
> permission java.io.FilePermission "<<ALL FILES>>", "read,write";
>
>
> eve
>
>
> ------------------------------
> From: mgainty_at_hotmail.com
> To: users_at_glassfish.dev.java.net; ejb_at_glassfish.dev.java.net
> CC: persistence_at_glassfish.dev.java.net
> Date: Tue, 3 Mar 2009 21:42:14 -0500
> Subject: RE: Vista, Jee5, sql2000 &sql2005
>
> make sure the SocketPermission Grant is on (for connect) in your
> server.policy for port 1433
>
> $GLASSFISH_HOME/domains/domain1/config/server.policy
> grant {
> //Workaround for bugs #6484935, 6513799
> permission java.lang.RuntimePermission "getProtectionDomain";
> permission
> com.sun.corba.ee.impl.presentation.rmi.DynamicAccessPermission "access";
> permission java.util.PropertyPermission "*", "read,write";
>
> permission java.lang.RuntimePermission "loadLibrary.*";
> permission java.lang.RuntimePermission "queuePrintJob";
> permission java.net.SocketPermission "*", "connect";
> ........
> }
>
> telnet and hypertrm were deemed "too useful and necessary" to be included
> in vista
>
> putty to the rescue..
> http://www.chiark.greenend.org.uk/~sgtatham/putty/<http://www.chiark.greenend.org.uk/%7Esgtatham/putty/>
>
> 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_at_msn.com
> To: ejb_at_glassfish.dev.java.net
> CC: users_at_glassfish.dev.java.net; persistence_at_glassfish.dev.java.net
> Date: Wed, 4 Mar 2009 00:42:44 +0000
> Subject: RE: Vista, Jee5, sql2000 &sql2005
>
> Dennis,
>
> Thank you ever so much. I still have errors:
>
> C:\Users\eve>telnet 127.0.0.1 1433
> 'telnet' is not recognized as an internal or external command,
> operable program or batch file.
> C:\Users\eve>
>
>
> SQL 2000 was so easy to setup. But its not compatible with Vista.
>
>
> Caused by: javax.resource.spi.ResourceAllocationException: Connection could
> not be allocated because: The TCP/IP connection to the host has failed.
> java.net.ConnectException: Connection refused: connect
> at
> com.sun.gjc.spi.DSManagedConnectionFactory.createManagedConnection(DSManagedConnectionFactory.java:119)
> at
> com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.getUnpooledConnection(ConnectorConnectionPoolAdminServiceImpl.java:1304)
> at
> com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.testConnectionPool(ConnectorConnectionPoolAdminServiceImpl.java:551)
> ... 73 more
> Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP
> connection to the host has failed. java.net.ConnectException: Connection
> refused: connect
> at
> com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown
> Source)
> at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown
> Source)
> at
> com.microsoft.sqlserver.jdbc.SQLServerDataSource.getConnectionInternal(Unknown
> Source)
> at com.microsoft.sqlserver.jdbc.SQLServerDataSource.getConnection(Unknown
> Source)
> at
> com.sun.gjc.spi.DSManagedConnectionFactory.createManagedConnection(DSManagedConnectionFactory.java:107)
> ... 75 more
> |#]
>
>
> Datasource Classname:
> com.microsoft.sqlserver.jdbc.SQLServerDataSource
>
> sqljdbc.jar
>
> is copied to domain1\lib
>
> Thanks
>
> eve
>
>
> > Date: Tue, 3 Mar 2009 17:07:25 -0700
> > From: dennis_at_gesker.com
> > To: ejb_at_glassfish.dev.java.net
> > Subject: Re: Vista, Jee5, sql2000 &sql2005
> >
> > What happens when you try to telnet to 127.0.0.1 1433 from the cmd
> console?
> >
> > Start --> CMD (enter in search box)
> > telnet 127.0.0.1 1433 (hit enter)
> >
> > Dennis
> >
> > On Tue, Mar 3, 2009 at 4:57 PM, Eve Pokua <gorgeous65_at_msn.com> wrote:
> > > 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_at_gesker.com
> > >> To: users_at_glassfish.dev.java.net
> > >> CC: ejb_at_glassfish.dev.java.net; persistence_at_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 <dennis_at_gesker.com>
> 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:
> > >> >
> > >> > <?xml version="1.0" encoding="UTF-8"?>
> > >> > <!DOCTYPE resources PUBLIC "-//Sun Microsystems, Inc.//DTD
> Application
> > >> > Server 9.0 Resource Definitions //EN"
> > >> > "http://www.sun.com/software/appserver/dtds/sun-resources_1_3.dtd">
> > >> > <resources>
> > >> > <jdbc-resource enabled="true" jndi-name="jdbc/MyDb"
> > >> > object-type="user" pool-name="MyDbPool"/>
> > >> >
> > >> > <jdbc-connection-pool allow-non-component-callers="false"
> > >> > 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">
> > >> > <property name="serverName" value="127.0.0.1"/>
> > >> > <property name="port" value="1433"/>
> > >> > <property name="appName" value="GlassfishAppServer"/>
> > >> > <property name="databaseName" value="MyDb"/>
> > >> > <property name="user" value="sa"/>
> > >> > <property name="password" value="mySecretPassword"/>
> > >> > <!-- <property name="URL"
> > >> >
> > >> >
> value="jdbc:jtds:sqlserver://localhost:1433/MyDb;tds=8.0;lastupdatecount=true"/>
> > >> > -->
> > >> > </jdbc-connection-pool>
> > >> >
> > >> >
> > >> > </resources>
> > >> >
> > >> >
> > >> > 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-18.html
> > >> >
> > >> >
> http://gesker.blogspot.com/2007/03/jspwikiglassfish-install-part-11-of-18.html
> > >> >
> > >> >
> > >> > 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 <gorgeous65_at_msn.com>
> 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_at_hotmail.com
> > >> >> To: users_at_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_at_msn.com
> > >> >> To: users_at_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_at_javadesktop.org
> > >> >>> To: users_at_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
> > >> >>> <install_root>/domains/<domain_name>/config directory.
> > >> >>> [Message sent by forum member 'sm157516' (sm157516)]
> > >> >>>
> > >> >>> http://forums.java.net/jive/thread.jspa?messageID=334707
> > >> >>>
> > >> >>>
> ---------------------------------------------------------------------
> > >> >>> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> > >> >>> For additional commands, e-mail:
> users-help_at_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_at_gesker.com
> > >> > google talk: gesker_at_gmail.com
> > >> > aim: dennisgesker
> > >> > pgp/gpg: 0x267D3FE8
> > >> > First things first, but not necessarily in that order. -- Unknown
> > >> >
> > >>
> > >>
> > >>
> > >> --
> > >> Dennis R. Gesker
> > >> email: dennis_at_gesker.com
> > >> google talk: gesker_at_gmail.com
> > >> aim: dennisgesker
> > >> pgp/gpg: 0x267D3FE8
> > >> First things first, but not necessarily in that order. -- Unknown
> > >>
> > >> ---------------------------------------------------------------------
> > >> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> > >> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
> > >>
> > >
> > > ________________________________
> > > Windows Live just got better. Find out more!
> >
> >
> >
> > --
> > Dennis R. Gesker
> > email: dennis_at_gesker.com
> > google talk: gesker_at_gmail.com
> > aim: dennisgesker
> > pgp/gpg: 0x267D3FE8
> > First things first, but not necessarily in that order. -- Unknown
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: ejb-unsubscribe_at_glassfish.dev.java.net
> > For additional commands, e-mail: ejb-help_at_glassfish.dev.java.net
> >
>
> ------------------------------
> Beyond Hotmail — see what else you can do with Windows Live. Find out
> more!
> ------------------------------
> Hotmail® is up to 70% faster. Now good news travels really fast. Find out
> more.<http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_HM_70faster_032009>
> ------------------------------
> Windows Live Hotmail just got better. Find out more!<http://clk.atdmt.com/UKM/go/134665311/direct/01/>
> ------------------------------
> Windows Live™: Keep your life in sync. Check it out.<http://windowslive.com/explore?ocid=TXT_TAGLM_WL_allup_1b_explore_032009>
>