I want to connect to progress using jdbc
i have added Jdbc driver for 10.1B openedge.jar.in the classpath:
also following jars added in the classpath:
Progress\OpenEdge\java\util.jar
Progress\OpenEdge\\java\base.jar
Progress\OpenEdge\\java\pool.jar
Progress\OpenEdge\\java\spy.jar
Progress\OpenEdge\\java\ prosp.jar
when i run sqlexp
D:\Progress\OpenEdge\bin>sqlexp jdbc:datadirect
penedge://161.89.116.165:20931;databaseName=cvs1;User=A;password=
it didnt give any problem
but for simple following jdbc connection program i am getting exception
url ="jdbc:datadirect
penedge://161.89.116.165:20931;databaseName=cvs1; try {
Class.forName("com.ddtek.jdbc.openedge.OpenEdgeDriver").newInstance();
final java.sql.Connection con = DriverManager.getConnection(url);
Exception
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver]A server crash is likely.
at com.ddtek.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.ddtek.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.headerSwapOut(Un
known Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientLoginRequest.preOpenConn
ection(Unknown Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientLoginRequest.preSubmitRe
quest(Unknown Source)
at com.ddtek.jdbc.openedge.OpenEdgeImplConnection.open(Unknown Source)
at com.ddtek.jdbc.base.BaseConnection.connect(Unknown Source)
at com.ddtek.jdbc.base.BaseConnection.setupImplConnection(Unknown Source
)
at com.ddtek.jdbc.base.BaseConnection.open(Unknown Source)
at com.ddtek.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at ProgressJdbc.main(ProgressJdbc.java:19)
Please let me know if i am doing anything wrong
Thanks,
Prasad
i have added Jdbc driver for 10.1B openedge.jar.in the classpath:
also following jars added in the classpath:
Progress\OpenEdge\java\util.jar
Progress\OpenEdge\\java\base.jar
Progress\OpenEdge\\java\pool.jar
Progress\OpenEdge\\java\spy.jar
Progress\OpenEdge\\java\ prosp.jar
when i run sqlexp
D:\Progress\OpenEdge\bin>sqlexp jdbc:datadirect
it didnt give any problem
but for simple following jdbc connection program i am getting exception
url ="jdbc:datadirect
Class.forName("com.ddtek.jdbc.openedge.OpenEdgeDriver").newInstance();
final java.sql.Connection con = DriverManager.getConnection(url);
Exception
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver]A server crash is likely.
at com.ddtek.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.ddtek.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.headerSwapOut(Un
known Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientLoginRequest.preOpenConn
ection(Unknown Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientLoginRequest.preSubmitRe
quest(Unknown Source)
at com.ddtek.jdbc.openedge.OpenEdgeImplConnection.open(Unknown Source)
at com.ddtek.jdbc.base.BaseConnection.connect(Unknown Source)
at com.ddtek.jdbc.base.BaseConnection.setupImplConnection(Unknown Source
)
at com.ddtek.jdbc.base.BaseConnection.open(Unknown Source)
at com.ddtek.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at ProgressJdbc.main(ProgressJdbc.java:19)
Please let me know if i am doing anything wrong
Thanks,
Prasad