Receive "java.lang.IndexOutOfBoundsException: No group 4" error trying to connect via ODBC to EDS VDB

Solution Verified - Updated -

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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In