The table goes into the "cacheName" schema - you have to load and expand other schemas in IntelliJ to see it:
[image: image.png] On Tue, Apr 18, 2023 at 7:19 AM <[email protected]> wrote: > 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). > > > > > > > > Regards > > Satyajit > > > > *From:* Pavel Tupitsyn <[email protected]> > *Sent:* Tuesday, April 18, 2023 9:40 AM > *To:* [email protected]; Mandal, Satyajit: IT (PUN) < > [email protected]> > *Subject:* Re: SQL objects in Ignite ( .NET) not showing up with JDBC > drivers > > > > CAUTION: This email originated from outside our organisation - > [email protected] 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 <[email protected]> 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. >
