Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5148

Native: Executing procedures without return values yields an error

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • None
    • 9.3.3
    • None
    • None
    • Hide

      On Postgres

      1. Create a table 
        CREATE TABLE public.mapping
(
  column1 numeric(18,2)
)
      2. Create a function/procedure which inserts data into this table and returns nothing 
        CREATE OR REPLACE FUNCTION public.insert_test()
  RETURNS void AS
$BODY$
		BEGIN
			insert into public.mapping
			select 12.4;
		END $BODY$ LANGUAGE plpgsql
      3. Execute the function in PgAdmin (works) 
        select public.insert_test();

      On Teiid

      1. Execute the function via native call from within Teiid (fails with [38000] org.postgresql.util.PGobject java.lang.ClassNotFoundException: org.postgresql.util.PGobject) 
        select * from (call "ds2.native"(
    "request" => 'select public.insert_test();'
)) a;;
      Show
      On Postgres Create a table CREATE TABLE public .mapping ( column1 numeric (18,2) ) Create a function/procedure which inserts data into this table and returns nothing CREATE OR REPLACE FUNCTION public .insert_test() RETURNS void AS $BODY$ BEGIN insert into public .mapping select 12.4; END $BODY$ LANGUAGE plpgsql Execute the function in PgAdmin (works) select public .insert_test(); On Teiid Execute the function via native call from within Teiid (fails with [38000] org.postgresql.util.PGobject java.lang.ClassNotFoundException: org.postgresql.util.PGobject ) select * from ( call "ds2.native" ( "request" => ' select public .insert_test();' )) a ;;

      Executing procedures without return values yields an error when executed via native function from within teiid. The stacktrace is as follows:

      [2017-11-14 11:25:48] [38000] org.postgresql.util.PGobject
[2017-11-14 11:25:48] java.lang.ClassNotFoundException: org.postgresql.util.PGobject
[2017-11-14 11:25:48] 	at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
[2017-11-14 11:25:48] 	at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
[2017-11-14 11:25:48] 	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
[2017-11-14 11:25:48] 	at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
[2017-11-14 11:25:48] 	at java.lang.Class.forName0(Native Method)
[2017-11-14 11:25:48] 	at java.lang.Class.forName(Class.java:348)
[2017-11-14 11:25:48] 	at java.io.ObjectInputStream.resolveClass(ObjectInputStream.java:677)
[2017-11-14 11:25:48] 	at org.teiid.netty.handler.codec.serialization.CompactObjectInputStream.resolveClass(CompactObjectInputStream.java:112)
[2017-11-14 11:25:48] 	at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1819)
[2017-11-14 11:25:48] 	at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1713)
[2017-11-14 11:25:48] 	at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1986)
[2017-11-14 11:25:48] 	at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1535)
[2017-11-14 11:25:48] 	at java.io.ObjectInputStream.readObject(ObjectInputStream.java:422)
[2017-11-14 11:25:48] 	at org.teiid.client.BatchSerializer$ColumnSerializer.readObject(BatchSerializer.java:552)
[2017-11-14 11:25:48] 	at org.teiid.client.BatchSerializer$ObjectColumnSerializer.readObject(BatchSerializer.java:283)
[2017-11-14 11:25:48] 	at org.teiid.client.BatchSerializer$ObjectColumnSerializer.access$2400(BatchSerializer.java:228)
[2017-11-14 11:25:48] 	at org.teiid.client.BatchSerializer$ArrayColumnSerializer2.readObject(BatchSerializer.java:177)
[2017-11-14 11:25:48] 	at org.teiid.client.BatchSerializer$ColumnSerializer.readColumn(BatchSerializer.java:543)
[2017-11-14 11:25:48] 	at org.teiid.client.BatchSerializer.readBatch(BatchSerializer.java:924)
[2017-11-14 11:25:48] 	at org.teiid.client.ResultsMessage.processResults(ResultsMessage.java:120)
[2017-11-14 11:25:48] 	at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:755)
[2017-11-14 11:25:48] 	at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:65)
[2017-11-14 11:25:48] 	at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:561)
[2017-11-14 11:25:48] 	at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135)
[2017-11-14 11:25:48] 	at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40)
[2017-11-14 11:25:48] 	at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79)
[2017-11-14 11:25:48] 	at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:285)
[2017-11-14 11:25:48] 	at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:337)
[2017-11-14 11:25:48] 	at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
[2017-11-14 11:25:48] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[2017-11-14 11:25:48] 	at java.lang.reflect.Method.invoke(Method.java:498)
[2017-11-14 11:25:48] 	at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:98)
[2017-11-14 11:25:48] 	at com.sun.proxy.$Proxy3.read(Unknown Source)
[2017-11-14 11:25:48] 	at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:427)
[2017-11-14 11:25:48] 	at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:570)
[2017-11-14 11:25:48] 	at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:423)
[2017-11-14 11:25:48] 	at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:354)
[2017-11-14 11:25:48] 	at com.intellij.database.remote.jdbc.impl.RemoteStatementImpl.executeQuery(RemoteStatementImpl.java:161)
[2017-11-14 11:25:48] 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[2017-11-14 11:25:48] 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[2017-11-14 11:25:48] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[2017-11-14 11:25:48] 	at java.lang.reflect.Method.invoke(Method.java:498)
[2017-11-14 11:25:48] 	at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:346)
[2017-11-14 11:25:48] 	at sun.rmi.transport.Transport$1.run(Transport.java:200)
[2017-11-14 11:25:48] 	at sun.rmi.transport.Transport$1.run(Transport.java:197)
[2017-11-14 11:25:48] 	at java.security.AccessController.doPrivileged(Native Method)
[2017-11-14 11:25:48] 	at sun.rmi.transport.Transport.serviceCall(Transport.java:196)
[2017-11-14 11:25:48] 	at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:568)
[2017-11-14 11:25:48] 	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:826)
[2017-11-14 11:25:48] 	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:683)
[2017-11-14 11:25:48] 	at java.security.AccessController.doPrivileged(Native Method)
[2017-11-14 11:25:48] 	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:682)
[2017-11-14 11:25:48] 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[2017-11-14 11:25:48] 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[2017-11-14 11:25:48] 	at java.lang.Thread.run(Thread.java:745) (no stack trace)

            rhn-engineering-shawkins Steven Hawkins
            fabio.franco Fábio Franco (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: