Receive "java.lang.IndexOutOfBoundsException: No group 4" error trying to connect via ODBC to EDS VDB
Issue
I am trying to isql from a unix box using ODBC to a EDS instance and it is giving the below error message.
2013-04-11 15:57:38,595 ERROR [org.teiid.ODBC] (New I/O server worker #3-4) Unexpected error occurred
java.lang.IndexOutOfBoundsException: No group 4
at java.util.regex.Matcher.group(Matcher.java:487)
at org.teiid.odbc.ODBCServerRemoteImpl.modifySQL(ODBCServerRemoteImpl.java:615)
at org.teiid.odbc.ODBCServerRemoteImpl.fixSQL(ODBCServerRemoteImpl.java:547)
at org.teiid.odbc.ODBCServerRemoteImpl.sqlExecute(ODBCServerRemoteImpl.java:346)
at org.teiid.odbc.ODBCServerRemoteImpl.access$2100(ODBCServerRemoteImpl.java:68)
at org.teiid.odbc.ODBCServerRemoteImpl$QueryWorkItem.run(ODBCServerRemoteImpl.java:949)
at org.teiid.odbc.ODBCServerRemoteImpl.executeQuery(ODBCServerRemoteImpl.java:653)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.teiid.transport.ODBCClientInstance.processMessage(ODBCClientInstance.java:128)
at org.teiid.transport.ODBCClientInstance.receivedMessage(ODBCClientInstance.java:117)
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.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:350)
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.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:722)
Environment
- JBoss Enterprise Data Services (EDS) 5.3.1
- DSN Configuration:
[DAL]
Driver = /opt/redhat/eds-5.x/psqlodbc/lib64/psqlodbc.so
Description = PostgreSQL Data Source
DSN = DAL
Servername = 127.0.0.1
Port = 30001
Protocol = 7.7.5
UserName = app-DAL
Password = password
Database = DAL
ReadOnly = no
ServerType = Postgres
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.