JAVA

Home » Data Access, Manipulation & Batch Languages »» JAVA

1
2
3
4
5
6
7
»
»»

problem with Informix IDS/PreparedStatement

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 data...

0 answers | 591 bytes |

problem with Expoting to excel.

Hi all,I need to export the results of query to excel file, but my query returnsmore than 65000 records. I know only how to put it into the first sheet of excel file. Doesanybody knows how to force my data to go to the next sheet after exceeding65000? I am doing this through Java and jsp code.Am...

3 answers | 326 bytes |

problem with db2 and webshpere (characters are truncated)

Hello,i've bmp ejb's on websphere(4 and 5.x) and ibm db2 fp 7. sometimes, when values areupdated via ejb, the value is cut after 10 characters and the last characters show as small boxes.This happens not always, but often with the same column (varchar) in the table.when i make a select...

0 answers | 457 bytes |

Problem with database connection

hi, i have a problem, i'm using classes12.jar to connect to the oracle database. and i get this error "Error connecting: java.sql.SQLException: Io exception: Got minus one from a read call"i checked and every thing is allright(host,port,sid etc)but still....the code is: String driver="or...

9 answers | 694 bytes |

problem with blob

hello,i have a oracle 8.1.7 database. when I insert a file via jdbc 2 into a blob column, it work fine, if the file is smaller than 5700 bytes. if it is bigger, the file is not inserted into the column. how can i enhance the size, which i can store in a blob column? i tried to make changes in th...

0 answers | 407 bytes |

Problem w multiple java forms on same page

A simple java form I use enables visitors to search multiple search engines by picking a search-site (such as google, etc.) from a pull-down menu and then entering the word they want to search in a window, then clicking a "search" button. It works fine, normally, but doesn't work when I hav...

7 answers | 468 bytes |

Problem trying to execute query

I have a class created specially for mysql DB connection (DBUtil.java) and i have a servlet (LoginServlet.java) for login and it is where the query is to be execute. But sadly, it gives me error "NullpointerException" (Error.gif) and point to the line of code "PreparedStatement ps = conn.prepare...

2 answers | 713 bytes |

problem setting up DSN on Win 2000 Professional

Dear All,I am following up a short tutorial on JDBC, from jGuru. It recommends setting up a DSN as it uses a MS Access database file for the excercise. I have the .mdb file stored in a dir C:\mybd. This is what I do to set up DSN on Win 2000...1. Click - Start - Settings - Control Panel2. Doubl...

2 answers | 2103 bytes |

Problem in inserting document into database as a blob object in tomcat server

Hi, I am inserting document into database as a blob. It is inserting successfully but we try to download it is not downloading. The insertion itself having some problem this code used for tomcat serverString SQL_GET_BY_PK ="select document_blob from PMS_Documents where documentId="+ pmskey +"...

1 answers | 698 bytes |

Problem Connecting to AS400 using jt400.jar

Hi All,Im using jt400.jar to connect to AS/400 for some implementation , The DB Properties have been hardcoded in one file from where it will be read . The file looks like this :.....................DRIVER=com.ibm.as400.access.AS400JDBCDriverDATABASENAME=jdbc:as400://157.227.246.4/TARONLUSERID=T...

0 answers | 1022 bytes |

Problem accessing AS400 data from Java

I'm trying to access data on AS400 from Websphere.I'm getting an error COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][AS] SQL0204N "QSYS.NULLID" is an undefined name. SQLSTATE=42704when I try to execute a select statement.Here is the code that I used to get a connection.Class.forNa...

0 answers | 648 bytes |

proble with jdbc - db2connect

I have an application which connect do db2/ os/390 via jdbc - db2connect.Sometimes , some query don't finish, and the ongly method i have is to restart the database... ( the kill thread command doesn't work )has someone an idea ?...

0 answers | 259 bytes |