I've been testing the Transfer program on NT 4 + Oracle 8i + Oracle Parser + JDK1.2 and I've been experiencing some problems with datatypes... It seems that I...
32
Helen Cheng
helen_cheng@...
Apr 10, 2000 8:03 pm
Hi Ronald and All, Does anyone know where is the part of code (or API) in the Transfer program that reads database tables and determines column types? I found...
33
Gilberto ALVES-RAMOS
gilberto.alves-ramos@...
Apr 11, 2000 1:32 pm
I'm not sure but I think it can be related with the ODBC driver you are using... I had some problems trying to insert numeric values into tables... I switched...
34
Ronald Bourret
rpbourret@...
Apr 26, 2000 2:18 pm
Sorry to be so long in answering -- I've been travelling and haven't had email access. ... I have never used XML-DBMS with mysql, but don't know of any reasons...
35
Ronald Bourret
rpbourret@...
Apr 26, 2000 2:50 pm
Sorry to be so long responding -- I've been travelling and haven't had email access. ... The code for determining data types is in Map.addColumnMetadata. This...
36
helen
helen@...
Apr 26, 2000 3:28 pm
Hi,Mr Ronald, I am very appreciate for your reply. To a xmldbms system it is very important to generate map file from dtd file.And I am not sure about how to...
37
itzenova@...
Apr 27, 2000 3:37 pm
Hello, I have an element with 5 attributes. In the *.map file I put one of these attributes in the element table and I wanted to put the other 4 in a different...
38
Ronald Bourret
rpbourret@...
Apr 28, 2000 11:25 am
Sorry to be so long in responding. I've been travelling and haven't had any email access. ... Actually, the parser is independent of the database. That is, you...
39
Ronald Bourret
rpbourret@...
Apr 28, 2000 11:27 am
... Can you give me more details (map files, table schemas, etc.)? There shouldn't be any problems in doing this. -- Ron Bourret ...
40
Ronald Bourret
rpbourret@...
Apr 28, 2000 11:57 am
... Wow -- big question. I've been trying to answer these questions for almost two years... As to the general strategy of mapping XML to databases, the usual...
41
Ronald Bourret
rpbourret@...
Apr 28, 2000 12:08 pm
This is not currently supported. I'll have to look at the code (probably next Wednesday) but I suspect the reason is a timing problem -- knowing when all the...
42
Ronald Bourret
rpbourret@...
Apr 28, 2000 12:17 pm
... The algorithm is fairly simple and is just a special case of the possibilities supported by the mapping language. You can find information about it in the...
43
paul.beer@...
Apr 28, 2000 5:42 pm
trying to get the trnasfer demo to run on NT 4 w/SQL server 7.0 . data goes in to the DB, but I get this error my text fields are set as ntext , but I have...
44
Phil Friedman
pfriedma@...
Apr 28, 2000 9:13 pm
Is there a way to get a simple (same structure as the database?) mapping starting with an existing database? It looks like GenerateMap requires a DTD, then...
45
Divyesh Shah
s.divyesh@...
May 1, 2000 7:41 am
Hi, Do you have all the fields as text/ntext or integer also. Is it possible that some value you are trying to put in is with decimal or something. Can you...
46
Phil Friedman
pfriedma@...
May 2, 2000 8:08 pm
Well, I Hacked a map by hand, not too difficult to start but I have the rest of a very large database to map. Is there some reason we can't generate a default...
47
Phil Friedman
pfriedma@...
May 2, 2000 8:47 pm
Paul and others, There is a Microsoft SQL Server limitation that you will likely hit, which is that MSSS allows only 1 active result set per connection and the...
48
cgrundstrom@...
May 2, 2000 9:01 pm
Ronald, Xml-dbms is great! It solves a difficult problem in a nice way and the code is clean and well-commented. That said, here's my feature request. I would...
49
Ronald Bourret
rpbourret@...
May 3, 2000 11:35 am
There's no reason this can't be done. In fact, it was planned for the 1.0 release -- I simply ran out of time to implement it. The basic algorithm is that you...
50
Ronald Bourret
rpbourret@...
May 3, 2000 12:10 pm
... A candidate key is any set of columns that uniquely identifies a row in a table. A primary key is the specific set of columns that has actually been chosen...
51
Ronald Bourret
rpbourret@...
May 3, 2000 12:49 pm
... This is true. ... You are correct in that it is a database limitation and not a ODBC/JDBC driver limitation. As to how to fix it, the best way is probably...
52
Ronald Bourret
rpbourret@...
May 3, 2000 1:14 pm
I'm also curious about the table structure / data types. I wrote a quick program to print out the JDBC data type indicators and they are as follows: BIGINT: -5...
53
Phil Friedman
pfriedma@...
May 3, 2000 3:17 pm
Volunteers? Yes, I'm looking into it. My first pass may be just a flat map with no join information. Regards, Philip Friedman -- Terralink Software Systems --...
54
Phil Friedman
pfriedma@...
May 3, 2000 3:18 pm
Ron, Thanks for the explanation. In my experience if the key is joined to the foreign key, it's the primary key. But you are right, there are often other...
55
Phil Friedman
pfriedma@...
May 3, 2000 3:18 pm
Regards, Philip Friedman -- Terralink Software Systems -- 207-772-6500 x101 ... Sorry Carl, don't know where "Paul" came from. ... The way Transfer is...
56
Ronald Bourret
rpbourret@...
May 5, 2000 10:23 am
Nice catch! I finally got a chance to look at this and you are correct. Please note that this is in DOMToDBMS. -- Ron ... ...
57
Ronald Bourret
rpbourret@...
May 5, 2000 1:32 pm
... (probably ... knowing when ... parent table ... attributes are ... restructuring ... would mean ... I took a look at the code. The problem is definitely...
58
Ronald Bourret
rpbourret@...
May 5, 2000 3:11 pm
... This presents an interesting problem. Transfer belongs to a class of generic applications that can be used with any database. Because there is no way to ...
59
Ronald Bourret
rpbourret@...
May 5, 2000 3:24 pm
In the next couple of weeks, I am going to try to put out a bug fix release. This will not include any new features, but just clean up what minor bugs people...
60
Phil Friedman
pfriedma@...
May 8, 2000 1:25 pm
On Fri, 05 May 2000 17:10:35 CEST, "Ronald Bourret" ... ODBC uses a string of connection parameters which can contain the password "PWD=asdf;..." and any other...
