Re: Java and remote databases

On Sep 3, 2024, at 10:57 AM, DOUGLAS ENGLANDER via JAVA400-L <java400-l@xxxxxxxxxxxxxxxxxx> wrote:

com.ibm.db2.jdbc.app.DB2JDBCSyntaxErrorException: An undefined column name
was detected.

As Pete suggested, I would recommend making sure you are matching the case of the columns.

Also, the exception indicates that you aren’t using JT400 … I would recommend you use that jdbc driver unless there is a compelling reason not to.

david

—
IBM i on Power Systems: For when you can't afford to be out of business!

I'm riding a in the American Diabetes Association's Tour de Cure to raise money for diabetes research, education, advocacy, and awareness. You can make a tax deductible donation to my ride by visiting https://mideml.diabetessucks.net. My goal is $7000 but any amount is appreciated.

You can see where my donations come from by visiting my interactive donation map ... https://mideml.diabetessucks.net/map (it's a geeky thing).

I may have diabetes, but diabetes doesn't have me!