create remote source error

[arvin888]

Hi
when I create the remote source in the data provisioning using the mysql adapters, the error happens as '
SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: java.lang.Integer.parseUnsignedInt(Ljava/lang/String;)I'.
My database version: 5.6.4 jdbc dirver 5.1.4

jason

[jayeshkothari87]

Hi Jason,
Have you had any luck with this error ?
I am getting the same error.

Regards,
Jayesh

[kshitizbht]

i haven't tried the mysqladapter usually that error implies from reflection. Make sure you are using the correct jdbc driver. Can you post the full stack trace as well?

[jayeshkothari87]

The issue was with the adapter I exported as .jar.
I am able to use the mysql Adapter

[jurrabi]

"The issue was with the adapter I exported as .jar."

can you elaborate on this?
I compiled the adapter acording to the sdk manual and got a .jar file that deployed and registered with HANA ok.

But my problem is, as it was in the original post when I try to create the remote source.I get the same error:
(Remote Source Editor) dberror($.hdb.Connection.executeProcedure): 403 - SQL error, server error code: 403. internal error: Test unsuccessful for remote source CNIO_REDCAP_DEV Reason: com.mysql.jdbc.Driver at /sapmnt/ld7272/a/HDB/jenkins_prod/workspace/8uyiojyvla/s/ptime/query/procedure/builtin_procedure/impl/BP_CheckRemoteSource.cc:92

and think it might be related to the odbc driver.
I downloaded the latest version from here:
https://dev.mysql.com/downloads/connector/j/5.0.html

unzipped and stored in the agent machine (any path ok?) then I enter the same path in the remote source configuration for the odbc driver, but no success.
Shall the mysql odcb.jar library be stored in a specific library path? or registered somehow?

thanks in advance,

Jesus.

[jurrabi]

Never Mind. There was an issue with the upload and the jar file was corrupt. A simple re-upload fixed the issue.