Re: SAP direct JDBC access

From: Oscar kind (oscar_at_danwa.net)
Date: 07/28/04 

Date: Wed, 28 Jul 2004 23:39:17 +0200

Horst Walter <unkwb@web.de> wrote:
> I am not sure which driver to use when I want to directly access SAP
> data with JDBC. I run a Netweaver sneak preview installation with MS
> SQL Server.
>
> 1) Of course I can directly use the SQL Server JDBC Drivers, which is
> not my goal. I want to use OpenSQL and become database independent -
> or do I mix here something.

Alternatively, you can use a data source to hide the actual database
driver used (to JDBC, it is transparent which database driver is used).

Then, confine yourself to only the SQL standards as supported by SQL
Server, and any other database you want to be compatible with.

Once you have your application running with those constraints, it's
database independent (it only depends on a relational database, but both
JDBC and SQL are biased towards that anyway). 

-- 
Oscar Kind                                    http://home.hccnet.nl/okind/
Software Developer                    for contact information, see website
PGP Key fingerprint:    91F3 6C72 F465 5E98 C246  61D9 2C32 8E24 097B B4E2

Relevant Pages

  • RE: New JDBC 1.2 driver runs slower than JDBC 1.1; my db definitio
    ... If the support incident ends up verifying a slowdown in the new driver, ... New JDBC 1.2 driver runs slower than JDBC 1.1; ... I do think this would happen in general, not just for my database; ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Problem with JDBC MSSQL
    ... >> JDBC from an applet. ... > classes and you can easily use another persistent storage instead of JDBC. ... > JDBC driver talks to the database. ...
    (comp.lang.java.databases)
  • Re: Behavior of Connection.commit()
    ... transaction count on the server is what we expect at that point in time.... ... Does anyone know what the JDBC ... >> should the driver throw an error? ... > doesn't say what happens if the JDBC driver sends "shutdown" SQL to the ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: JDBC vs Hibernate
    ... Do you really want database ... >> I just need to put the data in tables, thats all, no further SQL ... JDBC is fine for your needs. ... Is it a better option than writing data Row by Row in tables. ...
    (comp.lang.java.databases)
  • Re: Dateadd in SQL statement not working
    ... Omigod, I thought you said you were using SQL Server, which is what my ... version of SQL used by Jet, which is the database usually used by Access): ... But my confusion is not totally resolved: Why are you using a Sybase ODBC ... driver to connect to either a Jet or a SQL Server database? ...
    (microsoft.public.inetserver.asp.general)