|
getting integer info.: msg#00235db.postgresql.novice
Two JDBC questions. I'm using the JDBC driver that I created when compiling postgres. 1) I use the following line to connect to postgres when I'm running servlets on the same machine as the database. conn = DriverManager.getConnection("jdbc:postgresql:business","postgres",""); How do I change this URL to be used when connecting across the lan? 2) It seems that there is a problem getting an integer from a result set. If you use a simple select statement and it fills the result set with a string you can use the result.getString("columnname"); and it works fine. If you the same type of select with an integer column, and you use result.getInt("columnname"), it immediately goes to the catch block. (result is really a ResultSet object instance). Any help in this would be very helpful. -Mark ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx |
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Re: base36 sequence: 00235, Tom Lane |
|---|---|
| Next by Date: | Re: getting integer info.: 00235, Jeff Deroshia |
| Previous by Thread: | null value in date fieldi: 00235, Jeff Deroshia |
| Next by Thread: | Re: getting integer info.: 00235, Jeff Deroshia |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
| News | FAQ | advertise |