Is your Informix database on the linux machine?
Which user is in the connection statement of your jdbc url?
Does this user have CONNECT permissions in the database you want to connect to?
If you are executing it from a different machine, is your machine trusted?
Can you show me the URL?
I 've done this so many times, this must work!
I am also finding the same problem can you help me if find the solution
I am using suselinux7.3 ,InformixSE5.0 and jdbcdriver(type-4)
after running the jdbc java program to connect database .jdbc driver is getting loaded successfully ,but it gives the exception that can not find the database server.
thanks in advance
Originally posted by tomekz
I use databasepilot (jbuilder - tool) to connect informix database. databasepilot work with jdbcdriver - ifxjdbc.jar.
informix database is suse 7.2 linux machine.
I can't connect to database
java - errormessage:
java.sql.SQLException: Database not found or no system permission.
at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliCon nect.java)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Construc tor.java:274)
at com.informix.jdbc.IfxDriver.connect(IfxDriver.java )
at java.sql.DriverManager.getConnection(DriverManager .java:512)
at java.sql.DriverManager.getConnection(DriverManager .java:171)
at com.borland.dx.sql.dataset.Database.openConnection (Unknown Source)
at com.borland.jdbcx.metadata.DatabaseInfo.openConnec tion(Unknown Source)
at com.borland.jdbcx.metadata.e.run(Unknown Source)
informix on aix machines work without any problems.
It is linux problem?
Informix JDBC Driver supports only the TCP/IP protocol, which means
you can connect to SE database servers only through the "setlitcp" or
"sesoctcp" network protocols. Some platforms, such as Solaris, only
support "setlitcp"; other platforms only support "sesoctcp." Check
your SE database server machine notes to verify the network protocol
supported by your platform.
To use the TCP/IP protocol, you must bring up an SE daemon. First
define an SE database server name in the SQLHOSTS file, specifying
either "setlitcp" or "sesoctcp," as shown in the following example:
myserver_tli setlitcp myhost sqlexec
Assume that in the example, "sqlexec" has a port number of 1525. This
information will be used in a later example.
To bring up the SE tlitcp daemon, execute the following command as
the "root" user:
Use the UNIX "ps" command to check whether the SE daemon has been
B. DATABASE DIRECTORIES
INFORMIX-SE database servers can only read from or write to the
local directories on the computer where the SE daemon was started.
This means, for example, that you cannot create a database on an
NFS-mounted directory on the computer where the SE daemon was started.
By default, when you create a database through Informix JDBC Driver,
the driver asks the SE database server to create the database in your
home directory. This means that your home directory cannot be an NFS-
If you do not want the database to be created in your home directory,
you can specify another directory by using the following syntax
after connecting to the SE database server: