I've written a first draft of the spec for the classes that pool connections and statements in version 2.0, as well as how SQL strings will be handled. You can...
1508
Sean
sean0x77
Oct 22, 2001 5:06 pm
I have a couple questions about the implementation of the new datasource /
statement manager spec:
1) Is creating PreparedStatements really that expensive an...
1509
Sean
sean0x77
Oct 22, 2001 6:03 pm
... _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com...
1510
Erik van Oosten
erikieus
Oct 23, 2001 7:16 am
A cheap way to get pooling going is to use Poolman: http://www.codestudio.com/PoolMan Erik....
1511
Ronald Bourret
rpbourret@...
Oct 23, 2001 9:10 am
... Yes. Executing an SQL statement has three parts: parsing the SQL statement, creating an access plan, and executing the access plan. The first two parts are...
1512
Ronald Bourret
rpbourret@...
Oct 23, 2001 9:11 am
... There is one issue here. The current design of the pooling code uses the DataSource interface from JDBC 2. I had hoped to reship DataSource.class as part...
1513
Ronald Bourret
rpbourret@...
Oct 23, 2001 9:21 am
... The problem is that the object factory for connections (may) need both user name and password to get a new connection. This is true for the ...
1514
Sean
sean0x77
Oct 23, 2001 3:22 pm
... _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com...
1515
Sean
sean0x77
Oct 23, 2001 3:46 pm
... _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com...
1516
SOMU
sumesh_b
Oct 23, 2001 5:54 pm
Do I need to have Class(java file) for the ClassMap tag in map file?...
1517
Ronald Bourret
rpbourret@...
Oct 23, 2001 7:36 pm
... I probably did. My mistake. ... This is a very real problem. Different connection factories need different information. For example,...
1518
Ronald Bourret
rpbourret@...
Oct 23, 2001 7:49 pm
... No. Classes are used only at the theoretical level. They are never created. Since many people already know object-relational mappings, viewing an XML...
1519
nasimson@...
netplusplus
Oct 24, 2001 3:01 am
Dear all, Peace be upon you. Is it must that any implementation of KeyGenerator Interface must use a database solution? If not, then Ron why did you implement...
1520
nasimson@...
netplusplus
Oct 24, 2001 3:11 am
Dear all, Peace be upon you. In a code (modified transfer.java) I am facing same problem as in message # <Adam before 397> that is: on reading this line in...
1521
Ronald Bourret
rpbourret@...
Oct 24, 2001 8:24 am
... No. For example, a KeyGenerator that generated GUIDs (unique numbers used by Windows) would not need databases. ... The implementation uses a high/low...
1522
Ronald Bourret
rpbourret@...
Oct 24, 2001 8:46 am
... Here are some possible solutions: 1) If you always store map files in the same directory, place the xmldbms.dtd in that directory. xmldbms.dtd is shipped...
1523
adam flinton
aflinton@...
Oct 24, 2001 1:09 pm
Have a look at the J2EE OpenSource stuff (e.g. JBoss / Enhydra) as Connection Pools are a std part of an App server. Statement pools aren't. However WRT to...
1524
Sean
sean0x77
Oct 24, 2001 3:49 pm
... _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com...
1525
adam flinton
aflinton@...
Oct 24, 2001 4:41 pm
... Not entirely accurate. If using the Datasource / JDBC 2.0 as in 1.1 a Conn Pool can /will be provided by the App server (or even the DB itself). I am ...
1526
adam flinton
aflinton@...
Oct 24, 2001 4:41 pm
... Humm. The thing is that unless you're needing to "roll your own" because the Db doesn't provide this & you're running outside of an App server all you need...
1527
adam flinton
aflinton@...
Oct 24, 2001 4:41 pm
Easiest thing is simply to remove that line from the Map file. 2nd easiest is to simply have it in the same dir as the Code/Jar & the 3'rd is to change the ref...
1528
adam flinton
aflinton@...
Oct 24, 2001 4:41 pm
... Nope. I have 2 which don't. 1 was a test using SOAP (to test SOAP) but....I don't much like it as SOAP needs to speed up to be usefull for this. The 2nd is...
1529
SOMU
sumesh_b
Oct 24, 2001 5:13 pm
Hi Ron Could you pl tell me what am I doing wrong here. I have very simple small map file <?xml version="1.0" ?> <!DOCTYPE XMLToDBMS SYSTEM "../xmldbms.dtd"> ...
1530
Ronald Bourret
rpbourret@...
Oct 24, 2001 8:10 pm
You need to map the Suspect element type using ToRootTable (if there is no ignored root element) or with the PseudoRoot element (if there is an ignored root...
1531
Ronald Bourret
rpbourret@...
Oct 24, 2001 8:40 pm
... I agree that we should allow users to use connection pooling provided by app servers/databases. The proposed architecture does this (it needs a bit of...
1532
Ronald Bourret
rpbourret@...
Oct 24, 2001 8:40 pm
... What's inaccurate? All I meant was that users don't plug the DataSource directly into DOMToDBMS/DBMSToDOM. Instead, they plug it into a wrapper (DbConn2)...
1533
Ronald Bourret
rpbourret@...
Oct 24, 2001 8:40 pm
... As long as the app server connection pool is in the form of a DataSource object -- my understanding is that it always is -- the proposed architecture can...
1534
Ronald Bourret
rpbourret@...
Oct 25, 2001 5:51 am
... I'm leaning back this way. My main objection was forcing people to use JDK 1.2, but if we can solve the problem by downloading a single jar, that's a good...
1535
Ronald Bourret
rpbourret@...
Oct 25, 2001 6:38 am
I took a quick look at PoolMan and it looks like a good product. However, I don't want to use it for the following reasons: 1) We can't create a pool based on...
1536
adam flinton
aflinton@...
Oct 25, 2001 9:26 am
... Yup. We just need to be able to "ask for a connection" as in a "getConnection()" method. This would allow a 2nd party /XD connection pool if none are...
