alx7
|
|
1 | |
Create an UDR-procedure in java that will return multiple types data in IDS19.02.2009, 15:06. Показов 1620. Ответов 0
Метки нет (Все метки)
We installed:
IBM Informix Dynamic Server Version 10.00.UC6 JDBC – 3.00 J2SE 1.4.2 On operational system Red Hat 2.6.9-5.EL We create a UDR-procedure in java that will return multiple types data in IDS. We realized java file. We compiled and created the jar. class test { public static int two_return(int i, String s){ i=5; s=”OK”; return 0; } } Then we installed the jar: EXECUTE PROCEDURE install_jar ("file:$INFORMIXDIR/extend/krakatoa/Test_j.jar", "Test_j", 0); Created function for IDS: CREATE FUNCTION test_return (OUT a integer, OUT s char(5)) returns int external name 'Test_jar:test.two_return (int, java.lang.String)' language java; ALTER FUNCTION test_return (ADD HANDLESNULLS); tried call function: SELECT a, s FROM systable WHERE tabid=1 AND test_return (a#integer, s#char(5))=0; result of execution select above, error appears: Error (-937): Cannot find class for type(). LOG: Installing jar test.informix.Test_j... ADDING TO JARMAP: test.informix.Test_j + informix.jvp.dbapplet.impl.JVPClassLoader@5797b5ce PARAM is not NULL Questions: Why appears the error and how to achieve the above-named task? |
19.02.2009, 15:06 | |
Ответы с готовыми решениями:
0
Export data from SQL server (using VB) in new text file and return data Ошибка в классе - multiple types Create Procedure! CREATE PROCEDURE с параметрами |
19.02.2009, 15:06 | |
19.02.2009, 15:06 | |
Помогаю со студенческими работами здесь
1
Incompatible types: 'TNotifyEvent' and 'procedure Искать еще темы с ответами Или воспользуйтесь поиском по форуму: |