I recently began using Project Web Access in order to attempt some high level project planning and resource management. For those who do not know what this is, it is a web access module that extends Microsoft Sharepoint and allows for access to Microsoft Project files via the web. You create the project files with the desktop client and publish them to the sharepoint site for Project.

As I saved the project, the progress bar showed saved, but 0% complete. It never moved off 0% complete, and when I closed MS Project and re-opened it, I was not allowed to open the saved project file. It would not list on the server, and it was not published.

After some looking around, I found it in Server Settings -> Manage Queue , and I saw that the jobs were hung. I didn’t want to lose my work, and so I didn’t know what to do. I was able to restore it by restarting the Jobs Queue with the following commands from the command-line on the server:

net stop ProjectQueueService

net start ProjectQueueService

This restarted the queue and my jobs started up again and completed. I didn’t lose any work.. Yeah!!

Sometimes when you try to start JBoss you might see a port conflict. Many times this is caused by MSN Messenger or other applications that randomly use the same ports that JBoss attempts to bind and use.

An example of this is when JBoss attempts to bind port 1098 you might see:

java.rmi.server.ExportException: Port already in use: 1098; nested exception is:
java.net.BindException: Address already in use: JVM_Bind

If you are not sure which application is causing this conflict you can do the following:
1. From a command-line type

netstat -a -n -o

This will give you the Process ID for the application that is causing the conflict. You will need to scan through the output to find the line that shows the port in question, in the case above it was port 1098.

You then can go into the Task Manager to find the process. If you are not already showing the PID as a column on your Processes tab, then you can go to View->Select Columns and then check PID (Process Identifier) to add the column. You should be able to locate the same PID and shutdown that process to start JBoss.

If you would like to dump the contents of a mysql table into a csv file here is the syntax:


mysqldump --tab=<directory_for_dump> --fields-enclosed-by='"' --fields-terminated-by=',' <database_name> <table_name>


obviously,replacing anything inside the with what it describes.

Window -> Preferences…, Java -> Compiler -> Building. Under “Output folder” add “, .svn/” to “Filtered Resources” (so that you get “*.launch, .svn/”).

If you don’t do this, Eclipse will copy all the .svn directories to the target directory and complain about duplicate resources as the contents of src/main/java and src/main/resources end up at the same place in the target directory.

This was written for Oracle 9i use. Oracle 10g has more/better options available.

To allow for diacritic-insensitive searching using Oracle 9i you can create an index with Oracle Text. This gives you many other options as well. There are a few different index types, but this will just show the one. Here is the syntax:

CREATE INDEX [owner.index_name / for example MAS.LEADERNAME_CTX_IDX] ON [table_name]
([column_name])
INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS(’LEXER english_lexer’);

If you are using eclipse with a maven project and you have errors showing up that are not truly errors, then it is because eclipse is reading your maven.xml file as an ant file.

Eclipse will indentify this file as an ant file due to the .xml extension and the project tag as the root element. You will need to either tell the Ant Editor to ignore errors in the maven.xml files OR associate the maven.xml file with the XML editor instead of the Ant Editor. At the time of this post, there wasn’t an eclipse content type for Maven files (or at last I could not easily find one.)

Here are the options:

Use Ant editor to edit maven.xml files, but turn off the error reporting

1. In eclipse, click on Window -> Preferences -> Ant -> Editor
2. Click on the Problems tab
3. In the first edit box, you can list files that the error reporter will ignore, add maven.xml to this box

Associate the maven.xml file name to the XML content type

1. In eclipse, click on Window -> Preferences -> General -> Content Type
2. You can know look at your content types and associated extensions, *.xml is listed under ant. You can either change this to be more specific and add the maven.xml to another XML type OR try out your own combinations inside there.