12:52 p.m.
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