hi all,
Iam new to Oracle Spatial
iam using JBO:Oracle spatial data viewer to display the shape files of the polygons.
iam able to get the manually but iam unable to display the polygon
there is a java file displayManager viz iam getting an error please check the code and answer me back
here iam sending my code
package org.duckham.jbg ui;
import org.duckham.jbc ore.SpatialSet;...
san1014
Last Activity: Apr 25 '08, 10:56 AM
Joined: Jul 24 '07
Location:
-
Oracle Spatial Data Viewer
-
The error is :
The Method setDataSet(Stri ng,SpatialSet,A ppearence) in the type DisplayManager is not applicable for the arguments(Strin g,SpatialSet,Ap pearence) -
Oracle Spatial Data Viewer
hi all,
Iam new to Oracle Spatial
iam using JBO:Oracle spatial data viewer to display the shape files of the polygons.
iam able to get the manually but iam unable to display the polygon
there is a java file displayManager viz iam getting an error please check the code and answer me back
here iam sending my code
package org.duckham.jbg ui;
import org.duckham.jbc ore.SpatialSet;... -
Hello rski
I have re installed the postgreSQL.
Now i'm able to call the pg_dump and pg_restore in cmd, but after calling,when i entered the password it is giving the error
pg_dump: [archiver (db)] connection to database "sandeep" failed: FATAL: password authentication failed for user "sandeep"
When installation i have given password as databaseadminis trator
and the superuser password...Leave a comment:
-
how to declare the cursors in a stored procedural function
Hi
I have few questions.
Pleae give me the answers.
1) In postgreSQL, how to declare and call the cursors in a stored procedural function?
Ex: I want to display all the columns in a table in one cursor
and also how to see the output.
2) tell me , the analytic functions in oracle connect by prior,
sys_connect_by_ path are existed in postgreSQL?
3)how to call the stored procedural function which... -
Ya I'm downloaded from
http://www.postgresql. org/ftp/binary/v8.3.0/win32/.
If i have the pg_dump and pg_restore by default after installation then how to see those.
or else
Please tell me the site where can i get pg_dump and pg_restore, which do buckups and restore database from backups.
Thank you...Leave a comment:
-
Hi rski
thanks for your reply
I have installed postgres(postgr eSQL 8.3) full version only.(In that i got command prompt,pg admin3,psql to postgres).But i didn't get that pg_dump and pg_restore.
Can u please give me the site where can i get all those and also tell me how to use that.
In oracle, to export the data we can use the command as
exp username/password@databa se file=filename full=y -----command prompt...Leave a comment:
-
importing into postgreSQL from oracle
Hi
Where can i get the import and export software for postgreSQL(Full version) and
in postgreSQL how can we write procedures and functions? and
please tell me , how to import the dump file from oracle into postgreSQL.(inc luding procedures)
Thank you -
postgreSQL installation problem
Hi
I have the postgreSQL version 8.3.0-1.
When i am trying to install it on Windows XP, it giving the error as
Internal account lookup failure: No mapping between account names and security IDs was done
I have given the in the service configuration fields as
Account name:san
Account Domain:I
Account password:databaseadminis trator
verify password:databaseadminis trator
... -
how to create control files
Hi
I am using oracle 9i
I want to import the excel sheet data into the database.
i have an excel sheet to import the data into the database in node table.
SQL> desc node
Name Type Nullable Default Comments
----------- ------------ -------- ------- --------
USER_ID NUMBER(6)
SCENARIO_ID NUMBER(9)
... -
problem in writing a Query
Hi,
I have a table
SQL> select * fom temp;
FID TID RN
---------- ---------- ----------
1 2 1
1 3 2
1 4 3
2 1 1
2 5 2
3 1 1
3 6 2
3 7... -
I really confused with this.
If you dont mind can you explain in step wise , what can i do to use UTL_FILE?
Please help me.
Thank ypu...Leave a comment:
-
How can i modify the init.ora file and bounce the server?
Please tell me in detail.
Thank u...Leave a comment:
-
SQL> SELECT VALUE FROM v$parameter WHERE name = 'utl_file_dir';
VALUE
--------------------------------------------------------------------------------
But it is not displaying anything?
Please Help me?
What to do?
Thank u....Leave a comment:
-
problem with UTIL_FILE
Hi
I have created a procedure using UTL_FILE.
Before executing the procedure i created a directory as
[code=oracle]
connect system/system;
grant execute on sys.utl_file to PUBLIC;
alter system set processes=500 scope=spfile;
grant read, write on directory gams to public;
connect san/san;
create or replace directory gams as 'C:\gamsdir';
CREATE... -
How to copy data from one table to another table with where condition
Hi
I have a table, that describes
SQL> desc time_m_details
Name Null? Type
----------------------------------------- -------- ------
STUDENT_ID not null VARCHAR2(25)
SCENARIO_ID not null VARCHAR2(25)
TIME_ID not null VARCHAR2(25)
TIME_VALUE VARCHAR2(25)
In that table one student_id contains many scenario_id's.
student_id(108) contain scenario_id's(1 5,18,19,6)... -
problem in Order By
Hi
I Have a table like this
code=oracle]
sql> select month from temp;
month
-----------
Apr
May
Jul
Jun
dec
Oct
Feb
Nov
Mar
Sep
Jan
Aug
Now i want the o/p like this
sql>select month from temp;
month
----------
Jan
Feb
Mar
Apr
may... -
i hava a problem in charts.
i am having data without equal intervals in x-axis.
I want the data with equal intervals.
please give advice or code.
Thank uLeave a comment:
-
How to build the charts
Hi
I have a table like this
sql> select * from commodity;
commodity_id year value
---------------------- ------- ---------
C1 1996 20
C1 1998 39
C1 2000 45
C2 1990 170
C2 1995 200
C2 2000... -
You have to type the following command in command prompt
C:\Documents and Settings\S>imp usrname/password@hostna me file=C:\xxx.dmp (file location) full=y;
SandeepLeave a comment:
No activity results to display
Leave a comment: