Menu
▾
▴
Re: [Geoserver-devel] Oracle question
|
From: Gundel, A. <Aar...@sj...> - 2011-03-24 17:01:16
|
Hey Andrea, I had some time and was finally able to get this up and running. (Looks like I just needed to give it create resource permission. Doing this allowed all the tests to finish (in 8 minutes) successfully.) Thanks for helping me this far. In looking through the OracleDateTest, I can see how it would be problematic now. Since the DATE and TIMESTAMP types are functionally equivalent as far as geotools is concerned, wouldn't it be necessary to test both the date and the timestamp in regard to filtering by time, date, and datetime? Aaron -----Original Message----- From: and...@gm... [mailto:and...@gm...] On Behalf Of Andrea Aime Sent: Monday, March 21, 2011 1:37 PM To: Gundel, Aaron Cc: geo...@li... Subject: Re: [Geoserver-devel] Oracle question On Mon, Mar 21, 2011 at 6:28 PM, Gundel, Aaron <Aar...@sj...> wrote: > Hi Andrea, > > I've done the modifications you mention, but I'm still running into issues when I go to run the tests. It looks like the jdbc driver won't connect, it's giving me... Io exception: The Network Adapter could not establish the connection. (So it skips the connected tests) This isn't extraordinarily detailed, I'm guessing it has to do with my oracle.properties file, but I'm not sure. I'll post the stack trace and the file (though I'll have to remove all the actual connection details). Anyone have any ideas? Thanks! Yeah, those property files need some cleanup so that we don't have to type the same info multiple times. Nobody had the time to do that so far, but we can always hope :-) > port=1521 > password=postgis > url=jdbc\:oracle\:thin\:@localhost\:1521\:xe > host=localhost > database=xe > driver=oracle.jdbc.driver.OracleDriver > username=myuser > user=mypassword So mine looks like this: port=1521 password=<thepassword> url=jdbc\:oracle\:thin\:@localhost\:1521\:xe host=localhost database=xe driver=oracle.jdbc.driver.OracleDriver username=<theuser> user=<theuser> see how the username has to be provided twice, but it has to be consistent, and it's two times the same. The password is your database password... do you also like to tease Oracle spatial like me, stating the password is "postgis"? ;-) All the other params have to be customized to your enviroment as well... are you using Oracle XE too? How is your database called? If it's not XE and the db is called "monnalisa" instead of "xe" you'll have to fix both the url and database accordingly. Sorry it's a bit convoluted, we need to keep these files, that are different for each developer, out of svn, and Oracle adds insult to the injury by not allowing us to redistribute the driver in maven repositories. Ah, just remembered another thing. Oracle XE out of the box is pretty unusable even for the task of doing tests because of its very limited number of processes and sessions, you should follow this tutorial and increase both: http://www.markcallen.com/oracle/oracle-xe-tuning And then be patient... running the test suite against Oracle takes ages, it's easily 3 times slower than PostgreSQL/PostGIS: Oracle it's fast in production, but setting up and dropping tables and spatial indexes is glacially slow... Hope this helps 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 333 8128928 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 ------------------------------------------------------- |