Zipping Up BLOBs in the Database
HiI am trying to zip up existing BLOB files in the database, and when I do it, it just returns a bunch of unreadable garbage.. I have attached the code below, its a bit complicated, and I was wondering if anyone of you would know what I am doing wrong or is there an easier way to do this? ...
1 answers | 2261 bytes |
zero vs nothing in an integer field accessed with ResultSet.getInt()
I'm currently working with a DB that has int fields with both nothing and zero (0) and the two different values mean different things. No value means no measurements were taken and 0 means a measurement of zero.If I use ResultSet.getInt() on this field I get "0" for both cases. Is there a way ...
12 answers | 399 bytes |
Zero rows returned with JdbcOdbcDriver to MS Sql 2000
This code always returns 0 rows. There is plenty of data in the MS SQL 2000 Customers table.package DBTests;import javax.swing.*;//import javax.sql.*;import java.sql.*;import java.io.*;import java.lang.*;public class DBTests {public static void main(String[] args)//throws SQLException, ...
1 answers | 1566 bytes |
Zero resultset for MYSQL despite data in tables
I've been getting zero for all my query result sets even though my database is not empty. I don't know if the problem lies with my servlet code or my resin deployment. Can someone tell me what's wrong?Here's part of the codes.Login.javapublic class Login extends HttpServlet {final String ...
2 answers | 2419 bytes |
Z/OS Java under WLM stopped working
We are running WBIFN 1.1 on Z/OS 1.4. It uses DB2 V7 at RSU0512. The java runs under stored procedures, was working at install, but now we get:java.lang.ExceptionInInitializerErrorHere are the full messages:DSNX961I DSNX9WLS ATTEMPT TO PERFORM JNI FUNCTION FindClass 576FAILED FOR STORED ...
0 answers | 1411 bytes |
Your urgent help will be very much appreciated
I have a problem whenever I connect my database and need your urgent help. the sample source code is belowimport java.sql.*;import javax.swing.*;import java.awt.*;import java.awt.event.*;import java.util.*;public class Table extends JFrame{private Connection con;private JTable table;public ...
4 answers | 3317 bytes |
Your advice on database access
I have had two semesters of Java, and I also know my way around Microsoft Access pretty well. I want to know is it a good idea to learn JDBC to access MS Access or is it worth to learn another database tool like Oracle's to avoid connectivity problem? My efforts will be strictly for stand ...
1 answers | 454 bytes |
youd think this would be taken care of
using the insert statement in java i have ::INSERT INTO table (FieldName) VALUES ( "'" + StringName + "')");where StringName is string initilased in the .java file.thing is if that contains ' eg if the string is "Hello my name's John" it wont take it bad SQL statementhowever it'll take ...
6 answers | 410 bytes |
Yo! Can I get a lil' help here?
IDE=Forte 3.0DBMS=Oracle 8.1.6.0.0WebServer = IIS 5.0 with JRun 3.1Driver=MS Driver For Oracle (I know! But I'm just learning.)I am trying to execute a simple stored procedure but keep getting an error: "Syntax error or access violation"I have two examples. The one above is the one that does ...
2 answers | 2260 bytes |
Yet Another J Connector Problem Installation
I have JDK 1.4 installed where JAVA_HOME=C:\java\jdk\jdk1.4SET CLASSPATH=C:\java\jdk\jdk1.4\src.zip;.;%CLASSPATH%;I installed and configured MYSQL 4.0.21 work properly with PHP.I get the connecter from MYSQL.com mysql-connector-java-3.1.13.tar.tarUnzipped and get the ...
1 answers | 724 bytes |
Yet Another EJB/JBoss/Datasource problem
This is my first try at creating an ejb. I got that working, and now i'm trying to hook the ejb to a database via a datasource. I know I'm just doing something stupid and missing a tag or an xml file of a java: or whatever. If you can find this probem, I'll be completely in your debt ...
4 answers | 2810 bytes |
YesNo - Type at MS-Access
hello... atm i am programming a front-end to display the inventory of computers.i have to read out of MS-Access database 4 valuescomputerNumber(text), yearOfPurchase(text),price(single) & bought(YesNo) .my problem is : that i don't know how to handle the YesNo from access .,... my ...
3 answers | 671 bytes |
XSQL fails by JDBC
Folks,This XSQL works fine from SQL*plus, TOAD and VB.NET, BUT fails by JDBC driver.Pls help why this is happening. error is pasted below.SELECT inside FROM or Aliases, or what else is causing the problem.ThanksYogi at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)at ...
1 answers | 7696 bytes |
XSQL connections problem on Weblogic
Hi,We wrote a web application using XSQL and Oracle 8.1.7,Struts and JSPs.It worked just fine on Tomcat 4.1 (development environment), but now we are going into production using Weblogic 7.0 SP4 with its connection pool (and Oracle 8.1.6).We have noticed that the number of connections grows ...
1 answers | 607 bytes |
xsd to ddl tool
Hi,Does anyone know of any good tools for taking an XSD schema and using it to generate the DDL for a SQL Server database?Many thanksTariq...
0 answers | 166 bytes |
- XPATH Querying the XML from WebRowSet
- XML validation with DTD file
- xml to DNAList Conversion
- XML result from Oracle database to separate Strings - Oracle XMLType
- xml data into non-xml database.. solution anyone?
- XML attribute
- XML & XPath vs databse & SQL
- XaResource.prepare Method Error
- XML file to oracle via Java
- XML document stored in SQL server
- xml configuration with apache
- XML and SQL
- XA or JTA?
- XA Driver Required for JDBC + Persistent JMS Queue?
- Wrong results with ResultSetMetaData.isWritable()
- Wrong result ?
- Home - About Us - Contact - Privacy Statement - Link Exchange - Bookmark - Map.XML - Rss.Xml
- Copyright 2001-2009 by JAVA TECH Information Technology Co.,Ltd All rights reserved
- 0.563