UltraliteJ/12 ResultSetMetadata.getCorrelationName(i)

This is a multi-part message in MIME format.

---=_forums-1-dub4d10dff4
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 7bit

For the statement "SELECT count(*) as mycount FROM
TestTable", I'm getting the following behaviour:

ResultSetMetadata.getCorrelationName(1) returns null,
ResultSetMetadata.getTableName(1) returns null,
ResultSetMetadata.getTableColumnName(1) returns "mycount".

Shouldn't the CorrelationName be "mycount" and the
TableColumnName be null?

I'm running UltraliteJ 12.0.0.2601 and have attached an
example.

Thanks,
Terry

---=_forums-1-dub4d10dff4
Content-Type: text/x-java-source; name="MyULTest.java"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="MyULTest.java"

aW1wb3J0IG5ldC5yaW0uZGV2aWNlLmFwaS5jb21tYW5kLkNvbW1hbmQ7DQpp
bXBvcnQgbmV0LnJpbS5kZXZpY2UuYXBpLmNvbW1hbmQuQ29tbWFuZEhhbmRs
ZXI7DQppbXBvcnQgbmV0LnJpbS5kZXZpY2UuYXBpLmNvbW1hbmQuUmVhZE9u
bHlDb21tYW5kTWV0YWRhdGE7DQppbXBvcnQgbmV0LnJpbS5kZXZpY2UuYXBp
LnVpLk1lbnVJdGVtOw0KaW1wb3J0IG5ldC5yaW0uZGV2aWNlLmFwaS51aS5V
aUFwcGxpY2F0aW9uOw0KaW1wb3J0IG5ldC5yaW0uZGV2aWNlLmFwaS51aS5j
b21wb25lbnQuRGlhbG9nOw0KaW1wb3J0IG5ldC5yaW0uZGV2aWNlLmFwaS51
aS5jb21wb25lbnQuTGFiZWxGaWVsZDsNCmltcG9ydCBuZXQucmltLmRldmlj
ZS5hcGkudWkuY29udGFpbmVyLk1haW5TY3JlZW47DQppbXBvcnQgbmV0LnJp
bS5kZXZpY2UuYXBpLnV0aWwuU3RyaW5nUHJvdmlkZXI7DQoNCmltcG9ydCBj
b20uaWFueXdoZXJlLnVsdHJhbGl0ZWoxMi5Db25maWdGaWxlTUU7DQppbXBv
cnQgY29tLmlhbnl3aGVyZS51bHRyYWxpdGVqMTIuQ29ubmVjdGlvbjsNCmlt
cG9ydCBjb20uaWFueXdoZXJlLnVsdHJhbGl0ZWoxMi5EYXRhYmFzZU1hbmFn
ZXI7DQppbXBvcnQgY29tLmlhbnl3aGVyZS51bHRyYWxpdGVqMTIuUHJlcGFy
ZWRTdGF0ZW1lbnQ7DQppbXBvcnQgY29tLmlhbnl3aGVyZS51bHRyYWxpdGVq
MTIuUmVzdWx0U2V0Ow0KaW1wb3J0IGNvbS5pYW55d2hlcmUudWx0cmFsaXRl
ajEyLlJlc3VsdFNldE1ldGFkYXRhOw0KaW1wb3J0IGNvbS5pYW55d2hlcmUu
dWx0cmFsaXRlajEyLlVMakV4Y2VwdGlvbjsNCg0KcHVibGljIGNsYXNzIE15
VUxUZXN0IGV4dGVuZHMgVWlBcHBsaWNhdGlvbiB7DQoNCglwdWJsaWMgTXlV
TFRlc3QoKSB7DQoJCXB1c2hTY3JlZW4oIG5ldyBNeVVMVGVzdFNjcmVlbigp
ICk7DQoJfQ0KDQoJcHVibGljIHN0YXRpYyB2b2lkIG1haW4oU3RyaW5nW10g
YXJncykgew0KCQluZXcgTXlVTFRlc3QoKS5lbnRlckV2ZW50RGlzcGF0Y2hl
cigpOw0KCX0NCg0KCXB1YmxpYyBjbGFzcyBNeVVMVGVzdFNjcmVlbiBleHRl
bmRzIE1haW5TY3JlZW4gew0KDQoJCXByaXZhdGUgTGFiZWxGaWVsZCBfdGl0
bGU7DQoJCXByaXZhdGUgTGFiZWxGaWVsZCBfbWVzc2FnZTsNCg0KCQlwdWJs
aWMgTXlVTFRlc3RTY3JlZW4oKSB7DQogICAgICAgICAgICBfdGl0bGUgPSBu
ZXcgTGFiZWxGaWVsZCggIk15VUxUZXN0IiAsIExhYmVsRmllbGQuRUxMSVBT
SVMgfCBMYWJlbEZpZWxkLlVTRV9BTExfV0lEVEgpOw0KCQkJc2V0VGl0bGUo
IF90aXRsZSApOw0KICAgICAgICAgICAgX21lc3NhZ2UgPSBuZXcgTGFiZWxG
aWVsZCgpOw0KCQkJYWRkKCBfbWVzc2FnZSApOw0KDQoJCQlfdGVzdE1lbnVJ
dGVtLnNldENvbW1hbmQobmV3IENvbW1hbmQobmV3IENvbW1hbmRIYW5kbGVy
KCkgew0KCSAgICAgICAgICAgIHB1YmxpYyB2b2lkIGV4ZWN1dGUoUmVhZE9u
bHlDb21tYW5kTWV0YWRhdGEgbWV0YWRhdGEsIE9iamVjdCBjb250ZXh0KSB7
DQoJICAgICAgICAgICAgCW9uVGVzdCgpOw0KCSAgICAgICAgICAgIH0NCgkg
ICAgICAgIH0pKTsNCgkJCWFkZE1lbnVJdGVtKCBfdGVzdE1lbnVJdGVtICk7
DQoJCX0NCgkJDQogICAgICAgIHByaXZhdGUgTWVudUl0ZW0gX3Rlc3RNZW51
SXRlbSA9IG5ldyBNZW51SXRlbSAobmV3IFN0cmluZ1Byb3ZpZGVyKCJUZXN0
IikgLCAweDIzMDAzMCAsIDMwKTsNCiAgICAgICAgDQogICAgICAgIHByaXZh
dGUgdm9pZCBvblRlc3QoKSB7DQoJCQl0cnkgew0KCQkJCUNvbmZpZ0ZpbGVN
RSBjb25maWcgPSBEYXRhYmFzZU1hbmFnZXIuY3JlYXRlQ29uZmlndXJhdGlv
bkZpbGVNRSggImZpbGU6Ly8vU0RDYXJkL1Rlc3QudWxqIiApOw0KCQkJCUNv
bm5lY3Rpb24gY29ubiA9IERhdGFiYXNlTWFuYWdlci5jcmVhdGVEYXRhYmFz
ZSggY29uZmlnICk7DQoJCQkJX3RpdGxlLnNldFRleHQoICJNeVVMVGVzdDog
IiArIGNvbm4uZ2V0RGF0YWJhc2VJbmZvKCkuZ2V0UmVsZWFzZSgpICk7DQoJ
CQkJY3JlYXRlRGF0YWJhc2VTY2hlbWEoIGNvbm4gKTsNCg0KCQkJCXRlc3Qy
KCBjb25uICk7DQoJCQl9IGNhdGNoKCBFeGNlcHRpb24gZXggKSB7DQoJCQkJ
RGlhbG9nLmFsZXJ0KCAiRXhjZXB0aW9uW29uVGVzdF06ICIgKyBleC50b1N0
cmluZygpICk7DQoJCQl9ICAgICAgICAJDQogICAgICAgIH0NCg0KICAgIAlw
cml2YXRlIFN0cmluZ1tdIF9kZGwgPSB7DQogICAgCQkNCiAgICAJCSJDUkVB
VEUgVEFCTEUgVGVzdFRhYmxlICgiKw0KICAgIAkJIiBpZCBJTlRFR0VSIisN
CiAgICAJCSIsIHggRE9VQkxFIE5VTEwiKw0KICAgIAkJIiwgeSBET1VCTEUg
TlVMTCIrDQogICAgCQkiLCBQUklNQVJZIEtFWSAoIGlkIEFTQyApIisNCiAg
ICAJCSIpIiwNCg0KICAgIAl9Ow0KICAgIAkNCiAgICAgICAgcHJpdmF0ZSB2
b2lkIGNyZWF0ZURhdGFiYXNlU2NoZW1hKCBDb25uZWN0aW9uIGNvbm4gKSB0
aHJvd3MgVUxqRXhjZXB0aW9uIHsNCiAgICAJCWZvciggaW50IGk9MDsgaTxf
ZGRsLmxlbmd0aDsgaSsrICkgew0KICAgIAkJCVByZXBhcmVkU3RhdGVtZW50
IHBzID0gY29ubi5wcmVwYXJlU3RhdGVtZW50KCBfZGRsW2ldICk7DQogICAg
CQkJcHMuZXhlY3V0ZSgpOw0KICAgIAkJCXBzLmNsb3NlKCk7CQkNCiAgICAJ
CX0JCQ0KICAgIAl9DQogICAgCQ0KLy8gICAgICAgIHByaXZhdGUgdm9pZCB0
ZXN0KCBDb25uZWN0aW9uIGNvbm4gKSB0aHJvd3MgVUxqRXhjZXB0aW9uIHsN
Ci8vCQkJU3RyaW5nIHNxbCA9ICJVUERBVEUgVGVzdFRhYmxlIFNFVCB4PXki
Ow0KLy8JCQlQcmVwYXJlZFN0YXRlbWVudCBwcyA9IGNvbm4ucHJlcGFyZVN0
YXRlbWVudCggc3FsICk7DQovLwkJCXBzLmV4ZWN1dGUoKTsNCi8vCQkJcHMu
Y2xvc2UoKTsJCQ0KLy8gICAgICAgIH0NCg0KICAgICAgICBwcml2YXRlIHZv
aWQgdGVzdDIoIENvbm5lY3Rpb24gY29ubiApIHRocm93cyBVTGpFeGNlcHRp
b24gew0KCQkJU3RyaW5nIHNxbCA9ICJTRUxFQ1QgY291bnQoKikgYXMgbXlj
b3VudCBGUk9NIFRlc3RUYWJsZSI7DQoJCQlQcmVwYXJlZFN0YXRlbWVudCBw
cyA9IGNvbm4ucHJlcGFyZVN0YXRlbWVudCggc3FsICk7DQoJCQlSZXN1bHRT
ZXQgcnMgPSBwcy5leGVjdXRlUXVlcnkoKTsNCgkJCVJlc3VsdFNldE1ldGFk
YXRhIHJzbSA9IHJzLmdldFJlc3VsdFNldE1ldGFkYXRhKCk7DQoJCQlTdHJp
bmdCdWZmZXIgYnVmID0gbmV3IFN0cmluZ0J1ZmZlcigpOw0KCQkJYnVmLmFw
cGVuZCggIkNPUlJOQU1FPSIgKyByc20uZ2V0Q29ycmVsYXRpb25OYW1lKDEp
ICk7DQoJCQlidWYuYXBwZW5kKCAiXG5UQUJMRU5BTUU9IiArIHJzbS5nZXRU
YWJsZU5hbWUoMSkgKTsNCgkJCWJ1Zi5hcHBlbmQoICJcbkNPTFVNTk5BTUU9
IiArIHJzbS5nZXRUYWJsZUNvbHVtbk5hbWUoMSkgKTsNCgkJCXBzLmNsb3Nl
KCk7DQoJCQlfbWVzc2FnZS5zZXRUZXh0KCBidWYudG9TdHJpbmcoKSApOw0K
ICAgICAgICB9DQoJfQ0KfQ0K

