Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

JDBC connect ion from script

152 views
Skip to first unread message

Naga

unread,
Aug 2, 2013, 2:19:05 PM8/2/13
to
Hello,

I am trying to connect to db2 database from prolog. Here is my code.

var envconn = system.getConnector("ibmdi.JDBC");
envconn.setParam ("JDBCURL","jdbc:db2://server:port/schema");
envconn.setParam ("JDBCDriver","com.ibm.db2.jcc.DB2Driver");
envconn.setParam ("userName","userid");
envconn.setParam ("password","******");
envconn.setParam ("Schema","schemaname");
envconn.setParam ("tableName","tablename");
task.logmsg("connection successfull ");

var inputConnMode = new Packages.com.ibm.di.server.ConnectorMode("LookUp");
envconn.initialize (inputConnMode);
task.logmsg("connection successfull2 ");

and this is the error i am getting

14:16:09,267 ERROR - CTGDIS118I Script execution failed.
java.lang.Exception: CTGDIJ108E The database ''Schema'' name is not provided.
at com.ibm.di.connector.JDBCConnector.initialize(JDBCConnector.java:305)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.ibm.jscript.types.JavaAccessObject.call(JavaAccessObject.java:298)
at com.ibm.jscript.types.FBSObject.call(FBSObject.java:153)
at com.ibm.jscript.ASTTree.ASTCall.interpret(ASTCall.java:151)
at com.ibm.jscript.ASTTree.ASTProgram.interpretEx(ASTProgram.java:102)
at com.ibm.jscript.JSExpression.interpretExpression(JSExpression.java:399)
at com.ibm.jscript.JSExpression.evaluateValue(JSExpression.java:249)
at com.ibm.jscript.JSExpression.evaluateValue(JSExpression.java:236)
at com.ibm.jscript.JSExpression.evaluateValue(JSExpression.java:239)

as you can see i am setting the schema but it is still giving this error. What am i doing wrong here?

Hydel

unread,
Aug 5, 2013, 7:25:59 AM8/5/13
to
Hello Naga,

try this code:

var envconn = system.getConnector("ibmdi.JDBC");
envconn.setParam ("jdbcSource","jdbc:db2://server:port/schema");
envconn.setParam ("jdbcDriver","com.ibm.db2.jcc.DB2Driver");
envconn.setParam ("jdbcLogin","userid");
envconn.setParam ("jdbcPassword","*******");
envconn.setParam ("jdbcSchema","schemaname");
envconn.setParam ("jdbcTable","tablename");
task.logmsg("connection successfull");

// Use null to initialize the call instead of mode setting
envconn.initialize (null);
task.logmsg("connection successfull2 ");

Hydel

unread,
Aug 5, 2013, 7:29:04 AM8/5/13
to
Oops, this shoud be:
envconn.setParam ("jdbcSource","jdbc:db2://server:port/database"); <--- database, not schema!
0 new messages