Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How do I use 'kprb' jdbc driver with java SQLJ stored procedure (oracle)

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

From: Boca Lab <bocalab_AT_mindspring.com>
Date: 2000/08/13
Message-ID: <149dpscg5jqjj2ssog5q4j71vkb048mmsg@4ax.com>#1/1

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 Sun Aug 13 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US