Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-28267: Invalid NameSpace Value Using DB Link

Hi ,

Getting the
ORA-28267: Invalid NameSpace Value
RA-02063: preceding line from dblink12

I am trying to access the dblink through a datasource and I am using a managedBean in session scope to do it.

The code for accessing db link through managed bean is ,

Connection con = new ConnectionHandler().getConnection();
String sql = " select name from table@dblink12";
Statement stmt = null;
ResultSet rs = null;
String retValue = null;
try
{
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
SelectItem item = null;
if (rs.next()) {
retValue = rs.getString("name");
}
}
finally
{
ConnectionHandler.close(rs, stmt, con);
}
System.out.println("retValueARU: " + retValue);


It works when I am trying to run through jDeveloper but not in the standalone weblogic installation.

Any help will be appreciated.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 9 2010
Added on Jul 12 2010
0 comments
811 views