Re: [Geoserver-users] Oracle connections

[Jonathan Moules]

Thanks Jukka, interesting to know. I'm assuming there's some reason for
three different types of connections for Oracle though?




On 14 December 2012 16:02, Rahkonen Jukka  wrote:

>  Hi,
>
> ** **
>
> We have found no reason for using OCI driver so we use JNDI in production
> and JNDI and NG in development.
>
> ** **
>
> -Jukka Rahkonen-
>
> ** **
>
> Jonathan Moules wrote:
>
> ** **
>
> Hi Paulo,
>
> Thanks for that. I do have the relevant files already installed, but don't
> have an ORACLE_HOME set because other software breaks if I set it (I have
> both 32bit and 64 oracle installs, so if I set Oracle Home to one, then
> software for the other breaks).
>
> ** **
>
> Do you know if the OCI driver offers a performance advantage over the
> plain Oracle driver?
>
> ** **
>
> Thanks again,
>
> Jonathan
>
>
>
> 
>
> On 14 December 2012 11:20, Paolo Crosato 
> wrote:
>
> Il 14/12/2012 11:39, Jonathan Moules ha scritto:
>
>  Hi Christian,
>
>   Thanks for the detailed information. I'm more inclined to picking
> between the OCI and the NG one's myself. I have the NG one set up and
> working but the OCI one doesn't work.
>
> ** **
>
> I get this error in the console when I hit "save" for a new OCI Oracle
> store:
>
> ** **
>
> 109562 [btpool0-2] ERROR org.mortbay.log - Nested in
> org.springframework.web.util.NestedServletException: Handler processing
> failed; nested exception is java.lang.UnsatisfiedLinkError: no ocijdbc10 in
> 
>
>  java.library.path:
>
> java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
>
> ** **
>
> Hi,
> it would seem you are missing ojdbc from oracle in your java library path,
> or the binaries like libocijdbc11.so. I had the same issue with other
> spring apps relying on oracle. It could be that ojdbc5/6 is missing, or it
> can't find the oci layer because the libraries are not in the directories
> the linker is parsing.
> I would first check if the ojdb6.jar is in the tomcat/lib directory, if
> not get it from oracle
> http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html.
> For oci to work you will need the oci libraries too, you can get the
> instant client here if you haven't got it already:
> http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
> This provides the jars too, so you can skip the ojdbc donwload.
>
> Now all the pieces should be there, to make them work together you have to
> set ORACLE_HOME to the client path, like this:
> ORACLE_HOME=/usr/lib/oracle/11.2/client64 in my case, set TNS_ADMIN if you
> plan to use TNS configuration, and add the $ORACLE_HOME/lib dir to the
> linker search path, either by LD_LIBRARY_PATH which works but is not
> recommended, or via /etc/ld.so.conf.d/ method, then call ldconfig again.
>
> If you are on windows setting ORACLE_HOME and adding the executables and
> the libs to the PATH var should be enough.
>
> In summary what you need are the jars and the oci (libocci,
> libocijdbc1X.so) libs, when you have them it's just about having them talk
> together.
>
> Hope it helps, getting Oracle to work like you want it to is always
> troublesome :)
>
> Regards,
>
> Paolo 
>
> ** **
>
> ** **
>
> On 13 December 2012 23:03, cmaul  wrote:***
> *
>
> Jonathan,
>
> OCI is the Oracle Call Interface is a native C interface to interact with
> Oracle databases. Haven't used it.
>
> The other two are the JDBC connection pool implementations, which can
> reside
> on the application level (geoserver), which is the Oracle NG connection
> pool
> or on the container level (Tomcat), which is the JNDI connection pool.
>
> I was going to write there is not much difference as geoserver comes with
> commons-dbcp-xx.jar and tomcat with tomcat-dbcp.jar and both are from
> Apache, but this is not true as I discovered just now. They have a
> completely different class structure. Using NG on my production server and
> JNDI on the test server I found very little difference in performance or
> stability.
>
> One warning: It is either or. If you use JNDI your Oracle odbc.jar must sit
> in the Tomcat_home/lib, if you use NG it would be in the geoserver/lib. The
> jar in both lib directories causes confusion and connection errors.
>
> NG is documented:
> http://docs.geoserver.org/latest/en/user/data/database/oracle.html
>
> where it says: The database schema to access tables from. Setting this
> value
> greatly increases the speed... yes, but then you can only publish from this
> schema.
>
> JNDI and the necessary modifications in TOMCAT_HOME/conf/context.xml are
> here:
>
>
> http://docs.geoserver.org/latest/en/user/tutorials/tomcat-jndi/tomcat-jndi.html#tomcat-jndi
>
> Obviously when refreshing the pools in one case the app restart is enough,
> while you need to restart the container in the other case. And the JNDI
> pool
> can be used for other apps as well if they are running in the same
> container.
>
> Cheers
>
> Christian
>
>
>

