TechEd Speaker Session Approval

June 25, 2007

As I had already told you I submitted two proposals for the TechEd speaker sessions in Munich. After some back and forth I finally got the confirmation mail, that the session about Portal unit tests made it under the last 15.

“We have had an additional opening for the SDN Community sessions at SAP TechEd ’07 Munich, and your session was the next one in line from the voting. Your session “Unit Tests for Enterprise Portal Applications” is now an approved SDN Community session for Munich.”

Looks like someone didn’t took his chance and that would be my ticket to Munich. Fine for me. The final voting results should be up on SDN at any time today. I know for sure that Chris got an approval for both of his sessions so he will be in Munich too.


Call for Proposals on SDN

May 21, 2007

A couple of weeks ago there was a Call for Proposals on SDN for SAP’s annual developer conference TechEd. All SDN members were invited to submit session abstracts for Munich, Bangalore and Las Vegas, which got preselected and are now up for voting by the community until 28th of May.

Linda Bortolus already asked you to vote last week, just like Nigel James did, who is also with two PHP related proposals in the finals. There is still one week left and this is your chance to raise your voice and vote for what and who do you want to see at TechEd this year. And even if you don’t plan to go there, take the time and vote your favorites. Maybe you will benefit from material of sessions released after TechEd.

I submitted three papers and two of them made it into the finals.

1. Unit Test for Enterprise Portal Applications

I became a member of an XP user group a couple of month ago. It’s located in Düsseldorf and we meet up once a month. The first sessions were exciting. The topic we started with was TDD and it was really eye opening to see this done live by a bunch of experienced developers. This is one of the things for me I just don’t get only by reading about it but I had to see and feel how it’s done to get my head around it.

As most of my current development is happening in Enterprise/NetWeaver Portal, it was an obvious next step to figure out how to do it in that environment. So this session is all about TDD and the tools and APIs to do Unit Test in EP and my experiences and lessons learned from the last couple of month.

2. Maximize your Productivity in NWDS

Maybe you have followed my “Pimp Up My NWDS” blog series on SDN. OK, there were only two and they were written already last year but only because there were no follow ups doesn’t mean I’m not constantly trying to optimize my virtual developer workplace where I have to spend most of my working time day by day. Actually I have another PUMN blog in the work and a bunch of other add-ons I’m using in NWDS and plan to write about.

But this session won’t be only about NWDS/Eclipse add-ons but also about how to build up your overall development environment. Development on the NetWeaver Java stack is very different that good old ABAP and I don’t talk about the language perspective here. To keep productive and stay independent you have to have your own server running and once you have to jump between projects with different Java WAS versions it can get nasty.

I wasn’t sure in the beginning if this would fit into the sessions topics that are normally covered but it got excepted for the finals so here we are.

Another sessions I want to point you to is the one by Christian Günther where he talks about Portal Security. Chris is a good friend of mine and I can say he knows what he’s talking about and I expect this to become a really interesting session.

And not to forget Gregor Wolf. He is also taking his chance and is in the finals with a session on Type3 integration.

JDBC DataSource Deployment in NWDS

April 17, 2007

Dealing with databases on SAP NetWeaver Java stack is is usually done by using JDBC . Each installation of an app server has a standard db schema named sap<db name>db which SAP encourages you to use for your applications via OpenSQL, SAP’s database abstraction layer for Java. There are a couple of advantages that you get by using OpenSQL, e.g. support for Java Dictionary (which lets you deploy your table definitions and data types from NWDS), Table Buffer, Statement Pool, SQL Checker and SQL Trace. Further by using SQLJ, part of the OpenSQL framework, you get compile time checks for your SQL statements and that’s one thing we all really like in ABAP, do we?

In order to connect to this standard schema you would probably use a resource reference to connect from EJB like this:

java.sql.DataSource ds = (java.sql.DataSource) jndiCtx.lookup(“java:comp/env/datasourceRef”);

When connecting from outside of EJB you should use a DataSource Alias (DSA) instead. You define a resource reference and DSA as parts of your application. By that your application is easy portable once you need to move it to a new database instance or schema. You’ll find more on this in the DataSource Alias FAQ.

