Home » Infrastructure » Linux » getConnection():SQLException while creating connection (Oracle 10g, Linux using Shell script calling Java code)
getConnection():SQLException while creating connection [message #360976] Mon, 24 November 2008 08:57 Go to next message
nparas
Messages: 1
Registered: November 2008
Junior Member
We are moving an existing Java application to a new Linux server from HP server and also upgrading to 10g from 9i.

We use a shell script to call the java code which connects to the Oracle database. The logon parameters are given in a properties file. The same code is working on the old server.

We are successfully able to logon to the new Oracle database from the linux server using sqlplus command
sqlplus userid/password@databasename

But when we run the script it is giving the following message.

getUserCertificate: IOException: null
:processB2e: Creating DAO connection for VCI...

Mon Nov 24 06:42:36 EST 2008 :getConnection(int): SQLException while creating connection ORA-01017: invalid username/password; logon denied

OutBoundInterface :processB2e: SQLException: :getConnection: Error while creating connection

:retriveSDS: Creating SDS DAO object/connections

DEBUG com.b2e.integration.ford.dao.sds.SDS :getConnection(int): SQLException while creating connection ORA-01017: invalid username/password; logon denied

ERROR com.b2e.integration.ford.dao.sds.SDS :getConnection(int): SQLException while creating connection ORA-01017: invalid username/password; logon denied

:retriveSDS: SQLException: :getConnection: Error while creating connection
java.sql.SQLException: :getConnection: Error while creating connection
at com.b2e.integration.ford.dao.sds.SDS.getConnection(SDS.java:169)
at com.b2e.integration.ford.dao.sds.SDS.getConnection(SDS.java:119)
at com.b2e.integration.ford.outboundinterface.OutBoundInterface.processS

Can someone help me please.
Re: getConnection():SQLException while creating connection [message #361138 is a reply to message #360976] Tue, 25 November 2008 02:51 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Quote:
ORA-01017: invalid username/password; logon denied

The obvious would be to verify your username, password and database name ?
Previous Topic: please advice Oracle Server
Next Topic: How to configure paramaters sysctl.conf
Goto Forum:
  


Current Time: Fri Mar 29 03:56:51 CDT 2024