Re: [Geoserver-users] Oracle connections

[Rahkonen Jukka]

Hi,

We have found no reason for using OCI driver so we use JNDI in production and 
JNDI and NG in development.

-Jukka Rahkonen-

Jonathan Moules wrote:

Hi Paulo,
Thanks for that. I do have the relevant files already installed, but don't have 
an ORACLE_HOME set because other software breaks if I set it (I have both 32bit 
and 64 oracle installs, so if I set Oracle Home to one, then software for the 
other breaks).

Do you know if the OCI driver offers a performance advantage over the plain 
Oracle driver?

Thanks again,
Jonathan


On 14 December 2012 11:20, Paolo Crosato 
mailto:paolo.cros...@targaubiest.com>> wrote:
Il 14/12/2012 11:39, Jonathan Moules ha scritto:
Hi Christian,
  Thanks for the detailed information. I'm more inclined to picking between the 
OCI and the NG one's myself. I have the NG one set up and working but the OCI 
one doesn't work.

I get this error in the console when I hit "save" for a new OCI Oracle store:

109562 [btpool0-2] ERROR org.mortbay.log - Nested in 
org.springframework.web.util.NestedServletException: Handler processing failed; 
nested exception is java.lang.UnsatisfiedLinkError: no ocijdbc10 in
 java.library.path:
java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path

Hi,
it would seem you are missing ojdbc from oracle in your java library path, or 
the binaries like libocijdbc11.so. I had the same issue with other spring apps 
relying on oracle. It could be that ojdbc5/6 is missing, or it can't find the 
oci layer because the libraries are not in the directories the linker is 
parsing.
I would first check if the ojdb6.jar is in the tomcat/lib directory, if not get 
it from oracle 
http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html .
For oci to work you will need the oci libraries too, you can get the instant 
client here if you haven't got it already: 
http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
This provides the jars too, so you can skip the ojdbc donwload.

Now all the pieces should be there, to make them work together you have to set 
ORACLE_HOME to the client path, like this: 
ORACLE_HOME=/usr/lib/oracle/11.2/client64 in my case, set TNS_ADMIN if you plan 
to use TNS configuration, and add the $ORACLE_HOME/lib dir to the linker search 
path, either by LD_LIBRARY_PATH which works but is not recommended, or via 
/etc/ld.so.conf.d/ method, then call ldconfig again.

If you are on windows setting ORACLE_HOME and adding the executables and the 
libs to the PATH var should be enough.

In summary what you need are the jars and the oci (libocci, libocijdbc1X.so) 
libs, when you have them it's just about having them talk together.

Hope it helps, getting Oracle to work like you want it to is always troublesome 
:)

Regards,

Paolo


On 13 December 2012 23:03, cmaul 
mailto:christian.m...@dse.vic.gov.au>> wrote:
Jonathan,

