Hey guys,
I was working on this school project and I was doing it just as a straight
java swing app connecting to a db.  Anywhose, it appears that it needs to be
webbased.  So, me in all my simplicity, just made the application an applet.

I am very new to java. I have some code that goes like this ...
 <%-- This is the item number of the Image I would like to display --%>
 String st_Catpart = "123ABC";
 <%-- Get Image from Database --%>

 I need to update a CLOB field in a table with JDBC, using Oracle. Here
is the code I have for retrieving the existing value and adding some more
text onto the CLOB:
try {

I am trying to use
while (rs.next())
{...}
but there is one hitch -- it seems that Oracle doesn't want to return false,

We have some complex J2EE applications currently. IN most of the
applications, we need to take thousands of rows data from the database.Then
in the JSPs, we need to paginate them, means 100 rows per page and then next
etc. Each time the connection is established with the database ...

I have a file with all SQL statements e.g :
sql_createuser = INSERT INTO users VALUES(username,password,email)
sql_removeuser = ...
I read the sql statements with the properties get method. But how do I

How do I implement the vertical tab (\v) in a java string
I have tried '\013' and several other patterns from various sites, they all
print a symbols, not a vertical tab
Best wishes,  Jim

I have 2 record in a table name "item" in mysql database, and use
RecordSet to retrieve that 2 record.
i try to get the number of Result using the below method :
result.last()

Does anyone know a couple of databases that can run WITHIN
your java aplication (i.e. embedded) instead of as a separate
service (as for example Mysql)???
I've heard of jdbm... is that the database you would recommend?

Fellow IT Professionals,
I have downloaded and ran the install from Microsoft for the JDBC driver for
SQL Server.  I have also put the 3 JAR files in the CLASSPATH under
environment settings.

On Oracle tables with columns of type DATE:
ResultSetMetaData.getColumnType(colNum) returns 91 which is wrong.
DatabaseMetaData.getColumns()             tells 93 which is right.
Both ResultSetMetaData.getColumnTypeName(colNum) and

I'm using MySQL as database for my java application.I always use ResultSet
to retrieve data from database.
I'm thinking a efficient way to browse the retrieve data from a
JInternalFrame, so it is better to load all data from a table to a ResultSet

I'm trying to store a a long-ish string (approx 2,000 characters) in a
CLOB column in a MySql database, but I can't figure out how to create
a Clob object for insertion.  All the methods assume you already have
a Clob, but Clob is abstract.  All the sample code I've found first

Can anybody recommend a tool that can scan Java code for unclosed
connections. In this specific case I am dealing with pretty messy code
inherited from the predecessor that requires a clean up due to
increasing performance problems.

I am trying to call a stored procedure from ms sql server 2000 but I cant
quite get it working properly.
I have made my initial connection to ms sql and my database stored on it I
am just completely lost when it comes to calling the procedure. I can call