Похожие чаты

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 ответов

5 просмотров

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.

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

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

Ready for some fun AND a chance to win TKO Tokens? Join us for exciting minigames in our Telegram group! 🕒 Don’t miss out—games start on today 25 October 2024, at 8 PM! Ge...
Milkyway | Tokocrypto
255
Добрый вечер. Есть вопрос, а может и предложение. Был у меня диалог в другой группе о делфи и я задался вопросом: "А нельзя ли в делфи цвет //коментария и {комментария} сде...
Kraszx
24
Всем привет! Подскажи, пожалуйста, как передать в TComboBox сразу значение и id записи. На Delphi я делал так: ComboBox1.Items.AddObject('Какое-то значение', Pointer(id запис...
Евгений
13
Мдя, прикол, боевая сборка запускается (именно под отладчиком) после F9 примерно полторы минуты (97 секунд если быть точным). Начал копать - проблема детектится сразу - зависа...
Александр (Rouse_) Багель
38
How are we going bro about the Raids ??
🅿️abby_FX
13
я так понимаю, я так подозреваю, что создание такого плагина для человека, кто умеет писать плагины для делфи потребует минут 5-10 времени. но это мое подозрение. хотелось бы ...
Kraszx
7
Товарищи, кто работа с iphelper? Или может я в самой логике ошибки фигачу, не пойму.... var ifTable : PMIB_IFTABLE; size, corSize: DWORD; Buffer ...
Warfarellen
4
Здравствуйте, вопрос по структурам данных. Были у вас случаи, когда пришлось писать деревья или двунаправленные списки?
/ /
50
Keep saying it, it’s Trump or WW3. Iran will be emboldened if Harris wins by cheating. Israel will have to take the initiative against Iran. How has BTC faired everytime the...
Adz | Ferrum Network Product & Service Consultant @ Ferrum Network
1
Коллеги, добрый вечер. Создаю коллекцию от TFPGMap, ключ - перечисление, значение - целое. Нужно отсортировать коллекцию по значению. Как это можно сделать?
Kirill Filippenok
11
Карта сайта