Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Trying to integrate Remedy java api with servlets on Tomcat

843841Jul 19 2006 — edited Jul 20 2006
Hi,

I've been trying to make remedy my backend for an application. We're using remedy 5.1 (library arapi.jar).

First problem (it may help someone) I ran into right away was that I couldn't put arapi.jar into WEB-INF/lib, since underlining C modules cannot be loaded twice and tomcat complained about it. I eliminated that problem by putting arapi.jar into <tomcathome>/common/lib, but now the library cannot see the server. If I run almost exactly same code from the command line - it works, if I run it through servlet - it doesn't see the database server, and I get same error from remedy api as if I mistyped the server name, so somehow tomcat doesn't seem to resolve server name maybe? This is all very confusing.

Did anybody have same issues? I would greatly appreciate any help.

VG.

P.S. piece of code that works with command line and doesn't in servlet:

String user = args[0];
String password = args[1];
String language = "";
String server = args[2];
ARServerUser remedyUser = new ARServerUser(user, password, language, server);
System.out.println("trying to connect to " + server + "...");
System.getProperties().list(System.out);

try {
remedyUser.login();

} catch (ARException are) {
System.out.println("REMEDY Exception:");
are.printStackTrace();
} catch (Exception e) {
System.out.println(e.getMessage());
}


Error code I get from Remedy API:

MessageType: 2
MessageNum: 90
MessageText: Cannot open catalog; Message number = 90
AppendedText: "diablo" : RPC: Unknown host

Comments

Dpka
Hi Rahul,
1. When I edit the column selector view in 11g, the columns selected in a particular column selector is not visible. As a result I am unable to edit any column properties. Why is it >like this?
In 11g, when you edit the column selector view in results tab you can see options to modify the column properties of each column
2. Is it possible to re-order columns of a column selector? I want to sort the values alphabetically. Is it that I have to add the values in the column selector the way I want it to >appear in the drop down or is there any method through which I can sort the values after adding them to the colum selector?
Remove the column from Column selector edit view (in results tab) by clicking on the delete icon against the column and then add the column in the order you want.

Regards,
Dpka
877006
Hi Dpka,

Thanks for the response.

With reference to point 1, I understand that it is possible to edit column properties by editing column selector view.
However, my query is that after migration to 11g, the selected columns are not visible in the column selector editor because of which the "edit column properties" option is not visible too. And I am unbale to debug why it is so. Could you suggest a possible reason for it? Is it another bug in the tool?

With refernce to Point 2, you are confirming that there is no way to sort the values without deleting the columns. Am I right?


Thanks & Regards,
RG
Dpka
Answer
Hi Rahul,

I have faced this issue in 11.1.1.5 version. This is the bug,

Bug 12937182 : AFTER UPGRADE, COLUMN PROPERTIES ARE NOT WORKING IN COLUMN SELECTOR

Oracle syas this issue has been fixed in 11.1.1.6, looks like it still exists.

For the second query, yes there is no option to sort other than manually removing the columns.

Regards,
Dpka
Marked as Answer by 877006 · Sep 27 2020
877006
Hi Dpka,

Thanks again for the valid information.

Regards,
RG
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 17 2006
Added on Jul 19 2006
3 comments
166 views