Welcome to RL

When you find yourself in a situation where you can’t use the standard schema, you’ll face a couple of problems you may wouldn’t expect.

1. OpenSQL is only supported in the standard schema. Each additional schema has to use either Native_SQL or Vendor_SQL. That means you’ll loose a couple to many of the advantages mentioned before, because they are only supported in OpenSQL.
2. It may not always easy for a developer to get the necessary access to the server for setting up a new DataSource and as a developer being dependent from an administrator isn’t always desirable.

There are a couple of ways to create a new DataSource and most of them need an administrator account or direct access to the servers file system.

1. Probably best know procedure is to use our all favorite admin tool Visual Administrator, a rich client but you’ll need an admin account for that. (
2. Second best known is probably the web based version using NW Administrator but to get access to it you’ll face the same hurdles as with VA. (
3. For the ones who prefer to use a shell there is the MAKE_DATA_SOURCE from DBPOOL. Be sure to have file system access on the server here. (
4. There is a fourth way to deploy your new DataSource as a part of your application. The only thing you need here is the SDM password that you probably already have for your usual deployments. The official documentation is a little weak on that point. So let’s take a look at the necessary steps for this task.

DataSource Deployment

A DataSource definition used in a NW Java stack is described by a XML file that is based on a data-sources.dtd. You can generate a proper data-sources.xml file from this DTD definition. Another way is to create a new DataSource in Visual Admin under Services->JDBC Connector and export it as shown below.

That way you already have the necessary information filled into the right place. Just make sure to set for the password tag the attribute encrypted to false and provide the right password.

<password encrypted="false">mysecretpassword</password>

Next you have to store both files data-sources.dtd and data-sources.xml into the META-INF directory inside your Enterprise Application Project so that they will get deployed as part of your .ear archive.

That’s it and with your next deployment you’ll find your new created DataSource on your app server. Access to it is the same as for a DSA.

The Sad Part

One thing to keep in mind is that when you go with an alternative db schema you can’t use Open_SQL anymore because this is only supported for the standard schema as mentioned already above. You therefor have to switch to Native_SQL, which has to be configured in your DS definition like this.

<description>DB for Supplier Portal App</description>

Another option is to use Vendor_SQL but you should do this unless you have some good reasons and know exactly what you’re doing. You can find more about the differences in this SDN article.

Just a small step…

April 16, 2007

I’m not a big contributor to SDN, just occasionally checking the forums to see where I can help out or writing a small blog post when I run into something interesting that I like to share. Nevertheless I was glad to see this morning that I crossed the 1000 point mark.

That means a new SDN shirt (already curious what color it will have) and a nice motivating push to do more.

Problem with SDN Search

February 19, 2007

Just a small follow up on my post yesterday. After posting my latest blog on SDN Eddy pointed me to his blog post about Firebug. As I already told you I did a search on SDN but it didn’t and still doesn’t reveal any mentioning of Firebug. Houston (aehm, Craig?) we have a problem! Maybe I should have used Google in the first place because it would have given me at least a hint that Firebug isn’t unknown to the great community at SDN, even though it won’t give me the direct blog links. Craig is already aware about the issue so we know it is in good hands and will be fixed. Until then maybe a good idea to double check your results using Google or any of your favorite search engine, at least when you don’t get the results you may have expected.


I completely missed writing a note to SDN support about the problem. Should have done this first before writing this post. I’ll give you an update on the toppic.

Firebug on SDN

February 18, 2007

Recently I had to do a lot of Enterprise Portal development. Looking for a state of the art JavaScript debugger and I found Firebug that helped me so much getting the work done and JavaScript was only a small part of it. It’s well integrated into Firefox by showing only a small icon in the status bar but once you click that icon it gives code inspection, network monitoring, a great JavaScript debugger, etc. I was suprised to find out that Firebug wasn’t mentioned anywhere on SDN. Now it is.

And once you got knee deep into Firebug be sure to check out Joe Hewitts expert level introduction: Joe Hewitt: “Welcome to Firebug 1.0.