aspose file tools*
The moose likes JDBC and the fly likes Help on Sybase Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Help on Sybase" Watch "Help on Sybase" New topic
Author

Help on Sybase

Yogesh GA
Greenhorn

Joined: Apr 09, 2001
Posts: 6
i am working on WebSphere 3.5 with Sybase Adaptive Server Anywhere 6.0 as the backend.I am using jconnect 5.2 jdbc driver.Could you please help me with my following queries:
1)I have to run two ASA databases on the same machine .and i want a servlet to connect to both these databases simultaneously for ex: a servlet reads data from one db and updates the other.My problem is that though two instances of db's run the servlet always connect to that db which was started first. This must be because both the db's are running on the port 2638(default port for ASA 6.0).How to assign a different port number for multiple instances of databases.
Please let me know of any resources/links that helps developers who are working on Websphere/ASA.
Thanks,
Yogi
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
I haven't connected to Sybase with JDBC yet, but with other databases, you will connect to all databases running on a given database server via the same port. That should not be a problem.
The URL that you are passing to your JDBC driver should specify a different database for each connection. Are you doing that? Are you able to connect to the second DB at all, ever? These databases don't by any chance have the same name, do they?
Girish SV
Greenhorn

Joined: Jan 17, 2001
Posts: 14
Thanks Bodie Minster
Two databases running on the same m/c cannot run on the same
port.. right?
So, now if I want to connect my servlet to both the databases simulteniosly, how to assign different port no.s
(if I want to run two instances of databases)
Thanks
Girish
Yogesh GA
Greenhorn

Joined: Apr 09, 2001
Posts: 6
Hello Bodie Minster
Sudhir SV who has posted one more question is my colleage so pl dont get confused.
Yogesh GA.
 
wood burning stoves
 
subject: Help on Sybase