DOS BAT File Copy Rename with String Manipulation

I needed to rename a directory of files to truncate the file names to the first 5 characters (plus the file extension).  I found one example that showed how two write a FOR loop that broke out the filename and extension and passed it to a second BAT file:

for /f %%a IN (’dir /b *.txt’) do call runner.bat %%~na %%~xa

And using a second example that covered DOS string manipulation, I put together this batch file that accepts two parameters and does a substring to get the first 5 characters of the first parameter:

set file=%1
set file=%file:~0,5%
ren %1%2 %file%%2

 

Creating an Asynchronous ASP.NET Page To Initiate Batch Processes

I recently created a page that gave the user the option of initiating a long-running batch process.  The batch required repeatedly calling external web services that would have taken far too long for a user to wait for the traditional page processing model.  But, by using ASP.NET asynchronous execution to initiate the batch process on a separate thread, the page response is excellent.  I started by working through this excellent tutorial on asynchronous execution, but quickly ran into problems when I began calling web services.  Creating an asynchronous process involves writing a method that can execute without needing anything from the HttpContext (Application, Page, Session, Cache, Configuration, etc.) since this is not available when you use BeginInvoke to run your subroutine.  This presented me with an issue since my project had a library that we used to setup web service instances (with WSE security), but that library relied on the HttpContext’s Application object.  To work around this limitation, I created a private inner class that encapsulated the web service references. 

    Private Class WebSvcInstances

        Public FSI As MyWseSVc1 = GetMyWseSVc1

        Public PSI As MyWseSVc2 = GetMyWseSVc2

    End Class

The inner class was passed into the batch method while the Application object was still available and providing the objects the batch would need later.

To start off, create the subroutine you want to initiate asynchronously:

    Private Sub InitiateBatch(ByVal wsRefs As WebSvcInstances)

Create a Delegate in your code behind with the same signature as the subroutine:

    Private Delegate Sub Batch_Delegate(ByVal wsRefs As WebSvcInstances)

Then you can initiate your subroutine in a page event like so:

    Dim batchDelegate As InitiateBatch_Delegate

    Dim wsRefs As New WebSvcInstances

    batchDelegate = New InitiateBatch_Delegate(AddressOf InitiateBatch)

    Dim asyncResult As IAsyncResult

    asyncResult = batchDelegate.BeginInvoke(wsRefs, Nothing, Nothing)

You can read up on BeginInvoke to learn more about the callback features.  I didn’t need to be notified when the execution finished, so I just set those to Nothing

Before and AFTER

It hasn't taken quite as long as the lack of blog posts would have you believe, but the refurbishment of Flying Scot 338 is nearly complete. In addition to the fairing and painting, I've just finished replacing the gooseneck and standing rigging, installing a boom whoopie, turtle bags and guy hooks. I hope to get the transom port, bow bag, and stem band on before the Boathouse Regatta this weekend. I am SO glad I have a Flying Scot since the class builder has been SUPER helpful including instructions with all of the replacement parts.

Painting recap:

After talking to another club member who did the same paint job (but rolled everything) I should have been more aggressive with sanding the primer. I was concerned about sanding too much off and not hiding the yellow gel coat so I wet sanded with 220. My friend said he used 80-100 on the primer which I now wish I had done (with a long board)...but time was limited. I didn't think I'd have a chance to put a 2nd primer coat on.
I am very impressed with the shine and durability of Interlux Brightsides so far. I don't think I've scratched any paint off, though it's only been a couple months of light use.
During the refurb, I decided to tackle the bottom as well, painting it with VC Performance (a 2-part epoxy) and given that experience, I think I would be more willing to attempt a 2-part poly for the topsides next time. A warning about VC Performance though: it is extremely thin (runny), being designed to spray on. They say it is possible to brush/roll it on, but it would seem far easier to spray given my limited experience. My "spray rig" consisted of a $99 compressor and $15 gravity fed gun, both from Harbor Freight.

Centerboard:

As earlier pictures showed, my centerboard was in terrible shape. The leading edge was so badly damaged, there was actually a large accumulation of clay between the lead balast and the outer fiberglass causing a bulging in the airfoil shape. I ended up cutting out a curved section of fiberglass from the leading edge (both sides) and repairing it with about 4-5 layers of 1.5oz mat. I faired the repair and other leading edge defects with Interlux Watertite and finished with two coast of VC Performance (after removing LOTS of bottom paint) the board looks almost new.

Removing boat bottom paint

