informix « Database Product « Java Database Q&A





1. How to use genxmlquery function of informix using JDBC?    stackoverflow.com

I have the need to extract result of the database query in XML format. I have planned to use JDBC as my programming language. I came across the XML publishing function ...

2. Problem with Informix JDBC, MONEY and decimal separator in string literals    stackoverflow.com

I have problem with JDBC application that uses MONEY data type. When I insert into MONEY column:

insert into _money_test (amt) values ('123.45')
I got exception:
Character to numeric conversion error
The same SQL works from ...

3. How to pass an array object from jdbc code    stackoverflow.com

I have a stored procedure get_data(estargs set(char(1000) not null)) in the informix 11.5 database. I have to use this stored procedure in order to get a value from the database. I ...

4. Ibatis- couldn't get property "weapon" from Null reference    stackoverflow.com

I'm quite new to Ibatis so I might be missing something, but I can't seem to be able to figure out why I'm getting this error. I'm getting this error when I ...

5. Equivalent java datatype to hold the informix DATETIME YEAR TO SECOND value?    stackoverflow.com

I wanted to map the infomix DATETIME YEAR TO SECOND to Java Datatype. Can someone give the corresponding java datatype to hold the informix DATETIME YEAR TO SECOND value? Question is closed This ...

6. Informix and JDBC    coderanch.com

Hi, Iam trying to connect to Informix - IDS 2000 server from the Java example program which I got, when I downloaded the JDBC driver from Informix website. But when I try to run the program using - java demo1 'jdbc:informix-sqli://varadan:1526:informixserver=ol_varadan;user=informix;password=informix' , Iam getting error 'No suitable driver found' as an sql exception. The Class.forName() command executes properly, bit the createStatement ...

7. Informix JDBC    coderanch.com

8. Informix Connectivity with browser.    coderanch.com

9. Informix JDBC, setQueryTimeout    coderanch.com





10. Informix problem    coderanch.com

Hi, I am preparing a site in which i need to provide a functionality to user where user can input the data in japanese language. Its a J2EE based application. My database is informix. The problem is..when i keep the encoding of my page to 8859_1, the characters are inserted correctly in database. But I want the encoding of my page ...

11. Doubt in SET data type in informix?    coderanch.com

Hi, In my application i am using Informix database. In one of my table i have an indicator and a set of values for that indicator. Eg: 4 SET{A,B} i have a varibale X with set of values(e.g. A,B) and a single value (eg. A) in a different variable Y . I want to check whether Y is present in the ...

12. Informix database    coderanch.com

14. setup local informix db as in server    coderanch.com

15. java jdbc informix unload    dbforums.com

Im looking to see if i can get any help on how to execute an unload from my informix database table. Im tryint to execute this code getting a syntax error SQLException: try{ Statement st = con.createStatement(); st.execute( "unload to 'seriesNumericas' select * from serie_prueba_temp "); }catch(SQLException e){ stacktrace : java.sql.SQLException: A syntax error has occurred. at com.informix.util.IfxErrMsg.getSQLException(IfxErr Msg.java:355) at com.informix.jdbc.IfxSqli.addException(IfxSqli.jav ...

16. Informix JDBC problem    dbforums.com





17. Help for Informix database    dbforums.com

hi, i am using informix as the database for my application.There is a utility in informix that is dbschema for getting the schema of tables and procedures. I have to implement this command in java.I have downloaded ifxjdbc.jar,ifxtools.jar. But i dont know whether it is possible to implement through java. plz help me thanks to all of u

18. problem with Informix IDS/PreparedStatement    dbforums.com

Hi! I'm using JDBC (WinNT) to connect to an IDS server from within a JAVA application. I'm getting an SQLException when calling PreparedStatement.setObject(int,Object), parameter is a class that is type-mapped to a UDT and implements java.sql.SQLData. I can read this type from the database, but inserting via a PreparedStatement fails. Error code is -79770 for which I found no documentation, although ...