mysql 3 « mysql « Java Database Q&A





1. free database for distribution with a commerical Java application    stackoverflow.com

I wrote a scientific application that stores millions of rows of time series data each time I measure a specific person. It also stores meta-data about the person, and about ...

2. how to parse a field contain a XML structure?    stackoverflow.com

I have a field on my database(MYSQL) that contain a XML structure, I want to parse that field to extract data ,My idea is to extract that field and copied it ...

3. running my JDBC application in other systems    stackoverflow.com

I created a JDBC application using mysql5.5.14 . I want to run it on other systems without mysql5.5.14.(but having java) Is thee any way i can install(and configure) mysql5.5.14 on other systems ...

4. How to clone MySQL database in Java    stackoverflow.com

I've been able to successfully connect to the MySQL database with connector/j, but I'm not sure where to go from here. I want to clone the database for use with a ...

5. What`s the best way to store shapes in a Database    stackoverflow.com

I'am implementing an application that deals with Java Shapes. every user login and retrieve an inventory from a MySql Database. the shapes have differentes constructor and behaviore. So, what the ...

6. Solving a "communications link failure" with jdbc and mysql    stackoverflow.com

I'm trying to connect to the local mysql server but I keep getting an error here is the code

public class Connect
{
    public static void main(String[] args)
   ...

7. SocketException: Broken pipe with a mysql database accessed through JDBC    stackoverflow.com

I have a web application with a MySQL backend accessed through JDBC. Every morning I see this exception: ** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: Broken pipe
STACKTRACE:
java.net.SocketException: Broken pipe
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)
at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
at ...

8. writting a Script for MYSQL or Java    stackoverflow.com

I need to make a data file to hold two empty tables with many feilds I have been sucessfull at making a MySQL 5.5 table with its DOS style IDE ok. And MYSQL ...

9. How to handle multiple schemas containing the same data    stackoverflow.com

I'm working on a system which predicts soccer matches at work. I have several pre-existing databases which each contain broadly the same data, although some vendors provide more data than others. ...





10. calculating total login-logout time of a particular user in mysql    stackoverflow.com

mysql> select * from timing;

+--------------+---------------------+-----------------+
| employeeIdNo | employeeLogTime     | employeeLogType |
+--------------+---------------------+-----------------+
|            1 | 2011-08-16 09:53:29 | ...

11. can we create a common database class in java    stackoverflow.com

i want to know if we can create a common database class same like we create a connection class and just call getConnection when we need connection to be established.
Basically, i ...

12. Verifying User from MySQL database in java    stackoverflow.com

I am making a School management system. In this system, first we have to create a user which gets stored in MySQL Database of Usernames and Passwords. But I am ...

13. CallableStatement doesn't recognize OUT parameter    stackoverflow.com

I have an example of a stored procedure in MySql and I want to call it with JDBC. The problem is that I get the following error:

java.sql.SQLException: Parameter number 1 ...

14. Configuring log4j property file to store in mysql Database    stackoverflow.com

It's been a while that I began with log4j; pretty cool logging framework. I've done other type of logging like Console and File Logging. So trying for DB Adapters with mysql ...

15. Testing MySQL database on LAN client    stackoverflow.com

I am attempting to create a MySQL DB and Java client app for my home network. I haven't really had any experience with MySQL other than PHPMyAdmin for a website backend ...

16. Advice: System platform choices    stackoverflow.com

I am designing a data management system where I want users to be able to use the application on any platform e.g. web, IOS, android etc. I want to layer it ...





17. Printing a MySql results set in java    stackoverflow.com

How can we print the data of a mysql results set on the printer with correct alignments of each data rows and columns? Lets say, we get a dataset from a ...

18. Handling custom input in Java    stackoverflow.com

I want to write a method having four input parameters,all the input parameters are not mandatory. I need to check whether the input parameter is not null and query the database ...

19. Process hangs in waitFor()    stackoverflow.com

I am trying to run mysql to execute some files from java. The input is read from a file and should be piped into the mysql process, everthing seems ok but the ...

20. Mysql-Proxy Doesn't Failover (?)    stackoverflow.com

This is the first time I am using mysql-proxy and I am experiencing the weird behavior I was wondering if the community has tackled it before. I have mysql-proxy (0.8.2) running ...

21. how to create a form and report in Mysql    stackoverflow.com

I am creating Registration project that regist students and query about them and give a report to GM, using Java with MySQL. I'm stuck in a problem: I need to create a ...

22. Ensuring MySQL off or kill it with MysqldResource    stackoverflow.com

Context: MySQL server deployed with MysqldResource java class (Connector/MXJ lib). They app using mysql server may crash for some reason and could be finished without shutting down the MySQL. The setup and ...

23. I can I integrate Apache and Mysql in the application installer?    stackoverflow.com

I have an Application made with java ,and it needs a Mysql database ,and Apache server,and I use Advanced Insaller to generate the installer. I want the installer to install Mysql and ...

24. Returning Cursor in MySQL    stackoverflow.com

How do we return a cursor from MySQL Stored Procedure (Routines). Or another approach to return a list of values back to a Java program from the MySQL Proc. We are ...

25. MySQL and Java driven application    stackoverflow.com

I am looking to make a Java based application that also uses an external MySQL database. Does anyone know of some good resources that I could read up on? I am ...

26. Show users with any privileges to database. MySQL    stackoverflow.com

i have to select all users with any privileges to database (e.g. database 'mysql'). Any suggestions? Thanks.

27. Finishing off my 'make folders from database' class    stackoverflow.com

The below is a class for making local folders from database entries where each folder has a name, id and parent-id. I have put it together as best I can but do ...

28. Deadlock Prevention(Java+MySQL)    stackoverflow.com

i have an sql class that connects to the database and updates the information from my game server. I was wondering if anything here would cause a deadlock and what are ...

29. Make linked directories    stackoverflow.com

I have a class that pulls in an id, name and (if needed) parent-id, it converts these into objects and then links them. If you look right at the end you will ...

30. JCS: MYSQL jdbc    stackoverflow.com

I have configured JCS with MYSQL database as mentioned below in article: http://commons.apache.org/jcs/MySQLDiskCacheProperties.html I am not able to store 1000s of objects immediately, there is some delay while stroing objects in ...

31. Count the downline node in tree using store procedure in mysql    stackoverflow.com

I have a table in Mysql. The table consists of three columns: SponsorID, LeftID and RightID. And the table consists of hierarchical data, exactly like a binary tree. LeftID and RightID ...

32. Solutions for Storing Data XML, Databases and...?    stackoverflow.com

I have a piece of software for reviewing cigars, the user enters the stats (name, price, brand, country, length etc) and a review (maybe a paragraph or two). Theres a menu ...

33. application access to varrying databases    stackoverflow.com

I am working on a project and was wondering what the best practice for the following scenario would be? I am developing an application that needs to have user access control. When ...

34. Java MYSQL Nullpointerexception    stackoverflow.com

Hey guys i'm trying to connect to my database and run a query. it all works apart from the query execution (after narrowing it down i found it to be this) ...

35. Getting MySQL Connector/J + JDBC to work    stackoverflow.com

I've been trying to get MySQL Connector/J set up for the past hour but I am not getting anywhere. I tried following a lot of tutorials, and am using the code on ...

36. Separating Reads & Writes to Mysql With out touching web server's configuration    stackoverflow.com

I heard that there is a some type of mysql load balancer that splits read and writes and sends each request to different mysql instance (master, slave). So we can use ...

37. Tool to Extract CVS / SVN data to Mysql    stackoverflow.com

I'm new in dealing with CVS data. I'm wondering if there is a tool that reconstructs the CVS data to a database ? Thanks,

38. Use JDBC to implement mysql Store Procedure. Help Please?    stackoverflow.com

I try to implement store procedure through jdbc. But every time i run this program, it outputs "java.lang.NullPointerException". I do not know where the problem is. I already create procedure in ...

39. Non-Blocking Multithreaded MySQL with Java    stackoverflow.com

So I'm making a server application in java, and I want the database requests to be event driven, so that it's non-blocking. The way I'm doing this is to create the MySQL ...

40. JDBC Concurrency implementation    stackoverflow.com

I am receiving a data from the socket. My ServerSocket creats a new thread for each new request. Then a need to upload the data to MySQL database. A database connection ...

41. mysql and java jdbc call from another class [runtime application]    stackoverflow.com

the problem is due to the **app.java **being called in response to a plugin start i.e in run time environment. i tried addinG "mysql-connector-java-5.1.18-bin" in the runtime-EclipseApplication too but it does ...

42. Wait until DOS command execution has finished - Java    stackoverflow.com

I am trying to import a large amount of .dmp files in a MySQL DB and since there are more than 250 files that have to be imported I wrote an ...

43. user defined data type in mysql with java    stackoverflow.com

lets say i have a class named myClass1 and i have another class myClass2 such that myClass1 contains a collection of myClass2... storing this in java is very easy. i was ...

44. What is the reason for OutOfMemoryError: Java heap space in the following case?    stackoverflow.com

The following code sample is inside a for loop that runs about 2 million times.

List<String> parameters = new LinkedList<String>();
stmt2 = null;
rs2= null;

//This is line 472
stmt2 = con.prepareStatement("select NAME from TABLE_NAME where ...

45. How to persist such data in mysql    stackoverflow.com

I have the following 5 classes [other attributes and methods have been skipped] CommonInterface.java

    import java.util.Vector;

    public class CommonInterface {

       ...

46. How can I use JDBC to copy schema from one database to another?    stackoverflow.com

I have a database in MySQL, and I want to programatically create all the same tables and fields in FileMaker Pro. I can do this myself using JDBC, but I was ...

47. How to persist SOAP Messages in MySQL Database - working with Axis Client    stackoverflow.com

I am writing a java axis client, how could I persist raw xml into data base, till now I have found two ways of logging raw xml, but they are for ...

48. Java JDBC Access denied for user    stackoverflow.com

I am trying make a connection to MySQL from my java application and it keeps on saying :

java.sql.SQLException: Access denied for user 'vincent'@'x.x.x.x' (using password: YES)
I have checked ...

49. java mysql quick    stackoverflow.com

I'm learning how to connect to mysql from java from a book, but I get one error, the first line..the package declaration. I copied the code(given bellow) exactly as it was ...

50. Putting Objects in the JDBC?    stackoverflow.com

I am wondering how will I implement this classes I made in the JDBC, you see,I created a class like User,Employee, FinanceMember , SystemAdmin, and all of them have references to ...

51. JDO / PersistenceManager - How to deal with duplicates when persisting objects?    stackoverflow.com

I'm trying to persist objects using JDO and MySQL. My data structure basically looks like this:

// Dish
@PersistenceCapable
public class Dish {

    @Persistent
    private String name;

  ...

52. Live XML Feed to MySQL database    stackoverflow.com

I already know how to parse live XML feeds in Java, what i would like help on is placing that data in a MySQL database. I would then want to display that ...

53. Mac leapord. NetBeans. Mysql and class path    bytes.com

good evening all, I finally managed to get this script to work. I had to javac it with the driver in the same directory and it worked fine. That leads onto ...

54. Want to use Dynamic Jasper to make Reports with my Db MYSQL    bytes.com

Hey, i want to Use Dynamic japser to create reports of my database i.e MYSQL. Plus, i want to know that can i send attirbutes to dynamic jasper which a user ...

55. Save composite Object to mysql    bytes.com

57. I want to know how to store video into a MySql database using Java?    bytes.com

You can use Blob type to store video in MySQL. Read file and convert into BLOB and then store in DB. More convenient ways are to store the URL of video ...

58. Urgent help with connecing J2SE and MYSQL Connector/J    bytes.com

Hi i want to use MYSQl code in my java program using JDBC. As far as I know I have to connect mysql and j2se in order to use mysql codes ...

60. jBPM5 and MySQL??    community.jboss.org

I recently pulled down jBPM5.1 and am about to try to run the installer again using MySQL - I was wondering if anyone has done this and if so what version(s) ...

61. How to Access a MySQL DB using J2ME and Bluetooth    forums.netbeans.org

Hello everyone, currently, i'm working on a project where my users will have access to a database stored on my pc (bluetooth supported). They are supposed to get the data through ...

62. Database URL for MySQL in Mac OS X    forums.netbeans.org

I am using the tutorial about Netbeans and MySQL at http://www.netbeans.org/kb/60/ide/mysql.html. When I try to connect to the MySQL server using the database url as :/// I get an error message. ...

63. Idea who to in mysql    forums.netbeans.org

Is no other way to avoid call this code in all forms or modules like global Connection (Help Please) only live the conn open . String dbDriver = "org.gjt.mm.mysql.Driver"; Class.forName(dbDriver).newInstance(); System.out.println("Driver ...

64. NB 6.7 + MySQL 5.1.11 + JDK 1.6.0_14 + Vista64 = not working    forums.netbeans.org

Hello I have been trying all night to connect to MySQL server from Netbeans but it wont work. Done all the tutorials without any luck. I get the following error:

65. MySQL Server Properties -> path to start command    forums.netbeans.org

Hi, Can anyone confirm whether they've been able to start the MySQL server from the IDE? It seems that MySQL by default needs to be run with root privileges. Looking at ...

66. MYSQL Boolean: True, False and Null    forums.netbeans.org

This is probably a simple question. I've looked everywhere I can think of for the answer: A Mysql column that is defined as boolean or tinyint(1) can only have 2 values, ...

67. NetBean and Mysql    forums.netbeans.org

I connect to mysql on NetBean, I use root and when every I connect to Db, and I did give the db's name but everytime I connect to db , I ...

68. mySQL startup help for Windows7    forums.netbeans.org

i can start mySQL from windows services -- both XP,Win7 -- i have it configured as a manual service. i can stop it from services. i can stop it from netbeans. ...

69. Java and MySQL database    forums.netbeans.org

I am new to this and couldn't find the help to some of my questions so I am wondering if someone can help me with this. I have my database connected ...

70. MySQL in netbeans    forums.netbeans.org

Hello there! I'm a noob when it comes to java and netbeans and i badly need your help. I'm trying to create a program that will list items from a grocery ...

71. Server for Database mysql not available    forums.netbeans.org

I had mysql installed on Fedora 11. I run mysql -u fred -h localhost -p ...... and I can log in I installed netbeans 6.8. but when I go to Services, ...

72. 6.8 Simple CRUD application with MySQL hangs on createEntityManagerFactory    forums.netbeans.org

Situation: NetBeans 6.8, Remote MySQL. Connection to DB from IDE is OK, I successfully run SQL INSERT commands in NetBeans. Inserted data is visible by other tool. It seems to me, ...

73. HELP! JAVA+MYSQL    forums.netbeans.org

romina Joined: 20 Jan 2010 Posts: 4 Posted: Wed Jan 20, 2010 8:10 pm Post subject: HELP! JAVA+MYSQL Hi, (my english is poor sorry...but need help urgent) I ...

74. Problem stopping MySQL    forums.netbeans.org

Posted: Sun Jan 31, 2010 1:35 pm Post subject: Problem stopping MySQL Hello, Ive been going through the tutorials for setting up MySQL in netbeans but have ran ...

75. Mysql autoconnect.    forums.netbeans.org

Posted: Tue Feb 23, 2010 5:46 am Post subject: Mysql autoconnect. Hi, I have this enoying problem with MySQL connect timeout message: oracle.toplink.essentials.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last ...

76. Persistence MySQL Module    forums.netbeans.org

I have several applications that I am wanting to build on the Netbeans platform. Some of these applications will share modules, databases, and the like. I am trying to figure out ...

77. Java & MySQL    forums.netbeans.org

Hi ! I need some advices and ideas for an application: My job is to do basically a cadaster, with some fields of information. This application need to be running on ...

78. Netbeans 6.8 IDE used with GlassFishV3 with MySQL5.1 as backend    forums.netbeans.org

Hi: I am trying out the subject combination and trying to get the eCommerce application at "http://netbeans.org/kb/docs/javaee/ecommerce/connect-db.html" working. Briefly, I have gotten to the point of successfully pinged the database (screenshot ...

79. Problem with netbeans and mysql    forums.netbeans.org

Hi, Im developing an application in netbeans where i need to pass queries to a mysql database. Everything was working fine, but the problem occured when I renamed a table, and ...

80. Problem with netbeans and mysql    forums.netbeans.org

Hi, Im developing an application in netbeans where i need to pass queries to a mysql database. Everything was working fine, but the problem occured when I renamed a table, and ...

81. mysql guestion    forums.netbeans.org

Hello, I want to use netbeans for ruby development. But is netbeans shipped with mysql. If so, howcan I start it and create users for it and grant them privilliges ? ...

82. MySql, etc    forums.netbeans.org

Hello everybody, I have a desktop application written with NetBeans 6.7 in Java, uses MySql. I need to update a table in a MySql database in a web site from my ...

83. How do mysql not ignore accents?    forums.netbeans.org

I get words like zoolgico, outdoor and, of course, vo, but I need that '' != 'o'. I altered the following method of the controller class to pass a parameter:

84. MySQL in NetBeans question    forums.netbeans.org

I have one java desktop database application which use a MySQL table and works great locally, but didnt work when I stop MySQL server from the services; I want to share ...

85. Auto Reply: MySQL in NetBeans question    forums.netbeans.org

This is an auto-replied message. I am out of office right now. I will be be back in the office on August 16, 2010. Shreedhar Ganapathy (address-removed) is able to contact ...

86. MySQL: can't "grant full access" to root    forums.netbeans.org

I'm working through the AffableBean tutorial (which is outstanding by the way). I've connected to MySQL just fine but creating of the new dB calls for granting full access to root. But when I check the box to choose a dB user to grant full access to, root isn't there. The only choice is the other default user (pma). Does root ...

87. MySQL commands except EXPLAIN command    forums.netbeans.org

DESCRIBE (desc) Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.39 Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | scr_development | | test | +--------------------+ 4 rows ...

88. nb6.9.1 & javafx composer & mySql help needed    forums.netbeans.org

Hi, JDBC data source has methods that can insert, update and delete database rows. To remove rows from a table, execute DbDataSource.remove() method. Its signature is: remove(table : String, whereClause : String) executes this sql statement: var sql = "DELETE FROM {table} WHERE {whereClause}"; The problem is probably in the WHERE clause, I would recommend printing it out for verification, maybe ...

89. Java and MYSQL Problem    forums.netbeans.org

Code: Exception in thread "AWT-EventQueue-0" java.lang.IllegalArgumentException: An exception occured while creating a query in EntityManager at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerImpl.createQuery(EntityManagerImpl.java:209) at projekatbp.zapos.initComponents(zapos.java:47) at projekatbp.zapos.(zapos.java:29) at projekatbp.ProjekatBPView$8.run(ProjekatBPView.java:245) ...

90. college mySql java issue    forums.netbeans.org

So I am working on a java project for a college asssignment (im a student ...) and dont know what I have done... but my sub menu (when create, delete find or update is clicked) wont display. what should happen is create is clicked and the sub menu displays with student, class or teacher. but now it just displays the form ...

91. Set phphmyadmin as MySql Administration tool    forums.netbeans.org

92. Netbeans 6.9.1 & MySQL database problem    forums.netbeans.org

hello all, i'm a new member here, i'm using Netbeans 6.9.1 under windows 7, i have MySQL server installed in my system (essentials-version 5.1). i design a form using netbeans in Java. this form will work as a front-end to input data in MySQL database table. i create a database called 'garments' which has a table called 'product' with product_id & ...

93. Successful NetBeans with MySQL BUT Display not working    forums.netbeans.org

Hi, I have successfully managed to connect NetBeans with MySQL using teh following code. I found this code in the internet as I am a newbie in Java and Netbeans. The problem I am facing is that instead of System.Out.Println, I would like to display the contents of resultset in the jTextfield. I have tried jusing jText.SetText(string t) but that is ...

94. No tables/views/procedures viewable from MySQL?    forums.netbeans.org

Does MySQL offer a connection node and database explorer option like Derby? When I connect to a Derby database, I can right-click on a connection node and see folders for tables, views, and procedures that I can make use of. When I try to do the same thing for MySQL, all I get are little database stacked-disk icons, and there is ...

95. NetBeans 7, Communication Link Failure MySQL    forums.netbeans.org

Hi all, today I installed NetBeans 7.0. I wanted to add mySQL server by choosing "Register mySQL server" from the services tab. I provided the correct port, password etc. and mySQL server is started. When I want to connect I get a Communication Exception, Communication Link failure. In NetBeans 6.9.1, it still worked. Also, trying to connect with MySQL Workbech works ...

96. Headsup - FIXED Entity from Database problem with Netbeans 7.0 and MySQL 5.5.11 on OSX    forums.netbeans.org

Hi Everyone, I've recently installed Netbeans and MySQL on OS-X to do some J2EE development and have run into a problem with creating entity classes from my database due to primary keys not being identified by the wizard. Before describing the problem and solution, here are the versions of the software I've installed:- Product Version: NetBeans IDE 7.0 (Build 201104080000) Java: ...

97. Trying to set up MySQL Server on Netbeans IDE 7    forums.netbeans.org

hello I am situated at MySQL Server Properties dialog box at the Administration Properties tab in Netbeans IDE 7. In this dialog box there are 3 tabs needed to fill in to successfully set up SQL server. These tabs are: Path/URL to Admin Tool Path to start command Path to stop command In the dialog box under each tab there are ...

98. MySQL server    forums.netbeans.org

99. Adding the mySQL Library    forums.netbeans.org

Hi all, I hate to ask what seem like an obvious question but Im having some trouble installing the mySQL library into a project. I have downlaoded the connector from mySQL. I right click on my project name and then selected properties. I have then selected libraries and Add/ JAR/FOLDER add added the relevant mySQL jar connector. The library loads fine ...

100. MySQL Connector/J Problem when using IP ADD    forums.netbeans.org