Topic
  • 6 replies
  • Latest Post - ‏2012-05-25T12:19:22Z by SystemAdmin
SystemAdmin
SystemAdmin
570 Posts

Pinned topic [Solved] Connectivity to iseries from Worklight

‏2012-05-24T12:54:45Z |
Hello,

I am having some connectivity problem to the iseries database (DB2 for i5/OS).

These are the steps I have done:
1) Database Connection is working fine (I have seen the ping succeeded)
2) I am using SQLAdapter for database manipulation and selection.
3) in worklight.properties I have inserted these lines

training-jndi-name=\${custom-db.1.jndi-name}
custom-db.1.relative-jndi-name=jdbc/com.ibm.as400.access.AS400JDBCDriver
custom-db.1.driver=com.ibm.as400.access.AS400JDBCDriver
custom-db.1.url=iseriesd.demos.ibm.com
custom-db.1.username=ATDEMO
custom-db.1.password=DEMO4YOU

4) when i deploy the project on server I recieves

2012-05-24 17:43:01 Starting adapter deployment on Worklight Server
2012-05-24 17:43:01 Deploying adapter: boatsAdapter
2012-05-24 17:43:01 Server host: localhost
2012-05-24 17:43:01 Server port: 8080
2012-05-24 17:43:01 Adapter deployed successfully

5) When i execute the procedure, I recieves

2012-05-24 17:43:07 Starting procedure invocation on Worklight Server
2012-05-24 17:43:07 Not deploying adapter 'boatsAdapter' since it was not changed since last deployment
2012-05-24 17:43:07 Invoking procedure: 'procedure1' of adapter 'boatsAdapter'
2012-05-24 17:43:07 Server host: localhost
2012-05-24 17:43:07 Server port: 8080
2012-05-24 17:43:07] Parameters: [
2012-05-24 17:43:07 Procedure invocation finished

6) On the page I get this final result

{
"errors": ,
"info": [],
"isSuccessful": false,
"warnings": []
}
Please Do resolve this issue I would be pleased having some good response.

thanks

-Talha Haroon
  • IdanAdar
    IdanAdar
    288 Posts

    Re: [Solved] Connectivity to iseries from Worklight

    ‏2012-05-24T17:49:58Z  
    Worklight Server 4.2.x does not support DB2. What is your Worklight Server version?
  • SystemAdmin
    SystemAdmin
    570 Posts

    Re: [Solved] Connectivity to iseries from Worklight

    ‏2012-05-24T18:24:12Z  
    thanks for your response my friend
    I am using Worklight 4.2.1

    Please help me out

    Thanks
  • IdanAdar
    IdanAdar
    288 Posts

    Re: [Solved] Connectivity to iseries from Worklight

    ‏2012-05-25T05:43:42Z  
    Wait for a future release.
  • SystemAdmin
    SystemAdmin
    570 Posts

    Re: [Solved] Connectivity to iseries from Worklight

    ‏2012-05-25T10:51:06Z  
    oh That's not a good news for me, dude

    Got any other solution ?

    thanks
  • IdanAdar
    IdanAdar
    288 Posts

    Re: [Solved] Connectivity to iseries from Worklight

    ‏2012-05-25T11:50:38Z  
    No...

    Are you from IBM? If so, you should have some knowledge or be able to read about what is about to come, which should elevate your concerns; otherwise, I can't say much.
  • SystemAdmin
    SystemAdmin
    570 Posts

    Re: [Solved] Connectivity to iseries from Worklight

    ‏2012-05-25T12:19:22Z  
    Hmmm..
    ok thanks Idan