JDBC 2.0 Driver for Oracle 7.34?

JDBC 2.0 Driver for Oracle 7.34?

Post by Christian Bühle » Tue, 20 Jun 2000 04:00:00



I'm looking for a JDBC 2.0 Driver for Oracle 7.34 under Solaris.  I'm using
Java 1.2.

Can I use the JDBC Thin Driver for Oracle 8?

Please help!

Thanks in advance

Christian Buehler

 
 
 

JDBC 2.0 Driver for Oracle 7.34?

Post by Cathy Oo » Fri, 23 Jun 2000 04:00:00


Sure, no problem. It's downloadable at technet.oracle.com.
You have to register (free) first though.
Oracle 7.3 Thin Driver is a little unstable. I'd recommend using Oracle
8 Thin Driver.

> I'm looking for a JDBC 2.0 Driver for Oracle 7.34 under Solaris.  I'm using
> Java 1.2.

> Can I use the JDBC Thin Driver for Oracle 8?

> Please help!

> Thanks in advance

> Christian Buehler


 
 
 

1. Oracle 7.34, 8.x, full outer join syntax

Can someone assist me? Sorry if this is too complicated.

I know the ansi syntax for full outer joins does not work in Oracle.
(I'm using ODBC BTW)

Can someone tell me
1) the syntax and
2) can I retrict the scope of the result set as mentioned below?

Thanks
Jeff Kish

table1 part (code, number, alt_num, AlphaNumeric)
table2 altpart(alt_num, AlphaNumeric)

table1 =        ('code1','part1','alt_num1','part1'),
        ('code2','part_2',NULL,','part2')
table2 =        ('alt_num1','altnum1'),
        ('altnum2','altnum2')

results of full outer join should be? 1st table1 row joined with 1st
table2 row and then 2nd table1 row and then 2nd table2 row, not
necessarily in that order:

'code1','part1','alt_num1','part1',     'alt_num1','altnum1'
'code2','part_2',NULL,'part2',  NULL,NULL
NULL,NULL,NULL,NULL,            'altnum2','altnum2'

About limiting the results, .. could I somehow get only entries which
were related to a certain value of number, say 'part1'

Thanks again,
Jeff Kish

2. CURSOR problems

3. Connecting to SQL Server 2000 from Oracle versions 7.34 and 8.1.7

4. Insert images in SQL

5. Personal Oracle 7.34

6. SQL Statement needs Performance Improvement

7. JDBC 2.0 / JDK 1.2 Drivers for Oracle 8.0x (not Oracle 8i)

8. DBA/Consultant Wanted

9. JDBC 2.0/3.0 Support Status/Strategies for JDBC drivers supplied by various vendors

10. JDBC Driver supported JDBC 2.0 features

11. Jdbc or odbc driver for paradox compatible with jdbc 2.0

12. How to Get Drivers to Use JDBC 2.0 with ORACLE