mysql 4 « mysql « Java Database Q&A





1. Netbeans + Mysql Workbench    forums.netbeans.org

So i created a database using Mysql Workbench, and connected it with NetBeans. Everything seemed to be working perfectly. Now i wish to create a desktop application with the detail area as table. However the option is disabled. I have two tables, one of them containing a foreign key. The schema set for both the table is UTF-8 Default. And Engine ...

2. NetBeans IDE not recognizing MYSQL Database    forums.netbeans.org

Friends, I have NetBeans 6.9.1 and MySQL 5.5. I am able to access my database from command prompt. But when I try to right-click on Services option in NetBeans IDE it is not displaying the MySQL option at all. Please help how to get this sorted as I am not able to use the IDE without the database connection. Thanks with ...

3. HOW TO ADD IMAGE/PICTURE OF SOMEBODY TO MYSQL DATBASE    forums.netbeans.org

I am writting a database program for a college. I need to add The picture of every student to their data/record. I need your help on how to do this. I am using MYSQL SERVER 5.0 to store the DATA/RECORD. My questions are 1.) What is the data type for the Column that will store the image? 2.) I need a ...

4. How to access a MySQL database    forums.netbeans.org

I want to connect a java web application to a MySQL database. The database is on a linux server which requires a username and password. From there I also have to type in a command and give another username and password to access the actual database. How would I connect my web app to this database?

5. Design issue with MySQL and JAVA    forums.netbeans.org

I have written a JAVA program that looks promising. (At least to me!) I wanted to create a simple MySQL database on my Website so that when the program is being run it could do a search from anywhere via the net. The data is dynamic so a local copy will not work. I created the database last weekend and put ...

6. Little confused about JDBCJobstore with MYSQL    forums.terracotta.org

Hello, I found quartz 2 week ago. I have implemented it with my small project with RAMJobstore. But now want to work with JDBCJobstore connecting mysql. I have searched on www. But not found any suitable method to doing it. Please tell first which libraries are required for database. I am using comm.collection 3.2.1. Quartz 1.6.5. And now want to integrate ...

7. Quartz within JasperServer skipping scheduled jobs - replicated mysql    forums.terracotta.org

I am running JasperServer community edition version 3.7. This application uses Quartz packaged in quartz-1.5.1-jaspersoft.jar Not sure what they may have done to it that caused them to re-package. I have setup a simple report through the JS UI to run every 2 minutes. In my test environment, everything runs fine, however in my production environment, it misses the run very ...

8. JDBC & mysql & Graphs Results    jmeter.512774.n5.nabble.com

Hello All, I am trying to configure Jmeter to do load test on a remote mysql server. jmeter is install on an XP machince and mysql is on a redhat. jdbc connection.jar file is in the "lib". I have grant remote access on the mysql server, open the 3306 ports as well. It "looks" like the test plan is o.k, but ...

9. JDBC MySQL and SNMP    jmeter.512774.n5.nabble.com

It appears that the 2.1.1 JDBC Sampler does not work with MySQL. I get an SQL exception (below) with MySQL JDBC 3.1.8. This same Jar / config works with 2.0.3. Also, is there current SNMP support in JMeter? Where would I start if I wanted to implement it? Thanks TE 2006/06/05 16:18:26 INFO - jmeter.engine.StandardJMeterEngine: Running the test! 2006/06/05 16:18:26 ...





10. Load Testing the MySql Database    jmeter.512774.n5.nabble.com

JMeter - User - Load Testing the MySql Database JMeter JMeter - User Load Testing the MySql Database Classic List Threaded Locked 16 messages Jatin Davey-2 Reply | Threaded Open this post in threaded view | Report Content as Inappropriate Load Testing the MySql Database Hi All I want to ...

11. java.rmi.ConnectException + mySQL    coderanch.com

12. jdbc and mysql    coderanch.com

Here is the generic connect to database code: public boolean connectToDatabase() throws IOException { InputStream is = getClass().getResourceAsStream("db.properties"); try { dbProps.load(is); } catch (Exception e) { throw new IOException("Could not read properties file"); } try { Class.forName(dbProps.getProperty("db.driver")); } catch (ClassNotFoundException e) { String reason = "Could not register JDBC driver. Driver class name: " + e.getMessage(); System.out.println(reason); return false; } catch ...

13. MySQL vs Access    coderanch.com

I just found out MySQL is free so I am getting it. If I use it instead of MS Access for my site will it be faster? Or would the change be unnoticeable because my server uses a 56K modem connection? My servlets create a new connection for each request. MySQL is available on many platforms so I guess that is ...

14. SQLException with IE, MySQL, and JDBC    coderanch.com

15. mySQL INTEGER == LONG in Java and ....???    coderanch.com

I have a program that creates a table as follows: stmt.executeUpdate( "CREATE TABLE COFFEES (" + "Entry INTEGER NOT NULL, " + "Customer VARCHAR (20) NOT NULL, " + "DOW VARCHAR (3) NOT NULL, " + "Cups INTEGER NOT NULL, " + "Type VARCHAR (10) NOT NULL," + "PRIMARY KEY( Entry )" + ")" ); Notice that this is using MySQL ...

16. Mysql    coderanch.com





17. Postgres or MySql?    coderanch.com

18. default port in MySQL    coderanch.com

19. using mysql    coderanch.com

20. MySQL configuration problem    coderanch.com

Hi, I just installed the mysql server and client. It works fine from the shell. I also downloaded a jdbc driver for it. The driver is in /root (I'm using linux) so I added it to my classpath. I've been referring to JavaProgramming on Linux. There is a phonebook program in there. Within the program, it uses the following to open ...

21. JDBC & MySQL first time set up?    coderanch.com

22. Store Vector in MySql database    coderanch.com

If you're going to serialize, store the result as binary data. Never, ever, store the stuff as a string (or char(N) or varchar(N) or nchar(N) or nvarchar(N) or varchar2(N) or text or any other character-based data type). Character data can be subjected to character set conversions and what have you, and you can never be sure that the random binary goo ...

23. Newbie Java MySql question    coderanch.com

I am new to java (about 6 months). I downloaded the MySql and am running the Server (MySqlD) on my Win98 computer. I can run MySql and all works fine when I input commands by hand. I want to now create a java program that will open an existing database and insert some records. Can anyone provide a quick source code ...

24. JDBC and mySQL    coderanch.com

Hi, 1.)I think the first error lies in you Class.forName() line of code . it must be Class.forName("org.gjt.mm.mysql.Driver"); 2.) I think the insert statement u are using must be like st.executeUpdate("INSERT INTO PROJECT VALUES('"+fName+"', '"+lName+"', '"+emailAddress+"', '"+idnumber+"', '"+pWord+"')"); 3. try giving the connection like DriverManager.getConnection(url,"",""); try changing all these see if it works if u can post the error too that ...

25. mysql rm: cannot unlink `/tmp/mysql.sock': Operation not permitted    coderanch.com

Hi , there are more than 120 user in using the linux server Debian in my university. and I'm not allowed to touch the /root account of the Debian server. But I would like to install mysql in my own account called "jonny" in order to communicate with JDBC and JSP(TOMCAT) I using mysql-3.22.32 version( source - tarball ) /home/jonny/temp% ./configure ...

26. mysql help    coderanch.com

27. Auto-Create Bean From mySQL DB?    coderanch.com

Anyone know of a tool that will create beans from a database schema such as mySQL? What I'm after is a tool that can take a mySQL database and all it's tables and generate skeleton Insert, Update, Select, and Delete methods as well as all the get/set methods for each field. Any ideas out there?

28. Mysql and JDBC problem    coderanch.com

29. Has anybody worked with MySQL?    coderanch.com

30. MySql help needs    coderanch.com

31. Waht is Replication in mysql?    coderanch.com

32. MySql or Cloudscape?    coderanch.com

33. Unjarring mm.mysql....jar    coderanch.com

34. Problem running MySql    coderanch.com

My system in my lab is a Sun Sparc SunBlade 100. I am running Win2K *inside* Solaris 8 on this machine. I downloaded mysql-3.23.49-win.zip and installed under the Win2K system. Every time, when I run mysql.exe at c:\mydql\bin, I get such an error message. ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) I run the same version of MySql ...

35. How to get authorized using MySql?    coderanch.com

36. Resin MySQL    coderanch.com

37. MM.mysql    coderanch.com

38. URL for MySQL database    coderanch.com

39. org.gjt.mm.mysql    coderanch.com

Hi, I put mm.mysql under /var/tomcat4/lib. I have a test file which has the same setting on win2k and the following program runs fine, i.e. jsp can connect to mysql under win2k. However, when I used the same file and database, it did not work under linux box. Why and how should I fix it? Here is the program: Employee ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>40. <a href='http://www.coderanch.com/t/297556/JDBC/java/mysql-web-server'>mysql on web server ? ?</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>Thank to you all... I have mysql working extraordinally on my tomcat. Now I am trying to attack the big one. deploying the code on a web server. I have a blanc page display when I am trying to request the database with a servlet. I think that the errors is in the URL here is how I made the connection. ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>41. <a href='http://www.coderanch.com/t/297653/JDBC/java/Access-mysql'>Access -> mysql</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>Hi there, I want to switch from access to mysql but I don't know how to do it :| I'd be really grateful if someone could explain me step by step how to perform this task. Right now Im using "dnsless-connection" and that is the way it should be with mysql. static String dir = System.getProperty( "user.dir" ); static String conString="jdbc ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>42. <a href='http://www.coderanch.com/t/297729/JDBC/java/help-configuring-MySQL'>need help configuring MySQL</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>hi there, i want to use MySQL as my database for my aplication which runs with Tomcat 4.04. the database has been created but i cant seem to get y tomcat running. ive updated the server.xml file accordingly for my tomcat. this what i added : <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" driverName="org.gjt.mm.mysql.Driver" connectionURL="jdbc:mysql://localhost:3306/dbo?user=alit;password=wrox" userTable="users" userNameCol="username" userCredCol="password" userRoleTable="roles" roleNameCol="role" /> it gives me an ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>43. <a href='http://www.coderanch.com/t/297770/JDBC/java/MySQL-Connector'>MySQL Connector/J 2.0.14</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>44. <a href='http://www.coderanch.com/t/297796/JDBC/java/mysql-incomplete-insertions'>mysql & incomplete insertions!</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>While working on a cattle drive assignment, I've encountered this phenomenon: When inserting a row of data into my table from a html form, two of the fields do not show up at all. I'm not sure why these two fields aren't showing up because from what I can see, I'm handling the code for all 6 fields in each row ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>45. <a href='http://www.coderanch.com/t/297800/JDBC/java/simple-mysql-questoion'>simple mysql questoion</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>Thanks Hartmut Still having problems. I can't figure out where I have to put the dump. Do I place it in the bin directory ? I tried a few of the commands and couldn't seem to progress. At the sql prompt what command should I use ? The batch file is called backup.sql Thanks for your help in advance </p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>46. <a href='http://www.coderanch.com/t/297834/JDBC/java/MySql'>About MySql</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>Hi Andres, Thanks for the reply, Let me make my questions more clear. I want to choose an open source RDBMS that could be used for a medium level banking project. So I am looking for a ANSI-SQL complaint RDBMS server which is Open Source. I was suggested three choices and I have some questions about them: 1.MySQL - Is it ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>47. <a href='http://www.coderanch.com/t/297935/JDBC/java/JDBC-MYSQL'>JDBC with MYSQL</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>48. <a href='http://www.coderanch.com/t/297971/JDBC/java/mm-mysql-vs-Connector'>mm.mysql vs Connector/J...</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>49. <a href='http://www.coderanch.com/t/298017/JDBC/java/MySQL-charset'>MySQL and charset</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>50. <a href='http://www.coderanch.com/t/298116/JDBC/java/mysql'>mysql</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>51. <a href='http://www.coderanch.com/t/298119/JDBC/java/Clob-MySQL'>Clob and MySQL</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>52. <a href='http://www.coderanch.com/t/298130/JDBC/java/Setting-up-user-name-MySQL'>Setting up user name in MySQL problem</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>I'm Trying to connect to MySQL DB. This is part of the code I'm using to this: ..... con = DriverManager.getConnection("jdbc:mysql://localhost/wrox ?user=username&password=user_password"); ..... When I run the code I get: Invalid authorization specification: Access denied for user:'username@localhost' (using:YES) I realize I have to replace 'usename' and 'user_password' in the code for names I have defined. I don't have a problem with ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>53. <a href='http://www.coderanch.com/t/298132/JDBC/java/set-administrative-user-MySQL'>How to set administrative user in MySQL?</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>Gregg, Thanks for the feedback. I'm using the user name 'root' and I have set up a password for this username. I use this user name and passworrd in my JDBC coding and it connects up to the DB fine. I'm just a little confused as to how to put the user name and password onto the command line - so ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>54. <a href='http://www.coderanch.com/t/298146/JDBC/java/Setting-up-JDBC-MySQL'>Setting up JDBC with MySQL</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>The classpath tells both the java compiler and the VM where to find additional API's/Libraries, whatever you want to call them. When you put your Connector/J Driver in your classpath, all that did was add another search path so that when the compiler or the VM needs these libraries, it knows where to find them. What JDBC does is use Reflection ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>55. <a href='http://www.coderanch.com/t/298159/JDBC/java/xml-document-mySQL-database'>xml-document into mySQL database ?</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>Hi there ! I want to store a xml-document into a mySQL database and I don't have a clue how to solve that problem. I found some postings with similar topics in here but as I'm very inexperienced with all that inputStream stuff (in that postings people spoke much about "writeAsciiStream" and so on ...) the explanations given there didn't help ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>56. <a href='http://www.coderanch.com/t/298180/JDBC/java/mysql-jdbc'>mysql and jdbc</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>57. <a href='http://www.coderanch.com/t/298232/JDBC/java/Mysql-conncections-won-close-please'>Mysql conncections won't close, please help!!</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>Hi, I am struggling to close mysql connections from my application. As the application continues, more and more connections (threads) open until I get errors back from mysql. I close the statement and resultset and dereference everything, but the connections increase until i kill the class itself. The class runs in a thread and just loops continously doing some housekeeping on ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>58. <a href='http://www.coderanch.com/t/298260/JDBC/java/mysql'>mysql</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>59. <a href='http://www.coderanch.com/t/298301/JDBC/java/which-port-mySQL-running'>How to tell which port mySQL is running on?</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>That's the default port, but it might not be running on that port. You can't find out in the JSP (without scanning all the possible ports -ugh) what port it's on. Instead, go directly to MySQL (through the command-line interface) and check what port - or look in: /etc/my.cnf (on Unix/Linux) C:\WINNT\my.ini (on Windows) If it doesn't list anything, or that ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>60. <a href='http://www.coderanch.com/t/298307/JDBC/java/MYSQL'>MYSQL Question...</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>Yes, I know this is a Java forum, but it's the best forum out there, so I thought I'd ask: does anyone know if you can add non-foreign key constraints to a column in mysql? In SQL Server I can add a constraint which says that a column's data cannot include "@" for example. Does this exist in mysql? </p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>61. <a href='http://www.coderanch.com/t/298322/JDBC/java/mysql-javawebserver'>mysql and javawebserver</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>62. <a href='http://www.coderanch.com/t/298345/JDBC/java/mysql-jdbc-driver'>mysql 4.x/ jdbc-driver</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>63. <a href='http://www.coderanch.com/t/298350/JDBC/java/why-incorrect-data-mySQL'>why i get the incorrect data from mySQL????</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>I want get data from mySQL. mySQL's table as following: +---------+--------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+--------------------------+------+-----+---------+-------+ | article | int(4) unsigned zerofill | | PRI | 0000 | | | dealer | char(20) | | PRI | | | | price | double(16,2) | | | 0.00 | | +---------+--------------------------+------+-----+---------+-------+ my table ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>64. <a href='http://www.coderanch.com/t/298557/JDBC/java/mysql-connecton'>problem with mysql connecton!</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>You mentioned that this is a problem when "executing" a servlet. So, this must be a runtime problem. The JAR file needs to be "locateable" by your Servlet container. So, you probably want to add the JAR file to the lib folder of your web application. Or, for example, with a default installation of Tomcat, you could add it to the ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>65. <a href='http://www.coderanch.com/t/298569/JDBC/java/Hypersonic-vs-MySQL'>Hypersonic vs MySQL</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>Hi, We use JBoss 3.0.6 and now we are at a stage to decide about the database to use. Our project is a mid-size one and we being limited on funds we would be leaning more towards the open source tools. We narrowed down to MySQL. I tested my application with MySQL and Hypersonic(the one that ships with JBoss) I noticed ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>66. <a href='http://www.coderanch.com/t/298856/JDBC/java/Do-Remove-Users-MySQL-Database'>How Do I Remove Users From MySQL Database?</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>1. Use the REVOKE command as detailed in the mysql docs http://www.mysql.com/doc/en/GRANT.html An advantage of this is that the changes are noticed immediately, however the user is still in the table (but if you 'REVOKE ALL PRIVILEGES', then they have no rights). 2. Go to the tables (and if you've granted btoh global and database privileges, there will be more than ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>67. <a href='http://www.coderanch.com/t/298981/JDBC/java/Trouble-spaces-mySQL'>Trouble with "@" and spaces in mySQL</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>Hello, I'm using a servlet to write records to a mysql database running on my server. The problem i'm having is that everytime the servlet hits a space or an "@" symbol it kicks me back an SQL exception. Is there a certain data type i should use in mySQL or do i just have to parse all the text boxes ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>68. <a href='http://www.coderanch.com/t/299064/JDBC/java/mysql-autocommit'>mysql autocommit</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>ya, sorry that i did not give the details I am using the "org.gjt.mm.mysql.Driver" class as the driver and my application requires to connect to the "mysql" database, create a new database as given by the user and create a new user , grant privileges to the user on the new database, and then exit the application. here i am working ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>69. <a href='http://www.coderanch.com/t/299079/JDBC/java/mysql'>mysql</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>Hi all, I remember doing this at uni but I cant remember how. I am creating a database in mysql and entering all of the commands. I wanted to put these in a file and then execute the file. Just incase I have to move the site to another machine later on. I have created a file called lodge.sql it contains ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>70. <a href='http://www.coderanch.com/t/299168/JDBC/java/Create-User-MySQL'>How To Create User In The MySQL?</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>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'; the correct command? Thanks for your guidance. [ September 10, 2003: Message ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>71. <a href='http://www.coderanch.com/t/299172/JDBC/java/mySQL'>mySQL question</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>72. <a href='http://www.coderanch.com/t/299175/JDBC/java/Snaq-DBPool-Mysql-Communication-Link'>Snaq DBPool, Mysql Communication Link Failure</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>I'm using the DBPool package with a MySQL db under Struts and Tomcat 4.1 with the following settings in the properties file: drivers=org.gjt.mm.mysql.Driver logfile=dblog.txt local.url=jdbc:mysql:/localhost/billblac_recovery local.user=billblac_bill local.password=wgb local.maxpool=20 local.maxconn=20 local.expiry=0 local.name=recovery local.debug=true I'm getting the following error message intermittently on the host's linux server. I don't get the error on my Win2000 desktop under development: UserFactory.searchReturn() - EXECUTING STATEMENT UserBeanCommandFactory.searchReturn() sqlException: ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>73. <a href='http://www.coderanch.com/t/299349/JDBC/java/create-new-DB-MySQL-JDBC'>How 2 create a new DB with MySQL and JDBC</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>In my project, a requirement is to search if the database exists, if not, the program must create it... I've wrote a generic abstract class that creates a db, i've called DBCreator, then subclasses have the work of create the particular dbase using "CREATE table" SQL sentences... Ok, all of this works, but only if the database exists and has an ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>74. <a href='http://www.coderanch.com/t/299463/JDBC/java/MYSQL'>MYSQL question URGENT</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>I have a SELECT statement that looks like the following: SELECT * FROM products LEFT OUTER JOIN grouping ON (products.itemNum = grouping.itemNum) LEFT OUTER JOIN english ON (products.itemNum = english.itemNum) WHERE products.category = pictures AND products.subCategory = framed GROUP BY grouping.groupingWith ORDER BY products.displaySequence; Can ayone tell me how I can incorporate a aggregate function into this select so as to ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>75. <a href='http://www.coderanch.com/t/299483/JDBC/java/type-MySQL'>what type of MySQL</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>To be able to run Java Servlets and Java Server Pages, I have installed in my PC the following softwares below: - OS=Windows98 - Tomcat v. 4.1.27.exe - J2SE/JDK v. 1.3.1 I am now studying Integrating Web Application With Database, for this reason, I have to install the MySQL in my PC. There are things to consider in choosing the type ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>76. <a href='http://www.coderanch.com/t/299507/JDBC/java/JDBC-MySQL'>JDBC and MySQL</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>A few other hints. You can get the JDBC drivers here: Connector/J 3.0. Make sure that you put the driver JAR file where your JDK/JVM can find them. To connect, you'll do something like the following: // Connect to MySQL and run some tests ... public void testMySQL() { Connection conn = null; Statement stmt = null; try { Class.forName("com.mysql.jdbc.Driver"); conn ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>77. <a href='http://www.coderanch.com/t/299508/JDBC/java/mySQL'>mySQL</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>A few other hints. You'll need the JDBC drivers: Connector/J 3.0. Make sure that you put the driver JAR file where your JDK/JVM can find them. To connect, you'll do something like the following: // Connect to MySQL and run some tests ... public void testMySQL() { Connection conn = null; Statement stmt = null; try { Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection( ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>78. <a href='http://www.coderanch.com/t/299519/JDBC/java/ACCESS-MySQL'>ACCESS To MySQL</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>Ok! The how do you do a search in mySQL. Let's say a user can write in a name , from and to date and so on in a form and then click the search button. If the user dosn't write anything all records from the database will be retrived. If he writes a name the a like statement should be ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>79. <a href='http://www.coderanch.com/t/299540/JDBC/java/looking-big-sample-db-mysql'>looking for a big sample db for mysql</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>80. <a href='http://www.coderanch.com/t/299555/JDBC/java/magic-mySQL-XML-piece'>magic mySQL to XML piece???</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>I'm about as green as you can get so I'm sorry if this is a well known issue (searching the web and forums hasn't gotten me anywhere). My goal is to retrieve data from a mySQL database in XML format and allow this XML to be stored in a bean or sent back to the browser either raw or through a ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>81. <a href='http://www.coderanch.com/t/299584/JDBC/java/MYSQL'>MYSQL</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>Hi all, I have installed MySQL 4.0.15 on a Win Xp Home OS.The installation is done in the C rive and I access the MySql server like this..(local machine) C:\mysql\bin, this connects me to the server directly but.... I want to connect to the server by giving userid and password. I would like to know how I could do it each ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>82. <a href='http://www.coderanch.com/t/299804/JDBC/java/Vector-filtering-VS-MySQL-filtering'>Vector filtering VS. MySQL filtering</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>Hello All, I am slightly confused on a small problem and was wondering if I could get your thoughts on it - I have a Vector of objects from which I need specific data - object where a=1 and b=2, etc. Then based on the results of one set of specifics (a=1, b=2), I need to extract other data from this ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>83. <a href='http://www.coderanch.com/t/299812/JDBC/java/Clustering-MySQL'>Clustering MySQL</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>84. <a href='http://www.coderanch.com/t/299872/JDBC/java/Problems-accessing-MySql-jar-file'>Problems accessing MySql from a jar file</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>I built a small program for the teachers at our school to help keep track of grades and it needs to access a MySQL database. Everything was fine until I packed the class files into a jar file and tried to run it using the java -jar command and I got a "java.sql.SQLException: No suitable driver" error. The jar file sits ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>85. <a href='http://www.coderanch.com/t/299885/JDBC/java/MySql'>MySql Question</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>I am having a problem with the Driver in eclipse. I have added the correct library to my project. But I still am having problems importing the com.mysql.jdbc package. Does anyone know how to correct this problem. My other JDBC Drivers (DB2, DB2 iSeries, SQLServer) work fine I cannot get this one to work. </p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>86. <a href='http://www.coderanch.com/t/299913/JDBC/java/MySQL-Visual'>MySQL in Visual J++ 6.0</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>87. <a href='http://www.coderanch.com/t/299916/JDBC/java/Failover-MySQL'>Failover with MySQL</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>If someone has implemented a failover scenario with MySQL 4.0, I'd be more than happy to hear about the details... I have an application running on WebLogic Express 8.1, which has a "high-availability" configured multipool capable of switching to an alternative connection pool when the primary doesn't work anymore, but I'm having difficulty in figuring out how to stop the MySQL ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>88. <a href='http://www.coderanch.com/t/299936/JDBC/java/Good-books-MySql'>Good books on MySql</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>Do you want books on MySQL specifically? Why not just research a bit on the SQL syntax somewhere online? MySQL works the same way as another SQL database would when you are connecting to it in Java. I'd normally recommend a book, but on something so simple it might be a waste of money. </p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>89. <a href='http://www.coderanch.com/t/299957/JDBC/java/Confugure-MYSQL-accept-diffecult-char'>Confugure MYSQL to accept diffecult char</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>90. <a href='http://www.coderanch.com/t/300010/JDBC/java/Request-Opinions-MySQL-User-Authentication'>Request Opinions on MySQL User Authentication</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>91. <a href='http://www.coderanch.com/t/300046/JDBC/java/MySql-server-reg'>MySql server - reg</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>92. <a href='http://www.coderanch.com/t/300087/JDBC/java/MySQL-Connector-autoReconnectForPools'>MySQL Connector/J: autoReconnectForPools</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>Does anyone know if the "autoReconnectForPools" parameter for the org.gjt.mm.mysql.Driver is what I need to use to resolve stale connections to the database throwing: STACKTRACE: java.sql.SQLException: Communication link failure: java.net.SocketException, underlying cause: Connection reset ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: Connection reset STACKTRACE: java.net.SocketException: Connection reset at java.net.SocketInputStream.read(SocketInputStream.java:168) at java.io.BufferedInputStream.fill(BufferedInputStream.java:183) at java.io.BufferedInputStream.read(BufferedInputStream.java:201) because MySQL closes connections after 8 hours of ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>93. <a href='http://www.coderanch.com/t/300109/JDBC/java/Store-flags-MySQL'>Store flags in MySQL?</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>Well... If for instance I wanted a whole bunch of flags, like "user owns this, user can delete this, user can modify this, etc", would I have to create a separate column for each and every one? I mean as I go along, I might get more and more flags, and I don't think it would be cool to have 30 ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>94. <a href='http://www.coderanch.com/t/300117/JDBC/java/Linking-MySQL-Java'>Problem Linking MySQL and Java</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>I am having a problem in that I am getting an error instead of an empty ResultSet TestCode //Open Database cc.DBOpen(); //Create Table cc.DBUpdate("create table tblCustomer1 (id numeric(5), name character(20), address1 character(20), address2 character(20), phone character(20), email character(20), Loyalty_points numeric(5), primary key(id))"); //Close Database to Commit Changes cc.DBClose(); //Open Database cc.DBOpen(); //Run Query; java.sql.ResultSet rs = cc.DBQuery("Select * from tblCustomer1"); //Close ...</p></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>95. <a href='http://www.coderanch.com/t/300121/JDBC/java/jdbc-mysql'>jdbc mysql problem</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>96. <a href='http://www.coderanch.com/t/300232/JDBC/java/Changing-MSAccess-MySQL'>Changing from MSAccess to MySQL</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>97. <a href='http://www.coderanch.com/t/300246/JDBC/java/kind-file-does-MySQL-create'>What kind of file does MySQL create?</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>98. <a href='http://www.coderanch.com/t/300327/JDBC/java/mysql-chinese-font'>mysql 's chinese font</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>99. <a href='http://www.coderanch.com/t/300341/JDBC/java/doing-inner-select-MySql'>Problem doing inner select with MySql</a><span class='articleProductElementHost'>    coderanch.com</span></h3></div></td></tr><tr><td><div class='articleProductElement'><h3 class='articleProductElementTitle'>100. <a href='http://www.coderanch.com/t/300504/JDBC/java/LIMIT-Hypersonic-MySQL'>LIMIT in Hypersonic and MySQL.</a><span class='articleProductElementHost'>    coderanch.com</span></h3><p class='articleProductElementParagraph'>Hi, I am currently looking at creating a database component that can be used with both Hypersonic and MYSQL. As I am required to execute large statments a need to use the limit SQL keyword. I have notice a differance between Hypersonic and MySQL. In Hypersonic the syntax is: SELECT [{LIMIT n m | TOP m}][DISTINCT] { selectExpression | table.* | ...</p></div></td></tr></table></div></div><footer><p class='pull-right'><a href='http://www.java2s.com/'>java2s.com</a>  | Email:info at java2s.com | © Demo Source and Support. All rights reserved.</p></footer></div></body></html>