hello everyone,I managed to resolve this issue. I made some changes to the SQL server settings. It must have be blocking remote connections through the TCP/IP connection.Thanking everyone for your help.eveFrom: gorgeous65_at_msn.comTo: persistence_at_glassfish.dev.java.netCC: ejb_at_glassfish.dev.java.netDate: Wed, 31 Oct 2007 16:52:34 +0000Subject: RE: connection DB error
Hello Jaqadish, everyone,This is probably a little mistake I am making because I have done before and had managed to resolve some issued in the past. I am not getting the following error:'Operation 'pingConnectionPool' failed in 'resources' Config Mbean. Target exception message: Connection could not be allocated because: The TCP/IP connection to the host has failed. java.net.UnknownHostException:'So it seems the error message:'The connection to the named instance has failed'was due to the mistake in the database server name. So I made some corrections and now get the above error.I am also using the following client to test it apart from the admin console:import java.sql.*;public class clientFailover{ public static void main(String[] args) { // Create a variable for the connection string. String connectionUrl = "jdbc:sqlserver://SQLEXPRESS:1433;" + "databaseName=TESTING1;integratedSecurity=false;" + "failoverPartner=serverB"; // Declare the JDBC objects. Connection con = null; Statement stmt = null; try { // Establish the connection to the principal server. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); con = DriverManager.getConnection(connectionUrl); System.out.println("Connected to the principal server."); // Note that if a failover of serverA occurs here, then an // exception will be thrown and the failover partner will // be used in the first catch block below. // Create and execute an SQL statement that inserts some data. stmt = con.createStatement(); // Note that the following statement assumes that the // TestTable table has been created in the AdventureWorks // sample database. stmt.executeUpdate("INSERT INTO TestTable (Col2, Col3) VALUES ('a', 10)"); } // Handle any errors that may have occurred. catch (SQLException se) { try { // The connection to the principal server failed, // try the mirror server which may now be the new // principal server. System.out.println("Connection to principal server failed, " + "trying the mirror server."); con = DriverManager.getConnection(connectionUrl); System.out.println("Connected to the new principal server."); stmt = con.createStatement(); stmt.executeUpdate("INSERT INTO TestTING1 (Col2, Col3) VALUES ('a', 10)"); } catch (Exception e) { e.printStackTrace(); } } catch (Exception e) { e.printStackTrace(); } // Close the JDBC objects. finally { if (stmt != null) try { stmt.close(); } catch(Exception e) {} if (con != null) try { con.close(); } catch(Exception e) {} } }}I copied it off the JDBC connection tutorialAnymore idea? The database server service is running and TCP is enabled. eveFrom: gorgeous65_at_msn.comTo: persistence_at_glassfish.dev.java.netCC: ejb_at_glassfish.dev.java.netDate: Wed, 31 Oct 2007 14:22:24 +0000Subject: RE: connection DB error
Hello, Jaqadish,Thanks for your reply.I have following the procedure of connecting to the database:Data SourcesThe JDBC driver provides support for J2EE / JDBC 3.0 data sources. The JDBC driver SQLServerXADataSource class is implemented by com.microsoft.sqlserver.jdbc.SQLServerXADataSource.Datasource NamesYou can make database connections by using data sources. The data sources available with JDBC driver are described in the following table:DataSource Type Class Name DescriptionDataSource com.microsoft.sqlserver.jdbc.SQLServerDataSource The non pooling data source.ConnectionPoolDataSource com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource The data source to configure J2EE application server connection pools. Typically used when the application runs within a J2EE application server.XADataSource com.microsoft.sqlserver.jdbc.SQLServerXADataSource The data source to configure J2EE XA data sources. Typically used when the application runs within a J2EE application server and an XA transaction manager.Data Source PropertiesfThat is the help menu which comes with the JDBC driver. I have done this before but it just that the error messages are always different. Sometimes it referees to the datasource or class name if it's wrong.In this case, I am not sure about the name instance error message:'The connection to the named instance has failed'I will trying connecting to the database without going through the application server. I am able to go connect to the DB through the SQL server management studio express.Anymore suggestions.Thankseve> Date: Wed, 31 Oct 2007 19:30:43 +0530> From: Jagadish.Ramu_at_Sun.COM> To: persistence_at_glassfish.dev.java.net> CC: ejb_at_glassfish.dev.java.net> Subject: Re: connection DB error> > 1) Are you able to connect to the microsoft sql server using a> standalone jdbc program ?> > 2) you can set your pool config. according to> "microsoft_sqlserver2005_datasource.xml" available in> 91_AS_INSTALL_ROOT/lib/install/templates/resources/jdbc> > Thanks,> -Jagadish> > On Wed, 2007-10-31 at 12:26 +0000, Eve Pokua wrote:> > Hello everyone,> > > > I uninstalled my SQL server 2005 express and reinstalled an updated> > version. I get the following while trying to connect to the DB from> > the application server SUN 9:> > > > "Operation 'pingConnectionPool' > > failed in 'resources' Config > > Mbean. Target exception message: > > Connection could not be allocated > > because: The connection to the > > named instance has failed. Error: > > java.net.SocketTimeoutException: > > Receive timed out."> > > > After spending a couple days researching and trying to resolve the> > issue, I got fedup and uninstalled the SQL server 2005 express updated> > version. I also made sure the Old profile was deleted from my> > 'program files' so i didn't have to encounter the same issue after.> > However, I am still having the same error after installing the old SQL> > server express 2005. What I'm I doing wrong? I am sure the property> > settings are correct too. I've had this kind of error whilst trying> > to connect to the DB from the application server before, but may be> > not the same type of error. I have always managed to resolve the> > issue but this time I'm running out of ideas. Though, there are a> > lot of post on the internet, the error message is not always the> > same. > > > > I think, it has something about me uninstalling the Old SQL server> > 2005 express and installing a new one and so forth. Maybe the> > application server keeps data of some kind of the DB. Pls help. I am> > running out of ideas.> > > > thanks> > > > eve> > > > > > ______________________________________________________________________> > Do you know a place like the back of your hand? Share local knowledge> > with BackOfMyHand.comPlay Movie Mash-up and win BIG prizes!
Are you the Quizmaster? Play BrainBattle with a friend now!
_________________________________________________________________
The next generation of MSN Hotmail has arrived - Windows Live Hotmail
http://www.newhotmail.co.uk