Re: SQuirreL and WWW.PUB1.DE

I suspect that the release may not be significant. I'm using the latest SQuirreL, Java and JT400 against your PUB1.DE V5R3 machine and the little Java program fails, as expected. Ideally I'd like it run against a V5R3 machine with fewer than 32,768 libraries. If it works, I think I have enough evidence to report it as a problem on ibm.com/developerworks.

Sam

Probably most machine have fewer than 32,768 machine--I suspect your PUB1.DE might be unique. But I do appreciate the free access to it.

package pack;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class AS400Test {
public static void main(String[] args) throws ClassNotFoundException, SQLException
{
Class.forName("com.ibm.as400.access.AS400JDBCDriver");
Connection connection =
DriverManager.getConnection("jdbc:as400;namimg=sql");
connection.getMetaData().getSchemas();

// Will break with:
// Exception in thread "main" java.sql.SQLException: [MCH1210] Receiver value too small to hold result.
// at com.ibm.as400.access.JDError.throwSQLException(JDError.java:710)
// at com.ibm.as400.access.JDUtilities.getLibraries(JDUtilities.java:209)
// at com.ibm.as400.access.AS400JDBCDatabaseMetaData.getSchemas(AS400JDBCDatabaseMetaData.java:3963)
// at pack.AS400Test.main(AS400Test.java:18)
}
}




On 12/3/2014 3:59 PM, Holger Scherer wrote:

We have more than 100 machines - which release do you want to test on? :)

-h

Am 03.12.2014 um 22:49 schrieb Sam_L <lennon_s_j@xxxxxxxxxxx>:

Holger,

I can connect and use SQuirreL, but I can't get it to list the schemas. Having the schemas make building SQL easier using autocomplete.
The SQuirreL developer gave me a short java program that (probably) shows where the problem occurs. I'll have to see if I can get someone to run it against their machine which has less than 32,768 libraries.

---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com