InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

Juergen

I think the syntax should be:

SET DEFAULT_USERNAME uname DEFAULT_PASSWORD pword

If that still gives problems then try setting the properties:

tablename%username=value
tablename$password=value

Regards

Pete

--

Peter Hearty                         peter.hearty@lutris.com
Lutris Technologies (UK)        http://www.lutris.com
----- Original Message -----
From: "Juergen Roeder" <juergen-roeder@t-online.de>
To: <instantdb@enhydra.org>
Sent: Friday, September 08, 2000 9:56 AM
Subject: InstantDB: Import Data from JDBC Data Sources Problem


Dear Peter!
I'm trying to import data from a Informix SQL Server table into InstantDB
(3.20 beta 2) using the IMPORT-Statement shown on the InstantDB import.htm
web site.
Running the IMPORT-Statement brings up the error message under (A).
If i try to set the deafult username and password, the error message under
(B) comes up.
What's going wrong?
Thanks for help in advance! (juergen-roeder@t-online.de)
Juergen Roeder

============================================================================
===============================================
(A)
============================================================================
===============================================
Import.main() sql_drop_table = DROP TABLE stt
Import.main() sql_import_from_file = IMPORT stt FROM 'stt.txt' USING
'stt_schema.txt' BUFFER 2048
Import.main() sql_import_from_jdbc = IMPORT stt FROM URL
'jdbc:informix-sqli://192.168.168.3:1528/jdata:INFORMIXSERVER=dbs730_rm300'
USING 'SELECT * FROM stt' BUFFER 2048
Import.main() sql_select = SELECT * FROM stt
Import.main() idbURL = jdbc:idb:d:\de\plus\base\properties\stt.prp
Enhydra InstantDB - Version 3.20 beta 2
The Initial Developer of the Original Code is Lutris Technologies Inc.
Portions created by Lutris are Copyright (C) 1997-2000 Lutris Technologies,
Inc.
All Rights Reserved.
main DROP TABLE stt
Import.main() sql_drop_table       rc = -1
main IMPORT stt FROM URL
'jdbc:informix-sqli://192.168.168.3:1528/jdata:INFORMIXSERVER=dbs730_rm300'
USING 'SELECT * FROM stt' BUFFER 2048
main java.sql.SQLException: Incorrect password or user
com.informix.asf.IfxASFRemoteException:  is not known on the database
server.
java.sql.SQLException: Incorrect password or user
com.informix.asf.IfxASFRemoteException:  is not known on the database
server.
 at org.enhydra.instantdb.db.SQLProg.execute(SQLProg.java:276)
 at org.enhydra.instantdb.jdbc.idbStatement.execute(idbStatement.java,
Compiled Code)
 at
org.enhydra.instantdb.jdbc.idbStatement.executeUpdate(idbStatement.java:103)
Database stt is shutting down...
Database stt shutdown complete.
 at Import.main(Import.java:134)
============================================================================
==================================
(B)
============================================================================
================================================
Import.main() sql_drop_table       = DROP TABLE stt
Import.main() sql_import_from_file = IMPORT stt FROM 'stt.txt' USING
'stt_schema.txt' BUFFER 2048
Import.main() sql_import_from_jdbc = IMPORT stt FROM URL
'jdbc:informix-sqli://192.168.168.3:1528/jdata:INFORMIXSERVER=dbs730_rm300'
USING 'SELECT * FROM stt' BUFFER 2048
Import.main() sql_select           = SELECT * FROM stt
Import.main() idbURL               =
jdbc:idb:d:\de\plus\base\properties\stt.prp
Enhydra InstantDB - Version 3.20 beta 2
The Initial Developer of the Original Code is Lutris Technologies Inc.
Portions created by Lutris are Copyright (C) 1997-2000 Lutris Technologies,
Inc.
All Rights Reserved.
main SET DEFAULT_USERNAME ******
Import.main() sql_set_default_username rc = -1
main SET DEFAULT_PASSWORD *******
main SET DEFAULT_PASSWORD *******
 Don't understand SQL after: "SET"
 Expected: "DATE" found: "DEFAULT_PASSWORD"
java.sql.SQLException: SET DEFAULT_PASSWORD *******
 Don't understand SQL after: "SET"
 Expected: "DATE" found: "DEFAULT_PASSWORD"
 at org.enhydra.instantdb.db.SQLProg.execute(SQLProg.java:215)
 at org.enhydra.instantdb.jdbc.idbStatement.execute(idbStatement.java,
Compiled Code)
 at
org.enhydra.instantdb.jdbc.idbStatement.executeUpdate(idbStatement.java:103)
Database stt is shutting down...
Database stt shutdown complete.
 at Import.main(Import.java:126)





-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.