What for I need BC_DDDBTABLERT table for JPA operation's?

[Former Member]

Hello!

I create Entity EJB 3.0 with CMP with SAP JPA 1.0 with external Datasource.

Also I write SessionBean with Webservice directives and get webservice as I need.

But in runtime I've got exception:

Look at SOAP response it:

<SOAP-ENV:Envelope xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <SOAP-ENV:Body>
      <SOAP-ENV:Fault>
         <faultcode>SOAP-ENV:Server</faultcode>
         <faultstring>javax.ejb.EJBException: Exception in getMethodReady() for stateless bean sap.com/Demo1*annotation|demo1ejb.jar*annotation|OrderWSBean; nested exception is: com.sap.engine.services.ejb3.util.pool.PoolException: javax.ejb.EJBException: Cannot perform injection over bean instance ru.tech.sess.OrderWSBean@1488775 for bean sap.com/Demo1*annotation|demo1ejb.jar*annotation|OrderWSBean; nested exception is: com.sap.engine.services.ejb3.injection.InjectionException: Injection on field em of instance ru.tech.sess.OrderWSBean@1488775 failed. Could not get a value to be injected from the factory.</faultstring>
         <detail>
            <ns1:com.sap.engine.interfaces.webservices.runtime.RuntimeProcessException xmlns:ns1="http://sap-j2ee-engine/client-runtime-error">
               <!--javax.ejb.EJBException: Exception in getMethodReady() for stateless bean sap.com/Demo1*annotation|demo1ejb.jar*annotation|OrderWSBean; nested exception is: com.sap.engine.services.ejb3.util.pool.PoolException: javax.ejb.EJBException: Cannot perform injection over bean instance ru.tech.sess.OrderWSBean@1488775 for bean sap.com/Demo1*annotation|demo1ejb.jar*annotation|OrderWSBean; nested exception is: com.sap.engine.services.ejb3.injection.InjectionException: Injection on field em of instance ru.tech.sess.OrderWSBean@1488775 failed. Could not get a value to be injected from the factory.-->
            </ns1:com.sap.engine.interfaces.webservices.runtime.RuntimeProcessException>
         </detail>
      </SOAP-ENV:Fault>
   </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

I look at defaultTrace.0.trc and there i see:

Caused by: com.sap.engine.services.ejb3.injection.InjectionException: Injection on field em of instance ru.tech.sess.OrderWSBean@1488775 failed. Could not get a value to be injected from the factory.

	at com.sap.engine.services.ejb3.injection.FieldInjector.inject(FieldInjector.java:105)

	at com.sap.engine.services.ejb3.injection.InjectionMatrix.inject(InjectionMatrix.java:35)

	at com.sap.engine.services.ejb3.runtime.impl.Interceptors_DependencyInjection.invoke(Interceptors_DependencyInjection.java:22)

	... 72 more

Caused by: com.sap.dictionary.database.dbs.JddRuntimeException:  Caused by: [-4004] (at 16): Unknown table name:BC_DDDBTABLERT

I need to create BC_DDDBTABLERT table in any Datasource which I attach to SAP J2EE5 ?

Which another tables MUST be in DB schema?

How can I declare table in J2EE?

P.S. I can post EAR source code and Datasource deployment descriptor (if it's need)

[adrian_goerler · Accepted solution]

Hi,

the table BC_DDDBTABLERT contains the logical database catalog information used (only) by the Java Dictionary and Open SQL. If you use an external data source, you should configure it for "Native SQL" in the Visual Administrator/NW Administrator or in the XML description, respectively.

Adrian