[WEB400] sqlj puking in tomcat

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

anyone experience anything like the following?? joe?? <VBG>

This is not my first sqlj program and others under the same model in tomcat
and apache work just fine.

First, I can compile this using UDB 7.1 on windows or on the iSeries at v5r1
and I get the same results either way. Cume packages and groups are pretty
current. All the fields in the statement are actually in the database
record. I can cut and paste the select statement into an interactive SQL
session on the iSeries and substitute 13 in the key and poof, it works!

But when tomcat runs the servlet and creates this object, I get the
following:

....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+.
...8....+....9....+....0....+....1....+....2....+....3.
PrDBObject.hasIdentity()
 reading record...
PrDBObject.retrieve()
declare cursor:read data:
SQL STATE ON FAILURE: 42703 SQLCODE: -99999
java.sql.SQLException: An undefined column name was detected.
      java/lang/Throwable.<init>(Ljava/lang/String;)V+4 (Throwable.java:90)
      java/sql/SQLException.<init>(Ljava/lang/String;Ljava/lang/String;I)V+1

blah, blah, blah....

So then I delete the package and do a db2profc on the ser and move the
objects, restart the servers and what do I get for my troubles?????

PrDBObject.hasIdentity()
 reading record...
PrDBObject.retrieve()
declare cursor:read data:
SQL STATE ON FAILURE: 42601 SQLCODE: -104
java.sql.SQLException: [SQL0104] Token * was not valid. Valid tokens: ( END
SET CALL DROP FREE LOCK OPEN WITH ALTER BEGIN CLOSE FETC
      java/lang/Throwable.<init>(Ljava/lang/String;)V+4 (Throwable.java:90)
      java/sql/SQLException.<init>(Ljava/lang/String;Ljava/lang/String;I)V+1
(SQLException.java:39)

com/ibm/as400/access/JDError.throwSQLException(Lcom/ibm/as400/access/AS400JD
BCConnection;III)V+0 (JDError.java:388)
      com/ibm/as400/access/AS400JDBCStatement.commonPrepare

again, blah, blah, blah.....

But there is no * in the statement!!!
WTF? over.

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - iSeries Administrator
 -- IBM Certified Specialist - RPG IV Developer

"If you pick up a starving dog and make him prosperous,
  he will not bite you. This is the principal difference
  between a dog and a man."

    - Mark Twain