Eclipse Community Forums: EGL Development Tools » New Record From DB Generates Warning

Help

Home

Home » Archived » EGL Development Tools » New Record From DB Generates Warning

Show: Today's Messages :: Show Polls :: Message Navigator

New Record From DB Generates Warning [message #976770]

Thu, 08 November 2012 20:59

Gregory Testa

Messages: 28
Registered: April 2012

Junior Member

Anyone see this before?

I'm connecting to an MS SQL Database. I am creating a new record by right clicking on New --> Records --> then Create new record from database. When I select my table name and then click finish, the wizard generates a warning that states:
Cannot get valid message from column metadata
it seems to generate this for each column type of nvarchar. It also does not create those fields in the record.

Thanks,
Gregory

Report message to a moderator

Re: New Record From DB Generates Warning [message #983162 is a reply to message #976770]

Tue, 13 November 2012 18:33

Justin Spadea

Messages: 66
Registered: July 2009

Member

Hi Gregory,

This is just a guess, but it sounds like your JDBC driver doesn't support returning the metadata for columns of type nvarchar. Is there a newer JDBC driver you can try out to see if this is resolved? If we're unable to determine the type for a column then we have no idea to which EGL type it should be mapped. Maybe in this case the wizard could let you manually choose the EGL types for unknown columns. If you think this would be an adequate solution, go ahead and open an enhancement request at https://bugs.eclipse.org/bugs/enter_bug.cgi?product=EDT

-Justin

Report message to a moderator

Re: New Record From DB Generates Warning [message #983314 is a reply to message #983162]

Tue, 13 November 2012 21:11

Gregory Testa

Messages: 28
Registered: April 2012

Junior Member

Hi Justin --
I'm using the Microsoft JDBC Driver 4.0 for SQL Server that came out on 3/6/2012. Tables render properly when using the SQL Explorer plugin. It is in EDT only that this problem occurs. Any workarounds that you can think of?

Gregory

Report message to a moderator

Re: New Record From DB Generates Warning [message #984407 is a reply to message #983314]

Wed, 14 November 2012 17:19

Gregory Testa

Messages: 28
Registered: April 2012

Junior Member

fyi...
I added the missing fields to my record as string fields, then I used the CAST command in the select statement, e.g. CAST(id as varchar(80)). That allowed me to get past the error.

Report message to a moderator

Previous Topic:	EDT 0.8.2 Milestone 3 is here!
Next Topic:	How can I manage widget instances?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 20 18:11:30 GMT 2018

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter