1. A liitle help please my MYSQL project forums.oracle.comThanks Hippolyte that clue did it. I was so tried of trying to solve this project. I was get fustrated and could not see and think straight. red PS I did it that way once and it got me into trouble because I hit the return key.... Message was edited by: Redheadashley |
2. Java and mysql? forums.oracle.com |
3. MySQL problem forums.oracle.com |
4. Ms-Access db <-> MySQL forums.oracle.com |
5. mysql connector/j forums.oracle.comno that didnt fix it, where am i supposed to put the connector/j driver at? what specific folder for windows? i mean i just have it on my desktop, but i thought netbeans setup the classpath to read it... but maybe it didnt, and i dont want a classpath going to a random folder on my desktop. but then why could ... |
6. com.mysql.jdbc.CommunicationsException forums.oracle.comHi , i am getting this error while connecting to MySql 5.0 with Eclipse. can anyone help me out. Exception :- com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: java.security.AccessControlException: access denied (java.net.SocketPermission 127.0.0.1:3306 connect,resolve) STACKTRACE: java.net.SocketException: java.security.AccessControlException: access denied (java.net.SocketPermission 127.0.0.1:3306 connect,resolve) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151) at com.mysql.jdbc.MysqlIO. |
7. Netbeans and Mysql forums.oracle.com |
8. need help on java with mysql... forums.oracle.comI want to make application that will use mysql as database. I have downloaded mysql connector j but i'm confuse about how to install it to jdk. for reference, i'm using windows xp, phptriad that have mysql 4.1. After that, how do I connect my application to the database? please help... Thanks before... |
9. mySQL forums.oracle.comhey peepz... i know this is a java forum but was wondering if ou guys can help me out here...i am trying to connect to MySQL server on another laptop which acts as a server through my java application. the MySQL server happened to be part of WAMP. i managed to ping it but was denied the access to connect onto ... |
10. MySQL select .. where stmnt isn't working with text variables forums.oracle.com |
11. MySQL select .. where stmnt isn't working with text variables forums.oracle.com |
12. Alternative to Remote MySQL Access? forums.oracle.comI've been asking around to see if anyone has an idea for a solution to my problem... well I guess I should describe said problem. I want to access a MySQL database remotely with JDBC so that i can keep a list of usernames/passes and some data associated with each one and access this data in my Java application. Unfortunately, as ... |
13. JDBC 'Cannot find class com.mysql.jdbc.java' forums.oracle.com |
14. JDBC MYSQL localhost vs. over the internet forums.oracle.comThere is no problem with using webstart to distribute an application, in fact it is the preferred method. Directly connecting to your database from the application is a major security risk however. For one, you have the username and password hardcoded into your application, meaning that anybody with a decompiler can get this information. I'd make sure the user that the ... |
15. Confused between javadb + mysql + related forums.oracle.comHello -- I downloaded a package with netbeans and included a few things. I booted up glassfish and enabled the javadb and can connect to it successfully with netbeans. But ... how do I view the database? Do I need mysql to view the databases? Can I use mysql with javadb? Is javadb just the database and has no visual gui ... |
16. MySQL naming convention ? forums.oracle.com |
17. MySql question forums.oracle.comHello guys and excuse me for posting a question about MySql here and not on a specialized forum but you guys always helped me so I did it here.So I have built a database about games and I have a problem.I have a table named games.I want to store the platforms on which the game appeared.For example Rise of the Argonauts ... |
18. jdbc mySQL delete hole forums.oracle.comHi, I managed to write a program that displays the info in a database table. It also is capable of adding, deleting and modifying rows. However, after noticing rows appearing in unusual orders I discovered that mySQL creates holes when u delete a row. Has anyone else come accross this? And does anyone know how to work around this? Regards Aubrey. ... |
19. Button to link to MySQL? forums.oracle.comI am a Java beginner. I am writing a program for recording customers' payment. I would like to a button on a GUI for me to click to add a record. For example, I can add a record of $100 to MySQL simply by clicking this button. Whenever the customer pays, I can click it to add the record. What code ... |
20. MySQL with EE Tools forums.oracle.comLooking at [Java EE Downloads page|http://java.sun.com/javaee/downloads/index.jsp?userOsIndex=6&userOsId=windows&userOsName=Windows], I see an option to download Glassfish with MySQL, and options to download Glassfish with Java EE but without MySQL. Is there some kind of issue preventing MySQL from being used with EE, or is it because you want to have the DB and development environment on separate machines, or am I missing something obvious? ... |
21. mysql server problem forums.oracle.com |
22. help with creating a mysql database forums.oracle.comIs this a web app? Then you configure the DataSource in the server (database url, username, password...). Your code just needs the name of the data source. If this is just a simple application, put the config stuff (database url, username, password...) in a configuration file (*.xml or *.properties) so that whoever you give this to can supply the information. |
23. please help regarding method/function sign up validation with mysql jdbc. forums.oracle.comCan you tell us anything about this error? Like, does it happen at compile time or run time? Basic things like that. What does the error message say? (Copy and paste, don't try and retype it and -- even worse -- don't type a lame paraphrase of it.) What line of code does it refer to? Or are there no error ... |
24. Decode MySQL using Java forums.oracle.comHey guys, I have been having problems trying to figure out how to decode MySQL passwords that i have setup on my table using Java so that when a user enters a password on the java application it will decode that password check if it is correctly used and then let them log in. Currently i am using NetBeans and my ... |
25. Java MYSQL count problem forums.oracle.comHi all, I'm a newbie in developer world..Currently i'm developing a system and stuck when i want to make the count function..i'm wondering if i can make a count statement from the java programming or from the mysql statement..Below is my prob.. In mysql db,i store the record as below.. person ID Diet 1 A 1 B 2 A 3 A ... |
26. Java and mySQL??! forums.oracle.comImagine this, I am developing a program in PHP and storing some information into a mySQL database. The thing is, I really want to access this database in Java and use it. (Accessing it from the web, of course.) I've searched the web, but with no avail. If you could point me in the direction of some good articles/tutorials/whatever or something, ... |
27. Instaling MySQL dirver forums.oracle.comit fails here is the output C:\>java -classpath ".;C:\Program Files\Java\Extra\mysql-connector-java-5.0.8-bin.jar" JdbcConnection Exception in thread "main" java.lang.NoClassDefFoundError: JdbcConnection Caused by: java.lang.ClassNotFoundException: JdbcConnection at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClassInternal(Unknown Source) Could not find the main class: JdbcConnection. Program will exit. Scott. |
28. mysql on soloaris 10 forums.oracle.comhi lla, I have two questions on mysql 1) backup, before I use mysql administrator tool to backup and restore the db, but that is not available for solaris , how can i use mysql code to backup and restor mysql db, I try to use ./mysqldump -u root p secret test>Home:\test.sql but i got error> 2) when I import my ... |
29. chart from mysql using java forums.oracle.com |
30. how make installer java with mySQL database forums.oracle.comIf you have eg. a desktop application which needs a database, but don't have/ need a database server, which is accessed by several instances of the application (which seems to be the case, otherwise you wouldn't want to install it along with the application), consider an embedded database such as Apache Derby/ Java DB. Then all you need is to ship ... |
31. J2ME MySQL question forums.oracle.com |
32. Java, MySQL, SourceForge and JDBC forums.oracle.comAfter reading up on the situation a bit more I now realize the the project database at sourceforge is NOT intended to be used by, for example, an application to constantly read and write to. You have to go to your project site and request access to it, only then can you access it through your command-line and you are only ... |
33. grabing data from mysql forums.oracle.comI am writing a program that require to grab data from the mysql database. When I start the program it should grab all the data in the mysql database into the GUI list. Also, whenever new data is entered in the database, the program will automatically grab and add the new data into the GUI list. Any suggestion? |
34. mysql data to xml forums.oracle.com1) Use JDBC or an object/relational mapping tool to retrieve data from the database. 2) Create an org.w3c.dom.Document object (it's in the docs, look for it). 3) Add the data to the Document appropriately, where you have to define what "appropriately" means. 4) Write the document out. I believe that toString() will do that OK; there may be other ways. Or ... |
35. How to save a picture as data in mysql forums.oracle.comAnd if you have a BLOB of image data, you could easily (for example) write a servlet that sends the binary data to the user with the appropriate content type header. It's probably best to have (at least) two columns for this data -- the BLOB and the MIME type of the image data (or if you like, some kind of ... |
36. Java + mySQL forums.oracle.comI searched the web, and it seems to be a fairly complicated process (at least one that's beyond me right now). Because I have to concentrate on the program itself, not the connectivity, I was wondering if anyone knows of a class, or something, that makes it easier to connect to mySQL databases. |
37. JAVA and MYSQL NOW() Function only displays year? forums.oracle.comActually, you can leave it uninitialized, as you will set its value from the result set. You also do not need to loop the result set, as you can assume it will return only one row. It is usually considered as a good programming style to at least check to see if the first row exists before getting the column. If ... |
38. How restor mysql database using a java forums.oracle.com |
39. HashMap Into MySQL Database forums.oracle.comHello, I was looking for some direction of what the best way to get a hashmap into a MySQL DB would be. The HashMap is dynamic and is generated on the fly so I never know the exact size / how big the index is. I think the best way would be to iterate through the hashmap and insert each key ... |
40. how to restore a mysql dump file to database using java forums.oracle.comhai friends, i'm developing an application. in that i need to back up and restore the database. i'm using mysql. in that i used a code to back up the db.. its working perfectly and the dump file is created perfectly.. but while trying to restore the dump file nothing is happening... can anyone provide me a sample code to restore ... |
41. Getting data from MySQL forums.oracle.com |
42. Mysql+ play sound forums.oracle.comI wish to develop a program which used to play the sound file. The problem I face now is I wish can play the sound file when select the userID from mysql database. For example, when I select one of the userID from combobox, then the sound file can automatically playing? By the way, the userId is already stored in database, ... |
43. Java AES Encrypt/Decrypt and MySQL forums.oracle.com |
44. JDBC + MySQL forums.oracle.com |
45. Download the latest MySQL while you still can! forums.oracle.com |
46. How to Start/Stop MySQL Server using java code forums.oracle.comHi, I need to write the java code to start and stop the MySQL Server. I can write the java code if MySQL Server is installed as the windows service. My requirement is MySQL server is not installed as the windows service; I need to know the java code for this particular case. Thanks in advance. - raj |
47. / is not saving in mysql db forums.oracle.com |
48. want to get the port of mysql via my java program. forums.oracle.com |
49. Help with mysql class (Japplet) forums.oracle.comMan I don't want from you anything . I just want to learn why the class didn't work after editing . I think you thought me homeworks asker. First of all, as i said i want to learn what the bug exactly. Second, Take a Look at this " Sun Forums is a large collection of user generated discussions. It is ... |
50. MySQL Connector/J Javadocs. forums.oracle.com |
51. UTF-8 and MYSQL Issue forums.oracle.comI am having trouble writing UTF-8 into MYSQL, I am using MYSQL 5.0.45, my tables and database are set to UTF-8. When I query (select or insert) I use "pStmt.setBytes(qi++, (string).getBytes("UTF-8"));" That seems to work fine, but when I try to look at the data in phpMyAdmin I see it as "" (instead of ""), if I try to enter "" ... |
52. Store a word doc in MySql forums.oracle.comHello, I want to store a word file in to Mysql i.e., i want the entire word doc to be saved into Mysql without reading the contents of the file and i don't want the path of the file to be saved at the back end. Note: word file is a mixture of all jpeg ,text and word art text Cheers ... |
53. java feat database(MySql) forums.oracle.comQuestion 1: In my class how do I initialize the Boolean? Referring to the text book (JAVA Sixth Edition) Chapter 14, I created the class and a different class with the same info except for the import of the Serializable class/(function) in a package that I created. Both classes are in there. |
54. mysql connectionpropertiestransform issue - help needed forums.oracle.comBut I cannot move my connection properties implementation jar file to tomcat common lib. Actually i am mapping application user to database user. Depending on user who logged into the application, i have to connect to the database with that user id and password. We are using spring framework for authenticating user. If i move connection properties implementation jar file to ... |
55. MySQL advantages with Java server forums.oracle.comHi, all! It's not other question about "MySQL vs PostgreSQL". I read a lot of things on the internet about this topic. What I would like to know is that, cosidering that the Sun bought MySQL, does MySQL have any advantage over PostgreSQL when using a Java server? If not, does anyone know about any proposal of doing this? Thank you! ... |
56. How to deploy a MySQL based app forums.oracle.comHello everyone, I need help with getting my java application to find and communicate with a MySQL server.\ I have JARed the java application and I can run it by double-clicking the JAR file on my desktop. However, the application produces an error saying the driver class cannot be loaded. However, when I run the application from within Netbeans 5.5, it ... |
57. how to copy from javadb to mysql forums.oracle.com |
58. java and mysql forums.oracle.com |
59. Java RMI MYSQL forums.oracle.comHello, I have a problem and a possible solution to the problem, please give me your inputs about the feasability of my soultion or if you can suggest an alternate more effecient method to acheive the same goal. We have a java RMI client server application that has to write to a myql database. This was desigend to work on a ... |
60. Problem While Connectiong To MySql From Other Machines forums.oracle.comHi I am having a problem when I am trying to connect to MySql server available on some other machine with the following code. Java Code is like this, driver is loading properly, I am facing problem with url. Any thing need to be changed. DriverURL = jdbc:mysql://192.168.9.83:3306/coepsb1 DriverManager.getConnection( driverURL,"aaaa","aaaa"); 192.168.9.83 this is the machine IP Address. On port 3306 mysql ... |
61. DriverManager.registerDriver() for MySQL forums.oracle.comSorry, there are no "Java native" Drivers (if by that you mean a Driver delivered with the JRE). You need to download Connector/J from MySQL (it is 100% Java, which is, essentially what "Java native" should mean). I will bet you get the "Undefined Symbol" error (or something to that effect) when compiling, right? Do you know why that is? Because ... |
62. JDBC MySQL question forums.oracle.comI am trying to implement a search box for the FAQ table containing FAQ id, Question and Answer. the query that I have designed is working fine if searched string is greater than 3 letters otherwise it returns null. I have got few acronyms in my table most of them are 2 or 3 lettered medical terms. could any body suggest ... |
63. MySql strippes java's two backslashes forums.oracle.com |
64. Some help with MySQL fetch size forums.oracle.comJamwa wrote: Anyway my main aim was not only to get the results, but in case I got no results returned then I tell the user that via a JOptionPane. It's not clear to mean what you are trying to do: 1. If all you want to know is the number of rows in the table, or whether or not the ... |
65. Can i use MySql to check if the author has already been booked? forums.oracle.comIf the objective is just to get a unique list of authors based on your key, you could use the REPLACE statement in MySQL which functions as an "insert on duplicate key update" type of construct. [http://dev.mysql.com/doc/refman/5.0/en/replace.html|http://dev.mysql.com/doc/refman/5.0/en/replace.html] Catching an exception to detect dupes is functional but not very elegant. If you use REPLACE then you know your statements will always work. ... |
66. Java MySQL GLP Question forums.oracle.comI have a question about the MySQL GLP with Java. If I develop an application that connects to a MySQL database, and since I'm distrubuting the application and not the database, then my application is not under the GLP license according to this clause: "To convey a work means any kind of propagation that enables other parties to make or receive ... |
67. MySQL forums.oracle.comGuyz, Good day! I need your help again. I already have MySQL 5.0 and able to connect it using the Connector/J. My problem is how to create a table or database using the GUI / windows. But I know how to create using the DOS command. Is there an another way of creating it except the DOS command? Thanks, I-Talk |
68. Sun support for mysql and jdbc forums.oracle.comI can able to connect MySQL database from Eclipse 3.1.2 IDE with JDBC. below is sample code import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Date; public class MySqlTest { public static void main(String args[]) { Connection con = null; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); con = DriverManager.getConnection("jdbc:mysql://localhost/test", "root", "test"); Statement st= con.createStatement(); ResultSet rs = st.executeQuery ("select * from ... |
69. Finding , Creating , Copying Schema In MySQL forums.oracle.com |
70. mySQL via RMI question forums.oracle.comHello I am trying to invoke a SQL command via RMI from my client applet to the server. I have confirmed by debugging that there is a proper connection with the client and server and the server to the sql database. I have also tested from the server, the connection with the database by extracting data. For example if I have ... |
71. Which version of MySQL I should choose forums.oracle.com |
72. Simple MySQL Problem forums.oracle.com |
73. Sun buys MySQL for $1B forums.oracle.comMySQL and CloudScape/Derby/JavaDB are quite different products, aren't they? Derby is focused on being small and Java. Yeah, I know MySQL's been acting all enterprise-y for quite some time. But with Sun owning the product, I'm just wondering aloud whether or not there will be a preference toward some flavor of MySQL as the "integrated" database in the future. You're probably ... |
74. MYSQL Without JDBC forums.oracle.com |
75. JAVA MYSQL forums.oracle.com |
76. Java + MySQL + Daylight Savings Time == headache forums.oracle.comI have a problem with my Java + MySQL application every time the clocks go backwards. I have some code which checks how long something has been in a particular state: int duration = (int)(new Date().getTime() - dbObject.getStartTime().getTime())/1000; And under most conditions, that tells me how many seconds the dbObject has been running. the getStartTime() method is retrieving a java.util.Date object ... |
77. how to create config.inc mysql forums.oracle.com |
78. how to create config.inc mysql forums.oracle.com |
79. Problem in using now () in mysql 5.0 forums.oracle.com |
80. Datatypes in MySQL: getInt for integer, what for text? forums.oracle.comSecond question, I have a table which needs to store paragraphs of text in a row. What should i use? Text or blob? Any special precautions i need to take when using blob? Any special steps to take or is it just like the others? Lastly, I also have the following error, i googled it up already, but mainly the results ... |
81. mysql question forums.oracle.comThis might not be the best place to ask..... but.... I would like to come up with a trigger that runs a java application for example: On insert or update of a row send that info to a java application... if user says: INSERT INTO table1 VALUES ('name', '10/21/83') then name and 10/21/83 get sent to a java application like fromdatabase.manipulate(String ... |
82. quick mysql question forums.oracle.comneed to check to see if row exists if so then update otherwise insert code example: SELECT dirid FROM directory WHERE direc = path if it exists then update the database else insert it thought the code was: if (result set.next()) //means that it exists else does not exist but that does not seem to work |
83. Java and MySQL forums.oracle.com |
84. Problem with result set values from MYSQL forums.oracle.comProblem. I have servlet code which pulls values from a MYSQL db. The relevant line of code is: ResultSet rs = st1.executeQuery( "select pos1,pos2,root from wds WHERE wd ='" + data + "'" ); where wd, pos1, pos2, and root are table columns, and data is user input. This works in three contexts: a) when the MYSQL command is used on ... |
85. Does MySQL support setLoginTimeout()? forums.oracle.comWell I am trying to create another thread here that will count to 15 seconds, and if by that time a connection hasn't been made, it will throw a connection error. I've got that part to work, but after 15 seconds and once I am notified of a connection timeout, the thread that is connecting is still trying to connect even ... |
86. how to enter a 24 digit number into a mysql db forums.oracle.comhi, i want enter a 24 digit number into a mysql db as a mathematically manipulatable value. when i configure the field as a bigint(24) it takes it as bigint(20) when i keep it as bigint and parsing a double value from my application it gives data truncation exception for the particular field. the whole process worked well when i change ... |
87. can not get data from mySql forums.oracle.com// |
88. MySql forums.oracle.com |
89. How to import msaccess into mysql in lan using jdbc forums.oracle.comI'm working in a project where my application needs to import data from msaccess database which is somewhere in lan and which belongs to another application into mysql database which is in the server machine of my application.I need to create an option in my application to specify the path of database of another application and import its data into my ... |
90. Using MySQL with Java forums.oracle.comHi, I am writing a database program, and I decided I should try and use MySQL since many people have told me it is the best way to make a database. Does the java version that Sun provide come with the api to create mysql databases? Also, I would like to know of a good tutorial that teaches MySQL with java. ... |
91. Can I execute MySql's command from java application? forums.oracle.com |
92. how to access MySQL using java properties forums.oracle.com |
93. doubt regarding on com.mysql.jdbc.CommunicationException forums.oracle.comhi... iam develped an appln which peridically updates datas into the database iam using MySql server here... it will work normally for sometime.. then it throws the exception com.mysql.jdbc.CommunicationException... but datas are continuously updated into the database... After a few minutes,it dont throw any exception database is continously updated... i need to knw why this exception arise...? and also to knw ... |
94. problem in running a program in java mysql forums.oracle.comi have a lot of nested java programs, individual testting results are ok, how ever, the following results occur when i combine those codes, do you have any idea about this? sorry about this but i hope you can help me.... thanks in advance.... false true java.sql.SQLException: Illegal operation on empty result set. at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680) at com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:5021) at com.mysql.jdbc.ResultSet.getString(ResultSet.java:4999) at checkvalidity.tesdiscode(checkvalidity.java:44) ... |
95. How to import msaccess into mysql in lan using jdbc forums.oracle.comIf you ask me it would be easier to dump the access database as an SQL script, change it by hand so it has the syntax that MySQL wants and then import it into MySQL using the command line interface, or your favorite graphical user interface to work with MySQL. Or try to find a tool on the net that can ... |
96. Setting up JMS with mysql forums.oracle.comHi All, Can you anyone help me to setup on my linux machine JMS with mysql. I have installed JMS and mysql.I don't know after that what i need to do. I would like to setup on linux machine JMS with mysql database. Do i need to install any webserver.Please advice me step by step.Your help will be really appreciated Regards, ... |
97. NetBeans 5.5 & MySQL forums.oracle.com |
98. mysql database forums.oracle.com |
99. Read from MySql with Java? forums.oracle.comThanks to both of you for your help so far, I think I'm starting to understand. So, basically what I'm getting from this is, I can use java.sql and javax.sql, and they're already installed in Java 5.0 so we can use the online APIs? I thought you had to download something else, please correct me if I'm wrong. Jezzica85 |
100. Load Pictures to MySQL through JavaServer Pages forums.oracle.com |