column « mysql « Java Database Q&A





1. Hyphens in column names in MySQL DB    stackoverflow.com

May be this question has been answered before but I couldn't find it. I am using a 2/3 yr old MySQL database which has hyphens in its column names. When I try ...

2. How to keep Mysql high availability while column datatype & value are changed?    stackoverflow.com

I am looking for a strategy to keep mysql and web service high availability while changing column datatype and value. The scenario is: for example, a student table has columns student ...

3. MySQL-JDBC Question: Can I use the column name as parameter?    stackoverflow.com

Let's say I have a table with 3 columns: C1, C2, C3 I make a search based on the C1 column. Could I make something similar like this (this is not working - ...

4. Mysql Date/Datetime columns and Java persistence    stackoverflow.com

I have a Mysql table with DATE column , default '0000-00-00'. If I try to call, for instance, em.find(MyTable.class,pk_value); and it happens to be a record in database with default date value ...

5. Whats the difference between using out parameters vs. result fetching by column in stored procedures that return a single result called through JDBC?    stackoverflow.com

I know for more than one result, you don't have much choice for using out parameters, but I'm wondering whats the difference between the following 2 cases where there's one out ...

6. MySQL SMALLINT column returns 0 in java.lang.Short when the value is null    stackoverflow.com

I've com across this and I haven't been able to find the proper documentation. Basically I have in a MySQL table a column that is used to hold a year value the ...

7. Problem in reading MySQL column metadata using org.apache.ddlutils    stackoverflow.com

I'm using org.apache.ddlutils package for reading database metadata. I've written something like following:

        Platform platform = PlatformFactory.createNewPlatformInstance(dataSource);
       ...

8. MySQLSyntaxErrorException: Unknown column ' ____ ' in 'field list'    stackoverflow.com

I get the following MySQL exception:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'book.call_Number' in 'field list'.
What does that mean and how can I solve it? Here is the code responsible for this ...

9. I keep getting the error: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column '. . . . ' in 'field list'    stackoverflow.com

Here is my code guys, what am I doing wrong (I am forced to use a regular Statement as opposed to the PreparedStatement class so that I can use mySQL's AES_ENCRYPT/DECRYPT ...





10. rs.getMetaData().getColumnName(i) with aliased columns on mysql    stackoverflow.com

when I have a query result for something like:

select col as newName from table;
and I then do (in java) :
rs.getMetaData().getColumnName(i)
it returns the name of the column instead of "newName"... if however I ...

11. MySQL column containing different Java datatypes    stackoverflow.com

I have a table in my MySQL containing calculated values. At the moment this is a Decimal field. But now I'll need this table to also hold calculated dates, booleans etc. What's the ...

12. How to get a particular column's values alone?    stackoverflow.com

I am using the mysql java connector. I need java to display the contents of the first column and the second column in different steps. How do I achieve this?

String qry ...

13. IDENTITY column in MySQL    coderanch.com

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 of this column? Or the value simply increases as the number of records get inserted into the ...

14. Indexing MySQL columns    coderanch.com

Indexes effectively transfer work from output time to input time, so the answer to your question is yes, the indexes will slow down inserts. It is always a trade-off, and the ideal solution depends on your application. If there are lots of inserts, and they they have to be lightning fast, you might be better of with no indexes and slow ...

16. MySQL AUTO_INCREMENT column not uniform    coderanch.com

I would guess it is because the "missing" ids came when an insert operation failed or was aborted? e.g. the auto_increment functionality was triggered then the insert didn't happen. I don't know how auto_imcrement works in mysql, but it is common for databases to implement primary key generation mechanisms with spaces between the ids. Oracle sequences for example are not uniform, ...





17. MySql + Java // Column not found, message from server    dbforums.com

Hi, i hava a problem when inserting a row in a mysql-table from a java-program. Database and table exists ! Platform: Windows 2000. String url = "jdbc:mysql:///javas"; // javas is the database String sqlQuery1 = "Insert into customer values (" + name + "," + ssNo + "," + address + "," + phone +")"; System.out.println("sqlQuery : " + sqlQuery1); // ...

18. Column Index out of range, 3 > 2 ( mysql error)    forums.oracle.com

flounder wrote: So you have a while loop to iterate through the rows of your resultset. What do you think you need to get all the data from a single row? (which needs to be inside the while loop) So, how can I go to the next row? I could not find any kind of method to specify the row number ...