Saxon

Legacy ID: #4619794 Legacy Poster: sascha mantscheff (smantscheff)

I'm trying to use the saxon sql extension with the jdbc/mysql adapter. I can establish a connection to my database server with a test program. This contains the statements: Class.forName("com.mysql.jdbc.Driver"); Connection con = DriverManager.getConnection("jdbc:mysql://mysite/mydb", "user", "password"); (with all the literal strings replaced by real connection parameter strings). This connection opens and I can retrieve data from the database. Now I tried to run a simple XSL which connects with the same parameters to the database. This fails with a JDBC connection failure. I extracted saxon9-sql.jar and inserted some debug output in SQLConnect.java. This shows that SQLConnect.java gets the correct parameters from the XSL sheet. The connection statement in SQLConnect.java reads try { Class.forName(dbDriverString); connection = DriverManager.getConnection(dbString, userString, pwdString); } catch (Exception ex) { System.out.println( "dbDriverString: " + dbDriverString + "\ndbString: " + dbString + "\nuserString " + userString + "\npwdString: " + pwdString); dynamicError("JDBC Connection Failure: " + ex.getMessage(), SaxonErrorCode.SXSQ0003, context); } This code always leads to an exception at the statement connection=... But the output shows the same connection parameters as the working code. I'm stuck. Any ideas are welcome.