RE: MI Howto setup Oracle8i Spatial to accept Easyloader data
Thanks to all who helped. Just for the sake of everyone else trying to figure this out, the steps that a person takes to add the mapinfo user to Oracle 8i is outlined in the Mapinfo Professional 5.5 book, on page 382 (Chapter 21). It would have been nice to recap this information in the Easyloader documentation, just for the record. -Justin Akehurst From: James Koennicke [EMAIL PROTECTED] To: 'Justin Akehurst' [EMAIL PROTECTED] Subject: RE: MI Howto setup Oracle8i Spatial to accept Easyloader data Date: Fri, 22 Sep 2000 08:38:11 -0400 Justin, I believe that if you grant the user Bob dba privileges with the admin option, Easyloader will be able to create the MapCatalog without any problem. Something like: Grant dba to Bob with admin option; Hope this helps! James F. Koennicke Engineer/Analyst Vista Information Technologies, Inc. 2195 Fox Mill Road Herndon, VA 20171 email: [EMAIL PROTECTED] ph: (703) 561-4132 fax: (703) 561-4160 -Original Message- From: Justin Akehurst [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 21, 2000 8:28 PM To: [EMAIL PROTECTED] Subject: MI Howto setup Oracle8i Spatial to accept Easyloader data I have an Oracle 8i database with Spatial option, and I am trying to upload data into a table with Easyloader 6.5. I have an oracle user called Bob, let's say, and I can connect to the database with Bob and a password just fine. Easyloader loads up the Tab file, creates a table on the Oracle side, and uploads the data fine. I get a table called 'wakingcb' and a table called 'wakingcb_sx_fl6$' (cause that is what we called the table). Then we get a bunch of errors saying that username/password was incorrect and insufficient priviledges. The skimpy documentation mentions something about a mapinfo.mapinfo_mapcatalog table (which I don't have, since this is a brand new database) and that it would try to create it if it didn't exist. What priviledges/grants/users do I have to make or manipulate to get this data loaded... to me it seems like a user called mapinfo needs to be created in order for this table to be called mapinfo.mapinfo_mapcatalog. Are there any resources that I can read or go to, to make sure that I have Oracle set up right for mapinfo to like my Spatial data? -Justin Akehurst _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
Re: MI MapXstreme Java needs an X server?
From: David Corbin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: MI MapXstreme Java needs an X server? Date: Fri, 22 Sep 2000 14:03:18 -0400 I'm trying to write a small client that just creates a .GIF file. I'm using MapJ. Whenever I call toFile() or toImage(), I get an exception from the MapXtreme Java servlet saying it can't connect to an X Server. Please don't tell me your software requires that X be installed to work correctly. That's not a very effiecient server it it does. This is a limitation brought about by Java 1.2 and how it renders images. The way that people get around this is by obtaining Xvfb from the X consortium (http://www.x.org/) and set the DISPLAY variable to point to that. To invoke Xvfb, use this command (as root) : Xvfb :1 -screen 0 1152x900x8 then do this command as the user you start your server under (assuming you are using a Bourne-type shell): export DISPLAY=":1.0" Starting MapXtreme's server or Tomcat (which will start the server for you) shouldn't have a problem now. Note: If you are running a flavor of Linux, Xvfb is available as an rpm or deb package, if you don't want to compile it from source. It is usually included in a standard installation of X11R6.4 -Justin Akehurst TerraGraphics, LLC _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
MI Howto setup Oracle8i Spatial to accept Easyloader data
I have an Oracle 8i database with Spatial option, and I am trying to upload data into a table with Easyloader 6.5. I have an oracle user called Bob, let's say, and I can connect to the database with Bob and a password just fine. Easyloader loads up the Tab file, creates a table on the Oracle side, and uploads the data fine. I get a table called 'wakingcb' and a table called 'wakingcb_sx_fl6$' (cause that is what we called the table). Then we get a bunch of errors saying that username/password was incorrect and insufficient priviledges. The skimpy documentation mentions something about a mapinfo.mapinfo_mapcatalog table (which I don't have, since this is a brand new database) and that it would try to create it if it didn't exist. What priviledges/grants/users do I have to make or manipulate to get this data loaded... to me it seems like a user called mapinfo needs to be created in order for this table to be called mapinfo.mapinfo_mapcatalog. Are there any resources that I can read or go to, to make sure that I have Oracle set up right for mapinfo to like my Spatial data? -Justin Akehurst _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]