---=_forums-1-dub4d10dff4--
0
Terry
12/21/2010 5:12:20 PM
sybase.sqlanywhere.ultralite 2982 articles. 0 followers. Follow

2 Replies
527 Views

Similar Articles

[PageSpeed] 32

A correlation name is not the same as a column alias or in the case of 
ResultSetMetadata, the TableColumnName.  A correlation name is an 
alternate name for tables (or other supported database objects deoending 
on the database) in the FROM clause of a select statement or the first 
clause of a UPDATE or DELETE.

i.e., TableName is the correlation name for the following:

	select count(*) from t as TableName
	delete t as TableName where TableName.c = ...
	update t as TableName where TableName.c = ...

-chris

On 12/21/2010 12:12 PM, Terry Wilkinson wrote:
> For the statement "SELECT count(*) as mycount FROM
> TestTable", I'm getting the following behaviour:
>
> ResultSetMetadata.getCorrelationName(1) returns null,
> ResultSetMetadata.getTableName(1) returns null,
> ResultSetMetadata.getTableColumnName(1) returns "mycount".
>
> Shouldn't the CorrelationName be "mycount" and the
> TableColumnName be null?
>
> I'm running UltraliteJ 12.0.0.2601 and have attached an
> example.
>
> Thanks,
> Terry

