better declare this method, as static or not?

[Jefhandle]

hi,
i have a java class Myconnector.java which has a mehod giveMeConnectionToDatabase to connect with mysql database
All Other 25 servlets create an instance of this class and
becomm own connection to access database.
My method and my class arent static. Theis mehthod
is not synchronized too.
I havent yet problem with my aoolication, but iwill know
which method is better to use.
Thanks

 

[sedj]

Probably makes sense to make it static.
You don't need to worry about synchronization (unless you are doing something odd).

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[Diancecht]

Just some hints:

Nice tutorial about static methods:

http://www.javaworld.com/javaworld/javaqa/2001-11/03-qa-1121-mrhappy.html

A regular class can't be declared as static :

http://www.javaworld.com/javaworld/javaqa/1999-08/01-qa-static2.html

Cheers,
Dian

 

[Jefhandle]

but if i make it static i have physicaly one connection to database!!!!??
The other Question is, what is the Goal of Java and Object philosophy in java. I mean if i have more Connection to database is better than to have some crash by usinig only
one connection, which would be invoked from f.i 50 User??
The other Questtion is,if making more connections in
java programm depends on kind of using database or not?????
regards

 

[sedj]

Easy with the question marks fella ...

If you make the getConnection() method static, it does NOT mean you only have one connection to the database.

This forum is not the right place to discuss Java and Object-orientated design. If you want to know more, then use google and do some reading.


--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk