Skip to Content
author's profile photo Former Member
Former Member

JDBC Connector in NetWeaver Dev Studio WebAS

Hello,

I am attempting to deploy a web module that utilizes a WebAS datasource for an external Oracle database. I expect to add a JDBC Connector leveraging the Oracle JDBC driver. I have been unable to deploy the Oracle datasource.

I receive the stack trace below whenever I attempt to Start the datasource. I find many posts asking about this error but never have I found an answer as to the cause or resolution. OSS Note 751175 describes this as a classloader problem with connectors but it does not offer any repair method that works with this problem (in my case).

I've had this problem with NetWeaver SP7 and it remains with SP10.

Does anyone have explanation? Can I expect to test such applications in NetWeaver's standalone WebAS?

Best regards,

Gary

ava.rmi.RemoteException: Error occurred while starting application in whole cluster and wait.; nested exception is:

com.sap.engine.services.deploy.exceptions.ServerDeploymentException: Clusterwide exception: server ID 4114150:com.sap.engine.services.dbpool.exceptions.BaseDeploymentException: Cannot create DataSource "CMR".

at com.sap.engine.services.dbpool.deploy.ContainerImpl.startDataSources(ContainerImpl.java:1836)

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jan 18, 2005 at 04:43 PM

    Hi Gary,

    unfortunately it is not that easy to find out the details about this. You need to find two positions in the manuals for this. First is about JDBC Connector in the Admin manual:

    http://help.sap.com/saphelp_erp2004/helpdata/en/b0/6e62f30cbe9e44977c78dbdc7a6b27/frameset.htm

    This one explains how to define the JDBC datasource. But to do so you already need to have deployed the jar files. And that is done with the studio by defining and deploying a J2EE component, described here:

    http://help.sap.com/saphelp_erp2004/helpdata/en/9f/2ade3fc6c6ec06e10000000a1550b0/frameset.htm

    This should be it. According to your writing I guess you have seen the first place already. I'll take care so there will be a link to the deployment description in the future.

    Regards,

    Benny

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 18, 2005 at 05:22 PM

    Benny,

    Thank you for your reply but unfortunately I have read these links several times and executed the instructions carefully. They do not work.

    Have you tried this procedure yourself? If so could you note the exact steps you followed? Something is missing in the documentation.

    There are other exceptions related to this appearing in the default trace log (see below). I believe they are the root cause but I can't pin it down.

    Could you please suggest other checks I can verify?

    Best regards,

    Gary

    Caused by: com.sap.engine.services.dbpool.exceptions.BaseInstantiationException: Cannot create instance ManagedConnectionFactoryImpl.

    at com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl.<init>(ManagedConnectionFactoryImpl.java:79)

    at com.sap.engine.services.dbpool.deploy.ContainerImpl.startDataSources(ContainerImpl.java:1779)

    ... 40 more

    Caused by: java.lang.ClassCastException

    at com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl.<init>(ManagedConnectionFactoryImpl.java:77)

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Gary,

      the only problem left seems to be that you cannot activate another datasource. However, this should be possible absolutely, as you did that already because you always have the system DS running (without it the server wouldn't deven start).

      So, what happens when you try a third one?

      Please also keep in mind that Sybase is not supported by SAP , that means you have to run in "vendor" mode of the driver, to not use OpenSQL (you may try out the "native" mode later to get possibly SQLTrace and Table Buffer support)

      So what we need is the effects of the Sybase driver.

      Regards,

      Benny

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.