cancel
Showing results for 
Search instead for 
Did you mean: 

RFC TO JDBC adapter

Former Member
0 Kudos

Hi ,

i am working on RFC to JDBC scenerio.

SENDER: RFC

RECEIVER:JDBC

when i am sending message from RFC my receiver CC is in eror.it shows this erro.

Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//172.25.086\home\iqxadm\xifiles\mohittest\sender\Student_Database.mdb,Uid=iqxadm;Pwd=india123;': java.lang.NullPointerException

please help.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

This definitely seems to be JDBC driver issue or connection issue.

what is the connection string you mentioned in the receiver JDBC adapter? What is the JDBC driver you have in your system?

Former Member
0 Kudos

sun.jdbc.odbc.JdbcOdbcDriver

former_member185881
Active Participant
0 Kudos

Hi Mohit

Your target database os MS Access?

Regards

Dheeraj Kumar

Edited by: Dheeraj Kumar on Jun 24, 2010 3:07 PM

Former Member
0 Kudos

Hi Mohit,

The CC parameters are as follow:

JDBC Driver: jdbc.odbc.JdbcOdbcDriver

Connection: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=
xxxxxx\xxxxx\TestCon.mdb

your access database url is too long (this don't harm but first check it in shorter path).

Check this :

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

Regards

Laxmi Bhushan

Edited by: laxmi bhushan on Jun 24, 2010 3:06 PM

Former Member
0 Kudos

Hi,

Please use the following connection string in communication channel.

jdbc:sqlserver:// <Server name>:<port name>;DatabaseName=<Database Name>;SelectMethod=cursor

And driver details would be,

com.microsoft.sqlserver.jdbc.SQLServerDriver

Thanks

Rajesh

Former Member
0 Kudos

Hi,

Mohit is using .MDB file that is MS Access Not sql server.

Regards

Laxmi Bhushan

Former Member
0 Kudos

yes dheeraj!

Former Member
0 Kudos

Hi,

it seems error with your JDBC driver. Pl deploy correct driver.

Regards

Laxmi Bhushan