Microsoft SQL Server History
Comment
Archives: andreas
Error in the MS SQL JDBC driver 02/01/2828
The Microsoft JDBC driver, version 2.1.2828, provide all the SCHEMA on the JDBC interface. More precisely, said a DatabaseMetaData.getSchemas (), not all schema of an SQL server. Especially notable was the work when using DbVisualizer Free and the MS SQL Server 2005. Because of this behavior I had contact with the Ming be autonomous (manufacturer of DB Visualizer). I then received this reply:
Catalogs and schemas in DbVisualizer Free are retrieved by asking the JDBC driver to return them.
DbVisualizer Personal use its own SQL to fetch schema information.
Here's an example with the AdventureWorks sample database from Microsoft:
The support staff of Minq then gave me the hint that this is known at Microsoft, and the behavior is not caused by DbVisualizer: MS JDBC driver error , the driver 1.2.2828 is the latest version of the SQL Server 2005. The message in the forum is from January 2008! Since no bug fixing?
There is also the Microsoft SQL Server JDBC Driver 2.0 (2009 Jan) as a community technology preview , this also allows a connection to SQL Server 2005 and is JDBC 4.0 compliant if the version of Java 6 is used.
After a test set out at me too so wide disillusionment. As the screenshot below shows, the behavior is identical:
Unfortunately, this also provides brand-new driver is not correct SCHEMA. What makes because Microsoft? What is so difficult an accurate list of SCHEMA's return?
Update! They eliminated everyone in NetBeans in the USA
There is a post by David Van Couvering to his dismissal from Sun in this NetBeans forum . David was the head of the DB NetBeans team. According to his information, the entire NetBeans team was disbanded in the United States.
They eliminated everyone in NetBeans in the United States. The entire team was laid off J2EE, as well as the frameworks team. They also eliminated the QA team in St. Petersburg. So I do not think it's about mysql db tooling and tooling redundancy.
In recent months, several improvements have been implemented in the DB support in NetBeans, the example now: even the SQL code completion in NetBeans PHP editor is possible.
Too bad! Both for the affected developers as well as the NetBeans users.
The database support in NetBeans could be really good. There were many ideas to take place in what direction the development should be. The following are links to a few wiki pages of the DB team:
NetBeansDatabases
RewriteDBExplorer
NetBeansDatabases
The developers have looked beyond the horizon and what is considered the competition evolves in this area: DBCompetitiveAnalysis
DB Netbeans team eliminated
On the NetBeans DB mailing list (db.netbeans.org) has a SUN staff yesterday announced that the entire team was eliminated NetBeans DB:
You should know that actually the entire team was eliminated DB today, so this list, for a time at least, will be quite silent.
These are the effects of the Sun announcement to cut jobs 6000 . This "measure" has the market today with a strong price increase rewards.
Comparison of different SQL implementations
The page Comparison of different SQL implementations is very informative with respect to some DB systems. A look is worthwhile!
Getting the sources from Netbeans Mercurial
To work with the latest NetBeans sources, it is only one way: get the data from the source management. Some time ago moved from CVS to Mercurial SUN. Wiso, why? No idea! In connection with Netbeans is my first time to the source management Mercurial come in contact.
What exactly do anything to retrieve the source code is here described.
A hint from my own experience I can add: The first retrieve the source should not be carried out wirelessly. Anyway, it worked for me only works when I had my laptop connected via a network cable to the Internet.
Once the sources are successfully drawn on the plate to see the properties of the folder something like this:
That's quite a start! 239 000 Files! As you can wish all those who want to incorporate new here just "good succeed" 
Who is now an ant build starts to build the complete IDE with all extensions, which takes time. On my laptop (Centrino Duo) about 1 hour can be the whole extensions (this is mobile and the mobile) is not needed, can keep the build much slimmer by running it as:
ant Dcluster.config = basic
This will create only the Basic IDE. For me to get to know the (new) SQL Support for NetBeans: Just the right example.
Zip file of the NetBeans sources too big for WinZip?
Anyone who wishes to deal with the sources of NetBeans can here download a ZIP file of the entire IDE. The problem I've encountered here is the ZIP file itself! The extract this file with Winzip successfully saw at first glance. Simply "unzip file here" and away you go (I was thinking .
The extract needed some time on my laptop since many many files are included. The file (netbeans-trunk-night_xxx.zip) is about 280 MB in size and extract it with Winzip returns no error messages.
The subsequent attempt an ant build file to run with them, brought the most remarkable results and definitely not bootable IDE. Some re-download and then try to build did not improve. Unfortunately, the busy email traffic helped with the next (very helpful) is not Netbeans developers. They confirmed again that the file is in order and build on them to work without problems.
Then I got the idea to use another packer, sometimes even the best ideas are the spontaneous ... This was the solution of the problem!
Winzip says: This ZIP file is befänden 2671 files.
The same document of 7-Zip provides analysis of this result:
There are now suddenly 68 207 files! Aha!
After I had unpacked the sources with this tool, was also the subsequent build (almost) no problem, but that's another story.
Windows Live Hotmail saves planets and moons
Who are the days of a mail account with Microsoft sets up will receive the following notice:
The Hotmail storage space is designed so that it is increased with time,
However, only a moderate speed. This means that you should have enough space, as long as you do not save the planet Jupiter suddenly in Hotmail.
In this case, you will receive a nice e-mail in which we ask them
To save any planet in Hotmail (which gradually saving planets, moons and asteroids still OK).
)
Update: DbVisualizer 6.0.13
As of today, there's the DbVisualizer 6.0.13
Query Analyzer add-on: SQL Assistant
Using this tool, I just stumbled upon: SQL Assistant. It is ... how could it be otherwise, an additional code completion tool for SQL developers. SQL Assistant provides two innovative ideas in my opinion:
First It allows SQL code completion in a console window!
Second The code completion window in query analyzer lists the tables apparently using a TreeView? Real good idea to quickly jump to the column. I've tried to follow it yet, details!