If you are developing a jsp that output a pdf with iText, you could bump into the error: Error 500: OutputStream already obtained.
In order to avoid this error, simply ensure to remove all spaces, and new lines from jsp tags, for example this brief code will generate the error
<%@ page import="..." %> <% ... %>
and this will work (beware I’ve removed the newline between jsp tags)
<%@ page import="..." %><% ... %>
Here is a sample working jsp.
It happens on job that creating/dropping tables on a database (even an instance for developing) could take a long time due to bureaucratic procedures: send email with required table to create, wait until approval, wait until creation. Populate the table do the test and if something is wrong send a mail for the table dropping and repeat the cycle.
In order to exit this hypnotic loop, I have a MySQL on my computer and I use it for every test. Then when I’m sure of the table structure send the email and wait.
But what when you have to create a table that you have to test in join with other tables? The main problem should be to get a script for creating the table and the data for populating on the MySQL.
Getting the create table script
In order to get the create table script from the DB2 I use the client I’m used to use for accessing database: eclipse + SQLExplorer. Select the table you want the create script to be created in the database structure window and with a right click use the create table script. This will open you a new SQL editor with the create table script for DB2. Now fix it in order to accomplish the MySQL syntax. Actually I had to remove the Db2 owner, the double quotes from the table name and replace the double single quotes with a single single quote (script adjustment). Now run the tuned script on the instance of MySQL (always from SQLExplorer).
Getting the data
Now it’s time to get the data from DB2 table in order to pass it to the MySQL. With a simple
select * from owner.table
ensuring to uncheck the limit rows option of SQLExplorer, you’ll get in the SQLResult window a table with all the data. Right click on a cell, and choose the export->csv. This will generate a text file with all the fields separated by a semicolon (;). Let’s fix the file in order to get it digestible to MySQL; from command line
$ sed 's/;/\t/g' exported.csv > exported.txt
This will replace all the semicolons to a tab character.
Import data into MySQL
Now with a mysql access via command line, with root user (or with enough privileges) use the following command
load data infile 'exported.txt' into table the_table_you_created;
That’s all folks.
It could happen when developing with Websphere Studio Application Development that you bang into the error operation timed out: connect. Generally this happens when you have an XML file with a remote dtd.
While when working with a pure eclipse it’s enough to go to project preferences and disable the validation for XML files, in WSAD it doesn’t seem to work.
There some way to solve this. The first is to get an internet connection. Maybe the problem is because you are behind a proxy. If so, in windows->preferences for the internet voice, set the proxy parameters.
Another solution is to change the XML file pointing to a local copy of the DTD file. However this solution, in my opinion is the worst. It’s not portable: when releasing the application you have to change the source or you force the production environment to a physical disk structure. If you have more than one user you force every user to have the same disk structure.
What I prefer to do is switching to the resource view, create a local simple project with the required DTDs inside of it (1), going to window->preferences->xml->xml catalog (2), select the new button and add a new catalog item, specifying with the browse button select the local file from the workspace as URI and as key the remote address in the source file (3)(4)(5).
