Win a copy of Terraform in Action this week in the Cloud forum!

Tom Helegera

Greenhorn
+ Follow
since Nov 08, 2008
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Tom Helegera

Can we have @RolesAllowed in the Remote interface level rather than the Bean level.

Like if we want secure the Remote callers only and allow all calls for Local interface.


Thanks!
Hi bhargavi,

Were you able to come up with the correct answers ?

Hisham
Hi,

I am asked to write a general webservice to serve something like 5-10 clients (webservice consumers).

The return for this method in WS is an Object of strings (simple object).

If I changed anything in the object, this will change the WSDL ofcourse, and if the consumer is calling this method, he will get error parsing the new SOAP message.

So, I will have to inform all my clients to parse the new WSDL file once my EAR file is on production, and to deploy thier EAR files immediately, having a risk on synchronization between all parties!

Does anybody have an idea how to solve this issue (changeing the WDSL effect on client)?


Thanks
Hisham
12 years ago
Thanks Everybody,

The problem why the JDBC wan't returning results as the SQL Plus was becuase in the mentioned view the DB guy was using

userenv('LANG')

in his where statment.

so when I was executing the query from SQL Plus it gives :
select userenv('LANG') from dual ----------> result is AR

and from SQL Developer :
select userenv('LANG') from dual ----------> result is EN

IN THE SAME MACHINE.

Our DBA fixed the TEMP problem and replaced the userenv('LANG') to be fixed as 'AR'


Hisham
Hi Jeanne,

Actually they are the same user!



Hisham
Here is my code:



Anyway, I used Oracle SQL Deveoper, which uses ojdbc5.jar it gives the result as my Java code. However, executing the same query using SQL Plus, gives Error!

[Dave - removed DB credentials]
[ November 12, 2008: Message edited by: David O'Meara ]
Yes. PAY_COSTS_V is a view. But I would expect Java application would give me an error or something not to show that the view has no records!!!

Even if I repeat the test over and over, still, via SQLPlus it gives Error and Via Java it gives zero records!

Try using the JDBC backed client Oracle provide instead.



I am using ojdbc14.jar downloaded from Oracle website for the same Oracle version. Do you recommend something else?
Yesterday I made a post about JDBC returning different results from SQL+

Today, I found that in addition to the difference in results between JDBC and SQL+, there is a case that SQL+ is returnning an error :
"ORA-01652 Unable to extend temp segment by 128 in tablespace TEMP"

where as JDBC is simply retrning zero row count.

SQL Query: select count(*) from PAY_COSTS_V

Does this make any sence?
Again :

SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME='XXMOI_DB2_TSOE_V'
From JDBC: return one record APPS
From PL\SQL : return one record APPS (same as JDBC)

SELECT count(*) FROM XXMOI_DB2_TSOE_V
From JDBC: returns 0 after 44 second
From PL\SQL: return 181 rows after 800 second
XXMOI_DB2_TSOE_V is the name of the same view that you said to create a new one as for test, it is the same view.
I meant the owner is APPS

The output is:
APPS XXMOI_DB2_TSOE_V VIEW
SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME='PAY_COSTS_V'
From JDBC: return one record APPS
From PL\SQL : return one record APPS (same as JDBC)

SELECT count(*) FROM PAY_COSTS_V
From JDBC: returns 0 after 44 second
From PL\SQL: return 181 rows after 800 second

Please note that from JDBC no errors are returned.


Tom
Sorry Shailesh

Actualy the last query return one row, one letter was lower case.

it retuens APPS, my current username


Tom
Actually this surprises everybody here!

The view is there, and it returns data from PL/SQL and from SQL+

Oracle people says as long as it returns data from PL/SQL it is working fine.

Overview, that doesn't return data from ALL_OBJECTS , returns data in both PL/SQL and Java.
I also used the Thin driver to try the code! with the same result, now I returned to Thin as your last post.

I am sure about the username/password thing, they are the same of what I am using in the PL/SQL.

SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME='PAY_COSTS_V'

this would return no records.