Problems using JDBC to connect to SQLBase

comp.databases.gupta (1995-2015)
maciek

Problems using JDBC to connect to SQLBase

Post by maciek » 04 Sep 2006, 09:40

 Posted by:  maciek <lo...@gcm.pl> 

Hi ,

Im using SQLBase Server 6.1.2 and trying to connect using JDBC Drivers
(found on SQLBase CD)
but i get always "00296 DBO IVC Backend code page is not same" error ;(
When i use sqltalk utility it runs without any problems.
Where is the problem? Please help :)

this is my sql.ini
-----------------------------------
[sqlapiw]
country=poland

[winclient]
clientname=CLI_IP16
connecttimeout=5
country=poland

[winclient.dll]
;comdll=sqlwsock
comdll=sqlspxw4

[winclient.nbiow]

[winclient.spxw4]

[winclient.wsock]
serverpath=start,192.0.3.2/,*
[win32client]
;clientname=stat(1148)
clientname=inf_broda
country=poland

[win32client.dll]
;comdll=sqlspx32
comdll=sqlws32
;comdll=sqlwsspx

[win32client.apipe]

[win32client.ntnbi]

[win32client.ws32]
serverpath=kadry,192.0.3.2/xxx,*

[win32client.spx32]

[win32client.wsspx]


[patch.comments]
;
; This section is only used if running the NLM Database Server on a
; NETFRAME machine.
;
[patch]

[sqltalk]
country=poland
-----------------------------------

party of my country.sql
-----------------------------------
[poland]
#whitespace
9 A D 20
#numeric
0 1 2 3 4 5 6 7 8 9
#alpha
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z A5 C6 CA A3 D1
D3 8C AF 8F
a b c d e f g h i j k l m n o p q r s t u v w x y z B9 E6 EA B3 F1
F3 9C BF 9F
#lower
A5 B9
C6 E6
CA EA
A3 B3
D1 F1
D3 F3
8C 9C
AF BF
8F 9F
#upper
B9 A5
E6 C6
EA CA
B3 A3
F1 D1
F3 D3
9C 8C
BF AF
9F 8F
#translate
B9 a{
E6 c{
EA e{
B3 l{
F1 n{
F3 o{
9C s{
BF z{
9F z}
A5 A{
C6 C{
CA E{
A3 L{
D1 N{
D3 O{
8C S{
AF Z{
8F Z}
-----------------------------------

and part of my code

Connection con = null;
try {

Class.forName("com.centurasoft.java.sqlbase.SqlbaseDriver").newInstance();
String s1 = "A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
\A5 \C6 \CA \A3 \D1 \D3 \8C \AF \8F";
String s2 = "a b c d e f g h i j k l m n o p q r s t u v w x y z
\B9 \E6 \EA \B3 \F1 \F3 \9C \BF \9F";
String s3 = s1.concat(s2);

com.centurasoft.java.sqlbase.SqlbaseDriver.SetCountryWhiteSpace("\9
\A \D \20");
com.centurasoft.java.sqlbase.SqlbaseDriver.SetCountryNumeric("0
1 2 3 4 5 6 7 8 9");
com.centurasoft.java.sqlbase.SqlbaseDriver.SetCountryAlpha(s1);
DriverManager.setLogStream(System.out);
con =
DriverManager.getConnection("jdbc:sqlbase://192.0.3.2:2155/rumkat","sysadm","sysadm");
if(!con.isClosed())
System.out.println("Successfully connected to SQLBase");
} catch(Exception e) {
System.out.println("Exception: " + e.getMessage());
} finally {
try {
if(con != null)
con.close();
} catch(SQLException e) {
System.out.println("SQLException: " + e.getMessage());
}
}

full error message is:
DriverManager.getConnection("jdbc:sqlbase://192.0.3.2:2155/rumkat")
trying
driver[className=com.centurasoft.java.sqlbase.SqlbaseDriver,com.centurasoft.java.sqlbase.SqlbaseDriver@19f953d]
java.sql.SQLException: 00296 DBO IVC Backend code page is not same,
check SQL.INI file and country.sql

ODBC Drivers run without problems
but i would like to use JDBC.

Thanks for any comments/solutions
Maciej G.

Return to “comp.databases.gupta”

Who is online

Users browsing this forum: [Ccbot] and 8 guests