Remote JDBC Connection Error
goyal.sharad Feb 12, 2012 2:34 PMI have successfully deployed my virtual database but when I am trying to remotely connect through my jdbc connection it is not working and getting as null error (refer stack trace below). I also verfied with telnet ip adress with port and I am able to connect with the server so the port is not blocked by firewall.
Please help
General Properties
Name:subcontract.1 |
Version:1 |
Description:Teiid Virtual Database (VDB) |
Traits
Status: UP |
Errors: ** There are no errors reported for this VDB. ** |
String url = "jdbc:teiid:subcontract@mm://<ip address>:31000"; | |
Class.forName("org.teiid.jdbc.TeiidDriver"); | ||
Connection connection=null; |
connection = DriverManager.getConnection(url, "admin", "teiid");
1 [SingleInstanceCommunicationException]
2 [EOFException]
at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:162)
at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:94)
at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:310)
at org.teiid.jdbc.SocketProfile.createConnection(SocketProfile.java:104)
at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:88)
at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:87)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at realtime.test.RealConnectionTest.execute(RealConnectionTest.java:41)
at realtime.test.RealConnectionTest.main(RealConnectionTest.java:18)
Caused by: [SingleInstanceCommunicationException]
1 [EOFException]
at org.teiid.net.socket.SocketServerInstanceImpl.exceptionOccurred(SocketServerInstanceImpl.java:199)
at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)
at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:347)
at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke(SocketServerInstanceImpl.java:357)
at $Proxy0.logon(Unknown Source)
at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:127)
... 9 more
Caused by: java.io.EOFException
at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.fillBuffer(ObjectDecoderInputStream.java:166)
at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.findLength(ObjectDecoderInputStream.java:147)
at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.readObjectOverride(ObjectDecoderInputStream.java:81)
at java.io.ObjectInputStream.readObject(Unknown Source)
at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.read(OioOjbectChannelFactory.java:114)
at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:253)
... 13 more
org.teiid.jdbc.TeiidSQLException: Error establishing socket to host and port: :31000. Reason: null
at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109)
at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:91)
at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:87)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at realtime.test.RealConnectionTest.execute(RealConnectionTest.java:41)
at realtime.test.RealConnectionTest.main(RealConnectionTest.java:18)
Caused by: [SingleInstanceCommunicationException]Error establishing socket to host and port: :31000. Reason: null
1 [SingleInstanceCommunicationException]
2 [EOFException]
at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:162)
at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:94)
at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:310)
at org.teiid.jdbc.SocketProfile.createConnection(SocketProfile.java:104)
at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:88)
... 5 more
Caused by: [SingleInstanceCommunicationException]
1 [EOFException]
at org.teiid.net.socket.SocketServerInstanceImpl.exceptionOccurred(SocketServerInstanceImpl.java:199)
at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:257)
at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:347)
at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke(SocketServer