0
Chris
12/22/2010 8:16:45 PM
Thanks for the explanation.  I ran some more tests and now I
think I understand the differences between CorrelationName,
AliasName, WrittenName, QualifiedName, etc.

Thanks again,
Terry

> A correlation name is not the same as a column alias or in
> the case of  ResultSetMetadata, the TableColumnName.  A
> correlation name is an  alternate name for tables (or
> other supported database objects deoending  on the
> database) in the FROM clause of a select statement or the
> first  clause of a UPDATE or DELETE.
>
> i.e., TableName is the correlation name for the following:
>
>     select count(*) from t as TableName
>     delete t as TableName where TableName.c = ...
>     update t as TableName where TableName.c = ...
>
> -chris
>
> On 12/21/2010 12:12 PM, Terry Wilkinson wrote:
> > For the statement "SELECT count(*) as mycount FROM
> > TestTable", I'm getting the following behaviour:
> >
> > ResultSetMetadata.getCorrelationName(1) returns null,
> > ResultSetMetadata.getTableName(1) returns null,
> > ResultSetMetadata.getTableColumnName(1) returns
> "mycount". >
> > Shouldn't the CorrelationName be "mycount" and the
> > TableColumnName be null?
> >
> > I'm running UltraliteJ 12.0.0.2601 and have attached an
> > example.
> >
> > Thanks,
> > Terry
>
0
Terry
12/23/2010 6:44:57 PM
Reply:

