Re: JDBC can connected informix_se DBMS but not to the databases

Elham Not sure about why it works with the space in it either. Bringing up the sqlexecd is a given. I didn't even find this one out myself. I found this after several frustrating attempts to connect using JDBC to my SE database on my Linux machine at home, and asking in cdi in desperation. It used to give my -908 (AFAI remember) without the space, and with the space it does not. Go figure! Sujit echandler@my-deja.com on 08/28/2000 01:31:24 PM Please respond to echandler@my-deja.com To: informix-list@iiug.org cc: Subject: Re: JDBC can connected informix_se DBMS but not to the databases As far as I know, in order to connect to an SE server using JDBC, you just need to bring up your sqlexecd deamon process and then use that port number in your URL. I'm not sure what the spacing in your login path has to do with anything... Elham In article <8o3hvu$2g4$1@news.xmission.com>, Sujit.Pal@bankofamerica.com wrote: > > > vwxchoy > > Your URL needs to be specified like so... > Connection conn = DriverManager.getConnection > ("jdbc:informix-sqli://somehost:1536:/ /full/path/to/login" + > "INFORMIXSERVER=server_se;" + > "user=vwfecom;" + > "password=testpass;" > > Note the space between the / and /full/path/to/login. This style is needed to > access SE databases. > > HTH > Sujit > > vwxchoy@hotmail.com on 08/21/2000 05:28:54 AM > > Please respond to vwxchoy@hotmail.com > > To: informix-list@iiug.org > cc: > Subject: JDBC can connected informix_se DBMS but not to the databases > > Hello, > > I am having a problem with getting jdbc to see the DBMS's (server_se) > database (login). The database login contains a table called login. > > Connection conn = DriverManager.getConnection > ("jdbc:informix-sqli://somehost:1536:/login" + > "INFORMIXSERVER=server_se;" + > "user=vwfecom;" + > "password=testpass;" > > I put the above within a 'try' > > and catch catch with > System.out.println("Could connect to db....."); > System.out.println(e); > > now standard I/0 produces: > > Could not CONNECT to DATABASE server..... > java.sql.SQLException > > Exception occurred during event dispatching: > java.lang.RuntimeException: Error occurred while connecting to database: > Database not found or no system permission. > at JLogin.ping(JLogin.java) > at JLogin.pingDatabaseBTN_ActionPerformed(JLogin.java) > at JLogin$SymAction.actionPerformed(JLogin.java) > at java.awt.Button.processActionEvent(Unknown Source) > at java.awt.Button.processEvent(Unknown Source) > at java.awt.Component.dispatchEventImpl(Unknown Source) > at java.awt.Component.dispatchEvent(Unknown Source) > at java.awt.EventQueue.dispatchEvent(Unknown Source) > at java.awt.EventDispatchThread.pumpOneEvent(Unknown Source) > at java.awt.EventDispatchThread.pumpEvents(Unknown Source) > at java.awt.EventDispatchThread.run(Unknown Source) > I have checked all db files belong to user informix and have chmod 777 > just to make sure > > The informix server log is producing this: > > 2000-08-21 20:12:40.710000 sqlexec <UNKNOWN-HOST> vwfecom -X(null) > 2000-08-21 20:13:21.580000 sqlexec <UNKNOWN-HOST> vwfecom -X(null) > > Thanks for your help > > Sent via Deja.com http://www.deja.com/ > Before you buy. > > Sent via Deja.com http://www.deja.com/ Before you buy.