cancel
Showing results for 
Search instead for 
Did you mean: 

ConnectionFactory Exception

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

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