Similar Artilces:

12 #12
Name: hazza Email: hamzza38athotmaildotcom Product: Firefox Summary: 12 Comments: ;bj Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9b2) Gecko/2007121120 Firefox/3.0b2 From URL: http://hendrix.mozilla.org/ Note to readers: Hendrix gives no expectation of a response to this feedback but if you wish to provide one you must BCC (not CC) the sender for them to see it. ...

12 #12
Name: selim Email: yaralidotkalpathotmail.com Product: Gran Paradiso Alpha 1 Summary: 12 Comments: ukytrı86r86 Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9a1) Gecko/20061218 Minefield/3.0a1 ...

12-12-1963
Name: yücel Email: ydotkelekciatmynet.com Product: Gran Paradiso Alpha 1 Summary: 12-12-1963 Comments: teşekkürler Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; tr; rv:1.9a1) Gecko/20061215 Minefield/3.0a1 ...

12 to 12.5
I want to create a 12.5 server with 2K pagesize, and with the same device names and sizes. (Except for the system devices). Should be able to do a simple dump and load from the 12 to the 12.5 without mixing up the data and log, correct? Thanks. If the database is created with the same order and size of fragments (rows in sysusages), and assuming same OS platform, yes. PhilipL wrote: > > I want to create a 12.5 server with 2K pagesize, and with the same device > names and sizes. (Except for the system devices). Should be able to do a > simple dump and load from the ...

Mobilink synchronisation with Ultralite and UltraliteJ
Hi all, If you start a Mobilinik server, can you connect to it from both Ultralite and UltraliteJ databases on the same port? Cheers, Shao On 12/10/2010 8:20 AM, Shao Chan wrote: > If you start a Mobilinik server, can you connect to it from both Ultralite > and UltraliteJ databases on the same port? Yes, assuming they are all using the same protocol (HTTP for example). SQL Anywhere clients (dbmlsync) would also be able to connect using the same protocol on the same port. -- Reg Domaratzki - Sybase Please reply only to the newsgroup Documentation : Exer...

sqlanywhere and sqlanywhere server
Currently i am using sqlanywhere and powerbuilder tool as my system development. And i am developing a standalone system. Let say, if i want to migrate my standalone system to client-server system, how do i do that? I heard that i need to have sqlanywhere(server engine) to deploy my system as client-server system. If so, do i need to install sqlanywhere(server engine) into window NT or just normal pc(treat as server). For client-server system, do i need to install sqlanywhere server at server and sqlanywhere client as normal pc where my program is installed? Could someone tell me where...

Data case sensitive in ultralite and ultraliteJ
I have a problem about case sensitive of data in ultralite and ultraliteJ database. If I have a table articles like this : name 'Desktop' 'drop' And I have the request SQL like this: select * from articles where name like 'd%' order by name I test the request in ultralite and ultraliteJ. I find that I can get 'Desktop' and 'drop' in ultralite and get only 'drop' in ultraliteJ. It means that ultralite is case-insensitive and ultraliteJ is case- sensitive? My question is : Is ultralite case-sensitive about data? Thanks ...

