JDeveloper, Java & XML :: Reset Expired Password On Database?

Jan 2, 2013

I'm trying to write short program to reset password on databases. I'm trying to use OCINewPassword property with following

public void ResetPassword(String sOldPass, String sNewPass) {
this.sCurrent = sOldPass;
this.sNewPassword = sNewPass;
Properties props;
Connection conn = null;


View 4 Replies


Expired Account Need To Open Without Password Reset?

Aug 14, 2013

Account XYZ has expired and we don't know the password of account xyz and don't want reset the password also. How can open account XYZ without change the password?

View 1 Replies View Related

Reset Password - Oracle 9i Developer Database?

Aug 27, 2007

I have an Oracle 9i developer database on my Windows workstation. I havent used it in a couple weeks and forgot my Sysdba login password. how I can reset it or get into the database?

View 6 Replies View Related

JDeveloper, Java & XML :: Best Driver For Java To Oracle Database Connection

Jul 30, 2012

Which is the best driver for java to Oracle database connection ?

View 1 Replies View Related

Security :: User Password Expired?

Nov 11, 2011

i am using a oracle server. And all my users password has been expired, is there any way to recover those users without failing my data.

View 19 Replies View Related

Forms :: Raise Frm-41352 When Password Expired

Jul 20, 2010

we are working to increase the security of our oracle application by adding profil and expiration to all our database username.

Expiration is actually set to 60 days.So if i understand it correctly, 60 days is counting from when i change my password. So if I change it at 10:30am it will expire at 10:30am in 60 days.

Our forms application is calling all forms using the command open_form with SESSION parameter to open all forms in new session.

My problem is when the user connect in the system let say at 9:00am. At 10h30am the password will expire and when the user will click to open a new form from the application he will get the message ORA-28001:the password has expired.The new module will open even if password is expired and will raise the error FRM-41352: Failed to create session. So the module will stay in the same session than the caller.

Is there a way to catch the ORA-28001 and force a new logon.Probably with some code in the ON-ERROR of the called module but this mean that i will have to change +400 forms.

View 1 Replies View Related

JDeveloper, Java & XML :: Offline Database - OAF Or ADF?

Oct 25, 2011

I want to create offline database. there is one custom application i designed but for that need to use internet.

some time there is internet fluctuation. so i want offline db concept to implement . In a day once inter net connect data will get upload and centralize. is it possible by using OAF or ADF..?

View 12 Replies View Related

JDeveloper, Java & XML :: Two Separate Database - Transfer Data

Feb 15, 2011

I have two separate databases, I want to send XML file contains a query from one to the other , that read query and return results to a first via XML file.

View 10 Replies View Related

JDeveloper, Java & XML :: How To Select Node From Oracle Database

Jun 10, 2012

Bla bla bla...............


I wish to generate in my html form like..

PREVENTION: bla bla bla....

Is there any simple way to query out ?

I try

"SELECT T1.root_cause_analysis.query('/RCA/PREVENTION') as RCAXML from Submission_Record.............."

set rx=server.createobject("adodb.recordset")
rx.open sqlxmltest,con,1,3
while not rx.eof

<td ><% response.write rx("RCAXML")%></td>

BUT IT GIVE ME AN ERROR... [ORA-22806: not an object or REF]

View 3 Replies View Related

JDeveloper, Java & XML :: Kill Oracle Database Session From Javascript

Feb 24, 2013

how could we kill oracle database session from javascript/java application.

View 2 Replies View Related

JDeveloper, Java & XML :: Migrating Database From Oracle 9i To 10g - Parsing Failed

May 2, 2011

We are in process of Migrating our database from Oracle 9i to Oracle 10g.

I am getting below error while parsing XML in 10g.

ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00601: Invalid token in: '//soap:Envelope/soap:Header/coHeader/company/text()'

Same code works fine in Oracle 9i database with same XML. Is there any difference in XML TYPE functionality in Oracle 9i and 10g?

View 4 Replies View Related

JDeveloper / Java & XML :: Using Input And Output Stream Updating BLOB In Database

Nov 30, 2011

I have little code that's don't really works.

InputStream is = null;
OutputStream os = null;
Connection conn = null;
Blob value = null;

I know that there is 90% of Java code. But I have few questions:

I know that I can insert date using INSERT. But is it possible that I can use SELECT and JAVA will know that it need to update the SELECTED column ?

View 6 Replies View Related

JDeveloper, Java & XML :: Reading Data From Database Table That Contains Control Characters

May 1, 2011

I have the following bit of code that reads data from the an Oracle table (Note: This is running on Jdk 1.4.2)

ResultSet message = messageStatement.executeQuery(getMsgSql);
String messageData = message.getString("MESSAGE_DATA");

The data in the MESSAGE_DATA column contains text but also control characters that separate data elements in the message (i.e (char)31, (char)29) and (char)28) . What i am finding is that for some reason message.getString() is sometimes truncating the message. I can read the majority of messages but some of them are truncated. Am i supposed to be reading the data using a different method? If so how?

