How To Pass a Collection/List/Map Through the iBatis to the Database?

I am currenly using JSF as the front end of a J2EE application. Data go through many business logic layers and reach the database through the iBatis. The iBatis is new to me. To pass a query "String" from the front end to the database and get a "Collection" back from the database through the iBati

How To Delete A Particular Record From a Table?

Hi, I am new in using database. I have created a table in a MySQL database. I want to delete a record from the "members" table. The record I want to delete is: user_name="John Smith". I tried: MySQL>delete John Smith from members; it does not work. MySQL>delete username='John Smith' from memb

Select Records From the Database

I got "null" after selecting records from a table in the database. The table is created by me. I know how many records will be selected. Just cannot be null. I cannot help wonder if my SELECT statement is correct - I want records to be selected if user_role is equal to the userrole I supplied A

Is It Possible To Change the Value of A Particular Field Manually?

Hi, I am not a database person. I have a database called "members". One of the fields in this database is "user_name". There are a number of records in this database. Under the field user_name, I would like to make some changes manually; for example, I want to change John Doe to john_do

IDENTITY column

Hi, I am a beginner in using database. And I appreciate your support and help. When we first create a table, 1. is it possible to create a column that identifies each record that is to be inserted? 2. If we can create this IDENTITY column, how do we create it? Do we set a maximum to the value

How Do I Insert ...... ?

I have a table 'message' in the MySQL database. To make it simple; say, I have three fields in that table: thread_ID, thread_topic, and thread_body. The thread_ID field is AUTO_INCREMENT; therefore, I do not insert any value into that column. The value of that field starts with 1 when the first

Create Tables In MySQL

Hi, I have several simple questions regarding creating tables in the MySQL. 1. For a variable of Java primitive int type, I should use INT or INTEGER? Do I have to specify the length of the field? CREATE TABLE message_thread( thread_id INT or INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY); 2. A fie

Problem With Creating Table

Hi, I tried to create a table. This table has seventeen fields. My create table syntax gets too long and I was only able to specify 5 fields at the mysql prompt in the DOS window (DOS does not accept a command beyond certain length). How do I put the rest 12 fields in the table I just created?

Primary Key

I saw an example of creating tables (see below). I wonder what the primary key (user_name, role_name) in the table user_roles means? Does it mean that both user_name and role_name are the primary key of the user_roles table? How does a table have two primary keys? create table users ( user_na

Multiple Roles

In case that a user has multiple roles; for example, John Dole is both author and editor, 1. I should have two rows for John Dole? John Dole author John Dole editor or. I should have only one row and use comma ',' to separate the roles? John Dole author, editor 2.

How To Write This SQL Statement

Please help. What is the syntax of idenfying those who "do not" have addresses (in the address field) in the database? __ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online. http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For li

How To Create Users In MySQL?

I have the MySQL-3.23.55 installed in my PC. Therefore, I am the DBA without the required DBA knowledge. First, how do I create users in the MySQL database? Second, how do I grant table creation privilege to users? Is GRANT ALL PRIVILEGES ON databasename TO someuser IDENTIFIED BY 'somepassword';

Conditional Search of the Database

I am learning to query the MySQL database artimus_article. My database is a storage of articles with name of the creator, title of the article, the category in which the article is classifies, , etc. I try to search articles by the name of the creator within the "computer science" category.

How To Create An ArrayList From the MySQL database

I have a table "members" in the MySQL database. I am going to supply a String "editor" and search the "members" table. All those who are "editor" will be picked up and their name will enter the array I want to create. How do I code it and return this array? Here is a sketch of my code. I do n

What Is LIMIT? and How to Use LIMIT?

I saw somebody has MySQL statement this way: StringBuffer sql = new StringBuffer(512); sql.append("SELECT ThreadID, ForumID, MemberName, LastPostMemberName, ThreadTopic, ThreadBody"); sql.append(" FROM " + TABLE_NAME); sql.append(" ORDER BY " + sort + " " + order);