Re: JDBC and Virtual Machines

Can I get some more information on your setup?
What virtualization software are you using? Are you using Microsoft's
virtual pc? VMWare?

Do you have the source code that you are using to connect to the virtual
server? are you using an instance name?
Thanks,
Angel

--
Angel Saenz-Badillos [MS] Data Programmability
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.
I am now blogging: http://blogs.msdn.com/angelsb/




<kevin@xxxxxxxxx> wrote in message
news:1153165872.358761.18140@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
The utility program is my code. It uses a TCP/IP socket component to
open a connection on port 1433. So I know TCP/IP is working.

The code in the application that fails is not mine, and I don't have
access to it. I just know the same code works at another site.

The specific error message is:
2006-06-28 14:38:09,296 ERROR
[org.naphsis.ovs.server.ejb.OVSServerEJBBean] get requests
org.jboss.util.NestedSQLException: Could not create connection; -
nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000
Driver for JDBC]Error establishing socket.); - nested throwable:
(org.jboss.resource.ResourceException: Could not create connection; -
nested throwable: (java.sql.SQLException: [Microsoft][SQLServer 2000
Driver for JDBC]Error establishing socket.))
at
org.jboss.resource.adapter.jdbc.local.LocalDataSource.getConnection(LocalDataSource.java:106)
at org.naphsis.ovs.server.ejb.OVSServerEJBBean.getRequests(Unknown
Source)
at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:660)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:77)
at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:107)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:178)
at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:60)
at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:130)
at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:313)
at org.jboss.ejb.Container.invoke(Container.java:712)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
at
org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:98)
at
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:102)
at
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77)
at
org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)
at
org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:111)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:76)
at $Proxy24.getRequests(Unknown Source)
at org.naphsis.ovs.client.OVSClientManager.run(Unknown Source)
Caused by: org.jboss.resource.ResourceException: Could not create
connection; - nested throwable: (java.sql.SQLException:
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.)
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:144)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnection(InternalManagedConnectionPool.java:259)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:106)
at
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:323)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:467)
at
org.jboss.resource.connectionmanager.LocalTxConnectionManager.getManagedConnection(LocalTxConnectionManager.java:221)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:532)
at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:814)
at
org.jboss.resource.adapter.jdbc.local.LocalDataSource.getConnection(LocalDataSource.java:102)
... 23 more
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown
Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown
Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown
Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown
Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:133)
... 31 more
2006-06-28 14:38:09,296 ERROR [org.naphsis.ovs.client.OVSClientManager]
getting requests for queue
org.naphsis.ovs.client.SSNRequestCreateException: SQLException: Could
not create connection; - nested throwable: (java.sql.SQLException:
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.);
- nested throwable: (org.jboss.resource.ResourceException: Could not
create connection; - nested throwable: (java.sql.SQLException:
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.))
at org.naphsis.ovs.server.ejb.OVSServerEJBBean.getRequests(Unknown
Source)
at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:660)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:77)
at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:107)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:178)
at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:60)
at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:130)
at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
at
org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:313)
at org.jboss.ejb.Container.invoke(Container.java:712)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
at
org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:98)
at
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:102)
at
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77)
at
org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)
at
org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:111)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:76)
at $Proxy24.getRequests(Unknown Source)
at org.naphsis.ovs.client.OVSClientManager.run(Unknown Source)




Angel Saenz-Badillos[MS] wrote:
Without knowing what the utility program is I would still be concerned
that
it is connecting with NTLM instead of TCP/IP and try to verify TCP/IP was
enabled through the configuration manager. I would have looked for a
firewall that may be blocking traffic, but you mention that you can
connect...

What does your source code look like and what is the error that you are
getting.
Thanks,
--
Angel Saenz-Badillos [MS] Data Programmability
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.
I am now blogging: http://blogs.msdn.com/angelsb/




<kevin@xxxxxxxxx> wrote in message
news:1152890816.900686.79010@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
TCP/IP was one of the first things we checked. We used a utility
program to establish a connection on port 1433, just to make sure after
verifying that TCP/IP was enabled using Enterprise Manager.

Although we're running under Windows (virtually hosted), I was
concerened that similar problems exist when running under JBOSS under
Linux. (See
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3856304#3856304).
JBOSS is part of our mix too, albeit running under Windows on the
virtual server.

We have the same JDBC version running successfully under the same JBOSS
in another site, but this one isn't running inside a virtual server.

Kevin

Angel Saenz-Badillos[MS] wrote:
If you have basic connectivity working but JDBC is failing the first
thing I
would do would be to make sure TCP/IP is enabled. Other providers can
connect with NTLM but JDBC drivers only support TCP/IP. Make sure you
re-start the server after enabling TCP/IP

The second thing I would look for would be to make sure SQLBrowser is
running and/or try to connect using the IP address directly, let me
know
if
this helps.

--
Angel Saenz-Badillos [MS] Data Programmability
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.
I am now blogging: http://blogs.msdn.com/angelsb/




<kevin@xxxxxxxxx> wrote in message
news:1152631441.776781.49520@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have two Windows virtual servers hosted by Linux -- one running SQL
Server 2000 and the other trying to connect to it via JDBC. Are
there
any issues related to running a JDBC driver under a virtual windows
server?

I'm getting failure to connect socket errors, and everything we can
figure out hasn't helped. We know basic connectivity is there
through
running a non-JDBC program to connect to SQL Server.

Thanks,
Kevin





.

Relevant Pages

  • Re: Lan setup 2 nic
    ... The external nic only has TCP/IP enabled. ... Ipconfig of the server is looking good, but the client is still missing the ... > connection so we have a 2 nic with router setup now. ...
    (microsoft.public.windows.server.sbs)
  • Re: IP Spoofing
    ... But the server will disregard them. ... sockets, sequence numbers, and window sizes, is called a connection. ... There is nothing in the TCP/IP protocol which disallows it, ... the packet with your own. ...
    (comp.lang.php)
  • Re: connect to named instance w/ non-default port
    ... I have verified that the server is configured to accept remote ... connections via both named pipes and tcp/ip. ... following connection strings do not work. ... Is it configuration dependent? ...
    (microsoft.public.sqlserver.connect)
  • Re: pppd & gprs
    ... start the daemon which connects to the server. ... How can I determine from my C-application if a gprs/ppp connection is ... The company I'm working for does this (PPP over GPRS, and a TCP/IP ... library as a so called 'book bus' (a real bus moving around in ...
    (comp.os.linux.networking)
  • Re: Setting ICMP Rules
    ... > Can blocking all ICMP request by the FW cause problems on the TCP/IP ... I get connection TCP/IP connection has ... > been dropped by the server messages. ...
    (comp.security.firewalls)
Loading