Re: How do I use 'kprb' jdbc driver with java SQLJ stored procedure (oracle)

Err, this is from memory as I don't have the code to hand.

I specify the kprb connection as you would specify a normal client side connection, and then I connect to the database using OracleDriver().getDefaultConnection

Sorry this is vague, but as I say I haven't got the code to hand.

I'll drop the specifics down tomorrow nite, once I've had a look at the code (just got this working myself).

Cheers,

Andy.
Boca Lab <bocalab_AT_mindspring.com> wrote in message news:149dpscg5jqjj2ssog5q4j71vkb048mmsg_at_4ax.com...
> If your implementing a Java Stored procedure in SQLJ the docs say
> you must use the KPRB driver in your connect.properties file.
>
> The docs also say that you don't have to connect to the database,
> since a connection is implied anyway ( your sproc is running in the
> server already)
>
> So what I don't get is if this:
>
> Since the sproc doesnt connect to the database, you don't use the
> following line ( like you would for a client side sqlj program)
>
> Oracle.connect(getClass(),"connect.properties");
>
> So how does the sproc know to use the KPRB driver since the driver
> you want to use is in the connect.properties??
>
>
> I beleive this is why if I try to invoke my sproc I get the message:
> ORA-03113: end-of-file on communication channel
>
>
Received on Mon Aug 14 2000 - 16:19:45 CDT