OCI is the Oracle Call Interface is a native C interface to interact with
Oracle databases. Haven't used it.

The other two are the JDBC connection pool implementations, which can reside
on the application level (geoserver), which is the Oracle NG connection pool
or on the container level (Tomcat), which is the JNDI connection pool.

I was going to write there is not much difference as geoserver comes with
commons-dbcp-xx.jar and tomcat with tomcat-dbcp.jar and both are from
Apache, but this is not true as I discovered just now. They have a
completely different class structure. Using NG on my production server and
JNDI on the test server I found very little difference in performance or
stability.

One warning: It is either or. If you use JNDI your Oracle odbc.jar must sit
in the Tomcat_home/lib, if you use NG it would be in the geoserver/lib. The
jar in both lib directories causes confusion and connection errors.

NG is documented:
http://docs.geoserver.org/latest/en/user/data/database/oracle.html

where it says: The database schema to access tables from. Setting this value
greatly increases the speed... yes, but then you can only publish from this
schema.

JNDI and the necessary modifications in TOMCAT_HOME/conf/context.xml are
here:

http://docs.geoserver.org/latest/en/user/tutorials/tomcat-jndi/tomcat-jndi.html#tomcat-jndi

Obviously when refreshing the pools in one case the app restart is enough,
while you need to restart the container in the other case. And the JNDI pool
can be used for other apps as well if they are running in the same
container.

Cheers

Christian





-
 

Dr Christian Maul
Project Manager

Information Services Branch
Department of Sustainability and Environment
Level13, Marland House, 570 Bourke Street
Melbourne 3000

PO Box 500, East Melbourne Vic 3002


Telephone:+61-3-8636 2325
Telefax:  +61-3-8636 2813
--
View this message in context: 
http://osgeo-org.1560.n6.nabble.com/Oracle-connections-tp5022806p5022874.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

--

Re: [Geoserver-users] Oracle connections

[Jonathan Moules]

Hi Paulo,
Thanks for that. I do have the relevant files already installed, but don't
have an ORACLE_HOME set because other software breaks if I set it (I have
both 32bit and 64 oracle installs, so if I set Oracle Home to one, then
software for the other breaks).

Do you know if the OCI driver offers a performance advantage over the plain
Oracle driver?

Thanks again,
Jonathan



On 14 December 2012 11:20, Paolo Crosato wrote:

>  Il 14/12/2012 11:39, Jonathan Moules ha scritto:
>
> Hi Christian,
>   Thanks for the detailed information. I'm more inclined to picking
> between the OCI and the NG one's myself. I have the NG one set up and
> working but the OCI one doesn't work.
>
>  I get this error in the console when I hit "save" for a new OCI Oracle
> store:
>
>  109562 [btpool0-2] ERROR org.mortbay.log - Nested in
> org.springframework.web.util.NestedServletException: Handler processing
> failed; nested exception is java.lang.UnsatisfiedLinkError: no ocijdbc10 in
>  java.library.path:
> java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
>
>
> Hi,
> it would seem you are missing ojdbc from oracle in your java library path,
> or the binaries like libocijdbc11.so. I had the same issue with other
> spring apps relying on oracle. It could be that ojdbc5/6 is missing, or it
> can't find the oci layer because the libraries are not in the directories
> the linker is parsing.
> I would first check if the ojdb6.jar is in the tomcat/lib directory, if
> not get it from oracle
> http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html.
> For oci to work you will need the oci libraries too, you can get the
> instant client here if you haven't got it already:
> http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
> This provides the jars too, so you can skip the ojdbc donwload.
>
> Now all the pieces should be there, to make them work together you have to
> set ORACLE_HOME to the client path, like this:
> ORACLE_HOME=/usr/lib/oracle/11.2/client64 in my case, set TNS_ADMIN if you
> plan to use TNS configuration, and add the $ORACLE_HOME/lib dir to the
> linker search path, either by LD_LIBRARY_PATH which works but is not
> recommended, or via /etc/ld.so.conf.d/ method, then call ldconfig again.
>
> If you are on windows setting ORACLE_HOME and adding the executables and
> the libs to the PATH var should be enough.
>
> In summary what you need are the jars and the oci (libocci,
> libocijdbc1X.so) libs, when you have them it's just about having them talk
> together.
>
> Hope it helps, getting Oracle to work like you want it to is always
> troublesome :)
>
> Regards,
>
> Paolo
>
>
>
>
> On 13 December 2012 23:03, cmaul  wrote:
>
>> Jonathan,
>>
>> OCI is the Oracle Call Interface is a native C interface to interact with
>> Oracle databases. Haven't used it.
>>
>> The other two are the JDBC connection pool implementations, which can
>> reside
>> on the application level (geoserver), which is the Oracle NG connection
>> pool
>> or on the container level (Tomcat), which is the JNDI connection pool.
>>
>> I was going to write there is not much difference as geoserver comes with
>> commons-dbcp-xx.jar and tomcat with tomcat-dbcp.jar and both are from
>> Apache, but this is not true as I discovered just now. They have a
>> completely different class structure. Using NG on my production server and
>> JNDI on the test server I found very little difference in performance or
>> stability.
>>
>> One warning: It is either or. If you use JNDI your Oracle odbc.jar must
>> sit
>> in the Tomcat_home/lib, if you use NG it would be in the geoserver/lib.
>> The
>> jar in both lib directories causes confusion and connection errors.
>>
>> NG is documented:
>> http://docs.geoserver.org/latest/en/user/data/database/oracle.html
>>
>> where it says: The database schema to access tables from. Setting this
>> value
>> greatly increases the speed... yes, but then you can only publish from
>> this
>> schema.
>>
>> JNDI and the necessary modifications in TOMCAT_HOME/conf/context.xml are
>> here:
>>
>>
>> http://docs.geoserver.org/latest/en/user/tutorials/tomcat-jndi/tomcat-jndi.html#tomcat-jndi
>>
>> Obviously when refreshing the pools in one case the app restart is enough,
>> while you need to restart the container in the other case. And the JNDI
>> pool
>> can be used for other apps as well if they are running in the same
>> container.
>>
>> Cheers
>>
>> Christian
>>
>>
>>
>>
>>
>> -
>> 

>>
>> Dr Christian Maul
>> Project Manager
>>
>> Information Services Branch
>> Department of Sustainability and Environment
>> Level13, Marland House, 570 Bourke Street
>> Melbourne 3000
>>
>> PO Box 500, East Melbourne Vic 3002
>>
>>
>> Telephone:+61-3-8636 2325
>> Telefax:  +61-3-8636 2813
>> --
>> View this message in context:
>> http://osgeo-org.1560.n6.nabble.com/Oracle-connections-tp5022806p5022874.html
>> Sent from the GeoServer - User mailing l

Re: [Geoserver-users] Oracle connections

[Paolo Crosato]

Il 14/12/2012 11:39, Jonathan Moules ha scritto:

Hi Christian,
  Thanks for the detailed information. I'm more inclined to picking 
between the OCI and the NG one's myself. I have the NG one set up and 
working but the OCI one doesn't work.


I get this error in the console when I hit "save" for a new OCI Oracle 
store:


109562 [btpool0-2] ERROR org.mortbay.log - Nested in 
org.springframework.web.util.NestedServletException: Handler 
processing failed; nested exception is java.lang.UnsatisfiedLinkError: 
no ocijdbc10 in

 java.library.path:
java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path


Hi,
it would seem you are missing ojdbc from oracle in your java library 
path, or the binaries like libocijdbc11.so. I had the same issue with 
other spring apps relying on oracle. It could be that ojdbc5/6 is 
missing, or it can't find the oci layer because the libraries are not in 
the directories the linker is parsing.
I would first check if the ojdb6.jar is in the tomcat/lib directory, if 
not get it from oracle 
http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html .
For oci to work you will need the oci libraries too, you can get the 
instant client here if you haven't got it already: 
http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

This provides the jars too, so you can skip the ojdbc donwload.

Now all the pieces should be there, to make them work together you have 
to set ORACLE_HOME to the client path, like this: 
ORACLE_HOME=/usr/lib/oracle/11.2/client64 in my case, set TNS_ADMIN if 
you plan to use TNS configuration, and add the $ORACLE_HOME/lib dir to 
the linker search path, either by LD_LIBRARY_PATH which works but is not 
recommended, or via /etc/ld.so.conf.d/ method, then call ldconfig again.


If you are on windows setting ORACLE_HOME and adding the executables and 
the libs to the PATH var should be enough.


In summary what you need are the jars and the oci (libocci, 
libocijdbc1X.so) libs, when you have them it's just about having them 
talk together.


Hope it helps, getting Oracle to work like you want it to is always 
troublesome :)


Regards,

Paolo




On 13 December 2012 23:03, cmaul > wrote:


Jonathan,

OCI is the Oracle Call Interface is a native C interface to
interact with
Oracle databases. Haven't used it.

The other two are the JDBC connection pool implementations, which
can reside
on the application level (geoserver), which is the Oracle NG
connection pool
or on the container level (Tomcat), which is the JNDI connection pool.

I was going to write there is not much difference as geoserver
comes with
commons-dbcp-xx.jar and tomcat with tomcat-dbcp.jar and both are from
Apache, but this is not true as I discovered just now. They have a
completely different class structure. Using NG on my production
server and
JNDI on the test server I found very little difference in
performance or
stability.

One warning: It is either or. If you use JNDI your Oracle odbc.jar
must sit
in the Tomcat_home/lib, if you use NG it would be in the
geoserver/lib. The
jar in both lib directories causes confusion and connection errors.

NG is documented:
http://docs.geoserver.org/latest/en/user/data/database/oracle.html

where it says: The database schema to access tables from. Setting
this value
greatly increases the speed... yes, but then you can only publish
from this
schema.

JNDI and the necessary modifications in
TOMCAT_HOME/conf/context.xml are
here:


http://docs.geoserver.org/latest/en/user/tutorials/tomcat-jndi/tomcat-jndi.html#tomcat-jndi

Obviously when refreshing the pools in one case the app restart is
enough,
while you need to restart the container in the other case. And the
JNDI pool
can be used for other apps as well if they are running in the same
container.

Cheers

Christian





-


Dr Christian Maul
Project Manager

Information Services Branch
Department of Sustainability and Environment
Level13, Marland House, 570 Bourke Street
Melbourne 3000

PO Box 500, East Melbourne Vic 3002


Telephone:+61-3-8636 2325
Telefax:  +61-3-8636 2813
--
View this message in context:

http://osgeo-org.1560.n6.nabble.com/Oracle-connections-tp5022806p5022874.html
Sent from the GeoServer - User mailing list archive at Nabble.com.


--
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add
services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_123

Re: [Geoserver-users] Oracle connections

[cmaul]

Jonathan,

OCI is the Oracle Call Interface is a native C interface to interact with
Oracle databases. Haven't used it.

The other two are the JDBC connection pool implementations, which can reside
on the application level (geoserver), which is the Oracle NG connection pool
or on the container level (Tomcat), which is the JNDI connection pool. 

I was going to write there is not much difference as geoserver comes with
commons-dbcp-xx.jar and tomcat with tomcat-dbcp.jar and both are from
Apache, but this is not true as I discovered just now. They have a
completely different class structure. Using NG on my production server and
JNDI on the test server I found very little difference in performance or
stability.

One warning: It is either or. If you use JNDI your Oracle odbc.jar must sit
in the Tomcat_home/lib, if you use NG it would be in the geoserver/lib. The
jar in both lib directories causes confusion and connection errors. 

