datasource configuration
438970Feb 26 2005 — edited Mar 3 2005hello everyone,
i am working on oracle 10g enterprise edition and application server 10g. i want to see the american data whose datasource name is mvdemo. i imported and get the necessary scripts worked. i lived some problems while adding a datasource via admin page. shortly, i tried to configure the mapViewerConfig.xml file and changed the settings in this file to add a datasource. the new settings like this now:
*****************************
<map_data_source name="mvdemo"
jdbc_host="c-0y5wp0jvd2bf8"
jdbc_sid="orcl"
jdbc_port="1521"
jdbc_user="mvdemo"
jdbc_password="GHZQXP3/pkptW2KuY2bNyT7auS+JUVjo"
jdbc_mode="thin"
number_of_mappers="3"
/>
*****************************
i changed the jdbc_host, jdbc_password and jdbc_user. after starting the server, the password was encrypted automatically. however, some errors are seen on the screen after starting the server. this is the screen after starting the server:
*****************************************
05/02/27 14:44:37 INFO [oracle.lbs.mapserver.oms] oms root path: C:\mapviewer10
12_qs\mv1012qs\oc4j\j2ee\home\applications\mapviewer\web\
05/02/27 14:44:37 Oracle Application Server Containers for J2EE 10g (10.1.2.0.0)
initialized
05/02/27 14:44:37 INFO [oracle.lbs.mapserver.core.MapperConfig] using default co
nfig file: C:\mapviewer1012_qs\mv1012qs\oc4j\j2ee\home\applications\mapviewer\we
b\WEB-INF\conf\mapViewerConfig.xml
05/02/27 14:44:37 WARN [oracle.lbs.mapserver.core.MapperPool] destroying ALL map
maker instances.
05/02/27 14:44:40 WARN [oracle.sdovis.ds.nods] java.sql.SQLException: G/â istisn
as²: The Network Adapter could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:137)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:174)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:286)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:321)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:
414)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:149)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtensio
n.java:31)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:551)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at oracle.sdovis.ds.NativeOracleDataSource.<init>(NativeOracleDataSource
.java:120)
at oracle.sdovis.ds.DSManager.registerOracleJdbcDS(DSManager.java:86)
at oracle.lbs.mapserver.core.MapperConfig.createMappers(MapperConfig.jav
a:613)
at oracle.lbs.mapserver.core.MapperConfig.loadMapViewerConfig(MapperConf
ig.java:1189)
at oracle.lbs.mapserver.core.MapperConfig.loadConfigFile(MapperConfig.ja
va:436)
at oracle.lbs.mapserver.core.MapperConfig.<init>(MapperConfig.java:242)
at oracle.lbs.mapserver.MapServerImpl.<init>(MapServerImpl.java:122)
at oracle.lbs.mapserver.MapServerImpl.<init>(MapServerImpl.java:106)
at oracle.lbs.mapserver.oms$ColdStart.run(oms.java:159)
at java.lang.Thread.run(Thread.java:534)
05/02/27 14:44:40 WARN [oracle.sdovis.ds.nods] connecting to database using jdbc
thin driver...
05/02/27 14:44:41 ERROR [oracle.sdovis.ds.nods] java.sql.SQLException: G/â istis
nas²: The Network Adapter could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:137)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:174)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:286)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:321)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:
414)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:149)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtensio
n.java:31)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:551)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at oracle.sdovis.ds.NativeOracleDataSource.<init>(NativeOracleDataSource
.java:136)
at oracle.sdovis.ds.DSManager.registerOracleJdbcDS(DSManager.java:86)
at oracle.lbs.mapserver.core.MapperConfig.createMappers(MapperConfig.jav
a:613)
at oracle.lbs.mapserver.core.MapperConfig.loadMapViewerConfig(MapperConf
ig.java:1189)
at oracle.lbs.mapserver.core.MapperConfig.loadConfigFile(MapperConfig.ja
va:436)
at oracle.lbs.mapserver.core.MapperConfig.<init>(MapperConfig.java:242)
at oracle.lbs.mapserver.MapServerImpl.<init>(MapServerImpl.java:122)
at oracle.lbs.mapserver.MapServerImpl.<init>(MapServerImpl.java:106)
at oracle.lbs.mapserver.oms$ColdStart.run(oms.java:159)
at java.lang.Thread.run(Thread.java:534)
05/02/27 14:44:41 ERROR [oracle.sdovis.ds.nods] java.sql.SQLException: G/â istis
nas²: The Network Adapter could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:137)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:174)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:286)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:321)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:
414)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:149)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtensio
n.java:31)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:551)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at oracle.sdovis.ds.NativeOracleDataSource.<init>(NativeOracleDataSource
.java:136)
at oracle.sdovis.ds.DSManager.registerOracleJdbcDS(DSManager.java:86)
at oracle.lbs.mapserver.core.MapperConfig.createMappers(MapperConfig.jav
a:613)
at oracle.lbs.mapserver.core.MapperConfig.loadMapViewerConfig(MapperConf
ig.java:1189)
at oracle.lbs.mapserver.core.MapperConfig.loadConfigFile(MapperConfig.ja
va:436)
at oracle.lbs.mapserver.core.MapperConfig.<init>(MapperConfig.java:242)
at oracle.lbs.mapserver.MapServerImpl.<init>(MapServerImpl.java:122)
at oracle.lbs.mapserver.MapServerImpl.<init>(MapServerImpl.java:106)
at oracle.lbs.mapserver.oms$ColdStart.run(oms.java:159)
at java.lang.Thread.run(Thread.java:534)
05/02/27 14:44:41 ERROR [oracle.lbs.mapserver.core.MapperConfig] java.lang.Illeg
alArgumentException: Error creating NativeOracleDataSource.
at oracle.sdovis.ds.NativeOracleDataSource.<init>(NativeOracleDataSource
.java:196)
at oracle.sdovis.ds.DSManager.registerOracleJdbcDS(DSManager.java:86)
at oracle.lbs.mapserver.core.MapperConfig.createMappers(MapperConfig.jav
a:613)
at oracle.lbs.mapserver.core.MapperConfig.loadMapViewerConfig(MapperConf
ig.java:1189)
at oracle.lbs.mapserver.core.MapperConfig.loadConfigFile(MapperConfig.ja
va:436)
at oracle.lbs.mapserver.core.MapperConfig.<init>(MapperConfig.java:242)
at oracle.lbs.mapserver.MapServerImpl.<init>(MapServerImpl.java:122)
at oracle.lbs.mapserver.MapServerImpl.<init>(MapServerImpl.java:106)
at oracle.lbs.mapserver.oms$ColdStart.run(oms.java:159)
at java.lang.Thread.run(Thread.java:534)
05/02/27 14:44:41 WARN [oracle.lbs.mapserver.core.MapperConfig] [Map Server WARN
ING] Konfigâ¿rasyon dosyas²ndan eâ leme veri kaynaâ¡Â² eklenemiyor.(mvdemo)
05/02/27 14:44:41 INFO [oracle.lbs.mapserver.core.MapperConfig] Map Recycling th
read started.
05/02/27 14:44:41 INFO [oracle.lbs.mapserver.oms] *** Oracle MapViewer started.
***
*****************************************
and i am not able to see the demo results on the browser now. please help...
regards