This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Any Good Books On Java/SQL Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Any Good Books On Java/SQL Server" Watch "Any Good Books On Java/SQL Server" New topic
Author

Any Good Books On Java/SQL Server

Brandon Tom
Ranch Hand

Joined: Jan 11, 2006
Posts: 48
I know that JDBC basically allows you to ignore the specific database. but do you guys know any really interesting books about Java and SQL Server specifically.

In fact, any books on the topic would be welcome.

[ February 04, 2006: Message edited by: Brandon Tom ]
[ February 04, 2006: Message edited by: Brandon Tom ]

Brandon Tom, SCJP, MCP<br />Programmer/Graphic Designer<br /><a href="http://mailto:tombrand@hawaii.edu" target="_blank" rel="nofollow">tombrand@hawaii.edu</a>
Michael Duffy
Ranch Hand

Joined: Oct 15, 2005
Posts: 163
Originally posted by Brandon Tom:
I know that JDBC basically allows you to ignore the specific database. but do you guys know any really interesting books about Java and SQL Server specifically.

In fact, any books on the topic would be welcome.

[ February 04, 2006: Message edited by: Brandon Tom ]

[ February 04, 2006: Message edited by: Brandon Tom ]


I'm sure you won't find any.

Lots of books about JDBC, more about SQL Server, but I'll bet none about the two topics together.

As you've said, JDBC abstracts you from the database vendor. The success of that notion is borne out by the fact that there ARE no books on it.


%
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30138
    
150

There are books on some common databases and JDBC. I just read one on Oracle. But I haven't seen it for any other databases. That's not to say they don't exist, of course.

Maybe another approach is to try searching for SQL Server on Amazon and seeing if anyone has read them?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
stu derby
Ranch Hand

Joined: Dec 15, 2005
Posts: 333
Originally posted by Brandon Tom:
I know that JDBC basically allows you to ignore the specific database.

Sadly, that's not nearly as true as anyone would like. While there's a very very large "common denominator" among the major DBs when using JDBC, there's still a huge amount of DB-specific stuff that intermediate-to-advanced developers get into.

A quick casual example is the vendor default behavior when Statement.setFetchSize() hasn't been called. Some vendor's drivers will by default will fetch a single row at a time, thereby creating an I/O bottleneck; some drivers will fetch all returned rows in the ResultSet, thereby creating a scaling problem with large results (running you out of memory, typically), and some drivers have default fetch sizes that avoid these extremes, but may still not be right for your situation.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Any Good Books On Java/SQL Server
 
Similar Threads
Drawing An Image In Full-Screen
scriplets in jsp's
SQL ServerAgent restarting automatically
Marcus Green Mock- doubt
Strign Objects