Error message when connecting to missing VDB is misleading (makes it sound like it exists) ------------------------------------------------------------------------------------------ Key: TEIID-1321 URL: https://jira.jboss.org/browse/TEIID-1321 Project: Teiid Issue Type: Bug Components: JDBC Driver Affects Versions: 7.1.1 Environment: Fedora 12, SOA-P ER3 Reporter: Paul Nittel Assignee: Steven Hawkins Fix For: 7.1.1 I was using the simpleclient to query an XML document model, but misspelled the name of the VDB. The error I received was that the subject VDB was not active. Actually, it didn't exist and that distinction could have saved me a bunch of time trying to figure out why it appeared to be active, but wasn't. Here's an example (this VDB does not exist): ./run.sh localhost 31000 barfingToad "select * from booksdoc.booksetmixeddocument" Executing using the TeiidDriver Oct 25, 2010 12:45:07 PM org.teiid.jdbc.SocketProfile connect SEVERE: Could not create connection [ConnectionException]Remote org.teiid.client.security.LogonException: VDB "barfingToad" version "latest" is not in "active" status. 1 [LogonException]Remote org.teiid.client.security.LogonException: VDB "barfingToad" version "latest" is not in "active" status. 2 [TeiidSecurityException]Remote org.teiid.dqp.service.SessionServiceException: VDB "barfingToad" version "latest" is not in "active" status. at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:143) 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(DriverManager.java:620) at java.sql.DriverManager.getConnection(DriverManager.java:200) at JDBCClient.getDriverConnection(JDBCClient.java:53) at JDBCClient.main(JDBCClient.java:41) Caused by: [LogonException]Remote org.teiid.client.security.LogonException: VDB "barfingToad" version "latest" is not in "active" status. 1 [TeiidSecurityException]Remote org.teiid.dqp.service.SessionServiceException: VDB "barfingToad" version "latest" is not in "active" status. at org.teiid.transport.LogonImpl.logon(LogonImpl.java:84) at sun.reflect.GeneratedMethodAccessor1087.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:81) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:189) at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:160) at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:149) at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:210) at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:100) at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:545) at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:754) at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:144) at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:545) at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:754) at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:302) at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:317) at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:299) at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:216) at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:80) at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:545) at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:540) at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:274) at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:261) at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:349) at org.jboss.netty.channel.socket.nio.NioWorker.processSelectedKeys(NioWorker.java:281) at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:201) at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108) at org.jboss.netty.util.internal.IoWorkerRunnable.run(IoWorkerRunnable.java:46) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Caused by: [TeiidSecurityException]Remote org.teiid.dqp.service.SessionServiceException: VDB "barfingToad" version "latest" is not in "active" status. at org.teiid.services.SessionServiceImpl.getActiveVDB(SessionServiceImpl.java:225) at org.teiid.services.SessionServiceImpl.createSession(SessionServiceImpl.java:157) at org.teiid.transport.LogonImpl.logon(LogonImpl.java:75) ... 31 more -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira