on 02-04-2014 3:41 PM
Hi JDBC Gurus,
I'm encountering below error in my JDBC receiver. Hostname, port and SID used in the channel are correct and verified by the DB admin. PI is in the same network as the database and the firewall allows connections from within the network. Basis is also able to ping the database server from PI. I'm running out of things to check. Has anyone encountered this problem before? Any other possible cause other than firewall/network issue?
Appreciate your inputs. Thank you
Hi Mark
from your PI server , can you please try to do a tnsping to the remote Oracle DB which you want to connect to and see if it is working .
Also compare the result with the other databases which you mentioned are working .
Secondly , please check in the remote DB if there is any error or issue in it ?
Thanks
Rishi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
The database version is Oracle 8i and we're using ojdbc5.jar which I believe is backwards compatible. But as per SAP note 941317, it recommends Oracle 10g 10.2.x drivers (ojdbc14) when connecting to 8i 8.1.7 or higher. We couldn't really say that it's a driver issue since one of the test databases which we can successfully connect to is running on the same version (8i).
Any idea on how to make this work? Is ojdbc5 really compatible with Oracle 8i? If not, is it possible to deploy 2 drivers to be able to handle connections to 8i and newer versions (10g, 11g)? Thanks a lot
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mark - There is an interesting discussion on this topic. I think you can go with ojdbc14 to connect with newer versions as well along with 8i
Please check the below threads -
java - Can we use ojdbc14.jar with Oracel11g and jdk1.5 - Stack Overflow
Hi,
Ping does not mean firewall is open. you have to telnet. check with basis.
Regards,
Muni.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Nothing wrong with URL and you have confirmed that you are able to connect to other Oracle databases too
As a final check, can you try logging into that database(using toad/anything) and execute the queries with configured user to see if it has enough authorizations?
May be you can enable xpi inspector and i see if it logs any additional information.
Also did you try the above suggested test tool?
Hi Hareesh,
I've just asked the DB admin to double check the username and password and it's enabled and working fine.
Our PI only has JSPM so I couldn't use the EAR file provided in the note. I don't have NWDS yet to convert it to SDA. I will try to download later and see.
Thanks for all the inputs!
Check for the connection string whether it is configured properly or not.
Also check for the SAP note to test the connection from PI
1085539 - XI JDBC/FTP connection Test and XML Validation Application
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.