"URI is not hierarchical Error"

One of my colleague was hit with this issue and helped him to resolve.

Check the following to fix this issue.

a. Check the path of your jdevleoper and your project names.
The path of the jdeveloper should not have spaces between then like the example given below.
"c:\Program Files\Jdeveloper\jdev"
or Your project name should not have something like "SOA Samples"
This will create project while deploying the bpel projects.

b. WSDL with multiple namespaces using RPC/Literal didn't work on JDeveloper version 10.1.3.2, but works with 10.1.3.1

Same namespaces may have multiple prefixes in partner link wsdl or wsdls.


Please check on this.

You should be able to fix the issue.

How to get the last row of a table

To get the last row of a table we need to run the below query.

With Table Column:

SELECT * FROM table_name WHERE column_name =
(
SELECT max(column_name)
FROM table_name );

Without using table column:

select * from table_name where rowid=(select max(rowid) from table_name);

Exception in JDBC Java client : "java.sql.SQLException: ORA-01410: invalid ROWID"

I was facing an issue with JDBC Java client which pulls the data from a function in Oracle Database. Whenever i try to get the value , i get exception saying
"java.sql.SQLException: ORA-01410: invalid ROWID",

Then did a small change in the JDBC java client, then was able to fix this issue.
The change that i made on the connection object is as below.
After getting the connection object using the driver manager i made the auto commit option as "False". By doing this i was able to get the value from the database with out any issue.

DriverManager.registerDriver(new OracleDriver());
//Establishing the connection
oracleConnection =
DriverManager.getConnection(thinConn, userName, password);
oracleConnection.setAutoCommit(false);