First that All I want to help and learn.
I have work for about 3.5 years using servlets and java. We have developed a lot of
systems using diferent DB (Oracle 7 and 8, MSSQL servler 6.5 and 7, DB2, Access
(odbc), Cloudscape, and InstanDB).
We always use PreparedStatements instead of statements and it works so fine for us. We
NEVER have had strange problems.
I do not understand the real need of the Adaptor in the turbina connection pool.
We have our own connection pool and it works so well, and the developer do not have to
write any aditional classes for use it.
It support following parameters:
autoCommit
freeTimeout
lockedTimeout
getTimeout
maxConnections
driver
url
user
password
A pool can be loaded directly, by a name or with a configuration file.
When we need to add a new driver we simple create a file with the configuration, put a
line in a file and that is all.
The central configuration file is :
/co/com/pragma/META-INF/DBManager.properties it has the name of the files with the
pools definition.
This is importan for us becouse in one single server could be running some diferent
systems and we do not want that all the people knows the users and pwds of the other
people. That is why connection is defined in a separate file.
The DBManager use a PropertiesManager utility which is attached too.
We also define ALL the statemens of the project (application or system) in one or some
XML files and use that statements with a alias name.
We also have our own HTML template mechanism I attached a template example. All the
documentation is in english, but if you want it i can give the sources and the
documentation to you.
I really want to help.
What do you think about all this?
At least you can think about give a default behavior with out the need of write an
Adaptor, and incorporate some of the parameters.
Let me know what do you think.
Thank in advance for your attention.
You can find the files at: http://www.pragma.com.co/pgomez.
The files are are:
template_example.html
pool_example.properties
pjrTemplates.html (Los que sepan espa�ol pueden ver una descripci�n completa de
nuestro esquema de plantillas)
src.zip
We can share the templates source too.
About the templates:
The fundamental idea is to have the content separate of the HTML code.
Then you can pass to the template procesor a ResultSet, a Statement to be executed
dinamically, the form data, the session data, the cookies data, properties data, etc.
We develop that after see WebMacro and other tecnologies. You have to remember that
they are to integrate content with HTML, no for producing content.
______________________________________
Message sent with Misiva.
Visit us at http://www.pragma.com.co/misiva
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
