Search WebSpherePower's 6,973 WebSphere, Java, and Eclipse article archive 
Home
EasyPrint
News details Click here for the RSS feed's XML code. This is not a browser URL.
Articles-only Click here for the RSS feed's XML code. This is not a browser URL.
Twitter Feed Click here for the Twitter feed.
Further Adventures with Roller Weblogger (continued)

Fun with UTF-8
Take a quick peek at Figure F.

FIGURE F


Well, not complete success, but hey . . . it didn't crash! Roll over picture for a larger image.

You can see that while the screen did come up, it really doesn't look too good at this point. Scrolling down through the page, I could see that the entire page was just filled with UTF-8 (Universal Transformation Format-8) line-feeds and carriage returns. As Roseanne Rosannadanna's Nanna used to say, "It's always something!"

My first thought was the realization that the WebSphere Application Server doesn't come up out of the box with UTF-8 support enabled. I rarely have occasion to use UTF-8, so I had to look up the hoops that you have to jump through to turn that on.

I'd step through all of that here if it weren't for the fact that it had absolutely nothing to do with the problem. So we'll just forge ahead and pretend that I never really wasted all of that time and energy.

My next thought was that I didn't really know the status of MySQL's default UTF-8 support, so I did the research on that. It turned out to be another pointless waste of time, since that wasn't the heart of the problem either.

The heart of the problem, which I eventually stumbled upon through no fault of my own, was that I had simply loaded the database with that data. By this time, no amount of translation or support by any product would have made any difference.

I had just cut and pasted the insert statements from the demo database load file, which was designed for HSQLDB, and executed it under MySQL. MySQL interpreted all of the \u000a and \u000d text as simply text, and put that text into the database tables.

To correct this problem, I just brought the load script up in a text editor and performed the following "find and replace" actions:

\\\u000du000a to \n
\u000a to \n
\u000d to \n
admin to jchilton

That last item I threw in there because I realized that since I was using an external LDAP (Lightweight Directory Access Protocol) directory for authentication, and not the Roller user database, there wasn't going to be any way to work with either of the pre-defined Weblogs because there was neither an admin, nor a testuser1, on the existing LDAP directory.

Once I completed the changes, I rebuilt the database from the new load script and went back to Studio to try it once again.

3, 2, 1 . . . again
Once more, I right-clicked on the Web project to bring up the context menu and selected Run on Server. When the main Roller page came up, I clicked on the link to the Weblog formerly known as admin (now renamed to jchilton) and found myself looking at Figure G.

FIGURE G


Now, that looks much better. Roll over picture for a larger image.

Not too bad!

I clicked around a little bit and everything seemed to be working as it should. Then I went out to the other Weblog that comes bundled with the demo and did the same.


« Previous  ·  1  ·  2  ·  3  ·  4  ·  Next »
Other articles you might like
Home > Projects > Roller Weblogger (3 articles)
   Even more adventures with Roller Weblogger
   Adventures with Roller Weblogger
Get Weekly Email Updates
Subscribe to our regular weekly email newsletter. It's packed with tips, reviews, deep analysis, and the latest news.
 
Recent WebSpherePower Articles
A perfect 10: celebrating 10 years online
You can help bring security and safety back to White House email
Introducing the WebSpherePower RSS feeds
From New Jersey to Palm Bay, Florida
A WebSphere pot o' gold
How Elvis entered the building and CES went out the window
WebSphere Application Server 6: what's it all mean?
WebSpherePower News
Legal question: Can HP keep Hurd from going to Oracle?
Caringo announces integration with Symantec EV 9.0
Cisco & Citrix marry on virty PCs
Take Heed, Tech Giants: Edison's Failed Plot To Hijack Hollywood
IBM code unchains virtual workloads
Oracle names H-P ex-CEO Mark Hurd as co-president
Cloud Messaging Provider, Linxter, Releases SDK for Java and Android
>> Read all the news
More from the ZATZ journals
Computing Unplugged: Introducing the Jones family and their full-family backup challenges
David Gewirtz Online: CNN commentary and analysis
DominoPower: Lotus must open source Notes and Domino
OutlookPower: Hands on debugging a broken Outlook forwarding rule
-- Advertisement --

How To Save Jobs
This book is about how to create and save jobs. Believe it or not, there's not a single book out there that specifically focuses on job creation and preservation -- until now.

This book, by ZATZ editor-in-chief David Gewirtz, is about helping your business work better. It's about helping you change the things you need to change so your company can perform more effectively.

Plus, through a grant from ZATZ, it's a free download.

Read it and reap.

ZATZ Home  ·  News  ·  Back Issues  ·  Credits/Trademarks ·  Link To Us
Copyright © 2010, ZATZ Publishing. All rights reserved worldwide.
Editor's Login