jdbc mysql

I'm unable to deploy my web app with MySQL 5.5.11 backend to JBoss 5. I get this error: Caused by: java.lang.ClassNotFoundException:…

So I have ~10 million records in an excel file that have to be parsed out in a specific way (I can't just convert to CSV and insert it like that)…

I use com.mysql.jdbc.Driver I need insert and get id. My query: INSERT INTO Sessions(id_user) VALUES(1); SELECT LAST_INSERT_ID() FROM Sessions LIMIT…

I am still newbish to java envelopment as I am mainly a C# developer. I'd like to know how to use or enable connection pooling when I do SQL request…

I have worked on .NET web technologies earlier. Now I am starting to work on JBoss Developer Studio 4 GA. I need to create a seam application. I…

When trying to connect to my local MySQL server via JDBC, I get the following error: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:…

I have been working on a java application that has a connection to a mysql database. I can connect and run queries but when I try to take a string…

I can't seem to find the my.cnf or other config file for the MySQL that comes with MAMP. Does it not include one? I want to use NetBeans for…

I am using the SphinxQL MySQL client which stores indexes as "tables" but has no real notion of a "database"...One specifies the port (9306 in my…

I am curious how com.mysql.jdbc.ReplicationDriver works. I have configuration with 1master & 1slave. I want to force some queries to JUST on…

How do you specify that the JDBC connection to mysql in the typical line DriverManager.getConnection(url, username, password); is via TCP? Thanks

Ok, sorry if this question is stupid. I followed this tutorial: http://www.youtube.com/watch?v=E30_-pQGQXs . Now that I have it compiling in…

This is driving me nuts... What am I doing wrong here? ArrayList<String> toAdd = new ArrayList<String>(); toAdd.add("password"); try{…

this is what i am doing: String[] output = new String[index.length]; try{ for(int i=0; i<index.length; i++){ Statement st =…

I have a big ResultSet (getting from a JDBC query) of few thousand rows. Using each of these rows, I have to instantiate an Object , setting fields…

How can i initialize a 2-dimensional matrix from records coming from a database. I know how to do it in a for loop, but how should id o in such a…

i want to merge two rows and add a column to show the count of similar rows. I don't want to update the table, i just want this as part of select…

I have developed a program where I do some database connections and send some queries with JDBC. I have used MySQL, NetBeans 6.9 under Ubuntu 11.04…

I am executing this query insert into tbl (name) values('Î'); When I execute this query from my application with jdbc then I get following error…

I need to do select * based on a list of input ids, what's the best way of batch select? here's what I have StringBuilder inClause = new…