29 April 2008

Oracle SQL Developer 1.5 is Production

You might be linked into the announcements RSS feed on the OTN forum and so will have received the alert from the SQL Developer team announcing that we have released SQL Developer 1.5.

The latest release of SQL Developer expands the file-based support by introducing tight integration with the CVS and Subversion version control systems. In addition to browsing and editing files in the file system, in this release you can now import files into your source control system, check them out, modify them, and commit the changed files back into the source control system.

SQL Developer 1.5 has two new navigators; a File Navigator, available on start up, and a Versioning Navigator. This latter is not opened by default, instead is accessed when needed using the View menu. Once you have created a connection to your version control system, you can use SQL Developer to import files and version files. SQL Developer tracks the history of a file and you can compare recent changes and accept or reject those changes. Once you have accepted changes and committed them back to the version control system, you can generate a patch, based on the differences.

SQL Developer 1.5 is more than version control. This is the release where we wanted to address as many of the community requests as we could. The snag with that is as soon as you respond to one request, a dozen more new ones pop up. We're no daunted by this, just accepted a long list of requests and if you look at the Exchange, you'll see that many made it into 1.5. Requests added include code insight, updated formatter and more connection options. For a full list of new features, you can review the New Feature list on OTN.

For all new supporting documents, please visit SQL Developer on OTN

18 comments:

steeve_the_man said...

Cool new features indeed. But small things that should work are still not working. Like trying to connect when your password is expired. No error message, nothing. I used to right-click in the connection box and open sqlplus as a workaround, but in 1.5, sqlplus was removed from the connection window.

Sue said...

Hi Steev,

If you check the Thick/OCI driver preference, then when the password expires, you'll be prompted with a dialog. I have a bug logged, as it'd be good for this dialog to be available for basic (thin driver) connections too.

As for SQL*Plus, I have added SQL Plus to all my menus using External Tools to pop into SQL*Plus if I need. What we'd like is for SQL Developer to be able to handle everything you nipped into SQL*Plus for. (That's the goal!)

Keep in touch about features you are after by adding them to the Exchange: http://SQLDeveloper.oracle.com

Thanks fro the feedback
Sue

steeve_the_man said...

Thanks for the tips. I tried adding sqlplus and I am having problems. Can you send me the line you are using in the External Programs Options?

Sue said...

Here's the steps I use for External Tools for SQL*Plus. (Tools - External Tools...) select New...
Program Executable: cmd.exe
Arguments: /K start cmd /k sqlplus.exe ${sqldev.dbuser}
Run Directory (wherever my sqlplus executable is)

Integration Node - select the various menu where you want the menu to appear.

Passing just the dbuser, if I have the SQL Worksheet open for a user and then invoke SQL*Plus, I am connected to that same user, just need to provide the password.

If I am anywhere else in the product, I need to supply user name and password.

Ben Prusinski said...

Hi Sue,

I am using SQL Developer 1.5 right now for testing database migrations to Oracle 10g and 11g. Using the migration tools, I notice that no support is currently available for migrating IBM DB2 UDB and Informix to Oracle 10g and 11g yet in SQL Developer 1.5. Does Oracle have any future plans to offer support for these databases to migrate to Oracle 10g and 11g?

Regards,
Ben Prusinski, Oracle Author/Consultant

http://www.rampant-books.com/book_2008_1_migrating_oracle.htm

Sue said...

Ben,
You'll notice that we increased the support by adding Sybase to the initial three third-party tools supported. We're working through the list and will ultimately all databases supported by Oracle Migration Workbench. DB2 is next on the list.

Sue

Ben Prusinski said...

Sue,

Thank you for the update on third party database support for SQL Developer. Compared to the older migration tools ie) OMWB, it is a cleaner interface and I like having a fully functional IDE development environment as well. I can tell that Oracle has put a lot of time and effort and still development into the product since the early adopter (Raptor) days of the first release.

Regards,
Ben Prusinski

Manny Flores said...

Can Oracle SQL Developer 1.5 be used to migrate PeopleSoft Financials 8.8 on SQL Server 2000 to Oracle 9.2.0.7 on AIX 5.3? How will the dynamic SQL be addressed in the PeopleTools tables?

