Hi, I'm starting a new application in java using JTDS jdbc driver
(http://jtds.sourceforge.net) and SQLServer 2005 Express.
I have to design the database from scratch and my doubt is if I have to use
varchar or nvarchar fields to store string data.

Does anyone here use MySQL ConnectorJ to connect to a DB on a remote IP ? If
so, could you please share your code with me to do so. I can get it to
connect to a local machine, but not a remote one. Thanks, Ike

Does it exist?
I need prepared statement like this:
select split(?) from dual
which for parameter like '1 2 3' returns 3 rows

I would like to know what is the difference between the methods
setObject and (setShort, setString, and so on) in PreparedStatement
object.
When should we specifically use the setShort setString methods instead

hi..
we tested a small thing in a unix machine a found out that it takes a
java application 2 minuetes  to open a connection to oracle database
sitting on an other unix machine.. we tried to open sql-plus from the

Through Java, I am attempting to connect to a MySQL 4.12 server on a remote
computer. I can connect fine via php. I cann connect fine via Java, through
a servlet, when the servlet is on the same machine (localhost) as the MySQL
DB.

If I'm writing a fairly simple desktop application, can somebody
suggest what a logical breakpoint is between writing my own classes to
get/set information in a relational database (such as a MySQL database
on the same machine) and using an abstraction layer like Hibernate?

My environment is Windows 2003 Enterprise x64 and Oracle DB 9.2.0.3. My
problem is that I use JDBC to get one resultset from one table which exceeds
1 million records and 100 bytes per record.  I find there are so many page
faults and disk swapping heavy. But the physical free ...

Hi, I have a web service using apache axis/tomcat5.5. The web service
is a simple java bean
that just recieves two strings and updates a database.
I created a JDBC recsource in the container.

Is it possible to instantiate a variable based on the Clob Data Type.
 For example
        java.sql.Clob myClob = new java.sql.Clob().
 Java tells me this isn't possible.