InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comThu, 04 Dec 2008 03:19:16 GMT20http://www.teradata.com/teradataforum/Topic8000-11-1.aspxIn case it wasn't clear, this RFC was just created and has not yet been scheduled for a particular Teradata JDBC Driver release.Thu, 31 Jan 2008 11:50:17 GMTTomNolanhttp://www.teradata.com/teradataforum/Topic8000-11-1.aspxThis issue corresponds to JDBC RFC DR 119654 -- support default Properties with DriverManager.getConnection(url, Properties)Wed, 30 Jan 2008 13:33:43 GMTTomNolanhttp://www.teradata.com/teradataforum/Topic8000-11-1.aspxThe driver's implementation of the method "Connection connect(String url, java.util.Properties info)"<br>does not read correctly the properties stored in the "info" input parameter.<br><br>The driver ignores the "user" and the "password" properties (and probably the other properties too)<br>if these properties are "default"/parent properties.<br><br><br>The following code fails to initialize the JDBC connection :<br><br> Class.forName("com.ncr.teradata.TeraDriver");<br> Properties parentProps = new Properties();<br> parentProps.setProperty("user","myUser");<br> parentProps.setProperty("password","myPassword");<br> Properties props = new Properties(parentProps);<br> //the connection establishment fails because the driver fails to find the user and the password:<br> Connection con = DriverManager.getConnection(dbUrl,props); <br><br>If parentProps are directly used, the connection creation succeeds !!!<br><br>This means that Teradata is not able to handle correctly the java.util.Properties objects !<br>Somewhere inside the driver, Hashtable methods are directly used (like get() or containsKey() ) and<br>parent/default properties are ignored !!<br>For getting a property or checking if it exists you should use only "getProperty()" !<br> Fragment from the java.util.Properties#getProperty(String key) javadoc:<br> * If the key is not found in this property list, the default property list,<br> * and its defaults, recursively, are then checked. The method returns<br> * <code>null</code> if the property is not found.<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>Wed, 27 Jun 2007 05:59:24 GMTlogofatu