If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Informix & JDBC

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-16-03, 12:11
araujox_guntin araujox_guntin is offline
Registered User
 
Join Date: Jan 2003
Posts: 4
Unhappy Informix & JDBC

I EXECUTE:
java getIfxMetaData website 1533 maq website maq password

I GOT ERROR:

java.sql.SQLException: Database not found or no system permission.
at com.informix.jdbc.IfxSqli.addException(IfxSqli.jav a, Compiled Code)
at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.jav a, Compiled Code)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java , Compiled Code)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.j ava, Compiled Code)
at com.informix.jdbc.IfxSqli.executeOpenDatabase(IfxS qli.java, Compiled Code)
at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliCon nect.java, Compiled Code)
at java.lang.reflect.Constructor.newInstance(Native Method)
at com.informix.jdbc.IfxDriver.connect(IfxDriver.java , Compiled Code)
at java.sql.DriverManager.getConnection(DriverManager .java, Compiled Code)
at java.sql.DriverManager.getConnection(DriverManager .java, Compiled Code)
at getIfxMetaData.main(getIfxMetaData.java, Compiled Code)
################################################## ###############
MY PATH DB:
/apm/habana4/maq.dbs

DAEMON:
sqlexecd website

PLATFORMS:

SCO 5.0.6
Informix-SE 7.1
JDK 1.2.2
JDBC 2.21.JC3

SETING FILES:

HOSTS FILE:

127.0.0.1 localhost
192.168.0.5 website

SQLHOSTS FILE:

demo_on onipcshm on_hostname on_servername
demo_se seipcpip se_hostname sqlexec
website setlitcp website sqlexec

SERVICES FILE:

sqlexec 1533/tcp # Informix SE sqlexec

ENVIRONMENT VARIABLES:

INFORMIXDIR=/usr/informix
INFORMIXSERVER=website
DBPATH=/apm/habana4
PATH=/bin:/etc:/usr/bin:/tcb/bin:$INFORMIXDIR/bin:$INFORMIXDIR/lib
CLASSPATH=$CLASSPATH:/usr/java2/bin:/usr/java2:/usr/jdbc/bin:/usr/jdbc:/usr/jdbc/lib/ifxjdbc.jar:

/usr/java2/lib/tools.jar
PATH=$PATH:/usr/java2:/usr/java2/bin:/usr/jdbc/bin:/usr/jdbc:/usr/jdbc/lib/ifxjdbc.jar

getIfxMetaDAta.java FILE

//************************************************** **********************
// Overview:
// This program is a JAVA application that makes calls to various JDBC
// metadata functions, including
// getDriverName(), getDriverVersion(), getDatabaseProductName(),
// getDatabaseProductVersion(), getTypeInfo(), getStringFunctions(),
// getTableTypes(), getTables()
//
// Software Requirements:
// 1. Informix IDS
// 2. Java Development Kit
// 3. Be sure PATH and CLASSPATH environment variables are set.
// PATH needs to be set to include the bin directory of where JDK is
// installed (eg. d:\jdk1.3.1_02\bin). CLASSPATH should include
// ifxjdbc.jar (eg. d:\informix\jdbc\lib\ifxjdbc.jar).
//
// Instructions:
// 1. javac getIfxMetaData.java
// 2. java getIfxMetaData host port database server user password

import java.sql.*;

