Собственно и вопрос в теме.
Хочу вызвать хранимую процедуру в Oracle и получить результат в виде ResultSet'а.
Вот основной EJB, в котором производится вызов хранимой процедуры.
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
@Override
public ResultSet exec_sql_proc(String call_function, String[] args, String[] in_args){
ResultSet cursor;
try{
String arguments="()";
if(in_args.length>0){
arguments="(";
for(int i=0;i<in_args.length;i++){
arguments=arguments+"?,";
}
arguments=arguments.substring(0, arguments.length()-1)+")";
}
Connection connection = ds.getConnection();
CallableStatement callableStatement = connection.prepareCall("begin ? := "+call_function+arguments+"; end;");
callableStatement.registerOutParameter(1, OracleTypes.CURSOR);
if(in_args.length>0){
for(int i=0;i<in_args.length;i++){
callableStatement.setString(2+i, in_args[i]);
}
}
OracleCallableStatement ocs = callableStatement.unwrap(oracle.jdbc.OracleCallableStatement.class);
boolean bb=callableStatement.execute();
cursor=ocs.getCursor(1);
}
catch(Exception e){
errors=e.getMessage();
return null;
}
return cursor;
}
Вот ещё 1 EJB, который вызывает основной EJB:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
@Override
public ResultSet get_lpus(String find_words){
try{
ResultSet q=workTimeTableFacade.exec_sql_proc("work_time.get_lpu", new String[] {"lpucode","name"},new String[] {find_words});
// В q у нас всё нормально возвращается!
// В следующей строчке происходит исключение!
return q;
}
catch(Exception e){
errors=e.getMessage();
return null;
}
}
А вот код клиента, который вызывает удалённый метод EJB:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
public String get_lpus(String find_words){
NewSessionBean4Remote newSessionBean4=lookupNewSessionBean4Remote();
ResultSet cursor=newSessionBean4.get_lpus(find_words);
...
...
...
}
catch(Exception e){
return e.getMessage();
}
return result_var;
}
Вот какое исключение происходит при попытке вернуть q:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.glassfish.appclient.client.acc.AppClientContainer.launch(AppClientContainer.java:438)
at org.glassfish.appclient.client.AppClientFacade.main(AppClientFacade.java:165)
Caused by: javax.ejb.EJBException: java.rmi.MarshalException: CORBA MARSHAL 1330446343 No; nested exception is:
org.omg.CORBA.MARSHAL: FINE: IOP00810007: Underflow in BufferManagerReadStream after last fragment in message vmcid: OMG minor code: 7 completed: No
at NewSessionBean4._NewSessionBean4Remote_Wrapper.get_lpus(NewSessionBean4/_NewSessionBean4Remote_Wrapper.java)
at remotes_calls.Remote_calls.get_lpus(Remote_calls.java:36)
at applicationclient4.Main.main(Main.java:43)
... 6 more
Caused by: java.rmi.MarshalException: CORBA MARSHAL 1330446343 No; nested exception is:
org.omg.CORBA.MARSHAL: FINE: IOP00810007: Underflow in BufferManagerReadStream after last fragment in message vmcid: OMG minor code: 7 completed: No
at com.sun.corba.ee.impl.javax.rmi.CORBA.Util.mapSystemException(Util.java:267)
at com.sun.corba.ee.impl.presentation.rmi.StubInvocationHandlerImpl.privateInvoke(StubInvocationHandlerImpl.java:213)
at com.sun.corba.ee.impl.presentation.rmi.StubInvocationHandlerImpl.invoke(StubInvocationHandlerImpl.java:152)
at com.sun.corba.ee.impl.presentation.rmi.codegen.CodegenStubBase.invoke(CodegenStubBase.java:227)
at NewSessionBean4.__NewSessionBean4Remote_Remote_DynamicStub.get_lpus(NewSessionBean4/__NewSessionBean4Remote_Remote_DynamicStub.java)
... 9 more
Caused by: org.omg.CORBA.MARSHAL: FINE: IOP00810007: Underflow in BufferManagerReadStream after last fragment in message vmcid: OMG minor code: 7 completed: No
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.sun.corba.ee.spi.orbutil.logex.corba.CorbaExtension.makeException(CorbaExtension.java:248)
at com.sun.corba.ee.spi.orbutil.logex.corba.CorbaExtension.makeException(CorbaExtension.java:95)
at com.sun.corba.ee.spi.orbutil.logex.WrapperGenerator.handleFullLogging(WrapperGenerator.java:387)
at com.sun.corba.ee.spi.orbutil.logex.WrapperGenerator.access$400(WrapperGenerator.java:107)
at com.sun.corba.ee.spi.orbutil.logex.WrapperGenerator$2.invoke(WrapperGenerator.java:511)
at com.sun.corba.ee.spi.orbutil.proxy.CompositeInvocationHandlerImpl.invoke(CompositeInvocationHandlerImpl.java:99)
at $Proxy34.endOfStream(Unknown Source)
at com.sun.corba.ee.impl.encoding.BufferManagerReadStream.underflow(BufferManagerReadStream.java:128)
at com.sun.corba.ee.impl.encoding.CDRInputStream_1_1.grow(CDRInputStream_1_1.java:113)
at com.sun.corba.ee.impl.encoding.CDRInputStream_1_2.alignAndCheck(CDRInputStream_1_2.java:126)
at com.sun.corba.ee.impl.encoding.CDRInputStream_1_0.read_long(CDRInputStream_1_0.java:496)
at com.sun.corba.ee.impl.encoding.CDRInputStream_1_0.readValueTag(CDRInputStream_1_0.java:1810)
at com.sun.corba.ee.impl.encoding.CDRInputStream_1_0.read_value(CDRInputStream_1_0.java:1040)
at com.sun.corba.ee.impl.encoding.CDRInputObject.read_value(CDRInputObject.java:531)
at com.sun.corba.ee.impl.presentation.rmi.DynamicMethodMarshallerImpl$14.read(DynamicMethodMarshallerImpl.java:384)
at com.sun.corba.ee.impl.presentation.rmi.DynamicMethodMarshallerImpl.readResult(DynamicMethodMarshallerImpl.java:483)
at com.sun.corba.ee.impl.presentation.rmi.StubInvocationHandlerImpl.privateInvoke(StubInvocationHandlerImpl.java:203)
... 12 more
Java Result: 1
А что не так-то?
Строки возвращаются, а ResultSet почему-то не возвращается...
