Похожие чаты

Hi guys. I was looking for a place to ask

a couple of questions about a problem I am having with ibatis + java. Is this allowed here? I dont wanna disturb the chat!

2 ответов

6 просмотров

Just ask your problem but please try and show some effort before you do.

.- Автор вопроса
Agent Q | PM me for Paid Support
Just ask your problem but please try and show some...

I was tasked to make some new developments to an already functioning app which uses Java and ibatis (mybatis) plus an informix database. Part of this development consists on calling an already existing SPL which was updated with some new parameters. So this SPL has been in use for quite some time now. I added all the parameters in the XML file where our queries and stuff are, did the Java logic and stuff to add them to the parameter hash map which is the argument for the SPL (as I have done other times)...but, when I want to call the procedure it gives me the following error: class: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [IX000]; error code [-674]; The error ocurred while executing query procedure. Check the {call XXXXX (...)}. --- Check the SQL Statement (preparation failed). --- Cause: java.sql.SQLException: Routine (XXXX) can not be resolved.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in xml/xxxx.xml. I don't think I can post code because it's probably confidential or something like that, so that's why I am not attaching the whole log (names and stuff like that). However, my workmates checked the SPL logs and they told me that Java wasn't even calling it so the error is right before the call. It's probably good to know that when a param #param# is empty, we send it as NULL. Before adding the new parameters the app executed this same SPL and it worked like a charm. I've searched on Google and stack, there are plenty of similar questions but none of them gave me a useful answer. Google said that this error means three things: bad number of params No permissions. Bad params types. I have checked the 1 and 2 stuff and I am pretty sure these are not the problems. I don't think the third option is the problem, because I have tried to do a hard-coded xml call with call xxxx (NULL, NULL...)(everything as null to avoid problem with variable types) and it keeps throwing me the error. Of course, I checked the Java logs and show that the params were correctly formed (they are mostly amounts with a couple decimals and some strings, I already checked the syntax of decimals and stuff like that)and the number was correct. So I copied the call from the log to my SQL workbench and it worked! But copying that same call into the xml file and trying to execute it through Java fails. So the question is: can you think of any other thing that may be causing the problem? The XML file with the SQL compiles, so it's not a syntax error either.

Похожие вопросы

Обсуждают сегодня

Господа, а что сейчас вообще с рынком труда на делфи происходит? Какова ситуация?
Rꙮman Yankꙮvsky
29
А вообще, что может смущать в самой Julia - бы сказал, что нет единого стандартного подхода по многим моментам, поэтому многое выглядит как "хаки" и произвол. Короче говоря, с...
Viktor G.
2
@Benzenoid can you tell me the easiest, and safest way to bu.y HEX now?
Živa Žena
20
This is a question from my wife who make a fortune with memes 😂😂 About the Migration and Tokens: 1. How will the old tokens be migrated to the new $LGCYX network? What is th...
🍿 °anton°
2
30500 за редактор? )
Владимир
47
а через ESC-код ?
Alexey Kulakov
29
What is the Dex situation? Agora team started with the Pnetwork for their dex which helped them both with integration. It’s completed but as you can see from the Pnetwork ann...
Ben
1
Гайс, вопрос для разносторонее развитых: читаю стрим с юарта, нада выделять с него фреймы с определенной структурой, если ли чо готовое, или долбаться с ринг буффером? нада у...
Vitaly
9
Anyone knows where there are some instructions or discort about failed bridge transactions ?
Jochem
21
@lozuk how do I get my phex copies of my ehex from a atomic wallet, to move to my rabby?
Justfrontin 👀
11
Карта сайта