I have tried to use sqlplus to look at the data in the database and it is all there it is just truncated by the message.getString() method. I saw this when i tried to output the result i.e. System.out.println(message.getString()).

I ran an sql query using the length() function in Oracle and length("MESSAGE_DATA") returns 2032 whereas in java message.getString(1).length() returns 2000.

View 5 Replies View Related

JDeveloper, Java & XML :: Convert Complete Oracle Database In Single XML File

Dec 14, 2010

Inspiration of a java program that converts a oracle database to one single XML document?

View 1 Replies View Related

Reset Sys Password With Passwordfile Set To Shared?

Aug 29, 2012

Just trying to figure out a way to reset a lost sys password.The Customer has a database that were configured by the application provider.They were however kicked out and did not leave any kind of documentation behind

they also configured the passwordfile to disable OS (oracle) user to login to the DB.Is it possible to change the password file with orapwd to set a new password for the sys user?I some how recall that it can only be done if the passwordfile is set to exclusive and not as in this case set to shared.

View 3 Replies View Related

User Unable To Login Even After Password Reset

Nov 27, 2012 on Linux

I reset a user password and the user is unable to login as you can see below

[oracle@testdb 10.2.0]$ sqlplus sys/manager as sysdba

SQL*Plus: Release - Production on Tue Nov 27 16:20:21 2012

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release - Production With the Partitioning, OLAP and Data Mining options

SQL> alter user sysman identified by oracle;

User altered.

SQL> Disconnected from Oracle Database 10g Enterprise Edition Release - Production With the Partitioning, OLAP and Data Mining options

[oracle@testdb 10.2.0]$ sqlplus sysman/oracle

SQL*Plus: Release - Production on Tue Nov 27 16:20:32 2012

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

ERROR: ORA-01017: invalid username/password; logon denied

User unable to login even after password reset

View 4 Replies View Related

Security :: User Unable To Login After Password Reset

Dec 14, 2011

We have a production database on version. The application user was prompted to change the password after his password expired.

------------------------------ --------------------------------------------------------------------------- ---------- ----------
M500796 13-DEC-11 PM 100 28001

After changing the password he is not able to logon. The aud$ table does not show any occurrence of 1017, therefore it is not a question of Invalid password.


------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean FALSE

View 2 Replies View Related

Application Express :: Oracle 11g XE - Retrieve Or Reset Password

Dec 12, 2012

I cannot remember my password to access an existing database in Application Express. I tried entering my password 3 times, but the system does not provide a status other than 'Invalid Login Credentials'.

I am going to assume that 3 times is limit before you have to reset the password or from what I see reinstall. When selecting reset, the system asks for an email address that was never established in the system. How can I reset my password without uninstalling and reinstalling Oracle 11g XE?

View 10 Replies View Related

Application Express :: 2 Schemas - Admin Password Reset

Feb 7, 2013

We have 2 apex schemas


Before executing the apxchpwd.sql, found the "alter session command" sets schema to APEX_030000. So we changed that to APEX_040200. Then we executed the sql script. It executed fine.

But now when we try to login to apex, and pressing enter after providing the username/pwd, it raises the following exception

Error Error in PLSQL code raised during plug-in processing.
ORA-06508: PL/SQL: could not find program unit being called

View 1 Replies View Related

JDeveloper, Java & XML :: Using Java.lang.Math In Oracle / ORA-31011 / Parsing Failed

Apr 26, 2013

I am trying to execute an xslt (for XML transformation) using xmltype.transform function.

I can't paste XSLT code here, but below is similar what I am doing.


I have used a reference of random() method of java.lang.Math in xslt file, and it's giving me below error.

ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00607: Invalid reference: 'random'.

I doubt, it's because of "Math" class, which is not present in Oracle, how to load standard java classes.

View 1 Replies View Related

JDeveloper, Java & XML :: Java Stored Procedure Invoking Windows Run Time Process

May 22, 2012

I am trying to invoke program from my local Windows machine (exactly java executor, which is in my environment on c:javajdkinjava) using database package with Java stored procedure.

