On 26-10-2020 22:31, Humphries, Graham wrote:
Looks like you need to have your DBA set this to TRUE.
I don't know why Oracle don't have this set to TRUE by default
It's how Oracle make money.
-M
___
Geoserver-users mailing list
Please make sure
: [Geoserver-users] GeoServer and Oracle
I spoke to DBA and they have not made any changes to this parameter after
migration but i am sharing value of parameter .
NUM 5077
NAME spatial_vector_acceleration
TYPE1
VALUE
I spoke to DBA and they have not made any changes to this parameter after
migration but i am sharing value of parameter .
NUM 5077
NAMEspatial_vector_acceleration
TYPE 1
VALUE FALSE
Have the DBA's set the SPATIAL_ACCELERATOR option on the Oracle DB?
-Original Message-
From: pradeep2751 [mailto:pradeepkuma...@gmail.com]
Sent: Saturday, 24 October 2020 2:38 AM
To: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] GeoServer and Oracle
hi,
Facing
Really this question should be asked of Oracle, as you haven't changed your
geoserver setup (unless you haven't told us everything you did).
The codepath for those versions of Oracle in our codebase is identical.
Op vr 23 okt. 2020 16:06 schreef pradeep2751 :
> hi,
>
> We are migrating Oracle
hi,
Facing performance issue with loading spatial data and any update related to
spatial is taking more time then 12C database. As number of users increases
this even get worse, i have collected some stats which I am attaching with
post.
stats.JPG
Hello Pradeep,
What kind of performance issues are we talking about?
regards,
Imran
On Fri, Oct 23, 2020 at 7:06 PM pradeep2751
wrote:
> hi,
>
> We are migrating Oracle 12C database to 19C and facing performance issue.
> Anyone faced similar problem after migration ?
>
>
>
>
>
> --
> Sent
hi,
We are migrating Oracle 12C database to 19C and facing performance issue.
Anyone faced similar problem after migration ?
--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html
___
Geoserver-users mailing list
Please
As far as I know it is not an error but just information. So does not need
solving.
Russ
Sent from my iPad
> On 22 Jun 2020, at 21:01, Diego Mendes Rodrigues wrote:
>
>
> Friends,
>
> I have a server with GeoServer 2.17.1 installed from Debian 9.
>
> I use the Oracle 11.0.7 JDK.
> java
AM
To: Tom S ; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] GeoServer 2.17.1 - Oracle 11.0.7 JDK - Strong
cryptography available
I thought it means exactly what it says. To make it active there was some
configuration required
From: Tom S [mailto:tom-sourcefo
s exactly what it says. To make it active there was some
> configuration required
>
>
>
> *From:* Tom S [mailto:tom-sourcefo...@tomsaul.com]
> *Sent:* Tuesday, 23 June 2020 9:20 AM
> *To:* geoserver-users@lists.sourceforge.net
> *Subject:* Re: [Geoserver-users] GeoServer 2.17
I thought it means exactly what it says. To make it active there was some
configuration required
From: Tom S [mailto:tom-sourcefo...@tomsaul.com]
Sent: Tuesday, 23 June 2020 9:20 AM
To: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] GeoServer 2.17.1 - Oracle 11.0.7 JDK
“not available” then there are steps to add it, but that
doesn’t matter for your case.
Brad
*From:*Diego Mendes Rodrigues
*Sent:* Tuesday, 23 June 2020 5:58 AM
*To:* geoserver-users@lists.sourceforge.net
*Subject:* [Geoserver-users] GeoServer 2.17.1 - Oracle 11.0.7 JDK -
Strong cryptography available
et
Subject: [Geoserver-users] GeoServer 2.17.1 - Oracle 11.0.7 JDK - Strong
cryptography available
Friends,
I have a server with GeoServer 2.17.1 installed from Debian 9.
I use the Oracle 11.0.7 JDK.
java version "11.0.7" 2020-04-14 LTS
Java(TM) SE Runtime Environment 18.9
Friends,
I have a server with GeoServer 2.17.1 installed from Debian 9.
I use the Oracle 11.0.7 JDK.
java version "11.0.7" 2020-04-14 LTS
Java(TM) SE Runtime Environment 18.9 (build 11.0.7+8-LTS)
Java HotSpot(TM) 64-Bit Server VM 18.9 (build 11.0.7+8-LTS, mixed mode)
When I log in to the
Hi,
I don't know anyone that has tried version 19 yet, but you might do it and
report back?
I believe there are Oracle docker images to ease the setup
Cheers
Andrea
On Fri, Sep 20, 2019 at 1:14 PM Charlotte Toma (WhereGroup) <
charlotte.t...@wheregroup.com> wrote:
> Hello,
>
> i would like to
Hi,
I only have experience with Oracle 12.x or lower.
That say the best way, except having GeoServer run for a few months
using Oracle new versions, is to run GeoTools on line tests [1]
against one of those Oracle versions
Best regards,
Nuno Oliveira
[1]
Hello,
i would like to know which versions of oracle database are compatible
with geoserver.
I know, that you can connect oracle 11 and 12 with Geoserver in version
2.15.2. Now we want to switch to 18c / 19c and i would like to know if
it works.
Any informations regarding working versions can
Hi list,
has anyone any experience in using Oracles analytics functions
(https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions001.htm#SQLRF06174)
e.g. RATIO_TO_REPORT, like in this SQL:
select round(ratio_to_report(d.n) over ()*100,2) as p, d.n, d.kvadratid,
kn.geometri
from
Andrea,
If I understand the GeoServer/OGC TIME model, then it is actually quite
different to the temporal model in SQL:2011 (which is similar to what IBM
and Oracle provide).
In GeoServer, is the case that the TIME request parameter defines a time
instant or a time range, which is then used as a
On Mon, Nov 25, 2013 at 7:34 PM, Martin Davis mtncl...@gmail.com wrote:
Andrea,
If I understand the GeoServer/OGC TIME model, then it is actually quite
different to the temporal model in SQL:2011 (which is similar to what IBM
and Oracle provide).
In GeoServer, is the case that the TIME
Christian, you have things a bit easier with DB2, since it appears to
support only a single business time dimension [1]. This means that in the
query
SELECT * FROM mytable FOR BUSINESS_TIME AS OF
no information about temporal column names is needed, only the timestamps
of the filter.
In
On Mon, Nov 25, 2013 at 11:19 AM, Andrea Aime
andrea.a...@geo-solutions.itwrote:
On Mon, Nov 25, 2013 at 7:34 PM, Martin Davis mtncl...@gmail.com wrote:
Andrea,
If I understand the GeoServer/OGC TIME model, then it is actually quite
different to the temporal model in SQL:2011 (which is
Hi Martin
Sorry for the late reply. I am quite under pressure in these days and my
customer has a major milestone on 3rd of the December. For this milestone,
we use DB2 bitemporal geometries and are lucky to use constant date values
only. These data values are encoded in GeoServer sql views as
On Thu, Nov 21, 2013 at 9:31 AM, Christian Mueller
christian.muel...@os-solutions.at wrote:
I will investigate within the next weeks but I would feel unhappy to to
integrate the is feature only for DB2. (if this is possible). I think your
proposal number 2 is thew way to go.
I agree that
I will give you an example:
Given a normal select
select * from table mytable where
If this table has business time support it would be
select * from table mytable as of business_time of '2011-01-01' where
The syntax extension is in the from clause. The above query returns only
On Thu, Nov 21, 2013 at 10:31 AM, Christian Mueller
christian.muel...@os-solutions.at wrote:
I will give you an example:
Given a normal select
select * from table mytable where
If this table has business time support it would be
select * from table mytable as of business_time of
Ha, good news.
I will have deeper look at time activation, maybe I can find a solution
which requires some modifications in the SQL dialect only. The advantage is
that you need not to bother about date_from an date_to sql attributes,
only formulate the from clause with a date or a date range.
Christian, good to hear that other GeoServer users are interested in
SQL:2011-style temporal capability.
Oracle 12c also has a capability to set the valid (business) time at the
session level, via the ENABLE_AT_VALID_TIME procedure [1]. How do you set
the register for a connection? Via
We're looking at using GeoServer with data stored in Oracle 12c modelled
using its new valid time capability [1]. (Actually the data is modelled
using the Flashback Archive support for transaction time as well, making it
bitemporal. But the valid time dimension is of most interesting for
Hello, I have the same problem? Could you figure out a solution?
--
View this message in context:
http://osgeo-org.1560.n6.nabble.com/Geoserver-2-1-2-Oracle-Plugin-Error-tp3787501p4620420.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
Hi,
I am new to GeoServer and am trying to create a layer using the data I have
in oracle 10g database. I am able to connect to my database and see all my
tables. I am also able to create a view. But anywhere in the documentation, I
was unable to find what kind of view/table is required to
); geoserver-users@lists.sourceforge.net
Aihe: [Geoserver-users] GeoServer with oracle (not spatial)
Hi,
I am new to GeoServer and am trying to create a layer using the data I have
in oracle 10g database. I am able to connect to my database and see all my
tables. I am also able to create a view
Hi, I installed the last version of Geoserver, and I also installed the
Oracle Plugin for this version.
When I want to set a new data store the oracle plugin doesn't appear on the
list. So I don't know if I installed the plugin correctly. I installed the
plugin into WEB-INF/lib, is this ok? any
On Mon, Dec 12, 2011 at 12:11 PM, jyby joanmallo...@gmail.com wrote:
Hi, I installed the last version of Geoserver, and I also installed the
Oracle Plugin for this version.
How did you install it?
Did you pick an extension with the exact same version number as your
GeoServer?
When I want
Hi, I'm using GeoServer with Oracle and I can't require the KML of my Layer.
I'm using the SDO_GEOMETRY type in my Oracle table.
It's computing the bounding box limits, but can't rederize.
The GML is fine, but I'm needing the KML.
--
Att.
Davi Oliveira Serrano de Andrade
Laboratório de Sistemas
36 matches
Mail list logo