[teiid-issues] [JBoss JIRA] Closed: (TEIID-1321) Error message when connecting to missing VDB is misleading (makes it sound like it exists)
Steven Hawkins (JIRA)
jira-events at lists.jboss.org
Fri Nov 5 17:37:01 EDT 2010
[ https://jira.jboss.org/browse/TEIID-1321?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins closed TEIID-1321.
---------------------------------
> 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
More information about the teiid-issues
mailing list