Hi guys I have completed the Web API program for now and working on a PI JDBC software, I have written code based around GetSnap which is working, however I wanted to show some examples of common queries to show some better examples, I have the Nugreen database installed and can successfully query data from there using the PI Web API software I created, however with PI JDBC using the following code I get the following error and cannot work out why as Nugreen database exists and is callable via Web API.
SELECT Name, Description FROM NuGreen.Asset.Element WHERE Description LIKE ? (Using param N'Boiler%')
[PIOLEDB] Catalog name 'NuGreen' is invalid. at com.osisoft.jdbc.StatementImpl.executeQueryInternal(StatementImpl.java:429) at com.osisoft.jdbc.StatementImpl.executeQuery(StatementImpl.java:408)
In PI Web API, our path to anything Nugreen related was \\Nugreen\\Nugreen which is different to any of the documentation which specified to use \\Nugreen, I was wondering if there was a similar issue here, I have tried Nugreen.Nugreen with no luck. TIA.