The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Creating an ADO.net VerticaParameter throws an exception when the data type is set

Creating an ADO.net VerticaParameter throws an exception. You can recreate it with this code: var param = new VerticaParameter(); param.DbType = DbType.Int32; //exception on this line or this code var param = new VerticaParameter("id", 1); And this is the stack trace: System.NullReferenceException: Object reference not set to an instance of an object at Vertica.Data.Internal.ADO.Net.SParameter.SetupNewTypeMetadata (Int32 newProviderType, Boolean isSigned, Boolean throwOnFailure) [0x00000] in :0 at Vertica.Data.Internal.ADO.Net.SParameter.set_DbType (DbType value) [0x00000] in :0

Comments

  • Hi Riaz, sorry for your troubles! Thank you for sharing your code, we will look into the cause of this error.
  • You should not set directly the System.data.DbTYpe, use the 3 parameters ctor instead that lets you chose a VerticaType. To get the right one, you could call the GetVerticaType method on your DbType enum (in this case VerticaType.BigInt.).
  • Thanks for the response but it throws the same error: var param = new VerticaParameter("id", VerticaType.BigInt, 1); System.NullReferenceException: Object reference not set to an instance of an object at Vertica.Data.Internal.ADO.Net.SParameter.SetupNewTypeMetadata (Int32 newProviderType, Boolean isSigned, Boolean throwOnFailure) [0x00000] in :0 at Vertica.Data.Internal.ADO.Net.SParameter.set_DbType (DbType value) [0x00000] in :0 at Vertica.Data.VerticaClient.VerticaParameter.set_Type (VerticaType value) [0x00000] in :0 at Vertica.Data.VerticaClient.VerticaParameter..ctor (System.String name, VerticaType type, System.Object value) [0x00000] in :0 at (wrapper remoting-invoke-with-check) Vertica.Data.VerticaClient.VerticaParameter:.ctor (string,Vertica.Data.VerticaClient.VerticaType,object)
  • Thanks for the reply but using that method resulted in the same exception.
  • Hmm you could try ILSpy on the assembly to find out what's happening, or wait for the dev team to answer... :D BTW I've got problems with this provider too.
  • Hi Danielle, any word on solving this one? Thanks!
  • I have this error too -- Come on Vertica - please respond
  • I cannot find any solution to fix the same problem. Anybody have any idea..?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.