mysql 9 « mysql « Java Database Q&A





1. timestamp in mysql?    forums.oracle.com

Sorry if i post this in the wrong forum, but i hav posted this in jdbc topic, i haven't got any answered yet.... i hav created session table& i set the activeTime column to timestamp in mysql... I plan to set that everytime the sessionID check the activeTime updated to current time... 1. How can i do that? 2. How can ...

2. Change from mysql to java technology    forums.oracle.com

As has been stated, Java is a programming language and MySQL is a database management system (DBMS), so they are different things. But they play nicely together -- Java applications often use a database backend, and MySQL is a common backend to a Java application. It's also possible to take a Java application that connects to a database and switch it ...

3. JDBC and MySql related question    forums.oracle.com

I am writing a program that will read in very large text files and then store them in a MySQL database. I intend to use a bufferedreader then make repeated readLine calls, parse each line, then use a prepared statement to create a batch of updates. However I am having difficulty in designing the actual database. I know this isn't really ...

4. MySql problem    forums.oracle.com

i need to use a database for a project, so i downloaded mysql5.0 and connection drivers. i installed mysql with no problem, and extracted connection drivers. then i created a classpath and named the variable as C:\Connector\mysql-connector-java-5.0.4\mysql-connector-java-5.0.4-bin.jar. when i run a simple code to see if the driver is working or not i keep getting this error msg: Resource not found: ...

5. Using java with mysql JDBC    forums.oracle.com

Hello I'm trying to write a program which reads in tab-delimeted text files and then stores the results in a mysql database. The files are roughly 20,000 lines long and can have up to 10 columns, so for the biggest files I have 200,000 pieces of data to be stored seperately in the database. I'm currently using the readLine() method of ...

6. Automatic Generate Text File from mySQL    forums.oracle.com

Do you want MySQL to generate a text file? Or do you want to write some sort of program (not necessarily in Java) to extract data from a MySQL database and then write a text file using that info. If it is the first, ask at http://www.mysql.org/. If it is the second then first of all write the program. Then, if ...

7. Thoughts on MySql AB? Alternatives    forums.oracle.com

I am still not sure what alternatives or whatnot you are looking for. MySQL would not be first choice of databases. It has it's pros (free) but it also has it's cons (performance, stability, safety). Anyway I don't know if you are looking for alternatives in terms of databases or drivers or... ?

8. Java + MySQL Creating A Database    forums.oracle.com

Is it possible to create an SQL database in java with out having an initial database to connect to? So far im using: try{ String url = "jdbc:mysql://localhost:3306/MyDB"; String usr = "root"; String pwd = "root"; con = DriverManager.getConnection(url, usr, pwd); } But this assumes i have MyDB already created. From here I am able to create more DB's, but if ...

9. where have the java serlvet mysql guide    forums.oracle.com





10. mySQL: datatime?    forums.oracle.com

11. mysql access on a remote server    forums.oracle.com

You need to add your host name to the user account you are using to connect with. Doing this with administrative access levels is very easy using the GUI tools (MySQLAdmin). If you do not gave the GUI tools you will have to add the host record for the user account using SQL statements in the mysql command window. Either way, ...

12. Mysql database only for one java project    forums.oracle.com

Hello, Can anyone tell me if somehow I can connect mysql only for one java project. For e.g. I'm building a swing application I need to use database for some purposes. I want to have all in one. That my project will contain database only for it and nothing else. The user could not be able to connect to that mysql ...

13. Working with session beans and mysql    forums.oracle.com

in class where you match the username and password .if given user is exist in records then set it into session HttpSession session =request.getSession(); session.setAttribute("",); 3 tell the user they dont exist in the database or that there password is wrong and give them the option to either A) reset the password or B) create a user in same class if ...

14. Setting up MySQL in Netbeans IDE7    forums.oracle.com

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 ...