[teiid-issues] [JBoss JIRA] (TEIID-5148) Native: Executing procedures without return values yields an error
Fábio Franco (JIRA)
issues at jboss.org
Tue Nov 14 11:43:00 EST 2017
[ https://issues.jboss.org/browse/TEIID-5148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Fábio Franco updated TEIID-5148:
--------------------------------
Steps to Reproduce:
*On Postgres*
----
# Create a table
{code:sql}
CREATE TABLE public.mapping
(
column1 numeric(18,2)
)
{code}
# Create a function/procedure which inserts data into this table and returns nothing
{code:sql}
CREATE OR REPLACE FUNCTION public.insert_test()
RETURNS void AS
$BODY$
BEGIN
insert into public.mapping
select 12.4;
END $BODY$ LANGUAGE plpgsql
{code}
# Execute the function in PgAdmin (works)
{code:sql}
select public.insert_test();
{code}
*On Teiid*
----
# Execute the function via native call from within Teiid (fails with {color:red}[38000] org.postgresql.util.PGobject java.lang.ClassNotFoundException: org.postgresql.util.PGobject{color})
{code:sql}
select * from (call "ds2.native"(
"request" => 'select public.insert_test();'
)) a;;
{code}
was:
*On Postgres*
----
# Create a table
{code:sql}
CREATE TABLE public.mapping
(
column1 numeric(18,2)
)
{code}
# Create a function/procedure which inserts data into this table and returns nothing
{code:sql}
CREATE OR REPLACE FUNCTION public.insert_test()
RETURNS void AS
$BODY$
BEGIN
insert into public.mapping
select 12.4;
END $BODY$ LANGUAGE plpgsql
{code}
# Execute the function in PgAdmin (works)
{code:sql}
select public.insert_test();
{code}
# Execute the function via native call from within Teiid (fails with {color:red}[38000] org.postgresql.util.PGobject java.lang.ClassNotFoundException: org.postgresql.util.PGobject{color})
{code:sql}
select * from (call "ds2.native"(
"request" => 'select public.insert_test();'
)) a;;
{code}
> Native: Executing procedures without return values yields an error
> ------------------------------------------------------------------
>
> Key: TEIID-5148
> URL: https://issues.jboss.org/browse/TEIID-5148
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 9.3.3
> Environment: * teiid 9.3.3
> * jdbc driver: postgresql-9.4.1212.jre7.jar
> * PostgreSQL 9.6.2 on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.9.2-10) 4.9.2, 64-bit
> * java 1.8.0_141-b15
> Reporter: Fábio Franco
> Assignee: Steven Hawkins
>
> Executing procedures without return values yields an error when executed via native function from within teiid. The stacktrace is as follows:
> {code}
> [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)
> {code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
More information about the teiid-issues
mailing list