Sue said...

Manny,

We have a specific team in Oracle that deals with this. Peoplesoft have a toolset to do this and recompile all the Peoplecode.

Please contact me directly on sue.harper@oracle.com for more details.

Sue

kajdo said...

hi sue,

i like your blog - and the sql developer indeed, but it seems that the new version still isn't able to handle the export from a result set to a xls or csv file. for me it looks like the developer is still running the statement at least 2 times like described in several threads in the official oracle forum (http://forums.oracle.com/forums/thread.jspa?messageID=1766233�
http://forums.oracle.com/forums/thread.jspa?messageID=1633222�
http://forums.oracle.com/forums/thread.jspa?threadID=369005) ... is there a way to get the resultset directly in a csv or xls file as standard (or additional) output?

thx for your good work ... btw probably you already described the problem, but the search function on your blog isn't working in ie6 (js error)

Sue said...

Kajdo,

Thanks for the positive feedback and glad to hear you are using SQL Developer. The latest release is 1.5.1, now updated from 1.5. For any issues you have the choice of raising a Service Request with Support or adding the detail to the forum.

The developers did revisit the feature that the export queries twice and fixed some issues.
Of the 3 threads you have posted, only the last goes to SQL Developer forum. I see that I passed the thread on to the developers, but there is no further update. You should update this thread with the details of export that is doing a second call, so that we can look into it further.

The search feature in the blog is from Blogger,so if there are issues you can report them there. But I am able to use search on the blog in IE6 and Firefox with no issues.

Thanks again.
Sue

Vlada said...

Hi,

We would like to start with writting own extensions. There is big problem with documentation. What sources of informations we can use? Your examples (and Kris Rice) are fine but can't substitute regular documentation. Is Sql Developer source code available?

Thanks for your help and best regards

Vlada

Sue said...

Hi Vlada,

Yes, the team are working on documentation for extensions. Are you planning Java Extensions of XML? What are you missing right now? Can we provide a pointer or two before the doc is out?
Please post queries on the forum: http://forums.oracle.com/forums/forum.jspa?forumID=260 that way more benefit from the response. You can use this blog comment to point me to your thread.

Sue

Anonymous said...

There is nothing 'tight' about the integration with the CVS and SVN. In fact I would go so far as to say there is no integration at all!
It looks like someone has added a very badly coded repository browser window to the IDE, but at no point can you drag and drop files into the repository, most of the useful CVS/SVN options are greyed out, such as commit, add etc.
The integration with CVS is even worse than with SVN because you can't mount your repository at lower levels. You have to mount at a root level. Oracle's developers have a lot to learn about version control and writing IDE's. I have spent several days evaluating this tool for our developers and have concluded it is not fit for purpose. Please Oracle, for gods sake drop this rubbish and start writing Oracle plugins for Eclipse or something.

Sue said...

Why not add your comments by name? Anonymous is difficult to work with. If you have bugs let's discuss them. We are committed to making the product work and be useful. The CVS and Subversion extension is available for both JDeveloper and SQL Developer and the teams working on them are always looking for feedback and suggestions. Perhaps if you review the documentation on the JDeveloper site, you'll find some helpful pointers. I use Subversion with SQL Developer and the menu are all available.

Let's address your issue. A quiet rant does not help you or us.

Thanks for the feedback, I'll look into this further.

Sue

Juraj said...

I have to second Anonymous. He certainly had on mind that CVS/SVN integration does not at all simplify the workflow compared to external tool. You still have to export changes from database to file every time you want to commit them. And once they are in tile, it is easier to use TortoiseSVN than wrestle with Versioning menu. Because, for example, SQL Developer is seemingly not able to use pre-existing working copy.

Still I like SQLDev. very much and I like to communicate with you and explain the issue further.

susharma said...

Hi,
Can u please let me know what does the red cross symbol on a view name indicates?

Sue said...

It means the view is invalid. You are best posting your queries on the SQL Developer forum on OTN. There is a link straight there from this blog.