class getIfxMetaData
{
static void getDataAbout(Connection conn)
throws SQLException
{
DatabaseMetaData dmd = conn.getMetaData();

// Get product name
String pname = dmd.getDatabaseProductName();
String ver = dmd.getDatabaseProductVersion();

System.out.println("Database Product Name ==> " + pname + " Version "+ver);
System.out.println("");

// Get driver name
String dname = dmd.getDriverName();
String dver = dmd.getDriverVersion();

System.out.println("Driver ==> " + dname + " Version "+dver);
System.out.println("");

// Get description of all datatypes supported by database
// Types Class Definition is java.sql.Types

System.out.println("DBMS Type java.sql.Types");
System.out.println("------------------------- --------------");

ResultSet rs = dmd.getTypeInfo();

for (int i=1; rs.next(); i++) {
String typename = rs.getString("TYPE_NAME");
short dtype = rs.getShort("DATA_TYPE");

int len = typename.length();

StringBuffer stbfr = new StringBuffer(typename);

for( int j = 0 ; j < 50 - len ; j ++ )
stbfr = stbfr.append(" ");

System.out.println(stbfr.toString() + dtype);
}

rs.close();
System.out.println("");

// Gets a list of all database string functions
String s = dmd.getStringFunctions();
System.out.println("String functions: " + s);

System.out.println("");

// Gets a list of all database numeric functions
String n = dmd.getNumericFunctions();
System.out.println("Numeric functions: " + n);

System.out.println("");

// Gets a list of all database Datetime functions
String d = dmd.getTimeDateFunctions();
System.out.println("Datetime functions: " + d);

System.out.println("");

// Get list of tables for each table type supported by database
ResultSet ttypes = dmd.getTableTypes();

String[] ttypes_array = new String[5];
String[] op_array = new String[1];

for (int i=0; ttypes.next(); i++) {
String ttype = ttypes.getString("TABLE_TYPE");
ttypes_array[i] = ttype;
op_array[0] = ttypes_array[i];

ResultSet trs = dmd.getTables(null, null, "%" , op_array );

// get the list of the table objects

System.out.println("List of tables of type - "+ttype);

for (int j=1; trs.next(); j++) {

String tabschema = trs.getString("TABLE_SCHEM");
String tabname = trs.getString("TABLE_NAME");
System.out.println(j+".\t "+tabschema+"."+tabname);
}

System.out.println("");
trs.close();

}

}


public static void main(String argv[])
{
try {
// load driver
Connection con = null;
Class.forName("com.informix.jdbc.IfxDriver").newIn stance();

if (argv.length == 6) {
String hostname = argv[0];
String portnum = argv[1];
String database = argv[2];
String IfxServer = argv[3];
String userid = argv[4];
String passwd = argv[5];

// URL is

"jdbc:informix-sqli://hostnameort-number/dbname:INFORMIXSERVER=server-name;user=userid;password

=passwd;

/* String url = "jdbc:informix-sqli://"
+ hostname + ":"
+ portnum + "/"
+ database +
":INFORMIXSERVER=" +

IfxServer
+ ";user=" + userid +
";password=" + passwd;
*/

String url = "jdbc:informix-direct://maq;user=informix;rmm1243";

// connect with default id/password
con = DriverManager.getConnection(url);
}
else {
System.out.println("\nUsage: java getIfxMetaData host

port database server user password\n");
System.exit(0);
}

// get metadata about database
getDataAbout(con);

con.close();

} catch( Exception e ) {
e.printStackTrace(); }
}
}

// Here is the Types Class Definition in package java.sql;
// public class Types {
// public final static int BIT = -7;
// public final static int TINYINT = -6;
// public final static int SMALLINT = 5;
// public final static int INTEGER = 4;
// public final static int BIGINT = -5;
// public final static int FLOAT = 6;
// public final static int REAL = 7;
// public final static int DOUBLE = 8;
// public final static int NUMERIC = 2;
// public final static int DECIMAL = 3;
// public final static int CHAR = 1;
// public final static int VARCHAR = 12;
// public final static int LONGVARCHAR = -1;
// public final static int DATE = 91;
// public final static int TIME = 92;
// public final static int TIMESTAMP = 93;
// public final static int BINARY = -2;
// public final static int VARBINARY = -3;
// public final static int LONGVARBINARY = -4;
// public final static int NULL = 0;
// public final static int OTHER = 1111;
################################################## ######################################
Reply With Quote
  #2 (permalink)  
Old 01-20-03, 09:16
thedafna thedafna is offline
Registered User
 
Join Date: Oct 2002
Posts: 52
Assuning the connection is ok, you need to grant more powerful permission, It worked for me with DBA

Dafna
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On