Bug #30863 setDefault

• Submitted: 6 Sep 2007 13:47
• Modified: 5 Nov 2022 1:45
• Reporter: Marc Mirandews
• Status: Won't fix
• Category: Connector / J
• Severity: S4 (Feature request)
• Version: Mysql 5.1.21
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any

[6 Sep 2007 13:47] Marc Mirandews

Description:
We would enjoy very much the feature of setDefault 

con.preparestatement("insert into table values (?,?,?)");
preparedstatement.setDefault(1);
preparedstatement.setDefault(2); 
preparedstatement.setDefault(3); 
(throw an exception if it does not exist a default clause in schema definition)

or at least (much more inefficient)

preparedstatement.setObject with a new type java.sql.Types.DEFAULT

Thanks for all your great work, 

Marc

How to repeat:
not a bug

Suggested fix:
not a bug

[1 Sep 2009 12:29] Tonci Grgin

It is my opinion that introducing such function will bring little gain. Also, the effort to introduce would be great.

Anyway, feature is missing, so verified as described.

Mark?

[5 Nov 2022 1:45] Filipe Silva

Feature not part of the JDBC specification.