ERROR CONNNECTING POCKETBUILDER WITH SQLANYWHERE ULTRALITE 10
Hello!! I am developing a program in pocketbuilder 2.1.1042 with SQLAnywhere Ultralite developer edition 10.0.1.3579 for an equip HTC S621 with WINDOWS MOBILE 5. For the connection I am using a file .ini that contains the following thing: [DataBase] DBMS=ul10 Database= UserId= DatabasePassword = LogId= LogPassword= ServerName= DbParm=ConnectString='DBF=\Program Files\ulsample\routestandar.udb;UID=dba;PWD=sql' I already have installed SQLAnywhere Ultralite developer edition 10.0.1.3579 in the equip HTC. The connection in the application I maded it using connecti...

SQLAnywhere and Novell 3.12
I have a site where there is a server with Novell 3.12 (will be going to Win NT at some point) and SQLAnywhere 5.0.03 build #884 running on it. The utilization (as shown by MONITOR.NLM) occasionally hits 100 whereafter the system freezes almost permanently. The network manager resorts to the 'big red switch' to get the system going again. Occasionally is happening more frequently than tolerable now. Are there any suggestions as to what to look at or what can be done. TIA Gary Knighton 1) upgrade to 5.5.04 2) Look at your queries/procedures. Make sure your execution ...

SeaMonkey Triage Week (2010-12-06 to 2010-12-12)
Hello everybody! The SeaMonkey project needs your help triaging our bug reports in Bugzilla, to reduce the amount of bugs with an unknown status (see [1]). We have many UNCONFIRMED or NEW bugs where it's not clear if they are still an issue or not. To get these numbers down to a reasonable level while focusing especially on the UNCONFIRMED bugs, we need your help looking at those bug reports. To make it easier for you, we look at different components each day and have three time slots each day so everybody should have the chance to join us on irc.mozilla.org in channel...

Perl 6 Summary for 2005-12-05 through 2005-12-12
Perl 6 Summary for 2005-12-05 through 2005-12-12 All~ Welcome to another Perl 6 summary. This week, like last, Parrot has produced the highest volume of emails. Fine by me, Parrot tends to be easiest to summarize. This summary is brought to you by Snow (the lates= t soft toy in the house). I would say you should get one, but apparently Borders stores everywhere are sold out of them. He is quite soft and a little mischievous. Maybe he belonged to a samurai once... Perl 6 Compiler Context Confusion Mike Li wondered how to make his sample code w...

is there a way i can get just this part of date 12/12/2007 as opposed to 12/12/2007 17:42:00 by using getdate()
is there a way i can get just this part of date 12/12/2007 as opposed to 12/12/2007 17:42:00 by using getdate() try this.. select convert(varchar ,getdate(),101)Thanks, Mahadeo-----------------------------------------------Best is Not the END point, but a starting point for Innovation------------------------------------------------Remember to mark posts as the "Answer" to help future users. 101 gives mm/dd/yyyy format.  If you need dd/mm/yyyy, try  select convert(varchar ,getdate(),103)   See this for other formats -- Please Mark Posts that helped you a...

SQLAnywhere 5.04 running on Novell 3.12
Has anyone out there experienced any problems with the NLM for SLQAnywhere running on Novell 3.12. We are seeing some very weird results. After the database server runs for a while (that can be anywhere from 4 hours to 4 days) it will just up and unload itself or the server will abend. Sometimes it also abends the file server, sometimes not. All that appears to be consistent is the fact that after DBSRV50 unloads - there is a message stating that xxxx resources could not be recovered (from the Novell server). We have tried 5.01 - 5.04 and appear to be getting the same results. ...

pbcat tables from SQLAnywhere 5.5 to ASE 12
What's the best, easiest way to get the info from the pbcat tables (namely pbcatcol, pbcatedt, and pbcattbl) in a SQLAnywhere 5.5 database to the new database on ASE 12? We are moving from SQLAnywhere to ASE and we would like out edit styles and everything else to be migrated to the new database. TIA, Scott The short answer would be to use pipelines to get the data in the five PB tables from one database to another. However, as one database may have issues with certain datatypes and formats... etc. you may have to tweak them a little as the need arises. HTH -EGM ...

Web resources about - UltraliteJ/12 ResultSetMetadata.getCorrelationName(i) - sybase.sqlanywhere.ultralite

Resources last updated: 12/3/2015 10:19:28 PM