Everything is fired by SQLPLUS script, this script invokes package with Java stored procedure (jar loaded into Oracle) and that procedure is trying to invoke runtime process (syntax:

c:javajdkinjava -cp

and here ara my classes and main jar) using my local java executor. I added all permissions using dbms_java.grant_permisions (execution forced me to give permissions java.io.FilePermission to <<ALL_FILES>> for execute), moreover I added to my database user JAVASYSPRIV and JAVAUSERPRIV role. Unfortunately, beside this I am still getting error:

C:javajdkinjava not found (Note that lookup with PATH isn't done due to the oracle executable being setuid.)

View 8 Replies View Related

JDeveloper, Java & XML :: Java.sql.SQLException - Execute Batch - Exception Equal To 1?

Jul 14, 2011

I was getting java.sql.SQLException: executeBatch, Exception = 1when i tried to use executeBatch().could not understand why i am getting it.

View 1 Replies View Related

JDeveloper, Java & XML :: Calling Java Stored Procedure From Oracle

Jun 20, 2011

I am writing a java stored procedure in my package. In the java procedure I want to issue a query to be fired on the user table from which I am calling the java procedure.

Some thing like following:

I am logged in to USER1 and my package is inside USER1. From this package I am calling the Java Stored Procedure. In java procedure I want to make a jdbc connection to USER2. The details of USER2(password, hostname,portno) are stored in a table called 'connection_details' and this table is in the USER1.

My problem is how can I issue the


so that i can get the details..?

Do i need to first make jdbc connection to USER1 and then execute the above query for which i need similar details of USER1. How can i obtain the details of USER1 here.

I am thinking if I am already in USER1 then do I need to make the jdbc connection to USER1 and then execute the query?

View 1 Replies View Related

JDeveloper, Java & XML :: Create Or Replace And Compile Java - Getting Ora 29531?

Dec 21, 2011

I've this java source create or replace and compile java source named "Decodificador" as
public class Decodificador {
public static String decodifica(String codigo)
return codigo;

and this function

create or replace function F_Decodificador(codigo varchar2) RETURN VARCHAR2 IS
LANGUAGE java NAME 'Decodificador.decodifica(String) return String';

when I execute the function the result is:

ORA-29531: no method decodifica in class Decodificador

View 8 Replies View Related

JDeveloper, Java & XML :: Call DB Function From Java Hibernate

Feb 10, 2011

I need to call DB function through Java Hibernate.

My Sample XML File looks like.
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
<sql-query name="getchequeno" callable="true">
?:=call cz_nab_mw_fn_gen_ol_chq_no()
I am getting below error while reading the file

"java.lang.RuntimeException: org.hibernate.HibernateException: Errors in named queries: getchequeno"

View 1 Replies View Related

JDeveloper, Java & XML :: How To Pass Any Array From Java To Oracle

Feb 4, 2005

Here is a problem. I have to pass an array e.g ('Account','Marketing',Computer' ) from java to Oracle 9i.

Would I be able to do in Oracle, if yes then how ?

View 11 Replies View Related

JDeveloper, Java & XML :: Native Java In Oracle Versus PL/SQL?

Aug 26, 2011

we can you java code natively with Oracle. But I didn't get how to decide when to use native java in oracle and when to use pl/sql.

View 5 Replies View Related

JDeveloper, Java & XML :: Using PL/SQL Function To Execute Java Class?

May 20, 2013

i`m trying to use pl/sql function to execute java class. I created 2 tables with around 100 values and java class with simple functionality. I need to create function to loop through my table1 and get with each iteration one value from table and pass that value as parameter to java class.

table1 is something like this:

1 name1
2 name2
3 name3
. .
. .
100 name100

table2 is empty with same columns as table1 ( table2 is for data obtained from java returns ) I created in sql+ java class.

import java.io.*;
import java.util.*
public class myClass {
public static String fun(String strName)


Then i wanna make a pl/sql function for:

1)For i = 1 Obtain first value from table1 (column name) and pass it throught java class then return value and save it in table2 with the same id as id from table1

2) change i=1 to i=2 and do that same

3) end if i=101

View 1 Replies View Related

Java Application - Connection Reset During Insert

Jun 6, 2012

I have a java application (jdk 6) that use a db oracle 11g with ojdbc6.jar version on linux.

Sometimes (one or two cases on 11k sql insert on table in one day) I obtain, the error:

java.sql.SQLRecoverableException I/O Error: Connection reset
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:866)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1259)

View 1 Replies View Related

JDeveloper, Java & XML :: Connection Between Java And Oracle

Nov 26, 2012

I Program with Java . when we connect oracle by program ,

Get the following error :

'No suitable driver found for jdbc:orcl:thin:@localhost:1521 '

View 3 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved