Migrating j2ee Application from JBoss to SAP

[Former Member]

Dear sirs,

I am new to SAP WAS. I am working in struts, J2ee technology. We have a project which is deployed in JBoss4.0.2 with MySQL as the back end. The project uses CMP and Normal JDBC for database access.

1. Will SAP WAS support Migration from JBoss?

2. We are using MySQL as back end and we would like to know whether the database is suppeoted bt SAP WAS?

I tried to create a sample Entity bean with CMP with MySQL as back end; But failed to get the connection.

Do you have any idea whether any tutorials are available to for configuring and creating EJBs using SAP WAS with MySQL as backend?

Your hel and suggestions solicited,

Thannkyou,

Sudheesh K S

[Vlado]

Hi Sudheesh K S,

> 1. Will SAP WAS support Migration from JBoss?

Yes. Please check the <a href="https://media.sdn.sap.com/html/submitted_docs/sap_j2ee_migration_kit_webpages/index.html">J2EE Migration Kit</a>. You could also find a lot of useful information by searching in this forum's posts.

> 2. We are using MySQL as back end and we would like to know whether the database is suppeoted bt SAP WAS?

No. SAP Web AS Java supports the following databases: MaxDB, Oracle, MS SQL Server, and DB2 on different platforms. For more information please refer to the <a href="https://websmp104.sap-ag.de/~form/handler?_APP=00200682500000001303&_EVENT=RELEASE&00200682500000002804=01200314690900000192&00200682500000003818=PLTFRM&00200682500000003853=Application Server Java">Product Availability Matrix</a>.

Hope that helps!

Vladimir

[Former Member]

Dear sir,

Thankyou very much for your support. I was not able to access the producy availability matrix.

Sir I have one more doubt,

I want to migrate my existing database which is in MySQL 4 tp MaxDB.

How can it be possible? I started the SAP server and select the DB from SAP Management Console. But didn't find any option for migration.

What is the steps to do the same?

Sudheesh K S

[Former Member]

Hi,

Create the EAR file of your application and use the Deploy Tool to deploy the EAR File.

check link for Deploying J2EE Application.

http://help.sap.com/saphelp_nw04s/helpdata/en/f4/6c9962da317549a05919ce926b5196/frameset.htm

Check link for DataSource Creation (define the alias as used in the application)

http://help.sap.com/saphelp_nw04s/helpdata/en/c7/641f44be9f1e4ebbe807cfbad61d44/frameset.htm

Note: Usage of alias in the application 'jdbc/<aliasName>'

Regards,

S.Divakar