I read somewhere that the best tool for removing bottom paint is your checkbook. After my experience, I would have to agree, but it can be done. Apparently the pros sandblast the stuff off. Not being a pro, I turned to Google and read about several different methods for DIY: scraping, stripping, and sanding being the top three. In the end, I believe the most efficient way is to scrape AND sand.

Important tip: have a file in your pocket and keep the scraper sharp. The copper bottom paint dulls the scraper quickly. To sharpen, you have to lay the file down and hold the scraper perpendicular to the file. Just a few strokes makes a huge difference.

Flying Scot #338 had several layers of bottom paint so scraping removed a bunch of material, but did not remove the last layer of paint. The picture above shows the results of scraping on the right and after sanding on the left. I sanded using a 1-2 punch of a 6" sander with 50 grit lightly and carefully run over the paint to remove 95% and then a 5" orbital sander with 80 grit to get the last bit off and smooth out the agressive grit. This process took about 1 hour for the first side, second side TBD...

Fairing and repainting a Flying Scot

I will be blogging regularly about this year’s refurbishment of Flying Scot 338. Last weekend I removed all of the hardware including rub rails. This weekend I removed the centerboard (with the help of the club hoist). Launched the 338 onto dry land – a very unnaturally feeling. And, with the help of 3 club members, flipped the hull onto low sawhorses. Next up, cutting the bad balsa out of the aft deck and removing the bottom paint. I feel itchy already.

Take a look at that centerboard. I got a chance to give it a close inspection while we were…uh…sideways a few weeks ago. I think I see why light air has never been kind to us!

Configuring Oracle XE connection pool in Glassfish and Using JPA

I followed these instructions for creating an Oracle JDBC datasource. I needed to download the Oracle JDBC driver (ojdbc14.jar) into my <Glassfish>/lib directory and restart the server. After that the “Ping” was successful.

In “step 2” I had to specify 4 properties: user, password, url, and xa-driver-does-not-support-non-tx-operations.

Next I needed to create a JDBC resource that my persistence.xml file would reference.

With those tasks complete, I modified an existing EJB 3 JPA project to utilize the new connection pool. All that was necessary was to change two lines in the persistence.xml file. First was to point to the new JNDI name:

<jta-data-source>jdbc/AMRPool</jta-data-source>

And second was to change the “toplink.platform.class.name” (now deprecated) to:

<property name="toplink.target-database" value="Oracle"/>

After redeploying the JAR the CUSTOMER table was added to my schema. I re-ran the test client and was delighted to find a record in the table. Bravo to the Java community!

Excellent EJB 3 Persistence Tutorial

It had been a long time since I have visited the land of Java. When I was a regular traveler there, I remember feeling inundated by the rapidly progressing proliferation of APIs. JMS, JNDI, RMI, CMP, and on…and on…and ON. The technologies and vendors were spawning and/or evolving so fast and from so many directions it was difficult to stay current. From what I can see the frameworks have matured and are stabilizing. While there are still many innovations occuring, the rate of change does not appear to be the dizzying pace that I remembered.

To get up-to-speed on the current J2EE release, I dutifully installed the latest version of the open source Java EE 5 implementation…something called GlassFish. It has a decidedly un-Microsoft feel about it. I had flashbacks of all the previous Weblogic/Tomcat/Apache configuration nightmares and had to steel myself for navigation through the narrow passages in the reefs surrounding a modern Java app server. I have found…in general…that Java technologies are much less tolerant of the neophyte and the learning curve seems significantly steeper than the reciprocal Microsoft technology (“platform agnostic”…I know…I know).

I also downloaded the Java EE tutorial and attempted to follow it using Eclipse instead of the recommend NetBeans because I had previously used Eclipse and thought it was generally a great IDE. In doing so, I ran into trouble with creating the EJB example that was entirely related to my inexperience…and the 50 different project types Eclipse now ships with out of the box. I left the Sun script and started working through simple JSP examples just to get some tiny amount of momentum built. After following the online documentation, success was not far behind.

Then I ran across the EJB 3 persistence topic and decided that looked interesting, particularly hibernate.org. The top tutorial on the matter…as declared by Google, was from Web Age Solutions. It was short enough that it didn’t scare me off so I dove in with low expectations of a working example. I was pleasantly surprised by the author’s accuracy and brevity. The logical and successful progression was refreshing and rewarding. By the end of the tutorial, I had a basic understanding of the Java Persistence API (JPA) and a new level of respect for the current Java specification. Bravo!

http://www.webagesolutions.com/knowledgebase/javakb/jkb006/index.html