http://forums.hotjoe.com/posts/list/28.page JForum - http://www.jforum.net
I am new to JISQL.
Can anyone tell me how we can connect to another database or another user.
For example we have done create user A;
Now i want to change the user from current user to A.
How shall I do it.

In PSQL we do it like
\connect ot \c [DBNAME [USERNAME]]]]> http://forums.hotjoe.com/posts/preList/361/1523.page http://forums.hotjoe.com/posts/preList/361/1523.page GMT
Each JDBC driver vendor puts the database name in slightly different places. Off the top of my head I could change it so that the connection string has some sort of marker in it to include the database name and then add an option to specify the initial database. The cstring argument would look something like:

[code]jdbc:postgresql://localhost:5432/$DBNAME[/code]

and if you indicated that you wanted to connect to a different database then $DBNAME would be updated and Jisql would reconnect

Does that sound usable? It's kind of a pain - it requires a non-standard connection string though it wouldn't be difficult to support the standard one also.

Just a thought - let me know what you think about this change.]]> http://forums.hotjoe.com/posts/preList/361/1524.page http://forums.hotjoe.com/posts/preList/361/1524.page GMT
But when I tried to disconnect and reconnect by specifying the new user in connection string it shows an error.

For example build is my Linux user.
When i tried to connect to database using this user in connection string as :

jdbc:postgresql://localhost:5432:test_db22 -user build -password password -c \;

Then I am able to connect.
But when I create a user through sql command as:

Create user A;

And then try to coonect through user A as:

jdbc:postgresql://localhost:5432:test_db22 -user build -password password -c \;

It shows an error : ERROR: database "A" does not exist ErrorCode: 0

I want to connect to database though user created by database.

Also while trying doing so, I found following things:

1) My user 'Build ' has a password, but i when I did not specify the password, it asked me for password with message: "hit enter for no password".
I hit enter it then too it connected me to database.

2) Also if i specify the wrong database name, then it connect to any running database.

example: jdbc:postgresql://localhost:5432:test_db22 -user build -password password -c \;

After connection when i do:

select current_database;
it shows: shivani_db.

While I connected to test_db22(which did not exists).


Regards,
Shivani


]]> http://forums.hotjoe.com/posts/preList/361/1525.page http://forums.hotjoe.com/posts/preList/361/1525.page GMT