The following is probably of little concern for most of us as it does not deal with MI but with MapXtreme Java 3.0. Hope someone can help me anyway. Hereby my problem: Having lat/lon data in an Oracle table, I want to add a layer of symbols (and create a MDF with the Map Definition Manager). But with no success. The database is running on the same machine as the web server (Apache+Tomcat); Oracle is 8.1.6. I am able to run SQLPLUS. I am able to connect to the database and select from the table using JDBC. I am able to define a connection in the Connction Manager (test is successfull). All attempts to get the layer shown in the Map Definition Manager fail. The classes12_01.zip file has been added to the 2 lax files (after lax.jar for lax.class.path). The file has also been added to Tomcat (classpath in tomcat.sh). Here is how I proceed: - Add a layer, Any with X/Y column data - class is oracle.jdbc.driver.OracleDriver - URL is jdbc:oracle:thin:@host:1521:global - user is system and password is manager - table is named aaa and was created as follows: create table aaa (ID integer PRIMARY KEY, X float, Y float); insert into aaa values (1,10,10); insert into aaa values (2,20,30); commit - settings: lat/lon, columns are X and Y, don't render Results are (console stderr): - when accessing locally: com.mapinfo.mapj.MissingPrimaryKeyException: Unable to identify default primary key for table: aaa. A primary key must be identified in the TableDescHelper. at com.mapinfo.dp.jdbc.ey.a([DashoPro-V1.2-120198]) at com.mapinfo.dp.jdbc.ey.<init>([DashoPro-V1.2-120198]) at com.mapinfo.dp.jdbc.xy.f9.<init>([DashoPro-V1.2-120198]) at com.mapinfo.dp.jdbc.xy.XYDataProvider.createDBTableInfoForTable([DashoPro-V1.2-120198]) at com.mapinfo.dp.jdbc.DBDataProvider.getTableInfo([DashoPro-V1.2-120198]) at com.mapinfo.mapj.Layer.getTableInfo([DashoPro-V1.2-120198]) at com.mapinfo.mapj.Layers.a([DashoPro-V1.2-120198]) at com.mapinfo.mapj.Layers.a([DashoPro-V1.2-120198]) at com.mapinfo.mapj.ll.insert([DashoPro-V1.2-120198]) at com.mapinfo.beans.layercontrol.LayerControl.a([DashoPro-V1.2-120198]) ... - when accessing via mapxtreme servlet java.lang.Exception: Syntax error on line 1 at com.mapinfo.util.s.matchtok([DashoPro-V1.2-120198]) at com.mapinfo.util.ParamList.read([DashoPro-V1.2-120198]) at com.mapinfo.util.ParamList.read([DashoPro-V1.2-120198]) at com.mapinfo.util.ParamList.<init>([DashoPro-V1.2-120198]) at com.mapinfo.mapxtreme.client.MapXtremeDataProvider.getTableInfo([DashoPro-V1.2-120198]) at com.mapinfo.mapj.Layer.getTableInfo([DashoPro-V1.2-120198]) at com.mapinfo.mapj.Layers.a([DashoPro-V1.2-120198]) at com.mapinfo.mapj.Layers.a([DashoPro-V1.2-120198]) at com.mapinfo.mapj.ll.insert([DashoPro-V1.2-120198]) at com.mapinfo.beans.layercontrol.LayerControl.a([DashoPro-V1.2-120198]) ... Can someone help me please ? This starts driving me somewhat crazy. Pierre Henrotay Project Manager Siemens Business Services Major Projects Tel. ++ 32 81 559 687 Mob. ++ 32 477 69 93 19 Fax ++ 32 81 559 658 mailto:[EMAIL PROTECTED] (office) mailto:[EMAIL PROTECTED] (private) http://www.siemens.be ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
