[DataDirect][OpenEdge JDBC Driver] Transliteration failed, r

Hi,

I am currently out of the office on and will be returning to the

office on January 3rd. I will be checking email but If you need

immediate assistance please call my cell phone at 503-805-8598 or

contact Jim Stein at jstein@cornerstar.com.

Thanks,

Bryn Dearborn

503-805-8598

--

Bryn Dearborn

503-928-8115 (Work)

503-805-8598 (Cell)

Cornerstar

Hello,

Just some few suggestions.

The first procedure has single quotes (') but it should use double quotes (") since the stored procedure is actually based on Java.

You mentioned about setting "Text file encoding 'to UTF-8". I think that  you may need to play some more with these options

You can troubleshoot compilation errors of stored procedures by looking at the source code of the stored procedure.

When the stored procedure fails to compile, you can find a .java file, for example, LARISSA_KORNOWSKI_TEST01_SP.java in the working directory for the database.

Take a look at the .java file and see if there is something that  seems to be out of place, perhaps, there are unexpected characters. There is also a .lst file that you can check for compilation errors.

Also, you could even launch proenv and then  run javac from the command line. (You need to include the appropriate jar files in the classpath environment variable or use the -classpath option. I do not know the jar files off the top of my head.)

javac LARISSA_KORNOWSKI_TEST01_SP.java

I noticed that in the text of the error message it has "LARISSA.KORNOWSKI_TEST01_SP" instead of "LARISSA_KORNOWSKI_TEST01_SP".

I wonder if this causing the problem.

I hope this helps.

Hello egarcia, a happy new year!

Thanks for your answer.
larissa.kornowski is the user-name in the Connection Profile. And I can thus do not change easily. Can the problem really be at the point?

I changed the quotes:

CREATE PROCEDURE Test01() 
BEGIN
    String message = "Hello World"; 
END 

The first error was:

C:\OpenEdge\WRK1\SQL_3008_3820\LARISSA.KORNOWSKI_TEST01_SP.java:2: '{' expected
public final class LARISSA.KORNOWSKI_TEST01_SP extends JavaBaseSP
                          ^
C:\OpenEdge\WRK1\SQL_3008_3820\LARISSA.KORNOWSKI_TEST01_SP.java:29: '}' expected
^
2 errors

This is the Jar file. In my opinion there is no error:

import com.progress.sql.sp.*;
public final class LARISSA.KORNOWSKI_TEST01_SP extends JavaBaseSP
{
    public void finalize()
    {
        super.finalize();
    }
    
    public int dhTPwrap (SQLDA OLDROW,
                         SQLDA NEWROW)
               throws DhSQLException
    {
        return 0;
    };
    
    public int dhSPwrap (SQLDA input_da,
                         SQLDA output_da,
                         DhSQLResultSet SQLResultSet)
               throws DhSQLException
    {
        if(input_da != null) {
        }
        String message = "Hello World"; 
        if(output_da != null) {
        }
        return 0;
    }
}

I have not changed anything and compiled again in OpenEdge Architect.
Only now is this error:

[DataDirect][OpenEdge JDBC Driver] Transliteration failed, reason: invalid UTF8 data

I have tried all sorts of "Text file encoding", but there is always the same error.

I found out how to create user! I created the user sysprogress. Now when I want to create a procedure that immediately comes "failed transliteration, reason: invalid UTF8 data"-error. I really think the "Error from Java compiler. compilers massage follow. (10 727)"-error was due to the point in the class name.

But how do I get the UTF8-error away?