How does one convert from a date to an Oracle 8i timestamp and vise versa?
Thanks!

Hello , im new to the database technology and i wanted to ask:
Can the database manager grant a certain user access to several
columns in a table but block the others ?
so if i have name,phone number,address , the address column will be

what would be the preferred one? is there an open source alternative?
thank you
lutz

Hi,
I am learning to create an entity bean to connect to MS Access database. I
use the following method:

  Is there any way I can perform the following code wherein I set a picture
to a blob WITHOUT using a prepared statement? How can you do this operation
below without using a prepared statement? Thanks, Ike
 prepStatement = conn.prepareStatement("UPDATE associates SET picture = ?

we're currently developping a java client that will be used by  800
users on different devices
We would like to use a JAVA database to store the data.
What database would be suited for this task?  (single user, no special

I am storing a date in  a mySQL db in the format 2003-01-01
I have a bean that I use to extract the info from the db but am wondering if
it is possible to manipulate the date into something like 1 Jan 2003 in JSP?
Thanks for any advice

I load the app.DB2Driver as I'm used to load any other DB and do a
DriverManager.getConnection():
       java.sql.SQLException: No suitable driver
I thought I might have to set

Where can I find documents and guides about JSP ?
Consider I know Java, but I don't know anything about servers (like Apache
or Tomcat) or databases.
Thank you all

how to connect Oracle 8.1.7 if dots are inside the defined Servicename.
Sample: SERVICE_NAME from tnsnames.ora is ABC.DEF.GHI.JKL
then the connection string like:
jdbc:oracle:thin:@<host>:<port>:ABC.DEF.GHI.JKL seems does not work.

I get this execption once in a while in my application when some
database operation is to be performed the exception trace is
java.sql.SQLException: System or internal error
java.net.SocketException: Socket closed

I am having an issue with the Informix JDBC driver and wondering if anyone
else has it or has a solution to my problem. I have a method that fills a
preparedstatement with insert SQL ( prepare a Insert statement and then use
setXXX, addBatch() ). At the end of the loop, I perform ...

I'm using JDBC/ODBC to operate on Access DB. I came across an
exception which I hope someone can help me. The sniplets of the code
is something like this with exception, try and catch omitted.
<code>

From: "maatuk" <maatuk@btopenworld.com>
Subject: how to read data dctionnary using Java
Date: 11 September 2003 18:06
hi all

I want execute a procedure from Java but the procedure is very long so it
doesn't goes like this:
..Statement s = c.createStatement();
String sproc = "CREATE OR REPLACE PROCEDURE XYZ......");