Skip to main content
Solved

Java Access Provider

  • December 31, 2020
  • 2 replies
  • 264 views

hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • Superhero (Customer)
  • 318 replies

Hi,

I am trying to access from java. I added jar files to libraries. I am getting null pointer exception. What is the problem? 

package javaapplication1;

import ifs.fnd.ap.*;

public class JavaApplication1 {
    public static void main(String[] args) {
        try {
            Server srv = new Server();
            srv.setConnectionString("jdbc:oracle:thin:@//192.168.x.xxx.1521/TEST");
            srv.setCredentials("ifsapp", "******");
            System.out.println();
            PlsqlSelectCommand selCmd = new PlsqlSelectCommand(srv, "SELECT IDENTITY, DESCRIPTION FROM FND_USER");
            RecordCollection result = selCmd.executeQuery();
            System.out.println("All users:");
            if (result != null && result.size() > 0) {
                RecordIterator itr = result.recordIterator();
                Record next;
                while (itr.hasNext()) {
                    next = itr.nextRecord();
                    System.out.println("  " + next.findValue("IDENTITY") + "\t" + next.findValue("DESCRIPTION"));
                }
            } else {
                System.out.println("No rows selected");
            }
        } catch (Exception err) {
            err.printStackTrace(System.out);
        }
    }
}

 

 

Best answer by dsj

Hi @hhy38 ,

 

You’ve used the JDBC connection string format which I think is the problem. Change it to

srv.setConnectionString(IFS_URL:PORT)

Java Access Provider connects to IFS through IFS middleware server. Therefore yo need to use the IFS url, not the database connection string.

 

Happy coding!

Damith

 

View original
This topic has been closed for comments

2 replies

dsj
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 861 replies
  • Answer
  • January 1, 2021

Hi @hhy38 ,

 

You’ve used the JDBC connection string format which I think is the problem. Change it to

srv.setConnectionString(IFS_URL:PORT)

Java Access Provider connects to IFS through IFS middleware server. Therefore yo need to use the IFS url, not the database connection string.

 

Happy coding!

Damith

 


hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • Author
  • Superhero (Customer)
  • 318 replies
  • January 4, 2021
dsj wrote:

Hi @hhy38 ,

 

You’ve used the JDBC connection string format which I think is the problem. Change it to

srv.setConnectionString(IFS_URL:PORT)

Java Access Provider connects to IFS through IFS middleware server. Therefore yo need to use the IFS url, not the database connection string.

 

Happy coding!

Damith

 

Thank you. The problem has been solved. 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings