Java Shopping Basket ISA R/3

[Former Member]

Hello,

display of the shopping basket doesn't work (get an empty page).

The log File isa-jdbc.log contains the following error:

Apr 3, 2006 8:45:26 AM,070 Client_Thread_19 Debug bbcom.sapmarkets.isa.backend.jdbc.order.BasketJDBC [ID4001DB0.5506350293184352End|?]usedatabase has been set to : true

Apr 3, 2006 8:45:26 AM,070 Client_Thread_19 Debug bbcom.sapmarkets.isa.backend.jdbc.order.BasketJDBC [ID4001DB0.5506350293184352End|?]forceIPCPricing has been set to : false

Apr 3, 2006 8:45:26 AM,070 Client_Thread_19 Debug bbcom.sapmarkets.isa.backend.jdbc.order.BasketJDBC [ID4001DB0.5506350293184352End|?]preventIPCPricing has been set to : false

Apr 3, 2006 8:45:26 AM,070 Client_Thread_19 Debug bbcom.sapmarkets.isa.backend.jdbc.order.BasketJDBC [ID4001DB0.5506350293184352End|?]lineItemNumberIncrement has been set to : 10

Apr 3, 2006 8:45:26 AM,117 Client_Thread_19 Debug bbcom.sapmarkets.isa.backend.jdbc.order.BasketJDBC [ID4001DB0.5506350293184352End|?]com.sapmarkets.isa.core.eai.BackendException: javax.naming.NamingException: ID003608 : Object not found in lookup of ServerContextImpl: jdbc/crmjdbcpool

ID003515 : Exception in lookup of ClientContext [Root exception is javax.naming.NameNotFoundException: ID003608 : Object not found in lookup of ServerContextImpl: jdbc/crmjdbcpool]

Apr 3, 2006 8:45:26 AM,132 Client_Thread_19 Info bbcom.sapmarkets.isa.backend.jdbc.order.BasketJDBC [ID4001DB0.5506350293184352End|No database connection provided.] ???en.No database connection provided.???

SAP Note 630753 describes how to create a JDBC-Pool for ISA for Microsoft SQL but we use Oracle.

Which are the right settings for the following Parameters:

Port of Database, Driver (can i use com.inet.tds.TdsDriver?), which jar-File I have to use?

Kind Regards,

Mischa Gwinner

[Former Member]

Hi Mischa,

Have you deployed all SDAs which comes with SAR file? Is no ..thats the first step.

Regards,

Vivek

[Former Member]

Hi Vivek,

I have deployed the following SDAs (Chapter 5 Installation Process of Document Installation Guide CRM 4.0 SP06 - 6.20 Java Components of E-Selling and Channel Management on a SAP J2EE Engine 6.20, Document Version 1.61):

Chapter 5.1.1 Basic Libraries -> SAPJBASIS.SCA

Chapter 5.1.2 Backend-Independent Files -> b2b.ear and shopadmin.ear

Chapter 5.1.6 Files Relevant for Internet Sales (R/3 Edition) -> com.sap.km.trex.client.sda and trexr3.ear

Is it perhaps right, that I can only use the shopping basket with a Microsoft SQL database and not with Oracle in an Internet Sales R/3 Edition environment?

Kind Regards,

Mischa Gwinner

[Former Member]

Hi Mischa,

There are some SDAs related to database schemas too. Please see the SAR file, it must be there.

Regards,

Vivek

[Former Member]

Mischa,

You are right. Java basket can only be used with MS SQL server database, at least till ISA 4.0. Please see section 5.1 Installing the Database Software in the document "Installation Guide: CRM 4.0 SP06 – 6.20 Web Application".

Thx,

Bharat.

[Former Member]

Hello Bharat,

thanks for your help.

I have configure the component basket (in XCM) in the application b2b and set the parameter usedatabase to false. Now I can use the basket.

Kind Regards,

Mischa