Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

J2EE Professional Projects question  RSS feed

 
Luther Adon
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I bought this book for learning J2EE by Pallavi Jain and Shadab Siddiqui. The databases it uses are built with Microsoft SQL Server 2000. The book includes no databases and I am pretty sure there is no learning version of it on the net(please correct me if I am wrong).
I am wondering if I change the database the projects access through Servlets from MS SQL Server 2000 to MySQL or McKoi , given I am new to database access and J2EE and Servlets, am I likely to get hopelessly confused?
If yes, can anyone recommend a book that walks me through building one or more projects that use databases, EJB, JSP and J2EE. I am trying to figure out if I should take this book back and get something more useful.
 
Lasse Koskela
author
Sheriff
Posts: 11962
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In J2EE, database access is given by the container though an interface (javax.sql.DataSource) which doesn't change based on the underlying database. In other words, whether you're using MySQL or MSSQL doesn't affect your code (except for possibly some slight changes in the SQL strings). What it affects is how you configure your database connections for the application server (e.g. how does the connection URL look like, what is the JDBC driver class name, etc.).
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!