Please Help - Java, Database oracle or sybase

Hi All,

I am a java programmer used to using oracle database.

In my new job, we have oracle plus sybase database. Some applications
use oracle and some use Sybase. I am writing framework, so it can be
used by all applications.

Is it possible to write connection code, independent of database
driver, by just using java.sql package.
One problem I am seeing in sql package is java.sql.types does not have
cursor. I don't know how sybase returns a resultset but java.sql.other
does not look very promising.

Could any body suggest a general solution using two different database.

Thanks a lot,
Jill.

.

Relevant Pages

  • Re: Stepping into someones shoes
    ... Also required is some Oracle PL/SQL knowledge and the ability to create/manage Oracle objects. ... The best jobs were the ones where management trusted me to design, maintain and optimize the applications in both ends of the databases. ... The worst job was the one where the management only allowed me to optimize the front ends and not touch the back ends, because they'd been built by my predecessor, who was considered their guru. ... He'd written tens of thousands of lines of code that frankly could have been written in half as many lines if he'd been a good database programmer. ...
    (comp.databases.ms-access)
  • Re: Please Help - Java, Database oracle or sybase
    ... I am a java programmer used to using oracle database. ... we have oracle plus sybase database. ... may behave significantly differently in one DBMS than another. ...
    (comp.lang.java.databases)
  • Re: Oracle 10g R2 RHEL 5 When?
    ... few months or whatever for Oracle to come up with a certified release. ... version on RHEL 5. ... It sounds as if you have now put in a version of sybase onto the RHEL ... My experience with applications that are switched and converted ...
    (comp.databases.oracle.server)
  • Re: Newbie: Creating new database files
    ... With Oracle it appears that there is a central database area underneath the Oracle directory tree which will contain data for all applications using it. ... The Concepts Guide is only 1% or less of the complete documentation set but it has more information about Oracle packed into it than any other source I have seen. ...
    (comp.databases.oracle.misc)
  • Re: Oracle or Sybase ADO.NET driver ?
    ... In fact I have neither Sybase or Oracle database here. ... But I'm writting a database neutral product currently supporting SqlServer, ...
    (microsoft.public.dotnet.framework.compactframework)