DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Refcards Trend Reports Events Over 2 million developers have joined DZone. Join Today! Thanks for visiting DZone today,
Edit Profile Manage Email Subscriptions Moderation Admin Console How to Post to DZone Article Submission Guidelines
View Profile
Sign Out
Refcards
Trend Reports
Events
Zones
Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Partner Zones AWS Cloud
by AWS Developer Relations
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Partner Zones
AWS Cloud
by AWS Developer Relations

Trending

  • Design Patterns for Microservices: Ambassador, Anti-Corruption Layer, and Backends for Frontends
  • TDD vs. BDD: Choosing The Suitable Framework
  • How To Check IP Addresses for Known Threats and Tor Exit Node Servers in Java
  • Logging Best Practices Revisited [Video]
  1. DZone
  2. Culture and Methodologies
  3. Career Development
  4. Interview: Sybase Transact-SQL Browser on the NetBeans Platform

Interview: Sybase Transact-SQL Browser on the NetBeans Platform

Geertjan Wielenga user avatar by
Geertjan Wielenga
·
Nov. 05, 09 · News
Like (0)
Save
Tweet
Share
11.72K Views

Join the DZone community and get the full member experience.

Join For Free
SQLBrowser is a commercial IDE for Sybase Transact-SQL. For a long time, it was built using JBuilder. "At that time," says its developer Nicolas Gouteux (pictured, right), "the notion of a platform did not exist. I switched to the NetBeans Platform a while ago while still maintaining SQLBrowser 'by hand'. It was only after having suffered so much from trying to implement a windowing system and an editor by myself that I switched to the NetBeans Platform."

The full interview follows below: 

Hi Nicolas, how did you go about porting the application to the NetBeans Platform?

I tried to segregate between anything having to do with NetBeans (the module concept) from the rest by creating two root packages. I must admit that maintaining this separation requires energy.

The port went well although the learning curve was semi-steep at the time,  because there was little documentation at the time or, at least, it was not at all in the state it is today.

Here is a screenshot (more at the end of the interview):

(More screenshots at the end of the interview.)

Which aspects of NetBeans Platform development are you happiest with?

The "layer" invention is great, the Windowing system is also very neat, the Editor options modularity (e.g., hyperlinks) is very well thought out, and the Matisse GUI builder (although, this is not really  NetBeans Platform related) is essential.

Which of the NetBeans API's did you use?

Window System API, Nodes API, all the NetBeans IDE Editor libraries, Text API, the Utilities API, amongst others.

How has your experience been creating all of this?

All this experience is really great. It is quite rare that problems remain unsolved.

I find things improving all the time, for instance all my grammar is written in JavaCC from the start and I never thought I would be able to plug the JavaCC tokenizer into the tokenizer expected by the NetBeans Platform's Syntax Coloring. So I currently have 2 tokenizers. I saw that a JavaCC integration tutorial is out there! I will try this ASAP!

Can you give some tips for someone beginning a similar project on the NetBeans Platform?

Understanding how to create a NetBean Platform application is probably the most useful thing to do before starting. There are idioms which are best grasped through the tutorials, which I think are fundamental to adoption of the NetBeans Platform. I often  dreamed  that these tutorials had come earlier! Of course, one can download the whole source tree of NetBeans IDE but this is massive and not very explanatory.

Can you name some things that you'd like to have improved in the NetBeans Platform?

  • Modes. I am still struggling with modes setup when not all modules are enabled. All "wstcref" stuff is voluntarily left unexplained. I must say that whenever I reach a stable state, I rely on the magic to work. It is always tricky for software updates to work while preserving end users preferences, but this is a general issue.

  • Java-Centricity. I found initially that some things were too Java oriented. The main Options window panel, for example, is the general panel for options of any application, but contains items for Java Code Folding by default, even if your project has nothing to do with a Java editor.

  • Unexpected behavior. I have funny things happening with some customers, where some shortcuts suddenly seem to disappear (e.g., Ctrl-N, for New File) without explanation. Also, people sometimes get stuck in DDBlitLoops.Blit when unlocking their screens, but this is more of a Java2D issue I believe.

  • Closed classes. I sometimes find the classes too closed but I guess this is the price to pay to have a modularized system. There are some fields which I would have preferred protected rather than private, although I realize that this often betrays bad usage of the library!


Who are users of the application and what do they say about it?

Sybase customers are typically banks and insurance companies. Users of this application include:

  • SYBASE CONSULTING FRANCE
  • BNP PARIBAS ASSET MANAGEMENT
  • CLEARCHANNEL FRANCE
  • PREMALLIANCE
  • AGEFOS PME
  • BCA EXPERTISE
  • CREDIT AGRICOLE CHEUVREUX

Their comments can be found here.


What's the future of your application?

The first version of SQLBrowser was written in C on SunOS with the Curses library!. In 1996, I took the opportunity of Java arriving to learn the language while porting SQLBrowser. Today, SQLBrowser is a decent IDE for Sybase’s Transact-SQL: as long as Sybase is around, there is probably a place for this tool! The main adaptations besides natural enhancements of the tool will be new Syntax constructs and the exploitation of Sybase new features such as monitoring.

Anything else you want to share?

People in the NetBeans team are really impressive. They do a great job which counts almost as much as the Java base libraries themselves! Thanks to everyone. 

Appendix

Looking for database objects:

 Running SQL:

Analyzing SQL:

 Debugging SQL:

 

NetBeans Transact-SQL Interview (journalism)

Opinions expressed by DZone contributors are their own.

Trending

  • Design Patterns for Microservices: Ambassador, Anti-Corruption Layer, and Backends for Frontends
  • TDD vs. BDD: Choosing The Suitable Framework
  • How To Check IP Addresses for Known Threats and Tor Exit Node Servers in Java
  • Logging Best Practices Revisited [Video]

Comments

Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com

Let's be friends: