[Geoserver-users] Oracle plugin problem

Blaz · November 21, 2008, 11:32am

Hey all!

There seems to be a problem with oracle plugin for GeoServer 1.7.0 (stable
release).

When i do a request that contains a lot of parameters eg:

<wfs:GetFeature service="WFS" version="1.0.0"
  outputFormat="GML2"
  xmlns:topp="http://www.openplans.org/topp"
  xmlns:wfs="http://www.opengis.net/wfs"
  xmlns="http://www.opengis.net/ogc"
  xmlns:gml="http://www.opengis.net/gml"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://www.opengis.net/wfs
                      http://schemas.opengis.net/wfs/1.0.0/WFS-basic.xsd">
  <wfs:Query typeName="topp:sample_oracle_data">
    <Filter>
    <Intersects>
      <PropertyName>GEOMETRY</PropertyName>
      <gml:MultiPolygon
srsName="http://www.opengis.net/gml/srs/epsg.xml#2170">
        <gml:polygonMember>
          <gml:Polygon>
            <gml:outerBoundaryIs>
              <gml:LinearRing>
                <gml:coordinates>537517.85057797,94862.19340034
537517.62159792,94855.65420114 537516.96558605,94849.14391843
537515.88511819,94842.69060081 537514.38486236,94836.32166407
537512.47126615,94830.06451995 ....... ~~1000s more .......
</gml:coordinates>
              </gml:LinearRing>
            </gml:outerBoundaryIs>
          </gml:Polygon>
        </gml:polygonMember>
      </gml:MultiPolygon>
        </Intersects>
      </Filter>
  </wfs:Query>
</wfs:GetFeature>

I get this:

ORA-00939: too many arguments for function

Orable bind variables are not being used here? or is the problem somewhere
else?

--
View this message in context: http://www.nabble.com/Oracle-plugin-problem-tp20619506p20619506.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Andrea_Aime3 · November 21, 2008, 1:27pm

GeoUser ha scritto:

Hey all!

There seems to be a problem with oracle plugin for GeoServer 1.7.0 (stable
release).

When i do a request that contains a lot of parameters eg:

<wfs:GetFeature service="WFS" version="1.0.0"
  outputFormat="GML2"
  xmlns:topp="http://www.openplans.org/topp"
  xmlns:wfs="http://www.opengis.net/wfs"
  xmlns="http://www.opengis.net/ogc"
  xmlns:gml="http://www.opengis.net/gml"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://www.opengis.net/wfs
                      http://schemas.opengis.net/wfs/1.0.0/WFS-basic.xsd">
  <wfs:Query typeName="topp:sample_oracle_data">
    <Filter>
    <Intersects>
      <PropertyName>GEOMETRY</PropertyName>
      <gml:MultiPolygon
srsName="http://www.opengis.net/gml/srs/epsg.xml#2170">
        <gml:polygonMember>
          <gml:Polygon>
            <gml:outerBoundaryIs>
              <gml:LinearRing>
                <gml:coordinates>537517.85057797,94862.19340034
537517.62159792,94855.65420114 537516.96558605,94849.14391843
537515.88511819,94842.69060081 537514.38486236,94836.32166407
537512.47126615,94830.06451995 ....... ~~1000s more .......
</gml:coordinates> </gml:LinearRing>
            </gml:outerBoundaryIs>
          </gml:Polygon>
        </gml:polygonMember>
      </gml:MultiPolygon>
        </Intersects>
      </Filter>
  </wfs:Query>
</wfs:GetFeature>

I get this:

ORA-00939: too many arguments for function

Never seen this error, but then again I don't use Oracle much.

Orable bind variables are not being used here? or is the problem somewhere
else?

Nope, they are not for the old Oracle data store. The new one which
will be shipped as an option for 1.7.1 does use prepared statements
thought.

Just to be extra sure, can you use the GEOTOOLS_DEVELOPER_LOGGING
logging profile (configure/server) and see what the SQL looks like?
That would help to see if the problem is really just the argument
being too long of if there is something extra going on.

Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

Blaz · November 21, 2008, 2:06pm

I don't think the problem is anywhere else since if i reduce the number of
params to less that ~~600 the request gets processed properly.

But anyway here's the sample sql: (i've added \n at every param so that the
window doesn't get stretched)

SELECT ATTR0, ATTR1, ATTR2, GEOMETRY FROM ORACLE_TEST_TABLE WHERE