NG is documented:
http://docs.geoserver.org/latest/en/user/data/database/oracle.html

where it says: The database schema to access tables from. Setting this value
greatly increases the speed... yes, but then you can only publish from this
schema.

JNDI and the necessary modifications in TOMCAT_HOME/conf/context.xml are
here:

http://docs.geoserver.org/latest/en/user/tutorials/tomcat-jndi/tomcat-jndi.html#tomcat-jndi

Obviously when refreshing the pools in one case the app restart is enough,
while you need to restart the container in the other case. And the JNDI pool
can be used for other apps as well if they are running in the same
container. 

Cheers

Christian





-


Dr Christian Maul
Project Manager

Information Services Branch
Department of Sustainability and Environment
Level13, Marland House, 570 Bourke Street
Melbourne 3000

PO Box 500, East Melbourne Vic 3002


Telephone:+61-3-8636 2325
Telefax:  +61-3-8636 2813
--
View this message in context: 
http://osgeo-org.1560.n6.nabble.com/Oracle-connections-tp5022806p5022874.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

--
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[Geoserver-users] Oracle connections

[Jonathan Moules]

Hi All,
I've installed the Oracle extension and it seems to be working well.
Possibly too well because I have the following three:

 Oracle NG  - Oracle Database
 Oracle NG (JNDI)  - Oracle Database (JNDI)
 Oracle NG (OCI)  - Oracle Database (OCI)

I can find documentation for the first here:
http://docs.geoserver.org/latest/en/user/data/database/oracle.html

which includes references to (and screenshot of) JNDI here:
http://docs.geoserver.org/latest/en/user/tutorials/tomcat-jndi/tomcat-jndi.html#tomcat-jndi

But nothing on the OCI one.

What are the differences between these? Just the connection type? I can't
seem to find anything about the third one at all (I guess its using the
Oracle OCI client I have installed). Do any of them have any particular
advantages (i.e. speed?)
Thanks,
Jonathan


This transmission is intended for the named addressee(s) only and may contain 
sensitive or protectively marked material up to RESTRICTED and should be 
handled accordingly. Unless you are the named addressee (or authorised to 
receive it for the addressee) you may not copy or use it, or disclose it to 
anyone else. If you have received this transmission in error please notify the 
sender immediately. All email traffic sent to or from us,  including without 
limitation all GCSX traffic, may be subject to recording and/or monitoring in 
accordance with relevant legislation.
--
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Oracle Connections lost

[Andrea Aime]

On Fri, Feb 10, 2012 at 5:18 PM, Lucas Heezen - Covadis
wrote:

>  Okay, 
>
> ** **
>
> How do i use the thin driver?
>

When setting up the oracle data store, use "Oracle" instead of "Oracle OCI"

Cheers
Andrea


-- 
---
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead

Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy

phone: +39 0584 962313
fax:  +39 0584 962313
mob:+39 339 8844549

http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf

---
--
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing 
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Oracle Connections lost

[Lucas Heezen - Covadis]

Okay,

How do i use the thin driver?


Met vriendelijke groet,
Lucas Heezen

[Beschrijving: http://www.covadis.nl/emailkop/logo.gif]

Covadis b.v.

t: 026 3616600

Geograaf 12

f: 026 3612317

6921 EW Duiven

e: hee...@covadis.nl<mailto:hee...@covadis.nl>



Van: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] Namens Andrea Aime
Verzonden: vrijdag 10 februari 2012 12:19
Aan: Lucas Heezen - Covadis
CC: geoserver-users@lists.sourceforge.net
Onderwerp: Re: [Geoserver-users] Oracle Connections lost

On Fri, Feb 10, 2012 at 11:58 AM, Lucas Heezen - Covadis 
mailto:hee...@covadis.nl>> wrote:
OS: Windows Server 2003 family Build 3790 Service Pack 2

CPU:total 1 (1 cores per cpu, 1 threads per core) family 6 model 44 stepping 2, 
cmov, cx8, fxsr, mmx, sse, sse2, sse3, ssse3, sse4.1, sse4.2, popcnt

Memory: 4k page, physical 3145120k(1980048k free), swap 6131212k(4437104k free)

vm_info: Java HotSpot(TM) Client VM (20.1-b02) for windows-x86 JRE 
(1.6.0_26-b03), built on May  4 2011 00:50:59 by "java_re" with MS VC++ 7.1 
(VS2003)

time: Fri Feb 10 10:05:44 2012
elapsed time: 85382 seconds


Does this say anything?

That you are using OCI, which relies on native code, that crashed.
Try to use the thin driver (pure java), it's generally more stable

Cheers
Andrea


--
---
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead

Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy

phone: +39 0584 962313
fax:  +39 0584 962313
mob:+39 339 8844549

http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf

---
<>--
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing 
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Oracle Connections lost

[Andrea Aime]

On Fri, Feb 10, 2012 at 11:58 AM, Lucas Heezen - Covadis
wrote:

>  OS: Windows Server 2003 family Build 3790 Service Pack 2
>
> ** **
>
> CPU:total 1 (1 cores per cpu, 1 threads per core) family 6 model 44
> stepping 2, cmov, cx8, fxsr, mmx, sse, sse2, sse3, ssse3, sse4.1, sse4.2,
> popcnt
>
> ** **
>
> Memory: 4k page, physical 3145120k(1980048k free), swap 6131212k(4437104k
> free)
>
> ** **
>
> vm_info: Java HotSpot(TM) Client VM (20.1-b02) for windows-x86 JRE
> (1.6.0_26-b03), built on May  4 2011 00:50:59 by "java_re" with MS VC++ 7.1
> (VS2003)
>
> ** **
>
> time: Fri Feb 10 10:05:44 2012
>
> elapsed time: 85382 seconds
>
> ** **
>
> ** **
>
> Does this say anything?
>

That you are using OCI, which relies on native code, that crashed.
Try to use the thin driver (pure java), it's generally more stable

Cheers
Andrea


-- 
---
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead

Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy

phone: +39 0584 962313
fax:  +39 0584 962313
mob:+39 339 8844549

http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf

---
--
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing 
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Oracle Connections lost

[Andrea Aime]

On Wed, Feb 8, 2012 at 5:01 PM, Lucas Heezen - Covadis wrote:

>  Hello,
>
> 
>
> We have geoserver 1.7.7 runnen with 5 oracle connection (OCI) to 1
> database (5 different schema’s). 
>
> The connections are dropped at some point (we don’t no when this happens).
> 
>
> Is this a problem with geoserver or with Oracle?
>

Uh, old old GeoServer. GeoServer does not drop connections, but Oracle
likes to close connections
that are pooled and had been up for a long time.
In current GeoServer versions we have a "validation connection" flag that
makes the connection
pool check if the DBMS dropped the connection before using it, but I don't
remeber if that was
available in 1.7.7

Cheers
Andrea

-- 
---
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead

Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy

phone: +39 0584 962313
fax:  +39 0584 962313
mob:+39 339 8844549

http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf

---
--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[Geoserver-users] Oracle Connections lost

[Lucas Heezen - Covadis]

Hello,
We have geoserver 1.7.7 runnen with 5 oracle connection (OCI) to 1 database (5 
different schema's).
The connections are dropped at some point (we don't no when this happens).
Is this a problem with geoserver or with Oracle?


Met vriendelijke groet,
Lucas Heezen

[Beschrijving: http://www.covadis.nl/emailkop/logo.gif]

Covadis b.v.

t: 026 3616600

Geograaf 12

f: 026 3612317

6921 EW Duiven

e: hee...@covadis.nl



<>--
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users