• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Ranch Hand
Posts: 224
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Bartender
Posts: 4121
IntelliJ IDE Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic