AnsweredAssumed Answered

jTDS Driver - Installation on WebSphere

Question asked by Sabthami S on Feb 27, 2017
Latest reply on Feb 28, 2017 by Chitra Anilkumar

Like • Show 0 Likes0
Comment • 5

Hi All,

Do any one have any document for installing jTDS Driver on WebSphere application server ?.If so please help me how we can do it on WebSphere Application Server.

Also please let me know the jTDS driver version which we need to download for 7.0.1 P01 ?

Many thanks in advance !!!

Regards,

Sabthami Subramanian

Chitra Anilkumar

Feb 27, 2017 8:35 AM

Correct Answer

The jar needs to be at the following path:

/aveksa.ear/APP-INF/lib

Please follow the steps under "Maintaining a WebSphere Installation"- > "Modifying the RSA Identity Governance and Lifecycle Enterprise Archive" section in the installation guide to explode the ear, place the jar in the said path and rebuild and redeploy.

These steps need to be done every time an upgrade is done or a patch is applied.

I think the jTDS driver version depends on the database you are connecting to.

See the reply in context

No one else had this question

Outcomes

Chitra Anilkumar

Feb 27, 2017 8:35 AM

The jar needs to be at the following path:

/aveksa.ear/APP-INF/lib

These steps need to be done every time an upgrade is done or a patch is applied.

I think the jTDS driver version depends on the database you are connecting to.

Actions

Sabthami S @ Chitra Anilkumar on Feb 27, 2017 11:18 AM

Hi Chitra,

Do you have any idea where "aveksa-standalone-full.xml" will reside in Websphere installation and the use of it ?

Because I can't find the file when i search with find command.

Regards,

Sabthami S

Actions

Chitra Anilkumar

@ Sabthami S on Feb 27, 2017 11:28 AM

/opt/IBM/websphere/Apps/profiles/aveksaProfiles/installedApps/<host-node>/aveksa.ear/

Thanks,

Chitra Anilkumar,

Mobile: 248-756-2283.

Upcoming vacation time – 2/21

Dell EMC Holidays –5/29

Attachments

image001.jpg332 bytes
~WRD079.jpg823 bytes

Actions

Sabthami S @ Chitra Anilkumar on Feb 28, 2017 7:35 AM

Hi Chitra,

To say in high level the below are the steps to do jTDS installation on WebSphere right ?.Please correct me if I am wrong anywhere.

Set up a working directory, “new_ear” for example.
Copy the aveksa.ear file to the working directory.
Create a temporary ear directory, “ear_dir” for example, in the working directory.
Create a temporary war directory, “war_dir” for example, in the working directory.
Unzip aveksa.ear in the temporary ear directory (ear_dir):

cd ear_dir

jar -xvf ../aveksa.ear

Unzip aveksa.war in the temporary war directory (war_dir):

cd ../war_dir

jar -xvf ../ear_dir/aveksa.war

Complete any modification/changes to the files within the ear_dir or war_dir directories.

Place the jTDS driver under the below mentioned path

“/aveksa.ear/APP-INF/lib”

Rebuild the modified aveksa.war:

cd war_dir

jar uvfm ../ear_dir/aveksa.war META-INF/MANIFEST.MF *

Rebuild the modified aveksa.ear:

cd ../ear_dir

jar uvfm ../aveksa.ear META-INF/MANIFEST.MF *

Many thanks !!!

Regards,

Sabthami Subramanian

Actions

Chitra Anilkumar

@ Sabthami S on Feb 28, 2017 8:22 AM

Those are the steps I would follow – yes.

Thanks,

Chitra Anilkumar,

Mobile: 248-756-2283.

Upcoming vacation time – 2/21

Dell EMC Holidays –5/29

Attachments

image001.jpg332 bytes
~WRD123.jpg823 bytes

Actions

5 Replies

Chitra Anilkumar Feb 27, 2017 8:35 AM
Unmark Correct
Correct Answer
The jar needs to be at the following path:

/aveksa.ear/APP-INF/lib

Please follow the steps under "Maintaining a WebSphere Installation"- > "Modifying the RSA Identity Governance and Lifecycle Enterprise Archive" section in the installation guide to explode the ear, place the jar in the said path and rebuild and redeploy.

These steps need to be done every time an upgrade is done or a patch is applied.

I think the jTDS driver version depends on the database you are connecting to.
Like • Show 1 Like1
Actions
- Sabthami S @ Chitra Anilkumar on Feb 27, 2017 11:18 AM
  Mark Correct
  Correct Answer
  Hi Chitra,
  
  Do you have any idea where "aveksa-standalone-full.xml" will reside in Websphere installation and the use of it ?
  
  Because I can't find the file when i search with find command.
  
  Regards,
  Sabthami S
  Like • Show 0 Likes0
  Actions
  - Chitra Anilkumar @ Sabthami S on Feb 27, 2017 11:28 AM
    Mark Correct
    Correct Answer
    /opt/IBM/websphere/Apps/profiles/aveksaProfiles/installedApps/<host-node>/aveksa.ear/
    
    Thanks,
    Chitra Anilkumar,
    Mobile: 248-756-2283.
    
    Upcoming vacation time – 2/21
    Dell EMC Holidays –5/29
    Attachments
    image001.jpg332 bytes
    ~WRD079.jpg823 bytes
    Like • Show 1 Like1
    Actions
- Sabthami S @ Chitra Anilkumar on Feb 28, 2017 7:35 AM
  Mark Correct
  Correct Answer
  Hi Chitra,
  
  To say in high level the below are the steps to do jTDS installation on WebSphere right ?.Please correct me if I am wrong anywhere.
  Set up a working directory, “new_ear” for example.
  Copy the aveksa.ear file to the working directory.
  Create a temporary ear directory, “ear_dir” for example, in the working directory.
  Create a temporary war directory, “war_dir” for example, in the working directory.
  Unzip aveksa.ear in the temporary ear directory (ear_dir):
  cd ear_dir
  jar -xvf ../aveksa.ear
  Unzip aveksa.war in the temporary war directory (war_dir):
  cd ../war_dir
  jar -xvf ../ear_dir/aveksa.war
  Complete any modification/changes to the files within the ear_dir or war_dir directories.
  Place the jTDS driver under the below mentioned path
  “/aveksa.ear/APP-INF/lib”
  Rebuild the modified aveksa.war:
  cd war_dir
  jar uvfm ../ear_dir/aveksa.war META-INF/MANIFEST.MF *
  Rebuild the modified aveksa.ear:
  cd ../ear_dir
  jar uvfm ../aveksa.ear META-INF/MANIFEST.MF *
  
  Many thanks !!!
  Regards,
  Sabthami Subramanian
  Like • Show 0 Likes0
  Actions
  - Chitra Anilkumar @ Sabthami S on Feb 28, 2017 8:22 AM
    Mark Correct
    Correct Answer
    Those are the steps I would follow – yes.
    
    Thanks,
    Chitra Anilkumar,
    Mobile: 248-756-2283.
    
    Upcoming vacation time – 2/21
    Dell EMC Holidays –5/29
    Attachments
    image001.jpg332 bytes
    ~WRD123.jpg823 bytes
    Like • Show 0 Likes0
    Actions

jTDS Driver - Installation on WebSphere

Outcomes

Attachments

Attachments

Related Content

Recommended Content