SDO_RELATE(GEOMETRY,MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(537517.85057797,
94862.19340034,
537517.65131143,
94868.73356903,
537517.02467714,
94875.24675547,
537515.97343796,
94881.70489897,
537514.50203304,
94888.08056312,
537512.61689046,
94894.34630703,
537510.32590525,
94900.47531456,
537507.63896278,
94906.44139313,
537504.56752004,
94912.21897472,
537501.12492018,
94917.78332445,
537497.3256597,
94923.11054232,
537493.18612199,
94928.17787551,
537488.72405361,
94932.96361492,
537483.95856484,
94937.44730456,
537478.91002495,
94941.60974175,
537473.60006245,
94945.43308178,
537468.05135575,
94948.90083846,
537462.287739,
94951.9984072,
537461.58799345,
94952.34198307,
537390.16811813,
94987.07246655,
537387.52542937,
94988.31033109,
537226.99520707,
95060.66010126,
537224.61324077,
95061.69659758,
537115.51587678,
95107.49459918,
536995.05682202,
95158.25933425,
536903.48285614,
95196.91590256,
536823.44018961,
95312.17095882,
536732.65880573,
95443.18821535,
536732.49457282,
95443.4244326,
536638.28872823,
95578.55176257,
536541.03575083,
95718.27874044,
536457.89873588,
95838.80516509,
536457.5552463,
95839.2999305,
536371.55136109,
95962.38934722,
536282.68631959,
96091.4012608,
536282.45155519,
96091.740434,
536204.68050912,
96203.6551803,
536171.96107341,
96339.76138479,
536171.81203094,
96340.3731621,
536136.44428039,
96483.52346979,
536101.39478338,
96627.15564449,
536067.43807138,
96767.79745328,
536066.88215244,
96769.99093512,
536064.99689003,
96776.25667873,
536062.70588974,
96782.38568474,
536060.01893232,
96788.3517608,
536056.94757951,
96794.12933867,
536053.50486024,
96799.69357953,
536049.70569052,
96805.02089647,
536045.56613903,
96810.08822336,
536041.10405731,
96814.8739556,
536036.33855571,
96819.35763721,
536031.29000353,
96823.52006553,
536025.97992444,
96827.34329149,
536022.20316512,
96829.75833865,
535887.44705902,
96911.72548211,
535672.43684947,
97043.24800623,
535672.41698768,
97043.2601941,
535482.8471707,
97159.15995533,
535482.83054927,
97159.17004226,
535181.06592436,
97343.58298874,
534714.7867834,
97642.12914503,
534714.73692262,
97642.16097599,
534544.55683041,
97750.98090676,
534544.46568031,
97751.03910588,
534210.78573413,
97963.89891598,
534207.20095294,
97966.08123483,
534201.91182696,
97968.94186263,
533832.14186425,
98154.78227843,
533832.0677297,
98154.81950289,
533466.33777364,
98338.24895582,
533466.23342032,
98338.30121785,
533364.72716589,
98389.06280985,
533307.97221273,
98458.21548104,
533307.88974164,
98458.31584677,
532978.07443192,
98859.11392046,
532741.87386529,
99146.73796137,
532741.80225107,
99146.82511276,
532574.5858063,
99349.97877469,
532457.06590483,
99492.81853054,
532456.93499361,
99492.97731273,
532351.55920147,
99620.5205927,
532279.16775638,
99709.05423866,
532278.95166163,
99709.31757982,
532166.95465398,
99845.34006278,
532077.68915672,
99954.83264905,
532077.33609826,
99955.26326511,
531978.37503689,
100075.27751972,
531873.36719704,
100203.32510878,
531871.37572235,
100205.67853471,
531866.91361768,
100210.46424566,
531862.14809455,
100214.94790453,
531857.0995224,
100219.11030877,
531851.78952988,
100222.93361382,
531846.24079551,
100226.40133363,
531840.47715356,
100229.49886378,
531836.93381816,
100231.17055135,
531408.46384333,
100423.1408345,
531408.43895448,
100423.15198681,
531059.70894786,
100579.28165836,
531059.65854253,
100579.30417376,
530953.80817416,
100626.62417938,
530953.19943589,
100626.89384938,
530856.81537275,
100669.21418788,
530692.71530434,
100742.52464103,
530509.80728665,
100824.3933731,
530430.28941794,
100860.18751845,
530231.82188252,
101093.05870895,
530231.82021212,
101093.06070165,
529980.2113124,
101388.26962717,
529781.79906195,
101621.07078593,
529775.29344148,
101718.69857809,
529759.31274615,
101966.11513213,
529759.31011721,
101966.1562776,
529737.19036709,
102306.43635941,
529737.18783646,
102306.47467829,
529720.03341916,
102568.81693322,
529696.43331928,
102934.66696578,
529696.43008041,
102934.71617307,
529664.430312,
103426.99611564,
529664.42697292,
103427.0473121,
529640.57303693,
103791.12655522,
529625.91299114,
104018.0465917,
529625.90428891,
104018.17987007,
529618.95427587,
104123.56961034,
529618.95194795,
104123.60499772,
529602.4269018,
104372.84231902,
529586.94317856,
104612.69152745,
529586.94256911,
104612.69979862,
529570.25277706,
104870.89969923,
529569.63476925,
104877.27793941,
529568.58345772,
104883.7360852,
529567.11198046,
104890.11174691,
529565.95748329,
104894.12048688,
529521.69728593,
105036.56071805,
529521.32184256,
105037.74330687,
529469.03941717,
105198.91573753,
529432.76993787,
105315.53475075,
529432.2932309,
105317.02627182,
529382.26364327,
105469.43079141,
529333.332643,
105621.50079104,
529283.04757377,
105779.23990916,
529283.02979861,
105779.29553478,
529249.83856935,
105883.20375139,
529202.64151809,
106032.00160848,
529202.50804836,
106032.41927208,
529151.61780199,
106190.45255289,
529083.24447467,
106406.09168292,
529083.16505913,
106406.34068843,
529013.66511909,
106623.56053051,
529013.61210401,
106623.72583648,
528966.63612774,
106769.67431384,
528932.58604048,
106877.45254183,
528932.4406199,
106877.9091737,
528893.34206804,
106999.63338011,
528750.12257319,
107447.97585344,
528608.31295555,
107892.0761102,
528607.81692542,
107893.58798324,
528605.52585423,
107899.71698004,
528602.83882668,
107905.68304227,
528599.7674048,
107911.46060175,
528596.32461807,
107917.02492443,
528592.52527738,
107922.35210967,
528588.38566177,
107927.41940504,
528583.92351815,
107932.20510165,
528580.4716695,
107935.51074219,
528366.49335716,
108130.83178993,
528217.36599007,
108267.09645006,
528094.65654263,
108379.73301988,
528094.41721104,
108379.95192307,
528003.50878395,
108462.85638713,
527902.67947243,
108555.08941396,
527902.60645058,
108555.1561554,
527807.04611161,
108642.39596529,
527806.88000929,
108642.54728906,
527714.08591393,
108726.88015464,
527604.58639511,
108826.89077868,
527502.97712201,
108920.49275837,
527502.73100187,
108920.71869032,
527345.60105004,
109064.49847736,
527345.44518611,
109064.64077546,
527152.73337481,
109240.23337246,
526984.00839184,
109394.94778476,
526983.88230153,
109395.06321749,
526867.15221403,
109501.7336054,
526867.04732957,
109501.82931039,
526701.49091924,
109652.68732349,
526544.3365951,
109796.88408994,
526475.85806261,
109875.64190689,
526350.19454078,
110021.77476446,
526350.07374046,
110021.91509929,
526049.90386005,
110369.67510896,
526049.7635334,
110369.83726131,
525858.41171862,
110590.56782295,
525631.49742047,
110854.54978618,
525631.34811643,
110854.72315952,
525493.9281946,
111013.85325526,
525493.57549542,
111014.25947761,
525489.11334011,
111019.04526484,
525484.34766342,
111023.52889228,
525479.29904433,
111027.69115703,
525478.49741129,
111028.30272589,
525214.06622277,
111227.93548505,
524956.41911126,
111422.69542319,
524835.11140334,
111515.07896123,
524834.46180891,
111515.56949076,
524736.28700159,
111589.0809562,
524657.44820249,
111648.41964274,
524483.35939902,
111780.16341665,
524483.27004875,
111780.23103199,
523958.51088654,
112176.42479358,
523693.69068426,
112376.47481746,
523689.15845137,
112379.70446304,
523683.60967342,
112383.17223876,
523677.84599072,
112386.26961271,
523674.42624077,
112387.88571895,
523510.56658245,
112461.56580974,
523508.03242015,
112462.66353485,
523501.91379411,
112464.98204191,
523495.65660268,
112466.89553566,
523489.28762549,
112468.39568614,
523482.83427446,
112469.47604623,
523476.32396575,
112470.13205306,
523475.44927173,
112470.18751019,
523335.78907909,
112478.42740769,
523334.88621175,
112478.47654254,
523182.98913323,
112486.06067205,
523030.73742967,
112495.23988066,
523028.73019016,
112495.34069647,
522904.48137689,
112500.3277448,
522790.2178289,
112509.06976691,
522789.35393273,
112509.13210852,
522788.29921127,
112509.19801923,
522483.87915068,
112526.60768523,
522483.80054537,
112526.61215372,
522286.99065015,
112537.71213162,
522285.53124546,
112537.78376652,
522089.12090932,
112545.98401068,
522088.98724403,
112545.98944029,
521950.16746219,
112551.59926482,
521949.71486083,
112551.61650699,
521871.15662743,
112554.43469043,
521701.48475933,
112562.59390207,
521609.84050732,
112567.10013995,
521608.77213512,
112567.14702899,
521478.77466128,
112572.14598838,
521347.21356779,
112577.2343973,
521217.87416382,
112583.04031803,
521217.59416985,
112583.05246178,
521134.66672786,
112586.54202279,
521067.73977315,
112642.19579123,
520930.10003454,
112756.88714902,
520930.04319448,
112756.93448773,
520488.74292178,
113124.10471042,
520488.72589063,
113124.11888058,
520019.26983788,
113514.53939626,
519913.77074056,
113602.66115276,
519910.71840958,
113605.11094211,
519905.40837075,
113608.93418813,
519899.85959405,
113612.40184601,
519894.09591392,
113615.49931162,
519888.14200459,
113618.21302571,
519882.02338267,
113620.53162549,
519875.76619591,
113622.44510756,
519875.38444553,
113622.54750505,
519710.46048984,
113666.43695186,
519570.35793028,
113704.54524851,
519441.153907,
113739.90454163,
519440.85627187,
113739.98550001,
519440.69662566,
113740.02856819,
519294.03064446,
113779.42073326,
519139.79116241,
113821.16437756,
519000.03770451,
113859.35423981,
518999.86320382,
113859.40184258,
518879.63424147,
113892.02271049,
518763.26721579,
113923.87324562,
518762.96612838,
113923.9551538,
518762.89718569,
113923.97383706,
518589.44718522,
113970.73426751,
518583.14715802,
113972.21571997,
518576.69381523,
113973.2960658,
518570.18351568,
113973.95205895,
518563.64430732,
113974.18081007,
518557.1041379,
113973.98141897,
518550.59095892,
113973.35466038,
518544.13283104,
113972.30329767,
518541.07165394,
113971.65162253,
518428.99161867,
113945.95128087,
518425.67715548,
113945.13142887,
518419.41144358,
113943.24616592,
518413.28247589,
113940.95506273,
518407.31644481,
113938.26800519,
518401.53891816,
113935.19645078,
518395.97463054,
113931.75374313,
518390.64748172,
113927.95437922,
518385.58022419,
113923.81474286,
518380.79456672,
113919.35258104,
518376.31096493,
113914.58700444,
518372.14862114,
113909.53838269,
518368.32537962,
113904.22834467,
518364.85772615,
113898.67956909,
518361.76026486,
113892.91589039,
518359.04645027,
113886.96198302,
518356.72785455,
113880.84336311,
518354.81448104,
113874.5861784,
518353.3143456,
113868.21720916,
518352.23399997,
113861.76386706,
518351.57800696,
113855.25356819,
518351.34925591,
113848.71436052,
518351.548647,
113842.17419179,
518352.17540552,
113835.66101349,
518353.22676808,
113829.20288627,
518354.698295,
113822.82724646,
518356.58355767,
113816.56153483,
518358.87466054,
113810.43256738,
518361.56171774,
113804.46653649,
518364.63327178,
113798.68900999,
518368.07597904,
113793.12472247,
518371.87534256,
113787.79757371,
518376.01497853,
113782.73031618,
518380.47713996,
113777.94465864,
518385.24271618,
113773.46105676,
518390.29133756,
113769.29871281,
518395.60137524,
113765.47547109,
518401.1501505,
113762.00781738,
518406.91382893,
113758.91035581,
518412.86773606,
113756.1965409,
518418.98635577,
113753.87794483,
518425.24354033,
113751.96457096,
518431.61250946,
113750.46443514,
518438.06585152,
113749.38408911,
518444.57615039,
113748.72809571,
518451.11535811,
113748.49934426,
518457.65552695,
113748.69873497,
518464.1687054,
113749.32549313,
518470.62683281,
113750.37685534,
518473.68800972,
113751.02853024,
518561.46582782,
113771.15630183,
518710.67521799,
113730.93085714,
518826.98281202,
113699.09657154,
518827.19706698,
113699.0380974,
518947.45458007,
113666.40951878,
519087.22235895,
113628.21574545,
519087.45806068,
113628.15157038,
519241.86805584,
113586.36168666,
519241.893687,
113586.35472019,
519242.05333342,
113586.31175669,
519388.60359537,
113546.95072607,
519517.64618458,
113511.63565124,
519517.79589109,
113511.59480365,
519658.23551436,
113473.39477669,
519658.38344295,
113473.35466585,
519658.76519329,
113473.25226837,
519802.56052843,
113434.98555354,
519891.14936753,
113360.98866598,
519891.31434979,
113360.85116369,
520360.85383384,
112970.36128933,
520802.11769483,
112603.22131903,
520939.79001679,
112488.50278302,
520939.86775388,
112488.43802035,
521032.77778243,
112411.17776802,
521035.6612638,
112408.86873223,
521040.97130031,
112405.0454816,
521046.52007499,
112401.57781892,
521052.28375341,
112398.48034835,
521058.23766112,
112395.76652447,
521064.35628201,
112393.44791948,
521070.61346832,
112391.53453678,
521076.98243978,
112390.03439226,
521083.43578473,
112388.95403771,
521089.94608704,
112388.29803597,
521092.50595037,
112388.15745755,
521209.03506102,
112383.25397078,
521338.55616424,
112377.43988566,
521339.17560731,
112377.41399902,
521471.04568327,
112372.31358034,
521471.06787362,
112372.31269305,
521600.56092553,
112367.33307098,
521691.73960255,
112362.84975007,
521691.847412,
112362.84448323,
521862.15691583,
112354.65462009,
521863.37497224,
112354.60352146,
521942.31420805,
112351.77160016,
522080.79966046,
112346.1752866,
522276.46032947,
112338.00633537,
522472.50550956,
112326.94951336,
522775.92147402,
112309.59724554,
522891.03215531,
112300.79039804,
522891.89605146,
112300.72805633,
522894.64966303,
112300.57950405,
523019.7073689,
112295.5599566,
523171.47236132,
112286.41009286,
523172.50355,
112286.35323734,
523324.45776723,
112278.76624508,
523445.31985081,
112271.63537461,
523582.13799462,
112210.11464182,
523837.9689744,
112016.8551713,
523837.99018854,
112016.83910745,
524362.76965841,
111620.62993628,
524536.87108311,
111488.8766164,
524537.07977702,
111488.71912592,
524616.11963123,
111429.22904134,
524616.31798107,
111429.08015793,
524714.27080637,
111355.73501074,
524835.40836816,
111263.48103756,
524835.69376503,
111263.26443924,
525093.47356,
111068.40414086,
525093.52267674,
111068.36707806,
525349.51944593,
110875.1018809,
525479.93244997,
110724.0856753,
525706.8926578,
110460.05025158,
525707.16673154,
110459.73276603,
525898.57271027,
110238.93982286,
526198.6536992,
109891.28285072,
526324.41576523,
109745.03526803,
526324.77336727,
109744.621602,
526397.12302958,
109661.41158979,
526397.25458817,
109661.26065798,
526401.71673863,
109656.47497125,
526404.97815044,
109653.34364158,
526566.40811669,
109505.22377522,
526566.66259629,
109504.9911251,
526732.29879545,
109354.0604042,
526848.91834064,
109247.49097922,
527017.69187565,
109092.73208937,
527017.92493973,
109092.51906266,
527210.67130144,
108916.89500243,
527367.60013337,
108773.29929397,
527469.25295305,
108679.65713381,
527469.5671849,
108679.3688681,
527579.30675121,
108579.13903637,
527579.48956823,
108578.97249627,
527672.30287168,
108494.6221151,
527767.74368695,
108407.49145216,
527868.57037159,
108315.26074462,
527868.68267296,
108315.15821857,
527959.53185393,
108232.30780796,
528082.22383712,
108119.68720187,
528082.39098217,
108119.53409612,
528231.60095966,
107983.19400016,
528231.63877648,
107983.159475,
528425.92921919,
107805.80970141,
528559.61715485,
107387.14391981,
528559.62058527,
107387.13323463,
528702.88083484,
106938.66323339,
528702.92958706,
106938.51081279,
528741.96909607,
106816.97047227,
528776.02386291,
106709.1775942,
528776.18768368,
106708.66397452,
528823.2268665,
106562.51920417,
528892.64333865,
106345.56002834,
528961.05554525,
106129.7984706,
528961.1922375,
106129.37075043,
529012.08633355,
105971.32565551,
529059.23869208,
105822.66850772,
529059.30043609,
105822.4747089,
529092.51287318,
105718.50019701,
529142.84285052,
105560.62010079,
529142.92528255,
105560.36260938,
529191.98508477,
105407.892566,
529192.16680748,
105407.33336987,
529242.04283851,
105255.39672422,
529278.26025206,
105138.94481187,
529278.62821333,
105137.78652603,
529330.90845961,
104976.62092896,
529371.45439877,
104846.13412101,
529387.37695052,
104599.80428198,
529402.86686326,
104359.85836232,
529402.87819642,
104359.68477587,
529419.40579835,
104110.41010672,
529426.35126484,
104005.08885021,
529441.00718609,
103778.23364673,
529441.01315771,
103778.14287497,
529464.87168329,
103413.99457423,
529496.8663383,
102921.79341984,
529520.4664745,
102555.94342914,
529520.47224354,
102555.85569364,
529537.62992562,
102293.46405208,
529559.74708149,
101953.22515453,
529575.73710941,
101705.66509034,
529575.7503642,
101705.46177046,
529584.46041193,
101574.75158211,
529585.06545655,
101568.57196108,
529586.11675526,
101562.11382533,
529587.58811433,
101555.73817306,
529589.47341946,
101549.47244441,
529591.76446133,
101543.34345616,
529594.45145901,
101537.37740053,
529597.52285057,
101531.59984568,
529600.9656067,
101526.03552563,
529604.76491662,
101520.70834098,
529608.1288556,
101516.54022085,
529828.00905605,
101258.55036626,
529828.00999558,
101258.54921265,
530079.61813365,
100963.34117843,
530292.6582048,
100713.37137886,
530293.43458067,
100712.47136255,
530297.89668908,
100707.68565952,
530302.66221536,
100703.20200875,
530307.71079009,
100699.03961275,
530313.0207846,
100695.21631604,
530318.56952038,
100691.7486046,
530324.33316317,
100688.65108284,
530327.71681318,
100687.0511527,
530427.79663787,
100642.00124144,
530427.9898923,
100641.91454863,
530611.08004832,
100559.96428302,
530611.14488487,
100559.93524489,
530775.53491229,
100486.49527998,
530776.12053928,
100486.23592089,
530872.490886,
100443.92158249,
530977.99143154,
100396.75792443,
531326.69648791,
100240.63941467,
531733.66994583,
100058.30033958,
531823.83281092,
99948.35480078,
531824.0037042,
99948.14693786,
531922.86724843,
99828.251006,
532012.10079068,
99718.79755865,
532012.40822876,
99718.42242172,
532124.45700233,
99582.33714423,
532196.91211781,
99493.7255938,
532197.23511274,
99493.3325213,
532302.69941924,
99365.68218713,
532420.15405955,
99222.921745,
532420.16783953,
99222.90496497,
532587.37873044,
99019.75805488,
532823.55640519,
98732.16186285,
532823.62029431,
98732.08415017,
533153.43263981,
98331.28982719,
533223.65767686,
98245.72452907,
533225.62430026,
98243.40140947,
533230.08639299,
98238.61569256,
533234.85190452,
98234.13202692,
533239.90046551,
98229.96961512,
533245.21044734,
98226.14630172,
533250.75917132,
98222.67846815,
533256.22678586,
98219.72846384,
533376.73507806,
98159.4642756,
533742.37943217,
97976.07774441,
534107.54274037,
97792.55251206,
534436.85786542,
97582.47705441,
534606.95325567,
97473.71124224,
535074.11307098,
97174.601215,
535075.88939876,
97173.48999136,
535378.53290506,
96988.53985281,
535568.08282241,
96872.65229684,
535783.20306533,
96741.0624433,
535783.41715616,
96740.931841,
535882.79071763,
96680.48658832,
535907.03236188,
96580.082606,
535907.08981921,
96579.84568822,
535942.19979613,
96435.96562308,
535942.2682546,
96435.68670346,
535977.59504292,
96292.70222365,
536014.62913635,
96138.64840652,
536015.20818108,
96136.35898577,
536017.09344041,
96130.09324472,
536019.38443739,
96123.9642411,
536022.07128658,
96117.99816743,
536025.1427403,
96112.22059124,
536028.58545561,
96106.65635204,
536029.73875856,
96104.95969544,
536118.09926969,
95977.80641326,
536207.04391256,
95848.67899038,
536207.4247555,
95848.13012537,
536293.45179605,
95725.0075002,
536376.53110376,
95604.56476849,
536376.7711903,
95604.2183603,
536474.15135039,
95464.30866791,
536474.19527815,
95464.24555075,
536568.35374186,
95329.18608716,
536659.0707391,
95198.26175334,
536659.13188268,
95198.17368321,
536755.76230791,
95059.03370587,
536758.42465118,
95055.37935005,
536762.56419084,
95050.3120213,
536767.02626079,
95045.52628639,
536771.79175077,
95041.0426013,
536776.84029151,
95036.88016868,
536782.1502545,
95033.05683318,
536787.69896136,
95029.58908098,
536793.46257795,
95026.49151665,
536799.00333373,
95023.95093908,
536917.28312792,
94974.02085551,
536917.33845112,
94973.99749119,
537037.92831078,
94923.17750658,
537038.05663177,
94923.12351496,
537146.00828437,
94877.80650082,
537304.02785975,
94806.58826134,
537374.13218021,
94772.49753245,
537379.38628638,
94770.12728741,
537385.50485764,
94767.80857726,
537391.76200107,
94765.89498167,
537398.13093705,
94764.39472638,
537404.58425384,
94763.31425893,
537411.09453568,
94762.65824737,
537417.63373421,
94762.42937219,
537424.17390198,
94762.62863881,
537430.68708726,
94763.25516837,
537437.14522985,
94764.30640738,
537443.52089312,
94765.77781201,
537449.78663643,
94767.66305887,
537455.91564318,
94769.95404358,
537461.88172105,
94772.64098545,
537467.65930178,
94775.71232282,
537473.22354655,
94779.15502683,
537478.55086844,
94782.95418157,
537483.61820132,
94787.09371841,
537488.40394055,
94791.55578589,
537492.88763011,
94796.32127373,
537497.05006735,
94801.3698127,
537500.87330311,
94806.6798792,
537504.34116451,
94812.2284801,
537507.43862897,
94817.99209626,
537510.1525553,
94823.94594809,
537512.47126615,
94830.06451995,
537514.38486236,
94836.32166407,
537515.88511819,
94842.69060081,
537516.96558605,
94849.14391843,
537517.62159792,
94855.65420114,
537517.85057797,
94862.19340034)),
mask=anyinteract querytype=WINDOW) = TRUE

--
View this message in context: http://www.nabble.com/Oracle-plugin-problem-tp20619506p20621693.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Blaz · November 25, 2008, 1:29pm

Any idea when "The new one which will be shipped as an option for 1.7.1 does
use prepared statements thought. " will be available?
--
View this message in context: http://www.nabble.com/Oracle-plugin-problem-tp20619506p20681197.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Andrea_Aime3 · November 25, 2008, 1:34pm

GeoUser ha scritto:

Any idea when "The new one which will be shipped as an option for 1.7.1 does
use prepared statements thought. " will be available?

In a matter of days I believe. The new plugin should be part of the nightlies as well, but they haven't been build since the day before
yesterday:
http://gridlock.openplans.org/geoserver/1.7.x/

Cheers
Andrea

PS: keep in mind the new one is way more tested "unit testing" wise,
but has got no real usage whatsoever so don't expect it to be
picture perfect.

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.