| SQLJ Error [message #274912] |
Wed, 17 October 2007 12:00 |
sjcp21
Messages: 16
Registered: February 2007
|
Junior Member |
|
|
When I am compiling the code, this is the error I get.
XXCA_CNOTE_FILE1:28: Warning: The column int #1 is not nullable, even though it may be NULL in the select list. This may result in a runtime error.
Here is my code. Coudl somebody please help me. It is new to me.
CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED APPS."XXCA_CNOTE_FILE1" AS
// Purpose: .
//
// MODIFICATION HISTORY
// Person Date Comments
// --------- ------ -------------------------------------------
//
import java.io.*;
import java.sql.*;
import java.lang.InterruptedException;
import java.sql.SQLNullException;
public class XXCA_CNOTE_FILE1
{
public static void getList(String directory,String pay_method)
throws SQLException
{
File path = new File( directory);
String[] list = path.list();
String element;
int v_cnt;
for(int i = 0; i < list.length; i++)
{
element = list[i];
if (element.indexOf("NWCNOT") >= 0 ) // process only CNOTE* files
try{
#sql {
SELECT count(*) INTO :v_cnt
FROM
xxca_cnote1_temp_table
where filename =:IN element};
if (v_cnt != null) {
#sql {insert into xxca_cnote1_temp_table (filename,dir_name,pay_method)
VALUES (:element,:directory,:pay_method)};
}
}
catch (SQLNullException null_exception) {
System.out.println("SQLNullException " + null_exception);
} catch (SQLException exception) {
System.out.println("SQLException " + exception);
}
/* }*/
}
#sql {commit};
}
}
/
Thanks so much.
sunaina
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
