This week's book giveaway is in the Performance forum.
We're giving away four copies of The Java Performance Companion and have Charlie Hunt, Monica Beckwith, Poonam Parhar, & Bengt Rutisson on-line!
See this thread for details.
Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Code compatibilty in j2ee application while migrating from SQL Server 2000 to SQL Server 2005

 
sumanta panda
Ranch Hand
Posts: 224
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear All,
We have developed our application in j2ee technology where we used Struts ,EJB and SQL Server 2000.

In our java program we have written SQL queries.Sometimes we have also written Dynamic sql queries.

While migrating from SQL Server 2000 to SQL server 2005 what are types of changes required for java code where we have written sql query.

Please advise or guide me for the pointer of the URL so that it helps me to achieve my milestone.

Please share your input.

Thanks in advance.

Regards
Sumanta Panda
 
Nathan Pruett
Bartender
Posts: 4121
IntelliJ IDE Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It's probably not the "Java code" itself that's going to change - it's going to (possibly) be stuff like changing database connection information, and SQL queries. Now as for how much change - I don't know... I'm not sure how much changed between SQL Server 2000 and 2005.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic