Oracle Connection in Websphere 4.0

[DeepakY]

Hey All,
I need to know if anybody has done any connection in Webpshere 4.0 Adv Single Server Edition.I need to know how to do define datasource in WAS 4.0.I am running some EJB's on this server which access data from Oracle.
What is the procedure to create Data Source in WAS 4.0
I did something accroding to Websphere Documentation
But I am getting a error saying----
JDBCPersister W JDBC persister creation failed
for all the EJB's I think something is missing in the connection.
Thanks for the help

[Kyle Brown]

I'm sorry, but I just don't have enough information to go on. Can you please post a portion of the log file that shows the error you have?
Did you follow the instructions in section 6.6.14: Administering database connections (overview) of the InfoCenter?
Kyle

[Ketan Khimani]

Hi,
I think its a problem with URL.A custom property in case of Oracle which ur had not provided with ur Datasource.
In Datasource define custom property named URL and its value as jdbc racle:thin:@urserver:1521:hoststring
and that will work.
If than also ur getting problem then send back reply with ur log file.
Bye

[DeepakY]

Thanks for taking interest in my problem But I have given correect URL in the Data Sources ...I think I figured its not an error from Oracle but something to do with Admin Server I believe , but don't have enough info about this
The log file looks like
[02.01.31 23:06:11:515 EST] 5aa494e EJBEngine I WSVR0037I: Starting EJB jar: bostonCoachEJB11
[02.01.31 23:06:14:781 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:14:906 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#ProfileCreditCardMap: ProfileCreditCardMap
[02.01.31 23:06:14:906 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:15:000 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#AFPhoneRegistry: AFPhoneRegistry
[02.01.31 23:06:15:125 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:15:203 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#AFReservationBillingRegistry: AFReservationBillingRegistry
[02.01.31 23:06:16:187 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:16:281 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#AFDescriptionRegistry: AFDescriptionRegistry
[02.01.31 23:06:16:296 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:16:375 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#ServiceAreaRegistry: ServiceAreaRegistry
[02.01.31 23:06:16:390 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:16:468 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#AFCityRegistry: AFCityRegistry
[02.01.31 23:06:16:468 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:16:546 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#SessionRegistry: SessionRegistry
[02.01.31 23:06:16:546 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:16:625 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#AFStopRegistry: AFStopRegistry
[02.01.31 23:06:16:687 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:16:765 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#OrderHistory: OrderHistory
[02.01.31 23:06:16:765 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:16:843 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#OAGRegistry: OAGRegistry
[02.01.31 23:06:16:843 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:16:921 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#UserRegistry: UserRegistry
[02.01.31 23:06:16:937 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:17:015 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#ApplicationRegistry: ApplicationRegistry
[02.01.31 23:06:17:109 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:17:218 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#AccountRegistry: AccountRegistry
[02.01.31 23:06:17:234 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:17:312 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#ProfileLocationMap: ProfileLocationMap
[02.01.31 23:06:17:312 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:17:390 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#CodeRegistry: CodeRegistry
[02.01.31 23:06:17:406 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:17:484 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#ProfileRegistry: ProfileRegistry
[02.01.31 23:06:17:531 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:17:656 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#LandmarkRegistry: LandmarkRegistry
[02.01.31 23:06:17:765 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:17:843 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#UserGroupMap: UserGroupMap
[02.01.31 23:06:18:062 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:18:187 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#MemberRegistry: MemberRegistry
[02.01.31 23:06:18:203 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:18:281 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#ReceiptRegistry: ReceiptRegistry
[02.01.31 23:06:18:328 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:18:468 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#ServiceAreaVehicleTypeMap: ServiceAreaVehicleTypeMap
[02.01.31 23:06:18:468 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:18:546 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#MemberAccountMap: MemberAccountMap
[02.01.31 23:06:18:562 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:18:640 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#FlightRegistry: FlightRegistry
[02.01.31 23:06:18:640 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:18:718 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#OrderRegistry: OrderRegistry
[02.01.31 23:06:18:734 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:18:812 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#PromotionRegistry: PromotionRegistry
[02.01.31 23:06:18:968 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:19:046 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#ProfileWirelessDeviceMap: ProfileWirelessDeviceMap
[02.01.31 23:06:19:109 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:19:187 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#CounterRegistry: ProfileWirelessDeviceMap
[02.01.31 23:06:19:187 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:19:281 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#AFMemberProfileInfoRegistry: AFMemberProfileInfoRegistry
[02.01.31 23:06:19:500 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:19:625 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#ProfileAccessMap: ProfileAccessMap
[02.01.31 23:06:19:640 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:19:718 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#MemberGroupMap: MemberGroupMap
[02.01.31 23:06:19:718 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:19:796 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#OrderStopMap: OrderStopMap
[02.01.31 23:06:19:812 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:19:906 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#VehicleTypeRegistry: VehicleTypeRegistry
[02.01.31 23:06:19:921 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:20:000 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#OrderPickupInstructionMap: OrderPickupInstructionMap
[02.01.31 23:06:20:015 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:20:093 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#ProfilePromotionMap: ProfilePromotionMap
[02.01.31 23:06:20:156 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:20:250 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#AFReservationRegistry: AFReservationRegistry
[02.01.31 23:06:20:250 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:20:343 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#AFReservationHistoryRegistry: AFReservationHistoryRegistry
[02.01.31 23:06:20:687 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:20:796 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#OrderFlightMap: OrderFlightMap
[02.01.31 23:06:20:796 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:20:875 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#OrderAddressMap: OrderAddressMap
[02.01.31 23:06:20:875 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:20:953 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#AppAuthorizationMap: AppAuthorizationMap
[02.01.31 23:06:20:984 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:21:062 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#LandmarkPickupInstructionMap: LandmarkPickupInstructionMap
[02.01.31 23:06:21:078 EST] 5aa494e JDBCPersister W JDBC persister creation failed
[02.01.31 23:06:21:156 EST] 5aa494e EJBEngine I WSVR0062E: Failed to start EJB, BostonCoachApp#bostonCoachEJB11.jar#AFReceiptRegistry: AFReceiptRegistry
[02.01.31 23:06:22:031 EST] 5aa494e ServletEngine A SRVE0161I: IBM WebSphere Application Server - Web Container. Copyright IBM Corp. 1998-2001
[02.01.31 23:06:22:093 EST] 5aa494e ServletEngine A SRVE0162I: Servlet Specification Level: 2.2
[02.01.31 23:06:22:140 EST] 5aa494e ServletEngine A SRVE0163I: Supported JSP Specification Level: 1.1
[02.01.31 23:06:22:312 EST] 5aa494e ServletEngine A Session Manager is Configured - Initializing...
[02.01.31 23:06:22:656 EST] 5aa494e CacheManager A DYNA0011E: Servlet cache file dynacache.xml not found; caching is disabled
[02.01.31 23:06:22:750 EST] 5aa494e ServletEngine A Loading Web Module: Default Application
[02.01.31 23:06:23:125 EST] 5aa494e WebGroup I SRVE0091I: [Servlet LOG]: JSP 1.1 Processor: init
[02.01.31 23:06:23:187 EST] 5aa494e WebGroup I SRVE0091I: [Servlet LOG]: InvokerServlet: init
[02.01.31 23:06:23:625 EST] 5aa494e ServletEngine A Loading Web Module: Examples Application
[02.01.31 23:06:23:718 EST] 5aa494e WebGroup I SRVE0091I: [Servlet LOG]: JSP 1.1 Processor: init
[02.01.31 23:06:23:734 EST] 5aa494e WebGroup I SRVE0091I: [Servlet LOG]: SimpleFileServlet: init
[02.01.31 23:06:23:953 EST] 5aa494e ServletEngine A Loading Web Module: admin
[02.01.31 23:06:24:171 EST] 5aa494e WebGroup I SRVE0091I: [Servlet LOG]: JSP 1.1 Processor: init
[02.01.31 23:06:24:203 EST] 5aa494e WebGroup I SRVE0091I: [Servlet LOG]: SimpleFileServlet: init
[02.01.31 23:06:24:343 EST] 5aa494e WebGroup I SRVE0091I: [Servlet LOG]: action: init
[02.01.31 23:06:25:156 EST] 5aa494e ServletEngine A Loading Web Module: YourCo Web Application
[02.01.31 23:06:25:296 EST] 5aa494e WebGroup I SRVE0091I: [Servlet LOG]: JSP 1.1 Processor: init
[02.01.31 23:06:25:296 EST] 5aa494e WebGroup I SRVE0091I: [Servlet LOG]: SimpleFileServlet: init
[02.01.31 23:06:25:312 EST] 5aa494e WebGroup I SRVE0091I: [Servlet LOG]: InvokerServlet: init
[02.01.31 23:06:25:406 EST] 5aa494e ServletEngine A Loading Web Module: Samples Web Application
[02.01.31 23:06:25:515 EST] 5aa494e WebGroup I SRVE0091I: [Servlet LOG]: JSP 1.1 Processor: init
[02.01.31 23:06:25:531 EST] 5aa494e WebGroup I SRVE0091I: [Servlet LOG]: SimpleFileServlet: init
[02.01.31 23:06:25:531 EST] 5aa494e WebGroup I SRVE0091I: [Servlet LOG]: InvokerServlet: init
[02.01.31 23:06:25:578 EST] 5aa494e ServletEngine A Loading Web Module: theme Web Application
[02.01.31 23:06:25:640 EST] 5aa494e WebGroup I SRVE0091I: [Servlet LOG]: JSP 1.1 Processor: init
[02.01.31 23:06:25:656 EST] 5aa494e WebGroup I SRVE0091I: [Servlet LOG]: SimpleFileServlet: init
[02.01.31 23:06:25:671 EST] 5aa494e WebGroup I SRVE0091I: [Servlet LOG]: InvokerServlet: init
[02.01.31 23:06:25:843 EST] 5aa494e ServletEngine A Loading Web Module: HelloWar

[Kyle Brown]

No, this isn't the admin server -- this is your application server that's throwing exceptions. My guess is that the name you're using to look up the DataSource in the code might not match the name you gave it in the setup in the admin console.
These appear to be CMP beans. Did you do a simple top-down mapping? How did you deploy them? Did you use WSAD or not?
Kyle

[DeepakY]

Hey Kyle,
Thianks for the help , I did deploy my Ejb's but while deploying it gave me errors for some of the EJb's and some were deployed properly.
No I didn't create the jar file by WSAD but thru VAJ 4.0. Can I run EJB 1.0 on WAS 4.0.Another problem I saw was on Admin Console of WAS 4.0 where I don't see ejb-jar.xml.Its blank that means my EJB's are not properly deployed right.
Thanks anyway
Deepak

[Daryl Le]

No, you can't run EJB 1.0 on WebSphere App Server 4.0 (WAS40). You can either:
1. Import your 1.0 EJBs into VisualAge 4.0 (VAJ40) and then re-generate them as EJB 1.1.
2. Use Assembly Application Tool (AAT) to convert the beans from 1.0 to 1.1. See IBM InfoCenter section 6.7 Tutorial.
VAJ40 does some "magic" to make the beans look like EJB 1.1 compliant. The bean are NEVER EJB 1.1 compliant.
One way to check this out is running the Verify function of the AAT against the generated beans by VAJ40.
You'll get a lot of messages saying that the ejbs not compliant.
The strange thing is that they seems to be deployed and work fine in the WAS40.
If you have errors during the installation of the application, your application won't work.
Daryl