updating database in the remote machine?

is it possible to have a database program running on a local machine and use it to update the database in the remote machine?

[139 byte] By [CYung] at [2007-9-26 1:26:33]

«« registry editing with java
»» registry editing with java

# 1

Yes it is definately possible. i can give details about how to connect if you can tell me which databse you are using. incase us are using Oracle I would recommend you to use any of the type 4 driver provided by the Oracle Corp.You need specify the information about Remote address , port, Database UserName and Password in the driver configruation.

If you post your code i can explain you in detail where excatly u need to make changes.

thats all.

samsidd at 2007-6-29 1:09:38 >

top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...

# 2

I am still on the designing process ...

I am comfortable with using MS Access with JDBC on local machine only.

In the remote machine, there are Oracle, InstantDB and HSQL drivers installed.

I am not sure how can I create a data base file?

for example, with MS Access we would code like this:

private String url = "jdbc:odbc:grade";

private String username = "yung";

private String password = "1234";

Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );

connection = DriverManager.getConnection(

url, username, password );

I created "grade" with MS Access, but how can I do it for Oracle?

Execute "CREATE TABLE" ?

CYung at 2007-6-29 1:09:38 >

# 3

You can also use the ODBC Driver to connect to a remote machine and not change any code. In WinX systems goto the control panel and config ODBC Data Sources to point to the remote machine.

Massarian at 2007-6-29 1:09:38 >

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

updating database in the remote machine?

Database Connectivity New Topic

Database Connectivity Hot Topic

Database Connectivity

All Classified