on 07-03-2006 9:34 PM
Hello All,
I am working on migrating a J2EE app from Websphere Application Developer 5.1.2 to run on SAP J2EE engine. Once I deployed the ear and started the app, I get the app's login screen. When I try to login, I get the following exception:
com.sap.engine.services.jndi.persistent.exceptions.NamingException: Exception during lookup operation of object with name webContainer/applications/sap.com/PTA/pta-web/java:comp/env/jdbc/NonXADataSource, cannot resolve object reference. [Root exception is com.sap.engine.services.connector.exceptions.BaseResourceException: ConnectionFactory "jdbc/NonXADataSource" does not exist. Possible reasons: the connector in which ConnectionFactory "jdbc/NonXADataSource" is defined is not deployed or not started.
Below are the steps that I've done on the migration to SAP:
1. From SAP Management Console, started the J2EE Engine.
2. From Visual Administrator Tool, I created the JDBC driver (added appropriate drivers needed for SQL Server 2000) and datasources (added two datasources needed by our app), using the JDBC Connector.
3. From Deployment Tool, I did the following:
a. Created a project.
b. Using the Assembler tab, created an EAR file from the WAR file that I exported from our J2EE app in Websphere Application Developer 5.1.2.
c. Using the Deployer tab, added the datasource configuration and added the datasource alias.
d. Using the Deployer tab, I deployed the EAR file and started the application.
Since I am new in using SAP, I most likely missed something in my configuration setup. Any advice on this issue is greatly appreciated.
Thanks in advance,
Jose
Hi,
From the error trace, it seems that the JDBC connector configuration in VA needs a rechecking. Ensure db connection is okay by running a query in the DB Initialization.
Regards,
Srinivasan T
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Srinivasan,
Thanks for the reply and good point.
When I setup my datasources, I did run the test query in the DB initialization to make sure that the datasources were setup correctly. I received an OK reply when the query ran successfully.
Is there any other setup which I may have left out?
Thanks,
Jose
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.