access sap tables directly

[Former Member]

hi

i am trying like this using jdbc.... to sap connection

conn = DriverManager.getConnection(

"jdbc:oracle:thin:@10.10.88.111:50000","username","password");

but it is throwing ioException: get minus one from a read call

pls help me....

thanks

[Former Member · Accepted solution]

it is always possible that you could connect to and modify business data for an application DIRECTLY from backend. if you end up doing that, it defeats the sole purpose of the business application that is built on top of that business data...

hi Joshi,

[Former Member · Accepted solution]

u given valuable information, so,plz send me one simple sample example

using jdbc driver i have written that one line....is it correct ?

but throwing IOException ....

[Former Member · Accepted solution]

Please refrain from opening a new thread with the exact same question. There are plenty of resources on the net with examples on how to create and use a jdbc connection. Simply search for "jdbc example" or something similar in google and you will get thousands of results.

JDBC connections to a DB used by SAP are no different then any other jdbc connection to a DB, so any example would be valid.

regards,

Dion

[Former Member · Accepted solution]

The URL string looks not correct, change it to "jdbc:oracle:thin:@order_ip_address:1521:SID_of_Oracle".

Dennis

[Former Member · Accepted solution]

hi Dennis,

thanks, it is working..............

[Former Member · Accepted solution]

You really shouldn't be connecting directly to a SAP DB...