I am having problems connecting to Oracle9i using COCOBASE. I am using OCI9 drivers. My application server is WEBLOGIC. Can you please tell me the steps involved in connecting to Oracle 9.2 using cocobase.

Its urgent

Thanks
Mukesh Somani

Did you see the Weblogic BMP tutorials? They step through the
configuration & usage of Weblogic with Oracle drivers.
CocoBase requires that you properly configure the app server
& database to work together first, and then our runtime can
use your defined connection pool in the same way that a hand
coded jdbc application would.

So the correct question is do you have the connection pools
defined?

Did you find the tutorials on the download page, and give them
a try?

That should get you started...

THOUGHT Support

I am not using any BMP at all or even WebLogic connection pools. I want to use Oracle OCI drivers and I have my own connection pool ( CocoBase Pool ) . Now how do I configure if I am on WebLogic. I might want to shift to Tomcat and that should not make any difference as well.

What programming model/components are you using? CocoBase
can use both JDBC 1.2 & JDBC 2.0 style connections. The
JDBC 1.2 connection url syntax will be the same with or without
CocoBase.

So if a pool is avaiable with some jdbc 1.2 url syntax like
jdbc:mypoolprovider:poolname

then CocoBase would support this same syntax. It's really an
issue of what the jdbc system supports however.

With JDBC 2.0 style syntax, you'll need to make
the pool available to your component/application, and then
CocoBase supports a jndiurl syntax in the url such as:

jdbc:cocoprop=jndiurl=java:comp/env/jdbc/MyPool
or
jdbc:cocoprop=jndiurl=jdbc/MyPool

The jndiurl syntax depends on the server and how you have the
pool configured...

But basically CocoBase would rely & use the same basic pool
configuration just as any jdbc code...

THOUGHT Support