Skip to Main Content

Integration

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to bypass unicode characters through Siebel Connector?

User_RF21COct 10 2016 — edited Oct 10 2016

Hi,

We are using Siebel Sales 8.1x/8.2x with application Version 16.5.0.0 in Integration with Oracle EDQ 11.1.1.7.4.(29)

We have international data and having unicode characters in Siebel in the Account and Contact Names and they shouldn't be altered.

When using this data to generate keys through Siebel Connector, we are getting the below error and DQMgr batch jobs are getting failed.

ObjMgrLogError1000035af57f71424:02016-10-10 08:54:42(xmlcnv.cpp (1716)) SBL-EAI-00245: Character '0x000b' cannot be represented in XML
GenericLogGenericError1000035af57f71424:02016-10-10 08:54:42

Object manager error: ([0] Character '0x000b' cannot be represented in XML(SBL-EAI-00245) (IDS_XMLCNV_ERR_CONV_NOTXMLCHAR))

How can we bypass these unicode characters for key generation and matching through Siebel Connector without altering the data?

Thanks,

Ravi

Comments

796254
siyi23 wrote:
I have a program which connects to a Oracle Database through JDBC on Ubuntu 7.04 Feisty Fawn; well, it's still trying to do it. The Oracle's release is 10g, so I'm using "ojdbc14.jar" file to connect to it. This jar file is included correctly in the classpath environment variable.
No, it's not. That's what CNF exception is telling you.

Java ignores CLASSPATH environment variable. The right way to add a 3rd party JAR is to use the -classpath option on javac.exe and java.exe.

%
843859
I've been testing several possibilities and I've realized I've forgotten a detail: I'm trying to execute a program compressed in a jar file. When I run the connection-part of my code with the main class it doesn't fail, but when I do with the jar file it cannot find the driver class.

The connection-part of my code is:
//////////////////////////////////////////////////////////////////
import java.sql.Driver;
public class prueba {
static String DB_DRIVER = "oracle.jdbc.driver.OracleDriver";
public static void main(String [] args) {
try {
final Driver driver = (Driver) Class.forName(DB_DRIVER).newInstance();
System.out.println("Todo bien");
} catch (final Exception e) {
System.out.println("Se produjo un error al cargar el driver ["
+ DB_DRIVER + "] de la base de datos.");
System.out.println(e.toString() + "\r\n");
}
}
}
//////////////////////////////////////////////////////////////////

And the prompts I'm running are (Windows version):
java -classpath .;"E:\ojdbc14.jar" -jar prueba.jar
java -classpath .;"E:\ojdbc14.jar" prueba

The first one runs correctly, but the last one doesn't. What is the problem?
843859
I've found the solution in other posts. My problem was that I was trying to specify an extra classpath for a jar execution, but jar executions don't recognise any extra classpaths, neither in the environment variable nor the same command-line. The solution is to copy the files needed to include in the classpath to the jre\lib\ext subdirectory from the jdk directory.
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 7 2016
Added on Oct 10 2016
1 comment
366 views