db.executeQuery()

[DedicatedOT]

so after I executeQuery(), how do I close the db connection?

I tried db.close(), db:close(), neither worked because it said something about cur:close() being NIL.

 

[nsanee]

db:free()

 

[DedicatedOT]

I tried that too, but it says the same thing, cur:close() is NIL.

 

[DedicatedOT]

[12/08/2009 16:12:27] data/db.lua:73: attempt to index field 'cur' (a nil value)
[12/08/2009 16:12:27] stack traceback:
[12/08/2009 16:12:27] data/db.lua:73: in function 'free'

 

[slaw]

You can't close it lol ;p

Connection is started only 1 time, and closed at shutdown.

 

[DedicatedOT]

But if you don't close it,... you'll have like 500+ connections open and your db will soon have "Too many connections."

Is there any similar functions to mysql_close()?

 

[Darad]

It doesn't work like that. The server has 1 open connection with the database and the queries you execute through db.executeQuery are executed over that 1 open connection.

 

[DedicatedOT]

Yes but I'm not talking about the server's default connection with the server, I'm talking about whenever I connect to the db. How do I close it since cur:close() doesn't work.

 

[Darad]

With php? Because if you connect via lua you connect via your ot server to the database who already has an open connection and won't be closed untill you shut down the server.