WDA accessing MySQL DB through Java Connector

[Former Member]

Hi,

Im having some issues to interfacing a web dynpro abap application with a MySQL DB through a java connector connexion.

Here what I want to do:

Doing queries on my MySQL DB after input fields of search criteria and get the results back to display them in the web dyn pro application. (reporting tool-)

Accessing the data of a MySQL Database in my SAP, to avoid a duplication of data.

I would like to know how to send a query to my Java application ?

And how to send the result of this query to the Webdynpro ABAP ?

Whats the best and easiest solution ?

Thanks !

[Former Member]

Found my way through JCo Server.

I need an rfc or BAPI that have specific parameters --> a table with several specific fields and several fields for search criteria.

The user enter the search criteria than I send those to my Java server, the Java server retrieve those parameters and perform a SQL query on the MySQL DB. I fill in the table parameter with the result and send the whole table to the abap

How is it possible ?

Thanks !

[Former Member]

Thats what I thought 😛

And whats the solution ?

the only one I found was with Java Connector.

Is it possible to setValues for a JCoTable and than send this JCoTable to SAP to get access to the data ?

Thanks !

Edited by: Benjamin Art on Mar 16, 2011 3:08 PM

[Former Member]

Thanks for your reply !

And how is it possible to connect to a MySQL Database in ABAP, (The SAP system is install on a linux.)

I already read the subjects about creating a DSN etc ... and its only possible on a windows .

Thanks!

[thomas_jung]

Sorry. I miss read MySQL as MSSQL. Microsoft SQL Server would be accessible via DBConnect, but unfortunetely there is no ABAP data drivers for MySQL.

[thomas_jung]

>I would like to know how to send a query to my Java application ?

And how to send the result of this query to the Webdynpro ABAP ?

My guess would be be that you would have to build a Web Service around this Java logic to expose it to ABAP. Nothing Web Dynpro specific here.

>Whats the best and easiest solution ?

Why not access this database directly from ABAP instead of passing through Java?