Win a copy of Svelte and Sapper in Action this week in the JavaScript forum!

raul Alejandro Montero Cruz

Greenhorn
+ Follow
since Jun 05, 2008
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by raul Alejandro Montero Cruz

The problem is, I use the resultSet object as global for all the things in the class. I don't know if it is the best way though.

let me explain better, i have a method that show the data in a table, filling up the global ResultSet and then showing its contents in the control. When i update something in the database, i call the method in charge of refreshing, in order to see the changes applied to the control.

the last one, what it does is simply clean up the table and call the method that shows the data. Because the ResultSet keeps the same value it appears like nothing happend to the user, when the changes did apply to the database.

if you have any other idea im opened to it
And thanks

heres the code to show the data:
Hi,

I'm creating a java class to manage all related to Database Management (Especifically MySQL) and i've been having trouble while trying to update a ResultSet.

The problem is that I have a method that executes an insert query. When I call it creates a new record on the DB but it does'nt appear in the ResultSet. I know i can simply refill the ResultSet again using a Statement Object and call its executeQuery method, but i find it a memory waste to do that only for a single new row.

is there a way to only update the record i just created?

here is the code that adds the row:


Hi, i'm making a personal proyect using the NetBeans IDE and i decided to implement databases using the pre-installed MySQL driver.

The thing is made a database binding to the elements method of a jList. The first couple of times worked but after that it kepp telling me :

java.io.WriteAbortedException: writing aborted; java.io.NotSerializableException: org.jdesktop.swingbinding.JListBinding$BindingListModel

it doesn't even show the window when i try to open it. And when i delete all the databases bindings to the proyect and to the jList it works well. The problem is i wanna work with databases

Thanks for your help
Hi, i'm making a personal proyect using the NetBeans IDE and i decided to implement databases using the pre-installed MySQL driver.

The thing is made a database binding to the elements method of a jList. The first couple of times worked but after that it kepp telling me :

java.io.WriteAbortedException: writing aborted; java.io.NotSerializableException: org.jdesktop.swingbinding.JListBinding$BindingListModel

it doesn't even show the window when i try to open it. And when i delete all the databases bindings to the proyect and to the jList it works well. The problem is i wanna work with databases

Thanks for your help!
what i mean is make queries IN the program so i can manipulate the data WHEN the program is running, not when is being coded.

is like when i press a button i can INSERT into a table or DROP or UPDATE or anything the SQL languaje can do with queries.

if the tutorial said that, i did'nt saw it.
i just fnish the tutorial, i did'nt know how to use the dervy database but insted i used a Mysql connection wich is lot easier.

anyway, now i know how to connect to them but how do i use the operations like save data into the database, extract it and delete it?

Thanks for your help. the tutorial was very helpfull!
i really dont know, since i'm using the the Netbeans IDE wich comes with GlassFish V2. and as i read is is some kind of RDMBS(Relationa Database Management System). How can i check out what drivers i'm using?
hey, i was reading the tutorial you gave me and i enconter some dificulties. I have Netbeans installed and it comes with glassfish V2. But for some reason when i try to to start the Java DB thats located in the services window it says : "Could not listen on port 1527 on host localhost." , do i have to setup a server or something?

i need to pass this step to be able to finish the tutorial

P.S.: I stared the Glassfish server and it keep telling me the same.
what i meant was how can i connect to a local database, save and extract information from the tables inside.

because all i found about JDBC tell me the database have to be on the internet since it ask me for the url.

hope this time is understanble
hi, i'm kinda new to databases in the java world. I began serching a way to connect to databases in java, specially ODBC and all i could find out was connecting to remote databases using an url to identy them.

Is there a way to connect to a database that i have in my computer an bound the file with the .jar so i can use it cross platform?

I'm in the middle of a personal proyect and because of that i cant keep going