How I can create JDBC ODBC Connection in SAP NetWeaver Java EE 5

[Former Member]

Hi Experts,

I’m using SAP NetWeaver Java EE 5(SAPNWAS_JAVAEE5_T06), now I want connect my application to MySql. I have specified Opp as data source name in presistant.xml. But I’m not getting connection. I think some more steps there. So please help me for connecting the same.

Thanks in Advance

Toji.

[Former Member]

Hi,

you should first deploy the drivers for MySQL to the server, then define a custom DataSource (with native or vendor SQL).

More info how to do that:

<a href="http://help.sap.com/saphelp_nwce10/helpdata/en/45/08546ff5200486e10000000a155369/frameset.htm">Deploying JDBC Drivers</a>

<a href="http://help.sap.com/saphelp_nwce10/helpdata/en/45/07d2eeea3e0485e10000000a155369/frameset.htm">Deploying DataSources</a>.

Hope that helps!

P.S. Moving the thread to the Java EE 5 forum.