JDBC Sender Adapter Error

[Former Member]

HI Friends,

I have configured the JDBC Sender Adapter with parameters as

Driver : oracle.jdbc.driver.OracleDriver

Connection : jdbc:oracle:thin:system:netweaver:@172.25.4.221:1521

But Iam getting an error in Componenet Monitoring:

<b>History:

- 2006-05-30 04:55:36 UTC: Error: Stopped unexpectedly - reconfigure and activate to continue processing. Error: java.lang.NullPointerException

- 2006-05-30 04:55:36 UTC: Processing started</b>

How to resolve this??

Regards,

Raju

[bhavesh_kantilal · Accepted solution]

Hi,

The connection string should be in the format,

<b>jdbc:oracle:thin:@<IP adress>:<listener port>:<instance name (database name)></b>

In your case,

<b>jdbc:oracle:thin:@172.25.4.221:1521:netweaver/system</b>

netweaver/ system, whichever is your Global DB Name.

Regards,

Bhavesh

[Former Member · Accepted solution]

Hi

Thanks for the reply.

I tried with <b>jdbc:oracle:thin:@172.25.4.221:1521:netweaver</b> and

<b>jdbc:oracle:thin:@172.25.4.221:1521:system</b>

Now Iam getting another error.

<b>Sender Adapter v2108 for Party '', Service 'TBIT40_XI_LEGACY_BS_04':

Configured at 2006-05-30 05:12:30 UTC

History:

- 2006-05-30 05:13:00 UTC: Retry interval started. Length: 20.000 s

- 2006-05-30 05:13:00 UTC: Error: Accessing database connection 'jdbc:oracle:thin:@172.25.4.221:1521:system' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@172.25.4.221:1521:system': SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093376)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

- 2006-05-30 05:13:00 UTC: Processing started</b>

Can U please solve it..

regards,

Raju

[bhavesh_kantilal · Accepted solution]

Hi,

First check if the user id and password you have enterd in your JDBC adapter is correct and has the credentials to access your DB.

next, ask your DBA for the Global Database Name. Are you sure it is either System or Netweaver?

Also, try connecting tothe same DB using a stand aloe java program and see if you are able to do the same.

Regards,

Bhavesh

[Former Member · Accepted solution]

HI

Thanks for the Reply.

But the same error still exists.

Can you please explain the concept of SID. Like what exactly it is? And how is it useful?

[bhavesh_kantilal · Accepted solution]

Hi,

Am not a DB guy, but SID is the name associated with your Oracle Database. When installing your Oracle Db, you give a name to the database and this name should be used to access the Database.

Even when trying to access your DB from a DB Client, you will mention the SID , user id and the password.

Just make sure, that you have the correct SID and you will be able to access the DB.

Regards,

Bhavesh

[Former Member · Accepted solution]

HI

Now Iam getting another error

<b>Sender Adapter v2108 for Party '', Service 'TBIT40_XI_LEGACY_BS_04':

Configured at 2008-04-26 11:36:19 IST

History:

- 2008-04-26 11:41:40 IST: Retry interval started. Length: 20.000 s

- 2008-04-26 11:41:40 IST: Error: Accessing database connection 'jdbc:oracle:thin:@172.25.4.221:1521:system' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@172.25.4.221:1521:system': SAPClassNotFoundException: oracle.jdbc.driver.OracleDriver

- 2008-04-26 11:41:40 IST: Processing started</b>

I have found out the Global DB Name and it is correct.

But why this error has come??

[bhavesh_kantilal · Accepted solution]

Hi,

<b>SAPClassNotFoundException: oracle.jdbc.driver.OracleDriver</b>

Did you install the driver to access the Oracle DB in your XI server. It is not able to recognise the Oracle Driver.

To install oracle driver, just check this link,

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Regards,

Bhavesh

[Former Member]

hi,

While installing the driver, since you are using Oracle, you will need only Classes12.zip file.

So you have to make only one entry for jar files in provider.xml.

Do follow the manual very closely.

Once you get classes12.zip, try connecting to the database using Java code.

This helps to check wether u can actually connect to the DB or not.

Regards

Neetu