Hi Pavel,
Here is my query entity class
public class Person
{
// Indexed field. Will be visible to the SQL engine.
[QuerySqlField(IsIndexed = true)] public long Id;
//Queryable field. Will be visible to the SQL engine
[QuerySqlField] public string Name;
//Will NOT be visible to the SQL engine.
public int Age;
[QuerySqlField(IsIndexed = true, IsDescending = true)]
public float Salary;
}
And here is the code to create table using .NET Api.
var client = Ignition.Start(clientCfg);
Console.WriteLine("Total nodes: " + client.GetCluster().GetNodes().Count);
var cacheCfg = new CacheConfiguration
{
Name = "cacheName",
QueryEntities = new[]
{
new QueryEntity(typeof(int), typeof(Person))
}
};
var cache = client.CreateCache<int, Person>(cacheCfg);
Person val = new Person();
val.Name = "Satya";
val.Id = 5;
val.Age = 39;
val.Salary = 25000;
cache.Put(5, val);
Now we want to see this table to be shown up automatically in
Intellij using JDBC driver(ignite-core-2.14.0.jar).
[cid:image003.jpg@01D971DB.0C261860]
Regards
Satyajit
From: Pavel Tupitsyn <ptupit...@apache.org>
Sent: Tuesday, April 18, 2023 9:40 AM
To: user@ignite.apache.org; Mandal, Satyajit: IT (PUN)
<satyajit.man...@barclays.com>
Subject: Re: SQL objects in Ignite ( .NET) not showing up with JDBC drivers
CAUTION: This email originated from outside our organisation -
ptupit...@apache.org<mailto:ptupit...@apache.org> Do not click on links, open
attachments, or respond unless you recognize the sender and can validate the
content is safe.
Hi Satyajit,
How do you create tables in .NET? Are you sure QueryEntities are configured
correctly? Can you share the code please?
Normally tables should show up in JDBC.
On Mon, Apr 17, 2023 at 3:27 PM
satyajit.mandal.barclays.com<https://clicktime.symantec.com/15siFABQmz4yreNgp3kzV?h=LWuZz2wR-l0xerqVBEyXEUuUAVfNfwuN0R01xD0-M0A=&u=http://satyajit.mandal.barclays.com>
via user <user@ignite.apache.org<mailto:user@ignite.apache.org>> wrote:
Hi Pavel,
When we create SQL objects ( Tables) using .NET Ignite Api they don’t
show up in IntellijIdea with Ignite JDBC drivers. We want to see the
tables so that we can query the cache using normal Select statements
using JDBC driver.
Is there any alternative for same to view the tables in cache when
created using .NET Api?
Thanks
Satyajit
Barclays Execution Services Limited registered in England. Registered No.
1767980. Registered office: 1 Churchill Place, London, E14 5HP
Barclays Execution Services Limited provides support and administrative
services across Barclays group. Barclays Execution Services Limited is an
appointed representative of Barclays Bank UK plc, Barclays Bank plc and
Clydesdale Financial Services Limited. Barclays Bank UK plc and Barclays Bank
plc are authorised by the Prudential Regulation Authority and regulated by the
Financial Conduct Authority and the Prudential Regulation Authority. Clydesdale
Financial Services Limited is authorised and regulated by the Financial Conduct
Authority.
This email and any attachments are confidential and intended solely for the
addressee and may also be privileged or exempt from disclosure under applicable
law. If you are not the addressee, or have received this email in error, please
notify the sender and immediately delete it and any attachments from your
system. Do not copy, use, disclose or otherwise act on any part of this email
or its attachments.
Internet communications are not guaranteed to be secure or virus-free. The
Barclays group does not accept responsibility for any loss arising from
unauthorised access to, or interference with, any internet communications by
any third party, or from the transmission of any viruses. Replies to this email
may be monitored by the Barclays group for operational or business reasons.
Any opinion or other information in this email or its attachments that does not
relate to the business of the Barclays group is personal to the sender and is
not given or endorsed by the Barclays group.
Unless specifically indicated, this e-mail is not an offer to buy or sell or a
solicitation to buy or sell any securities, investment products or other
financial product or service, an official confirmation of any transaction, or
an official statement of Barclays.
Barclays Execution Services Limited registered in England. Registered No.
1767980. Registered office: 1 Churchill Place, London, E14 5HP
Barclays Execution Services Limited provides support and administrative
services across Barclays group. Barclays Execution Services Limited is an
appointed representative of Barclays Bank UK plc, Barclays Bank plc and
Clydesdale Financial Services Limited. Barclays Bank UK plc and Barclays Bank
plc are authorised by the Prudential Regulation Authority and regulated by the
Financial Conduct Authority and the Prudential Regulation Authority. Clydesdale
Financial Services Limited is authorised and regulated by the Financial Conduct
Authority.
This email and any attachments are confidential and intended solely for the
addressee and may also be privileged or exempt from disclosure under applicable
law. If you are not the addressee, or have received this email in error, please
notify the sender and immediately delete it and any attachments from your
system. Do not copy, use, disclose or otherwise act on any part of this email
or its attachments.
Internet communications are not guaranteed to be secure or virus-free. The
Barclays group does not accept responsibility for any loss arising from
unauthorised access to, or interference with, any internet communications by
any third party, or from the transmission of any viruses. Replies to this email
may be monitored by the Barclays group for operational or business reasons.
Any opinion or other information in this email or its attachments that does not
relate to the business of the Barclays group is personal to the sender and is
not given or endorsed by the Barclays group.
Unless specifically indicated, this e-mail is not an offer to buy or sell or a
solicitation to buy or sell any securities, investment products or other
financial product or service, an official confirmation of any transaction, or
an official statement of Barclays.
