Home » Other » General » Jpublisher giving error for publish table (Oracle 11g)
Jpublisher giving error for publish table [message #671030] Fri, 10 August 2018 06:23 Go to next message
vykalra
Messages: 10
Registered: November 2012
Junior Member
Hello,

As per the Jpublisher documentation, we can use the tables to expose them as web service
Link: https://docs.oracle.com/cd/B28359_01/java.111/b31225/chtwelve.htm#CBBEDIDD

"Improves PL/SQL Web services by extending the Web services support for additional PL/SQL types, including CLOB, BLOB, XMLTYPE, REF CURSOR, and PL/SQL records and tables"

However, when I try to use the following command it seems to fail. I am able to generate the classes for the package though!

C:\product\11.2.0\client_1\bin>jpub -user=<user>/<password> -url=jdbc:oracle:thin:@<IP>:<DBName> -sql=inv
oracle.jpub.JPubException: J2T-116, ERROR: Type or package ZSUSER.INV was not found in the database

If I use the following query directly on the database then it works fine, so it cannot be access related issue. Can you please guide ?

select * from inv


[Updated on: Fri, 10 August 2018 06:24]

Report message to a moderator

Re: Jpublisher giving error for publish table [message #671050 is a reply to message #671030] Mon, 13 August 2018 04:21 Go to previous messageGo to next message
vykalra
Messages: 10
Registered: November 2012
Junior Member
any idea on this ?
Re: Jpublisher giving error for publish table [message #671246 is a reply to message #671050] Mon, 20 August 2018 00:10 Go to previous messageGo to next message
vykalra
Messages: 10
Registered: November 2012
Junior Member
anyone has any idea ? Sad
Re: Jpublisher giving error for publish table [message #671248 is a reply to message #671246] Mon, 20 August 2018 00:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Most likely no one for the moment and no regulars, as far I know, uses/knows JPublisher.
Your topic is on top of the forum, no need to add post unless you have new information to "it seems to fail" which provides no clue of what is wrong or about what you've actually done and gave us nothing about it.

Re: Jpublisher giving error for publish table [message #671251 is a reply to message #671248] Mon, 20 August 2018 04:30 Go to previous messageGo to next message
vykalra
Messages: 10
Registered: November 2012
Junior Member
Thanks Michel, did not mean to push unnecessary. I did provide the command that I used and the subsequent error that I received for it in the original post. Let me know if I need to add anything further.
Re: Jpublisher giving error for publish table [message #671255 is a reply to message #671251] Mon, 20 August 2018 06:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I know nothing about JPublisher but from what you posted, here's my thoughts:
* maybe "<user>" is not the same thing than "ZSUSER"
* maybe "<user>" has no access right to "ZSUSER.INV"

Re: Jpublisher giving error for publish table [message #671256 is a reply to message #671255] Mon, 20 August 2018 06:09 Go to previous messageGo to next message
vykalra
Messages: 10
Registered: November 2012
Junior Member
Hello Michel,
The user is same as ZSUSER and as I mentioned this user does have the select rights on the table.
Re: Jpublisher giving error for publish table [message #671257 is a reply to message #671256] Mon, 20 August 2018 06:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

"select * from inv" seems to indicate that INV is a table (or view).
"-sql=inv" does not indicate anything how this object is called, if it is just "INV" then Oracle searches for a procedure.

Check what it is sent to Oracle.

Re: Jpublisher giving error for publish table [message #671261 is a reply to message #671257] Mon, 20 August 2018 07:12 Go to previous messageGo to next message
vykalra
Messages: 10
Registered: November 2012
Junior Member
Yes INV is a table, I checked the all_objects table and the OBJECT_NAME value is INV in this case. (with owner being ZSUER )

I tried to give -sql=INV and -sql=ZSUSER.INV , in both cases I get the following error.

oracle.jpub.JPubException: J2T-116, ERROR: Type or package ZSUSER.INV was not found in the database

[Updated on: Mon, 20 August 2018 07:13]

Report message to a moderator

Re: Jpublisher giving error for publish table [message #671269 is a reply to message #671261] Mon, 20 August 2018 07:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The explanation is most likely in the second point of my last post.

Re: Jpublisher giving error for publish table [message #671271 is a reply to message #671269] Mon, 20 August 2018 08:10 Go to previous messageGo to next message
vykalra
Messages: 10
Registered: November 2012
Junior Member
ok, so you are saying it is looking for a procedure, how do we tell it to look for the table ? The object_name is INV as per the all_objects table.
Re: Jpublisher giving error for publish table [message #671273 is a reply to message #671271] Mon, 20 August 2018 08:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

As I said, I know nothing about JPublisher, now you have to investigate how to use "-sql" to do what you want or how to "program" JPublisher to do what you want, I can't help you on this point.

Re: Jpublisher giving error for publish table [message #671280 is a reply to message #671273] Tue, 21 August 2018 00:08 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I know nothing about JPublisher either, but - as Michel has suggested - you're doing something wrong. You do think that you're dealing with a table (which, as you checked, exists in that schema), but Oracle says

oracle.jpub.JPubException: J2T-116, ERROR: Type or package ZSUSER.INV was not found in the database

See? TYPE or PACKAGE (which is what Michel said; a procedure).

Have a look at documentation, I believe it describes how to exactly do what you're trying to.
Previous Topic: 18c XE delayed - again
Next Topic: Upgrade from 9i single instance to 11g RAC
Goto Forum:
  


Current Time: Thu Mar 28 14:41:36 CDT 2024