aspose file tools*
The moose likes Websphere and the fly likes migrate from tomcat 5 to websphere 5.1 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "migrate from tomcat 5 to websphere 5.1" Watch "migrate from tomcat 5 to websphere 5.1" New topic
Author

migrate from tomcat 5 to websphere 5.1

Milan Jagatiya
Ranch Hand

Joined: Jan 01, 2007
Posts: 164
hi ,
i am new to websphere 5.1.
I want to deploy my web application (war) in websphere. what changes should i need to run application in websphere as in tomcat?.
another question is ...i am using commons dbcp factory for connection pooling in tomcat. what should i do to achieve connection pooling in websphere 5.1?? . i am using ms sql server 2000 database.

waiting for your kind replies.


Milan.<br />I can because I think I can...
Kurtcebe Eroglu
Ranch Hand

Joined: Jan 30, 2007
Posts: 30
Hi Milan,

If you are accessing your database only through datasource definitions (lookup a datasource via jndi and get connections from it) then you don't have to change anything in your application. The war file will deploy to WebSphere as well.

You must first define a JDBC provider with suitable driver (I think WebSphere alreay has an embedded driver for SQLServer). During this operation you should have an option to select "connection pool datasource" as the driver implementation type (I am using v6.0 now and cannot remember exactly). Then you define your datasource using this provider with your database settings. What is left is to map map the datasource you created to the one you defined in your application during deployment (application assemmbly phase).

Regards
Kurtcebe Eroglu
Milan Jagatiya
Ranch Hand

Joined: Jan 01, 2007
Posts: 164
hi kurt,
thanks for reply...
i already done this...not succeed..
i am using ms sql server 2000. to set the datasaurce i following below steps...

1) resaurces -> JDBC Providers -> new ->
2) selected " Microsoft JDBC driver for MSSQLServer 2000 "
3) set classpath for sqljdbc.jar
4) Implementation Classname :
com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource

5) in Additional Properties -> datasaurces -> created datasaurce name "mydb"
6) set all the properties for datasaurce.

still getting error :


JVM logs :


what it says??..

thanks...
Kurtcebe Eroglu
Ranch Hand

Joined: Jan 30, 2007
Posts: 30
Do we have something more at SysErr.log? Log above seems to belong to server startup only (with some JMS configuration errors raised). The lines that are added to the logs just at the time you test the connection would be more informative...

I would also suggest checking your settings against Vendor-specific data sources minimum required settings SQLServer section.

Regards
Kurtcebe Eroglu
Milan Jagatiya
Ranch Hand

Joined: Jan 01, 2007
Posts: 164

Do we have something more at SysErr.log?


System.err





I would also suggest checking your settings against Vendor-specific data sources minimum required settings SQLServer section.

yeah..i already refered that link...but not works..
Kurtcebe Eroglu
Ranch Hand

Joined: Jan 30, 2007
Posts: 30
Milan, there seems to be two different problems; first one is datasource configuration, and second is that something seems to be wrong in your deployment descriptor.

You are testing connection just after you define it, using admin console (not from within your application), right? So to test whether JDBC provider and data source definitions are working, you do not have to deploy any applications. My suggestion is, then, to undeploy your application and focus on datasource definition first; clear all logs, without any applications deployed, simply create and successfully test a connection to your database using admin console (test connection button in datasources page). This way we may avoid different problems getting in each other's way, because, as you can also see, there is nothing related to the error on datasource definition in the logs...

Kurtcebe
Milan Jagatiya
Ranch Hand

Joined: Jan 01, 2007
Posts: 164
Thanks kurt...I really appreciate your help....
I solved it...It was a versioning problem actually...
thanks again...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: migrate from tomcat 5 to websphere 5.1