JDBC Adapter

[Former Member]

Hello,

I have a JDBC adapter as recevercomm channel.

When i executed a message, it is throwing this error.

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: JDBC Adapter configuration not initialized: null

Let me know what to do in this rgard.

[Former Member · Accepted solution]

Hi,

Have you Installed the JDBC Drivers on XI Server???

If YES means, Take correct Drivers name & Connection

To install JDBC driver follow the how to guide.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide...

Configuration of JDBC Adapter for SQL Server

JDBC Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection = jdbc:microsoft:sqlserver://hostname:<port>;DatabaseName=<DBName>

UserID and Password.

If the connection is not working find the correct port number.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40b92770-db81-2a10-8e91-f747188d...

REgards

Seshagiri

[Former Member · Accepted solution]

Hi,

The same is working well for Development server. We use the same parameters in development. It is working fine.

But for Testing server, it is not working at all.

Please do let me know.

[Former Member]

This used to happen (to me) when adapter tried to initialize (start) while database wasn't available, and got stuck after too many retries. I think it has been fixed in SPS > 20 for 3.0 (can't tell for newer release) but a workaround is available :

lazyConnection = true

in adapter's advanced settings. Database connection won't be checked each time adapter starts

Hope this helps

Chris

[Former Member]

Hi,

check the links:

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/step%2bby%2bstep%2brfc%2bto%2bjdbc%2bscenario

Tips and Tutorial for Sender JDBC Adapter

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

http://help.sap.com/saphelp_nw04s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/content.htm

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

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

[former_member556603]

Hello ,

Are you installed JDBC Drivers?

Go through this links,

/people/varadharajan.krishnasamy/blog/2007/02/27/configuring-jdbc-connector-service-to-perform-database-lookups

http://searchsap.techtarget.com/tip/0,289483,sid21_gci1246926,00.html

To install JDBC driver follow the how to guide.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide...

Configuration of JDBC Adapter for SQL Server

JDBC Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection = jdbc:microsoft:sqlserver://hostname:<port>;DatabaseName=<DBName>

UserID and Password.

If the connection is not working find the correct port number.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40b92770-db81-2a10-8e91-f747188d...

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Please check the driver path as mentioned below.

JDBC Driver : sun.jdbc.odbc.JdbcOdbcDriver

Connection:jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//location of DB table.mdb;

No JDBC driver required.

Receiver JDBC scenario MS access - /people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

follow this thread

SAP Note 850116 has details

Thanks,

Satya Kumar

[Former Member]

Hi,

The following link might be helpful for you:

[http://help.sap.com/saphelp_nw2004s/helpdata/en/b0/676b3c255b1475e10000000a114084/content.htm|http://help.sap.com/saphelp_nw2004s/helpdata/en/b0/676b3c255b1475e10000000a114084/content.htm]

Regards

Bhanu

Intelligroup.

[aashish_sinha]

Hi,

Did you try CPA Cache refresh and starting and stopping JDBC adapter from Visual Admin.

Regards

Aashish Sinha

PS : reward points if helpful

[Former Member]

Hi,

Check this threads:

The problem here is that the JDBC adapter is not able to get information about your Comm Channel.

Try to activate the Communication Channel again. If that doesnt help, try CPA Cache refresh. If that also doesnt work, try starting and stopping the JDBC adapter from Visual Admin.