users@glassfish.java.net

RE: Vista, Jee5, sql2000 &sql2005

From: Eve Pokua <gorgeous65_at_msn.com>
Date: Mon, 2 Mar 2009 14:19:08 +0000

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_at_msn.com
To: users_at_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.<init>(ConnectionJDBC2.java:377)
 at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(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.<init>(SharedSocket.java:255)
 at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(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_at_ijws.com
> To: users_at_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
> >
> > <?xml version="1.0"?>
> > <!-- jbi.xml file for a sample shared library. -->
> > <jbi
> > version="1.0"
> > xmlns="http://java.sun.com/xml/ns/jbi"
> > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
> >
> > <!-- identification information about this shared library-->
> > <shared-library>
> > <identification>
> > <name>jtds</name>
> > <description>blah..blah..blah..</description>
> > </identification>
> > <shared-library-class-path>
> > <path-element>jtds-1.2.2.jar</path-element>
> > </shared-library-class-path>
> > </shared-library>
> > </jbi>
> >
> > 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_at_msn.com
> > To: users_at_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=25350&release_id=534076#
> >
> > 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_at_ijws.com
> > > To: users_at_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: <glassfish_at_javadesktop.org>
> > > >> To: <users_at_glassfish.dev.java.net>
> > > >> Sent: Wednesday, February 04, 2009 1:21 AM
> > > >> Subject: Re: FW: Vista, Jee5, sql2000 &sql2005
> > > >>
> > > >>
> > > >>> Is the sqljdbc.jar copied in the <install_root>/lib or
> > > >>> <install_root>/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_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™: Life without walls. Check it out.
> > <http://windowslive.com/explore?ocid=TXT_TAGLM_WL_allup_1a_explore_032009>
>
>
> ---------------------------------------------------------------------
> 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 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/